SAP Lumira, Discovery Edition: The Comprehensive Guide (Hardcover)

... Foreword ... 19 ... Acknowledgments ... 21 ... Introduction ... 23 ... Target Group and Prerequisites ... 23 ... Structure of the Book ... 23 ... Additional Resources ... 27 ... Part I: Getting Started ... 29 1 ... Introduction to SAP Lumira, Discovery Edition ... 31 1.1 ... Self-Service Business Intelligence ... 32 1.2 ... SAP Lumira Suite ... 36 1.3 ... SAP Lumira and SAP's Business Intelligence Portfolio ... 38 1.4 ... Summary ... 45 2 ... Installing SAP Lumira, Discovery Edition ... 47 2.1 ... License Model and 30-Day Trial ... 47 2.2 ... System Requirements ... 50 2.3 ... Downloading SAP Lumira, Discovery Edition ... 51 2.4 ... Installing SAP Lumira, Discovery Edition ... 55 2.5 ... Uninstalling SAP Lumira, Discovery Edition ... 59 2.6 ... Updating SAP Lumira, Discovery Edition ... 61 2.7 ... Tracing ... 63 2.8 ... Summary ... 66 3 ... SAP Lumira, Discovery Edition Interface ... 67 3.1 ... Home Page ... 67 3.2 ... Menu ... 71 3.3 ... Data View ... 86 3.4 ... Design View ... 87 3.5 ... Preview ... 90 3.6 ... Toolbar ... 90 3.7 ... Comparing SAP Lumira 1.x and SAP Lumira 2.x ... 92 3.8 ... Summary ... 94 4 ... Creating Your First Story ... 95 4.1 ... Creating a New Story ... 96 4.2 ... Analyzing Data ... 97 4.3 ... Data Preparation ... 99 4.4 ... Creating a Visualization ... 104 4.5 ... Finalizing Your Story ... 107 4.6 ... Sharing Your Story ... 109 4.7 ... Summary ... 110 ... Part II: Data ... 111 5 ... Data Acquisition ... 113 5.1 ... Microsoft Excel ... 114 5.2 ... Text ... 117 5.3 ... Windows Clipboard ... 121 5.4 ... SAP BW ... 124 5.5 ... SAP HANA ... 136 5.6 ... Universe ... 144 5.7 ... Query with SQL ... 149 5.8 ... Dataset Refresh and Edit ... 158 5.9 ... Summary ... 165 6 ... Live Data ... 167 6.1 ... SAP BW ... 168 6.2 ... SAP HANA ... 173 6.3 ... Summary ... 179 7 ... Data Analysis ... 181 7.1 ... Data View ... 182 7.2 ... Grid View ... 183 7.3 ... Facet View ... 185 7.4 ... Summary ... 188 8 ... Data Manipulation ... 189 8.1 ... Objects ... 190 8.2 ... Hierarchies ... 194 8.3 ... Calculated Objects ... 204 8.4 ... Data Actions ... 219 8.5 ... Merging Datasets ... 223 8.6 ... Appending Data ... 227 8.7 ... Configuring Auto-Enrichment ... 229 8.8 ... Summary ... 231 ... Part III: Data Visualization and Stories ... 233 9 ... Chart Creation ... 235 9.1 ... Chart Canvas ... 235 9.2 ... Chart Builder ... 238 9.3 ... Visualization Formatting ... 245 9.4 ... Reference Line ... 249 9.5 ... Conditional Formatting ... 251 9.6 ... Summary ... 254 10 ... Crosstabs ... 255 10.1 ... Creating a Crosstab ... 255 10.2 ... Analysis Options ... 259 10.3 ... SAP BW and SAP HANA Live Data ... 264 10.4 ... Summary ... 269 11 ... Comparison Charts ... 271 11.1 ... Bar Chart ... 271 11.2 ... Column Chart ... 274 11.3 ... Marimekko Chart ... 274 11.4 ... Radar Chart ... 276 11.5 ... Tag Cloud ... 277 11.6 ... Heat Map ... 278 11.7 ... Numeric Point ... 279 11.8 ... Summary ... 280 12 ... Percentage Charts ... 281 12.1 ... Pie Chart ... 281 12.2 ... Donut Chart ... 283 12.3 ... Stacked Bar Chart ... 284 12.4 ... Stacked Column Chart ... 286 12.5 ... Funnel Chart ... 287 12.6 ... Summary ... 288 13 ... Correlation Charts ... 289 13.1 ... Scatter Plot ... 289 13.2 ... Scatter Plot for Time Series ... 291 13.3 ... Bubble Chart ... 292 13.4 ... Bubble Chart for Time Series ... 294 13.5 ... Network Chart ... 294 13.6 ... Tree ... 295 13.7 ... Summary ... 296 14 ... Trend Charts ... 297 14.1 ... Line Chart ... 297 14.2 ... Stacked Area Chart ... 300 14.3 ... Waterfall Chart ... 301 14.4 ... Box Plot ... 302 14.5 ... Parallel Coordinates Chart ... 303 14.6 ... Combination Chart ... 304 14.7 ... Summary ... 306