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.
Course Features
- Lectures 0
- Quizzes 0
- Duration 16 hours
- Skill level All levels
- Language English
- Students 51
- Assessments Yes
