Operational systems feed data into the metrics data store and the dashboard retrieves performance data from it. If an operational system is replaced you could be hooped!įor these cases I recommend using a performance metrics data store. Tracking performance over the last 5 years is problematic when geographic boundaries are frequently changed or the business org chart gets shuffled. For longer term analysis, historic data can be lost when operational systems are reconfigured or replaced. Saturday, Decem1:34:54 PM - Alan Bardsleyīuilding a dashboard directly on operational data is fine if its timeframe is limited. To start with our dashboard, we go toĪ report in the service, hover with our mouse over a visual and click the pin icon. Sample objects at the bottom of this tip. Creating our first Power BI Dashboardīefore we start, we need to have some objects deployed to the Power BI serviceĪt least one report (with its dataset) and maybe an Excel workbook. There are no slicers or filters to click on. In Power BI a dashboard is not interactive: In Power BI however, a 'report' acts more like the dashboards we justĭescribed, while a 'dashboard' is something of an interactive table (using filters and slicers) on a single screen, not necessarily to be printed out. They are meant to be viewed and interacted with 'single glance' over your company's data and KPIs. They are pixel-perfect pages withĭifferent types of visualizations such as charts and tables, typically organized Visualization, reports and dashboards are sometimes used interchangeably.

It is necessary to make a distinction between reports and dashboards.

Power bi dashboard