Portfolio - Sumit Mangukiya

Sumit Mangukiya

Data Analyst

Resume

2

PowerBI Projects

1

Excel Project

About Me

Dynamic Data Analytics Master's graduate from Berlin School of Innovation with a robust skill set in predictive data analytics, machine learning, and big data analysis. Proficient in Python, MySQL, and Power BI for comprehensive data visualization and analysis. Specializing in creating insightful data dashboards and conducting advanced AI-driven analyses. Constantly evolving expertise through CodeBasics courses, with a focus on data dashboard development and data analysis. Excel in leveraging MS Word, MS PowerPoint, and MS Excel for impactful presentations and reports.

Key Skills

MySQL

Python

PowerBI

MsExcel

My Projects

Business Insight 360

Sales Analytics(FMCG)

Mitron Bank Analysis

My Experience

IT Support Analyst 04/2022-10/2022,INDIA

Belymon Infotech - Website & Computer Application Development and handling

• Reduced system downtime by 30%, resulting in an estimated saving of 50k annually

• Oversaw the migration of company data to a new CRM system, involving over 1 TB of data across 100+ users

• Achieved a 20% reduction in data processing times by automating repetitive tasks using SQL by developing custom scripts.

Analyst Intern 01/2022-04/2022,INDIA

Belymon Infotech - Website & Computer Application Development and handling

• Resulting in a 15% reduction in report generation time by optimizing SQL queries.

• Contributed to 5+ dashboard creations in Power BI, enhancing analytical reporting for management.

• Improved CRM data accuracy by 10%, enhancing customer engagement strategies.

Awards & Certificate

Get Job Ready: Power BI Data Analytics for All Levels 3.0

Excel: Mother of Business Intelligence

SQL Beginner to Advanced For Data Professionals

Learning Python for Data Analysis and Visualization

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/smit-mangukiya-084597256

Call Me

+49 1787826197

PowerBI Project

Business Insight 360

The CodeBasics Power BI 2.0 course mentored the creation of a guidance project, featuring executive, marketing, finance, supply chain, and sales views. It tracks key financial metrics like gross margin, net profit, COGS, YTD, and YTG for effective analysis.

View Project
Engagement

Crafting a landing oasis within your dashboard, tailored for you, where every click feels like a warm embrace, welcoming and intuitive.

Designing complex data structures with over 10 interconnected tables requires meticulous planning and creativity to ensure seamless functionality and

Project Details

In our quest for transformation, our mission is to craft a report that speaks to the hearts of sales, marketing, finance, and executive teams alike. We're driven by a triad of objectives:

Fortifying Data Foundations:We're laying the groundwork with robust data models, the very bedrock upon which actionable insights are built.

2. Human-Centric Reporting: Our reports are designed with the end-users in mind, ensuring intuitive navigation and effortless comprehension.

3. Diving Deep for Insights: We're not just scratching the surface; we're delving deep into the data mines, uncovering gems of granular insights for stakeholders to explore and extract effortlessly.

This journey has been an accumulation of invaluable expertise:

Mastery of Power Query: From its fundamental functions to its most intricate features, we wield Power Query with finesse, sculpting data with precision.

Crafting Dynamic DAX Formulas:Whether it's the basics or the complex, we'

Live Interactive Dashboard

Excel Project

Sales Analytics(FMCG)

I've meticulously engineered a pair of illuminating analyses, furnishing our sales squad with the tools to meticulously evaluate customer efficacy and measure our market triumphs against predefined objectives.

Customer Performance Report: Unveiling the fiscal prowess of each patron through annual net sales analysis.

Evaluate market performance against targets over multiple years to gauge country's progress and benchmark achievements.

Project Details

In this innovative endeavor, I've crafted an intricate sales dossier using the dynamic functionalities of Excel pivot tables. This comprehensive tool equips businesses to discern potent customer discounts, fostering seamless negotiations while pinpointing ripe prospects for expansion across global markets. The meticulously generated reports promise actionable insights, steering enterprises towards refined sales strategies, elevated customer gratification, and amplified revenue streams.

Throughout this journey, I've delved into an array of potent techniques:

1. Pivot Table Proficiency: Mastering the art of pivot tables unlocks a realm of analytical prowess, enabling swift data manipulation and insightful trend identification.

2. Power Query Prowess: Harnessing the power of Power Query elevates data wrangling to an art form, ensuring that information flows seamlessly for robust analysis.

3. DAX Dexterity (Introductory): A foundational understanding of Data Analysis Expr

PowerBI Project

Mitron Bank Analysis

Analyzing data from 4000 Mitron Bank users, my task was to unveil insights for launching a new line of credit cards. Mitron Bank aimed to broaden its market presence. Distilling the dataset, I pinpointed crucial trends and preferences. My recommendations will empower Mitron Bank's product strategy t

View Project
Engagement

Embark on a journey of discovery with our dynamic landing page! Explore Demographic insights, delve into Spending patterns, and uncover Payment trends

Discover the pulse of Mitron Bank's card users. Unveil preferences in gender, age, marital status, and more. Understand who's most intrigued by credit

Project Details

Unlocking the potential of 4000 users' data from Mitron Bank, I embarked on a journey to illuminate pathways for the bank's new credit card line. After meticulous data validation and adjustments, a robust modeling framework emerged. Crucial metrics like Monthly Income and Expenditure became guiding stars, steering our insights. With a dynamic month table in place, KPI integration and slicer filters fortified our analytical arsenal. Crafting intuitive pages for demographics, spending, and payment analyses, each click unfurled profound revelations. Coupled with market trends from secondary research, our recommendations resonate with strategic foresight. Mitron Bank's product strategy team now possesses a compass calibrated to align offerings precisely with customer needs, heralding a transformative era in financial services.