Lesson: Introduction to Data Analytics

1. Understanding Data Analytics

Data Analytics is the process of collecting, organising, and examining data to uncover
useful information, draw conclusions, and support decision-making. It helps
organisations understand what has happened, why it happened, and what might
happen next.
In today’s world, almost every action we take generates data — from buying
groceries online, posting on social media, or booking a flight, to using GPS on our
phones. Companies use this data to understand customer behaviour, improve
products, and make strategic decisions.
In simple terms, data analytics is like looking at a large pile of information and
finding patterns or stories hidden inside it.
Example:
Imagine you own a small bakery. You record how many loaves of bread you sell
every day for a month. By analysing this data, you might discover that sales are
highest on Fridays and Saturdays. This insight helps you bake more bread on
weekends and reduce waste during the week. That is data analytics in action.

2. Why Data Analytics Matters

Data analytics is vital because it turns raw information into actionable insights. Every
business, government, or individual making data-driven decisions can benefit from it.
Key benefits include:
1. Better decision-making: Instead of guessing, businesses rely on data to guide
choices.
2. Efficiency improvement: Data reveals where time, money, or resources are
being wasted.
3. Customer understanding: Analysing data about customers helps companies
tailor products or services to meet their needs.
4. Risk reduction: Data can highlight potential problems early, allowing
preventive measures.
5. Innovation: Insights from data often lead to new ideas, services, or products.
Example:
A retail store analyses customer purchase data and notices that umbrellas sell more
when rain is forecast. The manager decides to display umbrellas near the checkout
counter on rainy days. Sales increase — a clear example of using data analytics to
improve business performance.

3. The Data Analytics Process

The process of data analytics generally follows a structured path, often called the data
analytics lifecycle. It can be summarised in five main steps:
Step 1: Define the Question or Problem
Before analysing data, you must know what you want to find out.
Example: A school might want to know, “What factors influence students’ academic
performance?”
Step 2: Collect Data
Gather relevant data from reliable sources. Data can come from:

• Spreadsheets (like Microsoft Excel)

• Databases (such as SQL systems)

• Online sources or APIs

• Surveys and questionnaires

Example: The school collects data on attendance, study hours, and test scores.
Step 3: Clean and Prepare the Data
Raw data is rarely perfect. It may have missing values, duplicates, or errors. Cleaning
involves removing or correcting such issues.
Example: If some students’ attendance data is missing, you either fill it with an
average or remove those records.
Step 4: Analyse the Data
This is where you apply tools and techniques — such as Excel formulas,
visualisations, or statistical models — to find patterns and insights.
Example: The school might use Excel charts to compare attendance with exam scores
and discover that students with higher attendance tend to perform better.
Step 5: Interpret and Communicate Results
Finally, the results must be explained clearly, often using graphs, dashboards, or
written reports.
Example: The school’s management learns that improving attendance could lead to
higher grades, and decides to introduce attendance incentives.
This process helps transform raw data into meaningful conclusions that can influence
real-world decisions.

4. Types of Data Analytics

Data analytics can be divided into four main types, each answering different kinds of
questions.
1. Descriptive Analytics – “What happened?”
This type summarises historical data to understand trends or patterns.
Example: A coffee shop reviews last year’s sales and discovers that sales peak during
winter months.
2. Diagnostic Analytics – “Why did it happen?”
This digs deeper to find the causes behind outcomes.
Example: The coffee shop realises that higher winter sales occur because customers
buy more hot drinks when it’s cold.
3. Predictive Analytics – “What could happen next?”
Predictive analytics uses statistical models or machine learning to forecast future
events.
Example: The coffee shop predicts that next winter will bring a 15% increase in hot
drink sales based on past data.
4. Prescriptive Analytics – “What should we do about it?”
This form of analytics suggests actions to achieve the best possible outcome.
Example: The coffee shop decides to increase stock and hire extra staff during winter
to meet anticipated demand.
Each level builds on the previous one — starting from understanding what has
already happened to guiding future decisions.
 5. Types of Data
Before analysing, it’s important to understand the types of data you’ll encounter. Data
can generally be categorised as qualitative or quantitative.
• Qualitative Data: Descriptive information that cannot be measured numerically.
Example: Customer feedback like “The service was excellent.”
• Quantitative Data: Numeric information that can be measured and analysed.
Example: “200 customers rated the service 9 out of 10.”
Quantitative data can further be divided into:
• Discrete Data: Whole numbers (e.g. number of customers)
• Continuous Data: Measurable values that can take any range (e.g. temperature,
weight, or time)
Understanding the data type helps determine which tools or methods to use in your
analysis.

6. Data Sources and Formats

Data can come from multiple sources, such as:
• Spreadsheets: Excel files with sales or customer data
• Databases: Structured systems like SQL or Access
• APIs and Online Data: Real-time data from websites or applications
• Surveys and Reports: Responses collected manually or digitally
Data also comes in different formats:
• Structured data: Organised into tables (e.g., names, dates, numbers)
• Unstructured data: Text, images, or videos
• Semi-structured data: Email messages or JSON files that combine structure and
flexibility
For data analytics, structured data is often the easiest to begin with, especially when
using Excel or Power BI.
 7. Tools Used in Data Analytics
Data analysts rely on several tools, each serving specific purposes. Some of the most
widely used include:
• Microsoft Excel: Ideal for beginners. Used for data entry, cleaning,
calculations, and visualisations.
• SQL (Structured Query Language): For extracting and managing data from
databases.
• Power BI or Tableau: For creating interactive dashboards and visual reports.
• Python or R: For more advanced data analysis and automation.
Example:
A business analyst might use Excel to clean and prepare data, SQL to extract it from a
company database, and Power BI to create a dashboard that shows monthly sales
trends.

8. Real-World Examples of Data Analytics

1. Healthcare
Hospitals analyse patient data to predict disease outbreaks, monitor treatment
effectiveness, and manage resources efficiently.
2. Education
Schools use data analytics to identify students who may need extra support and to
improve teaching strategies.
3. Retail
Supermarkets track shopping habits to decide which products to promote, when to
offer discounts, and how to arrange items on shelves.
4. Sports
Teams use player performance data to plan strategies and improve training.
5. Government
Data analytics helps in traffic management, budgeting, and understanding population
trends.
These examples show that data analytics is not just for large corporations — it’s a
valuable tool across every industry.
 9. Challenges in Data Analytics
While powerful, data analytics comes with challenges that analysts must address:
1. Data Quality: Poor or missing data can lead to inaccurate results.
2. Data Privacy: Organisations must ensure that personal information is handled
ethically and securely.
3. Data Overload: Too much data can be overwhelming without proper tools or
methods.
4. Skills Gap: Understanding the technical and analytical skills needed to interpret
data correctly.
Learning how to manage these challenges is part of becoming a skilled data analyst.

10. The Role of a Data Analyst

A data analyst is a professional who collects, cleans, and interprets data to help
organisations make better decisions.
Their typical tasks include:

• Collecting and validating data

• Cleaning and preparing datasets

• Analysing and visualising data using tools like Excel and Power BI

• Presenting findings to stakeholders

A good data analyst is both technical and curious — they can use tools effectively,
but they also ask the right questions to uncover meaningful insights.

11. Conclusion
Data analytics is a cornerstone of modern decision-making. It allows individuals and
organisations to move beyond assumptions and make choices based on evidence.
Whether analysing sales in a local bakery, monitoring student performance, or
managing global business operations, data analytics provides the tools and insights
needed for success.
For new learners, the journey begins with understanding simple concepts — data
types, basic tools, and the analytical process. As skills grow, so does the ability to
work with larger, more complex data, leading to deeper insights and smarter
decisions.
The world is generating more data every second, and those who can analyse and
interpret it are shaping the future. Your journey into data analytics begins here —
with curiosity, logic, and the power to turn data into knowledge.

Lesson: Understanding Data Analytics

1. What is Data Analytics?
Data Analytics is the science of examining raw data to discover meaningful patterns, trends, and
insights that can help people or organisations make better decisions. It involves collecting data,
organising it, analysing it, and interpreting the results to answer specific questions or solve
problems.
In simpler terms, data analytics means learning from information. Instead of relying on intuition
or guesswork, it uses facts and evidence drawn from data to guide choices.
Data Analytics is not just about numbers — it’s about understanding what the data is trying to
tell you.
For example, every day we make small data-driven decisions without realising it. You might check
the weather app before deciding what to wear. That’s data analytics in action — you’ve gathered
data (the forecast), analysed it (it says it might rain), and made a decision (you take an umbrella).

2. The Everyday Importance of Data Analytics

Data Analytics plays a huge role in modern life, often behind the scenes. Whether you are shopping
online, watching a film, studying, or managing a business, data is constantly being generated and
used to improve experiences, products, and services.
In today’s world, data is sometimes called “the new oil.” Just like oil fuelled the industrial age, data
now fuels the digital age. Companies, governments, and individuals who can analyse and interpret
data have a powerful advantage.
Here’s how data analytics shapes our everyday lives:

• In business: Companies use data to understand customers, manage inventory, and improve
profits.

• In health: Hospitals use patient data to track diseases and improve treatments.

• In education: Schools use student performance data to identify areas for improvement.
 • In sports: Coaches analyse player data to design better strategies.

• In government: Cities analyse traffic data to reduce congestion and plan infrastructure.
Let’s explore these examples in more detail.

3. Real-World Examples of Data Analytics

Example 1: Business – Retail and Customer Insights
Imagine you run a small clothing shop. Every day, you record sales — what products are sold, at
what time, and to whom. After a few months, you notice patterns in your spreadsheet:

• More dresses sell during weekends.

• Jackets sell more in colder months.

• Younger customers buy more trendy clothes, while older customers prefer classic styles.
By analysing this data, you decide to increase your stock of dresses before weekends and plan a sale
on jackets in winter. You also adjust your marketing — promoting trendy outfits on social media for
younger customers.
Through data analytics, you have turned ordinary sales records into actionable insights that
increase profit and reduce waste.

Example 2: Healthcare – Improving Patient Outcomes

Hospitals and clinics use data analytics to improve patient care and prevent disease.
For instance, doctors might analyse patient data to find patterns in illnesses. If data shows that a
certain medicine works better for a particular age group or that a disease spreads more quickly
during a certain season, healthcare providers can act faster and save lives.
A hospital could also analyse appointment data and discover that many patients miss early morning
appointments. To improve attendance, it could schedule more appointments in the afternoon.
This is a simple but powerful example of how data analytics supports better healthcare
decisions.

Example 3: Education – Enhancing Learning Performance

Schools and universities increasingly use data analytics to monitor and improve student outcomes.
For example, a college might collect data on student attendance, participation, and exam results.
When analysed, it could reveal that students who attend tutorials regularly tend to score higher
marks.
This insight helps the school encourage more tutorial participation and support struggling students
early. Teachers also use data analytics to design more effective teaching strategies.
In this case, analytics helps educators understand how learning happens best.
Example 4: Sports – Performance and Strategy
Data analytics has transformed modern sports. Coaches, analysts, and even players use it to make
smarter decisions on and off the field.
Take football as an example. Analysts track every pass, shot, tackle, and run made during a match.
By analysing this data, they can identify:

• Which players are performing best under pressure

• Which tactics lead to more goals

• When a player might be fatigued or at risk of injury

For example, data might show that a team scores more goals when playing on the counterattack.
Coaches can then adjust their tactics accordingly.
Even fans see data analytics in action — think of statistics shown during televised matches, such as
“ball possession,” “pass accuracy,” or “expected goals.”
All of this is powered by data analytics in sports.

Example 5: Government and Urban Planning

Local governments and councils use data analytics to manage cities efficiently.
For instance, transport authorities collect data from road sensors, GPS devices, and public transport
systems. Analysing this data helps them understand traffic patterns, identify accident-prone areas,
and improve public transport routes.
Similarly, governments analyse population data to decide where to build new schools, hospitals, or
housing estates.
Through these analyses, cities become smarter, safer, and more efficient places to live.

4. Components of Data Analytics

To truly understand what data analytics involves, it’s useful to break it down into its main
components. These are the building blocks of the process.
1. Data Collection
This is the stage of gathering data from various sources. Data might come from sensors, online
transactions, surveys, or databases.
Example: A supermarket collects data through loyalty cards, tracking what products customers buy
and how often.
2. Data Cleaning
Raw data is often messy — it can contain duplicates, missing values, or errors. Cleaning ensures
that the data is accurate and ready for analysis.
Example: A business analyst removes incorrect phone numbers or fills in missing sales records
before analysis.
3. Data Analysis
Here, the cleaned data is studied using tools like Excel, SQL, or Power BI to identify trends or
patterns.
Example: A restaurant analyses its customer data to find out which meals are most popular at lunch
versus dinner.
4. Data Visualisation
Visualising data helps people understand it quickly. Charts, graphs, and dashboards are common
tools.
Example: A manager might view monthly sales data as a bar chart rather than a long list of
numbers.
5. Interpretation and Communication
Finally, the analyst draws conclusions and presents them in a simple way to guide decision-making.
Example: A teacher might present data showing that students who do more practice tests perform
15% better in final exams.

5. Data Analytics in the Digital Era

The rise of the internet, smartphones, and cloud computing has led to an explosion of data. Every
search, purchase, or message generates data that can be collected and analysed.
Modern businesses use technologies such as artificial intelligence (AI) and machine learning
(ML) to automate and enhance data analytics.
However, the essence of data analytics remains the same: turning information into understanding.
Even with complex systems, the goal is always to make better decisions using evidence.

6. Different Types of Data

For beginners, understanding the kinds of data being analysed is essential. Data generally falls into
two broad categories:

• Quantitative Data: Information that can be measured numerically (e.g. sales amount,
temperature, number of visitors).

• Qualitative Data: Descriptive information that expresses qualities or characteristics (e.g.

customer feedback, opinions, or colours).
Both types are valuable. Quantitative data gives measurable facts, while qualitative data provides
context and meaning.
Example:

• Quantitative: “500 people attended the concert.”

• Qualitative: “Most attendees said they loved the sound quality.”

A good data analyst often combines both to gain a complete picture.
7. The Role of a Data Analyst
A data analyst is a professional who gathers, processes, and interprets data to support decisions.
Their daily work might include:

• Extracting data from databases

• Cleaning and preparing datasets

• Performing calculations or statistical analysis

• Building charts and dashboards

• Writing reports or presentations explaining findings

Good analysts are not only technical but also curious and logical. They ask questions like “Why did
sales drop this month?” or “What factors influence customer loyalty?” and then use data to find
answers.

8. Why Learning Data Analytics Matters

In nearly every field today — business, education, healthcare, sports, and government — data
analytics is transforming the way people work.
Learning these skills opens up opportunities to:

• Make better personal or professional decisions

• Understand how information is used to shape policies or products

• Communicate insights clearly and confidently

For example, a small business owner who learns Excel and basic analytics can plan inventory more
efficiently. A teacher can track student performance. A health worker can identify trends in patient
recovery times.
In each case, data analytics empowers individuals to make informed decisions and add real value.

9. Conclusion
Understanding Data Analytics begins with recognising that data is everywhere — in our phones,
workplaces, schools, and cities. Every piece of information, when properly collected and analysed,
has the potential to reveal valuable insights.
From predicting when customers will buy a product to improving medical care or managing a
football team, data analytics helps people make smarter, evidence-based decisions.
For beginners, the key is to start small: learn how to observe data, ask good questions, and use
simple tools like Excel to explore and visualise results. As understanding deepens, you can move to
more advanced tools such as SQL, Power BI, or Python.
Ultimately, Data Analytics is not about numbers alone — it’s about stories, decisions, and the ability
to turn information into action. The more you understand data, the more you understand the world.
Lesson: Why Data Analytics Matters
1. Introduction
In the modern world, decisions are no longer made by instinct alone. Every business,
government, and individual who makes a decision benefits from one simple truth
— data tells a story.
Data Analytics is the process that translates that story into understanding. It takes raw
facts and figures and turns them into insights that explain what is happening, why it is
happening, and what can be done next.
Understanding why Data Analytics matters helps learners appreciate its value and see
how it influences nearly every aspect of our daily lives — from the advertisements
we see online to the health services we receive.

2. The Importance of Data-Driven Decisions

In the past, many organisations relied on experience, intuition, or trial and error to
make decisions. While experience is valuable, it can also be limited by bias or
guesswork. Data Analytics replaces this uncertainty with evidence-based decision-
making.
When decisions are driven by data, they are more likely to be accurate, measurable,
and successful. This is because data provides proof rather than assumptions.
For example:
A supermarket might notice that sales of certain items increase during specific
weather conditions. By analysing data, managers can stock up accordingly,
avoiding shortages or waste.
This kind of informed decision-making gives businesses an edge in a competitive
world.

3. Key Benefits of Data Analytics

There are several key reasons why Data Analytics matters so much. Below are five
major benefits, illustrated with simple, relatable examples across different fields.
 1. Better Decision-Making
At its core, Data Analytics helps people and organisations make better decisions
based on facts. Instead of asking, “What do I think?”, they can ask, “What does the
data show?”
Example: Business Management
A small café owner records sales for a month and notices that coffee sales peak
between 8 am and 10 am. Using this data, the owner decides to offer a morning
discount and hire more staff during those hours. As a result, the café becomes
more efficient and profitable.
Key Point: Data helps remove guesswork, replacing it with clarity and confidence.

2. Improved Efficiency and Productivity

By studying data, organisations can identify bottlenecks, waste, or inefficiencies in
their processes. Once these are discovered, improvements can be made to save time
and resources.
Example: Manufacturing Industry
A car manufacturer analyses data from its production line and discovers that one
machine frequently breaks down at specific times. The data shows a pattern — the
problem occurs after 8 hours of continuous use. The company decides to schedule
maintenance earlier and prevents costly downtime.
Key Point: Data Analytics streamlines operations and saves money.

3. Enhanced Customer Experience

Data helps businesses understand their customers’ needs, preferences, and
behaviours. When companies know what their customers like, they can tailor their
products, services, and communications accordingly.
Example: Online Retail
An online store analyses customer browsing and purchase data. It finds that people
who buy laptops often search for laptop bags shortly after. Using this insight, the
store begins recommending laptop bags during checkout. Sales increase
significantly.
Key Point: Data Analytics personalises experiences and strengthens customer
relationships.
 4. Risk Reduction and Fraud Detection
Data Analytics can identify potential risks before they become major problems. It
helps detect unusual patterns, preventing fraud, errors, or operational losses.
Example: Banking and Finance
Banks use data analytics to track transactions in real time. If a customer’s credit
card is suddenly used in a different country just minutes after being used locally,
the system flags it as suspicious and alerts the bank. This prevents possible fraud.
Key Point: Data-driven monitoring helps protect people and organisations from risks.

5. Driving Innovation and Growth

By studying data, organisations can uncover new opportunities for innovation. They
can identify emerging trends, customer demands, and areas where new products or
services can succeed.
Example: Healthcare and Medicine
Researchers analyse patient data from hospitals worldwide and notice that a particular
drug shows positive effects on a new illness. This discovery leads to further research
and eventually to new treatments that save lives.
Key Point: Data Analytics encourages innovation by revealing hidden possibilities.

4. Five Real-World Examples of Why Data Analytics Matters

To understand how powerful Data Analytics truly is, let’s look at how it shapes
different industries.

Example 1: Retail – Understanding Buying Patterns

Supermarkets use Data Analytics to study what customers buy and when. For
example, sales data might show that ice cream sales rise during school holidays or
that bread sales increase on weekends.
With this knowledge, supermarkets can adjust their stock levels, plan promotions, and
avoid running out of popular items. This means fewer losses, happier customers, and
higher profits.

Example 2: Healthcare – Predicting and Preventing Illness

Hospitals analyse large sets of patient data to detect patterns in diseases. For
instance, analysing data on flu cases might show that outbreaks often start in
certain regions or seasons.
Health authorities can then prepare vaccines or awareness campaigns in advance,
reducing the spread of disease and saving lives.

Example 3: Education – Improving Student Learning

Schools collect data on attendance, assessments, and class participation. When this
data is analysed, it can show which subjects students struggle with or which teaching
methods are most effective.
For example, if students who watch recorded lessons perform better, schools might
provide more video materials. Data Analytics ensures that teaching is targeted and
effective.

Example 4: Transport – Managing Traffic and Safety

Transport authorities analyse data from sensors, cameras, and GPS devices to manage
city traffic. By studying patterns, they can predict congestion and adjust traffic light
timings.
For example, if data shows heavy traffic every Monday morning on a specific route,
planners can suggest alternative routes or improve public transport in that area.
Data Analytics makes cities safer and more efficient.

Example 5: Sports – Enhancing Performance

Professional sports teams use data to track player performance, training, and game
strategies. By analysing match data, coaches can determine which tactics work best
and which players need rest or extra training.
For instance, a football coach might use analytics to see that the team scores more
goals when playing a 4-3-3 formation. That insight helps them plan future matches.
Data Analytics gives teams a competitive edge and improves performance.

5. Why the Global World Needs Data Analytics

Beyond individual industries, the entire global community relies increasingly on Data
Analytics. Here are five major reasons why the world needs it today.

1. Managing Global Challenges

The world faces complex challenges such as climate change, pandemics, and poverty.
Data Analytics helps scientists and policymakers understand these issues by
identifying causes, tracking trends, and testing solutions.
For example, environmental scientists use data to monitor global temperatures and
predict extreme weather events, helping governments prepare and respond
effectively.

2. Supporting Economic Growth

Countries use data analytics to manage economies, monitor employment rates, and
predict inflation or recession trends. Businesses use economic data to decide when to
expand or invest.
Data-driven economic planning ensures stability, growth, and better use of national
resources.

3. Enhancing Public Safety and Security

Data Analytics plays a major role in national and public safety. Security agencies
analyse data to detect suspicious activity, prevent cyberattacks, and identify threats
before they occur.
For instance, police forces use crime data to identify high-risk areas and allocate
patrols accordingly.
This leads to safer communities and faster response times.

4. Driving Technological Advancements

Technologies such as artificial intelligence, robotics, and smart devices all rely
heavily on data analytics. Data fuels these systems, allowing them to learn, predict,
and improve performance.
Without analytics, modern innovations like self-driving cars, voice assistants, and
predictive healthcare would not exist.

5. Promoting Sustainable Development

Governments and organisations use analytics to track progress towards sustainability
goals, such as reducing waste, conserving energy, and protecting natural resources.
For example, data analytics helps cities monitor energy consumption and design
smarter, greener solutions for transport and housing.

6. The Human Side of Data Analytics

Although Data Analytics is often associated with computers and numbers, it is
ultimately about people. Every dataset tells a human story — how we live, work,
learn, and interact.
When used responsibly, analytics improves quality of life:

• Businesses provide better products.

• Schools deliver better education.

• Hospitals offer better care.

• Governments make better policies.

The real value of data lies in how it is used to make life easier, fairer, and more
efficient for everyone.

7. Challenges and Responsibilities

While the benefits of Data Analytics are enormous, it must be used carefully and
ethically. Analysts must protect privacy, ensure data accuracy, and avoid misusing
information.
For example, customer data collected by a company should never be shared without
consent. Responsible data use builds trust and ensures analytics benefits society as a
whole.

8. Conclusion
Data Analytics matters because it empowers people and organisations to make
smarter, fairer, and faster decisions. It uncovers patterns that would otherwise remain
invisible and provides solutions to problems across every industry.
From helping a farmer predict weather patterns, to assisting doctors in diagnosing
diseases, to guiding governments in managing economies — Data Analytics shapes
the modern world.
In a world overflowing with information, those who can interpret data hold the power
to understand and improve it. That is why learning Data Analytics is not just a
technical skill — it is a life skill that enables informed thinking, critical reasoning,
and innovation in every field.
The more we understand data, the more capable we become of shaping a better, more
efficient, and more sustainable future.
Microsoft Excel for Data Analytics – 4-Week Intensive Training
Schedule
Week Session Topic Key Learning Points
- Understanding Excel interface (ribbon,
Week 1Introduction to
Session Getting Started worksheet, cells, ranges)- Workbook creation
Excel and Data
1 with Excel and management- Data entry and formatting
Foundations
basics- Data types (text, number, date)
- Sorting and filtering data- Using Find and
Session Working with
Replace- Data validation and drop-down lists-
2 Data
Basic conditional formatting
- Cell referencing (relative, absolute, mixed)-
Session Basic Formulas Arithmetic operations- SUM, AVERAGE,
3 and Functions COUNT, MAX, MIN- Text and logical
functions (LEFT, RIGHT, IF, AND, OR)
Session - Data cleaning and formatting practice- Mini-
Practical Exercise
4 project: preparing a clean dataset
Week 2Intermediate - Removing duplicates and blanks- Text-to-
Excel – Data Session Data Cleaning columns and Flash Fill- Handling missing
Management and 1 and Preparation data- Using TRIM, CLEAN, PROPER,
Analysis SUBSTITUTE
- VLOOKUP, HLOOKUP, XLOOKUP,
Advanced INDEX-MATCH- IFERROR, ISBLANK-
Session
Formulas and Date and time functions (TODAY,
2
Functions NETWORKDAYS, EOMONTH)- Nested
functions
- Sort and Filter for analysis- Conditional
Session Data Analysis formatting for insights- What-If Analysis (Goal
3 Tools Seek, Scenario Manager, Data Tables)-
Descriptive statistics in Excel
Session Hands-on - Case study: analysing business data- Short
4 Practice assessment on functions and analysis
Week 3Advanced - Creating and customising PivotTables-
Session PivotTables and
Excel for Data Grouping and filtering data- Calculated fields-
1 PivotCharts
Analytics Building PivotCharts and dashboards
- Data visualisation principles- Creating and
Data
Session formatting charts (column, line, pie, combo)-
Visualisation and
2 Dynamic dashboards using slicers and
Dashboards
formulas
- Power Query for data import and
Advanced Data
Session transformation- Power Pivot and Data Models-
Analysis
3 Creating relationships- Introduction to DAX
Techniques
(CALCULATE, SUMX)
Session - Building a complete dashboard- Group
Mini Project
4 project: data-driven insights presentation
Week 4Excel for - Recording and using macros- Basic VBA
Session
Business Intelligence Automating Tasks introduction- Dynamic ranges and named
1
and Reporting tables
 Week Session Topic Key Learning Points
Reporting and - Financial and sales performance analysis-
Session
Business Use Forecasting with Excel- KPI dashboards-
2
Cases Designing professional reports
- Connecting Excel to external data sources
Session Integration and
(CSV, SQL Server, Web)- Refreshing linked
3 Data Export
data- Preparing data for Power BI
- Capstone project: end-to-end Excel analysis-
Session Final Assessment
Group presentations- Transition to Power BI
4 and Presentation
overview

Learning Outcomes
By the end of the module, participants will be able to:

• Confidently perform data cleaning, analysis, and reporting in Excel

• Build interactive dashboards and visual analytics reports

• Use advanced formulas, Power Query, and PivotTables effectively

• Prepare and export structured data for use in Power BI and SQL

• Apply Excel to real-world business and data analysis scenarios

Would you like me to convert this schedule into a downloadable PDF or Word
document with your school’s branding and logo (if you provide it)?

Microsoft Excel for Data Analytics

Duration: 4 Weeks (Intensive Training)
Format: 3–4 sessions per week, 2–3 hours per session
Goal: To equip participants with the knowledge and skills to use Microsoft Excel
effectively for data analysis, business reporting, and decision-making.

Week 1: Introduction to Microsoft Excel and Data Foundations

Objective: Build fundamental understanding of Excel’s interface, navigation, and
basic data handling.
Session 1: Getting Started with Excel

• Introduction to Excel interface (ribbon, worksheet, cells, and ranges)

 • Workbook management (creating, saving, and navigating files)

• Data entry and editing

• Formatting basics (fonts, cell styles, borders, and colours)

• Understanding data types (text, numbers, dates)

Session 2: Working with Data

• Sorting and filtering data

• Using Find and Replace

• Data validation and drop-down lists

• Basic formatting for reports (conditional formatting basics)

• Understanding and fixing common data entry errors

Session 3: Basic Formulas and Functions

• Introduction to formulas and cell referencing (relative, absolute, and mixed)

• Arithmetic operations

• Common functions: SUM, AVERAGE, COUNT, MAX, MIN

• Text functions: LEFT, RIGHT, MID, CONCAT, TEXTJOIN

• Logical functions: IF, AND, OR, NOT

Session 4: Practical Exercise

• Hands-on data cleaning and basic analysis task

• Small project: Preparing a clean dataset for analysis

Week 2: Intermediate Excel – Data Management and Analysis

Objective: Enable participants to manipulate, clean, and analyse data using
intermediate Excel features.
Session 1: Data Cleaning and Preparation

• Removing duplicates and blanks

• Text-to-columns and Flash Fill

• Handling missing data

 • Using functions for data cleaning (TRIM, CLEAN, PROPER, SUBSTITUTE)

• Working with named ranges

Session 2: Advanced Formulas and Functions

• Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH

• Error handling: IFERROR, ISBLANK

• Date and time functions: TODAY, NETWORKDAYS, EOMONTH

• Nested functions for complex calculations

Session 3: Data Analysis Tools

• Using Sort and Filter effectively

• Conditional formatting for insights

• Using What-If Analysis tools (Goal Seek, Scenario Manager, Data Tables)

• Basic descriptive statistics in Excel (mean, median, mode, standard deviation)

Session 4: Hands-on Practice

• Case study: Cleaning and analysing a small business dataset

• Short assessment on intermediate Excel functions

Week 3: Advanced Excel for Data Analytics

Objective: Develop strong analytical and data visualisation capabilities using
advanced Excel features.
Session 1: PivotTables and PivotCharts

• Creating and customising PivotTables

• Grouping and filtering PivotTables

• Calculated fields and items

• Building PivotCharts and dashboards

• Slicers and timelines for interactivity

Session 2: Data Visualisation and Dashboards

• Best practices for data visualisation

 • Creating charts: column, line, bar, pie, combo, scatter

• Formatting charts for storytelling

• Building dynamic dashboards using charts, slicers, and formulas

Session 3: Advanced Data Analysis Techniques

• Using Power Query for data import and transformation

• Introduction to Power Pivot and Data Models

• Creating relationships between tables

• Basic introduction to DAX formulas (CALCULATE, SUMX)

Session 4: Mini Project

• Building a complete dashboard from raw data

• Group project: Presenting data-driven insights

Week 4: Excel for Business Intelligence and Reporting

Objective: Integrate Excel into the wider BI ecosystem and prepare for Power BI
transition.
Session 1: Automating Tasks

• Using macros and recording basic VBA

• Automating repetitive reporting tasks

• Dynamic ranges and named tables for automation

Session 2: Reporting and Business Use Cases

• Financial analysis and forecasting with Excel

• Sales performance analysis

• KPI dashboards

• Creating professional report templates

Session 3: Integration and Data Export

• Connecting Excel to external data sources (CSV, SQL Server, Web)

• Refreshing and updating linked data

 • Exporting and preparing data for Power BI
Session 4: Final Assessment and Presentation

• Capstone project: Comprehensive Excel analysis and report

• Group presentations and feedback session

• Transition briefing: Moving from Excel to Power BI

Learning Outcomes
By the end of the Excel module, participants will be able to:

• Confidently use Excel for data cleaning, transformation, and analysis

• Build interactive dashboards and visual reports

• Use advanced formulas and automation for efficiency

• Prepare and structure data effectively for Power BI and SQL integration

• Apply Excel skills in real-world business and data analytics contexts

Would you like me to format this into a table layout (for easier printing or sharing
with participants)?