Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Microsoft Foundational Career Certificate in Data Analytics

via LinkedIn Learning

Overview

Get a comprehensive introduction to data analytics to land a new job, boost your career, and tackle the Microsoft GSI Data Analytics certification exam.

Syllabus

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

Taught by

Robin Hunt

Reviews

4.2 rating, based on 4 Class Central reviews

Start your review of Microsoft Foundational Career Certificate in Data Analytics

  • The Data Analytics course I recently completed was nothing short of exceptional. The curriculum was meticulously designed, providing a comprehensive understanding of both theoretical concepts and practical applications. The instructors were highly knowledgeable, engaging, and supportive throughout the learning process, making complex topics easily digestible. Hands-on projects and real-world case studies were incorporated, enhancing the learning experience and preparing me for actual industry challenges. The course has significantly boosted my analytical skills, enabling me to approach data-driven problems with confidence and precision. I highly recommend this course to anyone aspiring to excel in the field of data analytics.
  • Madhumitha
    good teachingand easy to understand ,all the topic are coverd .very informative session easy and short learning .
  • Akhila Kumar
    very excellent. “It was such a pleasure to take a few classes with She was always accommodating, kind, and motivated. We worked on many projects together, and she is very applied and aims for high-quality work.
    She is creative, smart, has excellent communication skills, and is willing to help when you need it. is the kind of person who does anything for the group’s benefit. A great colleague!”
  • Profile image for Vishal Kumar Mahto
    Vishal Kumar Mahto
    “I truly enjoyed this course.” “I appreciated how the instructor surveyed the class before to get a sense of what we all wanted to take away from the course.” “The instructors were fantastic – very knowledgeable and willing to answer questions as they came up.”

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.