FDD
berli
Data_Source_Details_Last_Pageof_YourData_Brief1.docxData Source Details (for Final Draft of Your Data Brief)
Use this as an example and type your own text
Data Source Name: Avocado Sales
Total # of records (rows): 18,250
Dimensions you plan to use:
Date, Region, State, City, Product Type
Metrics you plan to use:
Average Price, Total Units, Total Bags
Dashboard
1-sentence summary of what your dashboard will contain:
Sales distribution of Hass avocados across the US
List at least 5 different data elements that will be in your dashboard (charts, tables, etc.)
1. Table: KPI Summary - Volume and sales by region with YoY % differences
2. Chart: Line chart showing avocado sales over time (summarized for US)
3. Chart: line chart showing average price per unit over time (lines for each year)
4. Chart: bar chart showing the % of total avocado sales per region
5. List: Top 5 cities for avocado purchases and the total amount $ spent
6. Chart: column chart showing avocado sales by product description
Analysis Presentation
1-sentence summary of what your analysis will focus on:
Analysis of avocado consumption by region, state, and city to determine differences in demand and pricing.
List the specific questions you will ask/answer with your analysis:
· Compare avocado consumption across regions
· What is the trend over time for price and consumption qty?
· Is there a relationship between price and consumption?
· Do different regions favor specific product types?
