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
