

Here we can easily identify the insights and explain it to our client. The dashboard is the place where we display all the charts in a single place. Select the category from the Sales table and the Cost price and Sale price from the Sale table.Select the Scatter chart from the Visualization chart.Scatter chart is the chart that is drawn between the two data points. Select the Total units sold from the Sales table.Select the Gauge chart from the visualization table.It means the sales have been reached to 85 per cent. Here the target value is 100 and we have reached to 85. The Guage chart is generally used to set the value as target and check hoe much value we finally reached. Select the category from the Sales table and the total units, Sale value and Cost value.Select the Area chart from the visualization table.Due to this chart, the decision is taken very quickly.

Here we have selected the Total units, Sales value, and the cost value. Here the area is filled with the colors between the two data points. The Area chart is the advanced version of the line chart.

From the below Figure we can conclude that Richard Carr is making the Highest sales. The Pie chart is generally in the form of the circle. The Pie chart is generally used to Buyer wise total units sold. Select the Category option and the Sale Price from the Sales table.Select the Waterfall chart from the Visualization chart.The Waterfall chart is used to see how the sale prices of the categories present in the market. Select the categories in the Sales table and the cost price and the sale price from the Sales table.Select the Clustered column chart from the visualization chart.From this, we come to the conclusion that at which quarter the units are sold more. Like this, we get for the entire quarters in a particular year. This chart is generally used to check per quarter in the entire units how many units are sold and how many are unsold. The Clustered column chart is also known as the vertical bar chart. This chart is quite opposite of the Clustered bar chart. Here from the above, we observe the bar chart showing which buyer made the highest purchase. Select the Buyers from the Buyers table and total units from the Sales table.Select the Bar chart from the visualization chart.These bar charts are horizontal bar charts that are used to represent the data. The chart contains Bars which easily represent how much sale is done. This chart is generally used to see the number of units sold. This chart is also called as the Horizontal Bar chart. The first visualization we will see is the Clustered Bar chart. Once the requisite dataset is selected, in the Navigator window, select the appropriate sheet from the Excel workbook, and then click on Load. Select the files from the location it is stored. In this case, it is Excel, so clicked on Excel as shown by the below screenshot.From the drop-down menu of Get Data, select the appropriate data source type.There are different ways to create a visualization, to load the dataset into Power BI Visualizations are used to effectively present your data. Hadoop, Data Science, Statistics & others
