Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 47 Minute(s)
Language
English
Taught by
Meta Brains, Skool of AI
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Master Excel and Power BI to create stunning project management dashboards, reports
Transform your project management reporting skills with this comprehensive course that teaches you to create professional dashboards and visual reports using Excel and Power BI. Whether you're a project manager, data analyst, or business professional, this hands-on course will equip you with the essential skills to turn raw project data into compelling visual stories.
You'll start by learning the fundamentals of project management reporting and understanding when to use Excel versus Power BI. Through practical exercises, you'll master data importing, cleaning, and structuring techniques that form the foundation of effective reporting. The course covers essential Excel functions including VLOOKUP, INDEX-MATCH, and conditional formulas, plus advanced features like Pivot Tables and Power Query.
Dive deep into time-based analysis with advanced date functions and trend visualization techniques. Learn to create stunning visualizations including waterfall charts, combo charts, KPIs, and interactive heatmaps. The course includes two comprehensive projects: building a complete project management dashboard in Excel and creating an advanced interactive dashboard in Power BI.
By the end of this course, you'll confidently create professional-grade project reports that impress stakeholders and support data-driven decision making. Perfect for project managers, analysts, and anyone who needs to communicate project performance through visual data storytelling. Let's go!
Course Content
- 7 section(s)
- 32 lecture(s)
- Section 1 Introduction to Project Management Reporting with Excel and Power BI
- Section 2 Data Importing, Cleaning, and Structuring
- Section 3 Fundamental Functions and Tools for Data Analysis
- Section 4 Time-Based and Trend Analysis
- Section 5 Data Visualization Techniques for Project Reporting
- Section 6 Building a Project Management Dashboard in Excel
- Section 7 Creating an Advanced Dashboard in Power BI
What You’ll Learn
- Master Excel and Power BI fundamentals for professional project reporting and dashboard creation
- Import, clean, and structure project data from multiple sources using advanced Excel tools and Power Query
- Create complex formulas using VLOOKUP, INDEX-MATCH, and conditional functions for data analysis
- Build interactive pivot tables and pivot charts to summarize and visualize project performance metrics
- Design advanced visualizations including waterfall charts, combo charts, and interactive heatmaps
- Develop time-based analysis skills using advanced date functions and trend visualization techniques
- Complete two hands-on projects: Excel project dashboard and advanced Power BI interactive report
- Apply data modeling principles and calculated fields to create professional business intelligence reports
Skills covered in this course
Reviews
-
OOsvaldo Mares Sanchez
hasta el momento ha sido claro el curso
-
TTom VDB
I was expecting more specific stuff. I've already used Excel and Power BI during high school and for my bachelor and this course didn't bring me much more. But for beginers, this training is a good starting point.
-
KKevin Utter
This course is very short and very basic. Much of the content is around trivial adjustments like making titles bold. The instruction around project management-specific visualizations is very thin and limited to Microsoft Excel. Anyone looking to create true dashboards on the topic of project management, as the title suggests, will be disappointed.
-
UUmar Abba Barau
The content are excellent
