The Modern Business Data Analyst A Case Study Introduction into Business Data Analytics with CRISP-DM and R 2024 with complete solution

The Modern Business Data Analyst A Case Study Introduction into Business Data Analytics with CRISP-DM and R 2024 with complete solution Contents Preface....................................................................................................................................... vii Solving Business Problems with Business Data Analytics................................................... vii R for Business Data Analytics ............................................................................................... ix How to Read this Book ........................................................................................................... x Conventions Used in this Book............................................................................................ xiii Code Examples .................................................................................................................... xiii Acknowledgments................................................................................................................. xv 1 Introduction......................................................................................................................... 1 1.1 Motivation................................................................................................................... 1 1.2 Whisky Quality Problems in the Junglivet Company ................................................. 2 1.3 The Business Data Analytics Mindset ...................................................................... 10 1.4 How Business Data Analytics Experts Work............................................................ 12 1.5 Business Understanding and Project Setup............................................................... 16 1.6 Checklist.................................................................................................................... 24 2 Business Data Analytics Toolbox: R and RStudio............................................................ 25 2.1 First Steps in RStudio to Run R Code....................................................................... 25 2.2 Data Structures and Variables in R........................................................................... 28 2.3 Work With Data in R ................................................................................................ 35 2.4 Write Functions and Logic in R................................................................................ 39 2.5 Expand your Code with External R Packages........................................................... 41 2.6 Manage your Projects and Data in RStudio .............................................................. 44 2.7 Further Beginner Resources...................................................................................... 45 2.8 Useful R Functions for Everyday R Programming ................................................... 46 2.9 R Beginner Exercises................................................................................................ 48 3 Business Data Understanding ........................................................................................... 49 3.1 Introduction............................................................................................................... 49 3.2 Business Data Manipulation with dplyr.................................................................... 51 3.3 Business Data Visualization with ggplot2 ................................................................ 59 3.4 Business Data Description ........................................................................................ 93 3.5 Business Data Quality and Validation ...................................................................... 97 xvi Contents xvii 3.6 Useful R Functions for Everyday Business Data Understanding............................ 104 3.7 Checklist.................................................................................................................. 109 3.8 Business Case Exercise: Visualizing Whisky Data................................................. 110 4 Business Data Preparation............................................................................................... 111 4.1 Introduction............................................................................................................. 111 4.2 Business Data.......................................................................................................... 114 4.3 Business Data Cleaning........................................................................................... 123 4.4 Feature Engineering ................................................................................................ 136 4.5 Business Data Integration ....................................................................................... 146 4.6 Useful R Functions for Everyday Business Data Preparation................................. 154 4.7 Checklist.................................................................................................................. 155 4.8 Business Case Exercise: Investigating Quality Production Problems..................... 157 5 Modeling ......................................................................................................................... 158 5.2 Modeling Methods in Analytics.............................................................................. 159 5.3 Compare Business Decisions.................................................................................. 164 5.4 Find Clusters........................................................................................................... 170 5.5 Find Rules and Relationships.................................................................................. 182 5.6 Predict Categorial Values........................................................................................ 191 5.7 Predict Numeric Values .......................................................................................... 198 5.8 Predict Developments............................................................................................. 206 5.9 Useful R Functions for Everyday Business Data Analytics.................................... 211 5.10 Checklist.................................................................................................................. 213 5.11 Business Case Exercise: Finding Clusters in the Whisky Market........................... 215 6 Business Data Products................................................................................................... 216 6.1 Introduction............................................................................................................. 216 6.2 Evaluation and Deployment of Business Data Products......................................... 218 6.3 Business Data Reporting......................................................................................... 220 6.4 Business Analytics Systems.................................................................................... 238 6.5 Useful R Functions for Everyday App Development ............................................. 252 6.6 Checklist.................................................................................................................. 253 6.7 Business Case Exercise: A Dashboard for the Marketing Management................. 255 xviii Contents 7 Mastering Business Data Analytics ................................................................................ 257 7.1 Introduction............................................................................................................. 257 7.2 Start your Career as Business Data Analyst............................................................ 257 7.3 Prepare for your Business Data Analyst Job........................................................... 269 7.4 Business Data Analyst Best Practices..................................................................... 274 7.5 Some Last Words.................................................................................................... 280 8 Appendix......................................................................................................................... 281 8.1 100 Technical Interview Questions......................................................................... 281 8.2 Business Case Study 1: Analyzing Transactions in the Junglivet Online Shop...... 291 8.3 Business Case Study 2: Developing a Car Maintenance System............................ 292 8.4 Business Case Study 3: Take Part in an Analytics Competition............................. 293 References............................................................................................................................... 29