Enrolment options

Fundamentals of Data Analytics

Welcome to the course “Fundamentals of Data Analytics”. This course is designed to provide you with practical knowledge and skills in data analysis and Business Intelligence (BI) using the ...

Enroll Now

Course Objective

Welcome to the course “Fundamentals of Data Analytics”. This course is designed to provide you with practical knowledge and skills in data analysis and Business Intelligence (BI) using the Microsoft Power BI tool.

Key Modules

Learning unit 1 Glossary of Terms
Concise definitions of key terms, concepts, and Power BI features from Modules 1-7.


Module 1: Foundations of Data Analytics

Focus: Introduction to BI, Data Storytelling, and Power BI Ecosystem.

●       Data Analytics: Analyzing data to find trends and build meaningful stories for decision-making.

●       Business Intelligence (BI): Strategies and technologies converting data into insights via a 5-step process.

●       5-Step BI Process: The core framework: 1. Gather, 2. Store, 3. Model, 4. Visualize, 5. Share.

●       Power BI Desktop: Local app to connect, transform, model data, and design reports.

●       Power BI Service: Cloud platform for publishing, sharing, and collaborating on reports.

●       Quantitative Analysis: Analysis using measurable numerical data (e.g., Revenue).

●       Qualitative Analysis: Analysis using non-numerical descriptive data (e.g., Feedback).

●       Quick Insights: AI feature automatically discovering and visualizing data patterns.

●       Q&A: NLP feature generating visuals from plain English questions.

 

Module 2: Data Cleaning & Preparation

Focus: Power Query, ETL, and Data Quality.

●       Power Query Editor: Interface to connect and refine data before loading into the model.

●       ETL (Extract, Transform, Load): Workflow to extract, clean/shape, and load data.

●       Dirty Data: Data with errors, nulls, duplicates, or inconsistencies needing cleaning.

●       Data Shaping: Structuring data layout (filtering rows, changing types) for analysis.

●       Applied Steps: Chronological audit trail of transformations allowing undo/modify.

●       Null Value: Marker indicating missing data or "no value".

●       Replace Values: Command to fill missing data with a standard value.

●       Column From Examples: Generates new columns by recognizing patterns in user inputs.

●       Trim: Removes accidental whitespace from the start and end of a string.


Module 3: Data Modeling

Focus: Relationships, Star Schema, and DAX.

●       Data Modeling: Connecting tables to build a unified analytical engine.

●       Star Schema: Standard model with a central Fact Table linked to surrounding Dimension Tables.

●       Fact Table: Central table with transactional data (e.g., Sales). Typically long and dynamic.

●       Dimension Table: Lookup table with descriptive attributes (e.g., Products). Typically wide and static.

●       Relationship: Connection linking a Dimension Primary Key to a Fact Foreign Key.

●       Metric: Business term for a quantifiable number (the question to answer).

●       Measure: Dynamic DAX formula calculating a metric based on context (e.g., SUM(Revenue)).

●       Calculated Column: Static row-by-row calculation stored in the table.

●       DAX: Formula language for creating custom measures and calculated columns.

●       CALCULATE: Function evaluating an expression in a modified filter context.


Module 4: Data Visualization

Focus: Charts, Interactivity, and Reporting.

●       Visualizations Pane: Toolbox containing chart types and configuration wells.

●       Clustered Column Chart: Standard chart comparing values across categories.

●       Card Visual: Visual displaying a single high-level KPI.

●       Slicer: Interactive on-canvas filter for segmenting report data.

●       Drill-down: Navigation from high-level hierarchy to details within a visual.

●       Matrix: Grid visual supporting grouping/drill-down (similar to Pivot Tables).

●       Interactive Reporting: Design principle where clicking one visual cross-filters others.


Module 5: Storytelling & Dashboard Design

Focus: UX/UI, Navigation, and Narrative.

●       Data Storytelling: Structuring analysis to drive narrative and insights, not just present data.

●       3-Act Structure: Narrative flow: 1. Context (Setup), 2. Conflict (Findings), 3. Resolution (Action).

●       Bookmarks: Captures report state (filters, visibility) for custom navigation.

●       Page Navigator: Button element automatically generating a clickable page menu.

●       What-if Parameter: Dynamic slicer for testing hypothetical variables/scenarios.

●       Smart Narrative: AI visual generating textual summaries of key takeaways.


Module 6: Text Analysis (Sentiment)

Focus: Unstructured Data and Sentiment Logic.

●       Unstructured Data: Data without a predefined model (e.g., free-text feedback).

●       Word Cloud: Visualization showing word frequency via size.

●       Sentiment Analysis: Detecting emotional tone (Positive, Negative, Neutral) in text.

●       Word Frequency: Count of specific keyword occurrences.

●       Conditional Column: Logic-based categorization (e.g., If Score > 0 then "Positive").


Module 7: Capstone & Business Analysis

Focus: End-to-End Project and Business KPIs.

●       Pareto Principle: 80/20 rule stating ~80% of outcomes come from ~20% of causes.

●       ABC Analysis: Categorizing inventory by value (High/Medium/Low) for prioritization.

●       KPI: Quantifiable measure evaluating success against objectives.

●       MoM (Month-over-Month): Metric comparing current vs. previous month performance.

●       YoY (Year-over-Year): Metric comparing current vs. same period last year.

●       Dead Stock: Inventory items with no sales transactions over a specific period.

 

Learning unit 2 Module 1: What Is Data Analytics? How Power BI Helps You Tell Stories with Numbers

This module is the starting point of your journey to becoming a data storyteller. Together, we will decode core concepts, familiarize ourselves with powerful tools, and take the first steps to turn raw data into insightful and meaningful charts and reports, unlocking a whole new level of analytical skill.

Duration: 0,5 hours

Competencies

Upon completing this module, learners will achieve the following competencies:

● Understand and present the foundational concepts of data analysis and Business Intelligence (BI). 
● Differentiate between quantitative and qualitative analysis.
● Become familiar with and identify the main components of the Power BI ecosystem.
● Perform basic data import operations from common sources.
● Recognize the role and application of Artificial Intelligence (AI) and Machine Learning (ML) in the modern BI landscape.

Learning Objectives:

By the end of this module, learners will be able to:

● Define the terms "Data Analysis" and "Business Intelligence".
● Describe the five core steps of a BI project.
● List and explain the roles of the three main components: Power BI Desktop, Power BI Service, and Power BI Mobile.
● Successfully install the Power BI Desktop application on their computers.
● Perform the task of importing data from an Excel file into Power BI Desktop.
● Use basic AI features like Quick Insights and Q&A to automatically explore data.

Learning unit 3 Module 2: Cleaning Data – Getting It Ready for Insights

Introduction

Welcome to Module 2. In the BI Process we learned about in Module 1, this is where we focus on the crucial 'Gather' and 'Transform' steps. In this module, we will dive deep into one of the most critical and time-consuming parts of data analysis: data cleaning and preparation. 

Did you know? Data analysts spend up to 80% of their time just cleaning data!

Cleaning data
Real-world data is rarely perfect. You’ll often face:
  • Errors
  • Missing values
  • Inconsistencies

The quality of your insights is only as good as the quality of your data.

That’s why learning how to clean and transform “dirty data” is one of the most critical skills for data analysts.

Duration: 3 hours

Learning Competencies

Upon completing this module, learners will achieve the following competencies:

  • Apply common data cleaning and transformation techniques to address complex data quality issues. 

  • Proficiently use the Power Query Editor interface and its main features to build an automated data preparation workflow.

  • Leverage AI-assisted features in Power Query Editor to automate and accelerate the data preparation process.

  • Understand and explain the importance of data shaping in creating an effective and accurate data model.

Learning Objectives

By the end of this module, learners will be able to:

  • Launch and navigate proficiently within the Power Query Editor environment.

  • Perform data cleaning operations such as removing duplicate rows, handling nulls and errors, and correctly changing data types.

  • Apply advanced text transformations like splitting columns, merging columns, extracting information, and reformatting text.

  • Use the "Column From Examples" feature to create new columns based on AI-inferred logic.

  • Use the "Data Profiling" and "Column Quality" tools to quickly assess and diagnose data quality issues.

Learning unit 4 Module 3: Connecting Data and Performing Simple Calculations with DAX

Introduction

Step 3. Model

Welcome to Module 3. In the 5-step BI process we've learned, this is the third step: Model. If Module 2 was the process of preparing high-quality "ingredients," then Module 3 is where we write the "recipe" – the thing that will combine those ingredients to create a complete "dish" in the form of an intelligent report. After getting a clean dataset, the next step is to build the "brain" of your report, transforming static data tables into a dynamic analytical model. In this module, you will learn how to connect data tables into a unified model. More importantly, you will get acquainted with DAX (Data Analysis Expressions) – Power BI's powerful formula language – not from a complex programming perspective, but as a tool to "ask questions" and command your data to create meaningful metrics from raw data.

What is a Metric? A metric is a general term for a number that quantifies something (e.g., "Total Enrollments," "Average Grade"). It's the specific calculation you want to see. In Power BI, we create these metrics by writing formulas called Measures. Think of a metric as the question you want to answer with data, and a Measure as the technical tool to get that answer.

Duration: 2,5 hours

Context and Mission

Context
Imagine you are a data analyst for a university. The Dean needs a report to answer core questions about academic performance. The raw data only shows individual enrollments, but he needs a consolidated view to answer questions like:
●      "What is our total number of enrollments?"
●      "How many distinct students are participating in courses?"
●      "Overall, what is the average student grade?"
●      "More importantly, how many enrollments are considered 'passing'?"
●      "How can we compare all these metrics across different Departments and see how they change over the Years?"

Mission
To answer these questions, your mission in this module is to build the analytical foundation for the report. You will start by connecting the data tables into a logical model. Then, you will use DAX to create specific measures to answer each of the questions above. Finally, you will consolidate all these metrics into a single Matrix visual, allowing the dean to have a multi-dimensional view of the university's performance.

Learning Competencies

Upon completing this module, learners will be able to:
● Build and explain a Star Schema data model, a powerful and efficient structure that serves as the backbone for any professional report.
● Differentiate and choose the right time to use Measures and Calculated Columns, a critical distinction that affects the performance, flexibility, and accuracy of the report.
● Proficiently use basic DAX functions (COUNT, DISTINCTCOUNT, AVERAGE) and the conditional function CALCULATE to move from simply viewing data to performing real analysis.
● Visualize the newly created metrics using a Matrix visual to present complex, multi-dimensional data clearly and digestibly, similar to advanced PivotTables.

Learning unit 5 Module 4: Make Your Data Speak – Choosing the Right Charts

Introduction


Welcome to Module 4. In the BI process, this is the fourth step: Visualize. After having a solid data model and powerful DAX calculations from Module 3, it's time to turn those numbers and relationships into intuitive, easy-to-understand visuals. In this module, you will learn how to select and use different types of charts in Power BI to explore data, identify trends, improve the user experience, and make your data truly "speak." This is where your analysis transforms from a collection of tables and numbers into a compelling story that can inform and persuade your audience.

Duration: 3 hours

Competencies

Upon completing this module, learners will achieve the following competencies:

  • Select the appropriate chart type to answer a specific business question.

  • Build and customize common visuals in Power BI.

  • Use filters, slicers, and drill-down features to create highly interactive reports.

Learning Objectives

By the end of this module, learners will be able to:

  • Create and format common visuals: Bar, Line, Pie, Table, Matrix, Card.

  • Add and configure Slicers and filters in the Filter Pane.

  • Use the drill-down feature to view data at different levels of detail.

Learning unit 6 Module 5: Dashboard Design and Storytelling with Data

Introduction

Welcome to Module 5, the turning point in your data analysis journey. If the previous modules equipped you with the "raw materials" and "tools"—the ability to clean data, build models, and create individual visuals—this module will teach you how to be an "architect" and a "storyteller." This is the stage that determines the success of an analysis project, where we shift from merely "presenting data" to "driving a purposeful narrative."

We will explore the core principles of design and user experience (UX/UI) optimization to ensure your reports are not only aesthetically pleasing but also intuitive and easy to use. You will learn to build highly interactive, multi-page reports, and most importantly, you will learn how to structure your analyses into a story with a clear beginning, middle, and end, thereby driving informed decisions.

Duration: 4 hours


Competencies

Upon completing this module, learners will achieve the following competencies:

  • Design Thinking: Apply basic principles of design and UX/UI to create reports that are readable, aesthetic, and effective in conveying information.

  • Report Architecture: Build complex multi-page reports with a logical and user-friendly navigation system.

  • The Art of Storytelling: Use data storytelling techniques to structure findings and insights into a coherent, impactful, and persuasive narrative.

  • Technology Integration: Integrate advanced analytics and Artificial Intelligence (AI) features into reports to enrich and automate the data story.


Learning Objectives

By the end of this module, learners will be able to:

  • Design and implement a complete multi-page report using Bookmarks and Buttons to create a seamless navigation experience.

  • Create and use What-if Parameters to perform scenario analysis, allowing end-users to explore different assumptions.

  • Apply the three-act narrative structure (Setup - Conflict - Resolution) to draft and build a purposeful data story.

  • Integrate insights from Q&A and Smart Narratives to automate explanations and deepen the data story.

Learning unit 7 Module 6: Decoding Feedback – Word Clouds, Keywords, and Simple Text Analysis

Introduction

Welcome to Module 6, Decoding Feedback – Word Clouds, Keywords, and Simple Text Analysis. This module is a vital bridge between numerical data and natural language. We will transition from analyzing numbers to "Decoding" student language using the available tools within Power BI. Feedback data is a precious source of information. This module will guide you on how to extract Keywords, measure Word Frequency to create Word Clouds, and perform Simple Text Analysis to transform language into measurable metrics, helping you gain deep insights into the student learning experience.

Duration: 4 hours

Contextual Mission (Connecting to Module 5)

Recall that Module 5 focused on turning data findings into a persuasive Data Story with a clear call to action. Raw data (like enrollment figures or course completion rates) often only provides the what.

The mission of this module is to generate the high-impact insights (the why) necessary for a coherent narrative. We will convert unstructured student feedback into measurable metrics (Sentiment Score, Instructor Performance) that allow you to build a story centered around "How the student experience (sentiment) impacts academic outcomes (scores)", directly supporting the storytelling techniques you have learned.

Learning Objectives

Upon completing this module, learners will achieve the following competencies:

    • Text Processing in Power Query: Apply ETL (Extract, Transform, Load) techniques to clean, standardize, and separate text data (Tokenization).

    • Structured Information Extraction: Use Text functions to extract critical information (e.g., Instructor Name) from unstructured data (Feedback).

    • Simulated Sentiment Analysis (Lexicon-based): Build Custom Columns to assign Positive/Negative sentiment scores.

    • Unstructured Data Visualization: Use Word Cloud and comparison charts to present text analysis results.

    • Data Integration: Link unstructured data (sentiment) with structured data (scores) to find correlations.

Learning unit 8 Module 7: Building a Comprehensive Report – A Retail Analysis Case Study

Introduction

Welcome to Module 7. This is a project-based module where we will synthesize all the skills learned throughout the course to solve a complete business analysis problem.

While previous modules provided you with individual tools—data cleaning (Module 2), modeling (Module 3), charting (Module 4), and storytelling (Module 5)—in this module, we will step into the shoes of a real data analyst, undertaking a project from receiving raw data to presenting actionable recommendations.

This module is not just a technical exercise; it simulates a real-world workflow where you must understand the business context, translate requirements into specific analyses, and finally, present the results persuasively. We will apply the entire 5-step BI process to an online retail dataset, turning discrete numbers into a meaningful business story that can drive decisions.

Duration: 3 hours

Competencies

Upon completing this module, learners will achieve the following competencies:

    • Apply the entire BI analysis process (Gather, Transform, Model, Visualize, Interpret) to a real-world case study: Learners will no longer see the steps individually but will understand the connection and importance of each stage in an overall project.

    • Build an effective Star Schema data model from various data sources: Master the industry-standard way of building data models to optimize report performance and ensure the accuracy of analyses.

    • Analyze and interpret core business KPIs to evaluate performance: Be able to identify and calculate key metrics and understand the meaning behind the numbers to assess business health.

    • Design an interactive, aesthetic, and narrative-driven dashboard to convey findings persuasively: Move beyond creating simple charts to designing a structured, logical, user-friendly report that guides the viewer through a coherent data story.



Learning Objectives

By the end of this module, learners will be able to:

    • Connect to and clean data from an Excel file containing multiple sheets using Power Query Editor: Practice common data processing techniques to ensure a clean and reliable input data source.

    • Establish correct one-to-many relationships in the Model View: Build the "brain" of the report, allowing different data tables to "communicate" and filter each other correctly.

    • Write DAX formulas to calculate key metrics such as revenue, number of orders, and cancellation rate: Translate business questions into specific measurements using Power BI's formula language.

    • Build an interactive, multi-page dashboard with charts, slicers, and KPI cards: Create a complete analytical product that allows users to explore the data from various perspectives.

    • Derive business recommendations based on insights found in the data: Take the final and most crucial step of an analyst: turning findings into valuable, actionable proposals for the business.

Learning unit 9 Final Assessment
Learning unit 10 Credits & Licensing


This course integrates a variety of multimedia resources, AI-generated content, licensed design tools, and selected open-access materials. To ensure transparency and responsible content use, we provide this summary of all tools and resources used in course development. All materials have been applied in accordance with their respective licenses and terms of use.

🎨Visual and Design Assets
    • Canva Pro – Licensed design elements and graphics.

    • Freepik – Images used in compliance with Freepik's free-use license; attribution provided where applicable.

✏️ Custom-Designed Visuals

Some visuals, diagrams and videos were originally created by the course’s instructional designer. These are original works and are used with full rights for instructional purposes in this course.

🔊Audio Narration
    • Narakeet – Licensed tool for generating audio narration and voiceovers.

📚Open Educational Resources & Creative Commons Content

This course may include content adapted from open educational resources (OERs) and Creative Commons (CC)-licensed materials. These resources have been used and adapted in accordance with their stated license terms. Attribution is provided where feasible and required. If you believe any content requires additional acknowledgment, please contact the course provider.

🧾 Instructional Content

All instructional content is original or responsibly adapted. This course is intended solely for educational distribution via the Atingi platform and is not for commercial resale or redistribution.

Learning unit 11 Additional resources

Here are some extra materials to help you explore the course topics further. These resources are textbooks, lectures, and tools to support your learning.

Please take some time to go through them and deepen your understanding.

1. Deckler, G., & Powell, B. (2024). Microsoft Power BI Cookbook (3rd ed.). Packt Publishing.

2. Larson, B. (2020). Data Analysis with Microsoft Power BI. McGraw-Hill Education.

3. Microsoft. (n.d.). Power BI documentation. Microsoft Learn. Retrieved from
https://learn.microsoft.com/en-us/training/powerplatform/power-bi

Learning unit 12 Certificate

To successfully earn your certificate for this course, please ensure you meet the following requirements:

Guests cannot access this course. Please log in.