Dashboard and Data Analysis with Microsoft Power BI

Facilitator:
Number of Sessions: 08
Session Duration: 2.00 Hr
Total Duration: 16 Hr
Course Length: 2 Month
Course Fee:

Course Contents:

Module 1: Understanding Business Intelligence  

✔ What is BI PowerPivot

✔ Why PowerPivot

✔ Exploring the PowerPivot

✔ Importing billion rows in excel

✔ Create Models

✔ Concept to Data Science

✔ Big Data

✔ Dax [If, Switch, Date, Related]

✔ Actual vs Budget Report

✔ Dashboard using PowerPivot

Module 2: Introduction to Power BI Desktop & installation 

✔ What is Power BI

✔ Why Power BI

✔ How Power BI Works

✔ How to Install Power BI?

✔ Windows Store

Module 3: Visualization Basic Charts in Power BI 

✔ Column Chart

✔ Stacked Column Chart

✔ Pie Chart

✔ Donut Chart

✔ Funnel Chart

✔ Ribbon Chart

✔ Include and Exclude

✔ Export data from Visual

Module 4: Other Charts in Power BI Desktop 

✔ Line Chart

✔ Area Chart

✔ Line vs Column Chart

✔ Scatter Plot

✔ Waterfall Chart

✔ Tree Map

✔ Gauge Chart

Module 5: Cards and Filters in Power BI 

✔ Number Card

✔ Text Card

✔ Date Card

✔ Multi-Row Card

✔ Filter on Visual

✔ Filter on Page

Module 6: Table and Matrix in Power BI 

✔ Creating a Simple Table

✔ Formatting in Table

✔ Conditional Formatting in Table

✔ Changing Aggregation in Table

✔ Creating a Matrix in Power BI

✔ Conditional Formatting in Matrix

✔ Automatic Hierarchy in Matrix

✔ Subtotal and Grand Total

Module 7: Column from Examples and Conditional Column in Power BI 

✔ Column from Examples on Splitting Text

✔ Column from Examples on Merging Text

✔ Column from Examples on Date Column

✔ Conditional Column on One Column

✔ Conditional Column on two columns

✔ Conditional Column Comparing two column values

Module 8: Power Query (Now Data Import)  

✔ Import Data from a Folder

✔ Import Data using Load To Option

✔ Clean Your Unstructured Data through Data Transform

✔ Pivot/ UnPivot Data

✔ Merge and Append Query

✔ Fill down and Fill up

✔ Grouping & Transpose

✔ Replace Errors and Values

✔ Keep Rows and Remove Rows

✔ Add, Remove, Goto Columns

Module 9: Advanced Power BI Desktop 

✔ Timeline Chart and Analyze Options

✔ Add Trend Lines and Forecast

✔ Multiple to show multiple fields and

✔ Show the percentage of totals in the table

✔ Import cool Visuals from Store and use one

✔ Export Data

✔ Show Multiple Charts

Module 10: Power BI DAX 

✔ What is DAX?

✔ What is Power Pivot?

✔ Aggregation Functions

✔ Date Time Intelligence Functions

✔ Filter Functions

✔ Financial Functions

✔ Logical Functions

✔ Relationship Functions

✔ Text Functions

✔ Dax Statement

✔ Related function can replace VLOOKUP

✔ Thee if() is more stronger than that of excel

✔ Use calculate functions to replace Sumifs

✔ Learn Measures

✔ New Columns Using DAX

✔ New Column Vs New Measure

✔ IF Condition in DAX

✔ IF with multiple Condition in DAX

✔ IFERROR Condition in DAX

✔ Adding Table with DAX

✔ Adding columns with DAX

Module 11: Advanced Power BI Desktop & ETL  

✔ Control and Edit Filter connection

✔ Conditional Format

✔ Load data from a folder automatically

✔ Transformation unshaped Data

✔ Use Data Quality

✔ Append and Merger

Module 12: Power BI Service Introduction  

✔ Introduce Power BI Service

✔ Publish a report on Web

✔ Build a Dashboard

✔ Create workspaces

✔ Share Reports and Dashboards with others

✔ Analyze with Excel

✔ Export to Different Platform

✔ Embed Data in Website

✔ Assign User Role and manage users

Pre-requisite: Excel Basics

After completing the course participants will be able to:  

✔ Develop Lucrative Sales Data Dashboard, Multiple Categories View  

✔ Segment Data Visualizations, Forecasting, Analyze, Performance Analyze  

✔ Combine, Find and Integrate Data from Multiple Data Sources. 

✔ Achieve Data Analysis Expressions (DAX) Business Logic and Calculations Skills.

✔ Perform Analytics Diagnostics Costing, Marketing and Sales Functions. 

✔ Achieve Analytics Techniques for Business Development.