Deliverables:
- Data Visualizations for all questions, both Tableau and Power BI
- SQL queries and results for questions 1-17
Analytical requirements:
- Total sales $ via Invoice
- Total sales $ via Invoiceline
- Total tracks (songs) sold
- Total sales $ by customer’s country – ranked (sorted largest to smallest) a. In data viz: provide comparison b. In data viz: provide composition c. In data viz: show sales on map
- Total sales $ by customer’s geo (country, state & city) a. In data viz: need to drill down from country to city
- Total sales $ by customer (a person with last name & first name) – ranked (sorted largest to smallest)
- Total sales $ by company – ranked (sorted largest to smallest)
- Total sales $ by artist – ranked (sorted largest to smallest) a. In data diz: All artists with sales b. In data viz: Top 20 artists
- Total sales $ by album – ranked (sorted largest to smallest)
- Total sales $ by salesperson (employee) a. In data viz: provide comparison b. In data viz: provide composition
- Total sales $ by media type a. In data viz: provide comparison b. In data viz: provide composition
- Total sales $ by genre a. In data viz: provide comparison b. In data viz: provide composition
- What are the total sales $ by year
- What are the total sales $ by year-month a. In data viz: provide comparison over time
- What are the employees’ name, birthday, hirecate, years of working with company (assume as of 2013-12-31), address, city, state, country, title, manager and manager’s title
- What are the total sales $ by employee age at the time of the invoice date
- What are the total sales $ by employees who are in their 30s, 40s, 50s and 60s (employee age at the time of the invoice date)
- For the artist “Led Zeppelin” what are the: a. Total sales b. Sales by Country c. Sales by Customer d. Sales by Employee e. Sales by Album f. Sales by Artist g. Sales by Genre h. Sales by Media Type i. Sales Over Time
- For the genre “TV Shows” what are the: a. Total sales b. Sales by Country c. Sales by Customer d. Sales by Employee e. Sales by Album f. Sales by Artist g. Sales by Genre h. Sales by Media Type i. Sales Over Time
- For the employee “Peacock, Jane” what are the: a. Total sales b. Sales by Country c. Sales by Customer d. Sales by Employee e. Sales by Album f. Sales by Artist g. Sales by Genre h. Sales by Media Type i. Sales Over Time
- For the country “France” what are the: a. Total sales b. Sales by Country c. Sales by Customer d. Sales by Employee e. Sales by Album f. Sales by Artist g. Sales by Genre h. Sales by Media Type i. Sales Over Time