Skip to content
View felipeandrade91's full-sized avatar

Block or report felipeandrade91

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
felipeandrade91/README.md

Hi, I'm Felipe Andrade

Data Analyst | SQL | PostgreSQL | Python | Power BI | Customer Analytics | Analytics Engineering

I'm a Data Analyst and PhD researcher with over 15 years of experience transforming complex real-world datasets into actionable insights through SQL, Python, Power BI, statistics, and analytical modeling.

My scientific background has strengthened my analytical thinking, hypothesis-driven problem solving, and ability to design reproducible analytical workflows.

Today, I apply these skills to solve business problems in Business Intelligence, Analytics Engineering, and Customer Analytics.

Applying scientific rigor and analytical thinking to solve business problems through modern data analytics.


Tech Stack

Analytics & Business Intelligence

  • SQL
  • PostgreSQL
  • Power BI
  • DAX
  • Power Query (M)
  • Analytics Engineering
  • Customer Analytics
  • Customer Segmentation
  • Customer Lifetime Value (CLV)
  • Star Schema
  • Data Modeling

Programming & Analytics

  • Python
  • Pandas
  • Matplotlib
  • R
  • Statistics
  • Machine Learning

Tools

  • Git
  • GitHub
  • DBeaver
  • Excel

Featured Projects

⭐ Customer Analytics for Brazilian E-commerce

End-to-end Analytics Engineering and Business Intelligence project built with PostgreSQL, SQL, and Power BI, featuring a Star Schema data model, SQL semantic layer, business KPIs, and interactive executive dashboards.

🔗 Repository

https://github.com/felipeandrade91/Customer-Analytics-for-Brazilian-E-commerce


⭐ Customer Segmentation & Customer Lifetime Value Analytics

Customer Analytics project built with PostgreSQL, SQL, and Python, extending the previous analytical foundation through customer feature engineering, RFM segmentation, Historical Customer Lifetime Value (CLV) analysis, and business-oriented data visualization.

🔗 Repository

https://github.com/felipeandrade91/customer-segmentation-clv


📂 Data Analytics Portfolio

A curated collection of my Business Intelligence, Analytics Engineering, Customer Analytics, SQL, Python, Power BI, Statistical Analysis, and Machine Learning projects.

🔗 Repository

https://github.com/felipeandrade91/Data-Analytics-Portfolio


Scientific Background

  • PhD in Animal Biology (UNICAMP)
  • Postdoctoral Researcher (USP)
  • 28 peer-reviewed scientific publications
  • Description of 13 new amphibian species
  • 15+ years working with complex real-world datasets

Connect with Me

💼 LinkedIn

https://linkedin.com/in/felipeandrade91

Pinned Loading

  1. Brazilian-Anuran-Diversity-Dashboard Brazilian-Anuran-Diversity-Dashboard Public

    Interactive Power BI dashboard exploring the spatial and temporal patterns of Brazilian anuran diversity using GBIF occurrence records.

    1

  2. gbif-amphibians-etl-pipeline gbif-amphibians-etl-pipeline Public

    This project was developed as a portfolio piece focused on biodiversity data engineering, demonstrating skills in SQL-based ETL pipelines, data quality assessment, and analytical dataset construction.

    1

  3. GBIF-Brazilian-Amphibian-Biodiversity-Analysis GBIF-Brazilian-Amphibian-Biodiversity-Analysis Public

    This project presents an exploratory and statistical analysis of amphibian occurrence records in Brazil using data from the Global Biodiversity Information Facility (GBIF).

    Jupyter Notebook 1

  4. Customer-Analytics-for-Brazilian-E-commerce Customer-Analytics-for-Brazilian-E-commerce Public

    End-to-end Customer Analytics project using PostgreSQL and Power BI, featuring Analytics Engineering, Star Schema modeling, SQL semantic layers, and interactive business dashboards built from the B…

    1