Data Analytic Principles/Habits
4.4 (22 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
182 students enrolled

Data Analytic Principles/Habits

A set of highly effective and easy to enforce habits that professionalize your analytic work
4.4 (22 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
182 students enrolled
Created by Eddie Jay
Last updated 5/2020
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 29 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Recognize the importance of a methodical approach to doing analytic work
  • Learn good habits for doing analytic work
  • Pick up universally applicable, practical, easy to enforce habits
Requirements
  • Some basic understanding of spreadsheet operations
  • A basic understanding of what doing analytic work entails
  • Open mind to change and practice your work habits
Description

Do you want to turn your analytic work from mediocre to great?

Do you want to shine at the workplace by demonstrating a superior, professional analytic ability?

Then this course is for you... Read on please.

Over 15 years, I identified a number of steps that elevate the quality of data analytic work. When done habitually, these steps will professionalize the analysis, making it more error resistant, flexible and effective in answering the “question”. This content is what I wish someone taught me when I first started working as a data analyst.

Course content:

  1. Context
  2. Preparations (filing system, inputs, model structure)
  3. Building (calculations, testing/checking, documentation)
  4. Output (results, presentation, iterations)

I have distilled the content into easy to remember sections to ensure that you gain a long lasting value from this course. Each section comes with supplemental material including poster for easy reminder and course reading that for reinforcements.

In Summary

Goal - Help you learn and adopt good habits when doing analytic work.

Format - 40 mins of videos that introduce the principles and illustrate the principles through an example. Poster and Reading Materials for each section serves as cheat sheets for future reference and enforcement.

Target Audience - Beginner level data analysts or Students who are about to enter the workforce (data, statistical, financial analyses)

This course is not a training program on how to use MS Excel. We use Excel to illustrate the principles; not hours on hours of lectures that are hard to remember. 40 minutes is all you need.

Who this course is for:
  • Beginner data/financial analysts
  • Anyone doing regular spreadsheet work
  • Students who are about to enter the workforce
Course content
Expand all 23 lectures 01:01:17
+ Welcome and introduction
2 lectures 04:04

Introduction to the Habits for Excellence in Analysis course.

Preview 02:14

Introduction to the course chapters and format

Preview 01:50
+ Understanding the Context
3 lectures 10:02

Principles of understanding the Context

Preview 03:06

The example video illustrates how the principles in the previous video is applied in the Chocolate Factory analysis. Note the supplementary material.

Preview 02:53

Bonus section from my Predictive Modeling in Healthcare Course

Planning an analysis
04:03
Why plan
1 question
+ Preparations
6 lectures 17:31

Principles of a good filing system, including folders, file layout and text/colour formats

Filing System
02:34

This example video illustrates how the principles in the previous video is applied in the Chocolate Factory analysis. Note the supplementary material.

Filing System example
04:34

Principles on working with input items

Input Items
02:57
What affects quality of input items?
1 question

Be careful when using input items such as data and assumptions. Make sure they are relevant and correct.

Input Items checking example
02:44

Principles on designing the model structure

Model structure
02:36
What personality attribute makes a great data analyst?
1 question

Illustrates the application of model structure principles in our Chocolate Factory example.

Model Structure example
02:06
+ Building
7 lectures 19:26

Principles for building the formulas and performing the calculations

Attached are two PDF print outs containing the

Most Useful Keyboard shortcuts

Most Useful Formulas in Excel

Building principle
02:09

Recommended steps for building your analysis

Building "Dos"
02:43
Building "Don'ts"
03:14

Principles on doing testing and checking of your analysis

Testing and Checking
03:33
What can be said about testing and checking?
1 question

Example illustrating testing and checking through our Chocolate factor example

Testing and Checking example
03:25

Detailed documentation is critical to your work

Preview 01:39

Illustration of principles of documenting your work

Documentation example
02:43
Why is documentation important?
1 question
+ Output
5 lectures 10:14

Principles on generating great and useful results

Results
01:57

Illustrates how principles relating to results were applied for the Chocolate Factory example

Results example
02:59

Principles on making great presentations of the results

Presentation
01:21

Illustration of how the results could be presented from our Chocolate factory example

Presentation example
03:20

No one gets it right the first time! Iterative refinements are required to identify issues and improve your analysis over time.

Refinements
00:37