# Data warehouse analytics dashboards question

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/5086/data-warehouse-analytics-dashboards
Source observed: 2026-11-05T00:19:16.877Z
Last checked: 2026-11-05T00:19:16.877+00:00
Indexed: 2026-11-06T22:50:39.108+00:00

---

# Create geographic and demographic dashboards for weekly, monthly, and yearly analytics

We provide interview-preparation resources through Aced, formerly Exponent. This question is a data-modeling interview prompt associated with the **Data Engineer** role, **Amazon**, and the **Data Modeling** category.

## Question

Create geographic and demographic dashboards for weekly, monthly, and yearly analytics using:

- `FCT_ORDER_ITEM(product_id, customer_id, view_day, item_price, quantity, page_view_id, is_ordered)`, containing **100M records per day for 5 years**.
- `DIM_CUSTOMER(customer_id, address, age)`, containing **1B rows**.

The prompt concerns designing analytics around order and customer data, including geographic and demographic reporting at weekly, monthly, and yearly grain.

## Interview details

- Role: [Data Engineer](https://www.aced.io/questions?role=data-engineer)
- Company: [Amazon](https://www.aced.io/questions?company=amazon)
- Category: [Data Modeling](https://www.aced.io/questions?type=data-modeling)
- Reported last asked: **2 years ago**
- Saved by: **4**

## Answers and access

No community answers have been contributed yet. To submit an answer, [log in or sign up](https://www.aced.io/signup?src=nav&returnPath=/questions/5086/data-warehouse-analytics-dashboards). Submitting an answer marks the question complete. Detailed company statistics for this question require an [upgrade](https://www.aced.io/upgrade?src=questions).

## Related courses

### [Data Engineering Interview Prep](https://www.aced.io/courses/data-engineering)

![Data Engineering Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/5XoOCgXlGqN2fa1zaroNWd/9a2e23df48a212bc00d352873feb2d6a/Data_Engineer_Interview_Prep_Hero_Image.jpg?w=800&h=800&fm=webp&q=75)

We help candidates prepare for data engineering roles at Meta, Google, Amazon, Microsoft, Walmart, DoorDash, and other top companies. The course includes mock interviews, frameworks, advice from senior candidates, data modeling, pipeline design, SQL, coding, and behavioral interview practice.

### [Behavioral Interviews: A Practical Guide for Engineers](https://www.aced.io/courses/eng-behavioral)

![Behavioral Interviews: A Practical Guide for Engineers](https://images.ctfassets.net/x78yjrjc11pq/47qcoHjzFZXE37GoacedkB/9d8e3f4910d8b06b21e76745cd9cbff3/AdobeStock_1142146335.jpeg?w=800&h=800&fm=webp&q=75)

We help engineers prepare for senior-plus behavioral interviews at FAANG and Tier-1 companies. The course was made with staff and principal engineers from Meta, Netflix, Google, and more, and covers avoiding down-leveling, presenting past projects effectively, and communicating naturally.

## Browse Aced

- [All questions](https://www.aced.io/questions)
- [Data Engineering courses](https://www.aced.io/courses/data-engineering)
- [Practice](https://www.aced.io/practice?src=nav)
- [Coaching](https://www.aced.io/coaching?src=nav)
- [Pricing](https://www.aced.io/upgrade?src=nav)
- [Log in](https://www.aced.io/login?src=nav)
- [Sign up](https://www.aced.io/signup?src=nav)

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F5086%2Fdata-warehouse-analytics-dashboards&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F5086%2Fdata-warehouse-analytics-dashboards). Opening a form does not execute a tool.