▦01
Excel
Learn data cleaning, formulas, lookup functions, PivotTables, and business reporting.
DATA & ANALYTICS · CAREER PATH
CAREER INTELLIGENCE / 04
TURN DATA.
INTO INSIGHT.
Learn to clean, analyze, and visualize data. Build practical skills with Excel, SQL, Python, and Power BI, then use them to solve real business problems.
ExcelSQLPythonPower BIBusiness Insights
ANALYTICS ENGINE
From raw data to decisions
01
Collect & clean
EXCEL · PYTHON
02
Query & analyze
SQL
03
Visualize insights
POWER BI
04
Recommend action
BUSINESS THINKING
The goal: turn business questions into evidence-based decisions.
THE SKILL MATRIX
Build your analytics foundation.
Four core tools. Practical exercises. Business-focused thinking.
⌘02
SQL
Practice queries, filtering, joins, aggregations, subqueries, and business analysis.
⌁03
Python
Explore Python fundamentals, pandas, data cleaning, and exploratory data analysis.
▥04
Power BI
Understand data modelling, Power Query, DAX fundamentals, and interactive dashboards.
LEARNING ROADMAP
Learn step by step.
PHASE 01
Clean & organize
Start with spreadsheet basics, formulas, data types, duplicates, and missing values.
PHASE 02
Query & investigate
Practice SQL and Python to answer questions, find patterns, and validate results.
PHASE 03
Visualize & explain
Build Power BI dashboards and communicate findings through a portfolio project.
TRACK 01 · SPREADSHEETS
Excel Challenges
Build practical Excel skills through hands-on challenges, from basic formulas to data cleaning and business reporting.
CHALLENGE · 001
Excel Basics Challenge 001
Test your knowledge of Excel fundamentals, formulas, cells, rows, columns, and basic data analysis.
10 Questions100 XP
Start Challenge
CHALLENGE · 002
Excel Formulas & Functions 002
Practice common Excel formulas and functions used to summarize and analyze business data.
10 Questions100 XP
Start Challenge
CHALLENGE · 003
Excel Data Cleaning & Sorting 003
Practice sorting, filtering, removing duplicates, cleaning text, and organizing spreadsheet data for analysis.
10 Questions100 XP
Start Challenge
CHALLENGE · 004
Excel Lookup Functions 004
Practice lookup formulas to find matching records, retrieve values, and handle missing results in business spreadsheets.
10 Questions100 XP
Start Challenge
CHALLENGE · 005
Excel Conditional Logic & Business Analysis 005
Practice IF, IFS, AND, OR, nested logic, and business scenarios for evaluating targets and classifying performance.
10 Questions100 XP
Start Challenge
CHALLENGE · 006
Excel Challenge 006: SUMIF, SUMIFS, COUNTIF & COUNTIFS
Practice conditional totals and counts using SUMIF, SUMIFS, COUNTIF, and COUNTIFS in realistic business scenarios.
10 Questions100 XP
Start Challenge
CHALLENGE · 007
Excel Challenge 007: Text Functions
Clean messy text and extract useful information from customer records, product codes, and business datasets using LEFT, RIGHT, MID, and TRIM.
10 Questions100 XP
Start Challenge
CHALLENGE · 008
Excel Challenge 008: Date Functions
Analyze dates, calculate employee tenure, track order ageing, and prepare monthly reports using TODAY, DATEDIF, and EOMONTH.
10 Questions100 XP
Start Challenge
CHALLENGE · 009
Excel Challenge 009: Pivot Tables & Summary Reports
Turn raw business data into meaningful reports using Pivot Tables, Rows, Columns, Values, date grouping, filters, slicers, and refresh operations.
10 Questions100 XP
Start Challenge
CHALLENGE · 010
Excel Challenge 010: Sales Performance Analysis
Solve a real-world sales analysis case study by evaluating revenue, targets, profit margins, average order value, regional performance, and business trends.
10 Questions100 XP
Start Challenge
TRACK 02 · DATABASE QUERIES
SQL Challenges
Practice SQL queries, filtering, sorting, aggregations, and joins through practical data analytics challenges.
CHALLENGE · 001
SQL Challenge 001
Test your knowledge of SQL fundamentals, queries, filtering, sorting, grouping, joins, and database concepts.
10 Questions100 XP
Start Challenge
CHALLENGE · 002
SQL Challenge 002
Test your knowledge of SQL aggregate functions, filtering groups, joins, NULL values, subqueries, and data modification.
10 Questions100 XP
Start Challenge
CHALLENGE · 003
SQL Challenge 003
Test your knowledge of SQL queries, joins, aggregation, constraints, data types, transactions, and practical database concepts.
10 Questions100 XP
Start Challenge
CHALLENGE · 004
SQL Challenge 004
Practice practical SQL for data analytics using CASE expressions, NULL handling, date filters, and conditional aggregation.
10 Questions100 XP
Start Challenge
CHALLENGE · 005
SQL Challenge 005: JOINs & Multi-Table Analysis
Practice INNER JOIN, LEFT JOIN, multi-table joins, and business analysis using relational data.
10 Questions100 XP
Start Challenge
CHALLENGE · 006
SQL Challenge 006: Subqueries & CTEs
Practice SQL subqueries, scalar queries, common table expressions, and multi-step business analysis.
10 Questions100 XP
Start Challenge
CHALLENGE · 007
SQL Challenge 007: Window Functions & Ranking
Practice SQL window functions, ranking, partitioning, previous-row comparisons, and running totals.
10 Questions100 XP
Start Challenge
CHALLENGE · 008
SQL Challenge 008: Date & Time Analysis
Practice SQL date filtering, date extraction, monthly aggregation, date differences, and time-based business analysis.
10 Questions100 XP
Start Challenge
CHALLENGE · 009
SQL Challenge 009: Advanced Aggregation & Business Metrics
Practice advanced aggregation, HAVING, conditional metrics, conversion rates, averages, and business reporting with SQL.
10 Questions100 XP
Start Challenge
CHALLENGE · 010
SQL Challenge 010: Set Operations & Advanced Query Logic
Practice UNION, UNION ALL, INTERSECT, EXCEPT, EXISTS, and advanced SQL filtering for data analysis.
10 Questions100 XP
Start Challenge
TRACK 03 · PYTHON ANALYTICS
Python Challenges
Practice Python fundamentals, Pandas, data cleaning, exploratory analysis, visualization, and business problem-solving.
CHALLENGE · 011
Python Challenge 001: Fundamentals
Practice Python variables, data types, operators, conditions, loops, and basic functions for data analytics.
10 Questions100 XP
Start Challenge
CHALLENGE · 012
Python Challenge 002: Data Structures
Practice Python lists, tuples, dictionaries, sets, indexing, slicing, and common data manipulation operations.
10 Questions100 XP
Start Challenge
CHALLENGE · 013
Python Challenge 003: NumPy Fundamentals
Practice NumPy arrays, array operations, shapes, indexing, aggregation, and numerical computing for data analytics.
10 Questions100 XP
Start Challenge
CHALLENGE · 014
Python Challenge 004: Pandas Fundamentals
Practice Pandas Series, DataFrames, data selection, filtering, missing values, and basic dataset inspection.
10 Questions100 XP
Start Challenge
CHALLENGE · 015
Python Challenge 005: Data Cleaning & Transformation
Practice handling missing values, duplicate rows, data types, string cleaning, and transformations using Pandas.
10 Questions100 XP
Start Challenge
CHALLENGE · 016
Python Challenge 006: Data Analysis with Pandas
Practice filtering, sorting, grouping, aggregation, and extracting business insights using Pandas.
10 Questions100 XP
Start Challenge
CHALLENGE · 017
Python Challenge 007: Exploratory Data Analysis
Practice inspecting datasets, descriptive statistics, correlations, outliers, and business insights using Pandas.
10 Questions100 XP
Start Challenge
CHALLENGE · 018
Python Challenge 008: Data Visualization
Practice choosing charts, creating plots with Matplotlib and Seaborn, and interpreting visual insights for business analysis.
10 Questions100 XP
Start Challenge
CHALLENGE · 019
Python Challenge 009: SQL vs Pandas
Practice translating common SQL operations into Pandas for practical data analysis.
10 Questions100 XP
Start Challenge
CHALLENGE · 020
Python Challenge 010: Business Data Analysis
Apply Pandas skills to business cases involving revenue, profitability, customer retention, and data-driven decisions.
10 Questions100 XP
Start Challenge
TRACK 04 · POWER BI ANALYTICS
Power BI Challenges
Practice Power Query, data modelling, DAX, time intelligence, dashboard design, publishing, and business case studies.
CHALLENGE · 021
Power BI Challenge 001: Fundamentals
Learn Power BI fundamentals, reports, dashboards, datasets, visuals, and the basic analytics workflow.
10 Questions100 XP
Start Challenge
CHALLENGE · 022
Power BI Challenge 002: Power Query & Data Cleaning
Practice data types, missing values, duplicate removal, column transformations, and merging or appending queries.
10 Questions100 XP
Start Challenge
CHALLENGE · 023
Power BI Challenge 003: Data Modelling & Relationships
Practice relationships, cardinality, fact and dimension tables, star schema, and filter propagation in Power BI.
10 Questions100 XP
Start Challenge
CHALLENGE · 024
Power BI Challenge 004: DAX Fundamentals & Measures
Practice DAX basics, measures, calculated columns, aggregations, and foundational business calculations.
10 Questions100 XP
Start Challenge
CHALLENGE · 025
Power BI Challenge 005: DAX Filter Context
Practice filter context, CALCULATE, FILTER, ALL, and dynamic business calculations using DAX.
10 Questions100 XP
Start Challenge
CHALLENGE · 026
Power BI Challenge 006: DAX Time Intelligence
Practice date tables, year-to-date calculations, prior-period comparisons, and year-over-year analysis using DAX.
10 Questions100 XP
Start Challenge
CHALLENGE · 027
Power BI Challenge 007: Dashboard Design & Visualizations
Practice choosing visuals, designing KPI cards, using slicers and drill-through, and presenting business insights clearly.
10 Questions100 XP
Start Challenge
CHALLENGE · 028
Power BI Challenge 008: Publishing & Sharing
Practice publishing reports, managing workspaces, refreshing data, configuring permissions, and sharing Power BI content.
10 Questions100 XP
Start Challenge
CHALLENGE · 029
Power BI Challenge 009: Advanced DAX
Practice iterator functions, row context, RELATED, distinct counts, and advanced business calculations using DAX.
10 Questions100 XP
Start Challenge
CHALLENGE · 030
Power BI Challenge 010: Business Analytics Case Study
Apply Power BI skills to a business case involving data preparation, modelling, DAX, KPIs, dashboards, and actionable insights.
10 Questions100 XP
Start Challenge