Ra'Meca | Aspiring Data Analyst

Ra'Meca

Aspiring Data Analyst

Based in Frisco, TX

About

I am currently a Business Services Coordinator in the healthcare field. I routinely work with small and large datasets. I love cleaning, transforming, and analyzing data to unveil information needed to obtain solutions to problems. I am passionate about data and desire to acquire the necessary skills to become a Data Analyst. I am currently enrolled in Merit America's Data Analytics program with an expected completion date of June 2024.

Skills

Projects

Querying Databases Using SQL SELECT Statement

Retrieved data from various tables in the employees database by setting conditions & using different SQL operators with the WHERE clause. Used wildcard characters, sorted result sets, limited results, and selected distinct data.

Capstone Project "Coming Soon"

Excel Charts & Dashboards

Took sales data and created pivot tables to summarize the data. From those pivot tables, I created line charts, bar charts, and pie charts to visualize the data. Finally, I created a dashboard to portray all of this information in a cohesive manner.

Demo Video - Creating Charts in Excel

This is a quick video showing how to create different charts from pivot tables and then creating a dashboard with those charts.

Citibike Trips Jan 2024

This project explores bike data for New York in January 2024. The data was sourced from citibikenyc.com. Some key information such as the most popular start & end stations are displayed via a map as well as the preferred bike type amongst members & casual riders.

Education

Expected Completion June 2024

Google Data Analytics Professional Certificate

Gained key analytical skills such as anlaysis, data cleaning, and visualization. Became proficient in SQL, R programming, spreadsheets, and Tableau. Learned to visualize and present data findings in dashboards and common visualization platforms.