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
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
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
Hands on/ Demo : Explore Power BI Desktop and relationships
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
Hands On / Demo: Explore DAX Expressions like Calculate, Evaluate, Error, IIF, Replace, Compute, Table Level Functions
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.
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
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
Hands On/Demo : Use Power BI Visuals Gallery
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
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
Hands On/Demo : Integration of SSRS Report with Power BI