Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence Business Analytics

Essential Analytics for Solo and Small Business Owners

Harness the power of Excel toolpak. ROCK your statistics! MASTER data driven decision making. Your success depends on it
Rating: 4.5 out of 54.5 (32 ratings)
252 students
Created by Susan Kawa
Published 11/2015
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Build a basic analytics skill set crucial to small business success
  • Learn and practice charting techniques to visualize data
  • Understand variability - what it is, why it's killing your ability to recognize meaningful trends, and how to measure it
  • Learn why the shape, or frequency distribution of data is important
  • Practice finding frequency distribution of data sets using histogramming techniques
  • Learn simple tips on data collection and organization
  • Understand how to choose key performance measure(s) unique to your business
  • Create a model by "characterizing" those key business performance measures
  • Establish a performance baseline for your business
  • Learn methods and strategies to plan and implement change
  • Learn how to use a fishbone diagram proactively when planning change
  • Mathematically predict how long it will take to get statistically significant results
  • Learn to practice discipline and vigilance during change to reduce external influences
  • Understand and internalize that correlation and causation are different
  • Understand what "confidence level" means, and how much confidence is reasonable to expect
  • Learn step by step how to conduct a t-test on before-and-after data sets to see if they are different in a statistically significant way
  • Learn how to interpret t-test results
  • Understand the Pareto technique to create a long term success plan by prioritizing change
  • Understand why incremental failures can be constructive, and how to leverage that data to best advantage
  • Practice all the skills and techniques taught, start to finish, on two project businesses (using workbooks)

Requirements

  • Suitable for beginner Excel users.
  • Ideal for students who learn quickly when shown, and who appreciate lots of examples.

Description

This course teaches basics of business analytics, and translates that knowledge into practical application. Students will come away from this course knowing how to apply simple analysis tools to characterize key performance measures of their business both before and after a strategic change, and to expose and quantify statistically significant results even in the most variable business climate.

Students will learn that the critical need to differentiate a business introduces a complication: business strategies that work for the competitors might not work for them. A bit of trial and error is necessary. By designing a strategic approach and applying analytics as taught in this course, students will put their small or solo business on a steady upward trajectory.

Who this course is for:

  • Anyone thinking of quitting their day job to pursue a dream of self-employment
  • Anyone concerned about the variability of demand for their product or service
  • Anyone embarking on solo or small business ownership, but confused about how to predict performance in a volatile and ever changing market
  • Small business owners ready to invest in marketing, but nervous about getting quantifiable results
  • Anyone frustrated with advertisers who take your money and don't deliver on promises
  • Anyone in a business rut, searching for ways to raise their game
  • And also statistics students looking for less math and more context and examples in their instruction

Course content

7 sections • 59 lectures • 4h 29m total length

  • Preview05:08
  • Preview18 pages
  • Preview03:38
  • Preview04:22
  • Preview02:01

  • 2.01 Get Ready
    01:58
  • 2.02 Choose a Data Set
    04:44
  • 2.03 Data Collection and Mining
    04:16
  • 2.04 Characterizing a Data Set
    03:22
  • 2.05 Understanding Variability
    04:01
  • 2.06 Electric Bill Example
    02:52
  • 2.07 Charting Overview and Demonstration
    08:15
  • 2.08 Homework - Charting
    00:07
  • 2.09 Installing the Excel Analysis Toolkit
    02:17
  • 2.10 The Shape of Data
    05:24
  • 2.11 Introduction to Histogramming
    04:16
  • 2.12 Histogram Demonstration
    10:44
  • 2.13 Homework - Histogramming
    00:07
  • 2.14 Non Normal Adjustment
    02:53
  • 2.15 The Power of Outliers
    03:28
  • 2.16 Salon Example
    11:24
  • 2.17 Web Instructor Example
    11:07
  • 2.18 Project - Salon
    00:07
  • 2.19 Project - Web Instructor
    00:07

  • 3.01 Get Set
    02:27
  • 3.02 Establishing a Baseline
    05:04
  • 3.03 Considering Change From Varying Angles
    07:23
  • 3.04 Planning a Change
    06:15
  • 3.05 Isolate Influences
    04:07
  • 3.06 How Much Data Is Enough
    05:57
  • 3.07 The Calculation Explained
    2 pages
  • 3.08 Salon Example
    02:14
  • 3.09 Web Instructor Example
    03:30
  • 3.10 Homework - Determining Experimental Sample Size
    1 page

  • 4.01 Go
    02:55
  • 4.02 Implement Change
    06:05
  • 4.03 Data Collection
    06:04
  • 4.04 Monitoring for Interference
    03:56
  • 4.05 Correlation Versus Causation
    05:41

  • 5.01 Soar
    03:31
  • 5.02 Analysis Introduction
    04:48
  • 5.03 Variance Comparison
    05:21
  • 5.04 Confidence Levels Explained
    05:34
  • 5.05 T-Test Demonstration
    13:46
  • 5.06 Homework - The t-Test
    00:07
  • 5.07 Salon t-Test Example
    06:50
  • 5.08 Web Instructor t-Test Example
    07:27
  • 5.09 Homework - Practice the t-Test Using Business Data
    1 page

  • 6.01 Beyond
    03:52
  • 6.02 A Case for Constant Collection
    04:36
  • 6.03 Issues of Practicality
    10:34
  • 6.04 Introduction to Pareto Analysis
    04:54
  • 6.05 Pareto Demonstration
    03:47
  • 6.06 Homework - Pareto Analysis
    00:07
  • 6.07 The Amazing Factorial
    05:45

  • Preview03:23
  • Preview02:01
  • 7.03 Tools Used to Develop the Course
    01:39
  • 7.04 Student Resources
    01:35

Instructor

Susan Kawa
Career scientist, bringing the power of simple analytics to the small business community
Susan Kawa
  • 4.5 Instructor Rating
  • 32 Reviews
  • 252 Students
  • 1 Course

I come to web-based teaching with over 20 years tech industry experience in software, electrical, and systems engineering, including fascinating assignments across commercial technology, government defense, maritime, and aviation segments.

After shivering through my Electrical Engineering Bachelor's Degree at Cornell University, I basked through Master's Degree studies (Systems Engineering) at sunny Florida Tech.  My day job, a technical leadership role with a top-10 defense contractor, is analytics-centric: I hold a Six Sigma Green Belt, practice Earned Value as a Project Engineer, and spread wisdom on Capability Maturity Model Integration (CMMI) along technology's front lines. I’ve completed dozens of focus assignments on analytics, metrics development and retooling, and team “reprogramming.” Mentoring in the engineering department is my specialty.

My affiliations include: INCOSE (International Council on Systems Engineering), Society of Women Engineers, the 99's International Organization of Women Pilots, and American Mensa. In my free time, in addition to writing analytics coursework, I judge the science fair at the elementary level (because I'm not very scary), and write science grants for the local public schools.

I'm delighted to debut as a web-based instructor. Enjoy my course! I look forward to your feedback.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.