Overview
Syllabus
- About this Specialization and Course
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; and
- 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!
- Asking The "Right Questions"
- 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
- Data Visualization with Tableau
- 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.
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! .
- Dynamic Data Manipulation and Presentation in Tableau
- 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.
To get started, please begin with the video “Customizing and Sharing New Data in Tableau.”
I hope you enjoy this week's materials!
- Your Communication Toolbox: Visualizations, Logic, and Stories
- 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, and
- Deliver compelling business presentations
- Final Project
- 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 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.
To get started, please begin with the video “Tips for Becoming a Data Analyst.”
I hope you enjoy this week's materials!
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.
To get started, please begin with the video “Using Visualization to Influence Business Decisions.”
I hope you enjoy this week's materials!
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 Discussions. Thank you for your contributions to this final project!
Taught by
Daniel Egger and Jana Schaich Borg
Tags
Reviews
4.0 rating, based on 7 Class Central reviews
4.7 rating at Coursera based on 3197 ratings
-
Data Visualization and Communication with Tableau is the third course in Duke University's "Excel to MySQL: Analytic Techniques for Business" specialization offered on Coursera. The 5-week course starts is essentially an introduction to Tableau (wee…
-
I'm currently enrolled and so far, so good. It's one of the best 'Data Analysis' I've come across online - and you can take it for free! What's not to like? And Jana's delivery is never dull and engaging. And as a little plus, she's easy on the eye :) Recommended!
-
It's a great class if you're interested in data visualization and want to learn how to use Tableau, a tool which makes it easier for companies to get useful data insights visually. Very hands on and practical learning.
-
I fully agree with Gregory. This course has the best video lectures. Week 2 and 3 are technical aspects of tableau. Week 1 and 4 are functional aspects of visualization which is of equal importance.
-
-