omkar yadav
@omkar-2004
About
BSc (IT) Student | Aspiring Data Analyst | Advanced Excel | Power BI | MySQL | Python (NumPy, Pandas, Matplotlib)
Skills & Technologies
Projects & Repositories
Recent public projects and repositories from this profile.
GlobalCart-Sales-Excel-Dashboard-
Build Excel Dashboard for Sales Performance
Healthcare-Analytics-Pipeline-From-SQL-Warehouse-to-Power-BI
Jupyter NotebookAn end-to-end healthcare analytics pipeline featuring a relational SQL Server (SSMS) data warehouse, Python-driven EDA for clinical insights, and an interactive Power BI dashboard for financial and operational reporting.
Profitability-and-Sales-optimization
Jupyter NotebookAn end-to-end data analytics pipeline using SQL Server, Python, and Power BI to uncover true profitability drivers, optimize pricing, and identify high-value customer cohorts.
Olist-Power-Bi-Dashbord
An end-to-end interactive Power BI Business Intelligence solution analyzing 100K+ transactional records from Brazil's largest department store marketplace (Olist). Features an advanced relational data model, custom DAX metrics, and deep-dive analytics covering Sales Trends, Customer Geography, Product Performance, and Logistic Satisfaction metrics.
Olist-Retail-Sales-Performance-Analysis
Jupyter NotebookThis repository contains a comprehensive data analytics and business intelligence project focused on the Olist E-Commerce Ecosystem in Brazil. The project covers the entire data pipeline, including data auditing, preprocessing, exploratory data analysis (EDA), and advanced business analysis to extract actionable insights
Hospitality-Data-Audit-Revenue-Integrity-System-EDA-
Jupyter Notebook🐍 Python-based data cleaning, feature engineering, and financial integrity audit pipeline for hotel transaction logs. Processes raw multi-property datasets and exposes operational ledger discrepancies.