Udemy

Introduction to Data Analytics with Microsoft Excel

立即報名
  • 6,158 名學生
  • 更新於 6/2024
  • 可獲發證書
4.5
(132 個評分)
  • 提示:
  • 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期*
全年招生
課程級別
學習模式
修業期
3 小時 32 分鐘
教學語言
英語
授課導師
Wayne Bowden
證書
  • 可獲發
  • (證書的發放與分配,依課程提供者的政策及安排而定。)
評分
4.5
(132 個評分)
課程連結
*提示: 以上時間表僅供參考,以機構網站為準。

課程簡介

Introduction to Data Analytics with Microsoft Excel

Master data analysis through Excel with advanced hands on practical training

Requirements

  • Microsoft Office 365 or Excel 2010 - 2019

  • Mac users Pivot Visuals may look slightly different to the examples shown

  • Basic experience with Excel functionality is a bonus but not required

Description

Welcome to the world of Data Analytics, voted the sexiest job of the 21st Century.

In this expertly crafted course, we will cover a complete introduction to data analytics using Microsoft Excel, you will cover the concepts, the value and practically apply core analytical skills to turn data into insight and present as a story.

Look at this as the first step in becoming a fully-fledged Data Scientist


Course Outline

The course covers each of the following topics in detail, with datasets, templates and 17 practical activities to walk through step by step:

What is Data Analytics

  • Why Do We Need It in this new world

  • Thinking about Data, how it works in the lad v how it works in the wild

  • Qualitative v Quantitative data and their importance

Finding Your Data

  • How to find Sources of Data and what they contain

  • Reviewing the Dataset and getting hands on

Analysing Your Data

  • Mean, Modes, Median and Range

  • Normal and Non normal Data and its impacts to predictability

  • What is an Outlier in our data and how do we remove

  • Distribution and Histograms and why they are important

  • Standard Deviation and Relative Standard Deviation, why variance is the enemy

  • What are Run and Control charts and what do they tell us?


Working With Pivot Tables

  • How the Pivot Builder Works

  • Setting Our Headers

  • Working with calculated fields

  • Sorting and Filtering

  • Transforming Data with Pivot Tables


Data Engineering

  • How to create new, insightful datasets

  • The importance of balanced data

  • Looking at Quality, Cost and Delivery together


Start Telling Our Analytical Story

  • What is your data telling?

  • Ask Yourself Questions

  • Transforming Data into Information


Visualizing Your Data

  • Levels of Reporting

  • What Chart to Use

  • Does Color Matter

  • Let's Visualize Some Data


Presenting Your Data

  • Bringing The Story Together with a Narrative


Practical Activities

We will cover the following practical activities in detail through this course:

  • Practical Example 1 - Mean, Mode, Median, Range & Normality

  • Practical Example 2 - Distribution and Histograms

  • Practical Example 3 - Standard Deviation and Relative Standard Deviation

  • Practical Example 4 - A Little Data Engineering

  • Practical Example 5 - Creating a Run Chart

  • Practical Example 6 - Create a Control Chart

  • Practical Example 7 - Create a Summary Pivot of Our Claims Data

  • Practical Example 8 - Transforming Data

  • Practical Example 9 - Calculated Fields, Sorting and Filtering

  • Practical Example 10 - Lets Engineer Some QCD Data

  • Practical Example 11 - Lets Answer Our Analytical Questions with Pivots

  • Practical Example 12 - Visualizing Our Data

  • Practical Example 13 - Lets Pull our Strategic Level Analysis Together

  • Practical Example 14 - Lets Pull our Tactical Level Analysis Together

  • Practical Example 15 - Lets Pull our Operational Level Analysis Together

  • Practical Example 16 - Lets Add Our Key Findings

  • Practical Example 17 - Lets Add Our Recommendations

Who this course is for:

  • Anyone who works with Excel on a regular basis and wants to supercharge their skills

  • Excel users who have basic skills but would like to become more proficient in data exploration and analysis

  • Students looking for a comprehensive, engaging, and highly interactive approach to training

  • Anyone looking to pursue a career in data analysis or business intelligence

課程章節

  • 11 個章節
  • 56 堂課
  • 第 1 章 Course Overview
  • 第 2 章 Introduction
  • 第 3 章 What is Data Analytics?
  • 第 4 章 Finding Your Data
  • 第 5 章 Analysing Your Data Part 1
  • 第 6 章 Analysing Your Data Part 2
  • 第 7 章 Working with Pivot Tables
  • 第 8 章 Start Telling Our Analytical Story
  • 第 9 章 Data Visualization
  • 第 10 章 Presenting Your Data
  • 第 11 章 And That's a Wrap

課程內容

  • What is Data Analytics & Why is it so Important
  • Why Do We Need Analytics? What's Changed?
  • How to Find Appropriate Datasets to work with
  • How to Analyse you Data
  • The importance of Mean, Mode, Median and Range of Data
  • What is the difference between Normal and Non Normal Data
  • How to create a histogram
  • How to find and remove outliers
  • Understand what is a standard deviation and relative standard deviation
  • Understand the Difference Between a Run and a Control Chart?
  • The basics of working with pivot tables
  • Starting to Tell Our Analytical Story
  • How to Visualize our data
  • How to Present You data and bring the story together


評價

  • S
    Sefunmi Ojo
    5.0

    At first had no knowledge of data analytics, I just understand what it is about

  • T
    Teo Jia Hui
    4.0

    Yes, Wayne's practical approach to teaching Excel is what I've been looking for.

  • J
    Jansen Espadon
    4.0

    It was fun and interesting to learn DA

  • N
    Ndiok Uwem Daniel
    5.0

    Very perfect, it reminds me of my control engineering back in school.

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策與使用條款才繼續瀏覽。

我已閱讀及同意