Embark on a comprehensive 2-hour crash course designed to introduce beginners to Microsoft Power BI. Learn the five crucial components of Power BI: Power Query, Data Modelling, DAX Expressions, Reporting Features, and Publishing to Power BI Service. Master the art of importing and transforming data from CSV, Excel, and text files using Power Query. Explore data modeling basics, including creating relationships between tables and generating dynamic date tables with DAX. Dive into the distinctions between calculated columns and measures, and discover how to build a key measures table. Develop your skills in creating Power BI reports by adding visualizations, pages, bookmarks, buttons, and applying formatting techniques. Conclude the course by learning how to publish reports to the Power BI Service and pin visualizations to a dashboard, equipping you with the essential knowledge to leverage this powerful business intelligence tool for advanced data analysis and modeling.
Overview
Syllabus
- Introduction to Power BI Desktop Part 1
- Agenda
- What is Power BI?
- Acquiring Power BI
- Importing CSV Files and Transforming Data
- Importing Excel Files and Text Files
- Creating Lookup Tables
- Merging Queries
- Data Modelling: Creating Relationship Between Tables
- Date Table Using DAX Expressions
- Introduction to Power BI Desktop Part 2
- Agenda
- Recap of Part 1
- Calculated Columns vs Measures
- Creating a Key Measures Table
- Adding Visualizations
- Adding Pages, Bookmarks, and Button
- Adding Filters
- Displaying and Formatting Overview Statistics
- Publishing Report to the Power BI Service
- Pinning Visualizations to a Dashboard
Taught by
Simon Sez IT
