Duration
Powerful Data Analytics & Visualization with Power BI
2 days
INTRODUCTION
Access the information you need when you need it through visually stunning dashboards and reports. Learn how to analyze and display data using Power BI and make better, more data-driven decisions.
COURSE OBJECTIVES
By the end of this course you will be able to:
1 How to use Microsoft Power Query
2 How to use Power Pivot in Excel
3 Understand the Power Business Intelligence (BI)
4 Combine multiple data sources into one dataset.
5 Build interactive reports.
6 Perform forecasting & What-If analysis
7 Connect the data to the dashboard, BI tool, or data warehouse of your choice
METHODOLOGY
Case Study & Group Discussion. Current financial & business cases will be analyzed, and scenario solutions will be discussed within the workshop.
WHO SHOULD ATTEND?
Entrepreneurs, Bankers, Accountants, CFO, CEO, Business Managers, Marketing Managers, Supervisors, and
Managers, Hr managers, Department heads & Operation heads.
Day 1
9:00am-10:30am
Module1: Creating Interactive Excel Dashboard
From data set to pivot table
Pivot table to charts.
From charts to dashboard
Course Outline :: Powerful Data Analytics & Visualization with Power BI::
Interactive dashboard
Module 2: Getting started
Introducing Power BI
A quick look at Power BI Desktop
A quick look at the Power BI service
Setting up Power BI Environment
10:30am-10:45pm Morning Break
10:45pm-12:30pm
Module 3: Getting Data
Available data sources in Power BI Desktop
Connecting to data sources
Get Data from Folder o Handling multiple worksheets
Get Data from CSV file
Module 4: Application of Power BI (case study)
Sales performance
Web application
Profit by date
Unit Sold by Each Country/states
Profit by product
12:30pm-1:30pm Lunch
1:30pm-3:30pm
Module 5: Shaping and Transforming Data
Introduction to the Query Editor
Clean and transform your data with the Query Editor.
Cleaning irregularly formatted data
Data categorization
Relationship view
3:30pm-3:45pm Afternoon Break
3:45pm-5:00pm
Module 6: How to use Microsoft Power Query
How to get Power Query
Transform data
Applied steps
Course Outline :: Powerful Data Analytics & Visualization with Power BI::
Add Column
Insert pivot table & chart
Importing additional data
Day 2
9:00am-10:30am
Module 7: Modelling- DAX -Data Analysis expressions
Introduction to modelling your data.
Optimizing data models
Introduction to DAX [Calculation Types / Functions]
Create calculated columns.
Create calculated measures.
Create calculated tables.
Create calendar date
Module 8: DAX -Data Analysis expressions (case study)
How many products we sales in all the different orders?
How many orders we have?
Calculate the profit for the company
Calculate the profit margin % for the company
DAX Formulas- time & date, Find, If, Calculate function
10:30am-10:45pm Morning Break
10:45pm-12:30pm
Module 9: Power Pivot in Excel
Download Power Pivot
Create a data model
Define Relationship
Add Column
Measure
Chart
KPI
Visual/charts
Power of insights
12:30pm-1:30pm Lunch
1:30pm-3:30pm
Course Outline :: Powerful Data Analytics & Visualization with Power BI::
Module 10: Visualizations
KPI
Line chart
Line & Clustered Column Chart
Cluster Bar Chart
Map
Q&A
Stacked column chart
Slicer
Decomposition Tree
Introduction to visuals in Power BI
3:30pm-3:45pm Afternoon Break
3:45pm-5:00pm
Module 11: Publishing
Home
Publish
Success
Headline
Region
Decomposition tree
Export- PPT, PDF
Focus mode
Filter further
Introduction to the Power BI service
Module 12: Sharing
Share report (Power BI pro user)
Upgrade to Power Bi Pro
Not Now
Send link
People with existing access
Programme scope, delivery arrangements and suitability are confirmed during enquiry.