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

4 quizzes, 1 assignment

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 readings1 quiz1 assignment1 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

1 quiz

Orientation Quiz0 minutes

1 assignmentTotal 60 minutes

Analytics Mindset: Quiz60 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 quiz

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 quizTotal 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 quiz

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 quizTotal 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.