Consume data with Power BI and how to build a simple dashboard

Power BI dashboard

A Power BI dashboard is a single page, often called a canvas, that uses visualizations to tell a story. Because it is limited to one page, a well-designed dashboard contains only the most important elements of that story.

Tiles are the visuals that appear on the dashboard. These tiles come from reports and are pinned to the dashboard. The dashboard’s visuals are derived from reports, and each report is based on a single data source. In fact, one way to think of a dashboard is as an entry point into the reports and data sets behind it. When you click on a visualization, you’ll be sent to the report (and data set) that was used to build it.

Dashboards are a wonderful way to monitor your business, look for answers, and to see your most important metrics at a glance. A dashboard’s visualizations can derive from one or more underlying data sets, as well as one or more underlying reports.

Loading the dataset in Power BI

Get Data -> Excel workbook->select file.

Now select the visualization according to your need

Here I am selecting pie chart to display Cost by customer id

for displaying select data from fields

Adding a Map to show State wise cost and Sales

Adding Bar Graph to show cost by city and state

Similarly add other Visuals to make a complete Dashboard