Consume data with Power BI and how to build a simple dashboard
In this post, I would be discussing about how we can create a simple dashboard in Power BI using the data that I had loaded in Power BI which is mentioned in my previous blog. Along with creating simple dashboard I will discuss about how we can create new data columns from the existing table columns we have.
Consume Data with Power BI
For generating dashboard and reports the dat is consumed from the SQL Server Management Studio. After consuming the data from sql server studio, we will start creating reports and dashboard according to our needs.
Creating Dashboard in Power BI
In this dashboard I will be creating various visualizations for different fields and it will be shown in the reports tab of Power BI. To start with I will be creating a visualization which shows the representation of quantity sold by product key and the product category. For creating this visualization I chose category, product_key, quantity from Product and Sales_Facts table respectively and choose the visualization from the visualization tab.
Next I have created a pie chart representation which is used to get the sales revenue representation for all the cities present. The chart represents the percentage sales revenue with total amount of revenue for individual cities. To create this visualization choose sales_revenue and city attributes from Sales_Facts and Store table.
With Power BI in the table section we can also create a new table using the data we already have. In the below figure I have created a Profit column from the actual_sale_price and original_sales_price of the Sales_Facts table.
The various visualizations that are created using this newly generated column values and previous attributes are shown below.
The profit for particular city and brand can also be viewed using the Stack bar chart visualization.
