UIUC - Tools for Exploratory Data Analysis in Business
- Offered byCoursera
Tools for Exploratory Data Analysis in Business at Coursera Overview
Duration | 17 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
Tools for Exploratory Data Analysis in Business at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Beginner Level Some prior experience using data in a business setting is helpful.
- Approx. 17 hours to complete
- English Subtitles: English
Tools for Exploratory Data Analysis in Business at Coursera Course details
- 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 for conducting 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.
Tools for Exploratory Data Analysis in Business at Coursera Curriculum
Course Orientation and Module 1: Analytics Mindset
Course Introduction
About Professor Jessen Hobson
About Professor Ronald Guymon
Module 1 Introduction
Turning Business Data Into Business Insights
Your Mind is The Most Important Tool
Analytics Mindset: System 1 vs System 2
Inductive Versus Deductive Reasoning
Let the Data Speak
Introduction to the Course Data Set: TECA
Data Analytics Modeling Pipeline
Business Analytics Key Terms
Module 1 Conclusion
Syllabus
About the Discussion Forums
Module 1 Overview
Module 1 Transcript
Orientation Quiz
Module 1 Quiz
Module 2: ETL and EDA Using PowerBI
Module 2 Introduction
Data
Business Problem
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 1: Univariate Plots for Numeric Data: Histograms and Boxplots
EDA 2 - Univariate, Bivariate, and Multivariate Plots with Categorical
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 Conclusion
Module 2 Overview
Module 2 Transcript
Files Used In Videos
Module 2 Quiz
Module 3: ETL and EDA Using RStudio
Module 3 Introduction
Data
Business Problem
Introduction to RStudio
Accessing and Installing R and RStudio
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, 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 Conclusion
Module 3 Overview
Module 3 Reading
Module 3 Transcript
Module 3 Quiz
Module 4: ETL and EDA Using Alteryx
Module 4 Introduction
Data
Business Problem
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 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 Conclusion
Course Conclusion
Gies Online Programs
Module 4 Overview
Files Used In Videos
Module 4 Transcript
Congratulations
Module 4 Quiz
Tools for Exploratory Data Analysis in Business at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?