Get started with the foundations of data analytics while learning your way around Excel. You’ll practice basic data formatting, navigation, and simple functions. At the same time, you’ll be introduced to AI in data analytics, exploring how tools like ChatGPT can generate project briefs, explain datasets, and support your learning. This module also covers ethical considerations of AI and includes hands-on labs and a quiz to reinforce your skills.

Learn how to clean and prepare data using formulas, functions, and conditional formatting. You’ll practice logical functions, auditing formulas, and ensuring data quality while exploring how AI tools like ChatGPT and Excel Copilot can generate and explain formulas, making the process faster and more accurate. A quiz helps solidify your skills.

Build your skills in cleaning and analyzing data with Excel tools like Flash Fill, Text-to-Columns, and pivot tables. You’ll explore descriptive statistics to uncover patterns and learn how to use Excel’s AI-powered Ideas tool to quickly generate insights from your data.

Learn to turn raw data into clear visual stories by creating charts, plots, and dashboards in Excel. You’ll apply the CRISP-DM project framework and explore AI-powered suggestions to enhance your dashboards. This module includes guided projects and a cumulative exercise to put your skills into practice.

Start working with databases by learning how to write basic SQL queries using commands like SELECT, WHERE, ORDER BY, and LIMIT. You’ll practice filtering and sorting data on real datasets while using AI tools such as ChatGPT to assist with query generation and debugging.

Take your skills further with GROUP BY, JOINs, and subqueries. You’ll learn how to join multiple tables, write subqueries, and perform aggregations, supported by hands-on labs to strengthen your understanding of relational data analysis.

Get started with Power BI by learning how to set up the tool, connect to data sources, and perform basic data transformations with Power Query. You’ll also explore natural language querying using the Power BI Q&A visual, making it easy to ask questions and get instant insights from your data.

Learn how to prepare and structure data effectively in Power BI by merging and appending datasets, creating reference queries, and profiling data. You’ll also leverage AI tools like Copilot to validate transformations, suggest optimizations, and ensure best practices in your data workflows.

Develop your Power BI skills by working with calculated columns, measures, and star schemas to create robust data models. You’ll also practice writing and testing DAX formulas, with support from AI tools like ChatGPT to generate and optimize measures such as running totals and year-over-year growth.

Learn to design and optimize professional dashboards in Power BI using visuals such as charts and KPIs. You’ll explore performance best practices and use the Smart Narrative visual to generate AI-driven insights automatically.

Take your dashboards to the next level by adding interactivity with slicers, bookmarks, and drill-through features. You’ll also apply time intelligence functions and clustering techniques to uncover trends and patterns, then publish interactive reports that bring your data to life.

In the Capstone Project, you’ll apply your skills to a real-world dataset using Excel, SQL, and Power BI, with AI tools supporting tasks like dashboard summaries, DAX writing, and SQL debugging. The course wraps up with Exam Prep, where you’ll reinforce your knowledge through quizzes, review sessions, and AI-generated mock questions designed to boost your confidence for final assessments