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
Dashboard look and Feel
Overview of SQL Server info
Database Info
Server configuration info
Who2 dashboard
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.
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 
, 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 !
(B)usiness (I)ntelligence Mentalist 
Feel free to use ! You can even not mention my name ! Just spread Power BI voice !
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
Sure ! You will get even if you will not join ! 🙂 !
I’ve join to the FB group. how can I get this Dashboard