(Business Intelligence)
2 Marks (Que & Ans)
1. What is Business Intelligence?
Business Intelligence (BI) is a field in data management that uses expert systems with data extract, transform, load (ETL) tools, data warehousing, and predictive analytics to gather, process, analyze, and uncover useful information from large and complex data sets.
BI allows organizations to monitor, track, manage, and transform their data into actionable insights that can help them make informed business decisions. BI tools and techniques are used in various industries, including finance, healthcare, retail, manufacturing, and government. BI solutions help organizations to gain a competitive advantage, optimize operations, improve customer satisfaction, and reduce costs.
2. What is Business?
Business refers to organizations involved in the production, distribution, or sale of goods or services in order to generate profit. Businesses can take various forms, including small shops, large corporations, and everything in between. They can also be for-profit or non-profit entities. The activities of a business often include marketing, finance, accounting, operations, and management.
3. What is Business Enterprise?
A business enterprise refers to a formal, organized effort to conduct commercial activities to produce goods or services for profit. It can encompass a wide range of entities, from small entrepreneurial ventures to large multinational corporations. Business enterprises typically involve various functions such as production, marketing, sales, finance, and management, and they can operate in diverse industries and sectors. This term is generally used to emphasize the commercial and profit-oriented nature of the organization’s activities.
4. List out core business functions?
- Sales and Marketing
- Product/Service Delivery
- Quality
- Product Development
- Accounting
- Technology
- Human Resource Management
- Supplier Management
- Legal and Compliance
- Corporate Planning
- Procurement (Purchases)
5. Expand OLTP & OLAP?
- OLTP (Online Transaction Processing)
- OLAP (Online Analytical Processing)
6. What is Data Warehouse?
A data warehouse is a central repository that collects, stores, and provides access to a large amount of data for reporting, analysis, and decision-making. The primary purpose of a data warehouse is to organize and integrate data from multiple sources in a consistent and efficient way to support the business operations.
7. List information users and requirements.
Executives and Decision Makers
Operational Staff
Sales and Marketing Teams
Finance and Accounting Teams
IT and System Administrators
8. List the sources of Structured Data?
- Relational Databases
- Enterprise Resource Planning (ERP) Systems
- Customer Relationship Management (CRM) Systems
- Spreadsheets and Data Tables
- Data Warehouses
- Public and Syndicated Data
- Internet of Things (IoT) Devices
- Cloud-Based Applications
9. Define digital data and list the types of digital data?
Digital data refers to information that is stored, transmitted, or processed in the form of discrete elements represented using electronic or binary signals. It encompasses a wide range of content, including text, images, audio, video, and various other types of information that are encoded digitally.
Types of digital data:
1. Text Data
2. Numerical Data
3. Image Data
4. Audio Data
5. Video Data
6. Geographic Data
7. Time-Series Data
8. Metadata
9. Structured Data
10. Unstructured Data
10. Define Data Integration?
Data integration refers to the process of combining data from multiple sources, cleansing and transforming it, and storing it in a centralized repository. It involves several components, including data extraction, presentation, data cleansing, transformation, loading, and maintenance.
Data integration is an essential component of data warehousing and business intelligence systems. It enables organizations to access data from various sources, consolidate it into a single view, and analyze it to gain insights and drive decision-making.
11. What is Baldrige business excellence framework and mention the phases
The Baldrige Business Excellence Framework is a comprehensive set of criteria for improving organizational performance and achieving excellence in business operations. It is based on the Malcolm Baldrige National Quality Award, which is a prestigious U.S. award recognizing organizations that excel in quality and performance.
Phases:
- Leadership
- Strategy
- Customers
- Workforce
- Operations
- Measurement & Analysis.
- Knowledge Management
12. List the characteristics of Internet Ready IT applications.
1. Scalability
2. Security
3. Interoperability
4. Reliability
5. Flexibility
6. Accessibility
7. Performance
8. Compliance with standards
9. Integration capabilities
10. User-friendliness
13. Define digital data and list the types of digital data.
Digital data refers to any information that is encoded and stored in a digital format, typically in binary code (0s and 1s) that can be processed and transmitted by electronic devices.
Types of digital data include:
1. Textual data
2. Numeric data
3. Audio data
4. Image data
5. Video data
6. Metadata
7. Geospatial data
8. Time-stamped data
9. Transactional data
10. Structured and unstructured data
9. Define digital data and list the types of digital data?
Digital data refers to information that is stored, transmitted, or processed in the form of discrete elements represented using electronic or binary signals. It encompasses a wide range of content, including text, images, audio, video, and various other types of information that are encoded digitally.
Types of digital data:
1. Text Data
2. Numerical Data
3. Image Data
4. Audio Data
5. Video Data
6. Geographic Data
7. Time-Series Data
8. Metadata
9. Structured Data
10. Unstructured Data
10. Define Data Integration?
Data integration refers to the process of combining data from multiple sources, cleansing and transforming it, and storing it in a centralized repository. It involves several components, including data extraction, presentation, data cleansing, transformation, loading, and maintenance.
Data integration is an essential component of data warehousing and business intelligence systems. It enables organizations to access data from various sources, consolidate it into a single view, and analyze it to gain insights and drive decision-making.
5 & 10 Marks (Que & Ans)
1. Explain Baldrige business excellence framework.
The Baldrige Business Excellence Framework is a set of criteria and guidelines developed to help organizations achieve superior levels of performance and excellence in various aspects of business operations. It is based on the Malcolm Baldrige National Quality Award, a prestigious recognition bestowed upon organizations that exemplify exceptional quality and performance standards.
The framework is designed to encompass seven key categories, also known as Criteria for Performance Excellence.
- Leadership: Focuses on how senior leaders set organizational direction, establish values, manage change, and guide the organization towards success.
- Strategy: Emphasizes how organizations develop strategic objectives and action plans, allocate resources effectively, and drive innovation and improvement.
- Customers: Centers on understanding customer needs and expectations, building relationships, and delivering value to customers to ensure satisfaction and loyalty.
- Measurement, Analysis, and Knowledge Management: Stresses the importance of measurement, analysis, and knowledge management in making informed decisions, driving performance improvement, and achieving organizational goals.
- Workforce: Focuses on how organizations engage, develop, and support their workforce, fostering a high-performance culture and ensuring employee satisfaction and well-being.
- Operations: Examines how organizations design, manage, and improve key processes to deliver products and services efficiently, and effectively meet customer and stakeholder requirements.
- Results: Evaluates and assesses organizational performance in key areas such as customer satisfaction, financial performance, workforce engagement, and other key operational outcomes.
2. Explain Key purpose of using IT in business
The key purpose of using Information Technology (IT) in business is to enhance efficiency, productivity, and decision-making processes. IT plays a crucial role in modern organizations by providing the following key benefits:
- Automation: IT systems can automate repetitive tasks, reducing the need for manual intervention and freeing up employees to focus on more strategic activities.
- Data Management: IT enables the collection, storage, and analysis of large volumes of data, leading to better-informed decision-making and improved business insights.
- Communication and Collaboration: IT facilitates seamless communication and collaboration among employees, teams, and with external stakeholders, regardless of geographical locations.
- Customer Relationship Management: IT systems help businesses to effectively manage customer relationships, improve service delivery, and personalize customer experiences.
- Enhanced Productivity: IT tools and applications streamline workflows, leading to increased productivity and reduced operational costs.
- Competitive Advantage: IT can provide businesses with a competitive edge through innovation, process optimization, and the development of unique products or services.
- Strategic Decision Making: IT provides real-time access to critical information, enabling rapid and informed decision-making at all levels of the organization.
- Market Expansion: IT allows businesses to reach new markets, explore e-commerce opportunities, and expand their customer base on a global scale.
3. What is Business Enterprise?
A business enterprise refers to a formal, organized effort to conduct commercial activities to produce goods or services for profit. It can encompass a wide range of entities, from small entrepreneurial ventures to large multinational corporations. Business enterprises typically involve various functions such as production, marketing, sales, finance, and management, and they can operate in diverse industries and sectors. This term is generally used to emphasize the commercial and profit-oriented nature of the organization’s activities.
4. List out core business functions?
- Sales and Marketing
- Product/Service Delivery
- Quality
- Product Development
- Accounting
- Technology
- Human Resource Management
- Supplier Management
- Legal and Compliance
- Corporate Planning
- Procurement (Purchases)
5. Expand OLTP & OLAP?
- OLTP (Online Transaction Processing)
- OLAP (Online Analytical Processing)
6. What is Data Warehouse?
A data warehouse is a central repository that collects, stores, and provides access to a large amount of data for reporting, analysis, and decision-making. The primary purpose of a data warehouse is to organize and integrate data from multiple sources in a consistent and efficient way to support the business operations.
7. List information users and requirements.
Executives and Decision Makers
Operational Staff
Sales and Marketing Teams
Finance and Accounting Teams
IT and System Administrators
8. List the sources of Structured Data?
- Relational Databases
- Enterprise Resource Planning (ERP) Systems
- Customer Relationship Management (CRM) Systems
- Spreadsheets and Data Tables
- Data Warehouses
- Public and Syndicated Data
- Internet of Things (IoT) Devices
- Cloud-Based Applications
9. Define digital data and list the types of digital data?
Digital data refers to information that is stored, transmitted, or processed in the form of discrete elements represented using electronic or binary signals. It encompasses a wide range of content, including text, images, audio, video, and various other types of information that are encoded digitally.
Types of digital data:
1. Text Data
2. Numerical Data
3. Image Data
4. Audio Data
5. Video Data
6. Geographic Data
7. Time-Series Data
8. Metadata
9. Structured Data
10. Unstructured Data
10. Define Data Integration?
Data integration refers to the process of combining data from multiple sources, cleansing and transforming it, and storing it in a centralized repository. It involves several components, including data extraction, presentation, data cleansing, transformation, loading, and maintenance.
Data integration is an essential component of data warehousing and business intelligence systems. It enables organizations to access data from various sources, consolidate it into a single view, and analyze it to gain insights and drive decision-making.
11. What is Baldrige business excellence framework and mention the phases
The Baldrige Business Excellence Framework is a comprehensive set of criteria for improving organizational performance and achieving excellence in business operations. It is based on the Malcolm Baldrige National Quality Award, which is a prestigious U.S. award recognizing organizations that excel in quality and performance.
Phases:
- Leadership
- Strategy
- Customers
- Workforce
- Operations
- Measurement & Analysis.
- Knowledge Management
12. List the characteristics of Internet Ready IT applications.
1. Scalability
2. Security
3. Interoperability
4. Reliability
5. Flexibility
6. Accessibility
7. Performance
8. Compliance with standards
9. Integration capabilities
10. User-friendliness
13. Define digital data and list the types of digital data.
Digital data refers to any information that is encoded and stored in a digital format, typically in binary code (0s and 1s) that can be processed and transmitted by electronic devices.
Types of digital data include:
1. Textual data
2. Numeric data
3. Audio data
4. Image data
5. Video data
6. Metadata
7. Geospatial data
8. Time-stamped data
9. Transactional data
10. Structured and unstructured data
9. Define digital data and list the types of digital data?
Digital data refers to information that is stored, transmitted, or processed in the form of discrete elements represented using electronic or binary signals. It encompasses a wide range of content, including text, images, audio, video, and various other types of information that are encoded digitally.
Types of digital data:
1. Text Data
2. Numerical Data
3. Image Data
4. Audio Data
5. Video Data
6. Geographic Data
7. Time-Series Data
8. Metadata
9. Structured Data
10. Unstructured Data
10. Define Data Integration?
Data integration refers to the process of combining data from multiple sources, cleansing and transforming it, and storing it in a centralized repository. It involves several components, including data extraction, presentation, data cleansing, transformation, loading, and maintenance.
Data integration is an essential component of data warehousing and business intelligence systems. It enables organizations to access data from various sources, consolidate it into a single view, and analyze it to gain insights and drive decision-making.
I want BI notes pdf please send the pdf to my mail