This 2-day practical workshop is aimed at equipping participants with the fundamentals of using Power BI Desktop as well as the applied skills required to enable them to communicate insights in the form of BI reports to make the right business decisions.
Learning Outcome
By the end of this workshop, participants will be able to:
Understand what data visualization is and its importance to data analytics
Learn about the types of data analytics Understand the data analytics cycle and iteration
Apply data visualization techniques and dashboard Equip with skills to create scorecards, KPIs and gauge charts
Create DAX formulas and functions for enhance visualization
Apply advanced visualization techniques for stakeholder engagement
Who Should Attend
This course would be suitable for any working professionals who are interested to advance their knowledge in using Power BI Desktop and its applications for their businesses.
Course Outlines
Topic 1. What Is Data Visualisation
Purpose of data visualization
Why is data visualization important?
4 types of data analytics
The data analytics cycle
Topic 2. Navigating through Power
BI Desktop and Data Models
Navigating through Power BI
Understanding data formats and types
Data Transformation in Power Query Editor
Creating Relationships between Tables
Create Basic Visualization
Topic 3. Setup and Data Visualization Techniques with Visual Filters and Power Query
Setting up Page Size and Tools
Using Visual Filters
Applying Advance Slicer Techniques
Calculated Column
Create Measures Table
Calculated Measure
Topic 4. Creating Scorecards, KPIs and Gauge Charts and DAX Formulas
Create DAX Formulas
Aggregation and Iteration Functions
Using SUM, CALCULATE, FILTER Functions
SUMX Function
AVERAGE and AVERAGEX Functions
Using COUNT and COUNTROWS Functions
DISTINCTCOUNT Function
MAX and MIN Functions
DIVIDE Function
FILTER Function
ALL Function
ALLEXCEPT Function
Using Score Cards
Using Key Performance Indicators (KPIs)
Using Gauge Charts
Topic 5. Publishing Dashboards on Analysis Services
Power BI Analysis Services
Using the Publish Feature
Creating Reports on Workplace
Creating Dashboards
Topic 6. Techniques to Provide Context and Details to Data and Using Predictive Analytics