Power BI Essentials – Advanced

Introduction to Data Visualisation

• Introduction to Data Analysis

Introduction to Power BI

• What is Power BI?
• Understanding Business Intelligence (BI)
• Getting started with Power BI
• Overview of the components of Power BI:-
• Power BI Service
• Power BI Report Server
• Power Query
• Data Modelling

Power BI Desktop

• Lets examine Power BI Desktop
• Basic concepts of Power BI
• Using Power BI to get data
• Types of Microsoft Power BI data sources
• Working with common data Sources: CSV, Excel, Text files
• Connecting to CSV files
• Connecting to databases: Microsoft Access, SQL Server
• Connecting to Google Analytics, Salesforce, Facebook
• Connecting to One Drive, Office 365 and other cloud services

Cleaning, Transforming and shaping your data

• Common Query Tasks in Power BI
• Exploring the Power BI Query Editor
• Utilising Power Query for data import
• Using Variables under Queries
• Error Handing in Queries
• Shape and Cleanse your data
• Appending and Merging Data from different data sources
• Overview of data transformations
• Unpivot
• Split Columns
• Extract
• Group

Data Modelling within Power BI

• What is a data model?
• Overview of the relationships between the tables
• Create and manage relationships in Power BI Designer
• Cross Filter Direction
• Calculated Columns in Power BI Designer
• Measures in Power BI Designer
• Data Types in Power BI
• Sort by Columns in Power BI Designer

Power BI Reports

• Creating a Power BI Reports
• Saving a Power BI Report
• Uploading Power BI Designer files
• Difference between Report and Dashboards
• Creating Charts
• Gauge and Ribbon Charts
• Custom Visuals

Power BI Service

• Overview of the Power BI Service
• Gateways
• Workspaces
• Content Packs and Apps
• Security
• Power BI Premium

Refreshing Data in Power BI

• Data sources that support refresh in Power BI
• Setting up a refresh schedule
• Power BI features in Tablets and Mobile
• Accessing your report & dashboards from Mobile

Setting up Data driven alerts

• Using Annotations

Data Modelling within PowerBI

• Create and manage relationships in Power BI Designer
• Calculated Columns in Power BI Designer
• Measures in Power BI Designer
• Data Types in Power BI
• Sort by Columns in Power BI Designer

Visualisation types in Power BI

• Creating a column chart
• Creating Bar, Line, Area and Pie Charts
• Creating a scatter chart
• Histograms
• Optimising Geographic data

Power BI Dashboards

• Prepare your dashboard layout
• Creating a dashboard
• Sharing a dashboard
• Publishing Reports
• Creating a Power BI App
• Create and manage a content pack
• Power BI Mobile apps

Working with Natural Language using Q & A

• How to ask questions in Power BI Q & A
• Preparing a workbook for Q & A

Size limit in Power BI

• Limitation of the free Power BI subscription

DAX in the World of Excel

• Cells vs Tables

Introducing DAX

• Understanding DAX calculations
• DAX data types
• DAX operators
• Calculated Columns vs Measures
• Variables
• Error handing in DAX
• Formatting DAX Code
• Common DAX Functions

Basic Table Functions

• What are Table Functions
• Evaluate Syntax
• Table Expressions
• Understanding FILTER
• Understanding ALL, ALLEXCEPT and ALLNOBLANKROW
• Understanding VALUES AND DISTINCT

Introduction to Evaluation Contexts

• Understanding the row context
• Using SUM in a calculated column
• Using columns in a measure
• Row context with Iterators – EARLIER function
• Working with many tables
• Row contexts and relationships
• Filter context with relationships
• Introducing Values
• Introducing ISFILTERED, ISCROSSFILTERED
• Evaluate Syntax
• Table Expressions
• Understanding FILTER
• Understanding ALL, ALLEXCEPT and ALLNOBLANKROW
• Understanding VALUES AND DISTINCT

Calculate and Calculate Table

• Understanding Calculate
• Understanding the filter contextt
• Calculate examples
• Filtering a single column
• Filtering with complex conditions
• Using Calculate Table
• What are circular dependencies
• Calculate rules
• Introducing All Selected
• Understanding Userelationship

Dax Examples

• Finding ratios and percentages
• Cumulative Totals
• Using ABC (Pareto) Classification
• Finding Sales per day and Working day
• Differences in working days
• Static moving averages

Time Intelligence Calculations

• What is time intelligence?
• Building a Date table
• Handling multiple relationships to the Date table
• Aggregating overtime (Year-to-date|Quarter-to-date)
• Opening and Closing Balances

The Global admin role

• The Power BI service admin role
• Key aspects of Power BI administration

Power BI licensing

• Automating license assignment

Securing Power BI

• Azure AD Conditional Access policies
• Restricting access based on network location
• Restricting access based on device Using multi-factor authentication
• Tracking risky sign-ins

Automating Reports and Dashboards

• Listing reports and dashboards
• Exporting reports
• Copying reports
• Creating reports and dashboards
• Copying tiles

Automating Workspaces

• Listing workspaces and their contents
• Creating workspaces
• Adding and removing users

Conclusion

• Summary