Portfolio Projects

Following are my projects in SQL, Python, Tableau & Excel: <br />

You can take a look at my personal website : www.priyankajha24.wixsite.com <br />

You can also take a look at my Linkedin : PriyankaJhaTheAnalyst <br />

• [x] SQL & Tableau -
  • Instagram Clone Data Analysis Project<br /> See on Tableau Public: Dashboard<br /> Review the Data Insertion SQL Script: HERE<br /> Review the Data Exploration SQL Script: HERE<br />

• [x] Hadoop (Hive) -

  • NYC Yellow Taxi Records: Data Analysis <br /> Review the HiveQL Script: HERE<br />

• [x] SQL -

  • Nashville Housing Dataset: Data Cleaning <br /> Review the SQL Script: HERE<br />

  • COVID-19 Dataset: Data Exploration <br /> Review the SQL Script: HERE<br />

• [x] PostgreSQL -

  • Business Intelligence Challenge <br /> Review the PostgreSQL Script: HERE<br /> Review the Google Slides Deck to see the Data Visualizations: HERE<br />

• [x] Python -

  • Movies Industry Dataset: Exploratory Data Analysis Project <br /> Read the complete Project Analysis in Markdown: HERE<br />

• [x] 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

• [x] Excel -

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

• Sales Superstore Sample: Sales Performance Dashboard <br />

• NetTRON Network Infrastructure Data : LOOKUP, INDEX, MATCH, SUMIFS <br />

• Shipping Data: Pivot Tables, Pivot Chart, Slicers <br />

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

---