MICROSOFT POWER BI (10-12 SESSIONS)
MODULE-1: COURSE INTRODUCTION
- What is Microsoft Power BI?
- Purpose of Training
- What to Expect?
- Required Resources
- Structure of Training
- Introduction to Training Project
MODULE-2: INTRODUCING THE POWER BI TOOL
- Meeting the Power BI tool: Desktop & Service
- How and where to Download Power BI Desktop
- Necessary Settings
- Familiarizing with Power BI
- Data Analysis Expressions (DAX)
- Quick Quiz Time
MODULE-3: POWER QUERY - CONNECTING TO DATA SOURCES
- Different Types of Connections
- Advantages / Disadvantages of each connection type
- Frequently used data sources
MODULE-4: POWER QUERY - SHAPING DATA
- Power Query Editor
- Basic Transformations
- Using Multiple tools available on Power Query
- Quick introduction to Advanced Editor
- Discussing Best Practices
- Quick Quiz Time
- Exercise
MODULE-5: POWER BI DESKTOP - MODELING DATA
- Introduction to Data Model
- Describing Modeling Tab
- Creating Model
- Best Practices
- Quick Quiz Time
- Exercise
MODULE-6: POWER BI DESKTOP - DAX
- What are Measures?
- What are Calculated Columns?
- Measure vs Calculated Columns
- Working session Using DAX
- Best Practices
- Quick Quiz Time
- Exercise
MODULE-7: POWER BI DESKTOP - CREATING VISUALIZATION
- Introduction
- Working session with Visuals
- Using Filters Pane
- Using Slicer
- Interacting with Visuals
- Using Drill through & Drill Down
- Editing Interactions
- Using "What-if" Parameters
- Managing Roles in Power BI
- Publishing Report to Power BI Service
- Best Practices
- Quick Quiz Time
- Exercise
MODULE-8: INTRODUCING POWER BI SERVICE
- BI as a Service
- Setting Expectations
- What is Power BI Service?
- How Power BI Service look like
- Quick Quiz Time
- Exercise
MODULE-9: POWER BI SERVICE - DATA CONNECTION FROM SERVICE
- Options for Data Connection
- Loading Flat files to Power BI Service
- Components of Power BI Service
- Creating App Workspace
- Loading Power BI File to Service
- Quick Quiz Time
- Exercise
MODULE-10: POWER BI SERVICE - GATEWAYS & REFRESH IN SERVICE
- What is a Data Gateway?
- Different types of Gateways
- Setting up Personal Gateway
- Enabling Scheduled Refresh
- What are Dataflows?
- Quick Quiz Time
- Exercise
MODULE-11: POWER BI SERVICE - REPORTS & DASHBOARDS
- What are Reports & Dashboards
- Pinning Report Visuals to Dashboard
- Adding Slicers Visuals
- Pinning Live Pages to Dashboards
- Setting up alerts
- Quick Quiz Time
- Exercise
MODULE-12: POWER BI SERVICE - SHARING ON SERVICE
- Sharing on Power BI Service
- Publishing the Report on the Web
- User Roles & Permissions
- Publishing Apps and using it
- Quick Quiz Time
- Exercise
MODULE-13: SUMMING UP
- Best Sites for Reference
- Best YouTube Channel for Reference
MODULE-14: ADVANCED TOPICS
- Working with M Language
- Advanced DAX Functions
- Calculated Tables
- Handling Many-to-Many Relationships
- Best Practices in Power Query
Classes
Duration
