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.
Prerequisite
A basic understanding of Excel is recommended, such as filtering and sorting data, creating simple charts, and calculating sums. If you’re new to these concepts, consider starting with our Foundation Excel course.
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.
