ADM-201 Reports and Dashboards

Reports and Dashboards Detailed Explanation

The Reports and Dashboards module is a powerful tool in Salesforce that allows users to analyze data, identify trends, and make informed decisions. Reports display detailed data, while dashboards provide a visual summary of key metrics.

7.1 Reports

Reports are structured lists of data pulled from Salesforce records. They allow users to view, filter, and analyze information based on specific criteria.

Report Types

There are four main report types in Salesforce, each suited for different use cases:

1. Tabular Reports

• What It Is:
  • Displays data in a simple, spreadsheet-like format with rows and columns.
• Use Case:
  • Best for viewing flat data lists (e.g., all Contacts in a region).
• Example:
  • A list of all open Leads sorted by Lead Source.

2. Summary Reports

• What It Is:
  • Groups and summarizes data by one or more fields.
• Use Case:
  • Ideal for analyzing data trends or creating subtotals.
• Example:
  • Total sales grouped by Sales Rep.

3. Matrix Reports

• What It Is:
  • Groups data by rows and columns, creating a grid layout.
• Use Case:
  • Useful for comparing data across two dimensions.
• Example:
  • Quarterly sales totals by Region (rows) and Product Line (columns).

4. Joined Reports

• What It Is:
  • Combines multiple reports into a single view.
• Use Case:
  • Useful for comparing data from related objects or showing different perspectives.
• Example:
  • A report combining Opportunities and Cases for the same Accounts.

Report Grouping

Grouping organizes data within reports, making it easier to identify trends and summarize information.

How to Group Data

1. Open a report in the Report Builder.
2. Drag a field (e.g., Close Date, Owner) into the Group Rows or Group Columns section.
3. Add filters if needed to refine results.

Common Grouping Examples

• Group by Date: View sales closed per quarter.
• Group by User: See activities completed by each team member.
• Group by Field: Organize accounts by industry.

Features to Enhance Reports

1. Filters:
   • Narrow down data by adding filters (e.g., show only Opportunities with "Closed Won" status).
2. Charts:
   • Visualize data within reports using bar, line, or pie charts.
3. Export:
   • Export reports to Excel or CSV for offline analysis.

7.2 Dashboards

Dashboards are visual representations of report data, providing a quick overview of key metrics and trends.

Dynamic Dashboards

What Are They?

• Dashboards that adjust their data based on the viewer's access permissions.
• Each user sees only the data they have permission to view.

When to Use:

• For teams with varying data visibility (e.g., managers see all sales data, reps see only their own).

Example:

• A "Monthly Sales Dashboard" shows team-wide sales data for managers and individual performance for sales reps.

Dashboard Components

Dashboards are made up of components that display report data in different visual formats.

1. Charts

• What It Is:
  • Displays data visually as bar charts, line graphs, or pie charts.
• Use Case:
  • Ideal for showing trends or comparisons over time.
• Example:
  • A bar chart displaying revenue by region.

2. Gauges

• What It Is:
  • Displays a single value within a range, similar to a speedometer.
• Use Case:
  • Great for tracking progress toward a goal.
• Example:
  • Percentage of quota achieved this quarter.

3. Metrics

• What It Is:
  • Displays a single, key number.
• Use Case:
  • Perfect for highlighting a critical value at a glance.
• Example:
  • Total revenue for the current month.

4. Tables

• What It Is:
  • Displays data in a tabular format.
• Use Case:
  • Ideal for showing detailed lists (e.g., top 10 deals by size).
• Example:
  • A table of the top 5 performing sales reps.

How to Create a Dashboard

1. Prepare Reports:
   • Ensure all necessary reports are created and saved.
2. Navigate to Dashboards:
   • Go to the Dashboards tab and click New Dashboard.
3. Add Components:
   • Drag and drop charts, gauges, or tables into the dashboard canvas.
4. Save and Share:
   • Save the dashboard and share it with the team or specific users.

Step-by-Step Summary

Reports

1. Choose the appropriate report type:
   • Tabular for lists, Summary for grouped data, Matrix for comparisons, Joined for combined views.
2. Add filters and grouping to refine data.
3. Visualize data using charts and export for offline use.

Dashboards

1. Use dynamic dashboards for personalized views.
2. Add components like charts, gauges, or metrics to visualize data.
3. Share dashboards with your team to monitor key metrics collaboratively.

Key Takeaways for Beginners

• Reports: Use them to gather and analyze detailed data.
• Dashboards: Provide high-level visual insights for quick decision-making.
• Dynamic Dashboards: Ensure data visibility aligns with user permissions.

Reports and Dashboards (Additional Content)

1. Custom Report Types (Building Tailored Reports for Unique Business Needs)

Why is it important?

• Custom Report Types (CRTs) allow administrators to define relationships between objects and customize field visibility beyond standard report types.
• Helps create reports that combine multiple objects in ways that standard reports do not support.

How to Create a Custom Report Type

1. Navigate to Setup → Search for Report Types.
2. Click New Custom Report Type.
3. Select the Primary Object (e.g., Leads).
4. Define Related Objects (e.g., Opportunities, Accounts).
5. Choose the relationship setting:

• "Each A record must have at least one related B record" → Includes only parent records with at least one related child record.
• "Each A record may or may not have related B records" → Includes all parent records, even those without child records.

6. Define field visibility and custom report layout.
7. Save the report type.

Example Scenario

• A sales team wants to track Leads and their related Opportunities.
• Standard report types do not provide a direct way to view this information.
• A Custom Report Type (CRT) allows Leads and Opportunities to be joined into a single report.

2. Bucket Fields (Categorizing Data Without Modifying the Database)

Why is it important?

• Bucket Fields allow users to create custom categories in reports without changing the underlying data.
• Helps group numerical or text values into meaningful segments.

How to Use Bucket Fields

1. Open the Report Builder.
2. Click on a numeric or text field (e.g., Opportunity Amount).
3. Click "Create Bucket Field".
4. Define custom Buckets (e.g., Sales Amount Ranges):

• Small Deals: <$10K
• Medium Deals: $10K - $50K
• Large Deals: >$50K

5. Apply Buckets to group data in reports.

Example Scenario

• A sales manager wants to categorize deals into small, medium, and large.
• Instead of creating a custom field in Salesforce, they use Bucket Fields in Reports.

3. Row-Level Formulas (Calculating Metrics on the Fly in Reports)

Why is it important?

• Row-Level Formulas allow users to perform calculations within a report without needing to create new fields in the object.
• Helps generate insights dynamically based on existing report data.

How to Create a Row-Level Formula

1. Open Report Builder.

2. Click "Add Formula".

3. Choose the fields to include in the formula.

4. Define the formula logic, such as:

• Calculate Expected Revenue:

  Amount * Probability
  

• Calculate Discount Percentage:

  (List Price - Sale Price) / List Price * 100
  

5. Save the formula and apply it to the report.

Example Scenario

• A sales team wants to calculate Expected Revenue per Opportunity:
  • Instead of adding a custom formula field in Salesforce, they create a Row-Level Formula that multiplies Amount × Probability.

4. Report Subscriptions (Automating Report Delivery to Users)

Why is it important?

• Report Subscriptions allow users to receive report updates automatically, ensuring real-time data visibility without manually checking reports.

How to Subscribe to a Report

1. Open the desired report.
2. Click "Subscribe".
3. Set Delivery Frequency:

• Daily, Weekly, or Monthly.

4. Select Recipients (Users, Groups, or Public Email Addresses).
5. Define Trigger Conditions (Optional):

• Example: Only send if Opportunities > $100,000.

6. Save the subscription.

Example Scenario

• A sales manager wants to receive a daily report of new Opportunities created in the last 24 hours.
  • They subscribe to the report, choosing "Daily" delivery at 8 AM.

5. Joined Reports (Comparing Data from Multiple Objects in One Report)

Why is it important?

• Joined Reports allow users to compare multiple datasets from different objects in a single report layout.
• Unlike standard reports, Joined Reports display data in separate blocks, enabling side-by-side comparisons.

How to Use Joined Reports

1. Open Report Builder.
2. Select "Report Type" → "Joined Report".
3. Add multiple report blocks:

• Block 1: Opportunities
• Block 2: Cases

4. Define a common field (e.g., Account Name) to link the datasets.
5. Apply Filters and Summaries for data comparison.

Example Scenario

• A customer success team wants to analyze the correlation between sales and support cases.
  • They create a Joined Report with:
    • Opportunities in Block 1 (to see closed deals).
    • Cases in Block 2 (to track support requests from those same customers).

6. Dashboard Filters (Creating Interactive Dashboards for Dynamic Insights)

Why is it important?

• Dashboard Filters allow users to change data views dynamically without creating multiple dashboards.
• Instead of creating separate dashboards for each region or sales rep, users can apply a filter to view different segments.

How to Use Dashboard Filters

1. Open the Dashboard Builder.
2. Click "Add Filter".
3. Select the field to filter by (e.g., Sales Region, Account Type).
4. Define Filter Values (e.g., North America, Europe, Asia).
5. Save the Dashboard.

Example Scenario

• A sales director wants to view performance by region.
  • Instead of creating separate dashboards for each region, they use a single dashboard with a "Sales Region" filter.

Final Summary

Feature	Description	Best Use Cases
Custom Report Types	Creates reports with custom object relationships	Combining Leads and Opportunities in a single report
Bucket Fields	Groups data into categories without modifying the database	Categorizing Opportunities by Deal Size
Row-Level Formulas	Calculates values dynamically within reports	Computing Expected Revenue per Opportunity
Report Subscriptions	Delivers automated report updates via email	Sending daily reports of new deals to sales managers
Joined Reports	Displays data from multiple objects in separate report blocks	Comparing Opportunities and Support Cases for the same customers
Dashboard Filters	Allows users to change data views dynamically	Filtering a single dashboard by Sales Region