Become a Power BI Expert
ExtraCourse is the NO.1 Power BI training institute offering the best Power BI training in Hyderabad, expert guidance and 100% placement assistance..
Extra Course is a best Power BI training institute in Hyderabad. We offer 100% practical driven program through our unique experimental learning, focus on comprehensive practical approach. We follow a holistic curriculum which has been designed by Industrial experts in a systematic approach from the beginner’s level to a more advanced study.
Holistic Curriculum | Complete Practical Driven Learning | Real Time Projects | Be a Future Ready
Key Highlights
- Curriculum is curated by Industrial Experts in Power BI
- Extensive study on real time projects
- Handouts, Exercises and Assignments on each and every topic in PEGA
- Work on Real-time scenarios
- 100+ Hands on Practical Assignments
- Real time work on currently running projects
- Resume preparation
- Mock Interviews
- 100% Placement Assistance
- All classes will be recorded and sent to you everyday
- Get Certified
What you'll learn
1.Business Intelligence tool to create stunning reports and dashboards.
2.Connect to multiple sources of data like SQL Server, Excel, CSV, JSON, XML, Web and SQL Analysis Services
3.Create powerful tables and matrix of reporting data.
3.Custom Visualizations and Themes in Power BI.
4.Automate the cleansing of data.
5.Develop data modeling skills.
Course Duration
Course Name |
Type |
Course Duration |
Price |
Power BI |
Training |
40 hrs |
20,000/- |
Power BI |
Workshop |
||
Power BI |
Training & Workshop |
Power BI Course Content
This module will walk you through the fundamental concepts of BI and Power BI Desktop. You will gain knowledge of query and file operations. You will learn about Power BI on how to connect multiple data sources to this tool and other concepts including tables, columns, and measures.
Getting Started
- Class Introduction (BI Basics)
- Class Introduction (Power Platform & Power BI Desktop Overview)
- Data Discovery with Power BI Desktop
Transforming Data
- Basic Transforms
- Add Column From Example
- Appending Queries
- Merging Queries
- Combine Files
- M Query Basics
- Parameters and Templates
- Other Query Features
Creating the Data Model
- Introduction to Modeling Data
- Modeling Basics
- Model Enhancements
- What If Parameters
- DAX Basics
- Navigation Function
- Calculated Tables
- Measure Basics
- Time Intelligence Functions
In this section, you will understand how the visualization of data is done and the creation of interactive reports with Power BI Desktop. We also learn about Power BI Components.
Visualizing Data – Creating Interactive Reports
- Introduction to Visualizing Data
- Creating Basic Reports with the Power BI Desktop
- Creating Interactive Reports (Adding Slicers for Filters)
- Visualizing Tabular Data
- Visualizing Categorical Data
- Visualizing Data Trends
- Visualizing Categorical and Trend Data Together
- Visualizing Geographical Data with Maps
- Visualizing Goal Tracking
- Using Custom Visuals
- Digital Storytelling
- Other Features
Usage of Power BI Service
- Deploying to the Power BI Service
- Creating and Sharing Dashboards
- Using Power BI Q&A
- Setting up App Workspaces
- Subscriptions and Alerts
- Excel Integration
- Export and Embed Options
Data Refreshing
- Overview
- Installing the Data Gateway
- Scheduling a Data Refresh
Power Mobile Version
- Power BI Mobile Overview
- Designing Reports and Dashboards for Mobile
- Interacting with the Power BI Mobile App
The Get Data module of Power BI deals with Excel and Power BI key features and services.
- Excel
- CSV
- Flat File
- Sql Server
- SSAS Multidimensional
- SSAS Tabular
In this module, you will become familiar with expressions used for Analyzing Data with Power BI and calculations. You will also learn about data manipulation using time periods and creating calculations over these time periods.
- Getting Started
- Data Modeling Basics (Overview & Tabular)
- What is DAX (Overview & Tabular)
- Creating Calculated Columns
- Navigation Functions
- Conditional and Logical Functions
- Creating Calculated Measures
- Time Intelligence Overview & Functions
- Using X-Functions and A-Functions
- Table Functions
- DAX as a Query Language
This section imparts knowledge on advanced expressions and Analyzing Data with Power BI using query context , row context, and filter context dynamically. You will also become familiar with the implementation of basic and dynamic row-level security. You will also gain knowledge of handling errors and role-playing dimensions.
- Class Introduction (Class Files)
- Class Introduction (Why Advanced DAX)
- Working with Variables
- Working with Filter Context – Basics
- CALCULATE
- Overriding Filter Context
- FILTER & ALL
- Working with Filter Context (ALL EXCEPT)
- Totals
- CALCULATE and Time Intelligence (YTD and MTD)
- Rolling 12 Months Total
- Rolling 3 Month Average Total
- Semi-Additive Measures (Overview)
- Opening and Closing Balance
- Understanding Row Context and Context Transition
- Working with Iterator Functions
- Nested Row Context
- Error Handling
- Implementing Basic Security
- Dynamic Security
- Implementing Basic Security – Tabular
- Dynamic Security – Tabular
- Role Playing Dimensions (Multiple Table Import)
- USERELATIONSHIP
- Advanced DAX Functions
- CONTAINS
- FIND
- SEARCH and SUBSTITUTE
- ALLSELECTED
- RANKX