workers-collab

Advanced Tools and Techniques for Data Analysis

Manipulate complex data sets to gain deeper insights and make better decisions

This 2-day advanced analytics seminar will introduce you to predictive analytics techniques, so you can frame strategic and operational questions involving marketing, finance, and operations or other real-world business applications. In this hands-on course, you will cover a variety of analytics tools, such as histograms, ANOVA analysis, A/B testing, Pareto analysis, clustering, box plots, scatter diagrams, partitioning, unstructured text analysis, and multivariate regression analysis. Best of all, no background in statistics or programming is required. As long as you have a basic understanding of spreadsheets, you will learn how to manipulate complex data sets so you can gain insights that are not possible with common business intelligence techniques.

Seminar Number: 02006

  • In a Classroom
  • Your Company Location

Course Scheduling & Pricing

Who Should Attend

Business professionals looking for data analysis tools to solve complex problems such as customer churn, statistically valid web-page optimization, and social media/online customer feedback analysis.

  •   Classroom2 Day(s)
    1.2 CEU, 12 PDCs
 

This 2-day advanced analytics seminar will introduce you to predictive analytics techniques, so you can frame strategic and operational questions involving marketing, finance, and operations or other real-world business applications.

In this hands-on course, you will cover a variety of analytics tools, such as histograms, ANOVA analysis, A/B testing, Pareto analysis, clustering, box plots, scatter diagrams, partitioning, unstructured text analysis, and multivariate regression analysis. Best of all, no background in statistics or programming is required. As long as you have a basic understanding of spreadsheets, you will learn how to manipulate complex data sets so you can gain insights that are not possible with common business intelligence techniques.

  • Go above and beyond standard business intelligence analysis techniques
  • Get answers to complex data analysis questions without becoming a statistician  
  • Learn which data analysis technique to use for various business problems
  • Extract the most meaningful results from large and small data sets and multiple data types
  • Become familiar with basic text analysis tools and gain insights from unstructured text data
  • Use advanced analysis functions in Excel and open source tools
  • Build on your basic understanding of spreadsheets to access powerful analytic techniques
  • Improve your business efficiency and effectiveness
  • Data analytics and business; working with data
  • Wrangling, cleansing, and shaping data (data scraping)
  • Using Google OpenRefine
  • Selecting the right variables, KPIs, CSFs (data analysis)
  • Becoming familiar with Excel’s Analysis Tool Pack
  • Utilizing multivariate statistics, T-Test, factor analysis, linear regression, and other advanced techniques
  • Reviewing additional tools—JMP, Tableau, SPSS, R

Special Feature

Seminar pre-requisites
Basic understanding of Excel and spreadsheets, including Pivot tables and basic charting functions.

Equipment and software required of each participant:
MS Windows-based laptop with a working browser to connect to the Internet via the AMA WiFi network, as well as with a minimum of Excel 2010 for PC installed.

Giving Feedback

  • Apply the Most Effective Data Analysis Technique to a Specific Business Problem
  • Extract Meaningful Results from Large and Small Data Sets to Improve Business Efficiency and Effectiveness
  • Interpret Results from the Analysis of Unstructured Text (Emails and Social Media) to Provide Insight into Specific Business Problems
  • Gain Increased Confidence in Your Ability to Use the Advanced Analysis Functions in Excel and Open-Source Tools to Share Newly Discovered Insights with Others in the Organization

Data Analytics and Business

  • Understand How Business Analytics (BA) Enhances Business
    Intelligence (BI)
  • Resolve Business Challenges That Yield to Data
  • Gain Insight from Data Analytics
  • Learn a Methodology for Framing Business Questions That Will Use Data and Analytics as the Basis for Answers and Solutions

Working with Data

  • Identify Which Data Analysis Tools Best Answer Common Analytical Business Questions
  • Understand How the Microsoft® Excel Analysis ToolPak and Other Programs Can Be Used for Advanced Data Analysis
  • Select the Appropriate Tools and Techniques for Your Data
  • Apply Analytical Tools to Answer the Basic Business Questions You Are Facing in Your Work

Advanced Analytical Techniques

  • Recognize How Advanced Data Analysis Techniques Can Be Used to Address a Variety of Business Challenges
  • Perform Various Data Analysis Techniques Including Correlation and Linear Regression, Multivariate Regression, Predictive Models, and ANOVA Analysis
  • Determine Data Analysis Techniques That Can Be Applied to Your Organization

Specialized Tools and Techniques

  • Recognize How Advanced Data Analysis Techniques Can Be Used to Address a Variety of Business Challenges
  • Determine Analysis Techniques That Can Be Applied to Your Organization
  • Perform Various Data Analysis Techniques (Moving Bubble Analysis for Multivariable Time Series, Unstructured Data Text Analysis, and Contingency Analysis, the Chi-Square Test, and the A/B Test

Applying the Techniques

  • Demonstrate the Skills and Knowledge You’ve Acquired to Analyze Data and Determine Relevant Business Questions
  • Use Many of the Techniques and Tools Demonstrated During the Seminar

American Management Association is accredited by the International Association for Continuing Education and Training (IACET) and is accredited to issue the IACET CEU.

AMA is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM.

Classroom Schedule

4 Sessions Available

  • $2,445.00 Non Members
  • $2,195.00 AMA Members
  • $2,079.00 GSA
Date Duration State City Zip
  2020-02-24 2020-02-25 Feb 24, 2020 - Feb 25, 2020 2 Days NY New York 10019 New York Register Now

  2020-03-19 2020-03-20 Mar 19, 2020 - Mar 20, 2020 2 Days DC Arlington/Washington 22202-4807 Arlington/Washington Register Now

  2020-05-04 2020-05-05 May 4, 2020 - May 5, 2020 2 Days IL Chicago 60601 Chicago Register Now

  2020-07-27 2020-07-28 Jul 27, 2020 - Jul 28, 2020 2 Days NY New York 10019 New York Register Now

2445.00 $
Close