2006 - AMA: 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.

Code: 2006

Duration: 2.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

  • 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

Content

  • Data analytics and business; working with data
  • Wrangling, cleansing, and shaping data (data scraping)
  • Using Google Open Refine
  • 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

Audience

N/A

Prerequisites

Basic understanding of Excel and spreadsheets, including Pivot tables and basic charting functions.

Certification

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

AMA Popular Courses

2218

Learn how to think finance, and you’ll expand your career opportunities. This program for non-financial managers makes the basics of finance accessible to anyon

2235

From this course, you’ll find your relationship style, identify your strengths and weaknesses, and master the winning tactics to work harmoniously to achieve yo

2506

This hands-on course gives them to you—from analyzing the cause of subpar performance to creating a climate for effective employee coaching and learning…from gi

2203

You’ll focus on improving communication skills and competencies necessary to build mutual understanding and connectivity with others, regardless of your role.
Enquire Now
 
 
 
 
0lkbcV
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy