Tools for Exploratory Data Analysis in Business
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).
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- المدة 19 ساعات hours
- الطبع بواسطة University of Illinois Urbana-Champaign
-
Offered by
عن
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. The learning outcomes for this course include: 1. Development of an analytic mindset for approaching business problems. 2. The ability to appraise the value of datasets for addressing business problems using summary statistics and data visualizations. 3. The ability to competently operate business analytic software applications for exploratory data analysis.الوحدات
Course Orientation
-
3
Videos
-
4
Readings
-
1
Quiz
-
1
Plugin
3
Videos
- Course Introduction
- About Professor Jessen Hobson
- About Professor Ronald Guymon
4
Readings
- Syllabus
- About the Discussion Forums
- Software for Download
- Online Education at Gies College of Business
1
Quiz
- Orientation Quiz
About Your Classmates
-
1
Readings
-
1
Discussion
1
Discussions
- Getting to Know Your Classmates
1
Readings
- Updating Your Profile
Module 1 Information
-
1
Videos
-
2
Readings
1
Videos
- Module 1 Introduction
2
Readings
- Module 1 Overview
- Module 1 Transcript
Business Context
-
2
Videos
2
Videos
- Turning Business Data Into Business Insights
- Your Mind is The Most Important Tool
TECA Data Set
-
1
Videos
1
Videos
- Analytics Mindset: System 1 vs System 2
Business Analytics
-
2
Videos
2
Videos
- Inductive Versus Deductive Reasoning
- Let the Data Speak
Your Mind as a Tool
-
3
Videos
3
Videos
- Introduction to the Course Data Set: TECA
- Data Analytics Modeling Pipeline
- Business Analytics Key Terms
Module 1 Review
-
1
Videos
-
1
Assignment
1
Assignment
- Analytics Mindset: Quiz
1
Videos
- Module 1 Conclusion
Module 2 Information
-
1
Videos
-
3
Readings
1
Videos
- Module 2 Introduction
3
Readings
- Module 2 Overview
- Module 2 Transcript
- Files Used In Videos
Business Problem
-
2
Videos
2
Videos
- Data
- Business Problem
Introduction to Power BI
-
6
Videos
6
Videos
- Introduction to Power BI
- Installing Power BI
- ETL 1: Examine Data with Power Query Editor
- ET2: Dates and Calculated Columns
- ETL 3: Checking for and Eliminating Outliers
- ETL 4: Data Models and Joins
EDA with Power BI
-
5
Videos
5
Videos
- EDA 1: Univariate Plots for Numeric Data: Histograms and Boxplots
- EDA 2 - Plots for Categorical Data
- EDA 3: Filters, Slicers, and Drill Through
- EDA 4: Multivariate Plots: Scatter Plots and Line Plots
- EDA 5: Publishing a Power BI Report
Module 2 Review
-
1
Videos
-
1
Quiz
1
Videos
- Module 2 Conclusion
1
Quiz
- ETL and EDA Using PowerBI: Quiz
Module 3 Information
-
1
Videos
-
3
Readings
1
Videos
- Module 3 Introduction
3
Readings
- Module 3 Overview
- Module 3 Transcript
- Files Used in Videos
Business Problem
-
2
Videos
2
Videos
- Data
- Business Problem
Introduction to RStudio
-
2
Videos
2
Videos
- Introduction to RStudio
- Accessing and Installing R and RStudio
ETL with RStudio
-
7
Videos
7
Videos
- ETL with RStudio, Part 1a: Examine Data and Data Formats
- ETL with RStudio, Part 1b: Examine Data and Data Formats
- ETL with RStudio, Part 1c: Examine Data and Data Formats
- ETL with RStudio, Part 2: Date Formats
- ETL with RStudio, Part 3: Checking for and Eliminating Outliers
- ETL with RStudio, Part 4a: Data Models and Joins
- ETL with RStudio, Part 4b: Data Models and Joins
EDA with RStudio
-
7
Videos
7
Videos
- EDA with RStudio, Part 1a: Variable Types, Ggplot ingredients, Histogram (of a Continuous Variable)
- EDA with RStudio, Part 1b: Variable Types, Ggplot ingredients, Histogram (of a Continuous Variable)
- EDA with RStudio, Part 2a: Scatter Plot (continuous & continuous), Bar/column plot (discrete & continuous), Box plot (discrete & continuous), Violin plot (discrete & continuous)
- EDA with RStudio, Part 2b: Scatter Plot (continuous & continuous), Bar/column plot (discrete & continuous), Box plot (discrete & continuous), Violin plot (discrete & continuous)
- EDA with RStudio, Part 3 - Grouping Data, Summarizing Data, Bar/Column Plot (Discrete & Continuous), Line Graph (Discrete & Continuous)
- EDA with RStudio, Part 4a - Interpreting Realistic grouped Data, Line Plots, Bar Plots, Businesses Insights
- EDA with RStudio, Part 4b - Interpreting Realistic grouped Data, Line Plots, Bar Plots, Businesses Insights
Module 3 Review
-
1
Videos
-
1
Quiz
1
Videos
- Module 3 Conclusion
1
Quiz
- ETL and EDA Using RStudio: Quiz
Module 4 Information
-
1
Videos
-
4
Readings
1
Videos
- Module 4 Introduction
4
Readings
- Module 4 Overview
- Files Used In Videos
- Module 4 Transcript
- Download Alteryx
Business Problem
-
2
Videos
2
Videos
- Data
- Business Problem
Introduction to Alteryx
-
8
Videos
8
Videos
- Introduction to Alteryx
- Installing and Getting Started with Alteryx
- ETL 1 - Read in Data and Examine Data Quality
- ETL 2 - Dates and Calculated Columns
- ETL 3 - Outliers
- ETL 4 - Missing Values
- ETL 5 - Data Joins
- ETL 6 - Writing Data and Organizing the Workflow
EDA with Alteryx
-
4
Videos
4
Videos
- EDA 1 - Using the Field Summary Tool to Create Histograms
- EDA 2 - Interactive Charts: Box, Bar, Scatter
- EDA 3 - Summary Tables
- EDA 4 - Saving Plots and Tables to a Report
Module 4 Review
-
1
Videos
-
1
Quiz
-
1
PeerReview
1
Peer Review
- ETL and EDA Using R: Peer Reviewed Assignment
1
Videos
- Module 4 Conclusion
1
Quiz
- ETL and EDA Using Alteryx: Quiz
Course Conclusion
-
2
Videos
-
2
Readings
-
1
Discussion
-
1
Plugin
1
Discussions
- Reflection
2
Videos
- Course Conclusion
- Learn on Your Terms
2
Readings
- Congratulations on completing the course!
- Get Your Course Certificate
Auto Summary
Discover the essentials of processing business data to derive actionable insights with the "Tools for Exploratory Data Analysis in Business" course. Tailored for the Business & Management domain, this engaging program emphasizes the development of an analytic mindset, crucial for any data analyst. Learn to identify and address business problems through data analytics and gain hands-on experience with leading software platforms like PowerBI, Alteryx, and RStudio for conducting ETL (Extract, Transform, Load) and EDA (Exploratory Data Analysis) processes. Throughout the course, you will: 1. Cultivate an analytic approach to solving business problems. 2. Evaluate datasets using summary statistics and data visualizations. 3. Master the use of business analytic software for effective exploratory data analysis. Offered by Coursera, this foundational course spans approximately 1140 minutes of immersive learning. Flexible subscription options, including Starter and Professional plans, make it accessible to a wide range of learners. Whether you're just beginning your journey in business analytics or seeking to enhance your skill set, this course is designed to provide you with the tools and knowledge to excel.
Ronald Guymon
Gies College of Business, University of Illinois