O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Learning Path: Using Advanced Analytics Tools for Business Insight

Video Description

This learning path will show you how to use advanced analytics platforms to achieve fast and valuable business insights. It introduces the leading advanced analytics platforms, including KNIME, RapidMiner, and Impala, and demonstrates how they can deliver critical information with speed. Through hands-on tutorials using real-world data sets, you’ll not only understand how to install, integrate, and optimize various tools, you’ll also gain the confidence to perform common data analysis tasks such as querying, preparing, and visualizing data.

Table of Contents

  1. Introduction
    1. Welcome To The Course 00:01:59
    2. About The Author 00:01:15
  2. Preparation
    1. Setting Up The RapidMiner Environment 00:05:00
    2. RM 7.2 Downsampling Explanation 00:01:17
    3. Data Sets 00:09:22
    4. Now You Try 00:01:55
  3. Modeling Techniques: Correlational Methods
    1. Correlation 00:08:21
    2. K-Means Clustering 00:07:44
    3. K-Nearest Neighbors 00:06:55
    4. Now You Try 00:03:21
  4. Modeling Techniques: Affinity Analysis
    1. Association Rules 00:05:00
    2. Naive Bayes 00:04:49
    3. Discriminant Analysis 00:02:52
    4. Now You Try 00:05:13
  5. Modeling Techniques: Prediction
    1. Linear Regression 00:03:50
    2. Logistic Regression 00:05:46
    3. Decision Trees 00:04:35
    4. Neural Networks 00:05:18
    5. Now You Try 00:07:41
  6. Unstructured Data
    1. Text Analysis 00:07:59
    2. Now You Try 00:03:32
  7. Evaluation And Deployment
    1. Cross-Validation 00:04:55
    2. A Note About Ethics 00:03:10
  8. Conclusion
    1. Wrap Up And Thank You 00:03:14
  9. Introduction
    1. Welcome To The Course 00:01:10
    2. About The Author 00:01:41
  10. Introduction To The KNIME Analytics Platform
    1. What Is The KNIME Analytics Platform And What It Can Do For You 00:04:15
    2. Installation Of The KNIME Analytics Platform 00:03:31
    3. A Quick Tour Of The KNIME Analytics Platform 00:05:34
    4. Available Resources And Preview Of Final Goals For This Course 00:04:19
    5. GUI Based Programming: Workflows, Nodes, And Importing Workflows 00:03:18
  11. Data Access
    1. Reading From A Text File 00:06:50
    2. Database Access 00:07:01
    3. External REST Services 00:04:17
    4. Artificial Data Generation 00:04:12
    5. Other Data Access Nodes 00:03:00
    6. Exercise 00:00:48
  12. Data Visualization
    1. Data Visualization 00:03:25
    2. JavaScript Based Visualization 00:06:54
    3. Data Views 00:05:32
    4. Highlighting 00:04:20
    5. Graphics Through R 00:03:21
    6. Exercise 00:01:06
  13. ETL And Data Manipulation
    1. Data Filtering 00:06:07
    2. Data Aggregations 00:06:21
    3. Concatenation And Join 00:05:29
    4. Data Transformations 00:07:53
    5. Workflow Clean Up 00:04:39
    6. Datetime Manipulation 00:06:20
    7. In-Database Processing 00:06:21
    8. Exercise 00:00:45
  14. Data Mining
    1. Process Overview 00:04:53
    2. Training And Applying A Decision Tree 00:05:40
    3. Scoring A Model 00:06:21
    4. PMML 00:04:45
    5. K-Means Clustering 00:05:21
    6. Recommendation Engines 00:06:33
    7. Other Models Available 00:06:27
    8. Exercise 00:00:47
  15. Reporting
    1. Reporting Overview 00:02:12
    2. BIRT Integration 00:04:55
    3. Other Commercial Integrations 00:04:07
    4. KNIME WebPortal 00:06:22
    5. Exercise 00:00:55
  16. Conclusion
    1. Wrap Up And Thank You 00:02:28
  17. Introduction
    1. Introduction 00:04:47
    2. About The Working Files 00:03:16
    3. About The Author 00:02:03
  18. What Is Impala?
    1. Introduction 00:00:22
    2. What Is Impala 00:04:45
    3. Architecture 00:05:30
    4. Impala in Ecosystem 00:04:15
    5. Using Impala With Big Data 00:06:00
  19. Simple Queries
    1. Introduction 00:00:25
    2. Impala Interfaces 00:09:28
    3. Data Sources 00:05:13
    4. Simple Queries 00:09:53
    5. Exercise 00:11:22
  20. Advanced Queries
    1. Introduction 00:00:21
    2. Advanced SQL Queries 00:12:33
    3. Impala Specific Queries 00:05:08
    4. Exercise - Part 1 00:13:45
    5. Exercise - Part 2 00:06:32
  21. Integrating with Impala
    1. Introduction 00:00:31
    2. JDBC Connections 00:05:25
    3. Operationalizing 00:04:09
    4. UDFs 00:07:28
  22. Installing Impala
    1. Introduction 00:00:24
    2. Installing With Cloudera Manager 00:02:59
    3. Other Sources 00:02:31
  23. Wrap Up
    1. Conclusion 00:02:35
  24. Introduction
    1. Introducing Excel Big Data 00:04:46
    2. About The Author 00:01:17
    3. Using The Working Files 00:01:33
  25. Basic Data Manipulation
    1. Fixing Headers For Screen And Print 00:05:00
    2. Sorting Data 00:04:50
    3. Filtering Data 00:05:41
    4. Add A Chart In A Second 00:03:18
  26. Data Cleansing
    1. Starting Out The Cleaning Process 00:05:08
    2. Removing Duplicate Records 00:05:49
    3. Changing The Case 00:05:40
    4. Replacing Text Method Part - 1 00:06:21
    5. Replacing Text Method Part - 2 00:06:16
    6. Removal Of Non Printing Characters And Spaces 00:07:37
    7. Numbers Standardized On Import And Export 00:06:48
    8. Dealing With Date And Time Issues 00:09:24
    9. Merging And Splitting Data Columns 00:09:04
    10. Rearranging Columns And Rows 00:07:31
    11. Comparing Multiple Datasets 00:06:43
  27. Excel Tables
    1. Creating A Table 00:05:19
    2. Formatting Made Easy 00:03:14
    3. Managing Rows And Columns 00:05:33
    4. Sorting And Filtering Table Data 00:07:49
    5. Using The Totals Row 00:05:48
    6. Adding A Calculated Column 00:03:54
    7. Adding Charts And Pivot Tables Using Table Data 00:05:26
    8. Data Entry And Editing Through A Form 00:06:43
    9. Filtering Using The Slicer 00:05:28
    10. Advanced Filtering 00:08:00
    11. External Data As A Table Source 00:05:54
  28. Pivot Tables
    1. Introducing Pivot Tables 00:07:26
    2. Recommended Pivot Tables 00:04:16
    3. Use Named Ranges And Rename Column Headings 00:04:27
    4. Change The Data Function And Format The Numbers 00:06:47
    5. Moving And Or Removing A Pivot Table 00:04:04
    6. The Report Filter Option 00:04:16
    7. Sorting And Filtering By Pivot Table Columns 00:05:28
    8. Refreshing A Pivot Table 00:05:30
    9. Drilldown Behind Pivot Table Numbers 00:03:57
    10. Using Pivot Table Styles 00:04:15
    11. Use Of Multiple Fields In Rows And Columns 00:05:18
    12. Grand And Sub Totals 00:06:30
    13. Filtering Columns And Rows Within A Pivot Table 00:06:35
    14. Exploring Additional Options 00:05:12
    15. Using The Data Slicer 00:06:06
    16. Connecting To A SQL Server Database 00:06:00
    17. Using External Connection Files 00:04:49
  29. Charts
    1. Creating And Using Charts 00:05:51
    2. Using Trendlines 00:08:13
    3. Dynamic Named Ranges 00:09:13
    4. Creating A Forecast Sheet 00:05:10
    5. Plotting On Two Axis 00:04:09
  30. Pivot Charts
    1. Creating A Pivot Chart 00:05:38
    2. Altering Chart Design And Location 00:04:07
    3. Filtering And Hiding Elements 00:05:17
  31. Power Query
    1. Introducing Get And Transform The New Power Query 00:07:57
    2. Making The Most Of The Query Editor 00:08:52
    3. Using The Query Editor To Group Or Combine 00:06:06
    4. Using An Odata Feed And Merging Data 00:07:07
    5. Using Google Sheets As Your Source Data 00:05:47
    6. Connecting To Using And Combining Webpage Data 00:07:30
    7. Connecting To And Using Data From Facebook 00:07:12
    8. SQL Server Data Connections 00:06:23
    9. Get And Transform Data From Multiple Files In A Folder 00:06:45
  32. Power Map
    1. Activating And Creating Your First 3D Power Map 00:05:11
    2. A Simple Map Alternative To 3D Power Map 00:04:12
    3. Tours Scenes And Layers 00:06:29
    4. Create A Tour And Customize A Layer 00:06:40
    5. Displaying Additional Data With Additional Layers 00:05:13
    6. Adding And Animating Scenes 00:06:49
    7. Filtering Data Within A Layer And Scene 00:05:04
    8. Customization Options 00:06:18
    9. Exporting Images And Videos Of Your 3D Map Tour 00:05:00
  33. Power Pivot
    1. Introducing Power Pivots 00:05:03
    2. Importing Data And Adding Additional Data To The Data Model 00:04:37
    3. Adding Tables To The Data Model And Creating Relationships 00:06:06
    4. Powerpivot Pivotstables And Pivotcharts 00:06:10
    5. Adding Calculated Fields To Your Data Model 00:08:47
    6. Measures And KPIs In Your Powerpivot 00:08:54
  34. Goal Seek And Solver
    1. Use Goal Seek To Carry Out What If Analysis 00:05:22
    2. Installing And Uninstalling Solver 00:03:12
    3. Use Solver To Carry Out What If Analysis 00:07:09
    4. Using Scenarios 00:08:25
    5. Adding Constraints To Solver 00:05:44
  35. Data Analysis Tools
    1. Introducing The Analysis Toolpack 00:03:40
    2. Calculating And Graphing The Moving Average 00:03:43
    3. Creating A Histogram With A Bell Curve 00:07:55
  36. The End
    1. Sharing Your Big Data 00:05:45
    2. Resume 00:06:28
  37. Course Introduction
    1. About This Series 00:03:06
    2. What You Will Learn 00:03:43
    3. About The Author 00:02:08
  38. Deciding On Dashboards
    1. Deciding On Dashboards 00:08:04
    2. Reports, Dashboards And Scorecards 00:06:42
    3. Pondering The Plan 00:03:21
    4. Selecting Measures And Metrics 00:08:36
  39. Preparing The Data
    1. Preparing The Data 00:03:06
    2. Data Modeling Basics 00:04:27
    3. Structuring The Workbook 00:05:06
    4. Connecting To Data - Part 1 00:04:36
    5. Connecting To Data - Part 2 00:08:34
    6. Simplifying Data With Named Ranges 00:06:55
    7. Leveraging The Efficiency Of Tables 00:07:54
    8. Harnessing The Power Of Pivot Tables 00:10:13
    9. Managing Connected Data 00:05:29
    10. Simplifying With Custom Number Formats 00:10:22
  40. Building Dashboards
    1. Building Dashboards 00:02:49
    2. Dashboard Design Rules 00:07:06
    3. Managing Branding With Custom Themes 00:07:31
    4. Creating The Navigation Bar - Part 1 00:06:55
    5. Creating The Navigation Bar - Part 2 00:06:57
    6. Creating The Navigation Bar - Part 3 00:05:07
    7. What Is In A Word? 00:08:00
    8. Building Out Worksheets And Navigation 00:01:57
    9. Summarizing Data Using Groups 00:02:25
    10. Configuring Show Values As For Pivot Tables 00:04:53
    11. Assigning Categories Using Nested If 00:04:03
    12. Identifying Top Ten Values 00:03:36
    13. Finding The Last Value In A Series 00:06:19
  41. Getting Visual
    1. Getting Visual 00:05:03
    2. Customizing Display With Text-Based Elements 00:05:47
    3. Alerting With Conditional Formatting 00:05:17
    4. Chart And Sparkline Review 00:08:09
    5. Creating Sparklines For Dashboards 00:04:05
    6. Creating Charts For Dashboards 00:07:26
    7. Using A Waffle Chart To Show Progress 00:06:54
    8. Using The Excel Camera 00:03:39
    9. Creating A Distribution Histogram 00:08:37
    10. Hitting The Mark With Bullet Graphs 00:05:09
  42. Adding Interactivity
    1. Adding Interactivity 00:03:26
    2. Displaying The Developer Tab 00:01:34
    3. Understanding Interactive Dashboard Controls 00:06:35
    4. Adding Actions To Buttons 00:08:03
    5. Creating Custom Content With Combo Boxes 00:07:44
    6. Simplifying With Check Boxes 00:05:17
    7. Facilitating Filtering With Slicers And Timelines 00:09:36
    8. Finalizing By Color-Coding, Hiding And Protecting Worksheets 00:05:33
  43. Generating Dashboards As Output
    1. Generating Dashboards As Output 00:02:31
    2. Producing Dashboards As PDF 00:04:27
    3. Presenting Dashboards With Powerpoint 00:02:59
    4. Sharing Dashboards Via OneDrive 00:05:04
  44. Conclusion
    1. What You Now Know 00:05:56