Group-Shopping Website Analysis

1. Group-Shopping Website Analysis Team Name: BIT Member: ZENG Yingpei (team leader) ZHANG Qiyuan CUI Xiaoning

2. Group Shopping • How group shopping works (Groupon’s pattern) • Group shopping in china • Fast growing & keen competition

3. Our Project • Analyze group shopping websites • Lashou, • and other 11 websites • Total revenue >¥ 300,000,000 • Grouping people> 6,000,000 • Business intelligence (BI) goals: • BI for 3 kinds of people: website owners, suppliers, investors

4. Technical Design Data Preparation Warehouse Design Project Design Dashboard Design

5. Data Preparation • Obtain raw data • 12 crawlers for 12 group-shopping websites • Fully automated • Process the raw data • Classify group deals into 24 subcategories • A classifier with 800+ keywords • Human scrutiny

6. Warehouse Design Website Fact Table Product Geography Time Generate lookup tables

7. Project Design 3 Facts (in use) 14 attributes 30+ metrics 4 user hierarchies

8. Dashboard Design • Three dashboards • Website dashboard • Provide information for the execution of a website • Supplier dashboard • Provide suggestions on launching a group deal • Investor dashboard • Provide information on selecting websites to invest

9. Team Work • Define ½ the subcategories and keywords • Define ½ the subcategories and keywords • Crawl raw group-deal data for 12 websites • Generate lookup and relationship tables for product and geography hierarchies • Design supplier dashboard • Design website dashboard • Design investor dashboard • Generate lookup and relationship tables for time hierarchy • Classified group deals with the keywords • Basic project design • Scan the classification of group deals • Project adjustment, design metrics Everyone’s work plan is discussed with team members Time

10. Dashboard Showcase Demo http://chn-vm-yzeng/microstrategy/asp/Main.aspx

11. Thanks!

13. Logic Table View

14. User Hierarchies