analystics

The Fair Analytics client API

Open Source implementation of an online analyst tool to research companies with competence in the area of Artificial Intelligence. Currently contains 11,469 public AI stocks, AI-ETF's and PE/VC backed AI companies with a focus on analytics of the core strength around AI technology. The system retrieves and collates data from multiple online sour…

A Data Analytics Tool with flexible architecture to visualize and analyse data

A sophisticated Mood Tracker App built with Streamlit, SQLite, and Matplotlib, designed to help users seamlessly log their daily moods, track emotional patterns, and visualize trends over time. The app features interactive data visualization, historical mood analysis, and AI-driven mood predictions for deeper emotional insights. With a user-friendl

The "120 Years of Olympic Games: A Comprehensive Review" project aimed to analyze historical Olympic Games data spanning more than a century. Utilizing data sourced from Kaggle, the project focused on cleaning, preparing, normalizing, and visualizing the data in Power BI to extract meaningful insights and highlight key trends in Olympic history.

A simple local lab to learn ETL and data quality using DuckDB and Great Expectations. Runs fully in Docker and perfect for beginners to try and explore.

Analyzed Airbnb's impact on NYC rentals using Python, SQL, and Tableau. Built an ETL pipeline, performed forecasting with scikit-learn, and created interactive dashboards to visualize pricing trends and listing saturation.

This project demonstrates an end-to-end analytics pipeline for a global manufacturing company, covering the full workflow from raw data ingestion to business-ready dashboards.

Advanced algorithm development for revenue maximization and enhanced conversion value in Google Ads expenditure, achieving a 15% increase in lead conversions while reducing costs

RetailIQ - Sales Management & Analytics Dashboard built with Python, MySQL & Streamlit.

Analyzed a real-world dataset of 2023 data science job postings using PostgreSQL to explore salary trends, in-demand skills, and hiring patterns. Built SQL queries using joins, CTEs, window functions, and aggregations to turn raw data into meaningful insights.

An end-to-end SQL Data Analytics Project that demonstrates relational database design, data import, SQL querying, and business insight generation using PostgreSQL.

HR analytics using advanced SQL | Window functions, CTEs, views, indexing | Optimized for dashboard consumption | MySQL

Interactive Power BI dashboard for Aadhaar enrollment, geographic distribution, and demographic analysis.

Let’s say you’re working for an energy company that wants to set up a new solar power plant somewhere in Brazil. They need to choose a location based on several criteria, such as Year-round solar irradiation level, easy access and connection to the nearby power grid. Your job, as data analyst, is to find the top 5 best locations all over Brazil.

End-to-end vendor performance analysis project using SQL, Python, and Power BI to analyze sales, purchasing, inventory, vendor performance, product trends, and business KPIs.

Production-grade data analytics platform: scrapes 170+ YouTube channels (yt-dlp) → BigQuery DWH → dbt star schema transformation → Next.js interactive dashboard. Features incremental pipelines, fact/dimension modeling, and 5 analytical views across 4 content niches.

End-to-end Customer Sales ETL Pipeline using Python, Pandas, SQLite, and SQL analytics.

Streamlit app to simulate VCT EMEA Kickoff (2026) triple-elimination bracket and build an interactive worst→best team ranking.

SQL-based E-Commerce Sales Analysis project using MySQL to analyze sales performance, revenue trends, product categories, and customer insights through data-driven reporting.