Power BI with Excel Training Course

Course Price: £250.00 excl. VAT (£300.00 incl. VAT)
Total Duration: 10 Hours
Course level: Beginner
Delivery Method: Instructor Led Classroom Training
Certification: Certificate of Completion will be provided after completing the course.

Course Overview:

Do you spend a lot of time working with excel building reports and dashboards?

Are you bored with the repetitive tasks? Are you fed up with copy and paste data from various sheets and deal with the same data issues again and again?

Then this course will help you to learn new feature with excel to automate all the steps to get an enterprise level dashboard.

This course will cover the aspects of self service Business Intelligence for excel analysts. In this course the students will be able to learn and practise the Power BI tools such as Power Query, Power Pivot, Power View. Also you will learn about DAX for efficient processing and reporting.

This course will be useful for Analysts, BI Developers, Dashboard Report Designers and super users.

Following topics are included in this course:

  • Power BI Basics
  • Loading Data
  • M language
  • Data Modelling
  • Advanced Data Modelling
  • DAX Basics
  • Reports

Skills Required

Basic knowledge in MS Excel.

Course Dates, Prices & Enrolment

Training MethodDatesPrice (incl. VAT) 
Classroom Training 07 Jul 2019 - 14 Jul 2019
2 Sundays 		£250 (normal price £300)Enrol Now
Classroom Training 03 Nov 2019 - 10 Nov 2019
2 Sundays 		£300Enrol Now
  1. Power BI Basics
    • Power BI Overview
  2. Loading Data
    • Connecting to data sources
    • Using the built-in transformations
  3. M language
    • M Language Basics
    • Using M language to load data - Advanced
  4. Data Modelling
    • Data Modelling basics
    • Tables and relationships
  5. Advanced Data Modelling
    • Power BI Data Storage and Internals
  6. DAX Basics
    • Introduction to DAX
    • DAX Calculate() function
    • Common calculations in DAX
  7. Reports
    • Developing reports and dashboards

Course Tutors

The course is working as an independent SQL BI consultant in the UK. He is a specialist consultant for building CI (Continuous Integration) solution for BI projects (SSIS, SSRS). He has considerable years of experience with the UK Financial Services Industry (Mainly in Insurance and Investment Banking). He has been presenting sessions in SQLBits, SQLPass and London SQL Server user Group since 2015.

Newsletter Sign-up

Have a Question?

Please read our frequently asked questions or contact us.

We are providing affordable IT training courses at times to suit you - enhance your employability and stand out from the crowd.

Become an IT expert and get that competitive edge that employers are looking for.

Popular Courses

Useful Links

Contact Us

London Academy of IT
Unit 15, Boardman House
64 Broadway
Stratford
London E15 1NT
United Kingdom
Tel: +44 (0)208 432 6218

2018 © London Academy of IT Limited. All Rights Reserved.
Registered in England & Wales with company no. 07923992. VAT no. GB200 4290 68.