Portfolio - Devesh Tyagi

PowerBI Project

Telangana Growth Analysis

The primary objective of this project is to analyze, gain insights and give recommendations from 3 different datasets related to Telangana government activities: Stamp Registration, Transportation and Ts-Ipass.

View Project
Engagement

View Project
on GitHUB

This meticulously crafted dashboard aims to answer pivotal questions through insightful graphs, providing a brief understanding of registration trends

This intricately designed dashboard is tailored to address queries using informative graphs, offering an overview of trends in Vehicle Registration.

Project Details

"Telangana Growth Analysis," a collaborative venture between the Government of Telangana and Code Basics under the Resume Project Challenge No. 7. This enriching experience delved into the realms of data analysis, focusing on open datasets pertinent to Telangana's development landscape.

Dataset Used: Open data of Telangana, meticulously analyzed to extract meaningful insights.

Tools Employed: Power BI, a dynamic tool that breathed life into the data, enabling a comprehensive understanding.

Insights Unveiled:
1. Infrastructure Development: Evaluating the current state and proposing strategies for enhancement.
2.IT Hub: Analyzing the potential for tech-driven growth and innovation.
3.Attracting Investments: Identifying key sectors for attracting investments.
4.Pharmaceuticals and Textiles: Investigating growth opportunities in these crucial industries.
5.Development of Skilled Labor: Proposing initiatives for skill development.

Project video

Live Interactive Dashboard

SQL Project

Provide The Insights To Management to in Consumer Goods Domain

Thrilled to present my Consumer Goods SQL Project, where I seamlessly integrated MySQL, Power BI, and Canva to unravel strategic insights for top-level management. This project revolves around addressing 10 ad hoc requests, translating raw data into actionable insights in the dynamic Consumer Goods

View Project
Engagement

View Project
on GitHUB

Provide The Insights To Management to in Consumer Goods Domain

Answering ad-hoc requests from stakeholders.

Tasked with examining 'ad-hoc-requests.pdf'.

Project Details

Tasked with examining 'ad-hoc-requests.pdf,' I embarked on a journey to decipher complex business queries using SQL queries. Targeting top-level management as the primary audience, I harnessed the power of MySQL for data querying, Power BI for visualization, and Canva for crafting a compelling presentation.

Key Insights:
1- Profitable Market Analysis: Identified India as the most lucrative market in both years, steering strategic focus towards maximizing opportunities in this region.
2- Year-on-Year Growth: Unveiled a remarkable 137.5% surge in profitability in 2021 compared to the preceding year, signaling an upward trajectory in business performance.
3- Product Demand Dynamics: Uncovered sustained high demand for "Personal Laptops" across both years.
Notably, witnessed a staggering 175% surge in demand for "Personal Laptops" in 2021, emphasizing its growing popularity.

PowerBI Project

Provide Insights to Revenue Team in Hospitality Domain

we delve into the dynamic world of the Hospitality Domain, focusing on the Atliq Rooms Hotel Chain, a prominent player with establishments across India.

View Project
Engagement

View Project
on GitHUB

Provide Insights to Revenue Team in Hospitality Domain

The project equips the organization with a data-driven approach, enabling informed decision-making and enhancing overall operational efficiency

This Power BI project navigates the intricacies of data gathering, cleaning, and modeling,

Project Details

In this Power BI project, we delve into the dynamic world of the Hospitality Domain, focusing on the Atliq Rooms Hotel Chain, a prominent player with establishments across India. The goal is to provide actionable insights into revenue and room bookings, empowering the organization to strategize, diversify, and execute operations effectively.
Project Overview:
Tools Used: Microsoft Power BI

Operations Performed:
Data Gathering: Collected data from various Excel files, ensuring a comprehensive dataset for analysis.
Data Cleaning: Employed robust data cleaning techniques to enhance data quality and eliminate inconsistencies.
Data Transformation: Leveraged Power Query to transform raw data into a structured format conducive to analysis.
Data Modelling: Created a Star Schema Model in Power BI, incorporating two fact tables for in-depth data analysis.
DAX (Data Analysis Expressions): Applied DAX formulas to derive meaningful metrics and calculations for a nuanced understanding.

Live Interactive Dashboard

PowerBI Project

Provide Insights to the Product Strategy Team in the Banking Domain

My project revolved around meticulously analyzing the sample data provided, aiming to deliver comprehensive findings to Mitron Bank's strategy team. This analysis serves as a guiding tool for tailoring credit card offerings to align with customer needs and current market trends.

View Project
Engagement

View Project
on GitHUB

Provide Insights to the Product Strategy Team in the Banking Domain

Customer Demographics Dashboard to elucidate key factors within the dataset, encompassing age, gender, occupation, city, and marital status.

This dashboard highlights key metrics such as credit card usage patterns, income utilization trends, and total income distribution.

Project Details

AtliQ Data Services came to know about this through an internal link and approached Mitron Bank with a proposal to implement this project. However, strategy director of Mitron Bank, Mr.Bashnir Rover is skeptical and asked them to do a pilot project with the sample data before handing them the full project. They provided a sample dataset of 4000 customers across five cities on their online spend and other details. Design a dashboard with your metrics and analysis. The end users of this dashboard are top-level management and product strategy team - hence the dashboard should be self-explanatory and easy to understand.
Present your insights to Mr.Bashnir Rover & team. Be creative and concise with your presentation. Use your dashboard in the presentation along with the deck.

Live Interactive Dashboard

Python Project

Quantitative Analysis of Stock Market using Python

Quantitative Analysis in the stock market involves the use of mathematical and statistical techniques to understand, predict, and make decisions about financial investments. Quantitative Analysis in the stock market is a financial methodology that utilizes mathematical and statistical techniques.

View Project
Engagement

View Project
on GitHUB

Quantitative Analysis of Stock Market using Python

Volatility analysis is a crucial aspect of stock analysis that helps investors understand the level of risk associated with a particular stock.

Time series analysis provides valuable insights into the past behavior and future potential of stocks, helping investors make informed decisions.

Project Details

Quantitative Analysis in the stock market is a financial methodology that utilizes mathematical and statistical techniques to analyze stocks and financial markets.
Below is the process we can follow for the task of Quantitative Analysis of the stock market:
Clearly define the objectives and questions to be answered.
Identify the key performance indicators (KPIs) relevant to the analysis.
Gather historical stock market data, including prices, volumes, and other relevant financial indicators.
Clean and preprocess the data to handle missing values, outliers, and errors.
Conduct initial analysis to understand data distributions, patterns, and correlations.
Implement various strategies based on quantitative analysis.

Excel Project

Sales & Finance Analytics for AtliQ Hardware

A sales analytics report involves analyzing various aspects of sales data to derive insights and make informed decisions. These reports help companies understand their market performance, identify trends, and optimize their sales strategies.

View Project
Engagement

View Project
on GitHUB

Sales & Finance Analytics for AtliQ Hardware

Excel spreadsheet to analyze the net sales, cost of goods sold (COGS), and gross margin for each month spanning three years: 2019, 2020, and 2021.

The Excel sheet aims to provide a comprehensive analysis of net sales, cost of goods sold (COGS), and gross margin across different countries.

Project Details

Created two reports for analyzing the sales performance of each of its customers and their year-over-year growth (Customer Performance Report) and also analyzed the market performance Vs target performance.

Hello, I am

Devesh Tyagi

3

1

1

1

About

Key

My

Telangana Growth Analysis

Provide The Insights To Management to in Consumer Goods Domain

Provide Insights to Revenue Team in Hospitality Domain

Provide Insights to the Product Strategy Team in the Banking Domain

Quantitative Analysis of Stock Market using Python

Sales & Finance Analytics for AtliQ Hardware

Awards

Contact Me

Email

Github

Linkedin

Call

Devesh Tyagi

Download Resume