Course overview
In this course, you’ll learn the fundamentals of Microsoft Power BI. You’ll learn how to import, load, clean, and transform data to start your data analysis process. You’ll also learn how to build reports and dashboards using Microsoft Power BI.
Best of all, you’ll learn by doing — you’ll practice and get feedback directly in the browser.
Key skills
- Navigating Power BI and using its building blocks
- Importing data from common sources
- Combining data and finding anomalies
- Simplifying a complicated model and changing data types
Course outline
Introduction to Data Analysis in Microsoft Power BI [5 lessons]
Get Started with Power BI 1h
Lesson Objectives- Make Power BI services and applications work together
- Employ Power BI to make your business more efficient
- Identify and connect to a data source
Clean Data in Power BI 1h
Lesson Objectives- Resolve inconsistencies, unexpected or null values, and data quality issues
- Apply data shape transformations to table structures
- Apply user-friendly naming conventions to columns
Transform Data in Power BI 1h
Lesson Objectives- Apply user-friendly value replacements and naming conventions to columns and queries
- Profile data, and evaluate and transform column data types
- Apply data shape transformations to table structures
Model and Combine Data in Power BI 1h
Lesson Objectives- Combine queries by appending rows and merging columns
- Create a table visualization
Create a Dashboard in Power BI 1h
Lesson Objectives- Create visualizations in a report
- Rearrange tiles
- Organize tiles into a dashboard
The Dataquest guarantee
Dataquest has helped thousands of people start new careers in data. If you put in the work and follow our path, you’ll master data skills and grow your career.
We believe so strongly in our paths that we offer a full satisfaction guarantee. If you complete a career path on Dataquest and aren’t satisfied with your outcome, we’ll give you a refund.
Master skills faster with Dataquest
Go from zero to job-ready
Learn exactly what you need to achieve your goal. Don’t waste time on unrelated lessons.
Build your project portfolio
Build confidence with our in-depth projects, and show off your data skills.
Challenge yourself with exercises
Work with real data from day one with interactive lessons and hands-on exercises.
Showcase your path certification
Impress employers by completing a capstone project and certifying it with an expert review.