Gain Deeper Insights and Analysis Using Power BI Solution Template for Azure Activity Log

Power BI solution template provides analytics on top of Activity Log in Azure Portal.

Share online:

Azure Activity Log Administrative Page

Microsoft has released Power BI solution template for Azure Activity Log, that provides analytics on top of Activity Log in the Azure Portal. It's also possibe to gain insight into the activities performed by various resources and people in the subscription.

Get started with setting up a solution template using the installer that guides through the process, and when prompt, just provide Azure credentials, as well as wheather to use existing or new Azure SQL database to store Activity Log data. Finally, just hit Run, in a few minutes, the pipeline get set up, and downloads a Power BI Desktop file that comes with pre-defined reports.

As soon as, it spun up, the streaming pipeline awaits new activities, and almost immediately, the data appear inside Power BI reports. The team suggests to start with a historical analysis on last 90 days of Activity Log data, letting an Azure SQL Database accumulate these historical events in addition to incoming events.

Behind the scenes, the following three Azure Services are spins up by the template:

  • An 'Event Hub' that streams the Activity Log events in near real-time to Stream Analytics
  • A 'Stream Analytics' job that processes the Activity Log events in near real-time and inserts the data into SQL
  • An Azure SQL database which comes with a pre-defined schema for your Activity Log data, the team writes.
Power BI Desktop Matrix Report
Matrix reporting

Power BI Desktop August release now introducing "What if" feature, which was previewed in the Data Insights Summit keynote in June. Also added in this release are features for table and matrix visual, including a formatting option to show values on rows of matrix.

Additionally, several new analytics features such as symmetry shading and ratio lines for scatter charts also made in to this release.

Here's the complete list of updates:

Reporting

  • Show values on rows for matrix
  • Color scales on font colors for table & matrix
  • Custom subtotal settings per level of matrix
  • Line styles and legend options
  • Scatter chart performance improvements
  • New custom visuals
  • Dot Plot by MAQ Software
  • Power KPI
  • Funnel plot
  • Beyondsoft Calendar

Analytics

  • What if parameters
  • New scatter chart analytics features
    • Symmetry shading
    • Ratio line
  • New quick measure: weighted average

    Data connectivity

    • Live connect to the Power BI service is generally available
    • Google BigQuery connector (beta)

    Get started by downloading the Power BI Desktop here. Watch this video for a summary of the major update of this release: