Business & Data Analytics

Lean Descriptive Analytics Specialized Skill Pathway Program (IM1005)


Description
90 Days | SCORM | info@imacia.org Course Description:

This certification course provides both foundational & applied knowledge in Descriptive analytics as part of Business Analytics. This course builds skills in describing data and learning about various tools to create, manage, reporting, extract measurements, interpret tables, and produce charts to support data insights and problem solving. Learners will be able to integrate concepts into application and practice.

Course Duration: 90 days from start date
Start Date: Date of registering and accessing course.
Course Format: Online & self-paced within course duration time frame.
Instructor: Available via in-class messages & in-class meeting capabilities
Contact Email Address: info@imacia.org
Course Objectives:
• Understand how to formulate and state a business problem
• Understand how to simply set a business analytics project to achieve results
• Learn the application and general difference of Descriptive analytics, Predictive analytics, and Prescriptive analytics
• Learn how to use some of Excel capabilities, how to Compare and contrast data, and use spreadsheet formats for analytics.
• Apply and compute descriptive analytics measurements of data sets to demonstrate knowledge and compare metrics between organizations or business.
• Produce Visual Analytics & interpret the meaning of measurement analysis outcomes and use Data Visualization
• Integrate the use of normal distributions with testing probabilities, hypothesis, or quality control approaches.

Course Outline:
• Introducing Business & Data Analytics
• Defining Business Problem
• Formulating & Prioritizing Problem Based Project
• Applying Business Analytics
• Descriptive Analytics
o Visualizing, Graphing & Exploring Data
o Descriptive Statistical Measures
o Probability Distributions and Data Modeling
o Sampling & Estimation
o Statistical Inference

Made especially affordable for IMACIA Social & Economic Mobility initiative.

Content
  • COURSE OVERVIEW
  • COURSE POLICY
  • COURSE MATERIALS
  • COURSE STRUCTURE
  • Introducing Business & Data Analytics
  • Introduction to Business & Data Analytics
  • Introduction to Business & Data Analytics
  • Business Analytics-Quick Review
  • Defining Business Problem
  • Simply Defining a Problem or Opportunity- How to?
  • Lesson
  • Defining the Problem
  • Defining the Problem
  • What Is a Problem Statement: Definition and Example
  • Formulating & Prioritizing Problem Based Project
  • Lesson: Defining a Project
  • Formulating & Prioritizing a Project
  • Project Priority & Screening
  • Applying Business Analytics
  • Introduction to Analytics on Spreadsheets
  • Learning Objectives
  • Lesson
  • Applying Business Analytics
  • Introduction to Excel 1
  • Excel Formulas & Functions
  • Excel Rows & Columns
  • Example on using Excel Functions
  • Date Function
  • Assessment - Practice Assignment [Go To Files]
  • Assessment -Quiz
  • Assessment - Practice Assignment [Go To Files]
  • Assessment - Quiz
  • Descriptive Analytics
  • Visualizing and Exploring Data
  • Introduction to Visualizing and Exploring Data
  • Learning Objectives
  • Lesson
  • Visualizing and Exploring Data
  • Create a chart from start to finish 1
  • How to Make a Histogram in Excel 2016
  • Pivot Table in Excel
  • Assessment - Practice Assignment [Go To Files]
  • Assessment - Quiz
  • Descriptive Statistical Measures
  • Introduction to Descriptive Statistical Measures
  • Learning Objectives
  • Lesson
  • Descriptive Analytics
  • Load the Analysis ToolPak & Solver in Excel
  • Installing Analysis ToolPack & Solver in Excel
  • Video: Descriptive Statistical Measures
  • Practice Assignment [Go To Files]
  • Practice Assignment Case Study: Drout Advertising
  • Quiz
  • Probability Distributions and Data Modeling
  • Introduction to Probability Distributions and Data Modeling sample
  • Learning Objectives
  • Lesson
  • Probability
  • Video1: Relative Freq. Definition of Prob. in Excel
  • Video2: Relative Freq. Definition of Prob. in Excel
  • Video3: Relative Freq. Definition of Prob. in Excel
  • Practice Assignment [Go To Files]
  • Quiz
  • Sampling & Estimation
  • Introduction to Sampling & Estimation
  • Learning Objective
  • Lesson
  • Populations and Samples
  • Sampling & Estimation
  • Sampling & Estimation in Excel
  • Practice Assignment [Go To Files]
  • Quiz
  • Statistical Inference
  • Introduction to Statistical Inference
  • Learning Objectives
  • Lesson
  • Statistical Inference
  • Statistical Inference 1
  • Statistical Inference 2
  • Materials - Statistical Inference Excel Tools
  • Assessment - Practice Assignment [Go To Files]
  • END
Completion rules
  • All units must be completed
  • Leads to a certificate with a duration: 1 year