warmice71 / dataanalystportfolioprojects

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
    

• 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 2020 Week 32 | Benefits of Working from Home: https://public.tableau.com/views/MakeoverMonday2020Week32BenefitsofWorkingfromHome/WORKFROMHOME?:language=en-GB&:display_count=n&:origin=viz_share_link

• Municipality Data Analysis Dashboard: https://public.tableau.com/views/MunicipalityDashboard/Municipality?:language=en-GB&:display_count=n&:origin=viz_share_link

• GROVER Junior Data Analyst Case Study Dashboard: https://public.tableau.com/views/GROVERJuniorDataAnalystCaseStudy/GroverDataAnalystDashboard?:language=en-GB&:display_count=n&:origin=viz_share_link

• Retail Pricing Analytics Dashboard: https://public.tableau.com/app/profile/priyankajhatheanalyst/viz/RetailPriceAnalyticsDashboard/RetailPricingAnalytics#2

• E-commerce Sales Dashboard: https://public.tableau.com/app/profile/priyankajhatheanalyst/viz/eCommerceSales_16310934566250/ExploratoryVisualAnalysis

• Sales SuperStore Deep Data Analysis (5 Dashboards): https://public.tableau.com/app/profile/priyankajhatheanalyst/viz/SuperStoreDataset5Dashboards/1KPIDashboard

  1 KPI Dashboard
  

  2 Top-Down Dashboard

  3 Q&A Dashboard

  4 Bottom-Up Dashboard

  5 Geo Chart

• World Bank CO2 Emissions Dashboard: https://public.tableau.com/views/WorldBankCo2Emissions_16149182681650/Dashboard1?:language=en-GB&:display_count=n&:origin=viz_share_link

• London Bus Safety Dashboard: https://public.tableau.com/views/TableauCertificationCourse2/ChartsDashboard?:language=en-GB&:display_count=n&:origin=viz_share_link

• Excel -

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

• Sales Superstore Sample: Sales Performance Dashboard
  

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

• Shipping Data: Pivot Tables, Pivot Chart, Slicers
  

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

---