Microsoft Power BI

This course is intended to provide the basic level curriculum. The idea of this course is conceptual understanding and hands-on learning. At the end of this course, everyone must feel they are at ease working with Power BI from basic to advanced areas.

Course Highlights:

• Learn to leverage data that makes you the star performer of your team
• Build Powerful AL Dashboards using Microsoft Power BI to track all your KPIs
• Get Key Insight & Observations from your data
• Master Data Analysis &Visualization 
• Perform Business Intelligence to grow any Company
• No Prior coding or business knowledge required

Content:

• Getting Started
  • Why Power BI
  • Interface of Power BI
  • Different Parts of Power BI
  • Components of Power BI
  • Power BI Workflow
• Module 2: Prepare Data In Power Bi
  • How to Import Tables and Ranges in Power BI?
  • How to Import CSV, PDF, and Web in Power BI?
  • Power BI output format?
• Module 3: Clean, Transform, And Load Data In Power Query
  • Functions using the menu:
  • Various text functions prepare data for data visualisation
  • Various Date functions to prepare data for data visualisation
  • Various Number of functions to prepare data for data visualisation
• Module 4: Data Cleaning Techniques
  • Transformation of data in Power Query without coding
  • Promote and Demote Headers 
  • Add, Remove, Rename, Delete, Move Column
  • Ignore Top/Bottom Rows and extract relevant data in middle
  • Keep and Remove Top and Bottom Rows
  • Transpose, Pivot and Unpivot
  • Fill up and Fill down
  • Merging data in Power Query- without VLOOKUP
  • Merging data from two tables in Excel
  • Remove Duplicates. blank rows, null values, and errors
  • Collect and add data to a single file in Power Query
  • Appending Clean Data
  • Append Multiple CSV files from a folder in a fraction of second
  • Append Multiple Excel Tables 
  • Append Multiple Excel files from the folder
  • Append Multiple PDF files from the folder
  • Merging data from two Excel files 
  • Merging data from two data sources
• Module 5: More With Power Query Editor
  • Creating data in Power BI Data Visualization
  • Creating custom columns with M Functions
  • Creating Columns from Examples
  • Creating Index Column
  • Creating parameter and using them in custom functions
  • Creating Custom Functions and invoking them
• Module 6: Advanced Visualization In Power Bi
  • Getting data in Power BI Data Visualization
  • Creating Various Types of charts like Column, Line, Bar, Stacked Column, Stacked Bar chart, Area Chart, Stacked Area chart, Line vs Column CHart
  • Creating Pie, Donut, Guage Chart, Funnel, Ribbon Chart
  • Creating a Maps
  • Creating a Single Card for text, Date, and numbers
  • Creating multi-row card for text, date, and numbers
  • Creating a decomposition tree