Advanced Tools and Techniques for Data
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
• Improve your business efficiency and effectiveness
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
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.
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.
Seminar begins at 9:00 am and ends at 5:00 pm,
except on the last day. On the last day, seminars that run the full day begin at
9:00 am and end at 4:30 pm.