Get a comprehensive introduction to data analytics to land a new job, boost your career, and tackle the Microsoft GSI Data Analytics certification exam.
Overview
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.2 rating, based on 4 Class Central reviews
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.
-
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!” -
“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.”