Prakhar Tyagi

Prakhar Tyagi

About

Detail

Data Analyst | SQL • Python • Power BI • Tableau • Databricks/PySpark | Turning Raw Data into KPI Dashboards & Business Decisions
Noida, Uttar Pradesh, India

Contact Prakhar regarding: 
work
Full-time jobs

Timeline


work
Job
school
Education
folder
Project

Résumé


Jobs verified_user 0% verified
  • E
    Data Analyst
    E Machines Technologies
    Mar 2026 - Current (5 months)
  • Infogain
    Data Engineer Intern
    Infogain
    Dec 2025 - Feb 2026 (3 months)
  • Fitelo
    Data Driven Analyst
    Fitelo
    Jan 2025 - Dec 2025 (1 year)
  • OctaNet Services Pvt Ltd
    Frontend Developer
    OctaNet Services Pvt Ltd
    Apr 2024 - Jun 2024 (3 months)
    I recently completed a two-month internship as a Frontend Web Developer, where I honed my skills in designing and implementing user-friendly web interfaces. During my internship, I successfully developed a fully functional and visually appealing landing page as my primary project. This experience allowed me to gain hands-on expertise in HTML, CSS, JavaScript, and responsive design principles. I am passionate about creating intuitive and aesthetically pleasing web experiences and look forward to applying my skills in future projects.
Education verified_user 0% verified
  • Chandigarh university
    Bachelor of Engineering - BE, Computer Science
    Chandigarh university
    Jan 2021 - Dec 2025 (5 years)
    | Transforming Ideas into Innovation | College has been the most important experience for me. Chandigarh University is providing ample of opportunities to explore various domains and a talented peer group that never failed to inspire me .
Projects (professional or personal) verified_user 0% verified
  • A
    AI-Enhanced Portfolio
    Jul 2026 - Current (1 month)
    Built a modern, responsive portfolio website featuring an AI-generated video introduction, smooth animations, and an interactive user experience. The portfolio showcases my data analytics projects, Power BI dashboards, SQL and Python skills, certifications, and professional experience in a visually engaging format.
  • E
    End-to-End E-Commerce B2B Demand & Operational Risk Analysis
    Jul 2026
    1- Developed a scalable data analytics pipeline using Python (Pandas, Seaborn, Matplotlib) to evaluate 500K transaction records of a UK-based retail shop. 2- Engineered advanced feature metrics (Total_Amount) and isolated completed orders from cancelled transactions to maintain true operational revenue. 3- Discovered that 97.4% of the customer base consists of Repeat B2B Buyers, confirming the platform acts as a core wholesale supply chain channel. 4- Identified a uniform 3% cancellation rate across all categories, proving that supply chain friction points are linked to centralized warehouse stock shortages rather than isolated product lines. 5- Uncovered stable weekend demand driven by global time-zone offsets, averaging £16M daily.
  • I
    Insurance System Data Engineering Pipeline (Databricks DLT)
    Jan 2026
    Built a production-grade, end-to-end Insurance Data Engineering pipeline using Databricks Delta Live Tables (DLT) following the Bronze–Silver–Gold (Medallion) architecture. Bronze Layer 1- Ingested raw JSON data for customers, policies, claims, payouts, and IoT/telematics 2- Implemented multi-format date & timestamp parsing 3- Preserved raw schema while flagging data quality issues (duplicates, invalid values, overlaps) Silver Layer 1- Designed a Customer Dimension with SCD Type-2 history tracking 2- Standardized and deduplicated customer records using window functions 3- Built policy-level risk profiling using IoT telematics data 4- Created a Claims Lifecycle fact table with coverage validation, reopened-claim logic, and payout aggregati
  • T
    Tennis Analytics Dashboard
    Oct 2025
    Excited to share my Tennis Game Analytics Project, where I built an end-to-end data pipeline using the Sportradar API. In this project, I extracted tennis competition and player ranking data using Python, transformed JSON data into a structured SQL database, and developed an interactive Streamlit dashboard to analyze competitions, venues, and competitor rankings. The goal was to turn raw sports data into meaningful insights through queries, filters, and visualizations. This project strengthened my skills in API integration, SQL data modeling, and building data-driven applications. #DataAnalytics #Python #SQL #Streamlit #SportsAnalytics
  • M
    My Portfolio
    Sep 2024
    Links to view my work
  • R
    Responsive Travel website
    May 2024
    Welcome to Journey Junction, where every path leads to adventure and every journey is a story waiting to be told. Step into a world where wanderlust reigns supreme and the wonders of the globe are at your fingertips. At Journey Junction, we believe that travel is more than just a destination—it's a transformative experience, a tapestry woven with memories of new places, faces, and flavors. Whether you're drawn to the bustling streets of a vibrant metropolis, the serene beauty of a remote countryside, or the untamed wilderness of far-off lands, our platform is your gateway to discovery. With Journey Junction, the world is yours to explore, and the possibilities are endless. Our curated selection of destinations, accommodations, and experienc
  • R
    Retail Sales And Inventory Project
    Pleased to present a comprehensive data intelligence system developed for a retail company specializing in mobile phones and laptops. This project transforms raw operational data into actionable business strategy, focusing on sales optimization, inventory management, and staff performance evaluation. Project Highlights & Technical Execution This solution provides a 360-degree view of the retail operation by integrating and analyzing data across 9 distinct relational tables (Sales & Production domains).Core Skills Demonstrated: Data Cleaning (Excel) $\right arrow$ Relational Schema Design (SQL Tables) $\right arrow$ DAX Modeling & Measures $\right arrow$ Power BI Visualization. Data Modeling: Successfully established robust one-to-many relat
  • J
    JavaScript-Age-Calculator
    A simple and efficient JavaScript-based age calculator that allows users to input their date of birth and instantly get their age in years, months, and days. This project demonstrates fundamental JavaScript concepts and provides a user-friendly interface for accurate age calculation. Its Features are : 1- Input date of birth using a user-friendly form 2- Instant age calculation in years, months, and days 3- Responsive design for both desktop and mobile users 4- Clear and concise user interface Technologies Used in the project are :- 1- HTML5 for structure 2- CSS3 for styling 3- JavaScript for functionality
This is a community-created genome.