Power BI: Take your Data to the Next Level

Discover how you can use Power BI to help your organization to become more data driven. Whether you are new to analytics or have been stuck preparing and delivering data using legacy BI tools, this workshop will show you how to use Microsoft Power BI with confidence.

You will learn ways to import data from various sources as well as how to transform and cleanse data prior to loading it to a report-ready, self-service-enabled data model. You will create visualizations in the Power BI Desktop and then secure, share, and collaborate using the various features in the Power BI service.

The workshop will help you build good habits and develop your career as a business analyst or data-driven business user.

Course Objective:

• Understand Business Intelligence and self-service analytics
• Explore the tools and features of Microsoft Power BI
• Create and format effective data visualizations
• Incorporate advanced interactivity and custom graphics
• Build and populate accurate data models
• Transform data using the Power BI Query Editor
• Work with measures, calculated columns, and tabular models
• Write powerful DAX language scripts
• Share content on the Power BI Service

Course Modules:

Day One: Power BI

Topic 1: Understanding the Basics
01 What is Business Intelligence?
02 Power BI Architecture and its Ecosystem
03 Self-Service Analytics
04 Power BI Licensing

Topic 2: Connect and Shape (Data Sources)
04 Power BI Desktop
05 Data Connections in Power BI
06 Loading Data from Excel
07 Loading Data from CSV files
08 Loading Data from SQL Server

Topic 3: Optimizing Your Data Model
09 Introduction to Data Modeling
10 Best Practices of Data Modeling
11 About Relationships
12 Practical Examples

Topic 4: Power Query (Data Transformation)
13 What is Power Query?
14 Power BI Query Editor
15 Reshaping Your Data
16 The M language

Topic 5: Using Power BI Visualisations
17 Interacting with a Power BI Report
18 Preparing the Environment
19 Changing Data with Slicers and Filters
20 Buttons
21 Bookmarks

Topic 6: Using the Power BI Service
21 Introduction
22 The Navigation Pane
23 Workspaces
24 Reports and Dashboards
25 Datasets and Data flows

Day Two: Power BI

Topic 1: Visualisation Formatting
01 Charts
02 Tables and Matrix
03 Card and Multi-Row Card
04 Pie Chart ad Donut Charts
05 KPI
06 Themes

Topic 2: Advanced Interactivity and Custom Visualisations
07 Controlling Interactivity
08 Synchronizing Slicers
09 Custom Tooltips
10 Selection Pane
11 Custom Visualisations from the Marketplace
12 Custom Visualisations from Open-Source Software

Topic 3: Creating a Tabular Model in Power BI
13 Relationships
14 User-Friendly Models
15 Hiding Columns from the End-User
16 Formatting and Categories

Topic 4: Measures and Calculated Columns
20 Introduction to the DAX Language
21 Calculated Columns
22 Measures
23 Measures and Context
24 Time Intelligence
25 The FILTER () Function
26 Using RETURN in a Measure

Topic 5: DAX Language Reference
27 DAX Operators
28 Comparison Operators
29 Arithmetic Operators
30 Aggregate Functions
31 DAX functions for Time Analytics

Topic 6: Sharing Content
32 The Power BI Service
33 Scheduling Refresh
23 Hosting Power BI on a Website