Microsoft Professional Program for Data Analysis

The ability to analyze data properly, communicate data analysis results, and make an impact with data is a critical skill today. Including visualization, descriptive and inferential statistics, and using logic for querying data sets, students will be ready to take on any data set. 

8 - 60

Technologies you will use to gain your skills

Data Analysis
Data Visualization
Microsoft Excel
Communicate Data Insights
Descriptive Analytics Models
Data Analysis Methods

Track detail

Each course runs for three months and starts at the beginning of a quarter. January—March, April—June, July—September, and October —December. The capstone runs for four weeks at the beginning of each quarter: January, April, July, October. For exact dates for the current course run, please refer to the course detail page on

* Courses can be taken during any course run and in any order. When multiple course options are listed for a skill, only one must be completed to satisfy the requirements for graduation.

  • Essential Math for Data Analysis using Excel Online

    Provided by Microsoft

    Learn to handle different data types, understand mathematical notation, become proficient in handling data sets and summary statistics, and get a sneak peek into how to be effective at making statistical inferences and predictions.

  • Data Visualization: A Practical Approach for Absolute Beginners

    Provided by Microsoft

    Data visualization literacy is fundamental. The ability to create compelling, accurate, and driven-data stories is a core skill of any modern job. This course provides a practical approach to learning the theories and techniques of data visualization.

  • Introduction to Data Analysis using Excel

    Provided by Microsoft

    Learn how to perform data analysis using the most powerful features in Excel. See the power of pivot tables in action, and their ability to summarize data in flexible ways, enabling quick data exploration and producing valuable insights.

  • Querying Data with Transact-SQL

    Provided by Microsoft

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

  • Option 1
    Analyzing and Visualizing Data with Excel

    Provided by Microsoft

    Explore tools in Excel that enable the analysis of more data than ever before, with improved visualizations and more sophisticated business logic. Learn how to import data from different sources, create mashups between data sources, and prepare data for analysis.

  • Option 2
    Analyzing and Visualizing Data with Power BI

    Provided by Microsoft

    Learn how to connect and visualize your data with Microsoft Power BI. Find out how to import your data, author reports using Power BI Desktop, and publish those reports to the Power BI service. Create dashboards and share with business users on the web and on mobile devices.

  • Analytics Storytelling for Impact

    Provided by Microsoft

    Learn effective strategies and tools to master data communication in the most impactful way possible—through well-crafted analytics stories. Find out how stories create value and why they matter. Learn to craft stories, command the room, finish strong, and assess your impact. Get practical help applying these ideas to your data analytics work. Plus, you'll learn guidelines and best practices for creating high-impact reports and presentations.

  • Microsoft Professional Capstone : Data Analysis

    Provided by Microsoft

    Showcase the knowledge you acquired in the MPP for Data Analysis, and solve a real-world analytics problem. You’ll explore a data set and deliver analyses and analytics artifacts that are tested and scored to determine your grade.

Microsoft Professional Program Certificate in Data Analysis

Hands-on learning using the latest analytics methods

Each course in the Microsoft Professional Program in Data Analysis features hands-on labs so you can practice the most sought-after skills. Assessments that require more than just memorization ensure mastery of these new skills.

Learn on your own time

All courses are available online and on demand – so whether you plan to spend a couple of hours per day or a couple of hours per week, you can work on these skills at the pace that is right for you. And since the curriculum consists of massive open online courses (MOOC) on edX, you can watch the videos on your tablet or phone.

Frequently asked questions

Question Why is Microsoft discontinuing the Microsoft Professional Program?


Three years ago, we launched the Microsoft Professional Program with one mission: to help you build the technical skills you need to succeed in emerging jobs.

Since then, we’ve heard from many of you about how you’ve applied your new skills to become more impactful in your current work and gained more recognition from your colleagues.

That’s why we’ve decided to take the best of the Microsoft Professional Program and apply it to a program where you can earn a technical certification when you complete your coursework. Why?

  • Certified new hires reach full productivity sooner and find more opportunities for advancement.
  • Certified employees earn 15 percent more than those without certification.
  • Employees with certifications are nearly 20 percent more productive.

Find out more about our move toward role-based certificates and role-based training here.

Question If I would like to continue pursuing an MPP track, how long do I have to complete it?


Microsoft Professional Program will end on December 31, 2019.  Enrollments to MPP tracks will discontinue on September 15, 2019.

If you are currently enrolled in MPP courses or tracks, please complete them by December 31, 2019.

If you have completed your MPP courses or tracks, please save/print certificates by December 31, 2019. Learners enrolled in tracks as of September 15, 2019 will have a final opportunity to take the capstone from November 1 through December 31, 2019. We are making this capstone period longer than the typical one month to allow for more time to test and retake, if needed. This final capstone will replace the one normally scheduled for Oct. 1-31.

Question If I have successfully completed an MPP track(s) or plan to finish before the program retires, will the achievement still have value in the market?

Yes! The MPP credential demonstrates value and excellence to managers looking to hire in technology fields.