This course is part of the Business Analytics Specialization

4.8
stars
33 ratings

Ronald Guymon +1 more instructor

7,110 already enrolled

Offered By

Make progress toward the Master of Business Administration (iMBA) degree

Learn More

Business Analytics SpecializationUniversity of Illinois at Urbana-Champaign

About this Course

17,216 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.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 3 of 6 in the

Business Analytics Specialization

Beginner Level

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

Approx. 17 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

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.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 3 of 6 in the

Business Analytics Specialization

Beginner Level

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

Approx. 17 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructors

Instructor rating

4.85/5 (8 Ratings)

Ronald Guymon

Senior Lecturer of Accountancy

Accountancy

55,484 Learners

5 Courses

Gies College of Business, University of Illinois

73,457 Learners

21 Courses

Offered by

University of Illinois at Urbana-Champaign

Get a head start on your degree

This course is part of the Master of Business Administration (iMBA) from University of Illinois at Urbana-Champaign. If you are admitted to the full program, your coursework will count towards your degree learning and all of your progress will transfer with you.

Learn More

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

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week1

Week 1

3 hours to complete

Course Orientation and Module 1: Analytics Mindset

3 hours to complete

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

14 videos

Course Introduction4mAbout Professor Jessen Hobson1mAbout Professor Ronald Guymon2mLearn on Your Terms30sModule 1 Introduction3mTurning Business Data Into Business Insights8mYour Mind is The Most Important Tool5mAnalytics Mindset: System 1 vs System 210mInductive Versus Deductive Reasoning7mLet the Data Speak6mIntroduction to the Course Data Set: TECA4mData Analytics Modeling Pipeline8mBusiness Analytics Key Terms10mModule 1 Conclusion2m

6 readings

Syllabus10mAbout the Discussion Forums10mSoftware for Download10mLearn More About Flexible Learning Paths10mModule 1 Overview10mModule 1 Transcript10m

2 practice exercises

Orientation QuizAnalytics Mindset: Quiz1h

Week2

Week 2

4 hours to complete

Module 2: ETL and EDA Using PowerBI

4 hours to complete

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

15 videos

Module 2 Introduction4mData3mBusiness Problem3mIntroduction to Power BI7mInstalling Power BI9mETL 1: Examine Data with Power Query Editor12mET2: Dates and Calculated Columns8mETL 3: Checking for and Eliminating Outliers14mETL 4: Data Models and Joins14mEDA 1: Univariate Plots for Numeric Data: Histograms and Boxplots12mEDA 2 - Univariate, Bivariate, and Multivariate Plots with Categorical9mEDA 3: Filters, Slicers, and Drill Through11mEDA 4: Multivariate Plots: Scatter Plots and Line Plots11mEDA 5: Publishing a Power BI Report3mModule 2 Conclusion3m

3 readings

Module 2 Overview10mModule 2 Transcript10mFiles Used In Videos10m

1 practice exercise

ETL and EDA Using PowerBI: Quiz1h

Week3

Week 3

4 hours to complete

Module 3: ETL and EDA Using RStudio

4 hours to complete

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

20 videos

Module 3 Introduction5mData4mBusiness Problem2mIntroduction to RStudio5mAccessing and Installing R and RStudio5mETL with RStudio, Part 1a: Examine Data and Data Formats8mETL with RStudio, Part 1b: Examine Data and Data Formats7mETL with RStudio, Part 1c: Examine Data and Data Formats6mETL with RStudio, Part 2: Date Formats9mETL with RStudio, Part 3: Checking for and Eliminating Outliers12mETL with RStudio, Part 4a: Data Models and Joins8mETL with RStudio, Part 4b: Data Models and Joins12mEDA with RStudio, Part 1a: Variable Types, Ggplot ingredients, Histogram (of a Continuous Variable)9mEDA with RStudio, Part 1b: Variable Types, Ggplot ingredients, Histogram (of a Continuous Variable)4mEDA with RStudio, Part 2a: Scatter Plot (continuous & continuous), Bar/column plot (discrete & continuous), Box plot (discrete & continuous), Violin plot (discrete & continuous)7mEDA with RStudio, Part 2b: Scatter Plot (continuous & continuous), Bar/column plot (discrete & continuous), Box plot (discrete & continuous), Violin plot (discrete & continuous)7mEDA with RStudio, Part 3 - Grouping Data, Summarizing Data, Bar/Column Plot (Discrete & Continuous), Line Graph (Discrete & Continuous)12mEDA with RStudio, Part 4a - Interpreting Realistic grouped Data, Line Plots, Bar Plots, Businesses Insights7mEDA with RStudio, Part 4b - Interpreting Realistic grouped Data, Line Plots, Bar Plots, Businesses Insights8mModule 3 Conclusion4m

3 readings

Module 3 Overview10mModule 3 Transcript10mFiles Used in Videos10m

1 practice exercise

ETL and EDA Using RStudio: Quiz1h

Week4

Week 4

7 hours to complete

Module 4: ETL and EDA Using Alteryx

7 hours to complete

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

18 videos

Module 4 Introduction4mData3mBusiness Problem5mIntroduction to Alteryx6mInstalling and Getting Started with Alteryx8mETL 1 - Read in Data and Examine Data Quality17mETL 2 - Dates and Calculated Columns16mETL 3 - Outliers6mETL 4 - Missing Values5mETL 5 - Data Joins8mETL 6 - Writing Data and Organizing the Workflow9mEDA 1 - Using the Field Summary Tool to Create Histograms5mEDA 2 - Interactive Charts: Box, Bar, Scatter8mEDA 3 - Summary Tables3mEDA 4 - Saving Plots and Tables to a Report4mModule 4 Conclusion3mCourse Conclusion3mGies Online Programs3m

6 readings

Module 4 Overview10mFiles Used In Videos10mModule 4 Transcript10mDownload Alteryx10mCongratulations10mGet Your Course Certificate10m

1 practice exercise

ETL and EDA Using Alteryx: Quiz30m

Reviews

4.8

8 reviews

5 stars
87.87%
4 stars
9.09%
1 star
3.03%

TOP REVIEWS FROM TOOLS FOR EXPLORATORY DATA ANALYSIS IN BUSINESS

by YEMar 3, 2023

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

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.

Build employee skills, drive business results

Discover Coursera for Business

Tools for Exploratory Data Analysis in Business

About this Course

What you will learn

Skills you will gain