Kudler Dimensional Model Hands-on-Project Essay

1527 Words Apr 18th, 2011 7 Pages
Kudler Dimensional Model Hands-On-Project Erwin Martinez DBM-460 March 14, 2011 Daniel McDonald Kudler Dimensional Model Hands-On-Project Kudler is looking for ways to increase sales and customer satisfaction. To achieve this goal Kudler will use data mining tools to predict future trends and behaviors to allow them to make proactive, knowledge-driven decisions. Kudler’s marketing director has access to information about all of its customers: their age, ethnicity, demographics, and shopping habits. The starting point will be a data warehouse containing a combination of internal data tracking all customers contact coupled with external market data …show more content…
3-4567 | lajolla@kudlers.com | S2 | Del Mar | Ocean ST | Del Mar | CA | 12653 | 715-456-3657 | delmar@kudlers.com | S3 | Encinitas | Second ST | Encinitas | | 12035 | 715-256-3214 | encinitas@kudlers.com | Products ProductID | Brand_Name | Product_Name | SKU | Sale_Price | Cost_Price | P1 | Clearwater | Crystal Geiser | | $1.50 | $0.75 | P2 | Wonder | Buttertop | | $1.48 | $0.60 | P3 | Bumble Bee | Tuna | | $0.75 | $0.25 | Sales Fact Table ProductID | CustomerID | StoreID | PromotionID | Time_ID | RegionID | Store_Sales | Store_Cost | P1 | C1 | S2 | Prom1 | T1 | R1 | $1.20 | $0.75 | P2 | C2

Related Documents