fbpx

High-Level PowerPoint & Excel Cloud Reports

Obtain a high-level trend insight into your cloud environments and view the evolution of your cloud assets over time.

AUTHOR

Haithem Khelifi

DATE

February 16, 2022

Cloudockit’s high-level reports consist of 2 types of documents: Excel and PowerPoint.

These documents help you monitor your cloud environment by displaying, through various tables and charts, an overall view of the changes occurring across your resources on a weekly or monthly basis. The documents are useful to track the changes in your resources, resource categories, resource types, tags, applications, warnings, and their associated costs.

The Excel document includes spreadsheets containing charts, pivot tables, and tables. The charts and tables list different stats from your resources and are organized by resource categories and by tags. The Excel documents allow you to have a customized experience by enabling you to modify the charts, pivot table, and display elements based on the data found by Cloudockit.

The PowerPoint document has more visual content and is useful for presentations with its different charts and summarized tables. The charts in the PowerPoint document are also customizable.

Before starting:

    • To use these dashboards effectively, please ensure to read our step-by-step guide on how to set up the high-level documents
    • The trends represented in the charts start from the moment you first started generating the high-level documents and will be updated every week or month depending on the selected frequency. Any gaps present in these charts is due to a skipped document generation or a scanning issue

High-Level Excel Reports

Charts spreadsheet

In the first spreadsheet, 10 charts across 3 sections are displayed. They include:

Overall Resources Status

    • The total distribution of resources by subscription
    • The number of resources by Application (which are the resources that you tag in your cloud environment as “Application”)
    • The trend of the distribution of resources by subscription over a period of time

The Cost Information Trend

    • Displays the total spending trend across all your subscriptions as well as, by application, and by resource category

Security and Best Practices Trend

    • The representation of the security, availability, and best practices changes occurring across all your subscriptions.

Pivot Tables Spreadsheet

Pivot tables offer a summarized view of the data found in the Categories Tables by displaying the totals of your costs, numbers of resources, and numbers warning for different dates.

Categories Table Spreadsheet

This table contains relevant statistics of your resources organized by subscription and resource category (Top category then Category) for each scan date.

For each resource category, you will find statistics computed for each scan period. These include:

    • The total cost of the category
    • The cost change compared to the previous scan
    • The total number of resources in that category
    • The number of deleted and/or added resources compared to the previous period
    • The number of tagged resources
    • The number of resources tagged for billing.

The additional statistics in the table relate to the numbers of security, availability, and best practices warnings for the category.

You can also build your own pivot tables and charts for subscriptions or resource categories based on the detailed data found in your cloud environment.

Tags Table Spreadsheet

The Tags Table spreadsheet will include the same stats of your resources, however, they will be organized by Tag, TagKey/TagValue. The table will also include the type of tag, as specified by the user in the Organize Content tab on the Cloudockit UI, and if it’s a billing tag.

High-Level PowerPoint Reports

The PowerPoint document is designed differently with more categories of information summarized through various charts and tables adapted for a PowerPoint presentation.

The comparison period displayed indicates the timeframe used to compute the resource changes. It is the state of the resources from the current scan compared to the state of the resources from the previous scan.

This comparison period can be slightly different from the timeframe used for the information of the costs if the scan dates do not correspond to the billing intervals. This is because the spending data is always gathered on fixed intervals, depending on the selected frequency:

    • Weekly: Monday to Sunday (included) of the previous week
    • Monthly: 1st to last day of the previous month

For this reason, it is highly advised to schedule the scan on Monday for weekly, and on the 1st day of the month for monthly. That way the resources and spending information displayed are in sync.

Subscription

This subsection lists the subscriptions, names, and IDs currently present in your environment.

Summary

The summary section is separated into 5 subsections and contains various tables summarizing the diverse metrics:

    • Subscriptions
    • Resource categories
    • Resources
    • Applications
    • Resources without tags

Resource Categories

This section displays the following changes compared to the previous scan:

    • New types of resources used
    • Types of resources no longer used
    • Categories of the recently added and deleted resources
    • New subscriptions
    • Deleted subscriptions
    • Subscriptions with more than 20% of new and deleted resources
    • New applications
    • Deleted applications
    • Applications with more than 20% of new and deleted resources

Resources

This Resources section displays the list of added and deleted resources for the scan period.

Applications

Under Applications, you will see the list of added and deleted applications for the scan period.

Resources Without Tags

This section presents the list of changes that occurred between 2 scans on the resources that are not tagged.

The possible values for these changes are:

    • Added Without Tags (Resource did not exist and is now added without a tag)
    • Tags removed (Tag for the resource was removed or lost)
    • Deleted (Resource without a tag is now deleted from the subscription)
    • Tagged (Resource is now tagged)

Monitoring

The monitoring slides contain charts and tables displaying information for resource distribution, their changes, spending trends, and warning trends.

Cost Trends

The cost trends section displays the cost trends for the previous billing periods, week, or month.

Billing Watch

Billing watch discloses information on the important billing changes that occurred during the last billing period.

The possible values displayed are:

    • Subscriptions with more than 20% of cost increase and decrease
    • Applications with more than 20% of cost increase and decrease
    • Categories with more than 20% of cost increase and decrease

Security & Best Practices Trends

This section contains bar charts for all the security, availability, and best practices warnings for all periods. Additionally, you will find a table listing the main warning changes compared to the previous scan.

The possible values displayed are:

    • New high-security warning types
    • Subscriptions and applications with new high-security warning types
    • Subscriptions and applications with new high availability warning types

Subscription Summary Slide

Contains a table displaying the following information for the current period and the change detected:

    • Number of resources
    • Cost for the current period
    • High-Security warnings
    • High Availability warnings

Detailed Information

The detailed information section contains more in-depth information for each subscription.

Cost Trend for the Previous Periods

Total cost trend for the subscription and for each category.

Warning Trends Charts

Charts for trends for high security and high availability warnings.

Warning Changes

The warning changes table lists changes in new high security and high availability warnings.

Detailed Resource Changes

This part contains information about the added, deleted resources, and their type.