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