Power BI Essentials - Advanced

This 5 day course will give delegates a thorough introduction with practical exercises to using the Microsoft Power BI and DAX (Data Analysis Expressions). This hands on course is ideal for beginners.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of Microsoft Power BI.

Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 5 Days, 40 Academic Hours

Day 1

Getting started with Microsoft Power BI

• What is Power BI
• Understanding BI
• Understanding Microsoft Power BI

​Power BI Designer

• Basic concepts of Power BI
• Using Microsoft Power BI to get data
• Types of Microsoft Power BI Datasources
• Connecting to Data Sources
• Merging Queries

Power BI Reports

• Creating Power BI Reports
• Saving a Power BI Report
• Uploading Power BI Designer files
• Difference between Report and Dashboards

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 and dashboards from Mobile 

Data Alerts

• Setting up Data driven alerts
• Using Annotations

​​Day 2

Transforming and shape your Data

• Query Overview in Power BI Designer
• Shape and Combine Data in Power BI Designer
• Common Query Tasks in Power BI
• Using Variables under Queries
• Error Handing in Queries

Data Modelling within Power BI

• 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 and Pie Charts
• Creating a scatter chart

Power BI Dashboards

• Creating a dashboard
• Sharing a dashboard

Working with Natural Language using Q and A

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

​​Size limit in Power BI

• Limitation of the free Power BI subscription

Day 3

What is DAX (Data Analysis Expressions)?

• 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

Understanding Evaluation Contexts

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

Day 4
Understanding Evaluation Contexts

• 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

CALCULATE and CALCULATE TABLE

• Understanding CALCULATE
• Understanding the filter context
• CALCULATE examples
• Filtering a single column
• Filtering with complex conditions
• Using CALCULATETABLE
• What are circular dependencies
• CALCULATE rules
• Introducing ALLSELECTED
• 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

Day 5

Power BI Administration

Overview

• 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

Duration: 5 Days

Timeline and Delivery:

Our training courses are meticulously planned by Habanero Data Solutions and are designed in a manner geared towards maximum of efficiency. Your time is valuable and so is ours, so our goal is best to prepare you while taking up the least amount of your time possible.

Microsoft Power BI training will be conducted by one of our trainers dependent on the selected training option. Daily Training lasts from 9am until 5pm.

Your Trainer:

Our Microsoft certified trainers are highly experienced Power BI practitioners who have real world expertise.

Fee:

• Power BI training fee is paid per delegate. This fee includes refreshments and food.
• The fee includes certificates for participants.
• The payment shall be made within 7 days of receiving the invoice.
• We look forward to working with you to achieve your development needs and do feel free to let us know how we can work with your objectives