> **#analytics-project** > > **Carmen Reyes** 9:14 AM > > Hey! Carmen here, I run the commercial side at Bona Lluna Cervesa -- we're a craft brewery outside Barcelona. 25 people, 12 beer styles, three sales channels that don't talk to each other. > > **Carmen Reyes** 9:15 AM > > So here's the deal: we have a taproom with a POS system, we distribute kegs to 45 bars and restaurants (invoiced through our accounting software), and we have a WooCommerce online shop for bottles and subscription boxes. > > **Carmen Reyes** 9:16 AM > > The problem is I get a different revenue number depending on which system I look at. My head brewer insists Pale Ale is our best seller. My sales manager says it's the IPA. They're probably both right in their own channel but I can't tell because nobody counts the same way. > > **Carmen Reyes** 9:17 AM > > What I want: one unified view. A dashboard I check Monday morning that tells me what sold last week, by channel, by beer style, with trends. I want filters so I can drill into things. And I want my sales manager to be able to use it without asking me questions. > > **Carmen Reyes** 9:18 AM > > I'm attaching three data exports: > - `taproom_pos.csv` -- 12 months of taproom transactions (date, product, quantity, amount, payment type) > - `distribution_invoices.csv` -- 12 months of wholesale invoices (invoice_date, client, products, quantities, amounts, payment_status) > - `online_orders.csv` -- 12 months from WooCommerce (order_date, product_name, sku, quantity, price, shipping, discount, country) > > Plus our `product_catalog.csv` with standard names, category, and production cost per liter. > > **Carmen Reyes** 9:19 AM > > Fair warning: the product names are a mess across the three systems. "Bona Lluna IPA 330ml" on the website is "IPA" in the POS and "BL IPA x24" in distribution. Sorry > > Let me know how you'd approach this and what you need from me! **Suggested message buttons:** 1. "Hi Carmen! I'll start by profiling each data source separately to understand what we're working with. A few quick questions before I dive in." 2. "Thanks for the data exports. I'm going to map the product names across all three systems first -- that seems like the foundation for everything else." 3. "Got it -- three sources, one dashboard. I'll send you a plan for how I'll approach this before I start building."