top of page
Blue Background

Data visualization with Microsoft Power BI

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

Please book for a short meeting. https://meet.brevo.com/xelware

bottom of page