Microsoft Power BI Advanced:

This course will help to further develop your Power BI skills by improving data modelling, using the DAX Expression language and to look at methods of creating more flexible business intelligence. Delegates must be comfortable with the course objectives covered at Introduction level.

 

Course Outline
Microsoft Power BI Advanced

Introducing DAX and Computations in Power BI
  • Starter Exercise, Importing Data and Creating a Simple Report
  • Applying Conditional Formats
  • Creating Computed Columns
  • Creating Measures
  • Grouping Data and Creating Visualisations
  • Creating KPIs
  • Creating Conditional Columns
Modelling Data
  • Using relationships to improve the ability to analyse data
  • Pivoting and Grouping Data
  • Creating Conditional Columns
  • Creating Tables from existing Data
  • Importing Data via a database query
  • Exploring DAX further – 3 useful expression templates
Improving Reports and Outputs
  • Working with multiple report pages
  • Adding Graphics and drawing elements to Reports
  • Exporting data to CSV
  • Exporting data to PowerPoint
  • Exporting Data to Excel
  • Creating a Power BI Template
  • Creating a Power BI App

Tags: Power BI

About the Trainers

Qualifications - European Computing Driving License (ECDL) Microsoft Office Specialists (MOS) Microsoft Office User Specialist (MOUS), Microsoft Certified Applications Specialist (MCAS), 2 of our trainers have taken the Institute of Learning Management Train the Trainer Master Class Award. Every trainer has a minimum of 5 years training experience.

mpn

NC Member logo

Latest News

Windows 10

Windows courses now available.

New courses for Microsoft Windows 10 available NOW – be one of the first to see it with us.

Microsoft Office Training

NEW Microsoft 365 Training – our most popular course, this course looks at making the most of using Office 365 including popular apps such as Teams, Forms and OneNote as well as the differences between the main Microsoft packages and the online ones. This course is a must for homeworkers.

NEW virtual courses – for Soft Skills, Management and Microsoft training. Half a day and full day training courses available.

Microsoft Office weekday, weekend, face to face and virtual training now available.

Microsoft Office 2016 and 2019 upgrade training courses.

Testimonials

"This morning I set up a Macro (as per Thursday’s advanced course) and recorded the whole operation so I could apply to future reports downloads and ‘wow’ this has really saved so much time -thank you."

Iris Vicary, Telent

"After taking part in the intermediate and advanced excel courses I soon booked onto the word training. Nicola was both helpful and technical. The courses were just the right length and I would strongly recommend."

James Harris, Critchleys Chartered Accountants