Data Analytics Portfolio Projects

Show how you turn raw data into clear findings. These projects help you practice SQL, Python, data visualization, and business intelligence while creating portfolio work you can explain to an employer.

Career areas

• Data Analyst
• BI Developer
• Analytics Engineer

Browse Data Analyst projects

• AI-Powered Customer Intelligence & RFM Dashboard

  A two-page Streamlit dashboard that runs RFM analysis on retail data and uses AI to generate marketing recommendations.

  Level: intermediate · Tools: Python, Streamlit, Pandas, Plotly

• Real-Time Market Sentiment & Price Correlation Tracker

  A live pipeline that fetches crypto/stock prices AND news sentiment, visualizing the correlation in real-time.

  Level: advanced · Tools: Python, WebSocket, NLTK/TextBlob, Streamlit

• Supply Chain Optimization & Demand Forecasting Tool

  A predictive analytics tool that forecasts demand and identifies supply chain bottlenecks via an interactive BI report.

  Level: intermediate · Tools: Python, Scikit-learn, Prophet, PostgreSQL

• IT Asset Management Dashboard

  An interactive dashboard tracking IT assets via the Snipe-IT API — visualizing allocation, lifecycle, and refresh cycles.

  Level: intermediate · Tools: Snipe-IT API, Python, Power BI/Tableau

• Rapid BI Dashboard Built with Generative AI

  A polished BI dashboard built end-to-end with AI — Claude generates the dataset, GPT writes the DAX, and Dribbble inspires the layout, all in under an hour.

  Level: beginner · Tools: Claude, ChatGPT, Power BI, Dribbble (inspiration)

• End-to-End ELT Pipeline with dbt and Airflow

  A scheduled pipeline that extracts from an API, loads to a warehouse, transforms with tested dbt models, and orchestrates the whole thing in Airflow — with data quality tests that fail loudly.

  Level: intermediate · Tools: Apache Airflow, dbt, Snowflake/Postgres, Python

• Laptop Lakehouse: DuckDB, Parquet, and a One-Page Dashboard

  A complete analytics project that runs on your laptop for free — public data converted to Parquet, queried with SQL in DuckDB, modeled into clean metrics, and shipped as a one-page dashboard you can actually send to someone.

  Level: beginner · Tools: DuckDB, Python, Parquet, Streamlit or Evidence

• Semantic Layer and Data Contracts with dbt, Queried in Plain English

  A dbt project where metrics are defined once in a semantic layer, protected by data contracts and tests, and exposed through a small natural-language interface that turns questions into governed SQL — so the AI and the dashboard always return the same number.

  Level: intermediate · Tools: dbt Core, MetricFlow, dbt Contracts and Tests, DuckDB

• Streaming Lakehouse: Redpanda to Iceberg to DuckDB

  A real-time analytics pipeline — events produced into Redpanda, landed continuously into Apache Iceberg tables with schema evolution and time travel, and queried seconds later from DuckDB and a live dashboard. The open lakehouse architecture that data platforms are standardizing on.

  Level: advanced · Tools: Redpanda (Kafka API), Apache Iceberg, DuckDB or Trino, Python Producer