Training Course on Data Analysis and Visualization using Microsoft Power BI

Course Overview

The Data Analysis and Visualization using Microsoft Power BI course is designed to introduce participants to Microsoft Power BI, from the basics of operating the tools, through to advanced data analysis and visualization techniques. Participants will have a comprehensive understanding of Microsoft Power BI for data analysis and visualization, enabling them to create compelling reports and dashboards for effective decision-making.

Target Audience
This is an introductory-level course suitable for professionals seeking to leverage Microsoft Power BI for comprehensive data analysis and visualization. Prior familiarity with data concepts and analysis tools is recommended to maximize learning and application during the course.

Course Objectives:

At the end of this Data Analysis and Visualization using Microsoft Power BI training course participants will be able to:

• Understand the core concepts and components of Power BI.
• Connect to different data sources and import data into Power BI.
• Perform data transformation and data shaping tasks.
• Create interactive and visually appealing reports and dashboards.
• Apply advanced analytics techniques using DAX (Data Analysis Expressions).
• Collaborate and share insights with others in the organization.
• Implement data governance and security measures within Power BI.

Requirements

• Microsoft Power BI Desktop
• This course is designed for PC/Windows users (currently not available for Mac)

Course Duration

Online training: 5 days (3-4hrs a day)

Classroom training: 5 days (7hrs a day)

Course Outline

Module 1: Introduction to Power BI and Data Sources

• Components of Power BI
• Features of Power BI
• Power BI workflow
• Self-Service ETL (Extract Transform Load)
• Setup and Configuration of Power BI
• Excel
• Online sources (Google Sheets, Kobo Toolbox, ONA, SurveyCTO, DHIS)
• Databases (PostgreSQL, MySQL, Microsoft SQL Server)

Module2: Data Transformation and Cleaning

• Using first Rows as Headers
• Rename fields & Replacing data values in cells, rows
• Changing data types & Change order of columns
• Un-pivoting Columns
• Grouping and splitting column into multiple
• Extract feature (before /after delimiter)
• Adding new columns
• Filters and Parameters
• View Native Queries vs Unfold Queries

Module 3: Modelling and Table Relationship

• Table relationship (One to One, One to many, Many to many)
• Introduction to Data Analysis Expression (DAX)
• Measures and calculated Column
• Row Context Vs Filter Context

Module 4: DAX Functions

• Aggregate Functions
• Date and Time Functions
• Time Intelligence Functions
• Filter Functions
• Relationship/Navigation Functions
• Logical Functions
• Text Functions

Module 5: Visualization and Charts (Power View)

• Stacked Bar chart and Stacked Column chart
• Clustered Bar chart and Clustered Column chart
• Line chart & Area Chart
• Line and Clustered Column Chart
• Line and Stacked Column Chart
• Ribbon & Waterfall chart
• Funnel & Tree Map visuals
• Pie chart and doughnut Chart
• Table chart and Matrix Chart
• Slicer, Gauge, Card visuals
• Map and Filled map
• KPI
• Q &A visual
• Fine tune your visualization using Parameters and Slicers
• Deciding on when to use a particular visual

Module 6: Building and Sharing a Dashboard

• Workspace
• Datasets
• Reports
• Create Dashboard
• Modify and update Dashboard
• Share your Dashboard
• Power Q&A and Insights
• Configuring Row level security
• Setting up user roles

Module 7: Power BI for Mobile

• Configuring Power BI for Mobile
• Visualize dashboards and report on Power BI Mobile
• Commenting on reports and dashboards in Power BI Mobile
• Excel Power BI
• Power Query and Power Pivot on Excel
• Visualize and Edit Power BI reports using excel analyzer
• Building reports on Excel and Publishing to Power BI service

Note: This course outline provides a general structure for a 5-day training program on Data Analysis and Visualization using Microsoft Power BI. The specific content, activities, and duration of each session may be adjusted based on the target audience, learning objectives, and available time.