Mastering Data Visualization With Power BI

Prequisites

Must have basic knowledge on Excel PivotTable (If not, please attend Excel Advanced Course).

Learning Outcomes / Benefits

After completing this course, students will be able to:

• Describe self-service BI.
• Describe the Power BI suite of products.
• Connect to data sources and optimize data models.
• Shape and combine data from different sources.
• Model data.
• Create reports and manage solutions.

Key Content

Module 1: Understanding Business Intelligence

• Why is Data Analytics Important?
• What is Business Intelligence (BI)?
• What is Self-Service BI?

Module 2: Understanding Power BI

• Power BI (Desktop vs Mobile vs Service)
• Licences (Free vs Pro vs Premium)
• Frequent Updates and Changes
• BI Steps in Power BI

Module 3: Getting Data in Power BI

• Understanding Power BI Navigation
• Exploring Different Data Sources in Power BI
• Getting Data from the web
• Get data from files for Power BI

Module 4: Data Transformation

• What is Power Query and Data Transformation?
• Navigating Power Query Editor
• Renaming Columns and Changing Data Types
• Duplicating Columns
• Splitting and Merging Columns
• Change Cases, Trimming and Cleaning

Module 5: Data Modelling

• Understanding the navigation of the model view
• What is Data Modelling?
• What is a Unique Identifier?
• Creating a New and Editing a Relationship

Module 6: Introduction to DAX

• What is DAX?
• Why is DAX so important?
• DAX Prerequisites
• What are Calculated Columns and Measures?
• Calculating a column using DAX
• Calculating a Measure using DAX

Module 7: Data Visualization

• Understand the navigation of the Report View
• Creating Reports
• Understanding Pages
• Understanding Fields
• Understanding Visualization
• Creating Visualization
• Formatting Visualization

Module 8: Exploring Filters

• Cross Filtering through Visuals
• Creating Slicer
• Understanding Page and Report Level Filter

Module 9: Power BI Service

• Navigation with Power BI Service
• Navigating Reports
• Add Live Power BI Report to PowerPoint

Target Audience

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.