Skip to content
View AlexPanoni's full-sized avatar
1 follower · 8 following

Block or report AlexPanoni

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
AlexPanoni/README.md

Hi there 👋

I'm Alex Panoni, an Economist (B.A. and M.A. from USP and UFSC) and Data Analyst with nearly 10 years of remote work experience. I specialize in data warehouse development, ETL pipelines, and building analytics solutions that support business decision-making.

🔧 Skills & Tools

Data & Analytics:

  • SQL (MySQL, SQL Server) - ETL, data modeling, dimensional design
  • Python (pandas, NumPy, matplotlib, seaborn) - data cleaning, transformation, analysis
  • Power BI & Tableau - interactive dashboards and KPI tracking
  • Excel (PowerQuery, pivot tables, advanced formulas)

Data Architecture:

  • Data Warehouse design (star schema, dimensional modeling)
  • ETL pipelines and data integration workflows
  • Data quality validation and integrity management
  • Exploring: Palantir Foundry

📂 Featured Projects

Data Warehouse (SQL Server)
End-to-end data warehouse with Medallion Architecture, ETL pipelines, star-schema modeling, and Tableau dashboard

E-commerce Analysis (Python)
Comprehensive exploratory analysis on Olist marketplace dataset with Power BI dashboard and actionable insights

📫 Connect

Pinned Loading

  1. Social_Media_Performance Social_Media_Performance Public

    Social Media Analytics Dashboard built in Power BI with engagement analysis, content performance insights, temporal trends, and geo-performance visualization across 6 platforms.

  2. Olist_Ecommerce_Analysis Olist_Ecommerce_Analysis Public

    E-commerce Exploratory Data Analysis (Python) on the Olist Dataset - Interactive Power BI Dashboard, Detailed PDF Report, and Actionable Marketplace Insights & Recommendations

    Jupyter Notebook

  3. lh-nautical-data-analytics-case lh-nautical-data-analytics-case Public

    Projeto end-to-end de Análise de Dados e BI desenvolvido para o desafio Lighthouse, envolvendo modelagem de dados, EDA, geração de insights e construção de dashboard, além das respostas estruturada…

    Jupyter Notebook

  4. Data_Warehouse_SQL_Project Data_Warehouse_SQL_Project Public

    End-to-end SQL Server Data Warehouse built using the Medallion Architecture, including ETL pipelines, star-schema modeling, analytics-ready views, and a Tableau-based executive dashboard.

    TSQL

  5. Mixpanel-Product-Analytics-Audit Mixpanel-Product-Analytics-Audit Public

    A comprehensive Product Analytics audit using a 12-month Mixpanel dataset. Analyzes the 'Efficiency of Friction' in onboarding, linear retention decay, and social-density triggers for monetization.