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
There are 6 modules in this course
One of the skills that characterizes great business data analysts is the ability to communicate practical implications of quantitative analyses to any kind of audience member. Even the most sophisticated statistical analyses are not useful to a business if they do not lead to actionable advice, or if the answers to those business questions are not conveyed in a way that non-technical people can understand.
In this course you will learn how to become a master at communicating business-relevant implications of data analyses. By the end, you will know how to structure your data analysis projects to ensure the fruits of your hard labor yield results for your stakeholders. You will also know how to streamline your analyses and highlight their implications efficiently using visualizations in Tableau, the most popular visualization program in the business world. Using other Tableau features, you will be able to make effective visualizations that harness the human brain’s innate perceptual and cognitive tendencies to convey conclusions directly and clearly. Finally, you will be practiced in designing and persuasively presenting business “data stories” that use these visualizations, capitalizing on business-tested methods and design principles.
The Coursera Specialization: Excel to MySQL: Analytic Techniques for Business, is about how 'Big Data' interacts with business, and how to use data analytics to create value for businesses. This specialization consists of four courses and a final Capstone Project, where you will apply your skills to a real-world business process. You will learn to perform sophisticated data-analysis functions using powerful software tools such as Microsoft Excel, Tableau, and MySQL. To learn more, watch the video and review the specialization overview document we provided.
In the third course of the specialization: Data Visualization and Communication with Tableau, you will learn how to communicate business-relevant implications of data analyses.
Specifically, you will:
~craft the right questions to ensure your analysis projects succeed
~leverage questions to design logical and structured analysis plans
~create the most important graphs used in business analysis and transform data in Tableau
~design business dashboards with Tableau
~tell stories with data
~design effective slide presentations to showcase your data story
~deliver compelling business presentations
By the end of this course, you will know how to structure your data analysis projects to ensure the fruits of your hard labor yield results for your stakeholders. You will also know how to streamline your analyses and highlight their implications efficiently using visualizations in Tableau, the most popular visualization program in the business world. Using other Tableau features, you will be able to make effective visualizations that harness the human brain’s innate perceptual and cognitive tendencies to convey conclusions directly and clearly. Finally, you will be practiced in designing and persuasively presenting business “data stories” that use these visualizations, capitalizing on business-tested methods and design principles by completing a final peer assessed project recommending a business process change.
To get started, please begin with the video 'About This Specialization.'
I hope you enjoy this week's materials!
What's included
2 videos5 readings
Show info about module content
2 videos•Total 9 minutes
About this Specialization•4 minutes
Welcome to the Course!•4 minutes
5 readings•Total 45 minutes
Specialization Overview•10 minutes
Report a problem with the course•5 minutes
Course Overview•10 minutes
Special Thanks!•10 minutes
About the Course Team•10 minutes
Asking The "Right Questions"
Module 2•2 hours to complete
Module details
Welcome! This week, you will learn how data analysts ask the right questions to ensure project success. By the end of this week, you will be able to:
~Craft the right questions to ensure your analysis projects succeed
~Leverage questions to design logical and structured analysis plans
Remember to refer back to the Additional Resources reading: Identifying and Eliciting Information from Stakeholders. In addition, you will complete a graded quiz. As always, if you have any questions, post them to the Discussions Forum. To get started, please begin with the video “Tips for Becoming a Data Analyst.” I hope you enjoy this week's materials!
What's included
8 videos2 readings1 assignment
Show info about module content
8 videos•Total 60 minutes
Tips for Becoming a Data Analyst•9 minutes
Asking the Right Questions•5 minutes
Rock Projects•6 minutes
S.M.A.R.T. Objectives•10 minutes
Listening to Stakeholders During Elicitation•9 minutes
Stakeholder Expectations Matter•8 minutes
Using SPAPs to Structure Your Thinking, Part 1•7 minutes
Using SPAPs to Structure Your Thinking, Part 2•7 minutes
2 readings•Total 20 minutes
Week 1 Additional Resources•10 minutes
SPAP Graphic•10 minutes
1 assignment•Total 30 minutes
Week 1 Quiz•30 minutes
Data Visualization with Tableau
Module 3•8 hours to complete
Module details
Welcome to week 2! This week you'll install Tableau to learn how visualizing data helps you figure out what your data mean efficiently, and in the process of doing so, helps you narrow in on what factors you should take into consideration in your statistical models or predictive algorithms. Over the next two weeks, we’re going to learn how to use Tableau to implement this type of visualization and to help you find, and communicate, answers to business questions, as well as work with the Tableau functions that all data analysts should be familiar with. In addition, through a series of practice exercises, you will use a data set to do example analyses and to answer specific sample questions about salaries for certain data-related jobs across the United State. Then for graded exercises, you will use a different data set to work out analyses and questions that will require you to directly apply the Tableau skills you have acquired through practice. By the end of this week, you will be able to:
~Create the most important graphs used in business analysis and transform data in Tableau
Once you have watched the "Why Tableau" video, and installed the software, remember to refer back to the Salary Data Set and to the Dognition Data Set resources posted on the course site this week. You will also complete a graded quiz at the end of the week. As always, if you have any questions, post them to the Discussions Forum. To get started, please begin with the video “Use Data Visualization to Drive Your Analysis" and then review the "Written Instructions to install Tableau Desktop.
I hope you enjoy this week's materials!
What's included
16 videos6 readings1 assignment
Show info about module content
16 videos•Total 130 minutes
Use Data Visualization to Drive Your Analysis•2 minutes
Why Tableau?•8 minutes
Meet Your Salary Data•3 minutes
Meet Your Dognition Data•12 minutes
Our Analysis Plan•1 minute
Salaries of Data-Related Jobs: Your First Graph•12 minutes
Formatting and Exporting Your First Graph•7 minutes
Digging Deeper Using the Rows and Columns Shelves•13 minutes
Understanding the Marks Card•11 minutes
Removing Outliers Using Scatterplot and Filtering and Groups•14 minutes
Analyzing Data-Related Salaries in Different States Using Filtering and Groups•8 minutes
When to Use Line Graphs•3 minutes
Dates as Hierarchical Dimensions or Measures•9 minutes
Analyzing Data-Related Salaries Over Time Using Date Hierarchies•8 minutes
Analyzing Data-Related Salaries Over Time Using Trend Lines•9 minutes
Analysing Data-Related Salaries Over Time Using Box Plots•10 minutes
6 readings•Total 230 minutes
Tableau Instructions•10 minutes
Salary Data Set, Description, and Analysis Plan•10 minutes
Dognition Data Set, Description, and Analysis Plan•10 minutes
The Effects of Outliers Video•10 minutes
Introduction to Linear Regression•10 minutes
Week 2 Practice Exercises•180 minutes
1 assignment•Total 120 minutes
Week 2 Quiz•120 minutes
Dynamic Data Manipulation and Presentation in Tableau
Module 4•7 hours to complete
Module details
Welcome to week 3! This week you'll continue learning how to use Tableau to answer data analysis questions. You will learn how to use Tableau to both find, and eventually communicate answers to business questions. You'll learn about the process of elicitation, and learn how to ensure your data story is not undermined by overgeneralization or bias and how to format your data charts to begin creating a compelling data story. By the end of this week, you will be able to:
~Write calculations and equations in Tableau
~Publish online business dashboards with Tableau
Remember to refer to the additional resources for this week: “Examples of Tableau Dashboards and Stories” and "Using Tableau Dashboards When You Don't Have To." You will also complete a graded quiz. As always, if you have any questions, post them to the Discussions Forums. To get started, please begin with the video “Customizing and Sharing New Data in Tableau.” I hope you enjoy this week's materials!
What's included
12 videos3 readings1 assignment
Show info about module content
12 videos•Total 98 minutes
Customizing and Sharing New Data in Tableau•3 minutes
Tableau Calculation Types•4 minutes
How to Write Calculations•11 minutes
Calculations that Make Filtering More Efficient•8 minutes
Identifying Companies that Pay Less than the Prevailing Wage•9 minutes
Blending Price Parity Data with Our Salary Data•5 minutes
Adjusting Data-related Salaries for Cost of Living•10 minutes
Calculating Which States Have the Top Adjusted Salaries within Job Subcategories•10 minutes
Using Parameters to Define Top States•7 minutes
Calculating Which Companies Have the Top Adjusted Salaries within Job Subcategories•8 minutes
Designing a Dashboard to Determine Where You should Apply for Data-related Job•12 minutes
Visual Story Points in Tableau•10 minutes
3 readings•Total 200 minutes
Data Sets Needed in Week 3•10 minutes
Week 3 Additional Resources: Examples of Tableau Dashboards and Stories•10 minutes
Week 3 Practice Exercises•180 minutes
1 assignment•Total 120 minutes
Week 3 Quiz•120 minutes
Your Communication Toolbox: Visualizations, Logic, and Stories
Module 5•4 hours to complete
Module details
Welcome to week 4! This week you will become a master at getting people to agree with your data-driven business recommendations as you learn to deliver a compelling business presentation. You’ll learn about the insight from the intersection of visualization science and decision science, and what this means for you as a data analyst, who seeks to design a compelling and effective business presentations. If you intend to affect people’s decisions, you need to influence where they look. This week we will review a set of tools and concepts you can use to optimize your visualizations and your presentation style. You will soon be a master at getting people to agree with your data-driven business recommendations! By the end of this week, you will be able to:
~Tell stories with data
~Design effective slide presentations to showcase your data story
~Deliver compelling business presentations
Remember to refer back to the Study Guide: Designing and Delivering Effective Presentations. You will also complete a graded quiz. As always, if you have any questions, post them to the Discussions Forums. To get started, please begin with the video “Using Visualization to Influence Business Decisions.” I hope you enjoy this week's materials!
What's included
16 videos1 reading1 assignment
Show info about module content
16 videos•Total 96 minutes
Using Visualization Science to Influence Business Decisions•3 minutes
The Storyboarding Hourglass•5 minutes
Making Your Data Story Come Alive•9 minutes
Storyboarding Your Presentation•7 minutes
The Best Stress-Testers are Teams•3 minutes
Overgeneralization and Sample Bias•6 minutes
Misinterpretations Due to Lack of Controls•4 minutes
Correlation Does Not Equal Causation•6 minutes
How Correlations Impact Business Decisions•9 minutes
Choosing Visualizations for Story Points•8 minutes
The Neuroscience of Visual Perception Can Make or Break Your Visualization•4 minutes
Misinterpretations Caused by Colorbars•5 minutes
Visual Contrast Directs Where Your Audience Looks•9 minutes
Formatting Slides to Communicate Data Stories•9 minutes
Formatting Presentations to Communicate Data Stories•5 minutes
Delivering Your Data Story•6 minutes
1 reading•Total 45 minutes
Week 4 Additional Resources: Designing and Delivering an Effective Business Presentation•45 minutes
1 assignment•Total 90 minutes
Week 4 Quiz•90 minutes
Final Project
Module 6•4 hours to complete
Module details
Welcome to week 5! This week you will complete your final project. This assignment requires you to submit a recording of yourself giving a 4-5 minute presentation in which you present a data-driven business process change proposal to Dognition company management about how to increase the numbers of tests users complete. Students will give a short, peer-reviewed business presentation that uses a specified chart in Tableau. The final project will assess your mastery of the following:
~Demonstrated understanding the Tableau functions discussed in this course
~Adapting visualizations to make them maximally communicative
~Storyboarding skills
~Translating your story into a presentation ready for the boardroom
~Effective presentation delivery
~Evaluating business presentations
Remember to refer to the Background Information for Peer Review Assignment on the course web site before you begin. This final course project is a comprehensive assessment covering all of the course material and will take approximately 6-8 hours to complete. As always, if you have any questions, post them to the Discussion Forums. Thank you for your contributions to this final project!
What's included
2 readings1 peer review
Show info about module content
2 readings•Total 40 minutes
Background Information for Peer Review Assignment•30 minutes
Share your learning experience•10 minutes
1 peer review•Total 180 minutes
Recommendations for Dognition Business Process Change•180 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructors
Instructor ratings
Instructor ratings
We asked all learners to give feedback on our instructors based on the quality of their teaching style.
Duke University has about 13,000 undergraduate and graduate students and a world-class faculty helping to expand the frontiers of knowledge. The university has a strong commitment to applying knowledge in service to society, both near its North Carolina campus and around the world.
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
4.7
3,214 reviews
5 stars
74.96%
4 stars
19.70%
3 stars
3.08%
2 stars
1.02%
1 star
1.21%
Showing 3 of 3214
T
TT
5·
Reviewed on Sep 18, 2020
An in detail course for beginners on Tableau. Excellent work by the professors in terms of explaining key concepts and helping students learn the tool properly. All should definitely go for it :) !!
A
AS
4·
Reviewed on Sep 1, 2020
Good course but 1 week of the tableau could have been taught . So the concept of tableau would become clear.2nd,3rd week was about tableau + 1 more week of tableau could have been excellent
K
KW
5·
Reviewed on Feb 6, 2016
Really polished videos, really thorough explanations of how to do everything, really great overview of different functionalities that gave us a good balance of breadth and depth. Fantastic course.
Will I receive a transcript from Duke University for completing this course?
No. Completion of a Coursera course does not earn you academic credit from Duke; therefore, Duke is not able to provide you with a university transcript. However, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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.
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.