Data analytics for business: AI-ML-PBI-SQL-R
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
London ; New York
Routledge
2024
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | xii, 270 Seiten Illustrationen, Diagramme |
| ISBN: | 9781032372624 9781032372631 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV049643543 | ||
| 003 | DE-604 | ||
| 005 | 20240527 | ||
| 007 | t | ||
| 008 | 240410s2024 a||| |||| 00||| eng d | ||
| 020 | |a 9781032372624 |c pbk |9 978-1-03-237262-4 | ||
| 020 | |a 9781032372631 |c hbk |9 978-1-03-237263-1 | ||
| 035 | |a (OCoLC)1432158651 | ||
| 035 | |a (DE-599)BVBBV049643543 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-20 |a DE-N2 |a DE-706 |a DE-355 | ||
| 084 | |a ST 530 |0 (DE-625)143679: |2 rvk | ||
| 084 | |a QH 500 |0 (DE-625)141607: |2 rvk | ||
| 100 | 1 | |a Garn, Wolfgang |e Verfasser |0 (DE-588)1330556909 |4 aut | |
| 245 | 1 | 0 | |a Data analytics for business |b AI-ML-PBI-SQL-R |c Wolfgang Garn |
| 264 | 1 | |a London ; New York |b Routledge |c 2024 | |
| 300 | |a xii, 270 Seiten |b Illustrationen, Diagramme | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 0 | 7 | |a Unternehmen |0 (DE-588)4061963-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenanalyse |0 (DE-588)4123037-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Wirtschaftsinformatik |0 (DE-588)4112736-5 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Unternehmen |0 (DE-588)4061963-1 |D s |
| 689 | 0 | 1 | |a Datenanalyse |0 (DE-588)4123037-1 |D s |
| 689 | 0 | 2 | |a Wirtschaftsinformatik |0 (DE-588)4112736-5 |D s |
| 689 | 0 | |5 DE-604 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |z 978-1003336099 |
| 856 | 4 | 2 | |m Digitalisierung UB Regensburg - ADAM Catalogue Enrichment |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=034987127&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-034987127 | |
Datensatz im Suchindex
| _version_ | 1815416366920892416 |
|---|---|
| adam_text |
Contents PART ONE Fundamental Business 1 2 Insights 1 3 introduction 1J Data Analytics and Applications 3 1.2 Learning Outcomes 5 1.3 Tools and Data 6 Databases 2.1 8 Introduction 2.1.1 8 Overview 8 2.1.2 Motivation and Managers 9 2.1.3 Database Integration and Cloud Solutions 2.1.4 Security, Ethics and Law '; 2.2 Systems 2.2.1 Concept 2.2.3 Setup and Configuration 2.2.4 Databases 2.3 SQL-Tables 13 ■ « ,- 2.2.2 Database Engines 12 12 13 - 14 15 18 21 2.3.1 Definition 21 2.3.2 Inserting Records 22 2.3.3 Deleting Records 23 2.3.4 Normal Forms 23 2.3.5 Data Access and R 26
CONTENTS 2.4 SQL - Queries 2.5 Unconditional Query 31 2.4.2 View 32 2.4.3 Conditional Query 33 2.4.4 Group and Aggregate 33 2.4.5 Join Query 34 Entity Relationships Directional ER 37 2.5.2 Combining Entities 40 Business Intelligence 3.1 Introduction 3.1.1 3.2 3.4 3.5 3.6 Definitions Tools 3.2.1 3.3 37 2.5.1 2.6 Summary 3 31 2.4.1 41 43 43 43 45 PBI Overview Design and Visualisations 47 48 3.3.1 Visualisations 48 3.3.2 FBI Crash Course 53 3.3.3 PBI General Considerations Analytics 69 72 3.4.1 Trends and Forecasts 73 3.4.2 PBI Key Influencers Visual 75 3.4.3 DAX Functions Miscellaneous 77 80 3.5.1 Best Practiccs/Sharcd Experiences 80 3.5.2 Bit-Size Challenges 80 3.5.3 Create Custom R Visualfor PBI Summary 85 88 PART TWO Coding and Frameworks 91 4 Data Science Languages 93 Introduction 93 4.1 4.1.1 4.2 Language R 94 Data Types and Operations 96 4.2.1 Arithmetic and Basic DataTypes 4.2.2 Compound Data Types 4.2.3 String Operations and RegularExpressions vi 94 4.1.2 Projects and Libraries 96 105 ш
4.3 Controls and Functions 4.3.1 4.3.2 If Conditions Loops - Control Flow 4.3.3 Functions 4.4 5 I I ! Il4 114 11b 4.3.4 Coding with GPT lib 4.3.5 Data Transfer Function 120 Summary Data Analytics Frameworks 12I 12 1 5.1 Introduction 12! 5.2 Modelling and Applications 124 5.2.1 5.3 5.4 126 121! Machine Learning Roadmap 5.3.1 Preprocessing, Splitting and Balancing I Ю Bl 5.3.2 Learning 1 11 5.3.3 Evaluation and Application 114 Knowledge Discovery in Databases (KDD) 1 IS 5.4.2 5.6 124 5.2.3 Business Applications 5.4.1 5.5 Business Scenario Example 5.2.2 Real World and Prediction Model KDD - Problem and Resourcing KDD - Data Cleansing and Preprocessing 11b 1 !» 5.4.3 KDD - Data Mining and Evaluation 140 5.4.4 KDD - Interpretation and Exploitation Cross-Industry Standard Process for DataMining 141 141 5.5.1 Understanding 141 5.5.2 Preparation and Modelling 14! 5.5.3 Evaluation and Deployment 14! Summary 144 PART THREE Learning ^’ 6 Statistical Learning 147 6.1 Introduction 147 6.2 Models and Quality Measures 14» 6.3 6.2.1 Quality Measures 14» 6.2.2 Confusion Matrix 1 Descriptive Statistics 156 6.3.1 Exploring Data ] 6.3.2 Correlation 1f)1 6.4 Linear Regression vii
CONTENTS 6.4.1 Simple Linear Regression 6.4.2 Multivariate Linear Regression 6.5 6.6 165 166 6.4.3 Applications, ML Parts and Statistik - 167 Logistic Regression 174 6.5.1 177 Multiple Classes - One versus AM 6.5.2 Old Faithful Example 179 Summary 181 7 Supervised Machine Learning 183 7.1 Introduction 183 7.2 Regression and Classification Trees 184 7.2.1 Regression Tree 7.2.2 Classification Trees 7.3 184 191 Tree-Based Algorithms 193 7.3.1 Random Forest 193 7.3.2 Trees 195 7.4 Nearest Neighbours Classifier 195 7.5 Summary 198 8 Unsupervised Machine Learning 199 8.1 Introduction 199 8.2 K-Means Clustering 200 8.2.1 8.3 Application 200 8.2.2 Concept and Algorithm 202 Hierarchical Clustering 204 8.3.1 206 Dendrogram 8.4 Self-Organising Maps 208 8.5 Expectation Maximisation 212 8.6 Summary 217 PART FOUR Artificial Intelligence 9 219 Artificial Intelligence 221 Introduction 221 9.1.1 Al Applications 222 9.1.2 Classic Al Areas 9.1 9.2 9.3 viii 223 Learning - ANN and SVM 224 9.2.1 Recap 224 9.2.2 ANN Model 226 9.2.3 Support Vector Machines (SVM) 231 Problem Solving - GA and SA 238 9.3.1 239 Knapsack Problem
9.4 9.3.2 Brute Force 2 5’1 9.3.3 Genetic Algorithm 241 9.3.4 Methods Overview 242 Games - Minimax 244 Chess 244 9.4.1 9.4.2 Minimax Algorithm 248 9.5 Reasoning Under Uncertainty - BBN 2" 2 9.6 Summary 2 54 PART FIVE References ^’1 -^ i Index ix |
| adam_txt | |
| any_adam_object | 1 |
| any_adam_object_boolean | |
| author | Garn, Wolfgang |
| author_GND | (DE-588)1330556909 |
| author_facet | Garn, Wolfgang |
| author_role | aut |
| author_sort | Garn, Wolfgang |
| author_variant | w g wg |
| building | Verbundindex |
| bvnumber | BV049643543 |
| classification_rvk | ST 530 QH 500 |
| ctrlnum | (OCoLC)1432158651 (DE-599)BVBBV049643543 |
| discipline | Informatik Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a2200000 c 4500</leader><controlfield tag="001">BV049643543</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20240527</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">240410s2024 a||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781032372624</subfield><subfield code="c">pbk</subfield><subfield code="9">978-1-03-237262-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781032372631</subfield><subfield code="c">hbk</subfield><subfield code="9">978-1-03-237263-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1432158651</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV049643543</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-20</subfield><subfield code="a">DE-N2</subfield><subfield code="a">DE-706</subfield><subfield code="a">DE-355</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 530</subfield><subfield code="0">(DE-625)143679:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QH 500</subfield><subfield code="0">(DE-625)141607:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Garn, Wolfgang</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1330556909</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Data analytics for business</subfield><subfield code="b">AI-ML-PBI-SQL-R</subfield><subfield code="c">Wolfgang Garn</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">London ; New York</subfield><subfield code="b">Routledge</subfield><subfield code="c">2024</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">xii, 270 Seiten</subfield><subfield code="b">Illustrationen, Diagramme</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Unternehmen</subfield><subfield code="0">(DE-588)4061963-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenanalyse</subfield><subfield code="0">(DE-588)4123037-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Wirtschaftsinformatik</subfield><subfield code="0">(DE-588)4112736-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Unternehmen</subfield><subfield code="0">(DE-588)4061963-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datenanalyse</subfield><subfield code="0">(DE-588)4123037-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">Wirtschaftsinformatik</subfield><subfield code="0">(DE-588)4112736-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Online-Ausgabe</subfield><subfield code="z">978-1003336099</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Regensburg - ADAM Catalogue Enrichment</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=034987127&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-034987127</subfield></datafield></record></collection> |
| id | DE-604.BV049643543 |
| illustrated | Illustrated |
| index_date | 2024-07-03T23:39:36Z |
| indexdate | 2024-11-11T09:06:02Z |
| institution | BVB |
| isbn | 9781032372624 9781032372631 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-034987127 |
| oclc_num | 1432158651 |
| open_access_boolean | |
| owner | DE-20 DE-N2 DE-706 DE-355 DE-BY-UBR |
| owner_facet | DE-20 DE-N2 DE-706 DE-355 DE-BY-UBR |
| physical | xii, 270 Seiten Illustrationen, Diagramme |
| publishDate | 2024 |
| publishDateSearch | 2024 |
| publishDateSort | 2024 |
| publisher | Routledge |
| record_format | marc |
| spelling | Garn, Wolfgang Verfasser (DE-588)1330556909 aut Data analytics for business AI-ML-PBI-SQL-R Wolfgang Garn London ; New York Routledge 2024 xii, 270 Seiten Illustrationen, Diagramme txt rdacontent n rdamedia nc rdacarrier Unternehmen (DE-588)4061963-1 gnd rswk-swf Datenanalyse (DE-588)4123037-1 gnd rswk-swf Wirtschaftsinformatik (DE-588)4112736-5 gnd rswk-swf Unternehmen (DE-588)4061963-1 s Datenanalyse (DE-588)4123037-1 s Wirtschaftsinformatik (DE-588)4112736-5 s DE-604 Erscheint auch als Online-Ausgabe 978-1003336099 Digitalisierung UB Regensburg - ADAM Catalogue Enrichment application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=034987127&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Garn, Wolfgang Data analytics for business AI-ML-PBI-SQL-R Unternehmen (DE-588)4061963-1 gnd Datenanalyse (DE-588)4123037-1 gnd Wirtschaftsinformatik (DE-588)4112736-5 gnd |
| subject_GND | (DE-588)4061963-1 (DE-588)4123037-1 (DE-588)4112736-5 |
| title | Data analytics for business AI-ML-PBI-SQL-R |
| title_auth | Data analytics for business AI-ML-PBI-SQL-R |
| title_exact_search | Data analytics for business AI-ML-PBI-SQL-R |
| title_exact_search_txtP | Data analytics for business AI-ML-PBI-SQL-R |
| title_full | Data analytics for business AI-ML-PBI-SQL-R Wolfgang Garn |
| title_fullStr | Data analytics for business AI-ML-PBI-SQL-R Wolfgang Garn |
| title_full_unstemmed | Data analytics for business AI-ML-PBI-SQL-R Wolfgang Garn |
| title_short | Data analytics for business |
| title_sort | data analytics for business ai ml pbi sql r |
| title_sub | AI-ML-PBI-SQL-R |
| topic | Unternehmen (DE-588)4061963-1 gnd Datenanalyse (DE-588)4123037-1 gnd Wirtschaftsinformatik (DE-588)4112736-5 gnd |
| topic_facet | Unternehmen Datenanalyse Wirtschaftsinformatik |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=034987127&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT garnwolfgang dataanalyticsforbusinessaimlpbisqlr |