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
Instructor
Mike
- Description
- Curriculum
- Reviews
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
Introduction to Power BILearning 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
-
2
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
-
3
Data Analysis Expressions (DAX)
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
-
4
Data Visualization
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
-
5
Introduction to Power BI Q
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
-
6
Direct Connectivity
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
-
7
Integrating Power BI and Azure ML
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
-
8
In-class Project
Goal:
- The aim of this module is to provide you hands-on experience in Reinforcement Learning
Please, login to leave a review
