Shared by 
Unlock all 7 pages
Get it free by sharing your own notes, buy just this one, or become a member and unlock documents with your plan.
How to unlock this document
Choose the way that suits you. Each one gives you all 7 pages to read online and the PDF to download.
Share your notes, unlock for free
2 free unlocks for every 5 approved uploads
- Upload your own lecture notes, assignments, essays or past papers
- PDF, Word, PowerPoint and Excel files all work, and you can send many at once
- We check each upload; you get a notification when it is approved
- Spend a free unlock on this document or any other, and keep it for good
- Shared under your public username, never your email
Then upload your notes from your profile.
Buy this document
$7 one-time payment
- All 7 pages of this document, yours to keep
- Download the PDF and read it any time, also offline
- No subscription and nothing to cancel
- Find it again any time under My Profile → Library
You log in or create a free account first, then pay securely.
Become a member
Unlock documents from the whole library, which keeps growing
- Choose any documents you like, up to your plan’s unlocks
- Documents you unlock stay yours, even if you cancel later
- Your unlocks start again with every renewal
- Secure checkout by Dodo Payments
You log in or create a free account first, then pay securely.
Compare the plansAlready a member, or bought this before? Log in to open it
About this document
- Pages
- 7 pages
- Price
- $7 one-time, yours to keep
- Membership
- Included in every plan
- Format
- Subject
- Business, Computer Science, Information Systems
This case study describes how L.L. Bean used a business intelligence data warehouse to improve its distribution processes. It explains the business situation, the solution implemented, and the benefits achieved.
What's inside
- Business situation at L.L. Bean
- Solution implemented with SQL Server 2000
- Benefits of the business intelligence data warehouse
- Details of the Stock Planning System
- Overview of L.L. Bean's Order Fulfillment Center
- Challenges faced in order processing
Who it is for: Students of Business, Information Systems, or Computer Science studying case studies. (Undergraduate)
Share with classmates: WhatsApp Telegram X LinkedIn Facebook
Summary
L.L. Bean's business intelligence data warehouse helps manage distribution costs. Students learn how a large retailer uses data to improve order picking and stock planning.
L.L. Bean's Business
L.L. Bean is a large outdoor clothing retailer. It sells through catalogues, websites and retail stores. It ships half a million items a day from its Order Fulfillment Center.
The Problem
L.L. Bean needed to improve how it planned stock and picked orders. Its staff had to walk around the warehouse to guess how much space was free.
The Solution
L.L. Bean built a business intelligence data warehouse. It used Microsoft SQL Server 2000 and Analysis Services to create multidimensional cubes. These cubes support drill-down reporting and key performance indicator dashboards.
The Benefits
The data warehouse gave L.L. Bean a better view of its business. It saved time and money in order picking. It improved customer service and planning.
Key terms
- Business Intelligence
- BI is the use of data to make better business decisions.
- Data Warehouse
- A data warehouse is a central place where data is stored and managed.
- Multidimensional Cubes
- Multidimensional cubes are data structures that allow data to be viewed from different angles.
- Key Performance Indicators
- KPIs are measures of how well a business is doing.
- Order Fulfillment Center
- An OFC is a warehouse where orders are picked and packed.
- Stock Keeping Unit
- A SKU is a unique code for each product.
Questions this document helps with
- How can a data warehouse help a retailer?
- What are the benefits of using multidimensional cubes?
- How does L.L. Bean use key performance indicators?
Summary written with AI from the document's text.
Ask the AI Teacher
Ask any question about this document or your course, and get a clear explanation.
Log in to ask Create a free account
Free accounts can ask 5 questions a day.