Microsoft Power BI (Data Analyst) – Level – 2
Microsoft Power BI Data Analyst Level - 2
- Bring your own laptop.
- Knowledge of Level 1 is required.
Note: Training is completely practical on real world industrial datasets to achieve mastery for an international market.
Microsoft Power BI is the industry-leading business intelligence platform with more than 115 million users — and its growing. In 2020, the Power BI market represented more than $20 billion, and is estimated to double by 2026. 50,000 companies worldwide use Power BI to clean, transform, model, and visualize their data. Power BI usage has been growing quickly, with over 80,000 open jobs on LinkedIn.
By learning Microsoft Power BI, you can accelerate your career and become a data professional. You will also get ready for Microsoft PL-300 exam (an updated version of the DA-100 exam).
- Foreign and Local Experienced Trainers
- Hands-on Training with Real Working Environment
- Internship Opportunities
- Affordable Cost
- Continuous help to the Participants even after Training sessions via WhatsApp groups
- Guided projects, Profile building and Specific Resume designing are also done usually during gap between two levels
As Data Literacy is going to be mandatory and regulatory requirements for all domains and industries, any professional belonging to Banking, Finance, HR & Admin, Audit, Supply Chain, Engineering, Computer Science, Health Care, etc. are eligible for this training.
Data modeling
- Relationship/Model view
- Create and manage relationships in Power BI Desktop
Data Fundamentals and DAX Functions
- Data Type in Power BI Desktop
- DAX Basics
- Measures in Power BI Desktop
- Create your own measures
- Calculated columns
- Create calculated columns
- Difference between Calculated Measures and
Calculated Columns
Context in DAX Formulas
- Introduction to Context
- Row Context
- Filter Context
- Iterator Function
- Calculate Function
- Variables
- Variable in conjunction with calculate Function
The Date Table in DAX
- Calculated tables
- Working with dates
- Importance of date table
- Creating date table
- Adding column inside a table
- Connecting columns of tables
Quick Measures in DAX
- Explore quick measures pane
- Working with all calculation’s options in quick measures
- Aggregate, filters and time intelligence functions, etc.
Tasks and Projects
- Apply relationship on Gold Commodity Dataset.
- Applying DAX on Adventure Works (Bikes) sales dataset.
- Creating tables and quick measures on Adventure Works (Bikes) sales dataset.
Final Project: Participants must make a project as their final project which will be mandatory to submit.
Overview
Course Modality
- On-site
- Online
Course Duration
- 12 Hours
Course Level
- Microsoft Power BI Data Analyst–Level - 2 (Intermediate)
Course Prerequisites
- Knowledge of Level 1 (Basic)
Course Language
- English