Embark on a comprehensive 1.5-hour tutorial designed for beginners to master Microsoft Power BI. Begin with an introduction to Power BI and its dashboard, then learn to import data from various sources. Explore merging queries using Power Query and creating relationships between tables. Dive into advanced topics like generating dynamic date lists and customizing date columns for analysis. Master essential skills such as sorting month and weekday names, marking date tables, and optimizing report views by hiding unnecessary fields. Gain hands-on experience with practical exercises covering installation, interface navigation, and commonly used options to jumpstart your Power BI journey.
Overview
Syllabus
- Welcome and Overview
- What is Power BI?
- Install Power BI Desktop
- A Tour of BI Desktop
- Explore Commonly Used Power BI Options
- Import Files from a Folder into Power BI Desktop
- Get Data from Excel and Text Files
- Reference Queries to Create Additional Lookup Tables
- Merge Queries in Power Query
- Prevent Queries from Loading into Power BI Desktop
- Create Relationships Between tables
- Create a Dynamic List of Dates
- Create Additional Date Columns for Analysis
- Sort the Month and Weekday Names Correctly
- Mark the Table as a Date Table
- Hide Unnecessary Fields from Report View
Taught by
Simon Sez IT
