Salesforce Reports, Dashboards & Analytics – A beginner‑friendly guide
This course is divided into three friendly modules. Each module builds on the previous one, using simple language, fun stories, and plenty of examples from Nigeria and everyday life.
| Module | Title | What you'll learn |
|---|---|---|
| 1 | Reports – Asking Questions of Your Data | What reports are, how to create them, and how to filter and group data. |
| 2 | Dashboards – Seeing the Big Picture | How to build dashboards, use charts, and tell stories with data. |
| 3 | Analytics – Making Smart Decisions | How to interpret data, spot trends, and use analytics to improve your business. |
📖 35 sections – from a fun story about a school market day to your first report.
📊 30+ sections – turn your reports into beautiful dashboards.
⚡ 25+ sections – use data to make better choices.
Each module includes a mix of:
| Type | Examples |
|---|---|
| 📝 Written | Fill‑in‑the‑blanks, true/false, short answers |
| 🧠 Thinking | Review questions, scenario‑based exercises |
| 🤝 Group | Role‑play, group activities, classroom discussions |
| 🎯 Practical | Mini‑projects, challenge exercises, building reports on paper |
🌟 Remember: Data is like a treasure map – it shows you where to go! Let's go! 🚀
Salesforce Reports, Dashboards & Analytics – Module 1: Reports – Asking Questions of Your Data
Hello, young data explorer! 👋 Have you ever wanted to know how many goals your favourite football team scored this season? Or how many books you read last month? When you want an answer to a question like that, you need to look at information – that's called data.
In Salesforce, we have lots of data – names of customers, sales amounts, phone numbers, and much more. But just having data is not enough. We need to ask questions and get answers. That's where reports come in. A report is like asking Salesforce a question and getting a list of answers.
In this module, we will learn what reports are, how to create them, and how to use filters and groups to get exactly the information we need. By the end, you'll be able to ask Salesforce any question and get the answer quickly!
Ready to become a report expert? Let's go! 🚀
After studying this module, you will be able to:
There was a school in Lagos that organised a market day. Each class had a stall selling things – food, toys, books, and clothes. At the end of the day, the teachers wanted to know which stall made the most money.
Mrs. Okafor, the head teacher, asked each class to write down how much they sold. She had a big sheet of paper with all the numbers. But it was a mess! She couldn't tell which class sold the most, or which item was most popular.
Her daughter, Ada, said, "Mummy, why don't you make a list? Write each class and their sales. Then you can see everything clearly." Mrs. Okafor made a simple table:
Class │ Sales (₦) ------ │ ----------- Class 1│ 5,000 Class 2│ 7,500 Class 3│ 3,000 Class 4│ 9,000 Class 5│ 6,500
Now she could see that Class 4 made the most money. She could also add a total to see how much the whole school raised. That simple table was a report – it answered her question!
Definition: A report is a list of information that answers a question.
Why important: Reports help you find answers quickly and make better decisions.
Simple explanation: Like asking your teacher for a list of everyone who scored above 80% in the test.
Real-life example: A shop manager runs a report to see which products are selling fastest.
School example: Your class monitor makes a report of who brought lunch and who didn't.
Home example: Your mum makes a list of groceries you need to buy – that's a report.
Nigerian example: A distributor in Kano runs a report to see which states ordered the most rice this month.
Illustration:
REPORT = A LIST OF INFORMATION ┌──────────────────────────────────────────┐ │ Customer Name │ Product │ Amount │ │ Mr. Ade │ Rice │ 50 bags │ │ Mrs. Okafor │ Beans │ 30 bags │ │ Alhaji Bello │ Oil │ 20 cans │ └──────────────────────────────────────────┘
Mini summary: A report is a list that answers a question about your data.
Definition: We use reports to find answers, spot patterns, and make smart decisions.
Why important: Without reports, you have to guess – and guessing can be wrong.
Simple explanation: Like using a map instead of wandering around – reports show you the way.
Real-life example: A manager uses a report to see which salesperson is doing best.
School example: A teacher uses a report to see which students need extra help.
Home example: Your dad uses a report of expenses to see where the money went.
Nigerian example: A farmer uses a report to see which crop sold the most.
Illustration:
WHY REPORTS? ┌────────────────────────────────────────────┐ │ Find answers → Spot patterns → Decide │ └────────────────────────────────────────────┘
Mini summary: Reports help you find answers and make better decisions.
Definition: Data is information – like names, numbers, and dates.
Why important: Reports work with data – without data, there is no report.
Simple explanation: Like ingredients for a cake – data is the ingredients, reports are the cake.
Real-life example: Customer names, phone numbers, and sales amounts are data.
School example: Student names, grades, and attendance records are data.
Home example: Your shopping list items are data.
Nigerian example: A trader's sales records are data.
Illustration:
DATA = INFORMATION ┌────────────────────────────────────────────┐ │ Name: Chidi │ │ Phone: 080-xxx-xxxx │ │ Sales: ₦10,000 │ └────────────────────────────────────────────┘
Mini summary: Data is information like names, numbers, and dates.
Definition: There are different types of reports: Tabular, Summary, Matrix, and Joined.
Why important: Each type is used for a different purpose.
Simple explanation: Like different types of knives – you use the right one for the job.
Real-life example: A Tabular report is a simple list. A Summary report groups data.
School example: A Tabular report of all students. A Summary report of students by class.
Home example: A simple list of chores (Tabular). A grouped list by person (Summary).
Nigerian example: A list of customers (Tabular). A summary by state (Summary).
Illustration:
REPORT TYPES ┌────────────────────────────────────────────┐ │ Tabular → Simple list │ │ Summary → Grouped data │ │ Matrix → Cross-tabulated data │ │ Joined → Data from multiple objects │ └────────────────────────────────────────────┘
Mini summary: There are different types of reports for different needs.
Definition: A Tabular report is a simple list of data, like a table.
Why important: It's the easiest type of report to create.
Simple explanation: Like a shopping list – just a list of items.
Real-life example: A list of all your customers.
School example: A list of all students.
Home example: A list of groceries to buy.
Nigerian example: A list of all orders placed.
Illustration:
TABULAR REPORT ┌──────────────────────────────────────────┐ │ Customer Name │ Phone │ City │ │ Mr. Ade │ 080-xxx │ Lagos │ │ Mrs. Okafor │ 080-yyy │ Abuja │ │ Alhaji Bello │ 080-zzz │ Kano │ └──────────────────────────────────────────┘
Mini summary: Tabular reports are simple lists of data.
Definition: A Summary report groups data together, like by city or by product.
Why important: It helps you see totals and averages for each group.
Simple explanation: Like sorting your toys into boxes – cars in one box, dolls in another.
Real-life example: Sales grouped by region – North, South, East, West.
School example: Students grouped by class.
Home example: Chores grouped by person – who does what.
Nigerian example: Sales grouped by state.
Illustration:
SUMMARY REPORT ┌──────────────────────────────────────────┐ │ City │ Total Sales │ # Customers │ │ Lagos │ ₦50,000 │ 10 │ │ Abuja │ ₦30,000 │ 6 │ │ Kano │ ₦20,000 │ 4 │ └──────────────────────────────────────────┘
Mini summary: Summary reports group data to show totals.
Definition: A Matrix report shows data in rows and columns, like a spreadsheet.
Why important: It helps you compare two things at once.
Simple explanation: Like a timetable – rows are days, columns are subjects.
Real-life example: Sales by region and by product.
School example: Grades by subject and by student.
Home example: Chores by day and by person.
Nigerian example: Sales by state and by product.
Illustration:
MATRIX REPORT ┌──────────────────────────────────────────┐ │ │ Lagos │ Abuja │ Kano │ │ Rice │ ₦20k │ ₦15k │ ₦10k │ │ Beans │ ₦15k │ ₦10k │ ₦5k │ │ Oil │ ₦10k │ ₦5k │ ₦3k │ └──────────────────────────────────────────┘
Mini summary: Matrix reports compare two things in rows and columns.
Definition: A filter is a rule that shows only the data you want, like "only leads from Lagos".
Why important: Filters help you focus on what matters.
Simple explanation: Like wearing sunglasses – you see only what you want to see.
Real-life example: A report filtered to show "sales above ₦1,000,000".
School example: A list of students filtered to "only those who play football".
Home example: Your shopping list filtered to "only fruits".
Nigerian example: A report filtered to "customers in Kano State".
Illustration:
FILTER EXAMPLE All customers → Filter: "City = Lagos" → Only Lagos customers
Mini summary: Filters let you see only the data you need.
Definition: Grouping means putting similar items together, like all leads from the same industry.
Why important: It makes your report easier to read and understand.
Simple explanation: Like sorting your toys into boxes – cars in one box, dolls in another.
Real-life example: Grouping sales by region – North, South, East, West.
School example: Grouping students by their class.
Home example: Grouping clothes by colour.
Nigerian example: Grouping customers by state.
Illustration:
GROUPING Leads by Industry Banking: 20 leads Telecom: 15 leads Retail: 10 leads
Mini summary: Grouping puts similar data together.
Definition: Summarising means calculating totals, averages, or counts from your data.
Why important: It gives you a quick answer without reading every row.
Simple explanation: Like adding up all your pocket money to know how much you have.
Real-life example: Total sales for the year = ₦50,000,000.
School example: Average test score = 72%.
Home example: Total number of eggs used this week = 24.
Nigerian example: Average monthly rainfall in Maiduguri = 50mm.
Illustration:
SUMMARY Count of Leads: 150 Total Opportunity Amount: ₦10,500,000 Average Deal Size: ₦70,000
Mini summary: Summaries give you totals and averages.
Definition: Building a report means choosing what data to show and how to show it.
Why important: You get exactly the information you need.
Simple explanation: Like choosing which toppings to put on your pizza.
Real-life example: You choose "Leads" and add fields: Name, Phone, and Status.
School example: You build a report of "Students" with Name, Class, and Attendance.
Home example: You build a "Chores" report with Task, Person, and Status.
Nigerian example: A report of "Orders" with Customer, Product, and Delivery Date.
Illustration:
BUILDING A REPORT 1. Choose object (e.g., Leads) 2. Add fields (Name, Email, Status) 3. Add filters (e.g., Status = 'New') 4. Run the report!
Mini summary: Building a report is like picking toppings – you choose what you want to see.
Definition: Scheduling means setting a report to run automatically at a specific time, like every Monday morning.
Why important: You don't have to remember to run the report – it's done for you.
Simple explanation: Like an alarm clock that wakes you up at the same time every day.
Real-life example: A report that sends sales numbers to the manager every Friday at 5pm.
School example: A report that emails the teacher the attendance list every morning.
Home example: A reminder to take out the rubbish every Tuesday.
Nigerian example: A report that sends daily sales to the CEO of a Lagos supermarket chain.
Illustration:
SCHEDULING Report runs → Every Monday 8am → Email sent to team
Mini summary: Scheduling lets reports run on their own – no need to remember.
Definition: Sharing means letting other team members see your reports.
Why important: Everyone gets the same information and can work together.
Simple explanation: Like showing your homework to a friend so they can check it.
Real-life example: A sales manager shares a report with the whole team.
School example: A group project – everyone shares their part.
Home example: You share the shopping list with your brother.
Nigerian example: A cooperative shares a report so all members know how much produce was sold.
Illustration:
SHARING Report → Share with Team → Everyone sees the same data
Mini summary: Sharing reports helps the whole team stay aligned.
Definition: Mistakes to avoid when creating reports.
Why important: Avoiding mistakes saves time and gives better answers.
Simple explanation: Like not burning your toast – you learn what not to do.
Real-life example: Using too many filters – you might miss important data.
School example: Forgetting to include all students in a report.
Home example: Forgetting to include a key item on your shopping list.
Nigerian example: Not including all states in a regional report.
Illustration:
COMMON MISTAKES ❌ Too many filters ❌ Wrong fields ❌ Not updating data ❌ Not sharing with team
Mini summary: Avoid common mistakes to get better reports.
Definition: Best practices are the best ways to create reports.
Why important: They help you get the most out of your reports.
Simple explanation: Like rules for a game – follow them to win.
Real-life example: Use clear titles and labels in your reports.
School example: Keep your report neat and easy to read.
Home example: Organise your shopping list by aisle.
Nigerian example: Use clear labels in your report.
Illustration:
BEST PRACTICES 1. Use clear titles 2. Choose the right report type 3. Use filters wisely 4. Group data meaningfully 5. Summarise key numbers
Mini summary: Best practices help you create great reports.
Encourage students to think of reports in their daily lives. Use the school market day story to illustrate the concept. Discuss why reports are important for making decisions.
Did you know that Salesforce can create reports with just a few clicks? You don't need to be a computer expert – it's designed to be easy!
Start → Choose Object → Add Fields → Add Filters → Run Report
│ │ │ │ │
▼ ▼ ▼ ▼ ▼
Decide Leads/Accounts Name, Date Status='New' View Data
┌──────────────────────────────────────────────────┐ │ Tabular │ Summary │ Matrix │ │ Simple │ Grouped │ Rows & Columns │ │ List │ Totals │ Cross-tabulated │ └──────────────────────────────────────────────────┘
All Customers (100)
│
▼
Filter: City = Lagos
│
▼
Lagos Customers (30)
| Tabular Report | Summary Report | Matrix Report |
|---|---|---|
| Simple list | Grouped data | Rows and columns |
| No totals | Has totals | Has totals |
| One dimension | One dimension | Two dimensions |
| Easy to create | Medium difficulty | More complex |
| Without Filters | With Filters |
|---|---|
| Shows all data | Shows only selected data |
| Can be overwhelming | Focused and clear |
| Harder to find answers | Easier to find answers |
Fantastic work! You have completed Module 1. You learned that reports are lists of data that answer questions. You discovered different types of reports – Tabular, Summary, and Matrix. You also learned how to use filters, grouping, and summarising to get exactly the information you need. You now understand why reports are important for making smart decisions.
You are ready for Module 2, where we will learn about dashboards – putting reports together in one place. Keep up the great work! 📋
| Term | Match |
|---|---|
| Report | List of data |
| Data | Information |
| Filter | Shows only certain data |
| Group | Put similar data together |
| Summarise | Totals and averages |
Scenario 1: Chidi is a sales manager. He wants to see which sales reps have the most deals this month. What type of report should he use? Why?
Scenario 2: Ada is a school principal. She wants to see attendance by class. What type of report should she use? Why?
In groups of 3, create a report on paper using the following data: 10 students, their grades in Maths and English. Add a filter and a summary. Present your report to the class.
Think of a question you want to answer (e.g., "How many books did I read this month?"). Create a simple report on paper to answer it.
Create a report for a fictional business. Include: the type of report, the fields, filters, and grouping. Present it to the class.
Write a one-page guide for creating a report in Salesforce. Include: choosing an object, adding fields, using filters, and grouping data.
Think of a business that could benefit from reports. Write a paragraph explaining what reports they would use and why.
MCQ answers: 1‑B, 2‑A, 3‑A, 4‑A, 5‑A, 6‑A, 7‑B, 8‑C, 9‑A, 10‑A, 11‑A, 12‑A, 13‑A, 14‑A, 15‑A.
In Module Two, we will learn about Dashboards – Seeing the Big Picture. You will discover how to turn your reports into beautiful dashboards with charts and numbers. Get ready to see your data in a whole new way!
📋 Congratulations! You have completed Module One. You are now a report expert! 📋
Salesforce Reports, Dashboards & Analytics – Module 2: Dashboards – Seeing the Big Picture
Hello again, data explorer! 👋 In Module 1, we learned about reports – how to ask questions and get answers from our data. We created lists, used filters, and grouped data. But sometimes, looking at a long list of numbers is not enough. We need to see the big picture – all at once!
That's where dashboards come in. A dashboard is like a scoreboard in a game. It shows you many numbers and charts together, so you can see how you are doing at a glance. Imagine a football coach looking at a screen that shows goals, assists, and player positions all at once – that's a dashboard!
In this module, we will learn what dashboards are, how to build them, and how to use charts to tell stories with data. By the end, you'll be able to create your own dashboard and understand what it's telling you.
Ready to see the big picture? Let's go! 🚀
After studying this module, you will be able to:
Coach Emeka was the manager of a football team in Lagos. He had many players, and he wanted to know how each player was performing. He had a notebook with pages of stats – goals, assists, passes, tackles. It was too much to look at!
His assistant, Tunde, said, "Coach, why don't you put all the stats on one screen? Use pictures like bars and pies, so you can see everything at once."
Coach Emeka made a big whiteboard with:
┌────────────────────────────────────────────┐ │ ⚽ Goals: 12 🅰️ Assists: 8 │ │ 📊 Top scorer: Chidi (5 goals) │ │ 🍕 Goals by position: │ │ Strikers ████████████ 60% │ │ Midfielders ██████ 30% │ │ Defenders ██ 10% │ └────────────────────────────────────────────┘
Now Coach Emeka could see everything in one place. He could tell who was playing well, what positions were scoring, and where to focus training. That whiteboard was his first dashboard – a screen that shows many numbers and charts together!
Definition: A dashboard is a screen that shows several reports together, using charts and numbers, so you can see the big picture at a glance.
Why important: It saves time – you don't have to read many reports one by one.
Simple explanation: Like the dashboard of a car – it shows you speed, fuel, and temperature all at once.
Real-life example: A call centre manager sees a dashboard with total calls, happy customers, and wait time.
School example: A teacher's dashboard might show attendance, test scores, and homework submitted.
Home example: A family dashboard on the fridge: chores done, upcoming events, and shopping list.
Nigerian example: A Lagos bus company uses a dashboard to see how many buses are on the road, how many passengers, and fuel levels.
Illustration:
DASHBOARD = SCOREBOARD ┌────────────────────────────────────────────┐ │ 📞 Calls today: 120 ✅ Won: 18 deals │ │ ⭐ Customer rating: 4.5 │ │ 📊 Pipeline: 40 opportunities │ └────────────────────────────────────────────┘
Mini summary: A dashboard shows many numbers and charts together in one place.
Definition: We use dashboards to see the big picture quickly and make fast decisions.
Why important: Dashboards save time and help you spot problems and opportunities.
Simple explanation: Like a map – you can see the whole city at once, not just one street.
Real-life example: A CEO looks at a dashboard to see sales, expenses, and customer satisfaction in one place.
School example: The head teacher looks at a dashboard to see attendance, grades, and events.
Home example: Your family looks at a dashboard to see chores, meals, and upcoming events.
Nigerian example: A market leader looks at a dashboard to see prices, supply, and demand.
Illustration:
WHY DASHBOARDS? ┌────────────────────────────────────────────┐ │ One screen → Many answers → Fast decisions│ └────────────────────────────────────────────┘
Mini summary: Dashboards help you see everything at once and make quick decisions.
Definition: A chart is a picture that shows numbers in a visual way – like bars, pies, or lines.
Why important: Charts make data easier to understand than rows of numbers.
Simple explanation: Like a drawing that tells a story with numbers.
Real-life example: A bar chart showing sales by month.
School example: A pie chart showing favourite subjects.
Home example: A line chart showing your height over the years.
Nigerian example: A chart showing rice production by state.
Illustration:
CHARTS = PICTURES OF NUMBERS ┌────────────────────────────────────────────┐ │ Bar charts │ Pie charts │ Line charts│ └────────────────────────────────────────────┘
Mini summary: Charts are pictures that make numbers easier to understand.
Definition: A bar chart uses bars of different heights to show numbers.
Why important: Bars make it easy to compare things.
Simple explanation: Taller bar = more of something. Shorter bar = less.
Real-life example: A bar chart shows sales for each month – you can see which month was best.
School example: A bar chart of books read by each class – Class 5A has the tallest bar!
Home example: A bar chart of chores done by each family member – who did the most?
Nigerian example: A bar chart showing how many yams were sold in each state – Oyo has the tallest bar.
Illustration:
BAR CHART (example) Sales by Region North ████████████ 120 South ██████████ 100 East ████████████ 130 West █████████ 80
Mini summary: Bar charts compare numbers using bars of different heights.
Definition: A pie chart is a circle cut into slices. Each slice shows a part of the whole.
Why important: It shows how something is divided – like who owns what share.
Simple explanation: Like cutting a pizza – each slice is a different flavour.
Real-life example: A pie chart shows which products make up the most sales – electronics 50%, clothes 30%, books 20%.
School example: A pie chart of favourite school subjects – maths, science, art.
Home example: A pie chart of how you spend your time – school, play, sleep, eat.
Nigerian example: A pie chart of agricultural produce: cassava 40%, yam 30%, cocoa 20%, others 10%.
Illustration:
PIE CHART
🍕
/ Cassava 40% \
| Yam 30% |
\ Cocoa 20% /
\ Others 10% /
Mini summary: Pie charts show parts of a whole, like slices of a pizza.
Definition: A line chart uses points connected by a line to show changes over time.
Why important: It helps you see trends – going up, going down, or staying the same.
Simple explanation: Like a snake that moves up and down to show what's happening.
Real-life example: A line chart of monthly sales – you can see if sales are growing.
School example: A line chart of your test scores over the year – are you improving?
Home example: A line chart of your savings – is your piggy bank growing?
Nigerian example: A line chart of rainfall in Abuja each month – which months have the most rain?
Illustration:
LINE CHART
Sales over 6 months
100 ──●─────●
80 │ ●─│─●
60 │ │ │ │
40 │ │ │ │
20 │ │ │ │
0 ─────────────────
J F M A M J
Mini summary: Line charts show how things change over time.
Definition: There are many other charts – doughnut charts, scatter plots, and more.
Why important: Different charts are good for different data.
Simple explanation: Like different tools – you use the right one for the job.
Real-life example: A doughnut chart is like a pie chart with a hole.
School example: A scatter plot shows the relationship between two things, like study time and test scores.
Home example: A gauge chart shows how close you are to a goal.
Nigerian example: A gauge chart showing progress towards a fundraising goal.
Illustration:
OTHER CHARTS ┌────────────────────────────────────────────┐ │ Doughnut │ Scatter │ Gauge │ │ (like pie) │ (dots) │ (speedometer) │ └────────────────────────────────────────────┘
Mini summary: There are many types of charts for different data.
Definition: Building a dashboard means putting reports and charts together on one screen.
Why important: You get a complete view of your data.
Simple explanation: Like making a collage – you put different pictures together.
Real-life example: You add a bar chart of sales, a pie chart of products, and a metric of total revenue.
School example: You add a chart of attendance, a chart of grades, and a metric of total students.
Home example: You add a chart of chores, a chart of expenses, and a metric of total savings.
Nigerian example: You add a chart of sales by state, a chart of products, and a metric of total revenue.
Illustration:
BUILDING A DASHBOARD 1. Choose reports 2. Choose chart types 3. Arrange on screen 4. Add metrics (KPIs) 5. Share with team
Mini summary: Building a dashboard is like making a collage of reports and charts.
Definition: Dashboard components are the different parts of a dashboard – charts, metrics, and tables.
Why important: Each component tells a different part of the story.
Simple explanation: Like different ingredients in a recipe – each one adds something.
Real-life example: A chart of sales, a metric of total revenue, and a table of top customers.
School example: A chart of attendance, a metric of total students, and a table of top performers.
Home example: A chart of chores, a metric of total completed, and a table of upcoming events.
Nigerian example: A chart of sales by state, a metric of total revenue, and a table of top products.
Illustration:
DASHBOARD COMPONENTS ┌────────────────────────────────────────────┐ │ Chart │ Metric (KPI) │ Table │ │ (bar) │ (big number) │ (list) │ └────────────────────────────────────────────┘
Mini summary: Dashboards include charts, metrics, and tables.
Definition: A KPI (Key Performance Indicator) is a big number that shows how well you are doing.
Why important: It gives you a quick answer to "How are we doing?"
Simple explanation: Like the score in a game – it tells you if you are winning.
Real-life example: Total sales this month = ₦5,000,000.
School example: Average test score = 75%.
Home example: Total chores done this week = 15.
Nigerian example: Total customers this month = 500.
Illustration:
KPI = BIG NUMBER ┌────────────────────────────────────────────┐ │ 🏆 Total Sales: ₦5,000,000 │ │ 📈 Conversion Rate: 25% │ │ ⭐ Customer Satisfaction: 4.5/5 │ └────────────────────────────────────────────┘
Mini summary: KPIs are big numbers that show how well you are doing.
Definition: Reading a dashboard means looking at all the charts and numbers to understand what is happening.
Why important: It helps you make decisions quickly.
Simple explanation: Like reading a comic – each chart is a panel in the story.
Real-life example: A manager sees that sales are low this month and decides to run a promotion.
School example: The teacher sees attendance is low on Fridays and decides to make Friday lessons more fun.
Home example: Mum sees that the water bill is high and reminds everyone to save water.
Nigerian example: A farmer sees that cassava sales are dropping and decides to find new buyers.
Illustration:
DASHBOARD STORY ┌────────────────────────────────────────────┐ │ 📉 Sales down 10% this month │ │ 📊 Top product: Rice (40% of sales) │ │ 📍 Best region: North (₦5M) │ │ 💡 Suggestion: Focus on rice in North │ └────────────────────────────────────────────┘
Mini summary: A dashboard tells a story that helps you decide what to do next.
Definition: Sharing means letting other team members see your dashboards.
Why important: Everyone gets the same information and can work together.
Simple explanation: Like showing your homework to a friend so they can check it.
Real-life example: A sales manager shares a dashboard with the whole team.
School example: A group project – everyone shares their part.
Home example: You share the shopping list with your brother.
Nigerian example: A cooperative shares a dashboard so all members know how much produce was sold.
Illustration:
SHARING Dashboard → Share with Team → Everyone sees the same data
Mini summary: Sharing dashboards helps the whole team stay aligned.
Definition: Mistakes to avoid when creating dashboards.
Why important: Avoiding mistakes makes dashboards more useful.
Simple explanation: Like not putting too much spice in a dish – you want it to be just right.
Real-life example: Too many charts on one dashboard – it becomes confusing.
School example: A dashboard with too much information – students can't understand it.
Home example: A family dashboard that's too messy – nobody uses it.
Nigerian example: A dashboard with outdated data – wrong decisions.
Illustration:
COMMON MISTAKES ❌ Too many charts ❌ Outdated data ❌ No clear story ❌ Not sharing
Mini summary: Avoid common mistakes to make better dashboards.
Definition: Best practices are the best ways to create dashboards.
Why important: They help you create useful and clear dashboards.
Simple explanation: Like rules for a game – follow them to win.
Real-life example: Keep it simple – use only the most important charts.
School example: Use clear titles and labels.
Home example: Update the dashboard regularly.
Nigerian example: Focus on the most important numbers.
Illustration:
BEST PRACTICES 1. Keep it simple 2. Use clear titles 3. Update regularly 4. Focus on KPIs 5. Tell a story
Mini summary: Best practices help you create great dashboards.
Definition: A sample dashboard is a pretend dashboard you can practice reading.
Why important: Practice helps you get better at reading and understanding.
Simple explanation: Like practising football drills before the big match.
Real-life example: A training dashboard with dummy data.
School example: A practice test before the real exam.
Home example: Practising a recipe before cooking for guests.
Nigerian example: A demo dashboard for a bank training session.
Illustration:
SAMPLE DASHBOARD ┌────────────────────────────────────────────┐ │ 📊 Total Leads: 200 │ │ 🏆 Won: 50 ❌ Lost: 30 ⏳ Open: 120 │ │ 📈 Sales by Month: (line chart) │ │ 🍕 Sales by Product: (pie chart) │ └────────────────────────────────────────────┘
Mini summary: Practice with sample dashboards to build your skills.
Encourage students to think of dashboards in their daily lives. Use the football coach story to illustrate the concept. Discuss why dashboards are important for making quick decisions.
Did you know that Salesforce has a feature called "Einstein Analytics" that can automatically suggest the best charts for your dashboard? It's like having a data expert helping you!
┌──────────────────────────────────────────────────┐ │ 📊 DASHBOARD │ │ ┌──────────┐ ┌──────────┐ ┌──────────────┐ │ │ │ Bar chart │ │ Pie chart│ │ Line chart │ │ │ │ (sales) │ │ (market) │ │ (trends) │ │ │ └──────────┘ └──────────┘ └──────────────┘ │ │ ┌──────────┐ ┌──────────┐ ┌──────────────┐ │ │ │ KPI 1 │ │ KPI 2 │ │ KPI 3 │ │ │ │ Total │ │ Average │ │ Conversion │ │ │ │ Leads │ │ Deal │ │ Rate │ │ │ └──────────┘ └──────────┘ └──────────────┘ │ └──────────────────────────────────────────────────┘
┌──────────────────────────────────────────────────┐ │ Bar │ Pie │ Line │ Doughnut │ │ ████ │ 🍕 │ ──●── │ ⭕ │ │ ████ │ slices│ ●─●─● │ (ring) │ │ ████ │ │ │ │ └──────────────────────────────────────────────────┘
Start → Choose Reports → Choose Charts → Arrange → Share
│ │ │ │ │
▼ ▼ ▼ ▼ ▼
Decide Pick data Pick type Layout Team sees
| Report | Dashboard |
|---|---|
| Shows a list of data | Shows charts and numbers |
| Answers one question | Answers many questions at once |
| Can be long | Is visual and quick to read |
| Usually text-based | Uses pictures and graphs |
| Chart Type | Best For | Example |
|---|---|---|
| Bar chart | Comparing values | Sales by region |
| Pie chart | Showing parts of a whole | Market share |
| Line chart | Showing trends over time | Monthly sales |
Fantastic work! You have completed Module 2. You learned that dashboards are screens that show many charts and numbers together – like a scoreboard. You discovered different types of charts – bar, pie, line, and more. You also learned how to build a dashboard, read it, and tell a story from it.
You now understand the power of dashboards to see the big picture and make quick decisions. You are ready for Module 3, where we will learn about analytics – using data to make even smarter decisions. Keep up the great work! 📊
| Term | Match |
|---|---|
| Dashboard | Screen with charts |
| Chart | Picture of numbers |
| Bar chart | Compares values |
| Pie chart | Shows parts of a whole |
| Line chart | Shows trends over time |
Scenario 1: Chidi is a sales manager. He wants to see sales by region and by product on one screen. What type of dashboard should he build?
Scenario 2: Ada is a school principal. She wants to see attendance, grades, and events all in one place. What type of dashboard should she build?
In groups of 3, create a dashboard on paper. Include: a bar chart, a pie chart, a line chart, and at least 2 KPIs. Use the following data: sales by region, market share by product, and monthly sales trends. Present your dashboard to the class.
Draw a dashboard for your own life. Include: a chart of your daily activities, a chart of your pocket money spending, and a KPI of total savings.
Create a dashboard for a fictional business. Include: at least 3 charts, 2 KPIs, and a clear story. Present it to the class.
Write a one-page guide for building a dashboard. Include: choosing reports, choosing charts, arranging components, and sharing with the team.
Think of a business that could benefit from a dashboard. Write a paragraph explaining what the dashboard would show and why it would be useful.
MCQ answers: 1‑B, 2‑A, 3‑B, 4‑A, 5‑C, 6‑A, 7‑A, 8‑A, 9‑A, 10‑A, 11‑A, 12‑A, 13‑A, 14‑A, 15‑A.
In Module Three, we will learn about Analytics – Making Smart Decisions. You will discover how to use data to spot trends, predict the future, and make better decisions. Get ready to become a data genius!
📊 Congratulations! You have completed Module Two. You are now a dashboard expert! 📊