This course is part of the Business Analytics Specialization

4.9
stars
14 ratings

Jessen Hobson +1 more instructor

4,173 already enrolled

Offered By

Part of the Master of Business Administration (iMBA) degree

Learn More

Business Analytics SpecializationUniversity of Illinois at Urbana-Champaign

About this Course

32,055 recent views

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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 3 of 6 in the

Business Analytics Specialization

Beginner Level

Some prior experience using data in a business setting is helpful.

Approx. 18 hours to complete

English

Subtitles: English

What you will 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 will gain

R and RStudio
Data Cleansing and Exploration
Alteryx
Analytic Mindset
PowerBI

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 3 of 6 in the

Business Analytics Specialization

Beginner Level

Some prior experience using data in a business setting is helpful.

Approx. 18 hours to complete

English

Subtitles: English

Instructors

Instructor rating

5/5 (5 Ratings)

Jessen Hobson

Professor of Accountancy

Department of Accountancy

5,602 Learners

3 Courses

Ronald Guymon

Senior Lecturer of Accountancy

Accountancy

42,037 Learners

5 Courses

Offered by

University of Illinois at Urbana-Champaign

The University of Illinois at Urbana-Champaign is a world leader in research, teaching and public engagement, distinguished by the breadth of its programs, broad academic excellence, and internationally renowned faculty and alumni. Illinois serves the world by creating knowledge, preparing students for lives of impact, and finding solutions to critical societal needs.

Start working towards your Master's degree

This course is part of the 100% online Master of Business Administration (iMBA) from University of Illinois at Urbana-Champaign. If you are admitted to the full program, your courses count towards your degree learning.

Learn More

Syllabus - What you will learn from this course

Week

Week 1

3 hours to complete

Course Orientation and Module 1: Analytics Mindset

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

3 hours to complete

14 videos (Total 76 min), 6 readings, 2 quizzes

14 videos

Course Introduction4m

About Professor Jessen Hobson1m

About Professor Ronald Guymon2m

Learn on Your Terms30s

Module 1 Introduction3m

Turning Business Data Into Business Insights8m

Your Mind is The Most Important Tool5m

Analytics Mindset: System 1 vs System 210m

Inductive Versus Deductive Reasoning7m

Let the Data Speak6m

Introduction to the Course Data Set: TECA4m

Data Analytics Modeling Pipeline8m

Business Analytics Key Terms10m

Module 1 Conclusion2m

6 readings

Syllabus10m

About the Discussion Forums10m

Software for Download10m

Learn More About Flexible Learning Paths10m

Module 1 Overview10m

Module 1 Transcript10m

2 practice exercises

Orientation Quiz

Analytics Mindset: Quiz1h

Week

Week 2

4 hours to complete

Module 2: ETL and EDA Using PowerBI

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.

4 hours to complete

15 videos (Total 130 min), 3 readings, 1 quiz

15 videos

Module 2 Introduction4m

Data3m

Business Problem3m

Introduction to Power BI7m

Installing Power BI9m

ETL 1: Examine Data with Power Query Editor12m

ET2: Dates and Calculated Columns8m

ETL 3: Checking for and Eliminating Outliers14m

ETL 4: Data Models and Joins14m

EDA 1: Univariate Plots for Numeric Data: Histograms and Boxplots12m

EDA 2 - Univariate, Bivariate, and Multivariate Plots with Categorical9m

EDA 3: Filters, Slicers, and Drill Through11m

EDA 4: Multivariate Plots: Scatter Plots and Line Plots11m

EDA 5: Publishing a Power BI Report3m

Module 2 Conclusion3m

3 readings

Module 2 Overview10m

Module 2 Transcript10m

Files Used In Videos10m

1 practice exercise

ETL and EDA Using PowerBI: Quiz1h

Week

Week 3

4 hours to complete

Module 3: ETL and EDA Using RStudio

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

4 hours to complete

20 videos (Total 150 min), 3 readings, 1 quiz

20 videos

Module 3 Introduction5m

Data4m

Business Problem2m

Introduction to RStudio5m

Accessing and Installing R and RStudio5m

ETL with RStudio, Part 1a: Examine Data and Data Formats8m

ETL with RStudio, Part 1b: Examine Data and Data Formats7m

ETL with RStudio, Part 1c: Examine Data and Data Formats6m

ETL with RStudio, Part 2: Date Formats9m

ETL with RStudio, Part 3: Checking for and Eliminating Outliers12m

ETL with RStudio, Part 4a: Data Models and Joins8m

ETL with RStudio, Part 4b: Data Models and Joins12m

EDA with RStudio, Part 1a: Variable Types, Ggplot ingredients, Histogram (of a Continuous Variable)9m

EDA with RStudio, Part 1b: Variable Types, Ggplot ingredients, Histogram (of a Continuous Variable)4m

EDA with RStudio, Part 2a: Scatter Plot (continuous & continuous), Bar/column plot (discrete & continuous), Box plot (discrete & continuous), Violin plot (discrete & continuous)7m

EDA with RStudio, Part 2b: Scatter Plot (continuous & continuous), Bar/column plot (discrete & continuous), Box plot (discrete & continuous), Violin plot (discrete & continuous)7m

EDA with RStudio, Part 3 - Grouping Data, Summarizing Data, Bar/Column Plot (Discrete & Continuous), Line Graph (Discrete & Continuous)12m

EDA with RStudio, Part 4a - Interpreting Realistic grouped Data, Line Plots, Bar Plots, Businesses Insights7m

EDA with RStudio, Part 4b - Interpreting Realistic grouped Data, Line Plots, Bar Plots, Businesses Insights8m

Module 3 Conclusion4m

3 readings

Module 3 Overview10m

Module 3 Transcript10m

Files Used in Videos10m

1 practice exercise

ETL and EDA Using RStudio: Quiz1h

Week

Week 4

7 hours to complete

Module 4: ETL and EDA Using Alteryx

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.

7 hours to complete

18 videos (Total 124 min), 6 readings, 2 quizzes

18 videos

Module 4 Introduction4m

Data3m

Business Problem5m

Introduction to Alteryx6m

Installing and Getting Started with Alteryx8m

ETL 1 - Read in Data and Examine Data Quality17m

ETL 2 - Dates and Calculated Columns16m

ETL 3 - Outliers6m

ETL 4 - Missing Values5m

ETL 5 - Data Joins8m

ETL 6 - Writing Data and Organizing the Workflow9m

EDA 1 - Using the Field Summary Tool to Create Histograms5m

EDA 2 - Interactive Charts: Box, Bar, Scatter8m

EDA 3 - Summary Tables3m

EDA 4 - Saving Plots and Tables to a Report4m

Module 4 Conclusion3m

Course Conclusion3m

Gies Online Programs3m

6 readings

Module 4 Overview10m

Files Used In Videos10m

Module 4 Transcript10m

Download Alteryx10m

Congratulations10m

Get Your Course Certificate10m

1 practice exercise

ETL and EDA Using Alteryx: Quiz30m

Reviews

4.9

2 reviews

5 stars
93.33%
4 stars
6.66%

TOP REVIEWS FROM TOOLS FOR EXPLORATORY DATA ANALYSIS IN BUSINESS

by JSNov 9, 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!

View all reviews

About the Business Analytics Specialization

Our world has become increasingly digital, and business leaders need to make sense of the enormous amount of available data today. In order to make key strategic business decisions and leverage data as a competitive advantage, it is critical to understand how to draw key insights from this data. The Business Analytics specialization is targeted towards aspiring managers, senior managers, and business executives who wish to have a well-rounded knowledge of business analytics that integrates the areas of data science, analytics and business decision making.

The courses in this Specialization will focus on strategy, methods, tools, and applications that are widely used in business. Topics covered include: Data strategy at firms Reliable ways to collect, analyze, and visualize data–and utilize data in organizational decision making Understanding data modeling and predictive analytics at a high-level Learning basic methods of business analytics by working with data sets and tools such as Power BI, Alteryx, and RStudio Learning to make informed business decisions via analytics across key functional areas in business such as finance, marketing, retail & supply chain management, and social media to enhance profitability and competitiveness.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions? Visit the Learner Help Center.

Tools for Exploratory Data Analysis in Business