Developing Solutions for System Monitoring and Administration

In this chapter, we will cover the following recipes:

  • Creating a centralized IT monitoring solution with Power BI
  • Constructing a monitoring, visualization, and analysis layer
  • Importing and visualizing dynamic management view (DMV) data of SSAS and Power BI data models
  • Increasing the SQL Server DBA's productivity with Power BI
  • Providing documentation of Power BI and SSAS data models to BI and business teams
  • Analyzing performance monitor counters of the Microsoft on-premises data gateway and SSAS tabular databases
  • Analyzing Extended Events trace data with Power BI
  • Visualizing log file data from SQL Server agent jobs and Office 365 audit searches

Get Microsoft Power BI Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.