Power BI with Excel Training Course

London Academy of IT

Short course

In London

Save 20%
£ 240 VAT inc.

The best Financial Analysis courses

See all

See all

Description

  • Type

    Short course

  • Level

    Beginner

  • Location

    London

  • Class hours

    10h

  • Duration

    2 Days

Get 20% discount by using the promo code: EMAG195

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

Facilities

Location

Start date

London
See map
Unit 15, Boardman House, 64 Broadway, Stratford, E15 1NT

Start date

NovemberEnrolment now closed

About this course

Skills Required
Basic knowledge in MS Excel.

Certification: Certificate of Completion will be provided after completing the course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • MS Excel
  • Power BI
  • Computer
  • IT courses
  • IT
  • IT Training
  • Programming
  • Database
  • London

Teachers and trainers (1)

Nat Sundar

Nat Sundar

Tutor

Nat Sundar is working as an independent SQL BI consultant in the UK with Bachelor Degree in Engineering. He has considerable years of experience with the UK Financial Services Industry (Mainly in Insurance and Investment Banking). He is passionate about SQL Server, SSIS, SSAS, SSRS and MDX.

Course programme

  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

Additional information

Please contact us or visit London Academy of IT website to view full course outline, dates, time and for enrolment.

See related categories

Power BI with Excel Training Course

£ 240 VAT inc.

The best Financial Analysis courses

See all

See all