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

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 ?
  • Download Dashboard
  • 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 !

Download Dashboard

Download SQL Server Power BI Dasboard Template from Microsoft Galary – http://bit.do/sqldash

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 !

4 thoughts on “Showcase : Power BI –SQL Server Info Dashboard in Dashboard for Life Series

Add yours

  1. HI Vishal,

    Thanks for sharing the dashboard. Are you ok for me to use your dahboard and change the content a bit to suite our client needs? I shall ensure to pass the credits/references to your company.

    regards
    Kishore

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: