Специализация От Excel до MySQL: аналитические методы для бизнеса

Начинается апр 03

Специализация От Excel до MySQL: аналитические методы для бизнеса

Turn Data Into Value

Drive business process change by identifying & analyzing key metrics in 4 industry-relevant courses.

Об этой специализации

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.


Партнеры курса:

5 courses

Следуйте предложенному порядку или выберите свой.


Поможет на практике применить полученные навыки.


Отметьте новые навыки в резюме и на LinkedIn.

Beginner Specialization.
No prior experience required.
  1. 1-Й КУРС

    Business Metrics for Data-Driven Companies

    Предстоящая сессия: апр 3–май 8.
    4 weeks, 3-5 hours per week
    English, Chinese (Simplified)

    О курсе

    In this course, you will learn best practices for how to use data analytics to make any company more competitive and more profitable. You will be able to recognize the most critical business metrics and distinguish them from mere data. You’ll get a clear picture of the vital but different roles business analysts, business data analysts, and data scientists each play in various types of companies. And you’ll know exactly what skills are required to be hired for, and succeed at, these high-demand jobs. Finally, you will be able to use a checklist provided in the course to score any company on how effectively it is embracing big data culture. Digital companies like Amazon, Uber and Airbnb are transforming entire industries through their creative use of big data. You’ll understand why these companies are so disruptive and how they use data-analytics techniques to out-compete traditional companies.
  2. 2-Й КУРС

    Mastering Data Analysis in Excel

    Предстоящая сессия: апр 3–май 22.
    6 weeks, 8-10 hours per week

    О курсе

    Important: The focus of this course is on math - specifically, data-analysis concepts and methods - not on Excel for its own sake. We use Excel to do our calculations, and all math formulas are given as Excel Spreadsheets, but we do not attempt to cover Excel Macros, Visual Basic, Pivot Tables, or other intermediate-to-advanced Excel functionality. This course will prepare you to design and implement realistic predictive models based on data. In the Final Project (module 6) you will assume the role of a business data analyst for a bank, and develop two different predictive models to determine which applicants for credit cards should be accepted and which rejected. Your first model will focus on minimizing default risk, and your second on maximizing bank profits. The two models should demonstrate to you in a practical, hands-on way the idea that your choice of business metric drives your choice of an optimal model. The second big idea this course seeks to demonstrate is that your data-analysis results cannot and should not aim to eliminate all uncertainty. Your role as a data-analyst is to reduce uncertainty for decision-makers by a financially valuable increment, while quantifying how much uncertainty remains. You will learn to calculate and apply to real-world examples the most important uncertainty measures used in business, including classification error rates, entropy of information, and confidence intervals for linear regression. All the data you need is provided within the course, all assignments are designed to be done in MS Excel, and you will learn enough Excel to complete all assignments. The course will give you enough practice with Excel to become fluent in its most commonly used business functions, and you’ll be ready to learn any other Excel functionality you might need in the future (module 1). The course does not cover Visual Basic or Pivot Tables and you will not need them to complete the assignments. All advanced concepts are demonstrated in individual Excel spreadsheet templates that you can use to answer relevant questions. You will emerge with substantial vocabulary and practical knowledge of how to apply business data analysis methods based on binary classification (module 2), information theory and entropy measures (module 3), and linear regression (module 4 and 5), all using no software tools more complex than Excel.
  3. 3-Й КУРС

    Data Visualization and Communication with Tableau

    Предстоящая сессия: апр 3–май 15.
    5 weeks, 6-8 hours per week

    О курсе

    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.
  4. 4-Й КУРС

    Управление большими данными с MySQL

    Текущая сессия: мар 27–май 8.
    5 недель, 3-5 часов в неделю

    О курсе

    Этот курс представляет собой введение в использование реляционных баз данных в бизнес-аналитике. Вы узнаете, как работают реляционные базы данных, и как использовать диаграммы сущностей и связей для отображения структуры данных, содержащихся в них. Это поможет вам понять, как собирать данные в контексте бизнеса, а также поможет вам определить, на что обратить внимание, при участии в сборе новых данных. Вы также узнаете, как выполнять наиболее полезные запросы, операторы обобщения таблиц для бизнес-аналитиков, и попрактикуетесь в их использовании с настоящими базами данных. Больше не нужно ждать 48 часов, пока кто-то в компании предоставит вам данные - вы сможете получить данные сами! К концу этого курса вы будете иметь четкое представление о том, как работают реляционные базы данных, а также овладеете набором запросов, которые вы можете показать потенциальным работодателям. Компании собирают все большее количество информации, с надеждой, что данные предоставят новые идеи о том, как улучшить бизнес. У аналитиков, которые понимают, как получить доступ к этой информации, - то есть у вас! - будет большое конкурентное преимущество в этом охваченном данными мире бизнеса.
  5. 5-Й КУРС

    Increasing Real Estate Management Profits: Harnessing Data Analytics

    Предстоящая сессия: май 8–июль 3.
    8 weeks of study, 8-10 hours/week

    О дипломном проекте

    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 residential rental properties throughout the United States. Your job is to persuade Watershed’s management team to pursue a new strategy for managing its properties that will increase their profits. To do this, you will: (1) Elicit information about important variables relevant to your analysis; (2) Draw upon your new MySQL database skills to extract relevant data from a real estate database; (3) Implement data analysis in Excel to identify the best opportunities for Watershed to increase revenue and maximize profits, while managing any new risks; (4) Create a Tableau dashboard to show Watershed executives the results of a sensitivity analysis; and (5) Articulate a significant and innovative business process change for Watershed based on your data analysis, that you will recommend to company executives. Airbnb, our Capstone’s official Sponsor, provided input on the project design. 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. "Note: Only learners who have passed the four previous courses in the specialization are eligible to take the Capstone."


  • Университет Дьюка

    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


More questions? Visit the Learner Help Center.