Ghulam Murtaza Portfolio

📜 Introduction to Raw Data: Demonstrated and briefed the initial dataset, encapsulating demographics of potential bike customers.

🧹 Data Cleaning Process: Undertook extensive data purification - deleting duplicates, expanding abbreviations, and introducing age brackets.

📊 Data Transformation through Pivot Tables: Leveraged pivot tables for data segmentation and summary prior to visualization.

📈 Visualization Creation: Crafted key visual representations - 3D bar charts, and two distinct line charts shedding light on customer behavior.

🖥 Dashboard Assembly: Consolidated visualizations into a streamlined dashboard, accentuating its design and usability.

🔍 Enhanced User Interactivity: Infused slicers for seamless data filtration, optimizing user insights and engagement.

Excel does not allow reports to be shared outside organization, To view Dashboard, click on View Dashboard to download or you can view pdf for quicker view

📤 Data Import: Seamlessly imported comprehensive ecommerce sales data into Excel, complete with a myriad of sales parameters.

📊 Combo Chart Design: Crafted and aesthetically upgraded a combo chart elucidating the relationship between sales and profit.

💹 Waterfall Chart for Profit Breakdown: Produced a visually refined waterfall chart dissecting profit by categories.

🥧 Sales Distribution via Pie Chart: Formulated an engaging donut chart capturing category-based sales distribution.

🗺 State-wise Sales Map Chart: Initiated a map chart portraying state-focused sales, differentiated with vivid color markers.

📊 Bar Chart for Subcategory Insights: Conceived a bar chart magnifying top subcategory sales, enhanced for clarity and elegance.

🔍 Interactive Dashboard Experience: Fused dynamic slicers linked to charts, optimizing user exploration and insights.

Excel does not allow reports to be shared outside organization, To view Dashboard, click on View Dashboard to download or you can view pdf for quicker view