Explore

Exploring and Producing Data for Business Decision Making

Approx. 23 hours to complete

Save Course

Go to Course

Course Summary

Learn how to use data to drive business decisions in this comprehensive course. Gain skills in data analysis, visualization, and communication to make strategic decisions that lead to business success.

Key Learning Points

Learn how to analyze and interpret data to make informed business decisions
Develop skills in data visualization to communicate insights effectively
Understand the importance of data-driven decision making in business
Explore case studies and real-world examples of successful data-driven businesses

Job Positions & Salaries of people who have taken this course might have

Data Analyst
- USA: $62,453
- India: ₹6,00,000
- Spain: €32,000
Business Analyst
- USA: $70,170
- India: ₹8,00,000
- Spain: €36,000
Data Scientist
- USA: $113,309
- India: ₹10,00,000
- Spain: €50,000

Learning Outcomes

Develop skills in data analysis and visualization
Understand the importance of data-driven decision making
Apply data analysis and visualization techniques to real-world business scenarios

Prerequisites or good to have knowledge before taking this course

Basic knowledge of statistics and Excel
Access to a computer with Excel and Tableau installed

Course Difficulty Level

Intermediate

Course Format

Self-paced
Video lectures
Quizzes and assignments

Similar Courses

Data-Driven Decision Making
Data Visualization
Business Analytics

Related Education Paths

Related Books

Description

This course provides an analytical framework to help you evaluate key problems in a structured fashion and will equip you with tools to better manage the uncertainties that pervade and complicate business processes. Specifically, you will learn how to summarize data and learn concepts of frequency, normal distribution, statistical studies, sampling, and confidence intervals.

While you will be introduced to some of the science of what is being taught, the focus will be on applying the methodologies. This will be accomplished through the use of Excel and data sets from different disciplines, allowing you to see the use of statistics in a range of settings. The course will focus not only on explaining these concepts, but also understanding and interpreting the results obtained. You will be able to: • Summarize large data sets in graphical, tabular, and numerical forms • Understand the significance of proper sampling and why one can rely on sample information • Understand why normal distribution can be used in a wide range of settings • Use sample information to make inferences about the population with a certain level of confidence about the accuracy of the estimations • Use Excel for statistical analysis This course is part of Gies College of Business’ suite of online programs, including the iMBA and iMSM. Learn more about admission into these programs and explore how your Coursera work can be leveraged if accepted into a degree program at https://degrees.giesbusiness.illinois.edu/idegrees/.

Outline

Course Orientation
Welcome to Exploring and Producing Data for Business Decision Making!
Learn on Your Terms
Excel Data Analysis Toolpak
Syllabus
ePub
About the Discussion Forums
Glossary
Learn More About Flexible Learning Paths
Using Excel for this Course
Updating Your Profile
Orientation Quiz

Module 1: Introduction and Summarizing Data
1-1.1. Basic Terminology
1-2.1. Summarizing Data: Frequency Tables
1-2.2. Frequency Tables in Excel: Quantitative Data
1-2.3. Frequency Tables in Excel: Qualitative Data
1-2.4. Presenting Frequency Tables as a Bar Graph in Excel
1-3.1. Summarizing Data: Histograms
1-3.2. Histograms in Excel
1-4.1. Summarizing Data: Pie Charts
1-4.2. Pie Charts in Excel
1-5.1. Summarizing Data: Scatter Plots
1-5.2. Scatter Plots in Excel
Module 1 Overview
Module 1 Readings
Lesson 1-1 Practice Quiz
Lesson 1-2 Practice Quiz
Lesson 1-3 Practice Quiz
Lesson 1-4 Practice Quiz
Lesson 1-5 Practice Quiz
Module 1 Quiz

Module 2: Descriptive Statistics and Probability Distributions
2-1.1. Measures of Central Tendencies
2-1.2. Mean and Median in Excel
2-2.1. Measures of Dispersion
2-2.2. Standard Deviation in Excel
2-3.1. Percentiles and Z-Score
2-3.2. Z-Score in Excel
2-4.1. Discrete and Continuous Random Variables
2-4.2. Expected Value in Excel
2-5.1. Normal Distribution
2-5.2. Normal Distribution in Excel
2-5.3. Standard Normal Distribution in Excel
2-5.4. "Less Than" in Excel
2-5.5. "Greater Than" in Excel
2-5.6. "Between Values" in Excel
2-5.7. Finding Z for a Given Probability (INV) in Excel
2-6.1. Standard Normal Distribution Table
Module 2 Overview
Module 2 Readings
Lesson 2-1 Practice Quiz
Lesson 2-2 Practice Quiz
Lesson 2-3 Practice Quiz
Lesson 2-4 Practice Quiz
Lesson 2-5 Practice Quiz
Lesson 2-6 Practice Quiz
Module 2 Quiz

Module 3: Sampling and Central Limit Theorem
3-1.1. Producing Data
3-2.1. Sampling
3-2.2 Sampling Function in Excel
3-3.1. Central Limit Theorem and Sampling Means
3-3.2. Animating the Central Limit Theorem
3-3.3. Sampling Distribution and Empirical Rule in Excel
3-4.1. Central Limit Theorem – Sampling Proportion
Module 3 Overview
Module 3 Readings
Lesson 3-1 Practice Quiz
Lesson 3-2 Practice Quiz
Lesson 3-3 Practice Quiz
Lesson 3-4 Practice Quiz
Module 3 Quiz

Module 4: Inference
4-1.1. Confidence Interval Basics
4-2.1. Confidence Interval for Means
4-2.2. Confidence Interval for Mean in Excel
4-2.3. Impact of Confidence Level Illustrated in Excel
4-3.1. Confidence Interval for Population Proportion
4-3.2. Confidence Interval for Population Proportion in Excel
4-3.3. Confidence Interval Animation in Excel
4-3.4. Starting Salary Example in Excel
4-4.1. Sample Size
4-4.2. Sample Size Proportion in Excel
4-4.3. Sample Size Mean in Excel
4-4.4. Sample Size Effect in Excel
Gies Online Programs
Module 4 Overview
Module 4 Readings
Congratulations!
Get Your Course Certificate
Lesson 4-1 Practice Quiz
Lesson 4-2 Practice Quiz
Lesson 4-3 Practice Quiz
Lesson 4-4 Practice Quiz
Module 4 Quiz

Summary of User Reviews

Discover the world of business data with this course on Coursera. Students have praised the course for its insightful and practical content. Overall, the course has received positive reviews for its comprehensive approach to business data.

Key Aspect Users Liked About This Course

The course is praised for its practical approach to business data.

Pros from User Reviews

Insightful and practical content.
Comprehensive coverage of business data.
Great for beginners and those with basic knowledge.
Easy to understand explanations and examples.
Good balance of theory and practice.

Cons from User Reviews

Some users found the course to be too basic.
The course may not be suitable for advanced learners.
The course does not cover more advanced topics.
Some users found the course to be too slow-paced.
Limited interaction with instructors.

Recommended for you

Data Science and Machine Learning with Python and Libraries

Learn Data Science and Machine Learning with Python and Libraries such as Numpy, Matplotlib, Pandas and much more WHAT IS DATA SCIENCE...

Save Course

Accounting–Financial Accounting Total-Beginners to Advanced

Including well over 100 hours of content, e-book (EPUB, MOBI, PDF) ,Excel worksheet, & PDF files, this is comprehensive Recently updated with A LOT of added content....

Save Course

A Practical Guide to TIBCO Spotfire for Business Analytics

Step by Step Guide to Spotfire Dashboard for Business Analytics with Data Visualizations & Analysis What is Spotfire? Data Table Management & Relationships...

Save Course