Lesson 1: Introduction to Power BI, Power Pivot, Power View, Power map
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 its usage.
o Introduction to SSBI SSBI Tools
o What is Power BI?
o Power BI – Flow of Activity
o Building Blocks of Power BI
o Power BI – Primary Tools : Power Pivot, Power Query,
o Power View, Power Map, Power Q&A, Power BI Desktop.
Lesson 2: Power BI Desktop
Power BI Desktop is one of the important components 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. At the end of this module you will be able to learn about different features of Power BI Desktop
o Power BI Desktop – Install Data Sources and Connections
o Connect to Data in Power BI Desktop
o How to use Query Editor in Power BI
o Advanced Data Changes and Transformation? Views in Power BI Desktop
o Modeling Data - Manage Data Relationship, Create
o Calculated Columns, Optimize Data Models
Lesson 3: Data Analysis Expressions (DAX)
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.
o What is DAX?
o Data Types in DAX
o Calculation Types
o DAX Functions : Date and Time, Time Intelligence
o nformation, Logical, Mathematical, Statistical, Text, Aggregate Measures in DAX
o Table Relationships and DAX
Lesson 4: Data Visualization
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
o Why Data Visualization Practices for Data Visualization
o How to use Visual in Power BI
o Reports in Power BI
o Charts in Power BI (Scatter, Waterfall, Funnel)
o Map Visualizations
o Gauges and Single Number Cards
o R Visuals in Power BI
Lesson 5: Introduction to Power BI Q&A and Data Insights
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.
o Power BI Q&A Dashboard
o Dashboard vs Reports
o Creating a Dashboard
o Dashboard Tiles
o Pinning Tiles
o Quick Insights with Power B
o Power BI Publisher for Excel
Lesson 6: Custom Visualizations
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.
o What Are Custom Visuals?
o Office Store
o Downloading Custom Visuals
o Importing Custom Visuals in Power BI Report
o KPI Visuals
o Data Binding in Power BI
Lesson 7: Power BI Embedded
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).
o Power BI Embedded Conceptual Model Workspace Collection
o Adding Power BI content to a Workspace
o Application Authentication Tokens
o Parts of Power BI embedded - REST API
o Power BI Embedding without an Embed Token
o Power BI Embedding with an Embed Token
Lesson 8: Power BI Integration and Administration
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.
o Data Gateways Content packs
o Power BI Report Server