Most popular programs
Trending now
Gain hands-on experience extracting, preparing, exploring, and analyzing data statistically and visually using features and tools native to Microsoft Excel.
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.
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
Senior Lecturer of Analytics and Information Systems and Co-Director for the Institute of Digital Enterprise at the Kelley School • Indiana University - Kelley School of Business
Teaching Professor in the Department of Operations and Decision Technologies • Indiana University - Kelley School of Business
Associate Department Chair - Operations and Decision Technologies, Teaching Professor, and Grant Thornton Scholar • Kelley School of Business Indiana University
For asynchronous content, a free copy of MS Excel is required. A free copy of Excel online can be acquired at Office.com by clicking on “Sign up for the free version of Office”. For the Live Sessions, a Windows copy of MS Excel 365 is required.
VERIFICATION ALERT for Platform-Based Analytics:
If you plan to take this course as part of the IU Kelley Master of Science in IT Management (MSITM) program, please know that this course will only count as a MICROMASTERS® course.
Only three of the MicroMasters® courses will count toward the 10-course MSITM degree. Therefore, do not enroll in this Platform-Based Analytics course if you have already successfully completed the Digital Ecosystem Infrastructure (DEI) MicroMasters® course.
If you have already completed or are currently completing your third MicroMasters® course, and have applied and been admitted to the full MSITM program, an alternative course to replace the Platform-Based Analytics will be offered once you matriculate into IU.
Please reach out to edXksb@indiana.edu with any questions.
Further explanation:
In our continuing effort to provide the most beneficial course sequencing and useful content to learners, we have switched two courses in our 10-course MSITM program:
As a result of the switch, students who have successfully completed the DEI course as part of the MicroMasters® program and plan on matriculating must be ready for matriculation by Fall 2023.
Who can take this course?
Unfortunately, learners residing in one or more of the following countries or regions will not be able to register for this course: Iran, Cuba and the Crimea region of Ukraine. While edX has sought licenses from the U.S. Office of Foreign Assets Control (OFAC) to offer our courses to learners in these countries and regions, the licenses we have received are not broad enough to allow us to offer this course in all locations. edX truly regrets that U.S. sanctions prevent us from offering all of our courses to everyone, no matter where they live.
Who can take this course?
Unfortunately, learners residing in one or more of the following countries or regions will not be able to register for this course: Iran, Cuba and the Crimea region of Ukraine. While edX has sought licenses from the U.S. Office of Foreign Assets Control (OFAC) to offer our courses to learners in these countries and regions, the licenses we have received are not broad enough to allow us to offer this course in all locations. edX truly regrets that U.S. sanctions prevent us from offering all of our courses to everyone, no matter where they live.