Turn data into knowledge! In this module, you will learn what reports are, why they matter, and how they help you understand your business.
Imagine you have a piggy bank. Every day, you put some money in. But you don't know how much you have saved. You don't know if you're saving more or less than last month. You're just guessing!
That's what it's like to run a business without reports. Reports are like a window into your business. They show you what's happening, what's working, and what needs attention.
In this module, you will learn the fundamentals of reporting – what reports are, why they matter, and how they help you make better decisions.
Tunde runs an ice cream shop in Lagos. He has many flavors – vanilla, chocolate, strawberry, and mango. He sells a lot of ice cream, but he didn't know which flavors were most popular.
One day, he started using reports in Zoho CRM. He created a report showing how many of each flavor he sold. He was shocked to see that mango ice cream was selling 3 times more than vanilla!
He decided to buy more mango ingredients and promote mango ice cream. His sales went up by 50%!
That's the power of reports – they help you see what's working and what's not.
Definition: A report is a document that organizes and presents your data in a clear way – like a table, a chart, or a graph.
Why important? Reports help you understand your business. They show you trends, patterns, and numbers that matter.
Simple explanation: Think of a report like a report card for your business. It shows you how well you are doing.
Real-life example: A supermarket creates a report to see which products sell the most each week.
School example: Your teacher creates a report of students' grades to see who needs extra help.
Home example: A family creates a report of their monthly spending to see where they spend the most.
Nigerian example: A farmer in Jos creates a report to compare harvests from different seasons.
Report = Data + Organization + Presentation
Definition: Reports matter because they help you make better decisions.
Why important? Without reports, you're guessing. With reports, you know.
Simple explanation: Like using a map instead of guessing which way to go.
Benefits of reports:
Definition: Zoho CRM has three main types of reports:
Why important? Different reports help you see data from different angles.
Simple explanation: Like using different lenses on a camera – each gives you a different view.
Tabular = List
Summary = Groups + Totals
Matrix = Grid (Rows + Columns)
Definition: A tabular report is the simplest type – it just shows a list of records with columns.
Why important? It's great for when you just want to see all your data in one place.
Simple explanation: Like a list of all your friends with their phone numbers.
Real-life example: A list of all your customers with their names and phone numbers.
Nigerian example: A shop owner creates a list of all the products they sold this week.
Tabular Report Example:
Name | Phone | City | Amount
Chidi | 080... | Lagos | ₦50,000
Bola | 070... | Abuja | ₦30,000
Definition: A summary report groups data by a field and shows totals, like total deals by city.
Why important? It helps you see trends and patterns.
Simple explanation: Like grouping your toys by color and counting how many of each.
Real-life example: A report showing total sales by region.
Nigerian example: A business owner sees which city has the most customers.
Summary Report:
City | Total Sales | Number of Customers
Lagos | ₦500,000 | 50
Abuja | ₦250,000 | 25
Definition: A matrix report is like a grid with rows and columns, comparing two dimensions.
Why important? It lets you see relationships between two sets of data.
Simple explanation: Like a multiplication table – rows and columns intersect.
Real-life example: A report showing sales by product and by region.
Nigerian example: A business owner sees which products sell best in which cities.
Matrix Report:
Stage \ City | Lagos | Abuja | Total
New | 5 | 2 | 7
Won | 8 | 3 | 11
Definition: KPI stands for Key Performance Indicator. It's an important number that tells you how well you're doing.
Why important? KPIs help you focus on what matters most.
Simple explanation: Like your score in a game – it tells you how well you're playing.
Common KPIs:
Definition: A report is detailed data. A dashboard is a visual summary of multiple reports.
Why important? Dashboards give you a quick snapshot, while reports give you detail.
Simple explanation: A report is like a book. A dashboard is like the cover of the book – it shows the most important parts.
Comparison:
| Report | Dashboard |
|---|---|
| Detailed data | Summary view |
| Can be long | One page |
| Used for analysis | Used for monitoring |
Definition: Data sources are where the information in your reports comes from.
Why important? You need to know where your data is coming from.
Common data sources:
Definition: Filters let you show only the data you want. For example, only deals from Lagos.
Why important? Filters help you focus on specific data.
Simple explanation: Like using a sieve to remove what you don't want.
Example: A report showing only deals that were Closed Won this month.
Definition: Groups let you organize data by categories, like grouping deals by stage.
Why important? Groups help you see patterns and totals.
Simple explanation: Like grouping your toys by type – cars together, dolls together.
Group Example:
Stage: New → 5 deals
Stage: Won → 8 deals
Stage: Lost → 3 deals
Definition: Reports help you make smart business decisions.
Why important? Data-driven decisions are better than guesses.
Simple explanation: Like using a map instead of guessing which way to go.
Nigerian example: A shop in Lagos uses a report to see that Saturdays have the most customers, so they open earlier on Saturdays.
Report – organized data in a table, chart, or graph.
Tabular – a simple list report.
Summary – groups data with totals.
Matrix – a grid comparing two dimensions.
KPI – Key Performance Indicator, an important number to track.
Dashboard – a page with multiple components.
Filter – shows only certain data.
Group – organizes data by categories.
Data Source – where the data comes from.
Analytics – using data to make decisions.
Example 1: A car dealership creates a report to see which model sells the most each month.
Example 2: A school creates a dashboard showing attendance, grades, and library books borrowed.
Imagine you collect trading cards. You could create a report showing how many cards you have of each type. Then create a pie chart to see which type is the most common!
Help your child create simple charts from everyday data, like tracking the weather each day or counting the types of fruit in the kitchen.
You can add a report to your dashboard and it will update automatically whenever new data is added!
Report Types
Tabular: List of records
Summary: Groups + Totals
Matrix: Grid (Rows + Columns)
Report Flow
Data → Report → Dashboard → Decision
| Feature | Tabular | Summary | Matrix |
|---|---|---|---|
| Format | List | Groups + totals | Grid |
| Best for | Looking at details | Finding totals | Comparing two dimensions |
| Example | List of all deals | Total deals by city | Deals by stage and city |
Congratulations! You have completed Module One. You now know:
Reports turn your data into powerful insights. With them, you can make better decisions and grow your business!
Match the term to its meaning:
| Term | Meaning |
|---|---|
| 1. Tabular | A. Groups data with totals |
| 2. Summary | B. Simple list |
| 3. Matrix | C. Grid comparing two dimensions |
Answers: 1-B, 2-A, 3-C
Scenario: You run a bakery with 3 branches. You want to see which branch sells the most cakes and which month has the highest sales. How would you use reports to get this information?
Answer: Create a summary report grouping by branch to see total sales per branch. Create another summary report grouping by month to see sales trends.
In groups, design a dashboard for a hotel. What components would you include? (e.g., occupancy rate, revenue, guest reviews). Draw it on paper.
Think of a question you would like answered about a business. Write down what report you would create to answer it.
Create a sample report on paper for a shop. List 10 items sold and create a bar chart showing the sales of each item.
If you have Zoho CRM access, create a tabular report showing all your leads. Add a filter to show only leads from this month.
In Module Two, we will learn about Building Reports in Zoho CRM. You will learn how to create different types of reports, add filters, and share reports with your team.
Get ready to create your own reports!
End of Module One · Zoho CRM Reports, Dashboards and Analytics
Create reports that answer your questions! In this module, you will learn how to create different types of reports, add filters, and share reports with your team.
In Module One, we learned what reports are and why they matter. Now it's time to actually build them! Creating reports in Zoho CRM is easier than you think.
In this module, you will learn how to create tabular, summary, and matrix reports. You'll add filters, sort and group data, and schedule reports to be sent automatically.
Funmi runs a small business in Lagos. She had lots of data in Zoho CRM, but she didn't know how to use it. She wanted to know which products were selling best.
She learned how to create reports. She built a summary report showing sales by product. She added a filter to show only the last month. She saw that one product was selling much better than others.
She used this information to order more of that product. Her sales increased by 30%!
Today, you will learn how Funmi did it!
Definition: The Reports section in Zoho CRM is where you create, view, and manage all your reports.
Why important? This is where you go to get answers from your data.
Simple explanation: Like a library where all your reports are stored.
Steps: Go to Analytics → Reports.
Analytics → Reports
Definition: A tabular report is a simple list of records with columns.
Why important? It's the easiest report to create and great for seeing all your data.
Steps:
Steps to create a tabular report:
1. Analytics → Reports
2. Click Create Report
3. Choose Tabular
4. Select a module
5. Add columns
6. Save ✅
Definition: Columns are the fields you want to see in your report – like Name, Email, Stage, or Amount.
Why important? You choose what information to show.
Simple explanation: Like choosing which items to put on a shopping list.
Common columns:
Definition: A summary report groups data by a field and shows totals.
Why important? It helps you see totals and patterns.
Steps:
Summary Report Example:
Stage | Count | Total Amount
New | 5 | ₦250,000
Contacted | 3 | ₦150,000
Won | 2 | ₦100,000 🎉
Definition: A matrix report is a grid with rows and columns, comparing two dimensions.
Why important? It lets you see relationships between two sets of data.
Steps:
Matrix Report:
Stage \ City | Lagos | Abuja | Total
New | 5 | 2 | 7
Won | 8 | 3 | 11
Definition: Filters let you show only the data you want.
Why important? Filters help you focus on specific data.
Simple explanation: Like using a sieve to remove what you don't want.
How to add filters: In the report builder, click "Add Filter" and choose a field and condition.
Filter Example:
Show only deals where Stage = "Won" and Amount > ₦100,000
Definition: Sorting arranges data in a specific order – like highest to lowest.
Why important? Sorting helps you find the most important data quickly.
Simple explanation: Like organizing your books by size.
How to sort: In the report builder, click on the column header to sort.
Definition: Grouping organizes data by categories.
Why important? Groups help you see patterns and totals.
Simple explanation: Like grouping your toys by type – cars together, dolls together.
How to group: In a summary report, choose a field to group by.
Definition: Saving a report means storing it so you can use it again.
Why important? You don't want to rebuild the same report every time.
Simple explanation: Like bookmarking a website you visit often.
Tips for naming:
Definition: Scheduling reports means setting them to be sent to you automatically.
Why important? You don't have to remember to check your reports.
Simple explanation: Like a newspaper delivery – it comes to you.
Steps:
Definition: Sharing reports means letting other people see your reports.
Why important? Your team needs the same information.
Simple explanation: Like sharing a document with your classmates.
How to share:
Definition: Report permissions control who can see or edit a report.
Why important? You don't want everyone changing your reports.
Permission levels:
Definition: Report templates are pre-built reports you can use as a starting point.
Why important? They save you time – you don't have to build from scratch.
Examples:
Tabular – a simple list report.
Summary – groups data with totals.
Matrix – a grid comparing two dimensions.
Filter – shows only certain data.
Group – organizes data by categories.
Sort – arranges data in order.
Schedule – send reports automatically.
Share – let others see your report.
Permission – controls access to reports.
Template – a pre-built report to start from.
Example 1: A car dealership creates a report showing sales by model to see which cars are most popular.
Example 2: A school creates a report showing student attendance by class to identify patterns.
Imagine you collect toys. You create a report showing how many toys you have of each type. Then you sort them from most to least. That's what a summary report does!
Help your child understand reporting by asking: "How would you show which toys you play with most?" This helps them think about organizing data.
You can add a report to your dashboard and it will update automatically whenever new data is added!
Report Creation Flow
Analytics → Reports → Create Report → Choose Type → Add Fields → Save ✅
Report Structure
+---------------------------+
| Report Name |
+---------------------------+
| Column 1 | Column 2 | Col |
+---------------------------+
| Data | Data | Data |
| Data | Data | Data |
+---------------------------+
| Total | Total | Total |
+---------------------------+
| Feature | Tabular | Summary | Matrix |
|---|---|---|---|
| Format | List | Groups + totals | Grid |
| Best for | Looking at details | Finding totals | Comparing two dimensions |
| Example | List of all deals | Total deals by city | Deals by stage and city |
Congratulations! You have completed Module Two. You now know:
With these skills, you can create reports that answer your business questions and help you make better decisions!
Match the term to its meaning:
| Term | Meaning |
|---|---|
| 1. Summary | A. Sends reports automatically |
| 2. Filter | B. Groups data with totals |
| 3. Schedule | C. Shows only certain data |
Answers: 1-B, 2-C, 3-A
Scenario: You run a business and want to see which products sell the most each month. How would you create a report to answer this?
Answer: Create a summary report grouped by Product, with Total Amount as the value. Add a filter for Created Date = This Month. Save and schedule the report.
In groups, create a report for a business. Decide the report type, columns, filters, and groups. Present your report to the class.
Think of a business question you want to answer. Write down what report type you would use and what fields you would include.
Create a sample report on paper for a business. Include columns, filters, and groups. Explain what question the report answers.
If you have Zoho CRM access, create a summary report showing deals by stage. Add a filter for this month. Save and share the report.
In Module Three, we will learn about Charts and Data Visualization. You will learn how to add charts to reports, choose the right chart type, and tell stories with your data.
Get ready to make your data look beautiful!
End of Module Two · Zoho CRM Reports, Dashboards and Analytics
Make your data tell a story! In this module, you will learn how to add charts to reports, choose the right chart type, and tell stories with your data.
Numbers alone can be boring. But when you turn numbers into charts and graphs, they become exciting! Charts help you see patterns, trends, and relationships that you might miss in a table.
In this module, you will learn how to add charts to your reports, choose the right chart type for your data, and use visualization to tell compelling stories.
Chidi runs a business in Lagos. He had lots of sales data, but it was all in tables. He couldn't see the patterns. Was his business growing? Which products were best?
Then he discovered charts in Zoho CRM. He created a bar chart showing sales by month. He created a pie chart showing sales by product. He created a line chart showing growth over time.
Now Chidi can see his business clearly. He knows what's working and what's not. His business is growing faster than ever!
Today, you will learn how Chidi did it!
Definition: Data visualization is the process of turning data into pictures like charts and graphs.
Why important? Pictures are easier to understand than numbers. They help you see patterns quickly.
Simple explanation: Like a picture that tells a story about your data.
Real-life example: A weather forecast uses a map with colors to show temperature.
School example: Your teacher uses a bar chart to show class test scores.
Home example: Your family uses a pie chart to show monthly spending.
Nigerian example: A shop owner uses a chart to see which products sell most.
Data Visualization = Turning data into pictures
Definition: A bar chart uses bars to show and compare data.
Why important? Bar charts are great for comparing different categories.
Simple explanation: Like a race where each bar is a runner – taller bars are better.
When to use: Comparing categories (e.g., sales by product).
Bar Chart:
Sales by Product
Product A: ████████
Product B: ██████
Product C: ██████████
Definition: A pie chart shows how a whole is divided into parts – like pieces of a pie.
Why important? Pie charts show proportions and percentages.
Simple explanation: Like a pizza with different toppings – each slice is a part of the whole.
When to use: Showing parts of a whole (e.g., market share).
Pie Chart:
Sales by Product
Product A: 30%
Product B: 20%
Product C: 50%
Definition: A line chart shows how data changes over time using a line.
Why important? Line charts show trends and patterns over time.
Simple explanation: Like a line on a map showing your journey.
When to use: Showing trends over time (e.g., sales by month).
Line Chart:
Sales by Month
Jan: ████████
Feb: ██████
Mar: ██████████
Definition: An area chart is like a line chart but with the area under the line filled in.
Why important? Area charts show the magnitude of change.
Simple explanation: Like a line chart with color underneath.
When to use: Showing cumulative totals or magnitude of change.
Definition: A column chart is the same as a bar chart but with vertical bars.
Why important? Column charts are used for the same purposes as bar charts.
Simple explanation: Bar charts are horizontal; column charts are vertical.
When to use: Comparing categories (same as bar charts).
Definition: You can add charts to your reports in Zoho CRM to make them more visual.
Why important? Charts make your reports more engaging and easier to understand.
Steps:
Definition: Different chart types work better for different kinds of data.
Why important? Using the wrong chart can make your data confusing.
| Chart Type | Best for |
|---|---|
| Bar/Column | Comparing categories |
| Pie | Showing parts of a whole |
| Line | Showing trends over time |
| Area | Showing magnitude of change |
Definition: You can customize the colors and styles of your charts.
Why important? Good colors make charts easier to read and more professional.
Tips:
Definition: Labels and titles explain what a chart shows.
Why important? Without labels, people might not understand your chart.
What to include:
Definition: Visual storytelling means using charts and data to tell a story.
Why important? Stories are more memorable than facts alone.
Steps to tell a story:
Definition: Dashboards can include charts to give you a quick snapshot of your data.
Why important? Charts on dashboards help you monitor your business at a glance.
What to include:
Definition: Best practices are smart ways to create effective charts.
Tips:
Data Visualization – turning data into pictures.
Bar Chart – uses bars to compare categories.
Pie Chart – shows parts of a whole.
Line Chart – shows trends over time.
Area Chart – line chart with filled area.
Column Chart – vertical bar chart.
Label – text that explains a chart.
Legend – explains what colors mean.
Visual Storytelling – using charts to tell a story.
Dashboard – a page with multiple components.
Example 1: A car dealership uses a bar chart to show sales by model.
Example 2: A school uses a line chart to show student enrollment over time.
Imagine you collect trading cards. You create a pie chart to see which type is the most common. You create a bar chart to compare the number of cards you have of each type. That's data visualization!
Help your child create simple charts from everyday data, like tracking the weather each day or counting the types of fruit in the kitchen.
You can add multiple charts to a single report in Zoho CRM!
Chart Types
Bar Chart: ████████ ██████ ██████████
Pie Chart: 🍕 (slices)
Line Chart: ╱╲╱╲╱╲
Visual Storytelling Flow
Question → Data → Chart → Insight → Action
| Chart Type | Best for | Example |
|---|---|---|
| Bar | Comparing categories | Sales by product |
| Pie | Parts of a whole | Market share |
| Line | Trends over time | Sales by month |
| Area | Magnitude of change | Revenue growth |
Congratulations! You have completed Module Three. You now know:
Charts make your data come alive. Use them to tell stories and make better decisions!
Match the chart to its use:
| Chart | Use |
|---|---|
| 1. Bar Chart | A. Shows trends over time |
| 2. Pie Chart | B. Compares categories |
| 3. Line Chart | C. Shows parts of a whole |
Answers: 1-B, 2-C, 3-A
Scenario: You run a business and want to see which products sell the most and how sales have changed over time. What charts would you use?
Answer: Use a bar chart to compare sales by product. Use a line chart to show sales trends over time.
In groups, create a visual story for a business. Include at least 2 charts and explain what story they tell.
Think of a business question you want to answer. Draw a chart that would help answer it.
Create a one-page report with 3 charts for a business. Include a title, labels, and a brief explanation.
If you have Zoho CRM access, add a chart to a saved report. Share the report with a teammate.
In Module Four, we will learn about Dashboards and KPIs. You will learn how to build dashboards, track KPIs, and create a control panel for your business.
Get ready to build your dashboard!
End of Module Three · Zoho CRM Reports, Dashboards and Analytics
See your business at a glance! In this module, you will learn how to build dashboards, track KPIs, and create a control panel for your business.
Imagine driving a car without a dashboard. You wouldn't know your speed, fuel level, or engine temperature. You'd be driving blind! That's what it's like to run a business without a dashboard.
A dashboard gives you a quick snapshot of your business. It shows you the most important numbers – your KPIs – all in one place. In this module, you will learn how to build dashboards that help you monitor your business at a glance.
Grace runs a small business in Abuja. She had lots of reports, but she couldn't see everything at once. She had to open different reports to see different things. It was time-consuming.
Then she discovered dashboards in Zoho CRM. She created a dashboard that showed her sales, customer satisfaction, and revenue all in one place. Now she can see her business at a glance.
Grace saves 2 hours every day. She makes better decisions because she sees everything instantly.
Today, you will learn how Grace did it!
Definition: A dashboard is a single page that shows multiple reports, charts, and numbers together.
Why important? It gives you a quick snapshot of your business at a glance.
Simple explanation: Like the dashboard of a car – it shows speed, fuel, and other important information at once.
Real-life example: A business owner sees sales, customer satisfaction, and revenue on one page.
School example: A teacher sees attendance, grades, and behavior on one screen.
Home example: A family sees spending, savings, and goals on one chart.
Nigerian example: A shop owner sees daily sales, top products, and customer feedback in one place.
Dashboard = Multiple reports on one page
Definition: Components are the individual pieces on a dashboard – like a report, chart, or number.
Why important? Components give you different views of your data.
Types of components:
Dashboard Components:
+------------------+ +------------------+
| Total Deals | | Sales by Month |
| 150 | | [Bar Chart] |
+------------------+ +------------------+
+------------------+ +------------------+
| Top Products | | Revenue by City |
| 1. Ice Cream | | [Pie Chart] |
+------------------+ +------------------+
Definition: KPI stands for Key Performance Indicator. It's an important number that tells you how well you're doing.
Why important? KPIs help you focus on what matters most.
Simple explanation: Like your score in a game – it tells you how well you're playing.
Common KPIs:
Definition: Creating a dashboard means building a new dashboard from scratch.
Why important? You can customize your dashboard to show what matters most.
Steps:
Definition: Layout is how components are arranged on your dashboard.
Why important? Good layout makes your dashboard easy to read.
Tips:
Definition: Widgets are the components you add to your dashboard.
Why important? Widgets are how you get the information you need.
Types of widgets:
Definition: A number widget shows a single number, like total deals or total revenue.
Why important? It gives you a quick snapshot of your most important metric.
Simple explanation: Like the speedometer on a car – it shows one number clearly.
Steps:
Definition: A chart widget shows a chart on your dashboard.
Why important? Charts help you see patterns and trends.
Steps:
Definition: A list widget shows a list of records, like recent deals or top customers.
Why important? Lists help you see detailed information.
Steps:
Definition: Customizing means changing the look and feel of your dashboard.
Why important? A customized dashboard is more useful and easier to read.
What you can customize:
Definition: Sharing dashboards means letting other people see your dashboard.
Why important? Your team needs to see the same data.
Simple explanation: Like sharing a document with your classmates.
How to share:
Definition: A KPI dashboard focuses on key performance indicators.
Why important? It helps you track your most important metrics.
What to include:
Definition: Best practices are smart ways to create effective dashboards.
Tips:
Dashboard – a page with multiple components.
Component – a piece on a dashboard.
KPI – Key Performance Indicator.
Widget – a component on a dashboard.
Layout – how components are arranged.
Number Widget – shows a single number.
Chart Widget – shows a chart.
List Widget – shows a list of records.
Share – let others see your dashboard.
Metric – a number you track.
Example 1: A business owner uses a dashboard to track sales, customers, and revenue daily.
Example 2: A school uses a dashboard to track attendance, grades, and behavior.
Imagine you have a dashboard for your lemonade stand. It shows how many cups you sold, how much money you made, and how many customers you had. That's what a business dashboard does!
Help your child create a simple dashboard for their allowance or chores. This helps them understand how dashboards work.
You can set up your dashboard to refresh automatically so you always see the latest data!
Dashboard Layout
+------------------+ +------------------+
| Number Component | | Chart Component |
+------------------+ +------------------+
+------------------+ +------------------+
| Table Component | | Chart Component |
+------------------+ +------------------+
KPI Dashboard Example
+------------------+ +------------------+
| Total Revenue | | New Customers |
| ₦500,000 | | 25 |
+------------------+ +------------------+
+------------------+ +------------------+
| Sales by Month | | Top Products |
| [Bar Chart] | | 1. Product A |
+------------------+ +------------------+
| Feature | Report | Dashboard |
|---|---|---|
| Purpose | Answer a specific question | Show overview at a glance |
| Layout | One page | Multiple components |
| Updates | Manual or scheduled | Real-time |
| Sharing | Yes | Yes |
Congratulations! You have completed Module Four. You now know:
Dashboards give you a quick snapshot of your business. Use them to monitor your progress and make better decisions!
Match the term to its meaning:
| Term | Meaning |
|---|---|
| 1. Dashboard | A. A piece on a dashboard |
| 2. Component | B. Multiple reports on one page |
| 3. KPI | C. Key Performance Indicator |
Answers: 1-B, 2-A, 3-C
Scenario: You run a business and want to track sales, customer satisfaction, and revenue daily. What would you include on your dashboard?
Answer: Include a number widget for Total Revenue, a chart widget for Sales by Month, and a chart widget for Customer Satisfaction Score.
In groups, design a dashboard for a business. Include 5 components and explain what each one shows. Present to the class.
Write down 5 KPIs you would track for a business. Explain why each KPI is important.
Create a paper dashboard with 5 components for a business of your choice. Include charts, numbers, and tables.
If you have Zoho CRM access, create a dashboard with 3 components. Share it with a teammate.
In Module Five, we will learn about Advanced Analytics and Insights. You will learn about trend analysis, forecasting, funnel analysis, and how to use analytics to make smarter decisions.
Get ready to become a data expert!
End of Module Four · Zoho CRM Reports, Dashboards and Analytics
Go beyond reporting! In this module, you will learn about trend analysis, forecasting, funnel analysis, and how to use analytics to make smarter decisions.
You've learned how to create reports, add charts, and build dashboards. But that's just the beginning. Analytics is about using data to understand what's happening and predict what will happen next.
In this module, you will learn how to analyze trends, forecast the future, and use funnel analysis to improve your business. You'll also learn about Zoho Analytics and how to optimize your reports.
Emeka runs a business in Lagos. He had lots of reports, but he didn't know how to use them to predict the future. He wanted to know: "Will my sales grow next month? Where are customers dropping off?"
Then he discovered analytics. He learned about trend analysis, forecasting, and funnel analysis. He used these insights to grow his business by 40%.
Today, you will learn how Emeka did it!
Definition: Analytics is the process of using data to understand what's happening and make better decisions.
Why important? Analytics helps you move from guessing to knowing.
Simple explanation: Like being a detective – you use clues (data) to solve a mystery.
Real-life example: A business uses sales data to decide which products to promote.
School example: A teacher uses test scores to see which students need help.
Home example: A family uses spending data to plan their budget.
Nigerian example: A shop owner uses sales data to decide which products to stock.
Analytics = Using data to make better decisions
Definition: Trend analysis is looking at data over time to see patterns.
Why important? Trends help you understand what's happening and predict the future.
Simple explanation: Like looking at a graph that goes up and down over time.
What to look for:
Trend Analysis:
Sales by Month
Jan: ████████
Feb: ██████
Mar: ██████████
Trend: 📈 Increasing
Definition: Forecasting is predicting what will happen in the future based on past data.
Why important? Forecasting helps you plan and prepare.
Simple explanation: Like guessing the weather tomorrow based on today's weather.
What you can forecast:
Definition: Funnel analysis shows where customers drop off in the sales process.
Why important? It helps you find and fix bottlenecks.
Simple explanation: Like a funnel – leads go in at the top and customers come out at the bottom.
Funnel Analysis:
Leads: 100
↓ 30% drop
Contacted: 70
↓ 40% drop
Qualified: 42
↓ 50% drop
Won: 21 🎉
Definition: Conversion analysis shows how many leads become customers.
Why important? It tells you how effective your sales process is.
How to calculate: Conversion Rate = (Customers / Leads) × 100
Example: If you have 100 leads and 20 customers, your conversion rate is 20%.
Definition: Segmentation is grouping customers by shared characteristics.
Why important? Different segments need different approaches.
Examples:
Definition: Cohort analysis groups customers by when they joined.
Why important? It helps you see if newer customers behave differently.
Simple explanation: Like grouping people by their birth year.
Example: Compare customers who joined in January vs. customers who joined in February.
Definition: Zoho Analytics is a powerful business intelligence tool that works with Zoho CRM.
Why important? It gives you even more powerful analytics capabilities.
Features:
Definition: Data-driven decisions are choices based on data, not just intuition.
Why important? Data-driven decisions are usually better than guesses.
Simple explanation: Like using a map instead of guessing which way to go.
How to be data-driven:
Definition: Predictive analytics uses data to predict what will happen.
Why important? It helps you prepare for the future.
Simple explanation: Like using a crystal ball, but with data.
Examples:
Definition: Report optimization is improving your reports to make them more useful.
Why important? Better reports lead to better decisions.
Tips:
Definition: Analytics culture means making data part of how your business operates.
Why important? Companies with a strong analytics culture perform better.
How to build it:
Definition: Best practices are smart ways to use analytics.
Tips:
Analytics – using data to make decisions.
Trend – a pattern in data over time.
Forecasting – predicting the future.
Funnel – shows where leads drop off.
Segmentation – grouping customers by characteristics.
Cohort – a group with a shared characteristic.
Predictive – using data to predict.
Optimization – making reports better.
Data-Driven – decisions based on data.
Insight – a valuable piece of understanding from data.
Example 1: A company uses funnel analysis to see that many leads drop off at the proposal stage. They improve their proposals and increase sales.
Example 2: A business uses trend analysis to see that sales are highest in December. They prepare more inventory for that month.
Imagine you have a lemonade stand. You track how many people walk by (leads), how many ask about lemonade (interested), and how many buy (customers). You see that many people walk away. You improve your sign and more people buy. That's funnel analysis!
Help your child understand analytics by asking: "How would you track your progress in a game?" This shows them how data helps improve performance.
Zoho Analytics uses AI to automatically find insights in your data!
Funnel Analysis
Leads: 100
↓ 30% drop
Contacted: 70
↓ 40% drop
Qualified: 42
↓ 50% drop
Won: 21 🎉
Analytics Cycle
Questions → Data → Analysis → Insights → Decisions → Action → Results
| Feature | Reporting | Analytics |
|---|---|---|
| What it does | Shows what happened | Explains why it happened |
| Focus | Past | Past, present, future |
| Purpose | Inform | Drive decisions |
| Output | Reports, dashboards | Insights, recommendations |
Congratulations! You have completed all five modules of the Zoho CRM Reports, Dashboards and Analytics course. Let's review what you have learned:
| Module | Key Topics Covered |
|---|---|
| Module 1 | Reporting fundamentals, types of reports, KPIs |
| Module 2 | Building reports, filters, groups, scheduling |
| Module 3 | Charts, data visualization, visual storytelling |
| Module 4 | Dashboards, widgets, KPIs, sharing |
| Module 5 | Advanced analytics, trends, forecasting, funnel analysis |
🎉 You are now ready to use reports, dashboards, and analytics to grow your business!
Keep learning and exploring. The more you use data, the better decisions you'll make.
Congratulations! You have completed Module Five. You now know:
With analytics, you can turn data into insights and make smarter decisions!
Match the term to its meaning:
| Term | Meaning |
|---|---|
| 1. Funnel | A. Predicting the future |
| 2. Forecasting | B. Shows where leads drop off |
| 3. Trend | C. A pattern in data over time |
Answers: 1-B, 2-A, 3-C
Scenario: You run a business and notice that many leads drop off at the proposal stage. What would you do with this information?
Answer: Investigate why leads are dropping off. Maybe proposals are too long, too expensive, or not clear. Improve proposals and track the results.
In groups, analyze a business situation. Identify a problem and use analytics to find a solution. Present your findings to the class.
Think of a business question you want to answer. How would you use analytics to answer it? Write down your approach.
Create a one-page analytics report for a business. Include trend analysis, a funnel chart, and recommendations.
If you have Zoho CRM access, create a report and analyze the data. Identify one insight and write a brief recommendation.
End of Module Five · Zoho CRM Reports, Dashboards and Analytics
🎓 You have completed all 5 modules. Congratulations!