Certhippo

CALL US
+1 302 956 2015 (USA)

Certhippo
Certhippo

571,823
Satisfied Learners

Certhippo

250,000+
Hours Classes

Certhippo

30,000+
Assignments

Certhippo

2,500+
Projects

All Course
Home   >    All Courses   >   Business Intelligence and Visualizations   >    Power BI Training and Certification

Power BI Training and Certification

SUPPORT NO. +1 302 956 2015 (USA)

Buy Now

Power BI training at Certhippo will make you an expert in business analytics service provided by Microsoft. You'll master the concepts about Power BI Desktop, Power BI Embedded, Power BI Map, Power BI DAX, Power BI SSRS, Power BI Integration and Power Pivot for Data Modelling.

Why this course ?

Microsoft - A leader in the Gartner Magic Quadrant for BI and Analytics Platforms for 2017

Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc ,Brillio and 45,000 MNCs across 185 countries use Power BI

Power BI professionals earn upto $114,000 per year - PayScale.com


  • 15K + satisfied learners. Reviews
Enroll now

Instructor-led Sessions

24 Hours of Online Live Instructor-led Classes. Weekend class : 8 sessions of 3 hours each. 

Real-life Case Studies

Towards the end of the course, create an interactive dashboard for visualisation using dataset from a Health Insurance company.

Assignments

Every class will be followed by practical assignments which aggregate to minimum 20 hours.

Lifetime Access

Lifetime access to Learning Management System (LMS) which has class presentations, quizzes, installation guide & class recordings.

24 x 7 Expert Support

Lifetime access to our 24x7 online support team who will resolve all your technical queries, through ticket based tracking system.

Certification

Addilearn certifies you as 'Power BI Expert' based on your project performance, reviewed by our expert panel.

Forum

Access to global community forum for all our users that further facilitates learning through peer interaction and knowledge sharing.

   About the course

Power BI is a powerful cloud-based suite of business analytics tools that make it easy to combine data from multiple sources, analyze and visualize information and share insights. 

Edureka's Power Bi course features easy drag and drop report authoring for advanced insights , and online web dashboards that update automatically and can be shared within seconds. 

You begin by learning about architecture and components of Power BI along with Power Query and Power Pivot. You will learn about Data Visualization with Power BI Desktop, Power View and Power Map. Along with the process of visualization, You will learn about Power BI Q&A and how the users can discover, explore and visualize their own enterprise. You will be introduced to the Power BI Administration for deployment of files and building dashboards in the Power BI Website.

   Training Objectives

After completing this course, you should be able to:

Discuss Power BI, Power Pivot, Power view, Power Map 

Discuss Power Query

Describe Power BI Desktop 

Describe DAX  

Explain Data Visualization 

State Power BI Q&A and Data insights

Develop Custom Visualizations

Discuss Power BI Embedded

Explain Power BI with SSRS Reports

Discuss the concepts around Power BI Administration

   Why Learn Power BI?

Power BI helps Business Analysts, Business Intelligence Manager, Statisticians & Analysts, Project Managers and Data scientists to visualize and share insights from their organizations’ data.

It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information from technology staff or database administrator. 

Power BI provides cloud based BI services - known as Power BI Services, along with a desktop based interface - called Power BI desktop. It offers Data modelling capabilities, including data preparation, data discovery and interactive dashboards.


   Who should go for this training?

The Power BI training at edureka is for all the professionals who are passionate about business intelligence, data visualization, and data analytics. 

For example:

  • Business Analysts

  • Business Intelligence Manager

  • Statisticians and Analysts

  • Data Scientists

  • Project Managers

   What are the pre-requisites for this Course?

Required Prerequisites : 

1. Experience navigating the Microsoft Windows Environment


2. Experience with Microsoft Excel Pivot Tables and Pivot Charts is desirable

Suggested Prerequisites : Microsoft Excel

   What are the System requirements for this course ?

Windows 7 / Windows Server 2008 R2, or later, .NET 4.5, Internet Explorer 9 or later ,1 GB RAM 

CPU: 1 Gigahertz (GHz) or faster x86- or x64-bit processor 

   How will I execute the Practicals?

We will be installing Power BI Desktop from https://powerbi.microsoft.com/en-us/ . The Installation guide for Power BI shall be available. 

In case if you face any issues, we have 24x7 Expert Support to help you with your queries. 

   Which Case-Studies will be part of the course?

A Health Insurance company wants to Visualize the Financial performance of policies (based on policy type wise claims) and much more. 

They want to create an interactive dashboard that will contain the following:

  • Ticker – Count of Claim Policy
  • Gauge – Total Revenue
  • Aster Plot – Net Loss by Claim Policy 
  • Stacked Bar Chart – Total revenue by Claim Policy 
  • Line and Clustered Column Chart – Monthly Profit and Gross Loss by Claim Policy 
  • Map – Frequency of Claim Policy by Region

   Introduction to Power BI, Power Pivot, Power View, Power Map

Goal : 
Power BI is a suite of business analytics cloud-based tools to analyze data and share insights. Through this data, reports are accessible from anywhere with Power BI Mobile apps which update automatically with any changes to your data. Power View is an interactive data visualization tool. Power Map creates maps and tours of data visualization. Power Pivot creates in-memory data model. Get introduced to these tools and discuss its usage.

Objectives :
Upon completing this lesson, you should be able to:

  • Learn about Power BI
  • Explain the Building Blocks of Power BI
  • Brief about the concepts – Power Query, Power Pivot, Power View, Power Map, Power Q&A, and Power BI Desktop
  • List the major benefits of Power BI Tool


Topics :

  • Introduction to SSBI
  • SSBI Tools
  • What is Power BI?
  • Power BI – Flow of Activity
  • Building Blocks of Power BI
  • Power BI – Primary Tools : Power Pivot, Power Query, Power View, Power Map, Power Q&A, Power BI Desktop


Hands On/Demo :

  • Explore Power Pivot, Power Map and Power View
  • Explore Power BI Desktop

   Power BI Desktop

Goal : 
Power BI Desktop is one of the important components of Power BI. It provides with the facility of drag and drop to place the content where you exactly want it. Quickly discover patterns as you explore a single unified view of linked interactive visualizations.  At the end of this module you will be able to learn about different features of Power BI Desktop.

Objectives :
At the end of this module, you should be able to:
  • Know about Power BI Desktop
  • List Data Sources and Data Connections in Power BI Desktop
  • Know the Role of Query Editor in Power BI
  • Modeling Data


Topics :

  • Power BI Desktop – Install
  • Data Sources and Connections
  • Connect to Data in Power BI Desktop
  • How to use Query Editor in Power BI
  • Advanced Data Changes and Transformation
  • Views in Power BI Desktop
  • Modeling Data - Manage Data Relationship, Create Calculated Columns, Optimize Data Models


Hands On / Demo :

  • Install Power BI Desktop
  • Using Query Editor
  • Views in Power BI Desktop
  • How to Perform Data Modeling

   Data Analysis Expression(DAX)

Goal :
The Data Analysis Expressions (DAX) language is a formula language for Power Pivot, Power BI Desktop, and Tabular modeling in SQL Server Analysis Services (SSAS), which allows users to define custom calculations in PowerPivot tables (calculated columns) and in Excel PivotTables (measures). DAX includes some of the functions that are used in Excel formulas, and it includes additional functions that are designed to work with relational data and perform dynamic aggregation.

Objectives:
At the end of this module, you should be able to:

  • Explain Data Analysis Expressions (DAX)
  • Discuss DAX Calculation Types
  • Explore DAX Functions for Advanced Calculations
  • Illustrate Time Intelligence Functions
  • Discuss use of Variables in DAX expressions
  • Table Relationships in DAX


Topics :
  • What is DAX?
  • Data Types in DAX
  • Calculation Types
  • DAX Functions : Date and Time, Time IIntelligence, Information, Logical, Mathematical, Statistical, Text, Aggregate
  • Measures in DAX
  • Table Relationships and DAX 


Hands On / Demo:

  • Data Types in DAX
  • Calculated Columns
  • Explore DAX Functions such as Aggregation, Counting, Logical, Information, Text and so on
  • Creating Calculated Measure
  • Time Intelligence Functions
  • Table Relationships and DAX

   Data Visualization

Goal :
Data visualization is the presentation of data in a pictorial or graphical format. It enables decision makers to see analytics presented visually, so they can grasp difficult concepts or identify new patterns. With interactive visualization, you can take the concept a step further by using technology to drill down into charts and graphs, for more detail, interactively changing what data you see and how it’s processed.

Objectives :
At the end of this module you should be able to:
  • Explain the benefits of Data Visualization
  • Describe Best Practices of Data Visualization
  • Describe Power BI Desktop Visualization
  • Illustrate Custom Visuals in Power BI Desktop
  • Discuss Formatting Visuals in Power BI Desktop
  • Understand Charts, Score Cards, and other Visualization items in Power View


Topics :

  • Why Data Visualization
  • Practices for Data Visualization
  • How to use Visual in Power BI
  • Reports in Power BI
  • Charts in Power BI (Scatter, Waterfall, Funnel)
  • Slicers
  • Map Visualizations
  • Gauges and Single Number Cards
  • R Visuals in Power BI


Hands On/Demo :

  • Explore charts and various visualizations using Power BI

   Introduction to Power BI Q&A and Data Insights

Goal : 
Power BI Q&A is currently available as part of the Power BI for Office 365 Preview. It enables users to discover, explore and visualize their own enterprise data using natural language. Get introduced to Power Q&A in this module.

Objectives :

  • Describe Power Q&A
  • Create a Dashboard
  • Discuss Dashboard Tiles
  • Power BI Publisher for Excel
  • Connect Power BI Data in Excel
  • Discuss Data Insights in Power BI


Topics :

  • Power BI Q&A
  • Dashboard
  • Dashboard vs Reports
  • Creating a Dashboard
  • Dashboard Tiles
  • Pinning Tiles
  • Quick Insights with Power BI
  • Power BI Publisher for Excel


Hands On/Demo :

  • Explore Power BI  Q&A
  • Creating a Dashboard
  • Pinning a Tile to a Dashboard
  • Run Quick Insights on a Dataset
  • Pin a range to a Dashboard
  • Connect to Power BI Data in Excel

   Custom Visualizations

Goal : 
The Power BI Visuals gallery contains custom visualizations created by members of the community and by Microsoft. These visualizations can be downloaded and added to Power BI Service reports and Power BI Desktop reports. They behave just like the native visualizations included with Power BI; they can be filtered, highlighted, edited, shared, etc. Explore Power BI Visual gallery and illustrate how to use them in this module.

Objectives :

  • Define Custom Visualizations in Power BI
  • Illustrate the installation and use of Custom Visuals 
  • Explain how to add a custom visual to a report in Power BI Desktop
  • Publish Custom visuals to the office store
  • Explain Key Performance Indicator (KPI)
  • Describe Data Binding


Topics :

  • What Are Custom Visuals?
  • Office Store
  • Downloading Custom Visuals
  • Importing Custom Visuals in Power BI Report
  • KPI Visuals
  • Data Binding in Power BI


Hands On/Demo :

  • Custom Visualizations – Using Power BI
  • Adding Custom Visual to Report in Power BI Desktop
  • Publish Custom Visuals
  • Data Binding and formatting

   Power BI Embedded

Goal : 
Power BI Embedded enables you to integrate Power BI reports into your mobile and Web applications. It is an azure Service that allows ISVs and app developers to surface Power BI data experiences within their applications. It defers to your application to perform all the necessary user authentication and authorization. There is no explicit requirement that your end users be customers of Azure Active Directory (Azure AD). Instead, your application expresses to Microsoft Power BI Embedded authorization to render a Power BI report by using Application Authentication Tokens (App Tokens). (Content)

Objectives : 
At the end of this module, you should be able to:

  • Define Power BI Embedded
  • Explain Power BI Embedded Conceptual Model
  • Differentiate REST API
  • Explain How to authenticate and Authorize Row Level Security with Embedded Power BI


Topics :

  • Power BI Embedded Conceptual Model
  • Workspace Collection
  • Adding Power BI content to a Workspace
  • Application Authentication Tokens
  • Parts of Power BI embedded - REST API
  • Power BI Embedding without an Embed Token
  • Power BI Embedding with an Embed Token

  • Hands On :

    • Embedding with an embed token 
    • Authentication and Authorization of Row Level Security with Embedded Power BI

   Power BI Integration and Administration

Goal : 
The Power BI Integration page in Reporting Services Configuration Manager is used to register the report server with the desired Azure Active Directory (AD) . The requirements for Power BI Integration are Azure Active Directory and Managed Tenant. The Power BI cloud strategy is based on two principles: - Self-Service BI in which user create reports or dashboards without relying on any IT professional and the second is Sharing of data.

Objectives :

  • Explain Data Gateways
  • Discuss Content Packs


Topics :

  • Data Gateways 
  • Content packs
  • Power BI Report Server 


Hands On/Demo :

  • None

   What if I miss a class?

You will never miss a lecture at edureka! You can choose either of the two options:

  • View the recorded session of the class available in your LMS.
  • You can attend the missed session in any other live batch.

   Will I get placement assistance?

Certhippo is committed to provide you an awesome learning experience through world-class content and best-in-class instructors. We will create an ecosystem through this training, that will enable you to convert opportunities into job offers by presenting your skills at the time of an interview. We can assist you in resume building and also share important interview questions once you are done with the training. However, please understand that we are not into job placements.

   Can I attend a demo session before enrollment?

We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrolment is not possible. 

However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.

   Who are the instructors?

All instructors at Certhippo are senior industry practitioners with minimum 10 - 12 years of relevant IT experience. They are subject matter experts who trained by Certhippo to provide impeccable learning experience to all our global users.

   Certification

    • Once you are successfully through the project (Reviewed by a Certhippo expert), you will be awarded with Certhippo’s Power BI Expert certificate.
    • Certhippo certification has industry recognition and we are the preferred training partner for many MNCs including e.g. Cisco, Ford, Mphasis, Nokia, Wipro, Accenture, IBM, Philips, Citi, Ford, Mindtree, BNYMellon etc