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
Who We are

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

1. Power BI Desktop and Power Query

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

  1. Class Introduction (BI Basics)
  2. Class Introduction (Power Platform & Power BI Desktop Overview)
  3. Data Discovery with Power BI Desktop

Transforming Data

  1. Basic Transforms
  2. Add Column From Example
  3. Appending Queries
  4. Merging Queries
  5. Combine Files
  6. M Query Basics
  7. Parameters and Templates
  8. Other Query Features

Creating the Data Model

  1. Introduction to Modeling Data
  2. Modeling Basics
  3. Model Enhancements
  4. What If Parameters
  5. DAX Basics
  6. Navigation Function
  7. Calculated Tables
  8. Measure Basics
  9. Time Intelligence Functions

2. Power BI Service - Visualizations - Power BI Mobile

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

  1. Introduction to Visualizing Data
  2. Creating Basic Reports with the Power BI Desktop
  3. Creating Interactive Reports (Adding Slicers for Filters)
  4. Visualizing Tabular Data
  5. Visualizing Categorical Data
  6. Visualizing Data Trends
  7. Visualizing Categorical and Trend Data Together
  8. Visualizing Geographical Data with Maps
  9. Visualizing Goal Tracking
  10. Using Custom Visuals
  11. Digital Storytelling
  12. Other Features

Usage of Power BI Service

  1. Deploying to the Power BI Service
  2. Creating and Sharing Dashboards
  3. Using Power BI Q&A
  4. Setting up App Workspaces
  5. Subscriptions and Alerts
  6. Excel Integration
  7. 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

3. Get Data Module

The Get Data module of Power BI deals with Excel and Power BI key features and services.

 

  1. Excel
  2. CSV
  3. Flat File
  4. Facebook
  5. Sql Server
  6. SSAS Multidimensional
  7. SSAS Tabular

4. Data Analysis Expressions (DAX) - Basics

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.

 

  1. Getting Started
  2. Data Modeling Basics (Overview & Tabular)
  3. What is DAX (Overview & Tabular)
  4. Creating Calculated Columns
  5. Navigation Functions
  6. Conditional and Logical Functions
  7. Creating Calculated Measures
  8. Time Intelligence Overview & Functions
  9. Using X-Functions and A-Functions
  10. Table Functions
  11. DAX as a Query Language

5. Data Analysis Expressions (DAX) - Advanced

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.

 

  1. Class Introduction (Class Files)
  2. Class Introduction (Why Advanced DAX)
  3. Working with Variables
  4. Working with Filter Context – Basics
  5. CALCULATE
  6. Overriding Filter Context
  7. FILTER & ALL
  8. Working with Filter Context (ALL EXCEPT)
  9. Totals

 

  1. CALCULATE and Time Intelligence (YTD and MTD)
  2. Rolling 12 Months Total
  3. Rolling 3 Month Average Total

 

  1. Semi-Additive Measures (Overview)
  2. Opening and Closing Balance
  3. Understanding Row Context and Context Transition
  4. Working with Iterator Functions
  5. Nested Row Context
  6. Error Handling

 

  1. Implementing Basic Security
  2. Dynamic Security
  3. Implementing Basic Security – Tabular
  4. Dynamic Security – Tabular

 

  1. Role Playing Dimensions (Multiple Table Import)
  2. USERELATIONSHIP

 

  1. Advanced DAX Functions
  2. CONTAINS
  3. FIND
  4. SEARCH and SUBSTITUTE
  5. ALLSELECTED
  6. RANKX