uCertify

Introduction to Data Analytics

(AU-DA.AEJP1)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

The Value of Data

  • Opening Case
  • Introduction
  • Managers and Decision Making
  • The Business Analytics Process
  • Business Analytics Tools
  • Business Analytics Models: Descriptive Analytics, Predictive Analytics, and Prescriptive Analytics
  • Summary
  • Discussion Questions
  • Closing Case 1
  • Closing Case 2
2

Working with Data

  • Some Sample Data
  • Moving Quickly with the Control Button
  • Copying Formulas and Data Quickly
  • Formatting Cells
  • Paste Special Values
  • Inserting Charts
  • Locating the Find and Replace Menus
  • Formulas for Locating and Pulling Values
  • Using VLOOKUP to Merge Data
  • Filtering and Sorting
  • Using PivotTables
  • Using Array Formulas
  • Solving Stuff with Solver
  • OpenSolver: I Wish We Didn't Need This, but We Do
3

Data Typologies and Governance

  • Opening Case
  • Introduction
  • Managing Data
  • The Database Approach
  • Big Data
  • Data Warehouses and Data Marts
  • Knowledge Management
  • Summary
  • Discussion Questions
  • Problem-Solving Activities
  • Closing Case 1
  • Closing Case 2
4

Business Statistics

  • Introduction to Probability
  • Structure of Probability
  • Marginal, Union, Joint, and Conditional Probabilities
  • Addition Laws
  • Multiplication Laws
  • Conditional Probability
  • Revision of Probabilities: Bayes' Rule
  • Introduction to Hypothesis Testing
  • Testing Hypotheses About a Population Mean Using the z Statistic (σ Known)
  • Testing Hypotheses About a Population Mean Using the t Statistic (σ Unknown)
  • Testing Hypotheses About a Proportion
  • Testing Hypotheses About a Variance
  • Solving for Type II Errors
  • Summary
  • Formulas
  • Supplementary Problems
  • Analyzing the Databases
  • Case - Colgate-Palmolive Makes a “Total” Effort
5

Optimization and Forecasting

  • Why Should Data Scientists Know Optimization?
  • Starting with a Simple Trade-Off
  • Fresh from the Grove to Your Glass…with a Pit Stop through a Blending Model
  • Modeling Risk
  • Wait, What? You're Pregnant?
  • Don't Kid Yourself
  • Predicting Pregnant Customers at RetailMart Using Linear Regression
  • Predicting Pregnant Customers at RetailMart Using Logistic Regression
  • For More Information
  • Correlation
  • Introduction to Simple Regression Analysis
  • Determining the Equation of the Regression Line
  • Residual Analysis
  • Standard Error of the Estimate
  • Coefficient of Determination
  • Hypothesis Tests for the Slope of the Regression Model and Testing the Overall Model
  • Estimation
  • Using Regression to Develop a Forecasting Trend Line
  • Interpreting the Output
  • Summary
  • Formulas
  • Supplementary Problems
  • Analyzing the Databases
  • Case - Caterpillar, Inc.
6

Data Visualization

  • Why Do We Visualize Data?
  • How Do We Visualize Data?
  • Color
  • Common Chart Types
  • When Our Visual Processing System Betrays Us
  • Every Decision Is a Compromise
  • Summary
7

Taking Off with Tableau

  • Foundations for building visualizations
  • Visualizing data
  • Using Show Me
  • Putting everything together in a dashboard
  • Summary
8

Connecting to Data in Tableau

  • The Tableau paradigm
  • Connecting to data
  • Managing data source metadata
  • Working with extracts instead of live connections
  • Using sets and groups
  • Filtering data
  • Summary
9

Telling a Data Story with Dashboards

  • Introduction to dashboards
  • Designing dashboards in Tableau
  • A dashboard to understand profitability
  • Designing for different displays and devices
  • Interactivity with actions
  • A regional scorecard dashboard
  • Stories
  • Summary
10

Other Data Analytic Tools

  • Getting Up and Running with R
  • Doing Some Actual Data Science
11

Prepare the data

  • Skill 1.1: Get data from different data sources
  • Skill 1.2: Profile the data
  • Skill 1.3: Clean, transform, and load the data
  • Lesson summary
  • Thought experiment
12

Visualize the data

  • Skill 3.1: Create reports
  • Skill 3.2: Create dashboards
  • Skill 3.3: Enrich reports for usability
  • Lesson summary
  • Thought experiment

1

The Value of Data

  • Summarizing the Aspects of Business Analytics and its Applications
2

Working with Data

  • Freezing the Top Row
  • Using the AVERAGE Function
  • Using Relative, Absolute, and Mixed References
  • Formatting Numbers
  • Applying Conditional Formatting
  • Using the Paste Special Feature
  • Analyzing Data Using a Line Chart
  • Creating a PivotTable Automatically
  • Calculating the Minimum and Maximum Sales Value
  • Using the SUM Function
  • Using the MATCH Function
  • Using the VLOOKUP Function
  • Sorting Data
3

Data Typologies and Governance

  • Understanding Big Data
  • Understanding the Relational Database Model
4

Business Statistics

  • Understanding Business Statistics
  • Calculating the Statistics
5

Optimization and Forecasting

  • Using the SUMIF Function
  • Using the IF Function
6

Data Visualization

  • Visualizing Data
  • Understanding Data Visualization
  • Creating and Analyzing Chart Types
7

Taking Off with Tableau

  • Creating a Connection in a New Workbook
  • Creating a Bar Chart
  • Creating a Line Chart
  • Creating Filled, Symbol, and Density Maps
  • Using the Show Me Toolbar
  • Building a Dashboard
8

Connecting to Data in Tableau

  • Viewing the Aggregate Data
  • Connecting to an Excel File
  • Managing Metadata
9

Telling a Data Story with Dashboards

  • Creating a Dashboard and Implementing Actions
  • Using a Set Action
  • Creating a Regional Scoreboard
  • Creating a Story
10

Other Data Analytic Tools

  • Using the factor() Function
  • Using the str() Function
  • Using the sqrt() Function
  • Using the matrix() Function
  • Using the length() Function
  • Using the rbind() and cbind() Functions
  • Using the aggregate() Function
  • Using the order() Function
  • Using the predict() Function
  • Using the print() Function
  • Using the summary() Function
  • Using the which() Function
11

Prepare the data

  • Creating a Data Connection
  • Profiling Data in Power BI
  • Using the Transpose Feature
  • Shaping Data for Analysis
  • Cleaning, Transforming, and Loading Connected Data
12

Visualize the data

  • Reviewing Custom Visuals and Apps
  • Filtering and Slicing Reports
  • Customizing Visuals in Power BI
  • Charting Data in Power BI
  • Creating Visualizations
  • Configuring the Mobile Layout
  • Incorporating Tooltips to Enhance Data Analysis
  • Saving and Exporting Files in Power BI

Related Courses

All Courses