Portfolio - Dhanush V D

Dhanush V D

Data Aspirant

Resume

1

Excel Project

1

PowerBI Project

About Me

Welcome! I'm an aspiring Data Analyst with a Bachelor's in Electronics and Communication Engineering. Transitioning from my background, I've discovered a passion for data analysis. With 1.5 years of experience in Oracle SQL and PL/SQL, I'm proficient in Excel, Power BI, and SQL for extracting insights. My portfolio showcases projects where I've unraveled data stories, driving informed decisions. Eager to explore opportunities where I can leverage my skills to drive impactful solutions through data analysis. Let's connect and collaborate on projects that harness the power of data for success. Together, we can unlock valuable insights and drive meaningful change.

Key Skills

SQL

Stakeholder management

My Projects

Sales Analytics(Atliq Hardware)

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

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/dhanushvd/

Call Me

+91 8270265227

GitHub

https://github.com/Dhanushdhandapani

Excel Project

Sales Analytics(Atliq Hardware)

Crafted 2 strategic Excel reports for Atliq Hardwares, enabling informed decisions. Delivered insights into customer and market-wise net sales performance, empowering the team for strategic business moves.

View Project
Engagement

View Project
on GitHUB

Assess country performance against targets across years. Drive informed decisions for sustainable growth with our Market Performance vs. Target Report

Gain insights into customer net sales performance across years with our Customer Performance Report.

Project Details

Developed a comprehensive sales report utilizing Excel pivot tables. This tool empowers businesses to ascertain optimal customer discounts, negotiate effectively, and pinpoint expansion opportunities in promising markets. The generated reports offer actionable insights and recommendations, facilitating sales strategy optimization, heightened customer satisfaction, and revenue maximization.
Learnings :-
→ ETL Process using power query
→ Data cleaning and transformation
→ Pivot and power pivot
→ Vlookup and Xlookup
→ DAX

Embark on a journey to transform business sales dynamics! This project is a beacon for businesses seeking empowerment through data-driven insights. Dive deep into sales data analysis to unearth untapped opportunities, fuel growth, and maintain competitiveness in an ever-evolving market terrain. Let's embark together on this path toward enhanced sales efficacy and sustainable success!

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtliQ Hardwares, a consumer electronics company, seeks to leverage advanced analytics through Power BI. My aim is to equip them with insights for informed decision-making amidst rapid expansion.

View Project
Engagement

Crafted a user-centric landing page within dashboard design, prioritizing intuitive navigation and seamless user experience.

Data modelling involving 10+ tables

Project Details

Our project aims to create a unified report catering to stakeholders from sales, marketing, finance, and the executive team. We prioritize robust data modeling, user-centric report design, and drillable insights for informed decision-making.
Here are some of the learnings in this project:-
📊 Importing Data from various sources
📊 Performing ETL process in power query
📊 Data modelling (Star and Snowflake Schema)
📊 Creating date table
📊 Generating report measures using DAX
📊 Calculated columns using DAX
📊 Filter context in Power BI
📊 Report optimization
📊 Navigation Menus
📊 Bookmarks
📊 Dynamic Headings based on filters
📊 Power Bi services
📊 Creating a connection gateway and SharePoint for Excel