README.md

📊 Shreya's Portfolio

Welcome to my portfolio repository showcasing my journey and expertise as a Data Analyst. Here, you'll find a curated collection of projects, analyses, and visualizations that demonstrate my skills in extracting insights from data and translating them into actionable solutions.

Table of Contents

• SQL
• Python
• MS Excel
• HTML and CSS

SQL

Project Name	DBMS Used	Major Functions	Repository Link
Student Analytics	PostgreSQL, PGAdmin	Subqueries, SUM, AVG, ROUND, SELECT	Repository
Danny's Diner	PostgreSQL, PGAdmin	Subqueries, JOINs, ROW_NUMBER()	Repository
McDonald's Menu Analysis	PostgreSQL, PGAdmin	Subqueries, SUM, AVG, ROUND, SELECT	Repository

MS Excel

Name of Project	Skills Used	Link of Repository
Drug Death Analysis	Charts and Visualizations	Repository

HTML and CSS

These projects were created as a part of the Responsive Developer Challenges of DevChallenges.io.

Project Name	Project Description	Repository	Deployment
Minimal Blog Card	Concepts of Basic HTML and CSS such as tags, card components, and CSS styling were used.	Repository	Deployment
Business Blog Card	Concepts of Basic HTML and CSS such as tags, card components, and CSS styling were used, along with advanced CSS concepts such as Flexbox and Grid.	Repository	Deployment
Testimonial Page	Using the basic concepts of HTML, CSS, Flexbox, Grid and Bootstrap, a visually captivating testimonial page is created.	Repository	Deployment
Contacts Page	Using the basic concepts of HTML, CSS, Flexbox, Grid and Bootstrap, along with HTML Forms, a visually captivating testimonial page is created. This page employs techniques liked media queries for responsiveness across different screen sizes.	Repository	Deployment
Simple Homepage	By employing fundamental HTML, CSS, Flexbox, Grid, and Bootstrap principles, as well as HTML Forms, a visually engaging simple homepage has been crafted. This page incorporates techniques like media queries to ensure responsiveness on various screen sizes.	Repository	Deployment