Management for an Ice Cream company is interested in improving the company's ice cream sales. The company has been collecting data about its sales—but not a lot. The available data is from an internal data source and is based on sales for 2019.
The Task is to review the data and provide some insight into the company’s ice cream sales. Ideally, management would like answers to the following questions:
1. What is the most popular flavor of ice cream?
2. How does temperature affect sales?
3. How do weekends and holidays affect sales?
4. How does profitability differ for new versus returning customers?
I'm going to use Power BI for this task because I think that it will allow me to generate an excellent report that answers all the questions for management, for each question, I will try to do a visualization then create a dashboard summary for all the questions at the end
What is the most popular flavor of ice cream?
How does temperature affect sales?
['2019-01-01',
'2019-01-21',
'2019-02-18',
'2019-05-27',
'2019-07-04',
'2019-09-02',
'2019-10-14',
'2019-11-11',
'2019-11-28',
'2019-12-25']
= Table.AddColumn(#"Inserted Day Name", "isHoldaywknd", each if List.Contains({#date(2019, 1, 1),#date(2019, 1, 21),#date(2019, 2, 18),#date(2019, 5, 27),#date(2019, 7, 4),#date(2019, 9, 2),#date(2019, 10, 14),#date(2019, 11, 11),#date(2019, 11, 28),#date(2019, 12, 25)}, [date]) then 1 else if List.Contains({"Saturday","Sunday"},[Day Name]) then 1 else 0)