DataAnalystPortfolioProjects
DataAnalystPortfolioProjects copied to clipboard
This repository contains my Data Analytics portfolio projects ranging from SQL, Python, Tableau, Excel, and Hadoop (HiveQL).
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
- [x] SQL & Tableau -
-
[x] Hadoop (Hive) -
- NYC Yellow Taxi Records: Data Analysis
Review the HiveQL Script: HERE
- NYC Yellow Taxi Records: Data Analysis
-
[x] SQL -
-
[x] PostgreSQL -
-
[x] Python -
- Movies Industry Dataset: Exploratory Data Analysis Project
Read the complete Project Analysis in Markdown: HERE
- Movies Industry Dataset: Exploratory Data Analysis Project
-
[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
- NetTRON Network Infrastructure Data : LOOKUP, INDEX, MATCH, SUMIFS
- Shipping Data: Pivot Tables, Pivot Chart, Slicers
- Project Costing Model Data: Scenario Manager, Solver (Data Modeling)