Course Description

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.

How You Will Benefit
  • 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

Online Accreditation
1.2 CEU, 12 PDCs

What you will learn

What You Will Cover
  • 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.

Course Requirements:
MS Windows-based laptop with working browser to connect to the Internet via WiFi network; as well as a minimum of Excel 2019 or 365 for PC installed.


Course: Advanced Tools and Techniques for Data Analysis

$2,695.00
View All Dates

Looking for Group eLearning Options?

Get your team access to 4,000+ top courses anytime, anywhere.

Request On-Site Training

Upcoming Dates

$2,695.00
$2,695.00
$2,695.00

Course Dates

Location Date & Time Duration Course Type
  • CL Classroom Live - Traditional live classroom with in-person instructor.
  • CV Classroom Virtual - Attend this live instructor-led event remotely from the indicated tech facility.
  • VL Virtual Live - Attend this live instructor-led event remotely from anywhere.
Price  
Show Events

Cancelation Policy

If you cannot attend an event, you may send someone else in your place. If that isn’t an option for you, cancellations received up to five working days before the event are refundable, minus a registration service charge ($10 for one-day events; $25 for multiple-day events). After that, cancellations are subject to the entire seminar fee, which you may apply toward a future seminar. Please note that if you don’t cancel and don’t attend, you are still responsible for payment.

Similar Courses