Data Explorer Feature
The Data Explorer feature is a powerful insight-driven tool for data analysis, designed to provide users with maximum flexibility and comprehensiveness when it comes to multi-dimensional report generation. With the ability to create reports that aggregate data across various fields, users can tailor their reports to reflect the exact cost measurements and dimensions they need.
Data Explorer is unique due to its explorative capabilities, which allow for the aggregation of complex data tailored to select cost measurements and dimensions, whether on a daily, weekly, or monthly basis. This level of granularity enables users to gain deeper insights and a more accurate understanding of their costs, ultimately empowering them to make more informed decisions.
Use cases
The Data Explorer feature can be utilized in various scenarios, including but not limited to:
Assess Resource IDs, allowing for an in-depth look at various aspects such as usage types and product families, enhanced by the ability to filter results according to specific services.
Track and analyze the cost-related aspects of sub-services, offering insights into the utilization of resources like S3 storage and NAT gateway, measured in hours and gigabytes.
Identify untagged data, providing essential information to guide the tagging process, which is crucial for improved data management and categorization within an organization.
Measurements vs. dimensions
Measurements- Numerical values or quantitative data used to represent a particular aspect of the analyzed data. These can include numbers such as cost types, and usage.
Dimensions- Categories or classifications that help organize and group related measurements. These can include the service type, region, or any tags. Dimensions provide context to the measurements and allow for deeper analysis and understanding of the data. Dimensions affect the level of detail in the view.
Creating a New Data Explorer
Navigate to Data Explorer in the navigation bar.
Select New Data Explorer.
Provide a name for your report.
(Optional) Include a description for your report.
Define the relevant dates for your report data.
(Optional) Filter the new Data Explorer using the MegaBill components, such as services, cost centers, or Virtual Tags.
(Optional) Choose a Time Column from day, week, or month.
(Optional) Define Measurements-
Specify aggregation activities for the report, choosing from Sum, Average, Minimum, or Maximum.
Select the cost type.
Please note: To add multiple measurements, click on ‘+’.
(Optional) Add Dimensions to the new Data Explorer by using the MegaBill components, such as services, cost centers, or Virtual Tags.
(Optional) Columns management- Reorder or rename selected fields as desired. Drag measurements up or down by clicking on the dots beside each measurement.
Order by- Set the order of the report based on selected measurements.
Click Save to generate the report.
Once saved, the report will be displayed with all the chosen data.
Additional options:
Duplicate report- Use the 'Duplicate' option to create a copy of the report.
Download report- Download the report as a CSV file.
Manage reports- Access all created reports in the main Data Explorer list. Click the three dots beside a report to edit, duplicate, or delete it.
Still need help? Please feel free to reach out to our team at [email protected].