---
schema_version: "1"
id: 6108d781419ac1dc35b6ac9a714771602b73d8c7d06966c657b637c5f922ccde
title: View Big Object Data in Reports and Dashboards
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/big-object-impl-guide/guides/big-object/big-object-query-and-report.md
canonical_url: https://developer.salesforce.com/docs/platform/big-object-impl-guide/guide/big-object-query-and-report.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 6d99829816a7b38d67ed387ca8007239b8cb4dd79127aaabe2c5b8bc943fde0e
products:
  - Big Objects Implementation Guide
  - Platform Developer Content
---

# View Big Object Data in Reports and Dashboards

When working with big data and billions of records, it’s not practical to build reports or dashboards directly from that data. Instead, use Bulk API to write a query that extracts a smaller, representative subset of the data that you’re interested in. You can store this working dataset in a custom object and use it in reports, dashboards, or any other Lightning Platform feature.

1.  Identify the big object that contains the data for which you need a report. In this example, the `Ride__b` big object contains the full dataset.

2.  Create a custom object. This object holds the working dataset for the big object data that you want to report on. In this example, we use the `Bike_Rental__c` custom object.


    1.  Under Optional Features for the custom object, click **Allow Reports**.

    2.  Add custom fields to the object that match the fields that you want to report on from the big object.

3.  Create an SOQL query that builds your working dataset by pulling the data from your big object into your custom object.

    To ensure that your working dataset is always up-to-date for accurate reporting, set this job to run nightly.

4.  Build a report using the working dataset you created.


    1.  From Setup, enter `Report Types` in the Quick Find box, then select **Report Types**.

    2.  Create a custom report type.

    3.  For the Primary Object, select the custom object from step 2, `Bike_Rental__c`.

    4.  Set the report to **Deployed**.

    5.  Run the report.

You can now use the information from your working dataset not only in your reports, but also in dashboards or any other Lightning Platform feature.