Programa Especializado - Excel to MySQL: Analytic Techniques for Business

Comienza el Aug 20

Programa Especializado - Excel to MySQL: Analytic Techniques for Business

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

Sobre este Programa Especializado

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.

Creada por:

Socios de la industria:

courses
5 courses

Sigue el orden sugerido o elige el tuyo.

projects
Proyectos

Diseñado para ayudarte a practicar y aplicar las habilidades que aprendiste.

certificates
Certificados

Resalta tus nuevas habilidades en tu currículum o LinkedIn.

Cursos
Beginner Specialization.
No prior experience required.
  1. CURSO 1

    Business Metrics for Data-Driven Companies

    Próxima sesión: Aug 20
    Dedicación
    4 weeks, 3-5 hours per week
    Subtítulos
    English, Chinese (Simplified)

    Acerca del Curso

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

    Mastering Data Analysis in Excel

    Próxima sesión: Aug 20
    Dedicación
    6 weeks, 8-10 hours per week
    Subtítulos
    English

    Acerca del Curso

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

    Data Visualization and Communication with Tableau

    Próxima sesión: Aug 20
    Dedicación
    5 weeks, 6-8 hours per week
    Subtítulos
    English

    Acerca del Curso

    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 bus
  4. CURSO 4

    Managing Big Data with MySQL

    Próxima sesión: Aug 27
    Dedicación
    5 weeks, 8-12 hours per week
    Subtítulos
    English, Korean, Russian, Chinese (Simplified)

    Acerca del Curso

    This course is an introduction to how to use relational databases in business analysis. You will learn how relational databases work, and how to use entity-relationship diagrams to display the structure of the data held within them. This knowledge
  5. CURSO 5

    Increasing Real Estate Management Profits: Harnessing Data Analytics

    Próxima sesión: Sep 24
    Dedicación
    8 weeks of study, 8-10 hours/week
    Subtítulos
    English

    Sobre el Proyecto Final

    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 r

Creadores

  • 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