Skill Up Card - Course Bundles

Pricing is per delegate, giving you huge savings over the cost of individual courses.

  • UK = £2,000 + VAT per Skill Up Card
  • Ireland = €2,400 per Skill Up Card
skill up card logo - Nexus Human

Quick Start to Power BI for Anlaysts & Users / Introduction to Power BI (TTDPB01)

4.6 out of 5 rating

Jump to dates

Duration

2 Days

12 CPD hours

About this course

This hands-on course is geared new users and analysts or individuals who might be responsible for accessing the organization's data, transforming that data and generating reports.

Overview

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, students will learn how to:
-Perform Power BI desktop data transformation.
-Describe Power BI desktop modelling.
-Create a Power BI desktop visualization.
-Implement the Power BI service.
-Describe how to connect to Excel data.
-Shape and Combine Data
-Describe how to collaborate with Power BI data.
-Connect directly to data stores.
-Time Permitting: Explore the Power BI developer API.
-Time Permitting: Describe the Power BI mobile app

Description

QuickStart to Power BI for Analysts and Users is a two-day introductory-level course that provides attendees with a hands-on exploration of the essential features and benefits of Power BI, as well as a targeted hands-on jump start to performing data analysis with Power BI. This course will provide you with the job-ready skills required to make you productive in your role with basic Power BI features and functionality, right after the training ends.

Prerequisites

Before attending this course, students should have:
-A general knowledge of database concepts (fields, records, relationships).
-An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
-Familiarity with Excel.

Module 1: Introduction to Self-Service BI Solutions

Introduces business intelligence (BI) and how to self-serve with BI.

Topics

Introduction to business intelligence
Introduction to data analysis
Introduction to data visualization
Overview of self-service BI
Considerations for self-service BI
Microsoft tools for self-service BI
Hands-on: Exploring an Enterprise BI solution
Viewing reports
Creating a Power BI report
Creating a Power BI dashboard
Module 2: Introducing Power BI

This module introduces Power BI desktop, and explores the features that enable the rapid creation and publication of sophisticated data visualizations.

Topics

Power BI
The Power BI service
Hands-on: Creating a Power BI dashboard
Connecting to Power BI data
Create a Power BI dashboard
Module 3: Power BI Essentials

At the end of this module students will be able to explain the rationale and advantages of using Power BI.

Topics

Using Excel as a data source for Power BI
The Power BI data model
Using databases as a data source for Power BI
The Power BI service
Hands-on: Importing data into Power BI
Importing Excel files into Power BI
Viewing reports from Excel files
Module 4: Shaping and Combining Data

With Power BI desktop you can shape and combine data with powerful, built-in tools. This module introduces the tools that are available for preparing your data and transforming it into a form ready for reporting.

Topics

Power BI desktop queries
Shaping data
Combining data
Hands-on: Shaping and combining data
Shape power BI data
Combine Power BI data
Module 5: Modelling data

This module describes how to shape and enhance data.

Topics

Relationships
DAX queries
Calculations and measures
What is DAX (Overview)
What is DAX (Tabular)
Creating Calculated Columns (Basics)
Conditional and Logical Functions
Creating Calculated Measures
Time Intelligence (Overview)
Time Intelligence (Time Intelligence Functions)
Using X-Functions and A-Functions
DAX as a Query Language
Hands-on: Let's Model Data
Module 6: Interactive Data Visualizations

This module describes how to create and manage interactive data visualizations.

Topics

Creating Power BI Reports
Page Layout and Formatting
Working with Multiple Visualizations
Creating Charts
Histograms
Managing a Power BI Solution
Power BI Service Settings
Power BI Desktop Settings
Module 7: Direct Connectivity

Cloud Data
Connecting to Big Data
Connecting to Analysis Services
Direct Connectivity to Analysis Services
Using the On-Premises Gateway
SSAS Multidimensional Models
Bonus Topics / Time Permitting

This content will be included with your course materials, and will be addressed in class if time permits.

Module 8: The Developer API

The Developer API
The Interactive API Console
Custom Visuals
Using Custom Visuals
Using the Developer API
Module 9: PowerBI Mobile

Power BI Mobile Apps
Creating Dashboards for Mobile Devices
Power BI for iOS and Android
Power BI for Windows 10
Using the Power BI Mobile App
Annotating Dashboards
Power BI Embedded
Adding Visualizations to an App
Power BI Community
Additional course details:

Nexus Humans Quick Start to Power BI for Anlaysts & Users / Introduction to Power BI (TTDPB01) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the ITS Data Analytics course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable. To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.

What people say about us


Global Schedule

GTR = Guarenteed to Run

13 Jan 25 Enquire Book
15:00 - 23:00Live Online1,695
03 Mar 25 Enquire Book
15:00 - 23:00Live Online1,695

22 Apr 25 Enquire Book
15:00 - 23:00Live Online1,695
09 Jun 25 Enquire Book
15:00 - 23:00Live Online1,695
28 Jul 25 Enquire Book
15:00 - 23:00Live Online1,695
15 Sep 25 Enquire Book
15:00 - 23:00Live Online1,695
27 Oct 25 Enquire Book
14:00 - 22:00Live Online1,695
08 Dec 25 Enquire Book
15:00 - 23:00Live Online1,695

Find out more about this course

Interested in alternative dates? Would like to book a private session of this course for your company? Or for any other queries please simply fill out the form below.