Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Introduction to Career Skills in Data Analytics

Introduction to Career Skills in Data Analytics

2h 28mBeginner2026-06-29

Authors

Robin Hunt

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.

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

Related learn paths

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
zarinpal
zibal