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 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
Server configuration info
Dashboard Data Source
Following various query used in Dashboard, Lets go one by one
- 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
- ALL SQL Server Information
- Drive Info
- Hardware info
- Instance Information
- SQL Server Start time
- SQL Server Configuration Details
- 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”
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 !