DashCoreHub
◆ Free · no sign-up
DashCore Hub Academy
Go from Trainee to BI Architect. Read the lessons, solve real missions for Sunshine Grocers (a fictional grocery chain) with real data, and pass each rank quiz. Your progress is saved in this browser.
Reset all progress?
1
Rank 1
Trainee
Excel foundations
Lessons
- ○Excel for Data Analysis: The Complete Beginner's Guide
- ○Excel Pivot Tables: Step-by-Step Guide with Examples
- ○XLOOKUP vs VLOOKUP vs INDEX-MATCH: Which One to Use
- ○Excel Dynamic Arrays: FILTER, SORT, UNIQUE and SEQUENCE
- ○Excel Charts: Best Practices for Clear Business Reports
- ○Conditional Formatting in Excel for Data Analysts
Missions
2
Rank 2
Junior Analyst
Clean, model and build dashboards
Lessons
- ○The Excel Data Cleaning Checklist (20 Steps)
- ○Power Query in Excel: Clean and Transform Data Automatically
- ○Power Pivot and the Excel Data Model Explained
- ○How to Build an Interactive Dashboard in Excel
- ○25 KPIs Every Business Should Track (with Formulas)
- ○Data Visualization Principles That Actually Work
Missions
3
Rank 3
Analyst
Power BI and DAX
Lessons
- ○What Is Power BI? A Plain-English Introduction
- ○Your First Power BI Report in 60 Minutes
- ○Star Schema in Power BI: How to Model Your Data
- ○DAX Basics: Measures, Calculated Columns and Context
- ○The CALCULATE Function in DAX, Explained Simply
- ○DAX Time Intelligence: YTD, MTD and Year-over-Year
- ○Power BI Dashboard Design: Layout, Color and UX
Missions
4
Rank 4
Senior Analyst
SQL and data warehouses
Lessons
- ○SQL for Beginners: SELECT, WHERE and ORDER BY
- ○SQL JOINs Explained with Simple Examples
- ○GROUP BY and Aggregate Functions in SQL
- ○SQL Window Functions: ROW_NUMBER, RANK and Running Totals
- ○CTEs and Subqueries in SQL
- ○Data Warehouse Basics: Facts, Dimensions and Grain
Missions
5
Rank 5
BI Architect
Python, automation and AI
Lessons
- ○Python for Data Analysis: Where to Start
- ○pandas Tutorial: DataFrames for Excel Users
- ○Automate Excel Reports with Python
- ○Sales Forecasting with Python (Beginner Project)
- ○Using ChatGPT and Claude as a Data Analyst
- ○How AI Is Changing Business Intelligence