Hi! I'm Padmashree!

I am an enthusiastic, data-driven Google Data Analytics Professional Certificate recepient with expertise in data analysis and visualization.

Portfolio

All
SQL
Tableau
Excel
R
Virtual Internship

Capstone - Cyclistic data

  • Imported 12 excel datasheets with millions of entries into R, then used tidyr package to clean the datasets and prepare them for analysis
  • Joined all of the datasets together, created subsets of the data, and converted each attribute to the proper data type before performing analysis to find differences between members and casual customers
  • Developed visuals using the ggplot2 package to display the analysis results and provide meaningful conclusions for stakeholders to act on
X
View Rmd Code & Output

IMDB Movies - Analysis

  • Evaluated the top 250 IMDB movies dataset in SQLite, identified and addressed issues such as missing values, inconsistencies, duplicates, and errors.
  • Performed necessary data transformations, handled missing values, ensured consistent formatting, eliminated duplicate entries, validated data accuracy and conducted quality checks.
  • Normalized the data structure as required, ensuring adherence to defined rules, and saved the cleaned dataset in SQLite for subsequent analysis or visualization purposes.
X
View SQL Code

Covid19 Dashboard

  • Cleaned and analyzed a dataset on COVID statistics in Microsoft SQL Server, creating views with subsets of the data to analyze specific variables
  • Created various visuals in Tableau, including bar charts, line graphs, and a map chart to display data conclusions, then compiled them into a dashboard
X
View Tableau

Rental Prices in NYC

  • Using Airbnb NYC 2019 data to draw insights on various neighborhood popularities and price comparison
  • Based on the insights generated from the data, Airbnb hosts can make informed decisions about pricing and availability
X
View Tableau

IMDB Movies- Visualization

  • Imported and configured the CSV files, ensuring data accuracy for further analysis and visualizations
  • Created compelling visual representations by selecting appropriate chart types, customizing visual elements, and leveraging Tableau's features.
  • Assembled the visualizations into a cohesive layout, added interactive elements, and refined the dashboard to effectively showcase insights and findings.
X
View Tableau

Bike Sales

  • Cleaned and analyzed a dataset on Excel spreadsheet. Using pivot table gained demographic insights of the users
  • Developed interactive dashboard using the pivot charts
X
View Spreadsheet

US Presidents

  • Identified and addressed issues such as missing values, inconsistent formatting, duplicates, and errors in the US Presidents' dataset
  • Removed unnecessary columns, handled missing values, standardized formatting, eliminated duplicates, validated accuracy, and performed necessary calculations or transformations
X
View Excel

Social Buzz

  • Identified and removed unnecessary columns, handled missing values, standardized formatting, eliminated duplicates, validated accuracy, and performed necessary calculations or transformations data provided by Social Buzz
  • Developed charts to draw insights and then presented data to the client
X
View Certificate

Wine Quality

  • Cleaned and manipulated data
  • Developed visualization to draw insights
X
View R code & Output

About Me

I am a Google Data Analytics Professional Certificate recepient with expertise in data analysis and visualization. I have experience in managing Management Information Systems (MIS) ISO audit files in the wind turbine assembly industry and am proficient in SAP Enterprise Resource Planning (ERP) module and Customer Relationship Management (CRM).

  • Proficient in data cleaning, modeling and analysis using tools such as R, SQL and Excel/spreadsheets
  • Skilled in data visualization tools such as Tableau
  • Detail-oriented professional with a track record of meeting deadlines and collaborating with cross-functional teams
  • Strong background in quality management systems and maintaining compliance with ISO standards
  • Skilled in Customer Relationship Management

Completed a rigorous Data Analytics and Business Intelligence program with a focus on developing information gathering, data cleaning, data modeling, database schema, data visualization, and analysis skills in order to obtain the Google Data Analytics and Business Intelligence certificates.

I am passionate about leveraging data analytics to drive data-informed decision-making and create meaningful impact. Seeking opportunities to optimize processes, drive efficiency, and deliver results through data analysis. Let's connect and explore opportunities to collaborate!

Contact

Please reach out on LinkedIn or Email (padmashree dot ravikiran3 at gmail dot com)