Skip to main content

Gain well-rounded analysis skills

Professional Certificate in
Data Analysis: Essential Skills

What you will learn

  • Course 1: Querying Data with Transact-SQL
  • Course 2: Analyzing and Visualizing Data with Excel
  • Course 3: Introduction to Data Analysis using Excel

Data Analysis: Essential Skills teaches core analytics principles, including how to manipulate and query large data sets. Students will work with T-SQL and use pivot tables for data visualization.

This program consists of three highly focused courses that you can take at your own pace. It is one of three Professional Certificates that make up the Microsoft Professional Program in Data Analysis.

Our approach combines self-directed online learning with hands-on labs, using the latest tools so you can hit the ground running. By enrolling in a shorter program, you can more quickly gain a standalone Professional Certificate and the valuable analytics skills that employers are looking for—all at a 10 percent discount.

Expert instruction
3 graduate-level courses
Progress at your own speed
2-4 months
44 - 70 hours of effort
For the full program experience

Courses in this program

  1. Microsoft's Data Analysis: Essential Skills Professional Certificate

  2. 4–5 hours per week, for 6 weeks

    From querying and modifying data in SQL Server or Azure SQL to programming with Transact-SQL, learn essential skills that employers need.

  3. 2–4 hours per week, for 6 weeks

    Develop your skills with Excel, one of the common tools that data scientists depend on to gather, transform, analyze, and visualize data.

  4. 2–4 hours per week, for 4 weeks

    Learn the basics of Excel, one of the most popular data analysis tools, to help visualize and gain insights from your data.

    • 5% of companies are predicted to adopt big data analytics by 2022. (World Economic Forum)
    • In the United States alone, there is a shortage of 151,717 people with data science skills. (LinkedIn Workforce Report)
    • 28% projected spike in demand for data scientists and advanced analysts by 2020. (Forbes)

Meet your instructors

from Microsoft
Dany Hoter
Solutions Architect
Geoff Allix
Microsoft Certified IT Professional for SQL Server
Content Master
Graeme Malcolm
Senior Content Developer
Microsoft Learning Experiences
Jonathan Sanito
Senior Content Developer

Experts from Microsoft committed to teaching online learning

Enrolling Now

3 courses in 2-4 months
Pursue the Program


Drive your career forward with university-backed credit programs and verified certificates


Study and demonstrate knowledge on your schedule


Try a course before you pay


Learn with university partners and peers from around the world