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
- 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
- What is BI and the value to business?
- How are business analytics and BI different?
- How data can provide intelligence to the organization
- Understanding the value of data-driven decision-making
- Questioning techniques to collect the right data
- Discovering and interpreting existing data
- Data sources and structures
- Describing data best practices
- Assessing and adapting the data for transformation
- Understanding the rules of the data
- Tips on preparing the data in Excel
- Transforming data in Excel with Power Query
- Transforming data in SQL
- Transforming data in Power BI
- Common cleaning and transformation
- Using built-in functions
- Relational databases
- Modeling data for Power BI
- Master data management
- Unstructured 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
- Data workers
- Data analysts
- Data engineers
- Data scientists
- 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
Showing Class Central Sort
-
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.
-
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.
-
“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.”
-
good teachingand easy to understand ,all the topic are coverd .very informative session easy and short learning .
-
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!”