|
CATEGORY
Data Analytics |
|
DURATION
Three Day |
|
SKILL LEVEL
Introductory - Advanced |
|
PD HOURS
21 |
Description
This hands-on 3-day course equips you with business analytics and modelling skills using Microsoft Excel and R, a freeware language and environment for statistical computing and graphics that has emerged as the world’s leading analytics tool to handle Big & Small Data.
Whether you work for a large or small organization, you most likely use Microsoft Excel. Your job likely involves analyzing, summarizing, and reporting data. It might also involve building models to help reduce costs, increase profits, or better manage operations.
The course will teach participants how to use Microsoft Excel more competently to analyze data, create models, and generate insights. It will further train you in extending your skills to industry strength analytics using the R programming language with the point-and-click familiarity that you bring from working with Excel.
The course features interactive discussion, case studies, and lecture formats which focus on the use of Excel for analytics. Training is hands-on, with participants working alongside knowledgeable instructors, learning within the context of real-world, practical examples.
Whether you work for a large or small organization, you most likely use Microsoft Excel. Your job likely involves analyzing, summarizing, and reporting data. It might also involve building models to help reduce costs, increase profits, or better manage operations.
The course will teach participants how to use Microsoft Excel more competently to analyze data, create models, and generate insights. It will further train you in extending your skills to industry strength analytics using the R programming language with the point-and-click familiarity that you bring from working with Excel.
The course features interactive discussion, case studies, and lecture formats which focus on the use of Excel for analytics. Training is hands-on, with participants working alongside knowledgeable instructors, learning within the context of real-world, practical examples.
What you'll learn
- Understand and learn the formulas, functions, and tools in Excel and R to conduct basic to advanced data analysis and model building.
- Understand modeling, forecasting, and simulation using Excel and R.
- Learn advanced analytics using Multivariate Regression Models, Regression Trees, Cluster Analysis, and Choice models.
- Increase productivity by focusing on analyzing, rather than generating output.
- Discover multiple ways to visualize data to transform information into actionable insights.
- Communicate within your business in new, actionable ways.
Who will benefit
Business professionals who work with data and need to develop broader analytic capabilities to make faster and smarter business decisions and better understand data-based decision making to monitor, measure and manage performance.
Special Instructions / Notes:
Attendees must bring a laptop with Microsoft Office 2013 or newer installed. Participants will receive detailed instructions to download R and related packages.
|
Our courses emphasize high-quality instruction, interactive learning, and student-centered curricula.
All courses meet the same exacting standards for content excellence and expert instruction. |
|
