Microsoft Power BI Certification

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 @ 8985077485
Power BI Guru E solutions provides best Power BI Training in Hyderabad 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

Exam basics:

  • 40-60 questions
  • 1-3 hours to complete the exam
  • Can review questions (for most question types)
  • Can include up to 20 different types of questions
  • 700 is passing
    • 700 <> 70%
  • Can be taken Online or at a registered exam location

Note 700 does not always represent 70%. Similar to most exams of its type, it is a normalized score, and it is on an exam by exam basis.

Consuming and Transforming Data By Using Power BI Desktop

  • Connect to data sources.
  • May include: Connect to databases, files, folders; import from Excel; connect to SQL Azure, Big Data, SQL Server Analysis Services (SSAS)
  • Perform transformations.
  • May include: Design and implement basic and advanced transformations; apply business rules; change data format to support visualization
  • Cleanse data.
  • May include: Manage incomplete data; meet data quality requirements

Modeling and Visualizing Data

  • Create and optimize data models.
  • May include: Manage relationships; optimize models for reporting; manually type in data; use Power Query
  • Create calculated columns, calculated tables, and measures.
  • May include: Create DAX formulas for calculated columns, calculated tables, and measures; Use What If parameters
  • Measure performance by using KPIs, gauges and cards.
  • May include: calculate the actual; calculate the target; calculate actual to target; configure values for gauges; use the format settings to manually set values
  • Create hierarchies.
  • May include: Create date hierarchies; create hierarchies based on business needs; add columns to tables to support desired hierarchy
  • Create and format interactive visualizations.
  • May include: Select a visualization type; configure page layout and formatting; configure interactions between visual; configure duplicate pages; handle categories that have no data; configure default summarization and data category of columns; position, align, and sort visuals; enable and integrate R visuals; format measures; Use bookmarks and themes for reports
  • Manage custom reporting solutions.
  • May include: Configure and access Microsoft Power BI Embedded; enable developers to create and edit reports through custom applications; enable developers to embed reports in applications; use the Power BI API to push data into a Power BI dataset; enable developers to create custom visuals

Configure Dashboards, Reports and Apps in the Power BI Service

  • Access on-premises data.
  • May include: Connect to a data source by using a data gateway;publish reports to the Power BI service from Power BI Desktop; edit Power BI Service reports by using Power BI desktop
  • Configure a dashboard.
  • May include: Add text and images; filter dashboards; dashboard settings; customize the URL and title; enable natural language queries
  • Publish and embed reports.
  • May include: Publish to web; publish to Microsoft SharePoint; publish reports to a Power BI Report Server
  • Configure security for dashboards, reports and apps.
  • May include: Create a security group by using the Admin Portal; configure access to dashboards and app workspaces; configure the export and sharing setting of the tenant; configure Row-Level Security
  • Configure apps and apps workspaces.
  • May include: Create and configure an app workspace; publish an app; update a published app; package dashboards and reports as apps

References:

Consume and Transform Data By Using Power BI Desktop

20-25% of the exam questions are on these topics.

 

Model and Visualize Data

45-50% of the exam questions come from these topics.

Configure Dashboards in the Power BI Service

25-30% of the questions in the exam are on these topics

 

Exam basics:

  • 40-60 questions
  • 1-3 hours to complete the exam
  • Can review questions (for most question types)
  • Can include up to 20 different types of questions
  • 700 is passing
    • 700 <> 70%
  • Can be taken Online or at a registered exam location

Note 700 does not always represent 70%. Similar to most exams of its type, it is a normalized score, and it is on an exam by exam basis.

 


Consuming and Transforming Data By Using Power BI Desktop

  • Connect to data sources.
  • May include: Connect to databases, files, folders; import from Excel; connect to SQL Azure, Big Data, SQL Server Analysis Services (SSAS)
  • Perform transformations.
  • May include: Design and implement basic and advanced transformations; apply business rules; change data format to support visualization
  • Cleanse data.
  • May include: Manage incomplete data; meet data quality requirements

Modeling and Visualizing Data

  • Create and optimize data models.
  • May include: Manage relationships; optimize models for reporting; manually type in data; use Power Query
  • Create calculated columns, calculated tables, and measures.
  • May include: Create DAX formulas for calculated columns, calculated tables, and measures; Use What If parameters
  • Measure performance by using KPIs, gauges and cards.
  • May include: calculate the actual; calculate the target; calculate actual to target; configure values for gauges; use the format settings to manually set values
  • Create hierarchies.
  • May include: Create date hierarchies; create hierarchies based on business needs; add columns to tables to support desired hierarchy
  • Create and format interactive visualizations.
  • May include: Select a visualization type; configure page layout and formatting; configure interactions between visual; configure duplicate pages; handle categories that have no data; configure default summarization and data category of columns; position, align, and sort visuals; enable and integrate R visuals; format measures; Use bookmarks and themes for reports
  • Manage custom reporting solutions.
  • May include: Configure and access Microsoft Power BI Embedded; enable developers to create and edit reports through custom applications; enable developers to embed reports in applications; use the Power BI API to push data into a Power BI dataset; enable developers to create custom visuals

Configure Dashboards, Reports and Apps in the Power BI Service

  • Access on-premises data.
  • May include: Connect to a data source by using a data gateway;publish reports to the Power BI service from Power BI Desktop; edit Power BI Service reports by using Power BI desktop
  • Configure a dashboard.
  • May include: Add text and images; filter dashboards; dashboard settings; customize the URL and title; enable natural language queries
  • Publish and embed reports.
  • May include: Publish to web; publish to Microsoft SharePoint; publish reports to a Power BI Report Server
  • Configure security for dashboards, reports and apps.
  • May include: Create a security group by using the Admin Portal; configure access to dashboards and app workspaces; configure the export and sharing setting of the tenant; configure Row-Level Security
  • Configure apps and apps workspaces.
  • May include: Create and configure an app workspace; publish an app; update a published app; package dashboards and reports as apps

 

References:

Consume and Transform Data By Using Power BI Desktop

20-25% of the exam questions are on these topics.

 

Model and Visualize Data

45-50% of the exam questions come from these topics.

Configure Dashboards in the Power BI Service

25-30% of the questions in the exam are on these topics

Exam basics:

  • 40-60 questions
  • 1-3 hours to complete the exam
  • Can review questions (for most question types)
  • Can include up to 20 different types of questions
  • 700 is passing
    • 700 <> 70%
  • Can be taken Online or at a registered exam location

Note 700 does not always represent 70%. Similar to most exams of its type, it is a normalized score, and it is on an exam by exam basis.

 


Consuming and Transforming Data By Using Power BI Desktop

  • Connect to data sources.
  • May include: Connect to databases, files, folders; import from Excel; connect to SQL Azure, Big Data, SQL Server Analysis Services (SSAS)
  • Perform transformations.
  • May include: Design and implement basic and advanced transformations; apply business rules; change data format to support visualization
  • Cleanse data.
  • May include: Manage incomplete data; meet data quality requirements

Modeling and Visualizing Data

  • Create and optimize data models.
  • May include: Manage relationships; optimize models for reporting; manually type in data; use Power Query
  • Create calculated columns, calculated tables, and measures.
  • May include: Create DAX formulas for calculated columns, calculated tables, and measures; Use What If parameters
  • Measure performance by using KPIs, gauges and cards.
  • May include: calculate the actual; calculate the target; calculate actual to target; configure values for gauges; use the format settings to manually set values
  • Create hierarchies.
  • May include: Create date hierarchies; create hierarchies based on business needs; add columns to tables to support desired hierarchy
  • Create and format interactive visualizations.
  • May include: Select a visualization type; configure page layout and formatting; configure interactions between visual; configure duplicate pages; handle categories that have no data; configure default summarization and data category of columns; position, align, and sort visuals; enable and integrate R visuals; format measures; Use bookmarks and themes for reports
  • Manage custom reporting solutions.
  • May include: Configure and access Microsoft Power BI Embedded; enable developers to create and edit reports through custom applications; enable developers to embed reports in applications; use the Power BI API to push data into a Power BI dataset; enable developers to create custom visuals

Configure Dashboards, Reports and Apps in the Power BI Service

  • Access on-premises data.
  • May include: Connect to a data source by using a data gateway;publish reports to the Power BI service from Power BI Desktop; edit Power BI Service reports by using Power BI desktop
  • Configure a dashboard.
  • May include: Add text and images; filter dashboards; dashboard settings; customize the URL and title; enable natural language queries
  • Publish and embed reports.
  • May include: Publish to web; publish to Microsoft SharePoint; publish reports to a Power BI Report Server
  • Configure security for dashboards, reports and apps.
  • May include: Create a security group by using the Admin Portal; configure access to dashboards and app workspaces; configure the export and sharing setting of the tenant; configure Row-Level Security
  • Configure apps and apps workspaces.
  • May include: Create and configure an app workspace; publish an app; update a published app; package dashboards and reports as apps

References:

Consume and Transform Data By Using Power BI Desktop

20-25% of the exam questions are on these topics.

 

Model and Visualize Data

45-50% of the exam questions come from these topics.

Configure Dashboards in the Power BI Service

25-30% of the questions in the exam are on these topics

Organizational content packs: Copy, refresh, & get access: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-organizational-content-packs-use-and-work-with/

Exam basics:

  • 40-60 questions
  • 1-3 hours to complete the exam
  • Can review questions (for most question types)
  • Can include up to 20 different types of questions
  • 700 is passing
    • 700 <> 70%
  • Can be taken Online or at a registered exam location

Note 700 does not always represent 70%. Similar to most exams of its type, it is a normalized score, and it is on an exam by exam basis.

 


Consuming and Transforming Data By Using Power BI Desktop

  • Connect to data sources.
  • May include: Connect to databases, files, folders; import from Excel; connect to SQL Azure, Big Data, SQL Server Analysis Services (SSAS)
  • Perform transformations.
  • May include: Design and implement basic and advanced transformations; apply business rules; change data format to support visualization
  • Cleanse data.
  • May include: Manage incomplete data; meet data quality requirements

Modeling and Visualizing Data

  • Create and optimize data models.
  • May include: Manage relationships; optimize models for reporting; manually type in data; use Power Query
  • Create calculated columns, calculated tables, and measures.
  • May include: Create DAX formulas for calculated columns, calculated tables, and measures; Use What If parameters
  • Measure performance by using KPIs, gauges and cards.
  • May include: calculate the actual; calculate the target; calculate actual to target; configure values for gauges; use the format settings to manually set values
  • Create hierarchies.
  • May include: Create date hierarchies; create hierarchies based on business needs; add columns to tables to support desired hierarchy
  • Create and format interactive visualizations.
  • May include: Select a visualization type; configure page layout and formatting; configure interactions between visual; configure duplicate pages; handle categories that have no data; configure default summarization and data category of columns; position, align, and sort visuals; enable and integrate R visuals; format measures; Use bookmarks and themes for reports
  • Manage custom reporting solutions.
  • May include: Configure and access Microsoft Power BI Embedded; enable developers to create and edit reports through custom applications; enable developers to embed reports in applications; use the Power BI API to push data into a Power BI dataset; enable developers to create custom visuals

Configure Dashboards, Reports and Apps in the Power BI Service

  • Access on-premises data.
  • May include: Connect to a data source by using a data gateway;publish reports to the Power BI service from Power BI Desktop; edit Power BI Service reports by using Power BI desktop
  • Configure a dashboard.
  • May include: Add text and images; filter dashboards; dashboard settings; customize the URL and title; enable natural language queries
  • Publish and embed reports.
  • May include: Publish to web; publish to Microsoft SharePoint; publish reports to a Power BI Report Server
  • Configure security for dashboards, reports and apps.
  • May include: Create a security group by using the Admin Portal; configure access to dashboards and app workspaces; configure the export and sharing setting of the tenant; configure Row-Level Security
  • Configure apps and apps workspaces.
  • May include: Create and configure an app workspace; publish an app; update a published app; package dashboards and reports as apps

References:

Consume and Transform Data By Using Power BI Desktop

20-25% of the exam questions are on these topics.

Model and Visualize Data

45-50% of the exam questions come from these topics.

Configure Dashboards in the Power BI Service

25-30% of the questions in the exam are on these topics

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 :

Introduction

  • Introduction to Power BI – Need, Importance
  • History – Power View, Power Query, Power Pivot
  • Power BI Architecture and Data Access

Power BI Desktop 

  • Power BI Desktop – Installation, Usage
  • Understanding Power BI Report Designer
  • Report Visuals, Fields and UI Options
  • Visualization Filters, Page Filters, Report Filters
  • General Properties, Sizing, Dimensions, and Positions
  • Sample Reports and Visualization Controls
  • Experimenting Visual Interactions, Advantages
  • Reports with Multiple Pages and Advantages
  • Hierarchies and Drilldown Options
  • Hierarchies: Grouping Multiple Report Fields
  • Hierarchy Levels and Usages in Visualizations
  • Drill-thru Options with Tree Map and Pie Chart
  • Higher Levels and Next Level Navigation Option
  • Data Fields and Filters with Visualizations
  • Creating Customised Tables with Power BI Editor
  • Column Headers, Column Formatting, Value Properties
  • Conditional Formatting Options – Color Scale
  • Background Properties, Borders and Lock Aspect
  • CHART Report Types and Properties
  • Map Reports: Working with Map Reports
  • Creating high-density reports, ArcGIS Maps
  • PUBLISH Options and Report Verification in Cloud

Power Query: 

  • Direct Query Options and Real-time (LIVE) Data Access
  • Advanced Query Mode @ Connection Settings – Options
  • Custom Columns with Power Query
  • Power Query Expressions and Usage
  • PIVOT Operation and Table.Pivot(). List Functions
  • Using Parameters(Power Query Editor)
  • Report Design using Databases & Queries

Power BI Service : 

  • Understanding PowerBI Cloud Architecture
  • Publish Options and Data Import Options
  • Page to Report – Mapping Options
  • Import and Export Options with Power BI
  • Gateways, Subscriptions, Mobile Reports
  • Installing the Power BI Enterprise Gateway
  • Dataset Actions and Refresh Settings with Gateway
  • Configuring Automatic Refresh and Schedules
  • Dashboards and Pins – Real-time Usage
  • Adding images to the dashboards
  • Relation between Dashboards to Reports
  • Dashboards, Workbooks, Reports, Datasets
  • Dashboard Integration with Apps in Power BI
  • Dashboard Actions: SETTINGS FOR Q & A, DELETE
  • PIN Actions: SETTINGS FOR Q & A, DELETE
  • EDIT DASHBOARD (CLOUD), On-The-Fly Reports
  • SCHEDULED REFRESH & RELATED ITEMS
  • Working with MY WORK SPACE group
  • PowerBI Cloud Account and Workspace
  • Quick Navigation Options with “My Workspace”
  • Navigation Paths with “My Workspace” Screens
  • Report Actions: USAGE METRICS, ANALYSE IN EXCEL
  • Personal and Organizational Content Packs
  • Dataset Navigations and Report Navigations
  • Managing report in Power BI Services
  • Dynamic Data Sources and Encryptions
  • Data Refresh with Power BI Architecture
  • Automatic Refresh – Possible Issues
  • Publish PowerBI Report Templates
  • Using natural Language Q&A to data – Cortana

Power BI Mobile:

Power BI Apps for Mobile Devices

  • Find your dashboards, reports, and apps in the Power BI mobile apps
    • Favourites
    • Report Server (optional)
    • Apps
    • Shared with me
    • Workspaces
  • New in the mobile apps for Power BI
  • Improved security management
  • Improved permission management
  • Auto-installed apps
  • Filters for phone reports in Android
  • View on-premises report server reports and KPIs in the Power BI mobile apps
  • Dashboards for Power BI Mobile
  • Interact with tiles in Mobile Apps
  • Share a dashboard from the Power BI Mobile Apps
  • Scan a Power BI QR code from your mobile device
  • Get notifications in the Power BI mobile apps
  • Data Alerts and View your data offline in the Power BI mobile apps
  • Power BI App for Android Phones/Iphones/Windows 10 Devices

Upcoming Events

COURSEFACULTYSTART DATETIMINGSDURIATION(HOURS)FEEMODE OF TRAININGRegister
Power BI Job Support(SQL Serevr/MSBI/Power BI)SrinivasTBDTBD22 days/Pm800 USDOnlineEnquire
Power BI _Industry ConnectSrinivas28 June 199 PM IST30900 USDOnlineEnquire
Power BI _Industry ConnectSrinivas5 July 198 AM IST30900 USDweekend Online Enquire
Power BI _Industry ConnectSrinivas29 June 198 AM30900 USDOnlineEnquire
Power BI _Industry ConnectSrinivas1 july 198 Pm30900 USDOnlineEnquire

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