Microsoft Power BI Training in
Hyderabad, India

Learn about basics of Microsoft Power BI, Power BI dashboard, DAX and to deal with data, its source and transformation

Power BI Training in Hyderabad ,Ameerpet @ 0091-9704077815
Power BI Guru E solutions provides best Power BI Training in Hyderabad, Power BI is a Data Visualization and Business Intelligence tool that converts data from different data sources to interactive dashboards and BI reports. Power BI suite provides multiple software, connector, and services – Power BI desktop, Power BI service based on Saas, and mobile Power BI apps available for different platforms.with 100% Real time Live projects , Job Placements , Certification classroom,online,corporate training’s in Hyderabad, Ameerpet.

Key Features

25 hours of Instructor-led training classes
Create dashboards with Quick Insights
Transform data for analysis and create effective data views
Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps
Creating calculated columns and measures and build relationships between different tables
How to create a report with different interactive visualization types
Learn how to use Power BI service to create dashboards and to share and publish your results
How to access your results from multiple devices using Power BI Mobile

Description

Power BI Training

Visualization of data is key to deriving useful insights from a business perspective. While there are many tools for this purpose, Power BI has been gaining popularity for offering cutting edge tools that help transform an organisation’s data into rich visuals and offer a panoramic view of the business to users helping them gauge updates in real time. The Power BI dashboard can run on multiple devices and helps organise data into trans formative visuals.

Power Bi Guru brings you a comprehensive Power BI training course that is a perfect introduction for you into the world of BI. You will learn the basics of Power BI such as the Power BI desktop, and how to connect to data using Power BI desktop. Our expert trainers will then familiarize you with the rich components that drive this tool such as Modelling, Visualizations, exploring data with the dashboard, working with Excel, publishing and sharing data and the DAX functionality. Enrol for the Power BI course now and master the powerful capabilities of BI. Moreover, you will get access to the reference materials after registering.

What you will learn from our workshop:

  • About BI and how it will transform data and business
  • About the Power BI desktop and managing and utilizing data with it
  • Connecting data from different sources and data modelling with Power BI desktop
  • How to custom create data visualizations and style reports for lucid data representation
  • The working of Power BI and Excel
  • How to share and collaborate with data with Power BI
  • Power BI Data Analysis Expression(DAX), and its functions

Is this course right for you?

This Power BI certification course is ideal for people who have to work with data and also developers, Business analysts, project managers and other IT professionals.

Prerequisites:

Participants are expected to have an understanding of how data works and how it can contribute to building a business to attend the Power BI training classes.

Course Content :

Unit 1: (1 Hour)

Introduction to Power BI

  • Why power BI
  • What Power BI contains
  • Different versions of Power BI
  • MSBI VS POWER BI
  • History of Power BI
  • Pre-requisites, course structure

Unit 2: UI (1 Hour)

Power BI Desktop:

  • Introduction to Power BI desktop
  • Installing of Power BI desktop
  • Loading the data from Power BI desktop
  • Different Tabs in Power BI Desktop
  • Grouping of categories
  • Creating Drill Down visualisations
  • Drill through Reports

 

Unit 3: UI (2 Hours)

Power BI feature implementations:

  • Report Tool tips
  • Book Marks
  • Visual Interactions -Cross filtering
  • Working with custom report /dashboard Themes
  • Sync Slicers
  • Selection pane

Filters:

  • Visual Level
  • Page Level
  • Report Level

Unit 4: D.S (2 Hours)

Working with Data sources:

Loading the data from

  • Excel
  • CSV
  • SQL Server

Tabular SSAS and

  • Azure Data warehouse or any other suggested sources

Data Loading Options

  • Import
  • Direct Query
  • Live Connection

Unit 5: Visualizations (3 Hours)

Working with Visualisations:

  • Creating visualisations in Power BI
  • Using of All default visualisations & Customisation
  • Working with custom visualisations

Unit 6 (4 Hours)

Power BI Service/Pro

Configuring Power Bi Service Account

Working with workspaces

  • Creating and Organising workspaces
  • Publishing reports from desktop
  • Importing reports
  • Importing data sets
  • Sharing of Reports/Dashboards

Gateways

  • Configuring gateway
  • Enterprise/personal gateways
  • Scheduling a data refresh
  • Sharing gateway at Gate way /Data set

Dashboards & sharing

  • Creating Dashboards
  • Sharing of individual reports/dashboards
  • Sharing reports to content packs
  • Sharing of reports to Apps and workspace

Self-service with Power BI

  • Accessing Reports /dashboards
  • Consuming content packs /Apps
  • Creating new reports in power Bi service

Others:

  • Exporting reports into PPT
  • Creating Alerts & subscriptions

Embeding the reports

Unit 7(3 Hours)

Power Query: (95% of all options in edit queries will be covered)

Performing transformations in Power BI

  • Grouping
  • Pivoting
  • Columns Split
  • Joins
  • Set operations
  • Keep/Remove TOP N Records etc

Unit 8 (1 Hour)

Power BI Mobile

  • Accessing of workspaces /Reports /Dashboards in Power BI Mobile
  • Creating mobile compatible Reports- Desktop
  • Creating mobile compatible Dashboards- Power BI service

Unit 9 (1 Hour)

Power BI Report server

Unit 10: (3 hours) Project

Interview Questions & resume preparation

Flow implementation

 

Upcoming Events

COURSEFACULTYSTART DATETIMINGSDURIATION(HOURS)FEEMODE OF TRAININGRegister
Power BI Srinivas24 May 197 AM25700 USDOnline TrainingEnquire
Power BI Srinivas22 May 197 PM IST25700 USDOnline TrainingEnquire
Power BISrinivas25th May 1910.30 PM IST25700 USDweekend Online TrainingEnquire

What are the differenyt sources that you worked on ?

SQL Server 
Tabular SSAS
Excel 
Notepad

What is the differeces b/w direct query/importing/live connection?

Import: we will load the data & craete a model in power Bi 
Direct query:we will load the structure of the tables & create a relation ships in power Bi file by keeping the data at database.we always access the data directly from source
Live connection: we will keep the data & model away from power Bi service,this can be reusable in mul

What is the difference b/w calculated column/measure?

Column
calculated column/computed/derived column which is created based on existing column
with the help of operators & functions .
-->whenever we perform the data refresh automatically this column gets the data
-->It will store the data in the model
--->it will occupy the emory 
--->It is faster 
-->it is static
-->it is unique at table level
-->for text/date related data types we can use
-->numeric columns for intermediate calculations we can use it 

Measure
--->It is a formula stored in a model
--->Whenever we used a measure at that time 
it wil get calculated
--->It will not store any data,it will not occupy any memory 
-->It will impact the performance 
--->It is unique at model level
-->It is dynamic

What are the different types of filters?

Page level
Visual level
Report level

COURSES

CLIENTS