GET 20% OFF on regular prices . Use this promo code during booking: WINTER21
Regular Course Price: £200.00   
Total Duration: 5 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.

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

Following topics are included in this course:

  • Introduction to Power BI
  • Loading Data
  • Create Reports
  • Graphs and Data Visualisation
  • Query Editor
  • Power BI Service


Skills Required

Basic knowledge in MS Excel.

Course Dates, Prices & Enrolment

Training
Method
Dates and Times
(in the UK)
Dates and Times
(if not in the UK)
Price 
Online Training using Zoom 10 Dec 2021 - 17 Dec 2021
2 Fridays
10am - 12:30pm
Start Date & Time
End Date & Time
£200
Enrol Now

Full Course Outline

  1. Introduction to Power BI
    • Power BI Overview
    • Introduction to PowerBI Desktop
  2. Create Reports
    • Connecting to data sources
    • Creating Tables in Power BI
    • Matrix Visualisation
    • Methods of Aggregation
    • Cards and Multi Row Cards
    • Filtering Data
  3. Graphs and Data Visualisation
    • Introduction to Visualisation
    • Creating Charts
    • Decomposition Tree
    • Creating Interactive Dashboards
  4. Query Editor
    • Introduction to Power BI Query Editor
    • Basic Transformations
    • Aggregation
  5. Power BI Service
    • Introducing Power BI Service
    • Load Data into the Power BI Service

Price Calculator & Booking Request Form

Calculate prices for Corporate, 1-on-1 or group training and request a booking.

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

  • book a course on different dates
  • book for a group of delegates
  • book corporate training
  • book a customised training
  • book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:

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.

Related Courses

Newsletter Sign-up

Have a Question?