Abel gebreyohannis
2450 Athlone | Montreal QC, Canada |-|-
Portfolio: https://my.novypro.com/abel-gebreyohannis
Professional Summary
Microsoft Certified Power BI Data Analyst with 8 years of experience in sales and marketing across multinational companies and industries.
My background in sales and marketing gives me a deep understanding of business KPIs, customer behavior, and performance metrics, allowing me to design data-driven dashboards that not only visualize trends but also align with real-world business decision-making. I am Experienced in sales forecasting, market segmentation, campaign performance analysis, and customer retention strategies, I leverage my industry knowledge to create impactful, insight-driven reports that directly contribute to revenue growth and operational efficiency.
Skills
Data Analysis and Interpretation
Problem Solving and Strategic Thinking
Data Visualization and Communication
Certification & Education
Microsoft Certified: Power BI Data Analyst Associate
Frontend Web Development Certification
Graphic Design
Masters Degree in Marketing Management
BA in Business Management
Portfolio Projects
Project portfolio Link:
NovyPro: https://my.novypro.com/abel-gebreyohannis
Maven Analytics: https://bit.ly/3DZaYmw
LinkedIn: https://www.linkedin.com/in/abel-gebretsadik/
1. Global Superstore performance analysis:
Project summery and Highlights: This three-page interactive Power BI report presents a comprehensive analysis of store sales performance, customer insights, and product analysis. It enables business stakeholders to monitor key performance indicators (KPIs) such as sales, profit, order trends, customer segmentation, and product performance. By visualizing these metrics, decision-makers can enhance sales strategies, optimize product offerings, and improve customer retention.
Project Highlights:
Sales & Profit Analysis: Tracked key financial KPIs, market-wise performance, and category sales distribution.
Customer Insights: Analyzed customer segments, purchase frequency, and top revenue-generating customers.
Product & Order Evaluation: Assessed product profitability, order priorities, and shipping cost impact.
Key Skills Demonstrated:
This project required expertise in Power BI development, including data cleaning, transformation, and visualization. Advanced DAX calculations were used to derive KPIs such as YoY growth and time intelligence functions. The dashboard effectively supports data-driven decision-making for sales and customer management.
Link for interactive visual: https://bit.ly/3XHtLcJ
2. Adventure Work Sales Performance Dashboard:
Project summery and Highlights: The adventure work sales performance is another project that show case my skill in power BI. the project includes advanced DAX measures and time intelligence function and interactive visuals to track and present key business metrics.
Project Highlights:
KPI and Trend Visualization: Visualized sales, profit, orders and other metrics across different timelines, geography and product categories as well as year over year change.
Interactive Exploration: Enabled users to explore market-specific sales and profit data.
Key Skills Demonstrated:
Extracted, transformed, and loaded data from multiple workbooks into Power BI, ensuring seamless integration. Built a robust data model for consistency and accuracy while developing custom DAX measures for KPIs, YoY analysis, and time intelligence. Designed interactive dashboards with advanced visuals, slicers, drill-through, drilldown, and page navigation for enhanced data exploration.
Tools utilized: Power BI desktop and Power BI service
Link for interactive visual: https://bit.ly/42oxEG2
3. Marketing Campaign Analysis:
Project summery and Highlights: This dashboard provides a comprehensive overview of a marketing campaign's performance, focusing on key metrics like sales, customer engagement, and channel effectiveness.
The dashboard also highlights the relationship between income and web purchases, the breakdown of sales by product category, the percentage contribution of different categories to total sales, and the geographical distribution of customers. Overall, the dashboard indicates a successful campaign with strong sales performance, but also highlights areas for potential optimization, such as improving campaign acceptance rates for lower-performing campaigns and potentially diversifying sales across different product categories.
Key Skills Demonstrated:
Data cleaning, extraction and transformation which followed by building data model between fact and dimension tables to ensure consistency, accuracy, and efficient data relationships. Created custom DAX measures, tables and columns to compute KPIs measure Year over Year (YoY) changes and other time intelligence analysis. Finally Designed interactive dashboards with advanced visuals, slicers, and charts as well as page navigation, drill through and drilldown options.
Tools utilized: Power BI desktop and Power BI service
Link for interactive visual: https://bit.ly/42dXv2i
4. DATABEL TELECOM Customer Churn Analysis:
Project summery and Highlights: This project aimed to understand and quantify customer churn at DATABEL TELCOME, revealing a significant issue with a 46.3% churn rate leading to a substantial financial loss of $908.9K. The analysis identified key factors contributing to churn, including competitive pressures, customer dissatisfaction, pricing concerns, and negative attitudes. Customers with higher monthly charges, lower data usage, shorter account lengths, and those paying via paper check were found to have a higher propensity to churn. Furthermore, the high number of customer service calls among churned customers suggests potential issues with service quality or resolution.
The findings highlight the urgent need for DATABEL TELCOME to implement targeted retention strategies. Recommendations include addressing competitive pressures through pricing and service adjustments, improving customer satisfaction by investigating and resolving service issues, optimizing pricing strategies, enhancing customer service responsiveness, and developing specific retention plans for high-risk customer segments. By focusing on these areas, DATABEL TELCOME can significantly reduce churn, improve customer retention, and mitigate the substantial financial losses associated with customer attrition.
Key Skills Demonstrated:
Data Analysis and Interpretation: cleaning, extracting and transforming data and identify patterns and trends to interpret the data in order to infer insights.
Problem solving and strategic thinking
Data visualization and communication: developing interactive and appealing visuals to communicate effectively
Tools utilized: Power BI desktop and Power BI service
Link for interactive visual: bit.ly/3D7ukpe
5. Sales Analysis:
Project summery and Highlights: This Power BI project presents a comprehensive sales performance dashboard, providing a clear overview of key financial metrics and trends over a period spanning 2013 and 2014. The dashboard focuses on sales, quantity sold, cost, and profit, comparing current year performance to the previous year. It also delves into granular details, showcasing sales trends over time, year-to-date sales by product, quarterly profit by product, sales distribution across different customer segments, and sales by country and product. The dashboard effectively visualizes sales data to enable stakeholders to quickly understand performance and identify areas for improvement or strategic decision-making.
The Sales Performance Dashboard project showcases impressive year-over-year growth, with substantial increases in sales, quantity sold, cost, and profit, culminating in a strong 14.23% profit margin. The dashboard effectively visualizes sales trends, revealing peak performance in October, while also providing granular insights into product performance through YTD sales and quarterly profit analyses. Furthermore, the project highlights the dominance of the government segment in sales volume and effectively illustrates the geographic distribution of sales across different countries, offering a comprehensive view of the company's sales performance.
Key Skills Demonstrated:
Data Modeling and Transformation: The project required structuring and transforming sales data to create a coherent and insightful data model for analysis.
DAX (Data Analysis Expressions): The creation of measures to calculate sales performance metrics, year-over-year changes, and profit margins demonstrates proficiency in DAX.
Data Visualization and Dashboard Design: The development of interactive charts, graphs, and slicers showcases strong data visualization and dashboard design skills, enabling clear and effective communication of sales insights.
Business Intelligence Analysis: The project reflects a strong understanding of business intelligence principles by translating raw data into actionable insights for sales performance analysis.
Tools utilized: Power BI desktop and Power BI service
Link for interactive visual: https://bit.ly/42h9NqI
