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 – introduction (1-day for beginners)

Power BI – introduction (1-day for beginners)

A one-day workshop

This course provides a condensed yet balanced look at the process of analysing data in reports. It starts by showing you how to import and connect to data from source files, including Excel, CSV files, and a web page. It then focuses on the process of cleaning and shaping data.

A comprehensive part of this course looks at the creation of dashboard visuals, including charts, maps, and tables, and how to arrange those visuals on a page to produce dynamic, interactive dashboards. It also looks at publishing and sharing reports in the online Power BI service.

You will also learn how table relationships work in a Data Model, the basis of a Power BI report, and includes DAX (Data Analysis Expressions) calculations to enhance your visuals.

learning objectives
  • The aim of this course is to provide an introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away.

Who should attend?

Managers and others who need to use or create reports and tables to support business management and decision-making.

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. Getting started

  • The Power BI Desktop ecosystem
  • Power BI’s four views

2. Importing files

  • The process of importing files
  • Import an Excel file
  • Import a CSV file
  • Import from the web
  • Manage file connections

3. The Power Query Editor

  • The process of cleaning data
  • What are Applied Steps?
  • Manage data types

4. Dashboard visuals

  • What is data storytelling?
  • Insert and format maps
  • Insert and format charts
  • Insert a table, matrix, and card
  • Controlling data formats
  • Highlighting key points
  • Filter reports with slicers

5. The Power BI service

  • The Power BI service ecosystem
  • Pin visuals to a dashboard
  • Share report dashboards

6. The data model

  • Model relationships
  • Relationship properties

7. DAX new columns

  • New columns and measures
  • Adding a new column calculation

8. Introduction measures

  • Basics of DAX measures
  • Insert a SUM function
  • Adding measures to visuals
  • Insert a COUNTROWS function
  • DAX formula rules

9. The CALCULATE measure

  • The syntax of CALCULATE
  • Using a CALCULATE measure

10. Time intelligence

  • Importance of a calendar table
  • Time intelligence functions
  • Insert a TOTALYTD function
  • Viewing time intelligence visually
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