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

Dive into data analytics to get a new job, boost your career and take on 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.4 rating, based on 5 Class Central reviews

4.7 rating at LinkedIn Learning based on 23049 ratings

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.
  • Nangunuru Kavitha
    The Microsoft Fundamentals Career Certificate in Data Analyst is an excellent program for anyone looking to enter the field of data analysis. It offers a solid foundation in essential skills, including data visualization, data preparation, and statistical analysis. The course is well-structured, featuring engaging content, hands-on labs, and real-world scenarios that enhance learning. The certification is recognized in the industry, adding value to your resume. Additionally, the support from instructors and the community fosters a collaborative learning environment. Overall, it’s a great investment for aspiring data analysts, providing the tools and knowledge needed to succeed in this dynamic field.
  • 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.”
  • 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!”

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.