Microsoft Power BI

Introduction

• Introduction to Power BI
• Components of Power BI
• Installing Power BI Desktop
• Various Options in Power BI Desktop

2. Working with Different Sources (Excel, SQL Server, OData Feed etc.)
• Import
• Direct Query
• Import vs Direct Query
• Limitations of Direct Query
• Query Editor
• Working with Power Query
• Relationships

3. Reports Development
• Reports Development in Power BI
• Working with Different Visuals
• Formatting Options in Reports
• Working with Filters
• Custom Visuals

4. Power BI Service
• Overview of Power BI Service
• Publishing the Reports
• Dashboards
• Gateways
• Enterprise vs Personal Gateway
• WorkSpaces
• Content Packs
• Apps
• Security
• Schedule Data Refresh
• Power BI Premium
5. SSAS Tabular
• SSAS Tabular Overview
• Install and Configure SSAS Tabular
• Building a Tabular Model
• SSAS Tabular as Source
• Live Connections
• Deploy & Processing in Tabular
• SQL Server Agent
• Schedule Processing of Model
6. Data Analysis Expressions (DAX)
• Introduction to DAX
• Calculated Columns
• Measures
• Calculated Columns vs Measures
• Variables
• Table Functions
• Evaluation Contexts
• Calculate
• Time Intelligence in DAX
• Frequently Used DAX functions in Real-time
• Calendar Functions
7. Other Power BI Concepts
• Parameters
• Drill Through
• Bookmarks
• Row-level Security
• Dynamic Measures
• Dynamic Axis in Charts
• Dynamic Filters
• Power BI Template file
• Wallpapers
• Themes
• Q&A
• Editing the Themes
• Power BI Updates

Course Enquiry





Menu