FORGOT YOUR DETAILS?

A Complete Introduction to Power BI
Live Online Course

Learn in-demand skills and bring your data and your CV to life!

Course dates

28 October 2020

Duration

1 day course

Format

Delivered live online by a trainer

Price

Now £195 plus VAT for a limited time only!

A Complete Introduction to Power BI

Learn how to create stunning interactive reports and dashboards, visualize data, provide actionable insights and drive business results!

The Microsoft Power BI complete introduction course is available on the dates shown (for anyone, anywhere bookings) and for organisations to book as 'in-house' virtual courses. The introduction course is split into the five modules below. A further 3 modules are available for those wishing to progress onto the advanced course. The training is delivered in small class sizes of no more than 8 delegates.

By the end of the course, you'll:

  • Be able to use the key components of Power BI
  • Learn how to connect to a wide variety of data sources
  • Use the query editor to transform and morph data into the right format
  • Perform complex data modelling operations using relationships, calculated columns, measures and Dax
  • Create visual and interactive dashboards and reports
  • Share Dashboards and report
  • And lots more!

In a nutshell you'll have the skills to start using Power BI with confidence.

Book course or request more information.

Course Content

Microsoft Power BI Course Outline

  1. What is Power BI, Power Query and Power Pivot?
  2. The Power BI service
  3. Power BI Report Server
  4. Power BI Desktop
  5. Understanding Dashboards, Reports and Datasets
  6. Creating, editing & saving PBIX files
  7. Natural Language Queries
  1. Connecting To CSV Files
  2. Connecting To Excel Data
  3. Connecting To A Folder Of Data
  4. Connecting To A Web URL
  5. Connecting To Web Page Content
  6. Connecting To A Microsoft Access Database
  7. SQL servers
  8. Other data sources
  9. Creating a group
  1. The Query Editor
  2. Applied Steps
  3. Advanced Editor
  4. Shaping Data
  5. Formatting Data
  6. Transforming Data
  7. Combining Data
  8. Merging Data
  1. What are the Relationships?
  2. Viewing Relationships
  3. Creating Relationships
  4. Cardinality
  5. Cross Filter Direction
  6. What is DAX?
  7. Syntax
  8. Functions
  9. Context
  10. Calculated Columns
  11. Calculated Tables
  12. Measures
  1. Visualization options
  2. Reports and Dashboards
  3. Choosing the right visual
  4. Changing visuals
  5. Editing properties
  6. Sorting and formatting
  7. Sorting data
  8. Drilling down and filtering
  9. Working with hierarchies
  10. The underlying data and hierarchies
  11. Analysing data
  12. Creating a hierarchy
  13. Filters
  14. Turning off interactions
  15. Applying advanced filtering
  16. Performance – small files and fast calculations
  17. Sharing your data

Who should attend?

Our Power BI Courses are suitable for Business Analysts and other professionals who want to create visual representations of data and produce user friendly reports and dashboards using data from Excel or databases.

Which course(s) is right for me?

This course is designed for beginners but it's recommended that you have a good knowledge of Excel (particularly Pivot Tables) or databases.

If you feel that you need to brush up on your Excel skills first, we would recommend filling in our training needs analysis.

Finally, if you're looking to take your Power BI knowledge further, we also have a 1-day Advanced Power BI Course.

How Can Live Online Help You?

The way in which training is delivered has evolved considerably in the last few years. Our Live Online Learning is a practical, personalised and role-centred solution to training your staff remotely. Also available as a scheduled course.

Learners receive online support from highly-experienced trainers, gaining the confidence and specific skills they need, organised within their workloads.

Our accredited (Certified On-line Facilitators) Live-On-Line trainers understand how to deliver effective training in this digital environment and they have designed our virtual courses to be topic driven, so that learners get the maximum learning experience in the shortest period of time.

TOP