Ask me Live!!

Showcase : Power BI –SQL Server Info Dashboard in Dashboard for Life Series

November 20, 2016 2 comments

Hi Friends,

Global Power BI User group will be starting big series of showcasing all ‘Power BI Hero’ with different episodes of Dashboard data stories, exclusively series with name “Dashboard for Life Series ”

I am excited to announce my giveaway to community and encouragement to DBA to use Power BI in terms “SQL Server Information Dashboard” specifically for “Dashboard for Life Series ” of Global Power BI User Group.

This dashboard will give you at a glance information relate to your SQL Server server instance, Dashboard have 4 sheet for analyze various data point of sql server.

In this blog post we will be covering following various aspects of “SQL Server Info Dashboards”

  • What is this series about ?
  • Play with live Dashboard
  • Dashboard look and Feel
  • Dashboard Data Source
  • Dashboard Data Model
  • Dashboard Summary – KPI and Data
  • Few “Wh” question regarding dashboard
  • Dashboard presentation for “Dashboard for Life Series”
  • How to get this Dashboard on your machine

What is this series about ?

See this video to know about this series !

Play with live Dashboard

 

https://app.powerbi.com/view?r=eyJrIjoiODM3ZDAwZDItNDE1Zi00NGRhLWE5NTAtMGMzODRjZDZjMjMxIiwidCI6ImMyNmNlMTk0LWI4NDAtNGZjYy04YTY4LTAyYTM0MDc1NTNlMyIsImMiOjF9

Dashboard look and Feel

Overview of SQL Server info

image

Database Info

2016-11-17 00_30_46-Greenshot

Server configuration info

2016-11-17 00_31_06-Greenshot

Who2 dashboard

2016-11-19 23_10_58-Vishal PBIDB Dashboard 11 16 2016 - Power BI Desktop

Dashboard Data Source

Following various query used in Dashboard, Lets go one by one

  • ServerInfo
  • ServerSpace
  • Database
  • DatabaseLastBackup
  • DatabaseMasterFile
  • CurrentProcess To know more about queries used for dashboard please see my latest post on SQL Mentalist –

Dashboard Data Model

Name is key , Which is nothing but Database name.

dATA mODEL

Dashboard Summary – KPI and Data

Summary

  • ALL SQL Server Information
  • Drive Info
  • Hardware info
  • Instance Information
  • SQL Server Start time
  • SQL Server Configuration Details

KPI

  • CPU Usage
  • Memory Usage
  • Disk Free Vs Total Space

Few “Wh” question regarding dashboard

  • Who -DB Admin and DB Devs
  • Where – This dashboard can use in real-time development and administration for any SQL Server information
  • When – On demand when you need to see all SQL server info at run time
  • Which – Is key column in table for Data modeling – name(Database name)
  • How – Dashboard has SQL Server Instance As Parameter

Dashboard presentation for “Dashboard for Life Series”

Click here to see slides related to this dashboard

Community Data Stories page

Click here to see community data stories page !

How to get this Dashboard on your machine

As I have made this dashboard specifically for “Dashboard for Life Series ” through Global Power BI User group, You need to sing up to get download info Smile with tongue out, I know this is another marketing stunt, But believe me this is how we will be in touch too for any update on this dashboard.

So without wasting moment please sign up for global Power BI here !

%d bloggers like this: