Power BI is an analytics tool developed by Microsoft that turns your bits of unstructured data into a visually compelling story. It consists of the Power BI Desktop, the SaaS Power BI Service, and a range of mobile apps (iOS and Android compatible). These tools take big data and help your business or organization ask the right questions and receive actionable insights.

Power BI takes information from disparate 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. The right data visualization can be the difference between having unstructured data that disappears and using that data to make critical (and more importantly, correct) decisions.

Microsoft Power BI is one of the most robust business intelligence platforms available for data modeling . It uses real-time Power BI dashboards to sort through and present data from multiple sources, giving businesses a better handle on their customers, operations, and future.

Proficiency in Power BI and DAX allows you to create real value for a business, not just gather the numbers. Whether it's a simple Excel files, working with a SQL server, or a complicated collection of on-premises data and cloud data, Power BI can sort it all out.

The British Academy for Training and Development offers this course to the following categories:

• Anyone who will be creating Power BI Desktop models.
• Both non-technical 'power users' and IT Professionals who will be creating models.
• Anyone who is familiar with Microsoft Office applications and who needs to work with data to be able to connect, process and analyze the data to produce suitable output at all levels within an organization.
• Data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI.
•  Individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.
• Anyone who will be consuming reports and sharing using Power BI Service.
• Anyone whose role requires them to use existing Power BI Reports or Dashboards to consume the contents.

After completing the program, participants will be able to master the following topics:

• Understand Power BI Concepts and Main Features
• Understand Data Sources compatible with Power BI Desktop
• Connecting to Data with Power BI Desktop
• Loading Excel Data into Power BI Desktop
• Apply Common Query Tasks to Shape Data in Power BI
• Explore Data Visualizations
• Work with Report formats and elements

• Power BI concepts and overview.
• Introduction to main features
• Using Get Data to connect to Excel workbooks
• Selecting the data to use
• Overview of Relationships in Power BI Desktop
• Setting the Data Type and Properties.
• Data Visualizations
• Filters and Queries
• Using Delimiters
• Tables and Matrices
• Charts
• Interactive Slicers
• Get Data and Query Editor
• Combining Data Sources as a Mash Up
• Merge Data Tables
• Working with Relationships in Data
• Activities using Query Editor
• Creating Custom Calculated Columns
• Adding Conditional Columns
• Introduction to DAX Expressions and Formula
• Histograms
• Forecast
• Create Measures
• Data Categories, Geo-Data and Maps
• Report Elements and Options
• Working with Pages
• Visual and Filter Settings
• Edit Interactions
• Bookmarks
• Report Themes
• Buttons and Q&A