This website was built using CodeDesign.ai, an AI-powered platform. While we provide the tools and hosting, this site is independently owned and operated by one of our users.
This notice is shown on projects using our free plan. The site owner can remove this by upgrading to a premium plan.
Andrea Ramirez
Data Analyst
Data Analyst with a passion for data-driven insights and problem solving.
About me
I am a Data Analyst with a passion
to analyze and visualize data using Excel, SQL, and Power BI. I have completed Excel and SQL certifications and have hands-on experience in data analysis and database management. Please look at my highlighted projects below and feel free to contact me for any inquiries or opportunities. Thank you!
Skills and Projects
EXCEL -
CAUSES OF DEATH BETWEEN 2019-2021
I used Pivot Table, Dynamic Table, Charts, SUM function, AVG function, Sort and Filter, Find and Select, Hyperlink, Data Visualization, and Data Cleaning.
In case you can't download it, use this link: https://youtu.be/3B9rdk264_k
SQL -
HOTEL RESERVATION DATASET ANALYSIS BETWEEN 2017-2018
SQL project
where analyzed Hotel Reservation data based on arrival year and month, repeated guest and booking status.
Used aggregate functions, wildcards, Aliases, between, Union, having, Group by, Case, and comments.
In case you can't download it, use this link: https://youtu.be/yFZb2q_J1A0
EXCEL -
HOSPITAL CONSUMER ASSESSMENT OF HEALTHCARE PROVIDERS AND SYSTEMS (HCAHPS) SURVEY
Maven Healthcare Challenge. Analyzed HCAHPS scores to evaluate whether the survey has been successful in creating incentives for hospitals to improve their quality of care. Employed advanced techniques such as
Conditional Formatting, Pivot Tables, and dynamic Charting to distill complex data into actionable insights.
In case you can't download it, use this link: https://youtu.be/3pIjm8DIylA
POWER BI -
VACCINATION BY REGION BETWEEN 2020-2021
Analyzed vaccination data from 2020-2021 in regions around the world (Europe, America, Africa, Western Pacific, South-East Asia, and Eastern Mediterranean) using Power BI. Employed various visualization tools like treemaps, clustered bar charts, stacked column charts, cards, and pie charts for dynamic presentations.
In case you can't download it, use this link: https://youtu.be/kUslYbNdkdc
Projects
September - November 2023
HOSPITAL CONSUMER ASSESSMENT OF HEALTHCARE PROVIDERS AND SYSTEMS (HCAHPS) SURVEY
Maven Analytics
Created an Excel spreadsheet
employing advanced techniques such as Conditional Formatting, Pivot Tables, and dynamic Charting to distill complex data into actionable insights.
April - May 2023
VACCINATION BY REGION BETWEEN 2020-2021
World Health Organization "WHO"
I Analyzed vaccination data from 2020-2021 in regions around the world (Europe, America, Africa, Western Pacific, South-East Asia, and Eastern Mediterranean) using Power BI. Employed various visualization tools like treemaps, clustered bar charts, stacked column charts, cards, gauges, and pie charts for dynamic presentations.
January 2023
HOTEL RESERVATION DATASET
ANALYSIS BETWEEN 2017-2018
Kaggle.com
Created and analyzed a database in SQL (Microsoft SQL Server) to examine hotel reservation data, focusing on arrival year and month, repeat guests, and booking status. Utilized aggregate functions, wildcards, aliases, the BETWEEN operator, UNION, HAVING, GROUP BY, CASE statements, and comments.
November - December 2022
CAUSES OF DEATH BETWEEN 2019-2021
Data.gov
Analyzed data in Excel based on causes of death from 2019-2021 (during the COVID-19 timeline). I focused on the three main causes each year, broken down by sex, age, race, and Hispanic origin. Utilized functions such as Pivot Table, Dynamic Table, Charts, SUM function, AVG function, Sort and Filter, Find and Select, Hyperlink, Data Visualization, and Data Cleaning.
Certificates and Education
Maven Analytics
July 2023
ChatGPT for Data Analytics
Power BI Developer
May 2023
Power BI Developer
Corporate Finance
Institute
March 2023
Fundamentals of Data Analytics in Excel
W3school
January 2023
Certified SQL Developer
Google Certificate
November 2022
Google Data Analytics Certificate
Universidad Central de Venezuela
March 2012
Cardiopulmonary Technician Bachelor's Degree
Get in touch