Power BI Desktop

GCOM Solutions
4.6
9 reviews
  • Very interesting and useful course. Instructor was extremely patient, as the user system wasn't always fast enough to keep up! I wasn't able to hear the training all the time as he spoke softly. Thanks a lot.
    ← | →
  • It was a very informative and inspiring course. Grant is very calming and clear. His examples and explanations were good enough as to make us understand all topics covered during the training.
    ← | →
  • I loved this course. It was informative and the examples used in class were really good.
    ← | →

Course

Inhouse

£ 1,071 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Level

    Advanced

  • Methodology

    Inhouse

  • Duration

    2 Days

  • Start date

    Different dates available

As Microsoft are gradually transition their self-service BI solution from Excel to Power Bi Desktop, this course shows users how to use Power BI Desktop to import data from a wide variety of data sources; model data by creating relationships, custom measures and calculated columns; and create a wide variety of visualizations and interactive dashboards.

Facilities

Location

Start date

Inhouse

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

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

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.6
excellent
  • Very interesting and useful course. Instructor was extremely patient, as the user system wasn't always fast enough to keep up! I wasn't able to hear the training all the time as he spoke softly. Thanks a lot.
    ← | →
  • It was a very informative and inspiring course. Grant is very calming and clear. His examples and explanations were good enough as to make us understand all topics covered during the training.
    ← | →
  • I loved this course. It was informative and the examples used in class were really good.
    ← | →
100%
4.6
excellent

Course rating

Recommended

Centre rating

Anonymous

5.0
02/09/2016
What I would highlight: Very interesting and useful course. Instructor was extremely patient, as the user system wasn't always fast enough to keep up! I wasn't able to hear the training all the time as he spoke softly. Thanks a lot.
What could be improved: I cannot describe this course with any negative words.
Would you recommend this course?: Yes

Caroline Douglas

5.0
02/09/2016
What I would highlight: It was a very informative and inspiring course. Grant is very calming and clear. His examples and explanations were good enough as to make us understand all topics covered during the training.
What could be improved: Everything was good.
Would you recommend this course?: Yes

Gill Cubitt

5.0
02/09/2016
What I would highlight: I loved this course. It was informative and the examples used in class were really good.
What could be improved: Everything OK.
Would you recommend this course?: Yes

Peter Elliott

5.0
02/09/2016
What I would highlight: The course was excellent, very thorough with a lot of examples. The instructor, Grant Gamble, was superb, explained everything in a concise and coherent manner and when needed, elaborated.
What could be improved: No negative comments.
Would you recommend this course?: Yes

Colin Meneely

4.5
02/09/2016
What I would highlight: Excellent course. A very good overview of the functionality of the software. I really enjoyed this course, it was interesting and very well delivered. A lot to cover but was competently done in a pleasant manner.
What could be improved: Nothing bad.
Would you recommend this course?: Yes

Helen Hail

4.5
02/09/2016
What I would highlight: It was a well designed course, methodically delivered. Grant had an excellent delivery style.
What could be improved: Nothing bad.
Would you recommend this course?: Yes

Anonymous

4.0
02/09/2016
What I would highlight: The best aspect of this training is that everyone took part in this course.
What could be improved: I think our instructor could have used clearer examples as they didn't represent the explanation.
Would you recommend this course?: Yes

Alistreis Mawhourses

4.0
02/09/2016
What I would highlight: The examples used in class were rreally good! We also achieved some objectives that we set at the beginning and covered a lot of important topics.
What could be improved: Everything was good.
Would you recommend this course?: Yes

Richard Murray

4.0
02/09/2016
What I would highlight: Very good: well presented and knowledgeable trainer.
What could be improved: Everything OK.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

Subjects

  • Excel
  • Import
  • MS Excel
  • BI
  • Data
  • Data sources
  • Power BI Desktop on-site training
  • Power BI Desktop in-house training
  • Power BI Desktop training
  • Power BI
  • Power BI Desktop
  • Creating relationships
  • BI Desktop

Course programme

As Microsoft are gradually transition their self-service BI solution from Excel to Power Bi Desktop, this course shows users how to use Power BI Desktop to import data from a wide variety of data sources; model data by creating relationships, custom measures and calculated columns; and create a wide variety of visualizations and interactive dashboards.

Power BI Desktop basics


What is Power BI
What is Power BI Desktop
Power BI Desktop and the Power BI service
Power BI Desktop and Microsoft Excel
Installing Power BI Desktop

Importing data


Overveiew of data sources
Connecting to data sources
Importing excel workbooks
Importing access databases
Connecting to sql server

Query Editor basics


Creating a query
Understanding query steps
Automatically generated steps
Renaming a query
Renaming columns
Changing data types
The close & apply command

Combining data


Appending queries
Rationalising column names
Performing merge operations
Performing expand operations

Transforming data columns


Transforming column data types
Removing columns
Shifting columns around
Merging columns
Splitting columns
Creating custom columns

Data modelling


Working in data view
Working in relationship view
Auto-detection of table relationships
Creating table relationships manually
Setting cardinality
Cross filter direction

Using DAX


Creating Calculated Fields
Implicit and Explicit Calculated Fields
Using DAX aggregate functions in a PowerPivot PivotTable
Using CountRows and DistinctCount Functions
The difference between evaluations using Row Context and evaluations using Filter Context
Advanced DAX functions: SUMX and CALCULATE
Time Intelligence Functions

Creating reports


Working in report view
Creating tables and key metrics
Working with matrixes
Filtering data with slicers

Creating visualizations


Creating column and bar charts
Creating line and area charts
Creating scatter charts
Treemap visualizations
Using charts as slicers
Using maps with geographical data
Using custom visuals in your reports
Creating interactive dashboards

Additional information

£900 for one-to-one training£1,100 for groups of up to 6 people£1,300 for groups of up to 12 people

See related categories

Power BI Desktop

£ 1,071 + VAT

The best Excel courses

See all

See all