Skip to content

This repository contains my Data Analytics portfolio projects ranging from SQL, Python, Tableau, Excel, and Hadoop (HiveQL).

Notifications You must be signed in to change notification settings

PriyankaJhaTheAnalyst/DataAnalystPortfolioProjects

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Portfolio Projects

Following are my projects in SQL, Python, Tableau & Excel:

You can take a look at my personal website : www.priyankajha24.wixsite.com

You can also take a look at my Linkedin : PriyankaJhaTheAnalyst

  • SQL & Tableau -
    • Instagram Clone Data Analysis Project
      See on Tableau Public: Dashboard
      Review the Data Insertion SQL Script: HERE
      Review the Data Exploration SQL Script: HERE

Instagram Clone Dashboard

  • Hadoop (Hive) -

    • NYC Yellow Taxi Records: Data Analysis
      Review the HiveQL Script: HERE
  • SQL -

    • Nashville Housing Dataset: Data Cleaning
      Review the SQL Script: HERE

    • COVID-19 Dataset: Data Exploration
      Review the SQL Script: HERE

  • PostgreSQL -

    • Business Intelligence Challenge
      Review the PostgreSQL Script: HERE
      Review the Google Slides Deck to see the Data Visualizations: HERE
  • Python -

    • Movies Industry Dataset: Exploratory Data Analysis Project
      Read the complete Project Analysis in Markdown: HERE
  • Tableau -

To view these Tableau Dashboards in Tableau Public, click on the hypertext link.

MakeoverMonday

Municipality Data Analysis

GROVER Junior Data Analyst

Retail Price Analytics

E-commerce Sales

KPI Dashboard

  2 Top-Down Dashboard

Top Down Dashboard

  3 Q&A Dashboard

Q&A Dashboard

  4 Bottom-Up Dashboard

Bottom Up Dashboard

  5 Geo Chart

Geo Chart

World Bank CO2 Emission

London Bus Safety

  • Excel -

Kindly download these Excel files from this repository and view them in Microsoft Excel.

  • Sales Superstore Sample: Sales Performance Dashboard

Dashboard

  • NetTRON Network Infrastructure Data : LOOKUP, INDEX, MATCH, SUMIFS

Dashboard

Dashboard

  • Shipping Data: Pivot Tables, Pivot Chart, Slicers

Dashboard

  • Project Costing Model Data: Scenario Manager, Solver (Data Modeling)

Dashboard

Dashboard

Dashboard