Getting Started in Power BI - Microsoft Power BI Tutorial for Beginners
Offered By: Simon Sez IT via YouTube
Course Description
Overview
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.
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
Related Courses
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX