TY - GEN AU - Prasad, R. N. AU - Acharya, Seema TI - Fundamentals of business analytics SN - 9788126563791 U1 - 658.403 PY - 2016/// CY - New Delhi PB - Wiley India Pvt. Ltd. KW - N1 - CONTENTS Foreword v Preface vii Acknowledgments xi About the Authors xiii 1 Business View of Information Technology Applications 1-18 1.1 Business Enterprise Organization, Its Functions, and Core Business Processes 1.2 Baldrige Business Excellence Frameworks (Optional Reading) 1.3 Key Purpose of using IT in Business 1.4 The Connected World: Characteristics of Internet-Ready IT Applications 1.5 Enterprise Applications (ERP/CRM, etc.) and Bespoke IT Applications 1.6 Information Users and Their Requirements 2 Types of Digital Data 31-56 2.1 Introduction 2.2 Getting into “GoodLife” Database 2.3 Getting to Know Structured Data 2.4 Getting to Know Unstructured Data 2.5 Getting to Know Semi-Structured Data 2.6 Difference between Semi-Structured and Structured Data 3 Introduction to OLTP and OLAP 59-86 3.1 OLTP (On-Line Transaction Processing) 3.2 OLAP (On-Line Analytical Processing) 3.3 Different OLAP Architectures 3.4 OLTP and OLAP 3.5 Data Models for OLTP and OLAP 3.6 Role of OLAP Tools in the BI Architecture 3.7 Should OLAP be Performed Directly on Operational Databases? 3.8 A Peek into the OLAP Operations on Multidimensional Data 3.9 Leveraging ERP Data Using Analytics 4 Getting Started with Business Intelligence 87-116 4.1 Using Analytical Information for Decision Support 4.2 Information Sources Before Dawn of BI? 4.3 Definitions and Examples in Business Intelligence, Data Mining, Analytics, Machine Learning, Data Science 4.4 Looking at “Data” from Many Perspectives 4.5 Business Intelligence (BI) Defined 4.6 Why BI? How Can You Achieve Your Stated Objectives? 4.7 Some Important Questions About BI - Where, When and What 4.8 Evolution of BI and Role of DSS, EIS, MIS, and Digital Dashboards 4.9 Need for BI at Virtually all Levels 4.10 BI for Past, Present, and Future 4.11 The BI Value Chain 4.12 Introduction to Business Analytics 5 BI Definitions and Concepts 117-148 5.1 BI Component Framework 5.2 Who is BI for? 5.3 BI Users 5.4 Business Intelligence Applications 5.5 BI Roles and Responsibilities 5.6 Best Practices in BI/DW 5.7 The Complete BI Professional 5.8 Popular BI Tools 6 Basics of Data Integration 151-203 6.1 Need for Data Warehouse 6.2 Definition of Data Warehouse 6.3 What is a Data Mart? 6.4 What is then an ODS? 6.5 Ralph Kimball’s Approach vs. W.H. Inmon’s Approach 6.6 Goals of a Data Warehouse 6.7 What Constitutes a Data Warehouse? 6.8 Extract, Transform, Load 6.9 What is Data Integration? 6.10 Data Integration Technologies 6.11 Data Quality 6.12 Data Profiling 7 Multidimensional Data Modeling 205-255 7.1 Introduction 7.2 Data Modeling Basics 7.3 Types of Data Model 7.4 Data Modeling Techniques 7.5 Fact Table 7.6 Dimension Table 7.7 Typical Dimensional Models 7.8 Dimensional Modeling Life Cycle 8 Measures, Metrics, KPIs and Performance Management 257-270 8.1 Understanding Measures and Performance 8.2 Measurement System Terminology 8.3 Navigating a Business Enterprise, Role of Metrics and Metrics Supply Chain 8.4 “Fact-Based Decision Making” and KPIs 8.5 KPI Usage in Companies 8.6 Where do Business Metrics and KPIs Come From? 8.7 Connecting the Dots: Measures to Business Decisions and Beyond 9 Basics of Enterprise Reporting 273-307 9.1 Reporting Perspectives Common to All Levels of Enterprise 9.2 Report Standardization and Presentation Practices 9.3 Enterprise Reporting Characteristics in OLAP World 9.4 Balanced Scorecard 9.5 Dashboards 9.6 How Do You Create Dashboards? 9.7 Scorecards vs. Dashboards 9.8 The Buzz behind Analysis 10 Understanding Statistics 309-327 10.1 Role of Statistics in Analytics 10.2 Data, Data Description and Summarization 10.3 Statistical Tests 10.4 Understanding Hypothesis and t-Test 10.5 Correlation Analysis 10.6 Regression 10.7 ANOVA 10.8 The F-Test 10.9 Time Series Analysis 11 Application of Analytics 331-343 11.1 Application of Analytics 11.2 Analytics in Industries 11.3 Widely Used Application of Analytics 12 Data Mining Algorithms 347-367 12.1 Association Rule Mining 12.2 k-Means Clustering 12.3 Decision Tree 13 BI Road Ahead 369-384 13.1 Understanding BI and Mobility 13.2 BI and Cloud Computing 13.3 Business Intelligence for ERP Systems 13.4 Social CRM and BI Unsolved Exercises Glossary 385 Index 397 ER -