从 Excel 到 MySQL:商业分析技术 Specialization

Starts May 28

从 Excel 到 MySQL:商业分析技术 Specialization

将数据化作价值. Drive business process change by identifying & analyzing key metrics in 4 industry-relevant courses.

About This Specialization

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.

Created by:

Industry Partners:

courses
5 courses

Follow the suggested order or choose your own.

projects
Projects

Designed to help you practice and apply the skills you learn.

certificates
Certificates

Highlight your new skills on your resume or LinkedIn.

Courses
Beginner Specialization.
No prior experience required.
  1. COURSE 1

    数据驱动型公司的业务指标

    Upcoming session: May 28
    Commitment
    该课程为 4 周长 估计需要每周学习 3-5 个小时
    Subtitles
    English, Chinese (Simplified)

    About the Course

    在该课程中 您将学习使用数据分析使公司更好的盈利且更具竞争力的最佳实践 您将能够识别最关键的业务指标 并将其与单纯的数据区分开来 你将会对至关重要但不同角色的业务分析师 业务数据分析师和数据科学家在不同公司的角色扮演有个清晰的概念 并且 将了解这些高需求的职位被雇佣和成功所需要的技能 最后 您将能够使用该课程提供的一个清单 对每个公司如何有效地接受大数据文化给予评分 像亚马逊(Amazon)优步(Uber)和空中食宿(Airbnb)等数码公司正在通过创造性地利用大
  2. COURSE 2

    Mastering Data Analysis in Excel

    Upcoming session: May 28
    Commitment
    6 weeks, 3 - 5 hours per week
    Subtitles
    English

    About the Course

    In business, data and algorithms create economic value when they reduce uncertainty about financially important outcomes. This course teaches the concepts and mathematical methods behind the most powerful and universal metrics used by Data Scien
  3. COURSE 3

    Data Visualization and Communication with Tableau

    Upcoming session: May 28
    Commitment
    5 weeks, 6-8 hours per week
    Subtitles
    English

    About the 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
  4. COURSE 4

    用MySQL管理大数据

    Upcoming session: Jun 4
    Commitment
    每周3-5小时,共5周
    Subtitles
    English, Russian, Chinese (Simplified)

    About the Course

    本课程致力于介绍如何在商业分析中运用关系数据库。你将会学到关系数据库是如何工作的,以及如何运用实体-联系图来展示数据结构。这将会帮助你理解商业环境下数据需要怎样被收集,而且如果你的工作
  5. COURSE 5

    从 Excel 到 MySQL:商业分析技术毕业项目

    Upcoming session: Jul 2
    Commitment
    8 weeks of study, 8-10 hours/week
    Subtitles
    English

    About the Capstone Project

    In this final course you will complete a Capstone Project using data analysis to recommend a method for improving profits for your company, Watershed Property Management, Inc. Watershed is responsible for managing thousands of residentia

Creators

  • Duke University

    Duke University is consistently ranked as a top research institution, with graduate and professional schools among the leaders in their fields.

    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.

  • Jana Schaich Borg

    Jana Schaich Borg

    Assistant Research Professor
  • Daniel Egger

    Daniel Egger

    Executive in Residence and Director, Center for Quantitative Modeling

FAQs