uCertify

BSA250 Foundation of Data Analytics

(UOP-BSA250.AE2)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Introduction to 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
  • AI in Business Analytics
  • Responsible AI and Ethics
  • Closing Case 1
  • Closing Case 2
  • 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 XLOOKUP to Merge Data
  • Filtering and Sorting
  • Using PivotTables
  • Power Query for Data Cleaning
  • Power Pivot and Data Model
  • Dynamic Array Functions
  • Excel + AI (Copilot & Formula Generation)
  • Creating Dashboards with Slicers
  • Using Array Formulas
  • Solving Stuff with Solver
  • OpenSolver: I Wish We Didn't Need This, but We Do
2

Data Typologies and Governance

  • Opening Case
  • Introduction
  • Managing Data
  • The Database Approach
  • Big Data
  • Data Warehouses and Data Marts
  • Knowledge Management
  • Data Governance and Responsible AI
  • IT's About Business: Data Privacy in AI Systems
  • Closing Case 1
3

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

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

BSA250 Foundation of Data Analytics

$279.99

Buy Now

Related Courses

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