Questions for Practical Case Study and Reporting Template

Questions for Practical Case Study and Reporting Template

Question:	1. What is the maximum longitude? It belongs to which state? (1 marks)
Answer:	Maximum longitude is 43.5 and this longitude belongs to the city “Of New York State”.
Screenshot:
Explanation:
To identify the maximum longitude, select the longitude entity and set its measure as “max”. To find out the, make a bar graph between states and longitude and set longitude measure as “max value”.

Question:	2. How much is the total gross margin for each state in 2017? (1 marks)
Answer:	The maximum gross margin in California is 13,439 and the minimum gross margin is 11.9 in Ohio.
Screenshot:
Explanation:
The above image shows the total gross margin value for each state for the year 2017. To evaluate this, select entities “gross margin value and state and date”. Set the date as only 2017 and gross margin values as “sum”. The above table shows the total gross margin value for each state. For example, for states Alabama: 163517, Alaska: 442, and so on.

Question:	3. How much is the maximum discount and by which store? (1 mark)
Answer:	The maximum discount is 0.65% and this is by ST897.
Screenshot:
Explanation:
To identify the maximum discount for different stores, select the discount percentage and set its measure as the maximum value. To identify the store name for maximum discount, make a chart between store ID and maximum discount percentage. The maximum discount is 0.65 and it is from the ST897 store.

Question:	4. Which city has the maximum sales price in 2017? How much? (1 mark)
Answer:	CT399 city has a maximum sales price 17,562.32 in the year 2017
Screenshot:
Explanation:
To evaluate maximum sales price by city, select the entities "Date," "Sale Price," and "City" from the dataset. Filter the data for the year 2017. Then, create an area chart to visualize the maximum sales price and its corresponding city for a clear comparison. The maximum sales price is 17562.32 for CT399.

Question:	5. The city in Question 4, which product did they sell the highest sales price in 2017? (1 mark)
Answer:	Product PDS77 had the highest sales price in 2017.
Screenshot:
Explanation:
The city name in question 4 is CT399. To evaluate the highest sale product in CT399, select entities “Date, city, sales price and product”. Filter date as 2017, city as CT399. The highest sales price is 17.6K rounded off for product PDS77.

Question:	6. For the product in Question 4, which year has the highest original sales price? (1 marks)
Answer:	2018
Screenshot:
Explanation:
The product In question 5 is PDS77. For Product PDS77, the highest original sale price was 20,624.37 in 2018. To evaluate this, make a chart between the date, original sales price and product. Filter product as only PDS77 (MiguelMyersMS, 2024).

Question:	7. Which product category had the highest fixed price in 2016? How much was it in total? (1 marks)
Answer:	The household category has the highest price in 2016 and that is about 7.12k.
Screenshot:
Explanation:
To answer this question, make a chart for product category, fixed price and Date, filter date as 2016. According to the above pie chart, it can be easily seen that the Household category had the highest fixed price in 2016 and that is about 7K.

Question:	8. Which month had the lowest gross margin and in which year? (1 marks)
Answer:	In January 2017
Screenshot:
Explanation:
To find out the month and year for the lowest gross margin value, make a simple line chart between the date and gross margin value. Set the Date as only month and year, remove quarter and day. According to the above line chart, the lowest gross margin was approx 5k In Jan 2017.

Question:	9. In the year with the lowest Gross Profit which product had the lowest profit and how much is that? (1 marks)
Answer:	PDS51
	320.71
Screenshot:
Explanation:
According to the above line graph in question 8, it is found that the least gross margin year is 2017. Now to find out the lowest gross margin profit value product in 2017, make a chart between the product and gross margin and date. Filter Date as only 2017, add data labels for more accuracy. The lowest gross margin value is 320.71 for the product “PDS51 (mberdugo, 2023).

Question:	10. In the year with the highest Gross profit which product had the highest profit and how much is that? (1 marks)
Answer:	PDS75
	98K
Screenshot:
Explanation:
First, evaluate the year with the highest gross profit using a pie chart comparing "Date" and "Gross Profit," identifying 2016 as the top year. Then, analyze the relationship between "Gross Profit" and "Product" for 2016. A bar graph shows that the highest profit, 98K, is from the product "PDS75."

DASHBOARDS

First:

This available dashboard provides a cursory view of how it is selling based on categories and periods. This can be explained by the ‘The Sum of Quantity Sold by Category’ which depicts that the Household category ranks with the highest score of 0. 47M units sold were followed by Apparel which sold 0. and only 38M originated from the Grocery and Camping segments of a total sale of goods. The Sum of the Original Sales Price and Sales Revenue pie chart shows that effective selling has been done in this segment and the revenue comprises 57%. This means that even if one disregards the discounting strategies, sales strategies for fixed assets turned out to be greatly successful and they formed 81% of the overall sales. 2. 81M. In the ‘Discount by Category’ doughnut chart which displays the sum of discounts, it is seen that the Apparel has a maximum discount of 55. 23 percent of the total amount while Households spent 43 percent. 69 and the remaining mins discounts in Grocery and Camping. When it comes to the Sum of Sales Revenue by Product Description there is a clear show that Nails is way above all the other products with 0. Males’ engagement was also highest for Stubble (76M), while engagement for females, was highest for Boots (0. 47M) and Gloves (0. 42M). From the above data if we go for the Sum of Sales Revenue by Year arguments then we can easily understand that the sales were high in 2016 at 969. 24k while the year, 2018 recorded 2018, 2017 had a drop of 426. 82K.

Second

This second type of dashboard provides a detailed gross profit of the regional sales, stores, revenues by products and categories, and discounts to know areas that perform well (mihart, 2023). The bar chart of the Sum of Gross Profit by State and Year exposed the result as follows: This chart pointed out that Arkansas was 13K in 2017, second to Alaska and Illinois and some states had no business Gross Profit at all. The Sum of Sales Revenue by Store ID reveals that the store with the highest sum of sales revenue is Store ST98 with a total sum of around $ 60, 000 while the other stores have a lot less sum of sales revenue. From the table titled: The Gross Profit by Product Description Tab it is viewed that Nails the highest value is 0. 2M Thus it can be seen that items like Boots, Gloves are the major gross contributors for this company while Water, Tarp, etc are minor gross contributors. Therefore, from the pie chart of the Sum of Sales Revenue by Region, we can see that the South Region has a total of $648. Mid-West in revenues amounted to 4,000 thousand,000 or four thousand in thousand, hundred and 0 in thousand. The Gross Profit Summary by Category shows that out of all the categories, Household has the highest Gross Profit at ($32683) On the treemap of discounts, PDS75 & PDS54 had the highest discount. The following dashboard aims to provide an insightful way of presenting the realistic gross profit, sales revenue, as well as the performance of various products over time. It has some attributes like the number of sales at the initial price, relative to the business’s month and year performance, and the business’s performance based on categories that offer a holistic view of how the business is performing.

Third

The third dashboard provides a summation of the original sales price by year and product identification number: It can be observed that the price of Product PDS77 was hiked in the year 2017 and 2018 and those are the years the firm has recorded decent sales. Below is the Gross Profit that has been arranged by the Product ID: The analysis reveals that the most lucrative product line in the entire RIM business is the PDS75, which recorded a gross profit of $0. Seven point two one M, PDS 56 and PDS 54 were found to have 0. 13M and 0. 10M, respectively. One more similar chart is The Sum of Gross Profit by Year and Month where it is seen that the year 2016 has the highest peak of the gross profit and that the gross profits are relatively higher in the next two years of 2017 and 2018. The Count of Order ID by Region and Category treemap depicted high order of Household category in the South and the Midwest. Last of all, the calculation of the gross profit sum by Product Description reveals Nails as the most profitable product type; while households emerge as the most profitable category. The sum of Original Sales Price by Year and Product ID: This bar chart shows the original sales price by year of the product PDS77. In 2016, the sales price hardly had any value, however, this grew to a substantial value in 2017 and 2018. Each column represents the growth and through the bar for 2018, it can be seen that sales were high. The sum of Gross Profit by Product ID: This bar chart shows the Gross Profit of various products which was measured in thousands of US dollars. PDS75 leads with 0. 18M while PDS56 contributes 0. 13M and 0. 10M, respectively. Other products depict lower gross profits which make a minimal contribution. Count of Order IDs by Region and Category: This treemap shows the distribution of the count of Order IDs by region and category (maggiesMSFT, 2023). In South and Mid Western regions, the orders placed are mostly through households while in the Western region, most orders placed are through Apparel orders. Across other regions such as the Atlantic and New England, the shop’s different categories present different results.

Reference

?maggiesMSFT (2023). Intro to dashboards for Power BI designers - Power BI. [online] Microsoft.com. Available at: https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboards [Accessed 19 Sep. 2024].

?mberdugo (2023). Examples of Power BI visuals - Power BI. [online] Microsoft.com. Available at: https://learn.microsoft.com/en-us/power-bi/developer/visuals/samples [Accessed 19 Sep. 2024].

MiguelMyersMS (2024). Visualization types in Power BI - Power BI. [online] Microsoft.com. Available at: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a#bar-and-column-charts [Accessed 19 Sep. 2024].

?mihart (2023). Dashboards for business users of the Power BI service - Power BI. [online] Microsoft.com. Available at: https://learn.microsoft.com/en-us/power-bi/consumer/end-user-dashboards [Accessed 19 Sep. 2024].

?