Tools for Exploratory Data Analysis in Business

Tools for Exploratory Data Analysis in Business

This course is part of Business Analytics Specialization

Gies College of Business, University of Illinois

Instructors: Ronald Guymon

What you'll learn

Development of an analytic mindset for approaching business problems.
The ability to appraise the value of datasets for addressing business problems using summary statistics and data visualizations.
Competence in operating business analytic software applications for exploratory data analysis.

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

5 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your subject-matter expertise

This course is part of the Business Analytics Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

This course introduces several tools for processing business data to obtain actionable insight. The most important tool is the mind of the data analyst. Accordingly, in this course, you will explore what it means to have an analytic mindset. You will also practice identifying business problems that can be answered using data analytics. You will then be introduced to various software platforms to extract, transform, and load (ETL) data into tools for conducting exploratory data analytics (EDA). Specifically, you will practice using PowerBI, Alteryx, and RStudio to conduct the ETL and EDA processes.

Your mind is the most important tool. Prepare your mind by learning about various mindsets and terms for approaching business analytic problems.

What's included

13 videos7 readings2 assignments1 discussion prompt1 plugin

13 videosTotal 76 minutes

Course Introduction4 minutesPreview module
About Professor Jessen Hobson1 minute
About Professor Ronald Guymon3 minutes
Module 1 Introduction3 minutes
Turning Business Data Into Business Insights8 minutes
Your Mind is The Most Important Tool5 minutes
Analytics Mindset: System 1 vs System 210 minutes
Inductive Versus Deductive Reasoning7 minutes
Let the Data Speak6 minutes
Introduction to the Course Data Set: TECA4 minutes
Data Analytics Modeling Pipeline8 minutes
Business Analytics Key Terms10 minutes
Module 1 Conclusion2 minutes

7 readingsTotal 70 minutes

Syllabus10 minutes
About the Discussion Forums10 minutes
Software for Download10 minutes
Online Education at Gies College of Business10 minutes
Updating Your Profile10 minutes
Module 1 Overview10 minutes
Module 1 Transcript10 minutes

2 assignmentsTotal 60 minutes

Analytics Mindset: Quiz60 minutes
Orientation Quiz0 minutes

1 discussion promptTotal 10 minutes

Getting to Know Your Classmates10 minutes

1 pluginTotal 15 minutes

Welcome! Please Tell Us About Yourself15 minutes

PowerBI is great for both data assembly and visualization. In this module we will use PowerBI to prepare the Teca data for analysis, and then visually explore that data with various charts.

What's included

15 videos3 readings1 assignment

15 videosTotal 130 minutes

Module 2 Introduction4 minutesPreview module
Data3 minutes
Business Problem3 minutes
Introduction to Power BI7 minutes
Installing Power BI9 minutes
ETL 1: Examine Data with Power Query Editor12 minutes
ET2: Dates and Calculated Columns8 minutes
ETL 3: Checking for and Eliminating Outliers14 minutes
ETL 4: Data Models and Joins14 minutes
EDA 1: Univariate Plots for Numeric Data: Histograms and Boxplots12 minutes
EDA 2 - Plots for Categorical Data9 minutes
EDA 3: Filters, Slicers, and Drill Through11 minutes
EDA 4: Multivariate Plots: Scatter Plots and Line Plots11 minutes
EDA 5: Publishing a Power BI Report3 minutes
Module 2 Conclusion3 minutes

3 readingsTotal 30 minutes

Module 2 Overview10 minutes
Module 2 Transcript10 minutes
Files Used In Videos10 minutes

1 assignmentTotal 60 minutes

ETL and EDA Using PowerBI: Quiz60 minutes

Using R in RStudio to load, transform, clean, and explore data

What's included

20 videos3 readings1 assignment

20 videosTotal 150 minutes

Module 3 Introduction5 minutesPreview module
Data4 minutes
Business Problem2 minutes
Introduction to RStudio5 minutes
Accessing and Installing R and RStudio5 minutes
ETL with RStudio, Part 1a: Examine Data and Data Formats8 minutes
ETL with RStudio, Part 1b: Examine Data and Data Formats7 minutes
ETL with RStudio, Part 1c: Examine Data and Data Formats6 minutes
ETL with RStudio, Part 2: Date Formats9 minutes
ETL with RStudio, Part 3: Checking for and Eliminating Outliers12 minutes
ETL with RStudio, Part 4a: Data Models and Joins8 minutes
ETL with RStudio, Part 4b: Data Models and Joins12 minutes
EDA with RStudio, Part 1a: Variable Types, Ggplot ingredients, Histogram (of a Continuous Variable)9 minutes
EDA with RStudio, Part 1b: Variable Types, Ggplot ingredients, Histogram (of a Continuous Variable)4 minutes
EDA with RStudio, Part 2a: Scatter Plot (continuous & continuous), Bar/column plot (discrete & continuous), Box plot (discrete & continuous), Violin plot (discrete & continuous)7 minutes
EDA with RStudio, Part 2b: Scatter Plot (continuous & continuous), Bar/column plot (discrete & continuous), Box plot (discrete & continuous), Violin plot (discrete & continuous)7 minutes
EDA with RStudio, Part 3 - Grouping Data, Summarizing Data, Bar/Column Plot (Discrete & Continuous), Line Graph (Discrete & Continuous)12 minutes
EDA with RStudio, Part 4a - Interpreting Realistic grouped Data, Line Plots, Bar Plots, Businesses Insights7 minutes
EDA with RStudio, Part 4b - Interpreting Realistic grouped Data, Line Plots, Bar Plots, Businesses Insights8 minutes
Module 3 Conclusion4 minutes

3 readingsTotal 30 minutes

Module 3 Overview10 minutes
Module 3 Transcript10 minutes
Files Used in Videos10 minutes

1 assignmentTotal 60 minutes

ETL and EDA Using RStudio: Quiz60 minutes

Alteryx is great for visually documenting the data analytic workflow. In this module we will use Alteryx to assemble the Teca data and explore it with plots and tables.

What's included

18 videos6 readings1 assignment1 peer review1 discussion prompt1 plugin

18 videosTotal 120 minutes

Module 4 Introduction4 minutesPreview module
Data3 minutes
Business Problem5 minutes
Introduction to Alteryx6 minutes
Installing and Getting Started with Alteryx8 minutes
ETL 1 - Read in Data and Examine Data Quality17 minutes
ETL 2 - Dates and Calculated Columns16 minutes
ETL 3 - Outliers6 minutes
ETL 4 - Missing Values5 minutes
ETL 5 - Data Joins8 minutes
ETL 6 - Writing Data and Organizing the Workflow9 minutes
EDA 1 - Using the Field Summary Tool to Create Histograms5 minutes
EDA 2 - Interactive Charts: Box, Bar, Scatter8 minutes
EDA 3 - Summary Tables3 minutes
EDA 4 - Saving Plots and Tables to a Report4 minutes
Module 4 Conclusion3 minutes
Course Conclusion3 minutes
Learn on Your Terms0 minutes

6 readingsTotal 60 minutes

Module 4 Overview10 minutes
Files Used In Videos10 minutes
Module 4 Transcript10 minutes
Download Alteryx10 minutes
Congratulations on completing the course!10 minutes
Get Your Course Certificate10 minutes

1 assignmentTotal 30 minutes

ETL and EDA Using Alteryx: Quiz30 minutes

1 peer reviewTotal 180 minutes

ETL and EDA Using R: Peer Reviewed Assignment180 minutes

1 discussion promptTotal 10 minutes

Reflection10 minutes

1 pluginTotal 15 minutes

How Was the Course?15 minutes

Instructors

Instructor ratings

4.4 (11 ratings)

Ronald Guymon

University of Illinois Urbana-Champaign

5 Courses79,452 learners

Offered by

University of Illinois Urbana-Champaign

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

4.8

48 reviews

5 stars
87.50%
4 stars
10.41%
3 stars
0%
2 stars
0%
1 star
2.08%

Showing 3 of 48

Reviewed on Nov 8, 2021

Brilliant stuff from the team. Thanks for Alteryx tool explanation. Unfortunately cannot pay for the course as have funds invested in other courses. Cheers!

Reviewed on Mar 2, 2023

Great course, I appreciate both instructors for this informative course! Thank you

View more reviews