Module 1: Introduction to Power BI

Power BI is the analytics tool. This provides interactive visualizations and business intelligence capabilities with simple interface for users to create their own reports and dashboards. It is the data visualization and business intelligence tool that converts data from different sources to interactive dashboards.

Module 2: Getting Data

The first experience of working with Power BI is getting data. For some data sources you can have a live or direct connection and some connections work offline. Power BI takes information from data sources and turns them into custom visuals designed to help an organization not only read the info but get a clear idea of what to do. Here you can connect too many data sources on-premises or on cloud. In this module you will learn everything about getting data experience in Power BI.

Module 3: Power Query for Data Transformation

Power BI (including Power Query & Power Pivot) is the biggest Excel news item in the last 10 years. Power Query is the data transformation and data preparation engine of Power BI. Power Query is also part of Power BI Desktop. With Power Query you can import or connect external data. In this module you will learn about all different versions of Power Query, their similarities, and differences, as well as configuration and requirements of using them.

Module 4: Power Pivot for Data Modeling

Power Pivot is an in-memory data modeling component that enables highly-compressed data storage and extremely fast aggregation and calculation in Power BI. Modeling effectively is the key to a high performance BI solution. Here you will learn the basics of Power Pivot such as creating relationships, and calculated members, as well as advanced best practices and DAX expressions. You will learn the basics of data modeling using DAX and creating live dashboards for reporting in real world challenges.

Module 5: Data Visualization with Power View, Power BI Desktop and Power Map

Power BI is the data visualization tool. Data Visualization is the front end of any BI application; this is the user view point of your system. This tool allows you to embed your custom visualization into your website or app. In this module you will learn conceptual best practices of data visualizations which are valid through all data visualization tools. You will possess Power View and Power Map skills. Power View is the interactive data visualization technology that lets you to create interactive charts, graphs and maps. Power Map is a 3D geo-spatial data visualization tool. You will learn how to create effective dashboards and charts using these tools as well as best practices for working. Also two versions of Power View; Power View for Excel, and Power View for SharePoint which will be covered in this module as well.

Module 6: Designing the best solution with Power Q&A

How Power Q&A works? Power BI Q&A searches through all the reports, datasets, and visualizations on a selected workspace to come up with the best results. Thus, as you formulate your question, the answer will change as more and more details are typed. Power Q&A is a 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. There are some tips and tricks you need to know about how to design your model to get the best answers through Power Q&A and in this module you will learn best practices for modeling that effect on the response of Power Q&A.

Module 7: Power BI Desktop; combination of three tools

Power BI Desktop combines interactive visualizations. This is the new tool that enhances the combination of Power Query, Power Pivot, and Power View components. Power BI Desktop has great features that will be fully explored in this module. You will learn the differences between the original version and Power BI Desktop. You will also learn how to use Power BI desktop to mash up data, model it, and visualize it. Best practices of design will be all discussed with demos.

Module 8: Administration

Power BI components can be deployed into different environments such as Power BI website, Office 365 subscription. In module – 8, we will go through configurations, deployment options and requirements required for each environment. You will know how to deploy your Power BI files into the Power BI website. These three elements – Power BI Desktop, the service, and the mobile apps are designed to let you create, share, and consume business insights in the way that serves you and your role most effectively. You will gain the skills to work with these three elements.