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

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More