Microsoft Power BI Bootcamp

This training path will take a deep dive into the Power BI ecosystem, you will learn from starting to end that how to develop solutions and solve complicated business problems.
Duration: 5 Days
Hours: 25 Hours
Training Level: All Level
Batch Fifteen
Monday, November 04, 2024
11:00 AM - 04:00 PM (Eastern Time)
Batch Sixteen
Monday, December 02, 2024
11:00 AM - 04:00 PM (Eastern Time)
Live Session
Single Attendee
$299.00 $499.00
Live Session
Recorded
Single Attendee
$349.00 $583.00
6 month Access for Recorded
Live+Recorded
Single Attendee
$399.00 $666.00
6 month Access for Recorded

About the Course:

Microsoft Power BI is one of the most popular Data Visualization and Business Intelligence that connects data from different data sources and creates stunning & interactive BI reports and dashboards. It possesses a large market share among Fortune 500 companies.

In this 25-hour virtual Bootcamp course, Our Microsoft Certified Power BI Profession & Microsoft Certified Trainer, will start the discussion with the importance of data visualization and Power BI and will help you to reach the advanced level in Power BI. This knowledge enriching journey will complete the milestones of Power Query Editor, cleaning & data transformation, connecting data from multiple sources, Data Analysis Expressions (DAX) and Data Visualization. This course finally ends its journey with Power BI Service. This course also helps you to prepare for PL-300 Exam. PL-300 Exam helps you to get Microsoft Power BI Data Analyst Certification. This certification will support you to shift your career to Data Analyst position or enriches freshers to build their career as Data Analyst.

Course Objective:

  • Overview of Data Visualization & Power BI
  • Introduction to Power BI Desktop
  • Loading data from various data sources
  • Cleaning & transforming data with Power Query Editor
  • Merging & Appending data
  • Using DAX functions
  • Data Modelling
  • Creating & formatting visuals
  • Advanced charts
  • Slicers & Filters
  • Hierarchies
  • Introduction to Power BI Service
  • Power BI Report vs Dashboard
  • Data Gateways
  • Row Level Security 

Who is the Target Audience?

  • This Bootcamp is for all industry professionals, faculty members and students who are passionate about Data Visualization and Data Analytics. Anyone who is eager to learn about Power BI as a newbie and would like to achieve the advanced level in it.

Basic Knowledge:

  • Basic MS Excel knowledge will help you but it is not compulsory.

Curriculum
Total Duration: 25 Hours
Introduction to Data Visualization & Power BI

  • Data Visualization  
  • History of Data Visualization  
  • Benefits of Data Visualization  
  • What is Power BI?  
  • Why are we learning Power BI?  
  • Components of Power BI  
  • Power BI Architecture  
  • Power BI pricing structure  

Power BI Desktop

  • Introduction to Power BI Desktop  
  • Installation of Power BI Desktop  
  • Views in Power BI Desktop  
  • Overview of Power Query Editor  

Connect data from multiple sources

  • Connect Excel & CSV files  
  • Connect Folder containing multiples Excel & CSV files  
  • Connect tables from Websites / SharePoint  
  • Understanding different data types  
  • Manually detecting data types  
  • Best practices in column naming conventions  
  • Creating Column Headers  
  • Modelling Data  
  • Managing Data Relationships  

Data Cleaning

  • Removing duplicates, null values & errors  
  • Filtering blank rows & columns  
  • Filtering unwanted rows & columns  
  • Importance of Applied Steps section in Power Query Editor  
  • Replacing data from the tables  
  • Data profiling for data quality check  
  • Splitting columns  

Data Transformation

  • Append Queries / Files  
  • Merge Queries / Files  
  • Merging columns  
  • Move columns & sorting of data  
  • Pivot & Unpivot of data  
  • Duplicate & Reference tables  
  • Closing & Applying changes in Power Query Editor  
  • Difference between Refresh Preview & Refresh All  
  • Issues in refreshing data  

Data Analysis Expressions (DAX)

  • Overview of DAX  
  • Why DAX is important to learn?  
  • Data types in DAX  
  • Introduction to DAX functions  
  • Measures in DAX  
  • Calculated Columns in DAX  
  • Field Parameters (new feature)  
  • Date & Time functions  
  • Time Intelligence functions  

Data Visualization

  • Introduction to visuals in Power BI  
  • Various charts in Power BI  
  • New Format Pane (new feature)  
  • Canvas Zoom (new feature)  
  • Chart formatting & customization  
  • Adjusting Page layout  
  • Creating Hierarchies  
  • Drill up & Drill down  
  • Page navigations  
  • Customizing Tooltips  
  • Slicers  
  • Sync slicers  
  • Bookmarks  
  • Filters  
  • Tables & Matrix  
  • Conditional formatting  
  • Advanced Charts  
  • Custom Visuals  

Power BI Service

  • Overview of Power BI Service  
  • Importance of Power BI Service  
  • What is Workspace?  
  • Creating Workspace  
  • Power BI Report vs Dashboard  
  • Creating Power BI Dashboard  
  • Publish Power BI Report to Power BI Service  
  • Quick Insights  
  • Power BI Q&A  
  • Ask questions about our data using NQL  
  • Power BI Embedded  
  • Row Level Security (RLS)  
  • Paginated Report  
  • What is Data Gateway?  
  • Standard vs Personal Gateway  
  • Installation & configuration of Data Gateway  
  • Scheduled Refresh