DataCraft Solutions Ltd

This 2- day virtual course gives an introduction into the Power BI tools when analysing data from databases, Excel worksheets and other sources. It includes using the Query Editor to prepare data prior to loading to the report and Data Analysis Expressions (DAX) calculations; the formula language that extends the data manipulation capabilities. We also look at the model structure and the importance of relationships to data utilisation. A report will be created using standard Power BI visualisations, with an introduction to the formatting features.

Not only will the instructor lead you through using the report creation tools, but delegate will have the opportunity to work through activities to enforce the learning. 

Post course attendees will receive a set of reference notes too.

Delegate Pre-Requisites

No Prior use of Power BI is required. Delegates should be experienced excel users, comfortable writing formulas using aggregates such as SUM, COUNT, AVERAGE. Use of Logic functions and Lookup functions would be beneficial, as well as any understanding of databases.

The core focus of this day is to create reports using Power BI Desktop; therefore, delegates should make sure they have the application installed on their machines.

Target Audience

This one-day course is ideal for those looking to gain a fundamental understanding of how to produce powerful visual reports by using the Power BI desktop.

Course Delivery Mode

Our Standard virtual delivery is via Microsoft Teams. Course timings are 09:30 - 16:30 (UK time) 

Course Content

Prepare your date using the Query Editor

• Overview of Query Editor
• Remove Rows & Columns
• Add Columns
• Using the Transformation tools
• Understanding Applied Steps
• Choosing which queries are loaded
• Creating Groups (Folders)
• Using Merge & Append queries 

Working with your model

• Importing data
• Working with relationships
• Creating basic calculations using Dax
• Applying Filters
• Managing Visual Interaction
• Working with hierarchies & drilldown features
• Using Grouping & Binning
• Data Source Connections 

Using the Report

• Power BI Desktop options
• Publish a report to the Power BI Service
• Share a report
• Create a Report in the cloud
• Create a tile dashboard
• Introduction to Workspaces
• Managing Workspaces

Cost per person £695.00

Upcoming Public Schedule Course Dates:

August 27th - 28th

September 12th & 13th

October 10th & 11th