Business Analytics with Microsoft Power BI : Course Content
Introduction
- Purpose and Objectives of this Course
- Introduction to Business Analytics
- Good Data vs Bad Data
- 10 rules for good data
- Overview: Power BI concepts
- Building Blocks of Power BI
- Power BI installation and user interface
---------------------------
Power Query Overview
- Power Query Software Overview
- Overview Power BI Data Sources
- Connecting to Data Sources and Extracting the Data
- Establish connection to the Excel source, SQL Server
- Importing Data into Power Query Editor
- Transforming the Data in Power Query Editor using GUI Options
- Loading the Data into Power Pivot
- Understanding the M(Mashup) Language behind the GUI Options
---------------------------
Data Modelling and Power Pivot
- Understanding Power Pivot
- Advantage of In Memory Columnar Database
- Type of Relationship
- Star Schema overview
---------------------------
Enhancing the Data Model - DAX
- What is DAX(Data Analysis eXpressions) Language – Functional Language
- New Column, New Measure / Quick Measure, New Table
- Creating New Column, Creating New Measure
- Implicit Measures, Explicit Measures
- Difference Between New Columns & New Measures
- DAX Text Functions
- DAX Logical Functions
- DAX Date & Time Functions
- DAX Filter Functions
- DAX Math and Statistical Functions
- DAX Time Intelligence Functions
- Quick Measures / DAX using ChatGPT
---------------------------
Power View
- Report View / Power View
- Visuals Interactions
- Filters in Power View
- Hierarchies and Drill-Down Reports
- Power BI Visualizations
- Visuals for Filtering
- Visualizing Categorical Data
- Visualizing Trend Data
- Visualizing KPI Data
- Visualizing Tabular Data
- Visualizing Geographical Data
- Tooltip Page
- Bookmarks, Selection Pane & Buttons
- Download and use custom visuals
- Designing using Bluewillow and MidJourney
---------------------------
Power BI Service
- Power BI Service Introduction
- Adding Dataset to Power BI Service and Creating Multiple New Reports
- Dashboards Development
- Building Blocks of Power BI
- Data Connectivity Modes in Power BI
- Installing & Configuring the Data Gateways
- Understanding Subfolders in Workspace
- Dataflows / ML Using Machine Learning
- Dataset Actions
- Excel Workbooks
- Report Actions
- Dashboard Actions
- Team Collaboration in Power BI using Workspaces
- Sharing Power BI Content using Basic Sharing, Content Packs and Apps
- Row Level Security in Power BI
- Syncing Published Power BI Report Files Using OneDrive / Google Drive
- Deployment Pipelines
---------------------------
ADD ON
- Real-time Project Explanation
- Resume Preparation, Power BI Developer Roles & Responsibilities
- Interview Questions Discussions
- Road to Microsoft-certified Power BI professional
Comments