FORGOT YOUR DETAILS?

Power BI

A Complete Introduction to Power BI
2-Day Live Online Course

An overview of Power BI for desktop analysis

Course dates

Please call us to arrange a date

Duration

2-day course

Format

Delivered live online by a trainer

Price

£595 plus VAT per person

A Complete Introduction to Power BI - 2-Day Course

Our comprehensive 2-day course is designed to kick-start your journey with Microsoft Power BI! In just two days, you'll learn to create visually compelling, interactive reports and dashboards that can transform raw data into powerful insights, helping you make informed decisions and drive meaningful business outcomes.

Small class sizes of no more than 8 participants ensure a supportive learning environment, with ample opportunities for personalised guidance and hands-on practice.

Our 2-day course is available both as a flexible online session, open to individuals from anywhere, and as a virtual 'in-house' option for organisations looking to train their teams. For those interested in advancing further, we offer an additional 3 modules in our Advanced Power BI course.

Book course or request more information. 

2-Day Course Content

Module 1 - Other Data Sources & Relationship Theory

· What is Power BI and when do I use it?
· Power BI Desktop installation and versions
· Important Information About Power BI Updates
· The Power BI service
· Power BI Report Server
· Understanding Reports, Datasets and Dashboards
· Overview of Power BI, Power Pivot and Power Query
· The Building blocks of Power BI Desktop
· Creating and saving PBIX files
· Methods of loading data

Module 2 - More Advanced DAX:

· Importing a variety of data sources into Power BI Desktop
· Connecting to Excel Workbooks
· Connecting to CSV Files
· Understanding the Data Model view
· Creating relationships
· Editing relationships
· Using Data View to sort and Format data
· Exploring the importance of custom calculation within the Data Model
· Creating a simple DAX Measure

Module 3 - Report Visuals:

· Using Report View to create visualisations
· Using the Visualisations Pane
· Using the Fields Pane
· Interacting with Visualisations
· Changing the Visualisation Type
· Moving and Resizing Visualisations
· Formatting Visualisations
· Removing a Visualisation
· Sorting data
· Changing Themes

Module 4 - Introduction to DAX Fundamental Principals

· What is a DAX Measure?
· Named reference syntax
· DAX Functions
· CALCULATE function and its uses
· Implicit vs Explicit Measures
· Calculated Columns
· Measures (Calc Fields) vs. Calc Columns
· Quick Measures
· COUNTROWS(), DISTINTCOUNT(), DIVIDE()
· Creating Variables within measures & using Return / return if

Module 5 - Shaping and Combining Data:

· The Query Editor window in Excel and Power BI Desktop
· Applied Steps
· Shaping Data
· Formatting Data
· Transforming Data
· Combining Data
· Merging Data

Module 6 - Managing Report Pages & using static objects

· Navigating Through Pages
· Showing and Hiding Pages
· Adding, Deleting Pages
· Renaming Pages
· Changing Page Order
· Setting Page View Options
· Using Phone vs. Desktop Layout
· Filters by Visual, Page, Report
· Inserting Pictures
· Inserting Text Boxes
· Inserting Shapes
· Working with Static Objects

How Can Live Online Help You?

The way in which training is delivered has evolved considerably in the last few years. Our Live Online Learning is a practical, personalised and role-centred solution to training your staff remotely. Also available as a scheduled course.

Learners receive online support from highly-experienced trainers, gaining the confidence and specific skills they need, organised within their workloads.

Our accredited (Certified On-line Facilitators) Live-On-Line trainers understand how to deliver effective training in this digital environment and they have designed our virtual courses to be topic driven, so that learners get the maximum learning experience in the shortest period of time.

Tel: 0203-941-4100 | e-mail: info@escalla.co.uk

TOP