Microsoft Power BI
Introduction Training
Microsoft Power BI is a vital tool for impactful data visualisations in business reports, financial analysis, and performance dashboards. With proper training, your team can harness its features to create engaging visuals that effectively communicate insights and captivate audiences.
From £199
Per person
Onsite
Live online
1 day
Explore Microsoft Power BI training courses tailored for all skill levels, from beginner to advanced and specialised topics. Our flexible onsite and live online sessions accommodate groups as small as 2 participants and up to 20, providing a personalised learning experience for all.
What you will learn
Discover the basics of the Power BI Desktop environment, including how to navigate the start screen and the four key views.
Learn how to import data from various sources like Excel, CSV, and web pages, and manage file connections, followed by data cleaning and shaping techniques.
Discover how to insert and format different visuals such as maps, charts, and tables, and utilise slicers for filtering reports while maintaining consistency across dashboards.
Explore the creation of DAX columns and measures, including functions like SUM and COUNTROWS, and learn about time intelligence functions and the importance of a calendar table for data analysis.
7 lesson covers:
Understanding Power BI
Get acquainted with the Power BI Desktop ecosystem, including the start screen and the four main views.
Importing Data
Learn how to import data from various sources, including Excel, CSV files, and webpages, and manage file connections effectively.
Data Cleaning and Shaping
Explore techniques for cleaning and shaping data, such as managing data types and applying filters.
Creating Visuals
Discover how to insert and format different visuals, including maps, charts, and tables, and how to use slicers for filtering reports.
Publishing and Sharing
Understand the process of publishing reports online, pinning visuals to dashboards, and sharing your findings within the Power BI service.
Data Modeling
Learn about the fundamentals of data modeling, including table relationships and relationship properties.
DAX and Time Intelligence
Get introduced to DAX for creating calculated columns and measures, and explore time intelligence functions to analyze data over time.