Unit 5 · Session 4
Business Value and BI
IT 231: IT and Application (BBM)
Learning Objectives
By the end of this session, you will be able to:
- ✅ Describe the main business-level advantages of using a database.
- ✅ Explain how a database improves decision making.
- ✅ Describe how a database enhances customer service and operational efficiency.
Beyond the Technical
Adopting a database isn't just an IT upgrade. It's a fundamental business decision.
The real power of a database lies in how it transforms business performance and creates a competitive edge.
Let's explore the four key business advantages.
1. Improved Decision Making 🎯
Databases provide a centralized, integrated, and up-to-date source of data.
- Empowers Managers: Access to a complete view of the business.
- Faster Insights: Identify trends and spot problems earlier.
- Data-Driven Strategy: Allocate resources more effectively based on real data, not guesswork.
From Data Chaos to Clarity
🐢 Without a Database
- Data in separate files (silos)
- Inconsistent & outdated info
- Slow, manual report generation
- Decisions based on gut feeling
🚀 With a Database
- Centralized, integrated data
- Consistent & real-time info
- Instant access to dashboards
- Informed, data-driven decisions
2. Enhanced Customer Service
A database provides a complete 360-degree view of every customer.
The "Single Source of Truth"
This means any employee can access a customer's complete history—past purchases, support tickets, and contact info—from one place.
- Faster, more efficient support.
- More personalized interactions.
- Increased customer satisfaction and loyalty.
Example: Customer Call
Scenario: A customer calls to check on their order status.
Without Database:
"Let me check with the sales team... now let me check with the warehouse... can you hold please?"
With Database:
"I see your order #1234 for a new laptop. It shipped this morning and is scheduled for delivery tomorrow. Is there anything else I can help with?"
3. Increased Operational Efficiency ⚡
Databases tackle the core problems of old file-based systems.
- Problem: Data Redundancy
The same data (e.g., a customer's address) is stored in multiple places.
- Problem: Data Inconsistency
Updating the address in one file but not another leads to conflicts.
Solution: A database stores data in one place, eliminating redundancy and ensuring consistency. This reduces errors and saves time.
4. Foundation for Business Intelligence 📊
Databases are the bedrock for understanding your business on a deeper level.
Business Intelligence (BI): The process of analyzing an organization's raw data to get actionable insights and make better strategic decisions.
Databases store the historical data needed for:
- Reporting & Dashboards
- Data Analysis
- Predictive Modeling (e.g., forecasting sales)
Real-World Application in Nepal
🛒 E-commerce (e.g., Daraz)
A central database helps manage:
- Inventory: Real-time stock levels across thousands of sellers.
- Orders: Tracking an order from placement to delivery.
- Customers: Recommending products based on past purchases.
💳 Digital Wallets (e.g., eSewa, Khalti)
A database is critical for:
- Transactions: Securely logging millions of daily payments.
- User Data: Providing a single, secure view of a user's balance and history.
- Efficiency: Ensuring instant and reliable fund transfers.
Key Takeaways 🔍
- Databases provide a "single source of truth" that leads to tangible business benefits.
- They empower better, data-driven decision making by providing a complete view of the business.
- A centralized customer view leads to superior customer service and personalization.
- They increase operational efficiency by reducing data redundancy and inconsistency.
- Databases are the essential foundation for all Business Intelligence activities.
Exam Practice: Short Answer
- What is meant by a “single source of truth”?
- List any four business-level advantages of using a database.
- Mention two costs or risks of adopting a database.
Exam Practice: Long Answer
- Explain the business-level advantages of using databases with examples.
- A retail chain in Nepal still uses separate spreadsheets in each branch. Advise management on the benefits of moving to a central database.
Revise the chapter note before writing these answers.
Thank You!
Any questions?
Learning Objectives 🎯
By the end of this chapter, you will be able to:
- ✅ Define Business Intelligence (BI).
- ✅ Describe the purpose of BI.
- ✅ Identify the key technologies used in BI.
What is Business Intelligence (BI)?
Business Intelligence (BI) is a technology-driven process for analyzing data and presenting actionable information to help executives, managers, and other corporate end-users make informed business decisions.
In simple terms: BI turns raw data into useful insights. ⚡
The Core Purpose of BI
BI exists to support better business decision-making.
The goal is not just to collect data, but to understand it and use it to drive strategy and performance.
It helps answer questions like:
- What were our sales last quarter?
- Which products are most profitable?
- How can we improve operational efficiency?
The BI Process: From Data to Decisions
📊 Raw Data
(Sales figures, customer records, web traffic)
⬇️
⚙️ BI System
(Collection, Integration, Analysis)
⬇️
💡 Actionable Information
(Reports, Dashboards, Visualizations)
Raw Data vs. Actionable Information
Raw Data बिखरा डेटा
- Unorganized facts and figures.
- Example: A list of 10,000 individual sales transactions.
- Difficult to understand context or trends.
Actionable Information ⚡
- Organized, analyzed data.
- Example: A chart showing "Total Sales per Region for Q3".
- Provides clear insights to make decisions.
Key BI Technologies 🔍
A successful BI system relies on several core components working together:
- Data Warehouses: The foundation for storing data.
- ETL Processes: The "plumbing" that moves data.
- Reporting & Querying Tools: For asking questions.
- Data Visualization & Dashboards: For understanding the answers.
Component 1: Data Warehouse
A Data Warehouse is a central repository of integrated data from one or more disparate sources.
- Stores clean, consolidated, and historical data.
- Designed specifically for querying and analysis.
- It's the single source of truth for an organization's data.
Think of it as a highly organized library for all your business data.
Component 2: ETL Process
Extract, Transform, Load
1. Extract
Pulling data from various sources (databases, CRM, files).
2. Transform
Cleaning, standardizing, and structuring the data.
3. Load
Loading the transformed data into the data warehouse.
ETL is the critical background process that ensures the data in the warehouse is reliable and ready for analysis.
Component 3 & 4: Analysis and Visualization
Reporting & Querying
- Allows users to ask specific questions of the data (e.g., using SQL).
- Generates static reports (PDFs, spreadsheets).
- Answers "What happened?"
Data Visualization & Dashboards
- Tools like Tableau & Power BI.
- Creates interactive charts, graphs, and maps.
- Helps users explore data visually and answer "Why did it happen?"
Practical Application: BI in Nepal
Scenario: A Nepali Telecom Company 🇳🇵
A company like Ncell or Nepal Telecom collects massive amounts of data:
- Call records, data usage, recharge card purchases, customer location.
How can they use BI?
- Marketing: A dashboard shows that data usage in Pokhara peaks between 8-10 PM. They can create a targeted "Night Data Pack" for that region.
- Network Ops: A report identifies areas with frequent call drops, helping engineers prioritize tower maintenance and upgrades.
Summary & Key Takeaways
- 🎯 BI is the process of turning raw data into actionable insights to support better business decisions.
- ⚙️ It transforms messy, raw data into clean, understandable information like reports and dashboards.
- 🏗️ Key components include a Data Warehouse for storage and Visualization Tools (like Power BI) for presentation.
- ⚡ The ultimate goal of BI is to improve business performance by making data-driven choices.
Exam Practice: Short Answer
- Define Business Intelligence. Name two BI tools.
- What is ETL? Why is it needed?
- What is a KPI? Give two examples for a retail business.
Exam Practice: Long Answer
- Explain the components and process of a BI system with a suitable diagram.
- How can Business Intelligence help a Nepali bank or retail chain make better decisions? Discuss its benefits and challenges.
Revise the chapter note before writing these answers.
📖 Read first (chapter notes)