- Data and Information - Data in the Real World - Data vs. Information - The Many “Vs” of Data - Structured Data and Unstructured Data - Types of Data - Data Analysis Defined - Why do we analyze data? - Data Analysis Mindset - Data Analysis Steps - Data Analysis Defined - Descriptive Statistics - Inferential StatisticsTypes of Variables - Categorical vs Numerical - Nominal Variables - 118 - - Ordinal Variables - Interval Variables - Ratio Variables - Central Tendency of Data - (Arithmetic) Mean - Median - Mode - Basic Probability - Probability Uses In Business - Ways We Can Calculate Probability - Probability Terms - Calculating Probability - Calculating Probability from a Contingency Table - Conditional Probability - Frequency Distribution Distributions, Variance, and Standard Deviation - Discrete Distributions - Continuous Distributions - Range - Quartiles - Variance - Standard DeviationPopulation vs. Sample - Application of the Standard Deviation - Standard Deviation and the Normal Distribution - Sigma (σ) Values (Standard Deviations) - Bimodal distribution, Skew and Summary - Other Distributions, Poisson Distribution - Exponential Distribution, Pareto Distribution (“80/20”) - Log Normal Distribution, Distributions in Excel - Fitting Data, Bivariate Data (Two Variables) - Covariance and Correlation, Simple Linear Regression - Linear Regression, Fitting Functions - Linear Fit, Polynomial Fit, Power-Law Fit, Advanced Charts & Dashboards - Heat Maps, Interactive, Animated Basic Data Visualization - Charting Overview, Types of Variables (categorical, numerical) - Types of Standard Charts, Charting Considerations