Mode of Training
LIVE ONLINE TRAINING
Curriculum
Power BI – Complete Package
1. 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 (1:1, 1: Many, Many:1)
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. Advanced/ 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
Benefits of Certificate
Skill Development: Certificates often require participants to acquire and demonstrate specific skills and knowledge. This can lead to improved competence and expertise in a particular area.
Career Advancement: Many certificates are directly related to specific careers or industries. Earning a relevant certificate can enhance your qualifications and make you a more attractive candidate for job opportunities or promotions.
Professional Recognition: Certain certificates are widely recognized and respected in specific fields. Earning such certificates can enhance your professional credibility and reputation.
Specialization: Certificates allow individuals to specialize in a particular area or aspect of a field, enabling them to focus on their areas of interest or expertise.
