Grow your data analysis skills

Learn critical skills through data analysis like problem solving, communication, decision making, and more. The tools of analysis may change, but its underlying skills will remain valuable.

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.

Technologies you will use to gain your Data Analysis skills

Data Analysis

Data Visualization

Microsoft Excel

Communicate Data Insights

Descriptive Analytics Models

T-SQL

Data Analysis Methods

Data Analysis Track Details

All courses are available online and on demand on any device – 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.

1. Data Analysis: A Practical Approach for Absolute Beginners

This course will take you from the beginnings of data concepts and structures in context through analyzing data, telling effective data stories, and understanding the environments in which data exists.

2. Essential Math for Data Analysis using Excel Online

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.

3. Data Visualization: A Practical Approach for Absolute Beginners

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.

4. Introduction to Data Analysis using Excel

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.

5. Querying Data with Transact-SQL

6. Build Descriptive Analytics Models and Visualizations

Option 1: Analyzing and Visualizing Data with Excel

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.

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.

7. Analytics Storytelling for Impact

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.

8. Applied Data Analysis: Working in Organizations and Industries

Get hands-on practice with organizational and industry-specific analytics scenarios. This course gives you the chance to try out different applied data analyst roles so that you can be better prepared for the work of an analyst.

9. Final Project - Microsoft Professional Capstone: Data Analysis

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

Booking Options: We offer two options to reach your Certificate in Data Analysis!

Self-paced E-Learning with optional Learning as a Service (LaaS) offerings