Power BI

Course Features

Course Details

Description
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. myTectra's Power BI Training in bangalore 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.
Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc., Brillio and over 45,000 MNCs across 185 countries use Power BI
Who should go for this training?
The Power BI training at Iteanz 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
course outline:1.Introduction
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 while we use them.
Objectives : 
Describe Power BI
Illustrate Power Pivot
Discuss Power View
Describe Power Map
Topics :
Power BI - Define Power BI, Architecture, Evolution of Power BI from Power Query, Data mash up engine
Power Pivot - Why Power Pivot, Versions and relationships
Power Map - Why Power Map, 3-D visualization with Power Map
Power View - Why Power View, Sorting, Filtering techniques in Power View
Hands on : How to acquire data from azure database
Explore Power Pivot, Power Map and Power View
2. Power BI Desktop
Goal : Power BI Desktop is one of the important features 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. This module also introduces you to Power query which is used to search data online. At the end of this module you will be able to learn about different features of Power BI Desktop and Power Query.
Objectives : At the end of this module, you should be able to:
Define Power Query
Learn about features of Power Query
Define Power BI Desktop
Learn How to get Data from different data Sources
Learn How to use Query Editor
Understand Modelling data and Relationships
Create Calculated Measures
Differentiate Power Pivot in Power BI Desktop with other components
Analyze Power View Difference in Power BI Desktop
Topics :
Database Sources
Xml
Folder
CSV File
Hands on/ Demo :
Explore Power BI Desktop and relationships
3.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 : 
Define Data Analysis Expressions (DAX)
Define Calculated members
Differentiate between Row Context and Set Context
Use Calculate Functions for Advanced Calculations
Illustrate Time Functions
Discuss Advanced DAX
Topics : 
Functions
Date and Time
Time Intelligence
Information
Logical
Mathematical
Statistical
Text
Aggregate
Hands On / Demo: 
Explore DAX Expressions like Calculate, Evaluate, Error, IIF, Replace, Compute, Table Level Functions
4.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: 
Define 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
Hands On / Demo: Explore charts and various items in data Visualization.
5.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
Design best practices for Power Q&A
Topics : 
Power BI Q&A : Why Power BI Q&A
Data Insights: Power BI adapter, Export Analytics Queries, Continuous export and Stream Analytics
Hands On/Demo :
Explore Power BI Q&A
6.Developing Custom Visualizations in Power BI
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 :
Explain the Visual Life-Cycle
Explain Developer Tools
Use functions like Init, Update and Destroy
Define Data Binding
Define Formatting
Topics :
Functions in Custom Visualizations
Init
Update
Destroy
Hands On/Demo :
Use Power BI Visuals Gallery
7.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 :
Define Power BI Embedded
Explain Power Bi Embedded Conceptual Model
Differentiate REST API and .NET API
Explain How to authenticate and Authorize Row Level Security with Embedded Power BI
Illustrate How to Embed a Power BI report with an I Frame
Discuss How to connect a data source and Interact with reports
Topics :
Parts of Power BI embedded
REST API
.NET API
8.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 :
Express features of SSRS 2016
Illustrate integration of SSRS reports with Power BI
Explain Data Gateways
Discuss Content Packs
Topics :
Requirements of SSRS
Installation of SQL Server 2016
Power BI account
Register SSRS with Power BI account
Pin SSRS Visuals and SQL Server agent
Data Gateways: 
Personal
On Premises
Hands On/Demo :
Integration of SSRS Report with Power BI
This course does not have any sections.

More Courses by this Instructor