Unlock the power of your data—learn to build interactive dashboards and reports with Excel in this hands-on introduction. You will never be the same again after this course.
Prerequisites
Basic Excel
Audience
Business Analysts: Want to move beyond Excel for data analysis. Need to build dashboards, reports, and data models. Often responsible for ad-hoc reporting and insights.
Data Enthusiasts / Power Users: Comfortable with Excel and want to upskill. Eager to explore more advanced data transformation and visualization tools.
Team Leads / Managers: Don’t necessarily build reports but need to understand Power BI outputs. Interested in data-driven decision-making and KPI tracking.
IT and Database Professionals: Looking to support or integrate Power BI into existing systems. May focus on data modeling, performance tuning, or governance.
Course Content
- Introduction to the Power Tools of Excel
- What it does and how it works
- Key terminology related to data and Power BI
- Data concepts and modeling
- Relational data
- Kimball Methodology
- Dimensional modeling
- Data transformation and cleaning techniques
- Append, Merge
- Pivot, Unpivot
- Surrogate Keys
- Duplicate, Reference
- Normalization and De-normalization
- Introductioni to Data Wrangling
- Data analysis with DAX (Data Analysis Expressions)
- Measures
- Calculated Columns
- Time Intelligence
- Date Tables
- Fiscal periods (e.g., April 2st fiscal year start)
- Creating dashboards and interactive visuals
- Power Pivot Tables!
- Bar Charts, Line Charts, Pie Charts
Course Setup Checklist
- Excel
- Computer with at least two monitors and mouse
- The course files (download link proveded after registration)