Platform-Based Analytics
Kelley Executive Education Programs
Gain hands-on experience extracting, preparing, exploring, and analyzing data statistically and visually using features and tools native to Microsoft Excel.
About this Course
This course will be retired. In an ever-growing digital world, the need for strong data analysis skills is at the forefront of every business function, along with the ability to accurately describe and interpret analytical findings. This course will center on foundational concepts of data analysis, tools for working with data, and strategies for communicating results by utilizing a hands-on teaching approach. Topics include approaching data sets with a critical eye, basic statistical and visual analysis, formatting visuals for interpretation, storytelling with data, and an introduction to spreadsheet modeling. Learn from renowned Kelley School of Business faculty with combined decades of teaching and analysis experience. This course will provide learners with practical skills to support their data analysis and decision-making needs.
What You'll Learn
- Define exploratory, explanatory, prescriptive, and predictive analytics
- Import data into spreadsheets from external sources
- Cleanse data using functions native to Microsoft Excel
- Summarize data using basic descriptive statistics and statistical charts
- Communicate analysis findings using appropriate data visualization selections and formatting
- Develop simple dashboards to answer business questions
- Explore the foundations of spreadsheet modeling
Instructors
Taryn Malher
Senior Lecturer of Analytics and Information Systems and Co-Director for the Institute of Digital Enterprise at the Kelley School
Eric Kinser
Teaching Professor in the Department of Operations and Decision Technologies
Kari A. Johnson
Associate Department Chair - Operations and Decision Technologies, Teaching Professor, and Grant Thornton Scholar