DATA ANALYSIS ROADMAP 2027
The Data Analysis Roadmap 2026/27 is a comprehensive, practical learning program designed to equip learners with the essential skills required to become job-ready data analysts. The program covers five core technologies: Microsoft Excel for data cleaning, calculations, and reporting; SQL for querying, filtering, and managing databases; Power BI for interactive dashboards and business intelligence; R for statistical analysis and data visualization; and Python for data manipulation, automation, and advanced analytics. Through a structured learning pathway, participants progress from foundational concepts to advanced analytical techniques, gaining hands-on experience with industry-relevant tools and workflows used by modern organizations. The program emphasizes solving real-world business problems through practical projects and case studies. Learners will analyze sales performance to identify revenue trends and underperforming products, investigate customer behavior to improve retention, evaluate financial and operational performance, forecast demand, and uncover insights that support strategic decision-making. By combining Excel, SQL, Power BI, R, and Python, participants will learn to transform raw data into actionable business intelligence, build professional dashboards, automate reporting processes, and communicate findings effectively to stakeholders. By the end of the roadmap, learners will have developed a portfolio of practical analytics projects that demonstrate their ability to solve business challenges and prepare them for opportunities in data analysis, business intelligence, and data-driven decision-making.
Your instructors
Shem Oluwatobi
Lead Instructor
Biostatistician & Data Scientist, Lead Instructor
Skills you will earn
10 Day Data Analysis for Excel
The 10-Day Data Analysis with Excel Course is designed to equip learners with the essential knowledge and practical skills required to analyze, organize, and interpret data using Microsoft Excel, progressing from beginner to advanced level. Participants will start with the fundamentals of Excel, including workbook and worksheet management, data entry, formatting, cell references, basic formulas, and essential functions such as SUM, AVERAGE, COUNT, IF, and logical functions. The course will then progress to data cleaning and preparation, sorting and filtering, conditional formatting, data validation, text and date functions, lookup functions such as VLOOKUP, XLOOKUP, and INDEX-MATCH, and techniques for handling duplicates, missing values, and inconsistent datasets. By the end of the 10-day training, learners will gain hands-on experience with advanced Excel functions, PivotTables, PivotCharts, data visualization, interactive dashboards, and advanced analytical techniques for transforming raw data into meaningful business insights. The course will also introduce What-If Analysis, scenario analysis, basic forecasting, and the use of Power Query for efficient data transformation and automation. Through practical exercises, real-world datasets, and guided projects, participants will develop the confidence to analyze data, identify trends, generate reports, and support informed decision-making in business, finance, operations, marketing, and other professional fields.
10-Day Power BI for Data Analysis
The 10-Day Power BI for Data Analysis program is an intensive, fast-paced roadmap designed to transform beginners into data professionals capable of building production-grade dashboards. Over the course of ten days, participants master the end-to-end data lifecycle, beginning with data ingestion and transformation in Power Query, progressing through data modeling, and unlocking advanced insights using Data Analysis Expressions (DAX). The structured layout ensures a smooth transition from raw, disorganized data sources into a highly optimized, semantic data model. The second half of the program shifts its focus to data storytelling, user experience (UI/UX) design, and enterprise-level sharing. Learners gain hands-on experience building interactive reports with cross-filtering, KPIs, and time-intelligence calculations before publishing their work to the Power BI Service for cloud collaboration. The course culminates in an end-to-end capstone portfolio project that simulates a real-world business intelligence scenario, making it ideal for professionals looking to fast-track their analytics careers or prepare for the PL-300 certification.
10-Day SQL for Data Analysis
The 10-Day SQL for Data Analysis professional certificate course delivers a comprehensive, high-level curriculum designed to transform raw institutional data into strategic corporate intelligence and rigorous research insights. Over two weeks, participants transition from fundamental relational database concepts and basic SELECT queries to mastering advanced data manipulation techniques. The syllabus methodically navigates the entire data extraction lifecycle—moving from filtering and aggregating records to executing complex multi-table joins, subqueries, and common table expressions (CTEs). By fusing structured query mechanics with logical database architecture, this program equips analytical professionals with the precision tools required to query massive, messy enterprise databases and extract clean, structured datasets for downstream analysis. Engineered specifically for business analysts, database administrators, research scientists, and quantitative project managers, this instructor-led course prioritizes performance optimization and scalable data pipelines. Participants dive deep into advanced analytical capabilities, including window functions for calculating running totals, moving averages, and ranks, as well as optimizing query execution plans for massive data volumes. The final days culminate in an end-to-end data auditing project where learners write complex, production-grade scripts to solve real-world case studies and generate executive-ready performance metrics. Graduates emerge with a robust technical portfolio and the professional autonomy needed to direct sophisticated data retrieval operations and support high-stakes, data-driven decision-making within their organization
10-Day Data Analysis with R
The 10-Day Data Analysis with R professional certificate course delivers a rigorous, high-level curriculum designed to bridge the gap between academic statistical theory and enterprise-level data science. Over two weeks, participants transition from fundamental R syntax and RStudio workspace optimization into mastering the robust Tidyverse ecosystem. The syllabus methodically covers the entire lifecycle of an enterprise data pipeline—from automated data ingestion and complex cleaning to advanced exploratory data analysis (EDA). By combining statistical computing fundamentals with predictive modeling, hypothesis testing, and regression analysis, this program arms analytical professionals with the mathematical and computational tools required to extract objective, high-integrity insights from messy organizational datasets. Engineered specifically for data analysts, institutional researchers, policy officers, and quantitative scientists, this instructor-led course prioritizes scalable, reproducible workflows. Beyond backend statistical programming, learners discover how to translate complex metrics into business intelligence through publication-quality graphics using ggplot2 and dynamic, interactive Shiny dashboards. The final module culminates in an end-to-end data analytics project, requiring participants to compile their scripts, empirical models, and data visualizations into automated, executive-ready Quarto reports. Graduates emerge with a robust technical portfolio and the professional autonomy needed to direct sophisticated data operations and support high-stakes, data-driven decision-making within their organizations.
Pizza Sales Data Project – Full Guided Analytics and Modeling Program
The Pizza Sales Data Project – Full Guided Analytics and Modeling Program is a rigorous, immersive case study designed to simulate the full lifecycle of an enterprise data science deployment. Over this intensive program, participants step into the role of a lead data consultant tasked with transforming a chaotic, multi-million-row commercial restaurant dataset into a highly optimized operational strategy. The curriculum bypasses isolated, theoretical exercises, forcing learners to confront the friction of real-world data engineering. Over the first phase, students construct robust data pipelines to ingest transaction logs, handle missing values, and execute complex feature engineering. By applying exploratory data analysis (EDA) alongside rigorous statistical modeling, participants uncover hidden customer behavior patterns, price elasticities, and operational bottlenecks that directly impact a business's bottom line. Engineered specifically for data analysts, business intelligence engineers, and quantitative consultants, this instructor-led program bridges the gap between backend computational modeling and executive-ready business insights. Beyond programming, participants translate their findings into interactive, production-grade dashboards and train predictive models to forecast demand, optimize inventory tracking, and automate menu engineering. The course culminates in a capstone portfolio presentation where learners defend their data models, deployment architectures, and data-driven recommendations against a simulated board of corporate stakeholders. Graduates emerge from this program with a comprehensive, end-to-end analytics project that demonstrates the precise technical authority and commercial acumen demanded by modern data teams.
Certificate of completion
Finish every course on this roadmap to unlock it.