Introduction to Career Skills in Data Analytics
2h 28mBeginner2026-06-29
Authors

Robin Hunt
Developer and Educator
Course details
Whether you're exploring a career change or building new skills, understanding data analytics can open doors across industries. In this course, instructor Robin Hunt provides a clear, practical roadmap for anyone looking to break into data analytics—no technical background required. Robin steps through the essentials, from defining data analysis and business intelligence to identifying, preparing, transforming, modeling, and visualizing data using tools like Excel, SQL, and Power BI.
Robin introduces key concepts such as data quality, data governance, and the difference between data-driven and data-informed decision-making. Along the way, she also helps you explore AI fluency with Copilot and learn questioning techniques to collect and interpret the right data. By the end, you have the foundation to map out your own path in data—whether that leads to data analysis, data engineering, visualization, or beyond.
Learning objectives
Define data analysis and common data roles, and develop a foundation in data fluency.
Explain business intelligence and its value to organizational decision-making.
Apply questioning techniques to identify, collect, and interpret data from various sources and structures.
Assess and prepare data for transformation using key Excel techniques such as removing duplicates, splitting text, and validating data.
Transform data using Excel formulas and pivot tables, and write basic SQL queries using select statements and joins.
Create reports and apply visualization best practices in Power BI.
Describe relational databases and model data for use in Power BI.
Use Copilot to support and enhance your data analysis workflow.
Robin introduces key concepts such as data quality, data governance, and the difference between data-driven and data-informed decision-making. Along the way, she also helps you explore AI fluency with Copilot and learn questioning techniques to collect and interpret the right data. By the end, you have the foundation to map out your own path in data—whether that leads to data analysis, data engineering, visualization, or beyond.
Learning objectives
Define data analysis and common data roles, and develop a foundation in data fluency.
Explain business intelligence and its value to organizational decision-making.
Apply questioning techniques to identify, collect, and interpret data from various sources and structures.
Assess and prepare data for transformation using key Excel techniques such as removing duplicates, splitting text, and validating data.
Transform data using Excel formulas and pivot tables, and write basic SQL queries using select statements and joins.
Create reports and apply visualization best practices in Power BI.
Describe relational databases and model data for use in Power BI.
Use Copilot to support and enhance your data analysis workflow.
Concepts
Introduction
- Starting out with data analytics
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
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
Identifying Data
- Understanding the value of data-driven decision-making
- Questioning techniques to collect the right data
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
Transforming Data
- Transforming data in Excel with Power Query
- Transforming data in SQL
- When to use Power Query in PowerBI
- Using built-in functions
Modeling Data
- Relational databases
- Modeling data for Power BI
- Master data management
- Using AI to support unstructured data
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
Introduction to AI for Data Analytics
- Using AI to reverse engineer solutions
- Using the Copilot Analyst Agent
Job Mapping in the Data Analytics Field
Continuing Your Data Analytics Learning Journey
- Next steps
Related courses
- Introduction to Career Skills in Data Analytics (2022)
- The Role of Business Analysis in Data Analytics
- Data Analytics for Students (2022)
- Oracle Cloud Infrastructure Operations Professional
- Introduction to Data Engineering on AWS: Data Sourcing and Storage
- Learning Data Science: Understanding the Basics
- Data Science Foundations: Fundamentals
- Introduction to Data Science
Related learn paths
- Career Essentials in Data Analysis by Microsoft and LinkedIn
- Explore a Career in Data Analysis
- Starting Your Career in Tech: Data Science
- Moving from Data Analyst to Data Scientist
- Introduction to Fundamental Skills for Data Work: Data Analysis and Interpretation
- Moving from Data Scientist to Data Analyst
- Advance Your Skills in R
- Introduction to Fundamental Skills for Data Work: Data Storage