AtlantaMDF2018

Demo material from my presentation on 11/12/18 For detailed instructions, please visit my blog at https://shabnamwatson.wordpress.com/2017/11/23/build-a-performance-monitoring-tool-for-ssas-using-power-bi/ You can build the model directly in PowerBI vs. in SSAS Tabular which is the approach I took in the blog post. I will write another blog post that will show the new approach.

Name		Name	Last commit message	Last commit date
Latest commit History 4 Commits
00_Perfmon_Data.sql		00_Perfmon_Data.sql
01_Create_QueryEnd_XEvents.xmla		01_Create_QueryEnd_XEvents.xmla
01_Read_ALL_XEL_File.sql		01_Read_ALL_XEL_File.sql
01_Simple_DAX.msdax		01_Simple_DAX.msdax
02_BadPractice_DAX.msdax		02_BadPractice_DAX.msdax
02_Read_From_XEvent_XEL_Files.sql		02_Read_From_XEvent_XEL_Files.sql
02_Useful_DMVs.dmx		02_Useful_DMVs.dmx
03_Read_From_XEL_File.sql		03_Read_From_XEL_File.sql
04_Delete_Trace_XEvents.xmla		04_Delete_Trace_XEvents.xmla
04_Read_Queries.sql		04_Read_Queries.sql
05_Create_LinkServer.sql		05_Create_LinkServer.sql
06_LinkedServer_DMVs.sql		06_LinkedServer_DMVs.sql
Monitoring_SSAS_Tabular.pbix		Monitoring_SSAS_Tabular.pbix
PerformanceMonitoringSSASTabular_20180922.pdf		PerformanceMonitoringSSASTabular_20180922.pdf
README.md		README.md

Provide feedback