课程信息
103,907 次近期查看

100% 在线

立即开始,按照自己的计划学习。

可灵活调整截止日期

根据您的日程表重置截止日期。

完成时间大约为26 小时

建议:5 weeks, 6-8 hours per week...

英语(English)

字幕:英语(English)

您将获得的技能

Data AnalysisTableau SoftwareData Visualization (DataViz)Visualization (Computer Graphics)

100% 在线

立即开始,按照自己的计划学习。

可灵活调整截止日期

根据您的日程表重置截止日期。

完成时间大约为26 小时

建议:5 weeks, 6-8 hours per week...

英语(English)

字幕:英语(English)

教学大纲 - 您将从这门课程中学到什么

1
完成时间为 1 小时

About this Specialization and Course

<p>The Coursera Specialization: <a href='https://www.coursera.org/specializations/excel-mysql' target='_blank'>Excel to MySQL: Analytic Techniques for Business</a>, 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.<p>In the third course of the specialization: <b>Data Visualization and Communication with Tableau</b>, you will learn how to communicate business-relevant implications of data analyses. <p>Specifically, you will:<ul><li>craft the right questions to ensure your analysis projects succeed;</li> <li>leverage questions to design logical and structured analysis plans;</li> <li>create the most important graphs used in business analysis and transform data in Tableau;</li><li>design business dashboards with Tableau;</li> <li>tell stories with data;</li><li>design effective slide presentations to showcase your data story; and </li><li>deliver compelling business presentations.</li></ul> <p>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. <P>To get started, please begin with the video 'About This Specialization.'<P>I hope you enjoy this week's materials!</P>...
2 个视频 (总计 9 分钟), 5 个阅读材料
2 个视频
Welcome to the Course!4分钟
5 个阅读材料
Specialization Overview10分钟
Course Overview10分钟
FAQ (Frequently Asked Questions)10分钟
Special Thanks!10分钟
About the Course Team10分钟
完成时间为 2 小时

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: <p><ul><li>Craft the right questions to ensure your analysis projects succeed</li><li> Leverage questions to design logical and structured analysis plans</ul></li> <p> Remember to refer back to the Additional Resources reading: Identifying and Eliciting Information from Stakeholders). In addition, you will complete a graded quiz. <p> As always, if you have any questions, post them to the <b>Discussions.</b> <p>To get started, please begin with the video “Tips for Becoming a Data Analyst.” <p>I hope you enjoy this week's materials!</p>...
8 个视频 (总计 60 分钟), 2 个阅读材料, 1 个测验
8 个视频
Asking the Right Questions5分钟
Rock Projects5分钟
S.M.A.R.T. Objectives9分钟
Listening to Stakeholders During Elicitation8分钟
Stakeholder Expectations Matter8分钟
Using SPAPs to Structure Your Thinking, Part 17分钟
Using SPAPs to Structure Your Thinking, Part 26分钟
2 个阅读材料
Week 1 Additional Resources10分钟
SPAP Graphic10分钟
1 个练习
Week 1 Quiz30分钟
2
完成时间为 8 小时

Data Visualization with Tableau

Welcome to week 2! This week you'll install Tableau Desktop 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. You will learn to install Tableau Desktop and learn to use the program by working with two data sets. 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. <p>By the end of this week, you will be able to: <ul><li>Create the most important graphs used in business analysis and transform data in Tableau </li></ul><p>Once you have watched the "Why Tableau" video, review the "Written Instructions to install Tableau Desktop" and install 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. <p>As always, if you have any questions, post them to the <b>Discussions</b>.<p>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.<p>I hope you enjoy this week's materials! ...
16 个视频 (总计 130 分钟), 6 个阅读材料, 2 个测验
16 个视频
Why Tableau?8分钟
Meet Your Salary Data3分钟
Meet Your Dognition Data11分钟
Our Analysis Plan39
Salaries of Data-Related Jobs: Your First Graph11分钟
Formatting and Exporting Your First Graph6分钟
Digging Deeper Using the Rows and Columns Shelves13分钟
Understanding the Marks Card11分钟
Removing Outliers Using Scatterplot and Filtering and Groups13分钟
Analyzing Data-Related Salaries in Different States Using Filtering and Groups8分钟
When to Use Line Graphs2分钟
Dates as Hierarchical Dimensions or Measures8分钟
Analyzing Data-Related Salaries Over Time Using Date Hierarchies8分钟
Analyzing Data-Related Salaries Over Time Using Trend Lines9分钟
Analysing Data-Related Salaries Over Time Using Box Plots10分钟
6 个阅读材料
Written Instructions to Install Tableau Desktop2分钟
Salary Data Set, Description, and Analysis Plan10分钟
Dognition Data Set, Description, and Analysis Plan10分钟
The Effects of Outliers Video10分钟
Introduction to Linear Regression10分钟
Week 2 Practice Exercises
1 个练习
Week 2 Quiz
3
完成时间为 7 小时

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: <ul><li>Write calculations and equations in Tableau</li> <li>Publish online business dashboards with Tableau.</li></ul> <p>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." <p>You will also complete a graded quiz. <p>As always, if you have any questions, post them to the Discussions. <p>To get started, please begin with the video “Customizing and Sharing New Data in Tableau.” <p>I hope you enjoy this week's materials!...
12 个视频 (总计 98 分钟), 3 个阅读材料, 1 个测验
12 个视频
Tableau Calculation Types4分钟
How to Write Calculations11分钟
Calculations that Make Filtering More Efficient8分钟
Identifying Companies that Pay Less than the Prevailing Wage9分钟
Blending Price Parity Data with Our Salary Data4分钟
Adjusting Data-related Salaries for Cost of Living10分钟
Calculating Which States Have the Top Adjusted Salaries within Job Subcategories10分钟
Using Parameters to Define Top States7分钟
Calculating Which Companies Have the Top Adjusted Salaries within Job Subcategories8分钟
Designing a Dashboard to Determine Where You should Apply for Data-related Job12分钟
Visual Story Points in Tableau10分钟
3 个阅读材料
Data Sets Needed in Week 310分钟
Week 3 Additional Resources: Examples of Tableau Dashboards and Stories10分钟
Week 3 Practice Exercises
1 个练习
Week 3 Quiz
4
完成时间为 4 小时

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! <p>By the end of this week, you will be able to:<p><ul><li>Tell stories with data</li> <li>Design effective slide presentations to showcase your data story, and</li> <li> Deliver compelling business presentations</ul></li><p> Remember to refer back to the Study Guide: Designing and Delivering Effective Presentations. You will also complete a graded quiz. <p>As always, if you have any questions, post them to the <b>Discussions</b>.<p> To get started, please begin with the video “Using Visualization to Influence Business Decisions.”<p> I hope you enjoy this week's materials!...
16 个视频 (总计 96 分钟), 1 个阅读材料, 1 个测验
16 个视频
The Storyboarding Hourglass5分钟
Making Your Data Story Come Alive9分钟
Storyboarding Your Presentation6分钟
The Best Stress-Testers are Teams3分钟
Overgeneralization and Sample Bias5分钟
Misinterpretations Due to Lack of Controls3分钟
Correlation Does Not Equal Causation6分钟
How Correlations Impact Business Decisions8分钟
Choosing Visualizations for Story Points7分钟
The Neuroscience of Visual Perception Can Make or Break Your Visualization3分钟
Misinterpretations Caused by Colorbars4分钟
Visual Contrast Directs Where Your Audience Looks8分钟
Formatting Slides to Communicate Data Stories8分钟
Formatting Presentations to Communicate Data Stories5分钟
Delivering Your Data Story5分钟
1 个阅读材料
Week 4 Additional Resources: Designing and Delivering an Effective Business Presentation45分钟
1 个练习
Week 4 Quiz30分钟
5
完成时间为 4 小时

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: <p> <ul><li>Demonstrated understanding the Tableau functions discussed in this course</li><li>Adapting visualizations to make them maximally communicative</li><li>Storyboarding skills</li> <li>Translating your story into a presentation ready for the boardroom</li><li>Effective presentation delivery</li><li>Evaluating business presentations</ul></li><p> 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.<p>As always, if you have any questions, post them to the Discussions. Thank you for your contributions to this final project!<p> ...
1 个阅读材料, 1 个测验
1 个阅读材料
Background Information for Peer Review Assignment30分钟
4.7
412 个审阅Chevron Right

39%

完成这些课程后已开始新的职业生涯

33%

通过此课程获得实实在在的工作福利

热门审阅

创建者 TPJul 4th 2016

Thanks very much for great content and especially, Ms. Jana Schaich Borg for brilliant presentation skills, lovely voice and good looking as well. Please participate. This is highly recommend course.

创建者 ITNov 7th 2018

I was pleased by the quality of this course. I really learned how to use tableau and the tips on researching and presenting were well founded. The teachers were positive and hard working. Thank you!

讲师

Avatar

Daniel Egger

Executive in Residence and Director, Center for Quantitative Modeling
Pratt School of Engineering, Duke University
Avatar

Jana Schaich Borg

Assistant Research Professor
Social Science Research Institute

关于 杜克大学

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....

关于 从 Excel 到 MySQL:商业分析技术 专项课程

Formulate data questions, explore and visualize large datasets, and inform strategic decisions. In this Specialization, you’ll learn to frame business challenges as data questions. You’ll use powerful tools and methods such as Excel, Tableau, and MySQL to analyze data, create forecasts and models, design visualizations, and communicate your insights. In the final Capstone Project, you’ll apply your skills to explore and justify improvements to a real-world business process. The Capstone Project focuses on optimizing revenues from residential property, and Airbnb, our Capstone’s official Sponsor, provided input on the project design. Airbnb is the world’s largest marketplace connecting property-owner hosts with travelers to facilitate short-term rental transactions. The top 10 Capstone completers each year will have the opportunity to present their work directly to senior data scientists at Airbnb live for feedback and discussion....
从 Excel 到 MySQL:商业分析技术

常见问题

  • 注册以便获得证书后,您将有权访问所有视频、测验和编程作业(如果适用)。只有在您的班次开课之后,才可以提交和审阅同学互评作业。如果您选择在不购买的情况下浏览课程,可能无法访问某些作业。

  • 您注册课程后,将有权访问专项课程中的所有课程,并且会在完成课程后获得证书。您的电子课程证书将添加到您的成就页中,您可以通过该页打印您的课程证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容,可以免费旁听课程。

  • 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.

还有其他问题吗?请访问 学生帮助中心