# Sales Analytics and Reporting
> Chapter 6 of the Courseiva MB-910 curriculum — https://courseiva.com/learn/mb-910/sales-analytics-and-reporting
**Official objective:** 2.4 — Identify key sales analytics, dashboards, and reporting capabilities used to track sales performance and forecast revenue.
## Introduction
Sales analytics and reporting transform raw numbers — like how many deals were closed yesterday — into clear, actionable insights that tell you what is working, what is broken, and where the next sale is likely to come from. For the MB-910 exam, you need to understand that Dynamics 365 does not just store sales data; it actively analyses it to help you predict future revenue and measure team performance. This concept matters because the exam tests whether you can identify which tool (dashboard, report, or AI-driven insight) solves a specific business problem.
## The Bakery Manager's Dashboard Analogy
First, you open a small bakery, and every day you sell croissants, cakes, and bread. At first, you just count the cash in the till at the end of the day. But as the bakery grows, you need to know more: which pastries sell most on rainy days, whether your new sourdough recipe is profitable, and if you should hire an extra baker before the weekend rush. That need for deeper insight drives the creation of a bakery manager's dashboard.
Your dashboard is a single screen that shows live numbers: 'Today's revenue: £450', 'Croissants sold: 120', 'Most popular item: chocolate muffin'. It also shows trends: 'Sales up 15% compared to last Tuesday' and 'Your best baker is working today — production is 20% higher'. You can click on 'Forecast' and see: 'Based on this week's data, you will sell 800 loaves of bread by Saturday — order 50kg more flour now'.
This is exactly how Microsoft Dynamics 365 Sales works for a company. The raw sales data (your daily receipts) flows into dashboards and reports (your manager's screen). Instead of guessing what will sell, the system uses historical data to predict future revenue (your flour order recommendation). The bakery manager can answer: 'Should I open on Sundays?' by running a report on Sunday sales from last month. Without this, you are just baking and hoping. With it, you make decisions based on facts.
## Core explanation
Sales analytics and reporting in Microsoft Dynamics 365 Sales is the system's ability to take the raw data your sales team enters every day — phone calls, emails, meetings, won deals, lost deals — and turn it into meaningful summaries, visual charts, and predictions. It is like having a personal analyst who reads all your team's activity logs and then tells you exactly what is happening and what is likely to happen next.
At the heart of this are three core concepts: dashboards, reports, and AI-driven insights. A dashboard is a single screen that shows key metrics — such as revenue this month, number of open opportunities, and win rate — often using colourful charts and numbers that update automatically. Think of it as the instrument panel in a car: you glance at it to see your speed (current sales), fuel level (pipeline value), and warning lights (deals at risk of closing late). Reports are more detailed, structured documents that you can generate on demand or schedule to receive by email. For example, a 'Sales Pipeline Report' might list every open deal, its value, its probability of closing, and the salesperson assigned. Reports are like printing out a full spreadsheet, whereas dashboards give you the highlights at a glance.
The third layer is AI-driven insights, which Dynamics 365 calls 'Relationship Analytics' and 'Predictive Scoring'. The system uses machine learning — a type of artificial intelligence that learns from past data — to analyse patterns across all your sales records. It then assigns a 'score' to each opportunity, predicting how likely it is to close. For example, if nearly all deals over £10,000 that receive a product demo within two weeks end up closing, the system learns that pattern and will boost the score of any new deal that follows that same pattern. It can also alert you if a deal's activity has gone quiet, flagging it as 'stale' so you can re-engage the customer.
So why does this exist? Before Dynamics 365, sales managers often relied on spreadsheets that were manually updated, which meant the data was always a week old and prone to human error. Worse, managers had to mentally guess which deals were likely to close. Sales analytics replaces guesswork with facts. It replaces 'I feel good about this quarter' with 'The system shows we have a 78% probability of hitting target based on current pipeline and historical conversion rates.'
What does it replace? It replaces the old-fashioned method of having a sales assistant walk around with a clipboard asking each rep what they sold yesterday. It replaces quarterly meetings where managers flip through paper reports. It replaces intuition with data.
Key features you need to know for the exam include:
- 'Dashboards': personal or shared views of KPIs (Key Performance Indicators). You can have a 'Sales Manager Dashboard' showing team-wide data, and a 'Sales Rep Dashboard' showing only that rep's own deals.
- 'Charts' and 'Visualisations': bar charts, pie charts, and funnels that let you quickly compare things like revenue by region or win rate by product.
- 'Reports with Power BI': Power BI is Microsoft's powerful analytics tool that can pull data from Dynamics 365 and create highly customised, interactive reports. This is a step beyond standard reports because you can slice and filter data freely.
- 'Forecasting': a dedicated feature that uses historical data and current open opportunities to predict future revenue. It shows a 'forecast grid' where you can see predicted revenue per sales rep per month.
- 'Goal Management': you can set targets (goals) for individual reps or teams, and the system will automatically track progress against those goals using incoming data.
- 'Relationship Analytics': this tool analyses the activity history (emails, meetings, calls) between your sales team and a customer. It tells you if the relationship is healthy or if it has gone cold.
Each of these features serves a specific purpose. For example, a dashboard is the quick 'pulse check', while a forecast is the forward-looking projection. A report gives you the detailed evidence to back up decisions. An AI insight tells you something you did not notice yourself.
In summary, sales analytics and reporting turn raw data into a competitive advantage. They let a sales manager see not just what happened last week, but what is likely to happen next month, and they give each salesperson a clear guide on which deals to prioritise.
## Real-world context
An IT professional working with Dynamics 365 Sales analytics might be called in to set up a dashboard for a regional sales manager named Priya, who oversees a team of ten sales reps selling office furniture. Priya has been relying on a weekly spreadsheet that her assistant compiles manually, but it is always three days out of date and full of errors. She wants a live view.
The IT professional would start by interviewing Priya to understand her key questions. Priya says: 'I need to know immediately if a rep is falling behind. I also need to see which product lines are selling best in each city. And my boss wants a monthly forecast of total revenue for the next quarter.'
The IT professional then logs into Dynamics 365 and does the following:
- First, they check that the sales team is entering data correctly. They look at the 'Opportunity' records and see that reps are not always updating the 'Close Date' or 'Estimated Revenue' fields. They create a workflow that sends a reminder to any rep who has not updated an opportunity in seven days. This step is crucial because analytics are only as good as the data feeding them.
- Next, they use the built-in 'Dashboard Designer' to create a custom dashboard for Priya. They add a chart showing 'Revenue by Product Category' using a funnel visualisation, so Priya can see at a glance that office chairs account for 40% of revenue, while desks are only 15%. They add a 'Won vs Lost Ratio' pie chart to show win rate. They add a grid of 'At-Risk Opportunities' — deals with a close date in the next 30 days but low activity in the past two weeks.
- They then set up a 'Forecast' for the next quarter. They configure the forecast to pull from the 'Sales Pipeline' and use historical conversion rates. For example, if historically 60% of 'Proposal Sent' stage opportunities convert to won, the system will automatically calculate that a £100,000 deal at that stage represents a £60,000 expected contribution. They schedule the forecast to refresh every Monday morning.
- For the boss's monthly report, the IT professional uses Power BI. They connect Dynamics 365 to Power BI, then build a report that compares actual revenue against the quarterly target. The report includes a slicer so the boss can filter by region or sales rep. The IT professional publishes the report to a shared workspace so the boss can access it from her laptop or phone.
- Finally, the IT professional enables 'Relationship Analytics'. They show Priya how to open the 'Relationship Health' tab for any account. Priya clicks on a key customer, 'Acme Corp,' and sees a green bar showing that the relationship is healthy because there have been four interactions in the last week. Another account, 'Beta Ltd,' shows a red bar because the last contact was 45 days ago. Priya immediately assigns a rep to call Beta Ltd.
Throughout this process, the IT professional is not just a technician; they are a consultant. They explain to Priya that the dashboard will update every 15 minutes based on new data entered by the reps. They make sure Priya understands that a forecast is not a guarantee — it is a prediction that changes as new deals are added or existing ones move stages. They also set up security so that Priya can only see her own team's data and not data from other departments.
This real-world scenario shows that an IT professional's job is to configure the tools, ensure data quality, and train users. The ultimate goal is not to create a fancy chart, but to give decision-makers like Priya the confidence to act quickly on accurate information.
## Exam focus
The MB-910 exam will test your ability to differentiate between the core sales analytics and reporting tools in Dynamics 365. The questions are often scenario-based, meaning they describe a business need and ask you to pick the right feature. Here is exactly what you need to master:
First, you must understand the distinction between a 'dashboard' and a 'report'. A common exam trap is offering both as answer choices in a scenario. For example: 'A sales manager wants to see a live summary of key metrics like revenue and win rate on a single screen without scrolling. Which should they use?' The correct answer is 'dashboard' because dashboards are designed for at-a-glance, real-time views with multiple visualisations. A report is created for detailed, often printable, analysis. Remember this rule: if the need is 'quick overview', pick dashboard. If the need is 'detailed historical analysis to share with executives', pick report.
Second, know the 'Forecasting' feature. The exam loves to test whether you understand that a forecast uses historical data and your current pipeline to predict future revenue. A trap question might say: 'A manager wants to predict next quarter's revenue based on last year's numbers alone.' The correct answer would involve 'forecasting', but the system uses current opportunities, not just history. The exam may also test that forecasting can be set up per user, per team, or for the whole organisation.
Third, 'AI-driven insights' are a hot topic. You need to know two specific terms:
- 'Predictive Lead Scoring': The system automatically assigns a score (0-100) to each lead based on how likely it is to convert to a sale. A high score means you should call that lead first.
- 'Predictive Opportunity Scoring': Same idea, but for existing deals (opportunities). It predicts the likelihood of winning that specific deal.
A trick question might describe predictive scoring but call it 'manual ranking'. The correct answer will call it 'predictive scoring' or 'AI-driven insights'. Know that these features rely on machine learning models built into Dynamics 365.
Fourth, 'Goal Management' is another concept that appears. You set a 'goal' (e.g., £50,000 in revenue this month) and the system tracks actual revenue against that goal. The exam may ask what you would use to see if a rep is on track for their quarterly target. The answer is 'goals', not 'forecast'. Goals compare actual results to a target, while forecasts predict future results.
Fifth, 'Relationship Analytics' may appear in a question about tracking customer engagement. If a question says 'which tool shows you whether your sales team is staying in touch with a key account?', the answer is 'relationship analytics' or 'activity analytics'.
Finally, understand 'Power BI' integration. The exam may ask: 'A manager needs to create a custom interactive report combining sales data with external marketing data. Which tool should they use?' The answer is Power BI, because standard Dynamics 365 reports are limited to the data within the system, while Power BI can combine multiple data sources.
Key topic areas to memorise:
- Dashboard vs. report: quick glance vs. detailed analysis.
- Forecasting: uses current pipeline + historical conversion rates to predict future revenue.
- Predictive scoring: AI-based, automatic, for leads and opportunities.
- Goal management: actuals vs. targets.
- Relationship analytics: measures interaction health with accounts.
- Power BI: for advanced, cross-source custom reports.
The exam questions are straightforward if you can map each business need to exactly one feature. When in doubt, read the question twice and identify the verb (e.g., 'predict', 'visualise', 'compare'). That verb will point you to the right tool.
## Step by step
1. **Configure Data Entry** — Before any analytics work, ensure sales reps are consistently and accurately entering data into key fields like Opportunity Status, Estimated Revenue, and Close Date. Without clean data, dashboards and forecasts will be misleading. This step often involves setting up validation rules or automated reminders.
2. **Identify Business Questions** — Work with the sales manager to define what they need to know. Common questions include: 'What is our total pipeline value?', 'Which product sells best?', 'Are we on track for the quarterly target?'. This step determines which metrics to display on dashboards and which reports to create.
3. **Create and Customise Dashboards** — Using the built-in dashboard designer, you add visual elements like charts (bar, pie, funnel) and grids. You can choose between a personal dashboard (visible only to you) or a system dashboard (visible to the whole team). This step translates the business questions into visual answers.
4. **Set Up Forecasting** — Configure the forecast by selecting the period (monthly, quarterly), the entity (opportunities), and the metrics (revenue, count). The system then uses historical conversion rates and current pipeline data to project future revenue. This step provides the forward-looking prediction the manager needs.
5. **Enable AI Insights and Relationship Analytics** — Turn on predictive scoring for leads and opportunities so the system automatically ranks them by conversion likelihood. Enable relationship analytics to track communication health. This step surfaces hidden patterns and alerts the team to risks they might otherwise miss.
## Comparisons
### Dashboard vs Report
**Dashboard:**
- Designed for at-a-glance, real-time monitoring
- Uses multiple visualisations (charts, grids) on one screen
- Typically interactive and updates automatically
**Report:**
- Designed for detailed, structured analysis
- Usually a single document or table view
- Often static or generated on a schedule for review
### Forecasting vs Goal Management
**Forecasting:**
- Predicts future revenue based on pipeline and history
- Uses current opportunities and conversion rates
- Output is a projected number (e.g., £200k for next month)
**Goal Management:**
- Compares actual results to a predefined target
- Uses actual close data and the goal you set
- Output is a progress percentage (e.g., 75% of target achieved)
### Predictive Lead Scoring vs Manual Lead Ranking
**Predictive Lead Scoring:**
- Automatically computed by AI using historical data
- Score updates as new data arrives
- Objective and consistent across all leads
**Manual Lead Ranking:**
- Assigned manually by a salesperson based on intuition
- Score only changes when a person updates it
- Subjective and varies between individuals
## Diagram
_This diagram shows how raw sales data flows into Dynamics 365 and branches into four key analytics outputs — dashboards, reports, forecasts, and AI insights — each supporting different business users._
```mermaid
flowchart TD
A[Sales Data Entry] --> B{Dynamics 365 Sales}
B --> C[Dashboards
Live visual summaries]
B --> D[Reports
Detailed structured data]
B --> E[Forecasts
Future revenue predictions]
B --> F[AI Insights
Predictive scores for leads/opps]
C --> G[Sales Manager
Quick decisions]
D --> H[Executive Review
In-depth analysis]
E --> G
F --> G
```
## Common misconceptions
- **Misconception:** A dashboard and a report are the same thing — both show data. **Reality:** A dashboard shows live, at-a-glance summaries with visual charts, updated automatically. A report is a detailed, often static, document you generate on demand or schedule, typically for deeper analysis. (The terms are often used interchangeably in everyday conversation, so beginners assume they are synonyms. The exam specifically differentiates them.)
- **Misconception:** Forecasting in Dynamics 365 is just a guess based on the sales team's opinions. **Reality:** Forecasting uses historical data (past conversion rates) combined with current open opportunities to generate a statistically driven prediction. (People associate 'forecast' with human intuition (e.g., 'I think we'll make £100k'), so they underestimate the data-driven automation behind it.)
- **Misconception:** You need to install extra software to use dashboards in Dynamics 365. **Reality:** Dashboards are built into Dynamics 365 Sales and can be created using the built-in designer without any additional purchases or installations. (Beginners often think 'analytics' always requires a separate tool like Power BI, but basic dashboards are native to the product.)
- **Misconception:** AI predictions in Dynamics 365 are only available if you have an expensive premium license. **Reality:** Basic predictive scoring (for leads and opportunities) is included in many Dynamics 365 Sales licenses, including the Sales Professional and Sales Enterprise tiers. (The phrase 'AI' triggers an assumption that it is an expensive add-on, but Microsoft includes it as a standard feature in their sales products.)
## Key takeaways
- A dashboard provides a live, visual summary of key performance indicators at a single glance, while a report offers detailed, structured historical data for in-depth review.
- Forecasting in Dynamics 365 uses your current open opportunities and historical conversion rates to predict future revenue, not just past performance.
- Predictive lead and opportunity scoring automatically rank deals and leads by likelihood of closing, helping salespeople prioritise their efforts.
- Goal management lets you set revenue or unit targets and automatically tracks actual results against those targets in real time.
- Relationship analytics measures the health of customer relationships based on activity history, flagging accounts that need attention.
- Power BI integration allows you to create custom, interactive reports that combine Dynamics 365 data with external data sources for advanced analytics.
## FAQ
**What is the difference between a dashboard and a report in Dynamics 365?**
A dashboard is a live, visual overview of key metrics displayed on a single screen for quick monitoring. A report is a detailed, often structured document you generate on demand, used for in-depth analysis or sharing with stakeholders.
**Does the forecast in Dynamics 365 use real-time data?**
The forecast refreshes based on the latest data in the system, but it is not completely real-time. It typically updates every 15 minutes or on a schedule you set, using the most current opportunities and historical conversion rates.
**Can I create custom charts on a dashboard?**
Yes. Dynamics 365 provides a drag-and-drop dashboard designer where you can add custom charts (bar, column, pie, funnel, etc.) using any fields from sales records, such as revenue by region or win rate by salesperson.
**What is predictive lead scoring and why would I use it?**
Predictive lead scoring is an AI feature that automatically assigns a score (0-100) to each lead, indicating how likely they are to become a customer. You use it to prioritise which leads your sales team should contact first, increasing efficiency and conversion rates.
**Do I need Power BI to see reports in Dynamics 365?**
No. Dynamics 365 includes built-in reporting capabilities for standard reports (e.g., pipeline, won/lost). Power BI is used only when you need more advanced, interactive, or cross-source reports that combine data from multiple systems.
**How does goal management work in Dynamics 365?**
You define a goal (such as £50,000 in monthly revenue) and attach it to a user or team. The system then automatically tracks actual revenue entered against that goal, showing progress as a percentage, so managers can see who is on track and who is behind.
## Check your understanding
1. **A sales manager wants to see a live summary of total revenue, win rate, and the number of open opportunities on a single screen. Which tool should be used?**
Answer: A dashboard, because it provides a live, at-a-glance visual summary of key metrics.
2. **What two types of data does the Forecasting feature use to predict future revenue?**
Answer: It uses current open opportunities (pipeline data) and historical conversion rates from previous deals.
3. **What is the name of the AI feature that automatically assigns a score to each lead based on how likely it is to convert?**
Answer: Predictive lead scoring.
4. **If a sales manager wants to track whether each sales rep is hitting their monthly revenue target, which feature should they use?**
Answer: Goal management, which compares actual revenue against the target set for each rep.
5. **A manager wants to create a custom interactive report that combines Dynamics 365 sales data with data from an external marketing tool. Which tool is needed?**
Answer: Power BI, because it can connect to multiple data sources and create interactive reports beyond standard Dynamics 365 capabilities.
---
Interactive version with quiz and diagrams: https://courseiva.com/learn/mb-910/sales-analytics-and-reporting