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

Introduction to Career Skills in Data Analytics (2022)

2h 22mBeginner2022-08-12

Authors

Robin Hunt

Robin Hunt

Developer and Educator

Course details

Are you ready to take the first step on your journey as a data analyst? Whatever your goals, you don’t need a background in computer science to get started today. In this course, instructor Robin Hunt gives you a comprehensive, behind-the-scenes look at what it’s really like to be a data analyst, from wielding data concepts and business intelligence skills, to landing your first role and advancing your career.

Explore the power of data and data analysis to develop a better understanding of the role. Learn about business intelligence, data-driven decision-making, data collection methods, discovery, and interpretation, as well as how to structure, assess, and transform data using core functions in Excel and Power BI. Gather insights from Robin on modeling, visualization, and mapping out the job market as an early-career analyst. By the end of this course, you’ll have the skills you need to set out on a new career path and tackle the Microsoft GSI Data Analytics certification exam.

Skills covered

Tech Career SkillsData AnalysisCybersecurityCloud ComputingData ScienceBusiness Analysis and StrategyBusiness Software and ToolsSoftware DevelopmentOne-Off

Concepts

Introduction

  • Starting out with data analytics

Introduction to Data and Data Analysis

  • 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

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
  • Discovering and interpreting existing data
  • Data sources and structures

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
  • Transforming data in Power BI
  • Common cleaning and transformation
  • Using built-in functions

Modeling Data

  • Relational databases
  • Modeling data for Power BI
  • Master data management
  • 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
  • Adding dashboard filters
  • Modifying dashboard tooltips

Job Mapping in the Data Analytics Field

  • Data workers
  • Data analysts
  • Data engineers
  • Data scientists

Continuing Your Data Analytics Learning Journey

  • Next steps and additional resources

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