Power BI training 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
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 dataset which contains data from different Airlines. You have gathered the requirement from the client on the analysis that has to be performed using the dataset. 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.
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 ProICT 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 ProICT 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:
Suggested Prerequisites:
- Experience navigating the Microsoft Windows Environment
- Experience with Microsoft Excel Pivot Tables and Pivot Charts is desirable
- 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.
ProICT’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.
You will never miss a lecture at ProICT! 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 ProICT are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by ProICT for providing an awesome learning experience to the participants.
You no longer need a credit history or a credit card to purchase this course. Using ZestMoney, we allow you to complete your payment with a EMI plan that best suits you. It's a simple 3 step procedure:
- Fill your profile: Complete your profile with Aadhaar, PAN and employment details.
- Verify your account: Get your account verified using netbanking, ekyc or uploading documents
- Activate your loan: Setup automatic repayment using NACH to activate your loan
Our Pricing (USD)
Power bi training and certification
Apply Coupon
