t. +44 (0)1582 463463
e. contact@tihtc.co.uk
Got a question - How can we help?
t. 01582 463463
e. contact@tihtc.co.uk
Got a question - How can we help?
searchCreated with Sketch Beta.

  • Power BI – intermediate (1-day workshop to follow the 2-day introduction)

Power BI – intermediate (1-day workshop to follow the 2-day introduction)

A one-day workshop

This course is designed for those already familiar with Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations.

The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI’s analytical capabilities with more depth.

learning objectives
  • The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth.

Who should attend?

Managers and others who need to use or create reports and tables to support business management and decision-making. Our assumption is you are already a Power BI Desktop user and are comfortable with the fundamentals. If not, we recommend attending the 2-day Introduction to Power BI course first.

Format

A very practical, interactive one-day session for a maximum group size of 8. This course can be run remotely online or face-to-face onsite.

Expert trainer

Alan became a professional IT trainer in 1995, when on completion of an NVQ accreditation in IT, the organisation providing the course, Apex North London, asked if he would like to join their team, which he happily did. Alan went on to become a City & Guilds Assessor with them.

Session outline

1. The Power Query editor

  • Grouping tables
  • Split a row by delimiter
  • Matching inconsistent data

2. Logical column functions

  • Understanding logical functions
  • Create a FIND function
  • Nest logical functions in an IF function

3. CALCULATE measure in-depth

  • Understanding CALCULATE filters
  • Add context to CALCULATE with FILTER
  • Using CALCULATE with a threshold

4. The ALL measure

  • Anatomy of ALL
  • Using ALL as a filter
  • Using ALL for percentages

5. Iterator measures in-depth

  • A closer look at SUMX
  • Create a RANKX
  • RANKX with ALL

6. Time intelligence measures in-depth

  • Developing a calendar table
  • Comparing historical data
  • Create a DATEADD measure

7. Visualisations in-depth

  • Heatmaps in Power BI
  • Applying static filters
  • Creating lists
  • Creating a scatter chart
  • Analysing chart trends
  • Creating dynamic dashboards
  • Customising tooltips
View PDF
Multiple delivery formats and options
users

Face-to-face delivery

monitor-code

Virtual delivery

fingerprint

Tailored solutions

Get in touch

Give us a call now at 01582 463 463, or use the contact form below.

Please enable JavaScript in your browser to complete this form.

How to find us

TIHTC

22 South Burgundy House
The Foresters, High Street
Harpenden, AL5 2FB

e. contact@tihtc.co.uk

t. +44 (0)1582 463 463

© 2024 TIHTC Ltd. All rights reserved

Training Areas

Our Clients

//

Navigation

Training Areas...

Leadership & management development

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt

View courses

Management & personal effectiveness

In voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.

View courses

Customer Service Training

Minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo.

View courses

Boardroom effectiveness

cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.

View courses

Maximum Coaching

Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque.

View courses

Specialist Subjects

quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo.

View courses
Ask us a question...

How can we help?

Got a question for us? We’d love to hear from you! Dial 01582 463 463 or use the form below.

Please enable JavaScript in your browser to complete this form.

Don't miss our latest updates & offers

Get the latest news, updates and special offers delivered straight to your inbox when you join our mailing list…

Please enable JavaScript in your browser to complete this form.
Name
How can we help?

Want to know more about our training areas?

Simply submit your question(s) below for a response within 24hrs…

Please enable JavaScript in your browser to complete this form.
"We have found Maximum Performance to be reliable, professional and hard-working. As a direct result, we have doubled the amount of work we do with the company. I have no hesitation in recommending Maximum Performance for training development and delivery".
CRCAOperations Director
As Maximum Performance’s interventions were based on the agreed business drivers, we have seen real evidence that the training has helped individuals move the organisation forward.
AdeccoOperations Director
As Maximum Performance’s interventions were based on the agreed business drivers, we have seen real evidence that the training has helped individuals move the organisation forward.
AdeccoOperations Director