Data visualization with Microsoft Power BI
Duration: 3 Days
Course Overview
This three-day, comprehensive, fast-paced training course presents Data visualization with Microsoft Power BI from Microsoft that gathers and processes your data, analyzes and provides data driven insights that enables managers, business analysts and key decision makers to make informed decisions real time. It allows one to ask questions and get answers about their data. Users of Power BI are able to create interactive dashboards and insights by self-interacting with the technology. This 3-days comprehensive training course will take the participants through the key features of Power BI, including data modeling, creating visualizations, and publishing reports. They will learn how to connect to various data sources, create stunning visualizations, and share insights with others in their organization.
Course Objectives:
Gain a solid understanding of Power BI, including data modeling, data loading, and report creation.
Learn how to import, transform, and clean data from various sources to make it suitable for analysis.
Master the creation of visually compelling and interactive reports and dashboards using Power BI’s extensive range of visuals.
Acquire the skills to write Data Analysis Expressions (DAX) formulas for advanced calculations, measures, and custom columns.
Understand how to connect and merge data from multiple sources, creating comprehensive datasets for analysis.
Apply Power BI to real-world scenarios, such as sales analysis, financial reporting, and performance tracking.
Learn how to publish and share reports securely within your organization and collaborate on data-driven insights.
Explore best practices for ensuring data security and governance in Power BI.
Course Outline
Introduction to Power BI
Components of Power BI
Features of Power BI
Power BI workflows
Self Service ETL (Extract Transform Load)
Setup and Configuration of Power BI
Connecting to Data Sources
Excel
Online sources (Google Sheet, Kobo Toolbox, ONA, Survey CTO, DHIS)
Databases (PostgreSQL, MySQL, Microsoft SQL Server)
Data Transformation: Data Management and Data Cleaning Processes in Power BI (Power Query)
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
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
DAX Functions
Aggregate Functions
Date and Time Functions
Time Intelligence Functions
Filter Functions
Relationship/Navigation Functions
Logical Functions
Text Functions
Visualization and Charts (Power View)
Stacked Bar chart and Stacked Column chart
Clustered Bar chart and Clustered Column chart
Line char t & 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
Building and Sharing a Dashboard
Workspace
Datasets
Reports
Create Dashboard
Modify and update Dashboard
Share your Dashboard
Power Q&A and Insights
Data Security in Power BI
Configuring Row level security
Setting up user roles
Publishing and Sharing
Sharing Options Overview
Publish from Power BI Desktop
Publish to Web
Share Dashboard with Power BI Service
Workspaces and Apps (Power BI Pro)
Content Packs (Power BI Pro)
Print or Save as PDF
Row Level Security (Power BI Pro)
Export Data from a Visualization
Publishing for Mobile Apps
Export to PowerPoint
Configuring Data Refresh
Types of Data refresh (Package Refresh, Model/Data refresh, Tile Refresh, Visual/Container Refresh)
Understand & Configure Data Management Gateways
Configuring & scheduling Data refresh
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
Training Approach
This Microsoft Power BI course is delivered by our seasoned trainers who have vast experience as expert professionals in Microsoft Power BI software. The course is taught through a mix of practical activities, theory, group works and case studies.
Training manuals and additional reference materials are provided to the participants.
Course Prerequisites:
Basic Data Analysis Knowledge
Understanding Data Sources
Basic Excel Skills
Basic Database Concepts
Certification
Upon successful completion of this course, participants will be issued with a certificate.
Audience:
This course is suitable for professionals in various fields, including:
Business Analysts
Data Analysts
Managers and Executives
IT Professionals
Sales and Marketing Professionals
Students and Researchers
By the end of this course, participants will have the skills and knowledge necessary to use Data Visualization with Microsoft Power BI for professional data analysis and reporting, enabling them to create insightful reports, dashboards, and data-driven solutions for their organizations.