Data Warehouse, BI, and Data Analysis Fundamentals
What is a Data Warehouse?
A data warehouse is a centralized repository designed to store large volumes of structured, semi-structured, and sometimes unstructured data.
Characteristics of a Data Warehouse
Subject-Oriented
- Organized around major subjects like customers, sales, or products, rather than business operations.
- Focuses on the specific areas of analysis rather than the detailed operations of individual systems.
Integrated
- Data from different sources is cleaned, transformed, and standardized to
Deming, COSO, and Audit Standards: A Summary
Deming Model
Principles:
1. Constancy 2. New Philosophy 3. Inspection 4. Eliminate 5. Improve Base Price 6. Training 7. Leadership 8. Discard 9. Remove Fear, barriers between departments 10. Elimination of harmful slogans 11. Quotas for quality (phase) personal 12. Achievements 13. Training 14. Transformation
Seven Deadly Sins
1. Lack of evidence in the millennium 2. Emphasis on short-term gains and immediate success 3. Evaluation 4. Annual address of the company based on company mobility 5. Direction
Read MoreTotal Quality Pillars: Lean Manufacturing & Toyota System
Total Quality Pillars
Key Pillars of Total Quality
- Customer Satisfaction: Product and service innovation.
- Economic Efficiency: Control processes, eliminate waste, optimize resource utilization.
- Internal Operation: Shared vision, focused goals, skills development and continuous learning.
Product Revolution: Market-driven approach (listen to the customer). PV = PC + Bo. Bo = Pv-Pc. M (maintain and improve).
Types of Waste
- Production waste
- Excessive waiting time
- Transportation waste
- Process waste
- Inventory waste
- Motion
Management and Leadership: Theories, Roles, and Change
The Challenge of Management
Managers are responsible for helping organizations achieve their objectives by creating and implementing plans. Management optimizes human, material, and financial contributions for organizational goals.
The Systems Approach
Management must be sensitive to organizational complexity and implement systems for efficiency. This involves breaking down barriers between departments and functions. Key concepts include: Subsystems, Synergy, Open and closed systems, Boundaries, Flows,
Read MoreICT’s Societal Impact: Digital Divide, Fraud, and Entertainment
The Impact of ICT on Society
Digital Divide
Digital divide: Gap between people able to make efficient use of ICT and those who are not.
- Introduction of technology can: Generate jobs, provide greater access to better health services.
Health Services
Health services: Some websites contain information about: Medicine, common ailments & how to treat them, contact details of doctors, waiting lists for hospital treatment. Appointments can also be booked online.
Employment Opportunities
Employment opportunities:
Read MorePromoting Health and Rehabilitation in Prisons: A Community Approach
Promoting Health and Rehabilitation in Prisons
The first obstacle is the resistance of the prison population, given their socio-psychological characteristics.
The processes will be motivating and lead with the subject itself.
Educational activities aimed at enabling the acquisition of knowledge will be very useful and should consider the individual as the primary resource for developing their own health. Therefore, the process should start from their demands and needs, using the endogenous potential
Read More