Welcome

👋 Hey I'm Lawnish

I'm a data analyst based in Gurgaon, India, with a passion for turning raw data into stunning, user-friendly dashboards. With a strong foundation in data analysis and visualization, I help businesses uncover insights and make smarter, data-driven decisions. Obsessed with clean design and clear storytelling, I'm always on the lookout for fresh challenges and opportunities to level up my skills and grow in the world of analytics.

What i'm doing

  • design icon

    Data analysis

    Transforming Raw Data Into Actionable Intelligence for Business Impact.

  • Web development icon

    Dashboard Building

    Building Smart Dashboards and Analytical Tools to Simplify Complex Data.

  • mobile app icon

    Data Scrapping

    Extracting Valuable Insights from the Web—Clean, Accurate, and Fast.

  • camera icon

    Photography

    I make high-quality photos of any category at a professional level.

Resume

Education

  1. Satyug Darshan Institute of Engineering and Technology

    2021 — Present

    Currently pursuing B.Tech in Computer Science and Engineering.

Projects

  1. Laptop Price Predictor

    Python and SQL

    • Developed a machine learning model to predict laptop prices using Python and SQL, achieving 85% accuracy in price predictions.

    • Collected and preprocessed dataset of 1000+ laptops, handling missing values and performing feature engineering.

    • Implemented data cleaning pipelines using pandas and numpy for efficient data transformation.

    • Built and optimized multiple ML models (Linear Regression, Random Forest, XGBoost) using scikit-learn.

    • Automated data collection process using SQL and Python scripts, reducing manual effort by 70%.

  2. Hospitality Domain

    Power BI

    • Created an interactive Power BI dashboard for the hospitality domain to visualize key performance indicators (KPIs).

    • Displayed critical metrics including occupancy rates, revenue per available room (RevPAR), and customer satisfaction scores.

    • Utilized DAX formulas to perform advanced calculations and derive meaningful insights from raw data.

    • Enhanced reporting capabilities by implementing dynamic filters, slicers, and drill-down functionalities.

    • Improved decision-making through clear, data-driven visual representations of business performance.

  3. Marvel vs DC

    Microsoft Excel and Power BI

    • Designed and developed an interactive Marvel vs DC analytics dashboard comparing revenue, ratings, and movie counts across timelines using data visualization tools.

    • Utilized Microsoft Excel for data cleaning, transformation, and analysis, ensuring data accuracy and integrity.

    • Created dynamic charts and graphs in Power BI to visualize trends and patterns in superhero movie performance.

    • Created dynamic visualizations for total revenue generation, highest-grossing movies, and top IMDb-rated movies.

My skills

  • Python
    80%
  • Power BI
    90%
  • SQL
    85%
  • Microsoft Excel
    85%

Certifications