Portfolio - Gul Sanowber

Gul Sanowber

Market Research Analyst

Resume

3

PowerBI Projects

1

Excel Project

1

SQL Project

About Me

Welcome to my Portfolio! I'm Gulsanowber Darakhshan, a dedicated market research professional with experience in supply chain, and logistics, I have a strong background in conducting secondary research and analyzing market data and a burning passion for transitioning into Business Analytics and Data Analytics roles.
I'm well-versed in Excel, Power BI, and SQL and I'm here to help you make sense of your data.

Key Skills

SQL

Problem Solving

Analytical Thinking

Market Research

Communication

My Projects

India Export Import Analytics

Domain/Function: Logistics and Supply Chain - Import and Export

Product Growth Plan

Domain/Function: Logistics and Supply Chain

Sales and Operations Dashboard

Domain/Function: Retail

Credit Card Transaction Analysis

Domain/Function: Finance

Marketing Campaign Dashboard

Domain/Function: Marketing

My Experience

Managed and worked on a Power BI POC Project for the retail industry, enhancing data visualization and cutting report creation time by 20%.
Conducted Market research for products and analysed their data to understand their market size, growth rates, needs, purchasing behaviour, and demographics.

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/gul-sanowber-453b54177/

Call Me

+91 8830251723

PowerBI Project

India Export Import Analytics

Domain/Function: Logistics and Supply Chain - Import and Export

India's export and import analytics involves collecting and analyzing data related to the goods and services that India sells to and buys from other countries. This analysis helps businesses and the government understand trade patterns, identify opportunities, and make informed decisions.

View Project
Engagement

Ocean Trade View offers an overview of maritime trade, highlighting the movement of goods via sea routes.

Air Trade View provides an overview of goods transported by air, focusing on the volume and value of exports and imports via air routes.

Project Details

Home Page View:
This is the starting point of the Power BI dashboard. It gives a clear and easy way to navigate through various sections of trade data.
Ocean Trade View:
This view will help you to understand maritime trade activities. This page is designed to provide KPIs and detailed charts to help analyse trade data effectively.
Air Trade View:
This view will help you to understand air trade activities. This page is designed to provide KPIs and detailed charts to help analyse trade data effectively.
Exporter View:
This view will show who the top exporters are and give detailed information about their trading activities.
Importer View:
This view will show who the top Importer are and give detailed information about their trading activities.
Port View:
This view will show who the top ports are in exports and imports and detailed information about their trading activities since 2019.
Analytics View:
This view will provide a quick summary of important trade information.

Live Interactive Dashboard

Excel Project

Product Growth Plan

Domain/Function: Logistics and Supply Chain

The goal of this project was to develop a comprehensive product growth plan for the trade lane. This plan focuses on analyzing key trade routes, ports, and TEU (Twenty-foot Equivalent Unit) data to identify growth opportunities and optimize logistics strategies.

Analysis aimed to identify key trade flows, evaluate the volume of exports in terms of TEUs and understand the distribution of trade among top ports

Analysis aimed to identify key trade flows, evaluate the volume of imports in terms of TEUs and understand the distribution of trade among top ports

Project Details

This comprehensive product growth plan for the Asia to North America trade lane provided valuable insights into trade routes, port performance, and cargo volumes. By leveraging these insights, stakeholders can make informed decisions to optimize logistics operations, invest in infrastructure, and explore new growth opportunities. The plan aims to enhance the efficiency of this vital trade corridor and support the strategic objectives of stakeholders involved in the Asia to North America trade lane.

PowerBI Project

Sales and Operations Dashboard

Domain/Function: Retail

This Power BI dashboard provides a concise overview of B2B retail sales and operations, focusing on key metrics such as sales performance, profit margins, inventory levels, and customer segments. It enables businesses to monitor sales trends, optimize inventory, and analyze customer behavior.

Sales Performance View: Track sales trends, identify top-performing products, and monitor sales targets.

Order Processing View: Monitor the efficiency of order processing, track order statuses, and ensure timely delivery.

Project Details

This Power BI Sales and Operations Dashboard for retail B2B provides an overview of essential business metrics, including sales performance, order processing efficiency, inventory management, profitability, and top performers. It equips retail managers with the insights needed to optimize operations, boost sales, and enhance profitability.

Live Interactive Dashboard

SQL Project

Credit Card Transaction Analysis

Domain/Function: Finance

This project involved analyzing spending patterns across various card types using advanced SQL techniques.The analysis provided actionable insights into consumer behavior and financial trends, leveraging advanced SQL functions for in-depth data exploration.

Query 1: Top 5 Cities by Highest Spends Query 2: Highest Spend Month per Card Type

Query 4: Percentage Contribution of Female Spends by Expense Type Query 5: Highest Month-over-Month Growth for Card and Expense Type in January 2014

Project Details

Key tasks included identifying the highest spending month, evaluating expense trends by city, tracking significant financial milestones, and assessing spend growth for specific card and expense combinations. The analysis provided actionable insights into consumer behavior and financial trends, leveraging advanced SQL functions for in-depth data exploration.

PowerBI Project

Marketing Campaign Dashboard

Domain/Function: Marketing

A Power BI dashboard for analyzing marketing campaigns is essential for making data-driven decisions and optimizing performance. By tracking trends over time, it helps in refining strategies, improving targeting, and maximizing return on marketing investment.

Home Page

With real-time insights, businesses can quickly identify which campaigns are performing well, which target audiences are most responsive

Project Details

It provides a clear, visual representation of key metrics such as conversion rates, ROI, customer engagement, and acquisition costs across different channels.