f

Microsoft Power BI Training at

 will help you achieve expertise in business analytics. At the end of this course, you will master the concepts like Power BI Desktop, Power BI DAX, Power BI Q&A, Power BI Content packs, Power BI Custom Visuals, Power BI Integrations with Azure Machine Learning and SQL Services.

  • 128K + satisfied learners. Reviews
Weekend $314
Weekdays

Training Features

Instructor-led Sessions

27 Hours of Online Live Instructor-Led Classes. Weekend Class : 09 sessions of 3 hours each.


Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various Power BI concepts.


Lifetime Access

You get lifetime access to Learning Management System (LMS) where presentations, quizzes, installation guide & 


24 X 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.


Certification

Sucessfully complete your final course project and Certpine will certify you as a Business Analyst using Power BI.


Forum

We have a community forum for all our customers that further facilitates learning through peer interaction and knowledge 


Course Description

Certpine’s Microsoft Power BI Training introduces you to Power BI Desktop and how it is used with Power Pivot for Data Modelling. This course enables you to learn about Data Analysis Expressions (DAX) and Data Visualization with Power BI Desktop, Power View and Power Map. This course will also introduce you to Power BI Q&A, which enables you to discover, explore and visualize enterprise data using Natural Language.

Power BI is a business analytics service provided by Microsoft. 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 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.

Microsoft Power BI Training will help you to become a Power BI expert. It will enhance 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
  • Learn about Power Pivot, Power View, Power Map etc
  • Understand 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
  • Understand and use Data Gateways, Content packs, Power BI Report Server

The Microsoft Power BI Training at Certpine 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 Manager

As such, there is no prior Technical Knowledge required to learn Power BI. However, if you have experience with a fundamental understanding of Microsoft Excel and formulas will be an advantage. 

Suggested Pre-requisites:

  • Microsoft Excel
  • Python

To help you brush up concepts of R and Python Scripts, we will give you self-paced videos absolutely free in your LMS.

Project

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 an 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.

Curriculum

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

Topics:
  • Business Intelligence
  • Self Service Business Intelligence
  • SSBI Tools
  • What is Power BI
  • Why Power BI?
  • Key Benefits of Power BI
  • Flow of Power BI
  • Components of Power BI
  • Architecture of Power BI
  • Building Blocks of Power BI

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

Topics:
  • Overview of Power BI Desktop
  • Data Sources in Power BI Desktop
  • Connecting to a data Sources
  • Query Editor in Power BI
  • Clean and Transform your data with Query Editor
  • Combining Data – Merging and Appending
  • Cleaning irregularly formatted data
  • Views in Power BI Desktop
  • Modelling Data
  • Manage Data Relationship
  • Cross Filter Direction
  • Create calculated tables and measures
  • Optimizing Data Models

Learning Objective: This module will help you learn the basics of DAX in Power BI Desktop. 

Topics:
  • Essential concepts in DAX
  • Why is DAX important?
  • DAX Syntax
  • Data Types in DAX
  • Calculation Types
  • DAX Functions
  • Measures in DAX
  • DAX Operators
  • DAX tables and filtering
  • DAX queries
  • DAX Parameter Naming

Learning Objective: This module will help you understand the benefits and best practices of Data Visualization. It will also help you in creating charts using Custom Visuals. 

Topics:
  • Introduction to visuals in Power BI
  • Charts in Power BI
  • Matrixes and tables
  • Slicers
  • Map Visualizations
  • Gauges and Single Number Cards
  • Modifying colors in charts and visuals
  • Shapes, text boxes, and images
  • What Are Custom Visuals?
  • Page layout and formatting
  • KPI Visuals
  • Z-Order

Learning Objective: This module will help you in creating Dashboards and publishing it on Power BI services. You will also be taught to monitor Real-time Data with REST API. 

Topics:
  • Introduction to Power BI Service
  • Dashboard vs. Reports
  • Quick Insights in Power BI
  • Creating Dashboards
  • Configuring a Dashboard
  • Power BI Q&A
  • Ask questions of your data with natural language
  • Power BI embedded

Learning Objective: This module will help you learn, how to connect data sources directly to Azure, HD Spark, My SQL, and create interactive dashboards. 

Topics:
  • Introduction to using Excel data in Power BI
  • Exploring live connections to data with Power BI
  • Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ My SQL
  • Introduction to Power BI Development API
  • Import Power View and Power Pivot to Power BI
  • Power BI Publisher for Excel
  • Content packs
  • Introducing Power BI Mobile

Learning Objective: This module will help you understand about Power BI Report Servers and data gateways. Also, you will learn about the web portal in which you display and manage reports and KPI’s. 

Topics:
  • Report Server Basics
  • Web Portal
  • Paginated Reports
  • Row level Security
  • Data Gateways
  • Scheduled Refresh
  • Resources (Rest API/ SOAP API’s/ URL Access)

Learning Objective: This module will help you create R and Python visuals in Power BI Desktop as well as in Power BI Service. 

Topics:
  • R Integration in Power BI Desktop
  • R visuals in Power BI
  • R Powered Custom Visuals
  • Creating R visuals in Power BI
  • R Visuals in Power BI Service
  • R Scripts Security
  • Creating visual using Python

Learning Objective: Here in you will develop an exhaustive project where you will incorporate all your learnings of Power BI. At the end of this module, you should be able to learn to incorporate various features as per the requirements of your Enterprise.

FAQ's

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

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

Post-enrolment, the LMS access will be instantly provided to you and will be available for lifetime. You will be able to access the complete set of previous class recordings, PPTs, PDFs, assignments. Moreover the access to our 24x7 support team will be granted instantly as well. You can start learning right away.

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

Certification

  • Once you are successfully through the project (Reviewed by an addiLEARN expert), you will be awarded with addiLEARN’s 'Business Analyst using Power BI' certificate.
  • addiLEARN'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.