Portfolio - abdiwahid abdullahi | Codebasics

Powered by
Codebasics Data Analytics Bootcamp

Hello, I am

abdiwahid abdullahi

Data Aspirant

Resume

1

Excel
Project

1

PowerBI
Project

About

Me

Welcome! I'm on a dynamic journey as an aspiring Data Analyst, driven by the thrill of unraveling insights from data's intricate threads. Proficient in harnessing Excel, Power BI, SQL, and Python, I'm all about translating raw information into actionable narratives.

I discovered my true calling in the world of data analysis. My curiosity and determination have fueled my journey to not just analyze data, but to also transform it into impactful business solutions.

I've embarked on numerous business projects, all proudly showcased in my portfolio below. Each project has been a playground for me to dive deep, showcase my skills, and unearth hidden opportunities.

Let's engage in a conversation about data, innovation, and the exciting potential it holds. Together, we can build data-driven strategies that unlock insights, efficiencies, and game-changing decisions. Welcome to my world of turning data into stories!

Key

Skills

Effective Communication

Stake holder Management

My

Projects

Sales Analytics

Sales Analytics

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

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

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

AtliQ Hardware is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company make informed decisions.

Contact Me

Email

[email protected]

Github

https://github.com/abdiwahidabdullahi/Excel-Sales-Analytics

Linkedin

https://www.linkedin.com/in/abdiwahid-abdullahi?lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_contact_details%3B%2BExe3w8eRuasijTqwucLYw%3D%3D

Call

+36 205905732

abdiwahid abdullahi

Data Aspirant

Download Resume

Resume

Excel Project

Sales Analytics

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
on GitHUB

Sales Analytics

Customer Performance Report: Provides net sales performance of each customer across years

Sales Analytics

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I utilized Excel pivot tables to create a sales report, aiding businesses in discount assessment, consumer negotiations, and spotting expansion chances in promising regions. Reports offer actionable insights and advice for sales strategy optimization, customer satisfaction boost, and revenue maximization.

Learnt:

Pivot Table
Power Query and DAX.
Conditional Formatting
Report Enhancement
Sales Metrics
Overall, this initiative empowers businesses with tools and insights for sales monitoring, evaluation, and improvement. Leveraging sales data analysis unlocks new opportunities, fuels growth, and ensures competitiveness in a dynamic market landscape.

PowerBI Project

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

AtliQ Hardware is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company make informed decisions.

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

User-empathetic landing page as a part of dashboard design

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

Data modelling involving 10+ tables

Project Details

Deliver a single report catering to sales, marketing, finance, and executive stakeholders. Focus areas:

Robust Data Modeling
User-centric Report Design
Drillable Insights
Skills Acquired:

Power Query (Basic and Advanced)
Basic & Complex DAX Formulas
Multi-table Data Modeling
Optimal Visual Selection & Formatting
Dashboard Design Principles
Bookmark Utilization
Power BI Service Deployment
Actionable Stakeholder Feedback Integration
Handling Sales, Marketing, Finance & Supply Chain Metrics
Outcome: Empower stakeholders with insights for strategic decision-making, fostering efficiency, unity, and growth.

Live Interactive Dashboard