Introduction
Starting out with data analytics
()
1. Introduction to Data and Data Analysis
Defining the roles that perform data analysis
()
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
()
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
()
When to use Power Query in PowerBI
()
Using built-in functions
()
6. Modeling Data
Relational databases
()
Modeling data for Power BI
()
Master data management
()
Using AI to support 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 and adding dashboard filters
()
8. Introduction to AI for Data Analytics
Using AI to reverse engineer solutions
()
Using the Copilot Analyst Agent
()
10. Continuing Your Data Analytics Learning Journey
Next steps
()
Ex_Files_Intro_Career_Skills_Data_Analytics.zip
(11.9 MB)
URL Resources
(12 KB)