This course designed to give you an end to end view of all Power BI components and tools. In this course, you will learn all modules of Power BI; from Getting Data with Power Query, Doing data Modeling and DAX, Visualization in Power BI Desktop, Publishing and Sharing content in Power BI Service, and Refreshing Dataset and Security. This course designed in a way that by completing it, you will have a full understanding of all components in Power BI and you will know how these components work together.
Power BI is the newest Microsoft Business Intelligence and Data Analysis tool. In this module we will go through basics of this product, and introduce all five components of Power BI (Power Query, Power Pivot, Power View, Power Map, and Power Q&A). You will see some demos and introduction about Power BI desktop, Office 365 Power BI subscription, and Power BI website, and mobile apps. You will see some basic demos of how easy to use is Power BI in some scenarios.
- Power BI Essentials Agenda
- Introduction to Power BI; What is Power BI?
- Power BI Desktop the First Experience
- Power BI Website; You’ll Just Need a Web Browser
Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on cloud. For some data sources you can have a live or direct connection, for some connection works offline. For some connections you need a gateway or connector to be installed. In this module you will learn everything about get data experience of Power BI.
- Introduction to Power Query
- Get Started with Power Query; Movies Data Mash Up
- Get Data From Excel
Data analysis and BI world starts from data extraction and transformation. Power Query is the data transformation engine of Power BI. Power Query comes as part of Excel 2016, or as an add-in for Excel 2013 and 2010. Power Query is also part of Power BI Desktop. In this module you will learn about all different version of Power Query, their similarities, and differences, as well as configuration and requirements of using them. Power Query uses a graphical user interface to apply transformations on the dataset. However Power Query works with a functional scripting language behind the scenes. The key to learn Power Query is learning the functional language called M. There are many features in M that are not available in the Power Query GUI. In this module you will learn how to understand M, and how to write M scripts even from scratch. You will learn writing custom functions in M as well as many other useful features.
- Power Query Formula Language
- Power Query Function’s Library; #shared Keyword
- Writing Custom Functions
- Generators and EACH; Explored Through an Example
- Error Handling in Power Query
- Date Dimension with Power Query
- Fitbit Data Integration with Power Query
Power Pivot is xVelocity in-memory data modelling engine of the Power BI. Modelling effectively is the key of high performance BI solution. In this module you will learn basics of Power Pivot such as creating relationships, and calculated members, as well as advanced best practices and DAX expressions. DAX is Data Analytical eXpression language. DAX has similar structure to excel functions, but it is different. In this module you will learn DAX from beginner to advance. You will learn basic functions as well as complex functions and scenarios of using them in real world challenges.
- Data Modeling and Relationships
- Formatting Data Fields
- Sort By Column
DAX, or Data Analysis eXpression is the language for querying and creating calculated measure and columns and tables in Power BI, SSAS Tabular, and Power Pivot. So one of the critical learning path for Power BI is learning DAX. In this lesson you learn basics of DAX and also some examples of using time intelligence functions in real world.
- Calculated Columns and Measures
- Secret of Time Intelligence Functions in Power BI
- CALCULATE function for Time Intelligence
- Rolling 12 Months Calculation
- Modeling Best Practices
- Scenarios of Using Calculated Tables
- DAX Time Zone Issue in Power BI
Data Visualization is the front end of any BI application, this is the user view point of your system. It is critical to visualize measures, and dimensions effectively so the BI system could tell the story of the data clearly. In this module you will learn conceptual best practices of data visualizations which is valid through all data visualization tools. You will learn Power View and Power Map skills. Power View is the interactive data visualization tool and Power Map is 3D geo-spatial data visualization tool. You will learn how to create effective charts, and dashboards using these tools as well as best practices for working with these tools. There are two version of Power View; Power View for Excel, and Power View for SharePoint which will be covered in this module as well.
- Built-in Visualizations
- Scatter Chart
- Waterfall Chart
- Map Visualization
- Filled Map; the Good, the Bad, and the Ugly
- Shape Map
- Custom Visuals
- KPIs and Power BI; Visualization Aspect
Power BI introduced a new engine for users which focus on users who wants to play with the data more, and understand the story behind the data better. Power Q&A is question and answering engine which works based on human natural language. Power Q&A automatically will be enabled on Power BI files deployed into Power BI website, or Office 365 subscription. However there are some tips and tricks about how to design your model to get the best type of answers through Power Q&A. In this module you will learn best practices for modelling that effect on the response of Power Q&A.
- Power Q&A; How to Ask Questions?
- Improve Q&A with a Better Data Model
Power BI can connect to cloud data sources and also on-premises data source. For on-premises connection you need to install and configure gateways on the on-premises servers or machine, and Power BI creates the connection based on that. In this module you learn about different types of gateways and how to set up them for an on-premises data access from Power BI.
- Import Data vs DirectQuery
- Power BI Gateways
- On-Premises Data Gateway and SSAS Tabular Live Connection
In this module you will learn how to use work groups and sharing in Power BI to share dashboards, reports, and data set within Office 365 group. You will also learn how to implement row level security in different levels. You will learn implementing row level security in Power BI Desktop, or in a data source of SSAS Tabular Live connection, or dynamically.
- Sharing Dashboards
- Groups in Power BI
- Row Level Security in Power BI
- Row Level Security with SSAS Tabular Live Connection
- Dynamic Row Level Security Free Preview
- Wrap Up