Power BI Essentials – Advanced

Bring your data to life
Approved by Habanero Data
Power BI
next available:
March 15, 2021
Duration :
5 Day/s
DURATION
5 Day/s
USD $
900
USD
$ 900
NGN ₦
400,000
NGN
₦ 400,000

Course Information

Everything you need to know

  • Course Syllabus
  • Your trainer
  • Key Information

About this course: Our 5-day online advanced course is designed for those who have some knowledge of Power BI and would like to examine DAX (Data Analysis Expressions) and data modelling further. On the course we deliver practical exercises demonstrating the features of this data visualisation tool. On completion of the course participants will be able to confidently produce visualisations in dashboards and reports. This hands on course is ideal for beginners.

Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the 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

Course Syllabus:

Day 1

The world of Self-Service Business Intelligence

  • 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

 

Day 2

Data Alerts

  • 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

 

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

 

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
  • 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

 

Power BI Administration

  • 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

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

I – Laptops will be provided for all candidates with pre-installed Microsoft PowerBI.

II – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of a place on the course).

III – Lunches and refreshments are provided inclusive of the cost. Wi-fi and access to spaces to take private calls are also available.

For more information on our training, please enquire using the form above or call +2348103382376

Power BI Essentials – Advanced

Contact Our Team Today!








    What's Included

    Find out what’s included in the training programme.
    COURSE MANUALS
    REFRESHMENTS
    INSTRUCTOR

    Delivery Options

    Everything you need to know

    CLASS ROOM TRAINING
    ONLINE TRAINING
    ONSITE TRAINING

    Course Schedule

    Find out the next available dates

    Power BI Essentials – Advanced

    Available Dates

    Available Places

    Book or Enquire

    June 7, 2021

    Abuja, Accra, Addis Ababa, Freetown, Kigali, Lagos, Nairobi

    We are happy to help

    Call our team today on +2348103382376 or email training@habanerodata.net

    We’re here to discuss your needs with a free consultation and to offer guidance on the best route forward for you or your team. We’re proud of our expert data courses and consultancy services, and we’re always happy to talk about them.