This module introduces you to the fundamentals of Microsoft Excel, focusing on data cleaning, formatting, and analysis techniques. You’ll learn to use formulas, pivot tables, charts, and advanced functions like VLOOKUP and IF statements to manipulate and summarize data effectively. Designed for beginners and intermediate users, this module lays the foundation for understanding data structure and building basic dashboards. By the end, you'll be able to confidently perform data analysis and reporting tasks in Excel.
Learn how to retrieve, filter, and manage data using SQL (Structured Query Language), one of the most essential tools in data analytics. This module teaches you how to write queries, join multiple tables, use aggregate functions, and build data views. You’ll work with real datasets to practice these skills, giving you a strong grasp of how data is stored and accessed in relational databases—critical knowledge for any aspiring data analyst.
This module focuses on transforming raw data into interactive dashboards and visual insights using Microsoft Power BI. You'll learn how to connect data sources, create dynamic reports, and apply DAX (Data Analysis Expressions) to develop calculated columns and measures. The hands-on approach ensures you gain experience in building compelling visuals that support data-driven decisions. By the end, you’ll be able to present your data clearly and professionally for stakeholders and business teams.
Explore Python’s powerful data analytics libraries such as Pandas, NumPy, and Matplotlib. This module teaches you how to load, clean, analyze, and visualize data using Python. You'll also dive into basic statistics, loops, and functions to automate your analysis process. Designed for beginners, it equips you with coding skills that enhance efficiency and unlock advanced analytics capabilities. Python is a must-have tool in the modern analyst’s toolkit, and this module ensures you're ready to use it effectively.
This module emphasizes the importance of preparing high-quality data for analysis. You'll learn techniques for handling missing values, duplicates, inconsistent formatting, and outliers. Tools like Excel, Python, and SQL will be used to demonstrate real-world data wrangling workflows. Clean data leads to better insights, and this module ensures you understand how to assess data quality and apply preprocessing methods to make your datasets analysis-ready.
Put your skills to the test with hands-on projects and case studies drawn from various industries such as retail, healthcare, and finance. You’ll work on end-to-end analytics tasks—from data extraction and cleaning to visualization and reporting. This module helps you build a strong portfolio and boosts your confidence in solving practical business problems using data. It’s the perfect capstone to reinforce everything you’ve learned and demonstrate your readiness for real-world data roles.