SCCM Dashboard for Power BI

​Visualize Your Environment Anytime - Anywhere

SCCM remotely manages operating systems, software distribution and network security. However, this tool lacks rich reporting and dashboards that provide insights into the things that matter the most to you. The SCCM Dashboard Solution Template offers intuitive visualizations that give you an on-demand snapshot of your environment wherever you are.

Within Power BI information is collected daily so you can see your organization’s computing health and see how key metrics change over time. Quickly identify machines requiring critical software updates. Be notified of successful and failed mitigations to malware infections. All this from the interactive data visualization tools embedded within Power BI.​


Marquam’s three step solution deployment process for Power BI:

 

Behind the scenes, Marquam will spin up an ETL pipeline to incrementally pull data out of your Configuration Manager database and push the data into an optimized SQL database. All we need is read access to Configuration Manager database, an Azure SQL (preferred) or an on-premise SQL Server instance and a Power BI Pro subscription. Specific actions are listed below.

  • Assist with establishing Azure and O365 Tenants
  • Assist with network connectivity to Azure tenant
  • Build and configure Azure VM to host ETL process
  • Build and configure Azure SQL Database for SCCM data mart
  • Schedule ETL process
  • Publish Power BI Reports
  • Build Power BI Dashboard
  • Enhance Power BI Model / Reports as required
​​
Would you like to see the deployment status of operating systems or identify machines with 3rd party license agreements? The SCCM Dashboard can help and we are here to help you.
Contact Us for a Free C​onsultation.​