Pre-Defined Reports Filtering Grouping Breadcrumbs

Viewing Your Public Cloud Billing Reports

Viewing Your Public Cloud Billing Reports

#380550

The Densify Cloud Cost Intelligence module allows you to review your billing data through a dedicated reporting interface. It is a full-featured reporting framework that allows you to filter and build the reports you need to manage your cloud bills. You can customize and save your reports and then generate them monthly or as required, for analysis.

Note: Currently, collection and analysis of billing data is only supported for AWS.

To learn more watch the video,

Prerequisites

The following prerequisites must be addressed before you can access the Cloud Cost Intelligence module:

  • Configure and initiate data collection—You must create a cloud connection and collect both CloudWatch and billing data. Refer to AWS Data Collection Prerequisites for an IAM Role for details on collecting both billing data and CloudWatch data. It may take up to 24-hours from the time you create the connection to data being collected and loaded into your Densify instance.
  • Join the Billing_Analyst group—Your Densify user account must be a member of the Billing_Analyst group. Once the module has been enabled, your Cloud Advisor will either create a new billing analyst user account or add your existing account to the Billing_Analyst group. See Managing Densify User Accounts.

The Densify Console has been optimized for Google Chrome so this browser is highly recommended for the richest user experience.

Accessing the Cloud Cost Intelligence Module

  1. Log in to Densify using your Billing_Analyst user account.
  2. You will be prompted to select which console to open. Select Cloud Cost Intelligence module.
  3. When you log out of the Cloud Cost Intelligence module, you are returned to the Densify login page. You need to login in and select the Densify Console to access other Densify features.

Densify collects, loads and processes your AWS cost and usage report (CUR). Refer to AWS for details on the content of the cost and usage report. Refer to AWS Data Collection Prerequisites for an IAM Role for details on configuring the cost and usage report and collecting billing data.

This module provides a cost navigator and a view of your Reserved Instance usage. The Cost Navigator is displayed by default. See See Using the Reserved Instance Cost Reports for details on using the RI reports.

The data displayed in each report is based on both the selected options at the top and the filters located on the left side of the page. See Grouping and Filtering Your Billing Data.

Cost Navigator Overview

You can customize and save a set of options that you can then access at any time, through the Reports drop down menu.

Note: The Report Library tab at the top of page is intended for future development. Depending on your specific installation you may see the list of your Cloud Cost Intelligence reports, including any custom billing reports that have been enabled . Alll other custom reports are available through Densify ConsoleMy Reports.

Once the billing data has been collected by Densify, the following tabs provide the tools to review your bill:

  • Chart View—Provides a chart summary of your billing data.
  • Tabular View—Provides a tabular summary of the entire data set.
  • Outliers—Provides a table of billing anomalies. These are data points that are outside of a pre-defined range and show you cost or usage that is outside of your normal expenditure. The range typically corresponds to 2 standard deviations and is configurable.

Summary Bar

A summary bar is provided at the top of each of the Cost Navigator and Reserved Instances reports that provides a high level overview of the report content. The content for each summary bar is different and the totals are affected by the grouping and filter settings that have been applied to the report.

Breadcrumbs

The displayed billing data is based on the options selected at the grouping and filtering options at the top and left side of the page. If filtering has been enabled , you will see the selected filter setting as "breadcrumbs" at the top of the report. See Grouping and Filtering Your Billing Data.

Savings Plans

Savings plans offer discounts when you make an hourly commitment to compute usage and are automatically applied to any applicable compute usage across regions, regardless of instance size, tenancy, and OS. These discounts are reflected on the chart as negative values. and are indicated in the chart's legend.

Chart View

The type of chart view is selectable. The top 10 items, as defined by your grouping and filtering selections are displayed on this chart and are listed in legend on the right side of the page. You can also hover over any one of the bars to see a breakdown of the data. A legend is displayed on the right side of the chart.

The type of chart is selectable and options are described below.

Chart Type Selection

You can choose from various chart types to best suit your requirements. The chart type selection is not saved when your report options are saved.

Note: This feature is not applicable to the Reserved Instance Utilization Report.

By default, the selected data is shown in a column chart format. You can select a different type of chart at any time from the Chart Types window. The following chart types are provided:

Table: Cloud Cost Navigator - Chart Type Options

Column Name

Description

Column

Values are displayed as columns. Three report options are available:

  • Column—Group members are shown as individual columns.
  • Stacked Column—Group members are show as portions of a single column whose size reflects the aggregate value of the group.
  • Percent Column—Group members are shown as proportions of a single column of fixed size.

Bar

Values are displayed as bars. Three report options are available:

  • Column—Group members are shown as individual horizontal bars.
  • Stacked Column—Group members are show as portions of a single horizontal bar whose size reflects the aggregate value of the group.
  • Percent Column—Group members are shown as proportions of a single horizontal bar of fixed size.

Line

Values are displayed as points connected by lines. Two report options are available:

  • Line—Displays data points connected with straight lines.
  • Spline—Displays data points connected with a fitted curve.

Area

Values are displayed as shaded areas. Two report options are available:

  • Line—Displays data points connected with a straight line and a color below the line. Groups members are displayed as transparent overlays.
  • Spline—Displays data points connected with a fitted curve and a color below the line. Groups members are displayed as transparent overlays.

Spider

This type of chart displays three or more values on a series of spokes. Spider charts can use columns, lines, or areas to display values.

  • Line—Displays data points connected with a straight line and a color below the line. Groups members are displayed as transparent overlays.
  • Spline—Displays data points connected with a fitted curve and a color below the line. Groups members are displayed as transparent overlays.

Tabular View

Though the charts show only the top 10 items, this tabular view provides details on the entire set of data, as defined by your grouping and filtering settings.

Within the table, you can click on any of the entries with hyperlinks to see an expanded view of the underlying data from the cost and usage report. The billing line item details are a rolled up value and when you click to drill down the resulting data is capped at 1000 rows, so as to not impact performance. The message at the top of the table indicates how many additional rows of data are avaialble

You can export the content from both the tabular view and the drilled down details report to see the full set of data.  Data can be export to CSV, PDF or XLSX formats.

Outliers

This report tab, within the Cloud Cost Intelligence console, provides a tabular list of values that are identified as outliers. Values are considered outliers if they are more than 2 standard deviations away from the average value. The average value is determined from the previous 10 days of data. The table is sorted by the highest outlier value

The set of outlier data displayed, is based on the selected grouping and filters. If you change the settings, the new settings will also be applied to the cost navigator, so you may want to save your report configuration before making any changes.

Links are provided within the outlier report that allow you to investigate the data.

  1. Click the first link to see the detailed data that has been rolled up to the outlier value.
  2. Click the second link to open a graphical representation of outlier data. This chart provides the upper and lower limits of a moving average of your selected data, as a set of bands. The bands provide an area that includes 95% of your data. The range typically corresponds to 2 standard deviations above and below a 10-day moving average. These settings are configurable.
  3. You can select from various chart options. The most commonly used line chart is displayed, by default.

    The outlier tabular report is sorted by the values in the column "Delta from Avg".

  4. Click the Back button (below the Cost Navigator label) to return to the parent report. If you drill down to the detailed or graphical outlier data report, click the Back button to return to the parent outlier listing.

When reviewing the report observe the following:

  • Normal data points are shown as black dots.
  • The red dots are the outliers.
  • The grey, shaded area highlights the day you selected in the tabular view.
  • The orange dashed line is the historical moving average, based on the last 10 days of data, or whatever value and unit you have configured.
  • The blue dashed line is the 2-standard devaiton threshold. In this case, two standard deviations.
  • A footnote below the graph indicates the outlier configuration settings

Configuring the Outlier Report

Three settings are used to configure this report. These settings are accessible from the settings section in the left pane.

Table: Outlier Configuration Settings

Setting

Default

Description

Outlier Threshold (Std Deviations)

2

The number of standard deviations from the average, that the value needs to be before it is identified as an outlier. The default is 2 standard deviations.

Outlier Time Window

10

Values are identified as outliers if they are more than 2 standard deviations from the average value. This value defines the amount of data used to establish the average value. The default is 10.

The time unit depends on what has been selected for the report. If the time scale for the report is in days, then 10 days of data is used to determine the average. If the time scale is in months, then 10 months of data is used to determine the average

If you do not have the specified number of <time units> of data, then no outliers will be detected, until the required ata has been collected and analyzed. For this reason it is very important to verify the time scale on your outlier reports.

Outlier Minimum

100

This is the minimum value to be considered an outlier. Data points below this are considered part of normal, or expected billing activity.

As with the time window, the units are based the data selected for your report.

Exporting Data

You can export the content of any of the reports by clicking the export icon, located on the right side of the page. You can export tabular data to PDF, CSV or XLS. Data exported to .XLSX is not paginated.

Charts can only be exported to a PDF file. The currently displayed chart type is exported to PDF. See Chart Type Selection for available chart types. Charts can also be exported as .CSV and .XLSX. In this case, the export results in the export of the tabular data on which the chart is based.

You may need to scroll horizontally to see the download icon on some tabular reports due to the amount of data on the screen.

Search

You can use the search feature to search the content of the current page. Even when you drill down, your results may still include hundreds of records.

Enter your search criteria and then use the forward and back buttons to search the pages's content.

Zoom

You can use the zoom features to increase/decrease the report viewing area. The Cloud Cost Intelligence module's zoom features are separate from your browser zoom features.

It is highly recommended that you keep your browser zoom at 100% to avoid display issues and use the zoom feature within the report, as required.

Pre-Defined Reports Tab

A number of commonly used reports are provided in the Reports drop down menu. The data set is not filtered.

The data is grouped as indicated in the report title and there are View By and Period selectors set. These can be adjusted for your use case. You can also adjust the filtering criteria as required and then save your report with a new name.

The following reports are available from this menu:

Table: Pre-Defined Reports for Cost Navigator

Report Name

Description

Show (Metric)

Group By

Period

Costs by Account (Daily - MTD)

Unblended Costs grouped by Linked Account shown for each day of the previous month.

Unblended Cost

Linked Account

Previous Month-to-Date

Costs by Account (Monthly)

Unblended Costs grouped by Linked Account showing month over month spend. The last 5 months and month-to-date for the current month are displayed.

Unblended Cost

Linked Account

Previous 6 Months

Costs by Account (Quarterly)

Unblended Costs grouped by Linked Account showing quarter over quarter spend. The last 4 completed quarters are displayed.

Unblended Cost

Linked Account

Previous 4 Quarters

Costs by Account (Yearly)

Unblended Costs grouped by Linked Account showing year over year spend. All available data is displayed with year-to-date shown for the current year.

Unblended Cost

Linked Account

Previous 2 Years

Costs by Charge Type (Daily)

Unblended Costs grouped by Charge Type shown for each day of the previous month.

Unblended Cost

Charge Type

Previous Month to Date

Costs by Charge Type (Monthly)

Unblended Costs grouped by Charge Type showing month over month spend. The last 5 months and month-to-date for the current month are displayed.

Unblended Cost

Charge Type

Previous 6 Months

Costs by Charge Type (Quarterly)

Unblended Costs grouped by Charge Type showing quarter over quarter spend. The last 4 completed quarters are displayed.

Unblended Cost

Charge Type

Previous 4 Quarters

Costs by Charge Type (Yearly)

Unblended Costs grouped by Charge Type showing year over year spend. All available data is displayed with year-to-date shown for the current year.

Unblended Cost

Charge Type

Previous 2 Years

Costs by Service (Daily - MTD)

Unblended Costs grouped by Service shown for each day of the previous month.

Unblended Cost

Service

Month-to-Date

Costs by Service(Monthly)

Unblended Costs grouped by Service showing month over month spend. The last 5 months and month-to-date for the current month are displayed.

Unblended Cost

Service

Previous 6 Months

Costs by Service(Quarterly)

Unblended Costs grouped by Service showing quarter over quarter spend. The last 4 completed quarters are displayed.

Unblended Cost

Service

Previous 4 Quarters

Costs by Service (Yearly)

Unblended Costs grouped by Service showing year over year spend. All available data is displayed with year-to-date shown for the current year.

Unblended Cost

Service

Previous 2 Years