Data-Analytics-Essentials

This repository contains all the projects I completed while enrolled on Cisco's Data Analytics Essentials course.

Table of Contents

• Module 2: Getting started with Data Gathering and Investigation
• Module 3: Preparing and cleaning data for analysis
• Module 4: Transforming data with Excel
• Module 5: Analyse the data using statistics
• Module 6: Introduction to relational databases and SQL
• Module 7: Introduction to Structured Queries
• Module 8: Introduction to Tableau

Module 2: Getting started with Data Gathering and Investigation

Basic Excel concepts and features

Lab - Excel Practice
Excel - Bike Sales Data

Module 3: Preparing and cleaning data for analysis

Data in structured files

Lab - Working with CVS files
CVS - My CVS

Data Preparation

Lab - Preparing Data
Excel - Bike sales prepare lab (fixed)

Module 4: Transforming data with Excel

Sorting and filtering data with Excel

Lab - Using Excel to sort and filter data
Excel - Bike sales sort

Formatting and adjusting data

Lab - Manipulate data
Excel - Bike sales manipulate

Data calculations

Lab - Formulas and functions
Excel - Bike Sales Function

Lab - Pivot tables
Excel - Bike sales pivot

Module 5: Analyse the data using statistics

Creating Visualisations with Excel

Lab - Creating Visualisations in Excel
Bike sales visualizations

Addressing anomalies in data

Lab - Interperate visualisations with respect to outliers
Excel - Bike Sales Outliers

Using Excel to address issues with data

Lab - Using VLOOKUP in data analysis
Excel - Bike sales VLOOKUP

Module 6: Introduction to relational databases and SQL

SQL

SQL - SQL around the world
SQL - Ordering and limiting SQL - Successful Movies
SQL - Grouping Data SQL - Calculated Columns

Module 7: Introduction to Structured Queries

Combining SQL functions to extract data

SQL - Joining Tables

Module 8: Introduction to Tableau

Introducing Tableau

Lab - Exploring Tableau
Excel - Movies data

Create visualisations in Tableau & Tableau dashboards

Lab - Creating a Visualization
CSV - Hollywoods Most Profitable Stories
Lab - Dashboarding​
Tableau - Profitability and Worldwide Gross of Top 10 Rated Films by Genre​