Portfolio - Shivprakash Vishwakarma

Hello, I am

Shivprakash Vishwakarma

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

About

Hello! 👋 I'm Shivprakash , a data scientist with a bachelor's degree in Data Science and a stellar 9.3 CGPA. My expertise lies in transforming data into compelling stories that deliver valuable insights.

Proficient in Python and SQL, I excel in data management, ensuring organized and meaningful information. Using Power BI and Excel, I craft visually impactful representations.

"Storytelling with Data" by Cole Nussbaumer Knaflic is my guide for making numbers not just interesting but actionable. I bring a unique blend of coding prowess in Python and a keen focus on data management to unravel digital mysteries.

Key

Skills

R studio

SQL

My

Projects

AtliQ Hardware Sales and Finance Analytics

Ignited a data revolution at AtliQ Hardwares! Led Sales and Finance Analytics, mastering Excel's tools for 1M sales records. Result? Precision, insights, and user-friendly impact, transforming decision-making.

Business Insights 360

Biz360 Snapshot is your business's all-in-one dashboard!
See real-time finances, sales, supply chain, marketing, and executive updates.
Smart insights, simple decisions, big results!

Awards

& Certificate

Alteryx Foundational Micro-Credential

Contact Me

Email

[email protected]

Github

https://github.com/shivgithub1860

https://www.linkedin.com/in/shivprofile/

Call

+91 9082817984

Shivprakash Vishwakarma

Data Aspirant

Download Resume

Resume

Excel Project

AtliQ Hardware Sales and Finance Analytics

View Project
Engagement

View Project
on GitHUB

Customer Performace of AtliQ over the years and comparison between 2020 & 2021

Market Performance of AtliQ over the years

Project Details

Transformed a Massive challenge: 1 million sales records into actionable gold. Highlights? Here's the magic:

🔗 Power Moves:

Power Query danced through data chaos.
Mastered Excel sorcery: VLOOKUP, XLOOKUP unleashed.
Power Pivot and DAX orchestrated a multidimensional symphony.
A touch of magic: Conditional formatting made data art.
User-friendly vibes with slicers, measures, and filters.

👀 Key Insights Unleashed:

Crafted table relationships for extensive data views.
Methodically organized data analysis with Power Query.
ETL wizardry transformed raw chaos into unified elegance.

🔹 What I Gained:
Explored the details of sales and finance, equipped with valuable insights for decision-making. This journey enhanced my skills, provided essential tools, and empowered me to use data as a decisive force. 🛠️

PowerBI Project

Business Insights 360

Biz360 Snapshot is your business's all-in-one dashboard! See real-time finances, sales, supply chain, marketing, and executive updates. Smart insights, simple decisions, big results!

View Project
Engagement

Home Page View of Business Insights 360

Star Schema Data Model of BI 360

Project Details

Unlocking AtliQ's Success Journey! 🚀📊

Key Indicators:
Spotlighting AtliQ's health with Gross Margin, Net Profit, YTD, and YTG figures.

Expertise Highlights:
Crafting data magic with DAX, sleek data design, and visual wizardry. From live data updates to tooltip tricks, we've got it all!

Navigate BI 360 like a pro:
🏠 Home Hub
💹 Finance Facts
💼 Sales Stories
👔 Marketing Magic
🚚 Supply Chain Secrets
👨‍⚖️ Executive Insights

Outcome:
Finance View:
2018: $30M Net Sales, 37.43% GM, -4.38% Net Profit
2019: $110M Net Sales, 41.20% GM, 2.21% Net Profit
2020: $270M Net Sales, 37.10% GM, -0.85% Net Profit
2021: $820M Net Sales, 36.49% GM, -6.63% Net Profit

Sales View:
Amazon dominates and All-Out leads GM%. The notebook segment shines.

Marketing View:
Growing sales hint at market capture despite losses.

Supply Chain View:
Accurate forecasts guide supply planning and Net Error monitors inventory.

Executive View:
KPIs and growth insights for stakeholders.

Hello, I am

Shivprakash Vishwakarma

1

1

About

Key

My

AtliQ Hardware Sales and Finance Analytics

Business Insights 360

Awards

Contact Me

Email

Github

Linkedin

Call

Shivprakash Vishwakarma

Download Resume