Business Database Management
Business QuestionQ1:Create a pivot table shows Items, Unit sold, unit cost, unit priceShows on dollar currency and a line chart.Q2:Create a pivot table shows the top 10 countries on the total costColumn/Bar chart for the tableCreate a pivot table shows the top 10 cities of USA on the total costColumn/Bar chart for the tableCreate two slicers of year for two table or a single slicer for bothQ3:Find the value of Total Profit and create a table that shows all products total revenue, total cost and total profit.Create a pivot table shows the percentage of profit each year.Pie chart for the table with labeled data.Show correlation between total revenue and total profit of items.Create Dashboard for all pivot charts.(For question 3c referring to 3b. 3a is only a pivot table, in 3d you create a pivot chart based on 3a table.only charts and slicers of all pivot tables will contain the dashboard.)
