Become a Data Analyst 

Introduction

Imperative Nontechnical Skills

Conclusion

Introduction

Foundational Concepts of Data Analysis

Visualizing Data

Testing a Hypothesis

Utilizing Data Distributions

Measuring Covariance and Correlation

Calculating Probabilities, Combinations, and Permutations

Performing Bayesian Analysis

Conclusion

Introduction

Think with Data

Prepare Data

Adapt Data

Explore Data

Describe Data

Probability and Inference

Continuing Your Data Fluency Learning Quest

Introduction

Getting Started with Data Analysis

Fundamentals of Data Understanding

Key Elements to Understand when Starting Data Analysis

Getting Started with a Data Project

Data Importing, Exporting, and Connections

Getting Started with Data Cleaning and Modeling

Applying Common Techniques for All Data Analysts

Conclusion

Introduction

Working with Business Data

Building Data Sets with Queries

Chart Data Anytime and Anywhere

Pivot Data Anytime and Anywhere

Building in Power BI Desktop

Power Query Tips and Tricks for Data Analysts

Presenting Data in Meetings

Conclusion

Introduction

Excel Statistics Fundamentals

Types of Data

Probability

Central Tendency

Variability

Distributions

Normal Distributions

Sampling Distributions

Estimation

Hypothesis Testing

Testing Hypotheses about a Mean

Testing Hypotheses about a Variance

Independent Samples Hypothesis Testing

Matched Samples Hypothesis Testing

Testing Hypotheses about Two Variances

The Analysis of Variance

After the Analysis of Variance

Repeated Measures Analysis

Hypothesis Testing with Two Factors

Regression

Correlation

Conclusion

Introduction

What Is Data Mining and Predictive Analytics?

Problem Definition

Data Requirements

Resources You Will Need

Problems You Will Face

Finding the Solution

Putting the Solution to Work

The Nine Laws of Data Mining

Conclusion

Introduction

Get Started with Power BI

Get Data

Create a Report with Visualizations

Modify and Print a Report

Create a Dashboard

Share Data with Colleagues and Others

Use Power BI Mobile Apps

Use Power BI Desktop to Model Data

Conclusion

Introduction

Big Idea

What to Think About

Selecting the Visualization Type

Designing Visualizations for Impact

Conclusion

Introduction

Introducing Tableau

Managing Data Sources and Visualizations

Managing Tableau Worksheets and Workbooks

Creating Custom Calculations and Fields

Analyzing Data

Sorting and Filtering Tableau Data

Defining Groups and Sets

Creating Basic Visualizations

Formatting Tableau Visualizations

Annotating and Formatting Visualizations

Mapping Geographic Data

Creating Dashboards and Actions

Conclusion

Introduction

Prepare to Code in SQL

Use SQL to Report Data

Group Your SQL Results

Merge Data from Multiple Tables

More Advanced SQL

Introduction

What Is R?

Getting Started

Importing Data

Visualizing Data with ggplot2

Wrangling Data

Recoding Data

Conclusion

Introduction

Bad Data

Causes of Errors

Detecting Errors

Preventing Errors

Fixing Errors

Conclusion