Microsoft Foundational Career Certificate in Data Analytics

Dive into data analytics to get a new job, boost your career and take on the Microsoft GSI Data Analytics certification exam.

Introduction

• Starting out with data analytics

1. Introduction to Data and Data Analysis

• Defining data analysis and roles in data analysis
• Developing data fluency
• Understanding how data governance impacts the data analyst
• Understanding the importance of data quality

2. Introduction to Business Intelligence

• What is BI and the value to business?
• How are business analytics and BI different?
• How data can provide intelligence to the organization

3. Identifying Data

• Understanding the value of data-driven decision-making
• Questioning techniques to collect the right data
• Discovering and interpreting existing data
• Data sources and structures

4. Preparing Data

• Describing data best practices
• Assessing and adapting the data for transformation
• Understanding the rules of the data
• Tips on preparing the data in Excel

5. Transforming Data

• Transforming data in Excel with Power Query
• Transforming data in SQL
• Transforming data in Power BI
• Common cleaning and transformation
• Using built-in functions

6. Modeling Data

• Relational databases
• Modeling data for Power BI
• Master data management
• Unstructured data

7. Visualizing Data

• Visualization methods and best practices
• Creating reports to visualize your data over pages
• Creating a dashboards for reporting
• Gathering requirements for visualizations
• Presenting data challenges effectively to others
• Finalizing dashboards
• Adding dashboard filters
• Modifying dashboard tooltips

8. Job Mapping in the Data Analytics Field

• Data workers
• Data analysts
• Data engineers
• Data scientists

Continuing Your Data Analytics Learning Journey

• Next steps and additional resources