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

Home   >    All Courses   >   Business Intelligence and Visualizations   >   Microsoft Power BI Training

Microsoft Power BI Training

SUPPORT NO. +1 302 956 2015 (USA)

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. Weekday Class: 12 sessions of 2 hours each.

Real-Life Case Studies

Towards the end of the course, create an interactive dashboard for visualization 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 a ticket based tracking system.

Certification

addiLEARN certifies you as 'Business Analyst using Power BI' based on your project performance, reviewed by our expert panel.

Forum

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

This Microsoft Power BI training introduces you to Power BI and how it is used for data mashup along with Power Pivot for Data Modeling. This course also enables you to learn about Data Analysis Expressions (DAX) and Data Visualization with Power BI Desktop, Power View and Power Map. Power BI Q&A enables the user to discover, explore and visualize their own enterprise data using Natural Language. This course enhances various Programmability and Extensibility features like .Net integration with Power BI and Integrating Power BI with SSRS reports as well as Microsoft Azure for machine learning.

Microsoft Power BI Training by Edureka is designed by industry experts to make you a Certified Power BI Practitioner. After completing this Microsoft Power BI Training course, you should be able to:

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

·         Describe Power BI Desktop and Power Query

·         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

·         State Power BI Administration

·         Create real-time dashboards

·         Publish reports/dashboards and share them with others

·         Directly connect to Azure SQL, HD Spark, SSAS

·         Integrate Power Bi with Azure ML

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 modeling capabilities, including data preparation, data discovery and interactive dashboards.

Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc., Brillio and over 45,000 MNCs across 185 countries use Power BI. These are few of the reasons why Microsoft Power BI Training comes in handy.

Microsoft Power BI Certification Training will help you to become a Power BI expert. It will hone your skills by offering you comprehensive knowledge on Power BI, and the required hands-on experience for solving real-time industry-based Power BI projects. 

 

During Power BI course you will be trained by our expert instructors to:

·         Master concepts like Data Visualization and Integration

·         Use Power Pivot, Power View, Power Map etc

·         Implement DAX and SSBI

·         Use and implement Custom Visuals

·         Explore Power BI Q&A

·         Perform Data Binding and Formatting

·         Master Power BI Embedded and Workspace Collection

·         Use Data Gateways, Content packs, Power BI Report Server

The Microsoft Power BI Training at Edureka is for all the professionals who are passionate about business intelligence, data visualization, and data analytics. It is best suited for:

·         Business Analysts

·         Business Intelligence Manager

·         Statisticians and Analysts

·         Data Scientists

·         Project Managers

Required Prerequisites:

·         Experience navigating the Microsoft Windows Environment

·         Experience with Microsoft Excel Pivot Tables and Pivot Charts is desirable

 

Suggested Prerequisites:

·         Microsoft Excel

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

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

For Practical’s, we will help you to sign up and create account on Microsoft Power BI to activate Power BI services. We will also help you out to install and set up Power BI Desktop as well.

Certhippo’s Microsoft Power BI  Training includes multiple real-time, industry-based projects, which will hone your skills as per current industry standards. Below are some of the Case Studies covered in this course:


Case Study #1

Domain: Retail

Problem Statement: You are a Senior Data Analyst with Yarnger, a global Retail organization. You’ve been asked to create a high-level, interactive, Weekly Review dashboard for a retail business. You have been provided with sales data, and you have completed all the clean-up and enrichment in the previous module. You’re now ready to create the visualizations and views that are interactive, insightful and useful.

Case Study #2

Domain: Banking

Problem Statement: Churn of banking customers is the biggest talk at corporate offices of any banking and financial company in the world. You work directly with the managing director of a leading consumer bank of Europe, and you lead an actuarial team of twenty people working on consumer data. Your team member Ajay sent you an email with the data of 8000 customers with their unique identification as ‘customerId’ and many more details that need your attention. The Managing Director has asked about loss of customer accounts in some countries and the reasons behind them. Although, Ajay has been able to isolate the country wise data of branches losing customers, however, he hasn’t been able to do narrow down to the reason of loss from that data. When you looked at the data you found that even the data needs to be verified by the Azure server. Now the MD has asked Ajay to share a one-page analysis within 24 hours with him about the possible reasons for the churn. Due to time constraint, you have taken it upon yourself to do the analysis and understand the data from Ajay.

Learning Objective: This module will introduce you to Power BI, its Building Blocks and the various fundamental concepts of Power BI. 

 

Topics:

·         Overview of BI concepts

·         Why we need BI?

·         Introduction to SSBI

·         SSBI Tools

·         Why Power BI?

·         What is Power BI?

·         Building Blocks of Power BI

·         Getting started with Power BI Desktop

 

Hands-On:

·         Explore Power BI Desktop

·         First Report on Power BI Desktop

Learning Objective: This module will introduce you to Power BI Desktop, extract data from various sources and establish connections with Power BI Desktop, perform Transformation operations on data and know the Role of Query Editor in Power BI. 

 

Topics:

·         Power BI Desktop

·         Extracting data from various sources

·         Workspaces in Power BI

·         Data Transformation

·         Measures and Calculated Columns

·         Query Editor

 

Hands-On:

·         Install Power BI Desktop

·         Data Transformation

·         Using Query Editor

Learning Objective: This module will help you understand the relationships between data tables, and you will learn the following - DAX Calculation Types, DAX Functions for Advanced Calculations, Time Intelligence Functions, Variables in DAX expressions and Table Relationships in DAX 

 

Topics:

·         Modelling Data

·         Manage Data Relationship

·         Optimize Data Models

·         What is DAX?

·         Data Types in DAX

·         Calculation Types

·         DAX Functions: Date and Time, Time Intelligence, Information, Logical, Mathematical, Statistical, Text and Aggregate

·         Measures in DAX

 

Hands-On:

·         Create relationships

·         Calculated Columns

·         Data Types in DAX

·         Explore DAX Functions such as Aggregation, Counting, Logical, Information, Text

·         Creating Calculated Measure

·         Time Intelligence Functions

Learning Objective: This module will help you understand the benefits of Data Visualization, Best Practices of Data Visualization, Power BI Desktop Visualization, Custom Visuals in Power BI, Formatting Visuals and create Charts, Score Cards and other Visualization items in Power View 

 

Topics:

·         How to use Visual in Power BI?

·         Charts in Power BI

·         Matrixes and tables

·         Slicers

·         Map Visualizations

·         Gauges and Single Number Cards

·         R Visuals in Power BI

·         What Are Custom Visuals?

·         KPI Visuals

·         Data Binding

·         Power BI report server

Learning Objectives: This module covers Power BI Q&A which is currently available as part of the Power BI for Office 365 Preview. You will also learn about Dashboards, Reports, Tiles Quick Insights and Power BI Publisher. 

 

Topics:

·         Why Dashboard?

·         Dashboard vs Reports

·         Creating Dashboards

·         Configuring a Dashboard: Dashboard Tiles, Pinning Tiles

·         Power BI Q&A

·         Quick Insights in Power BI

·         Power BI embedded

·         REST API

 

Hands-On:

·         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

·         Monitor Real-time Data with REST API

Learning Objectives: In this module, you will be connecting directly to Azure, HD Spark, My SQL, and create interactive dashboards. 

 

Topics:

·         Custom Data Gateways

·         Exploring live connections to data with Power BI

·         Connecting directly to SQL Azure, HD Spark, and SQL Server Analysis Services/ My SQL

·         Introduction to Power BI Development API

·         Excel with Power BI: Connect Excel to Power BI, Power BI Publisher for Excel

·         Content packs

·         Update content packs

 

Hands-On:

·         Connecting Power BI with Azure, HD Spark, SSAS

·         Use the developer API to create custom visuals

·         Connecting Excel to Power BI

·         Creating content packs

Learning Objectives: In this module, you will learn to integrate Azure Machine Learning model inside Power BI. Using Azure ML, Power BI regularly brings in the latest output of business model for analysis. 

 

Topics:

·         Extracting data out of Azure SQL using R

·         Using R, call the Azure ML web service and send it the unscored data

·         Writing the output of the Azure ML model back into SQL

·         read scored data into Power BI using R

·         Publishing the Power BI file to the Power BI service

·         Scheduling a refresh of the data using the Personal Gateway

 

Hands-On:

·         Extracting data from Azure SQL using R

·         Calling Azure ML web service using R

·         Writing the Output of the Azure ML back to SQL

·         Reading scored data into Power BI

·         Publishing the file to Power BI service

·         Scheduling a refresh of the data

You have been given a data set which contains data from different Airlines. You have gathered the requirement from the client on the analysis that has to be performed using the data set. The analysis is for different airports from which the airlines depart and arrive. The average delay time of an airline over a period of time and more.

You will never miss a lecture at Certhippo! 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.

To help you in this endeavor, we have added a resume builder tool in your LMS. Now, you will be able to create a winning resume in just 3 easy steps. You will have unlimited access to use these templates across different roles and designations. All you need to do is, log in to your LMS and click on the "create your resume" option.

We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrollment 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 a class.

All the instructors at Certhippo are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by Certhippo for providing an awesome learning experience to the participants.

You can give us a CALL at +91- 989 926 9264(India) / 1800-688-5897 (US) OR email at support@Certhippo.org

    • Once you are successfully through the project (Reviewed by an Certhippo expert), you will be awarded with Certhippo’s 'Business Analyst using Power BI' certificate.
    • Certhippo's certification has industry-wide recognition and we are the preferred training partner for various MNCs including Cisco, Ford, Mphasis, Nokia, Wipro, Accenture, IBM, Philips, Citi, Mindtree, BNYMellon and many more.