Rafael
Portfolio

I used to tell stories while cultivating cells and tissues in a research laboratory. Now I tell them as a data analyst using SQL, R, and Tableau @Rafael .

Google Data Analytics Capstone: Bellabeat

Case Study: How Can a Wellness Technology Company Play It Smart? To answer key business questions, this project contains various real-world tasks of a data analyst following the steps of the data analysis process: Ask, Prepare, Process, Analyze, Share, and Act. The analyses were carried out in RStudio.

Google Data Analytics Capstone II:Cyclistic

Case Study II: How does a bike-share navigate speedy success? This project is made as a condition for the completion of Google Data Analytics Professional Certificate. The analyses were carried out on Google BigQuery Sandbox .

Advanced analysis in SQL

Aiming to optimize the operational efficiency and financial return of a company, I made the following queries in SQL Server Management Studio: 1) Set up SQL Database; 2) Find highest spending customers; 3) Find duplicate records; 4) Common table expression (CTE) to find Top selling products; 5) Calculate Revenue Growth by using LAG function; 6) Find the most recent Order Dates; 7) Find out which supplier had the highest sales using CTE; 8) Analyzing product performance and cumalative sales; 9) Compare product sales for given months and rank the products based on Sales Growth.

Data Cleaning
in SQL

Small mistakes can lead to big consequences in the long run. Therefore, clean data is very important for effective analysis. In this project, SQL Server Management Studio was used to clean data about housing in Nashville.