Practical Data Analysis with Excel & Power BI
Clean and validate a practical dataset. Analyze data with formulas and pivot tables. Learn through short, focused lessons and practical exercises you can revisit at your own pace.
Created by Hannah Kim✓ Verified Instructor♧ Secure checkout powered by Stripe
↶ 30-Day Money-Back GuaranteeBuy once. Learn at your pace. Access forever.
This course includes
- ▷ 2h 27m on-demand video
- ↓ Downloadable resources
- ▣ Access on mobile and TV
- ∞ Access forever
- ✧ Certificate of completion
What you’ll learn
- ✓Clean and validate a practical dataset
- ✓Analyze data with formulas and pivot tables
- ✓Build a clear Power BI report
- ✓Communicate findings and limitations
Who this course is for
Curious professionals and independent learners who want a structured introduction to this topic. Bring a computer, time for practice, and a willingness to revisit the exercises. No advanced subject knowledge is assumed.
Short lessons introduce one idea at a time. Each module gives you an opportunity to apply it before moving on. Certificates recognize course completion and are not academic degrees or professional licenses.
Course curriculum
6 modules · 18 lessons · 2h 27m total
01Ask the right question3 lessons · 33 min+
- ▷Define a decision10:00
- ▷Inspect a dataset11:00
- ▷Document data limitations12:00
02Excel preparation3 lessons · 28 min+
- ▷Clean text and dates11:00
- ▷Handle missing values12:00
- ▷Validate table structure5:00
03Excel analysis3 lessons · 23 min+
- ▷Useful conditional formulas12:00
- ▷Lookups and relationships5:00
- ▷Build pivot tables6:00
04Power Query3 lessons · 18 min+
- ▷Import and transform data5:00
- ▷Combine related tables6:00
- ▷Create repeatable steps7:00
05Power BI models3 lessons · 21 min+
- ▷Build relationships6:00
- ▷Create basic DAX measures7:00
- ▷Check calculation context8:00
06Dashboard delivery3 lessons · 24 min+
- ▷Choose appropriate charts7:00
- ▷Add filters and navigation8:00
- ▷Explain the result9:00
Meet your instructor
Hannah translates raw data into understandable business decisions. Her teaching combines careful data preparation, reusable analysis, and dashboards that answer a specific question.
View instructor profile ↗Learner feedback
672 illustrative reviews
This pre-launch catalog uses sample rating and enrollment data. Verified learner reviews will be shown after courses open for enrollment.