About Me
Welcome!
Hi, Iām Bahre Hailemariam ā Data Analyst & BI Developer.
I specialize in transforming raw, messy data into clear insights and interactive dashboards. Using SQL, Python, Excel, Power BI, and Tableau, I help businesses uncover opportunities, improve decision-making, and drive growth.š¹ About MeI bring a unique mix of analytical skills and business understanding. With experience in interpreting complex datasets, building BI solutions, and automating reporting workflows, I deliver results that save time and enable smarter decisions.My strengths include:
Designing interactive dashboards that tell a story.
Performing ETL, data modeling, and automation.
Conducting scenario modeling and financial analysis (including M&A use cases).
Bridging technical outputs with clear communication for business leaders.
š¹ Core SkillsData Analysis: SQL, Python (Pandas, NumPy), Excel (Power Query, PivotTables)
BI Tools: Power BI (DAX, data modeling), Tableau
Data Management: ETL, database querying, workflow automation
Business Focus: Financial modeling, performance tracking, operations analytics
Skills
SQL | Power BI | Excel | Tableau | Python | AI
Data Visualization-3+year
Data Analytics-4+year
Time Managment-5+year
Report Development-3+year
Featured Projects
Seasonal Sales Trends Analysis using Power BI |SQL server
Replaced a manual process by creating a SQL script and Power BI dashboard to pull and visualize revenue data.
Marketing Analytics Business Case
Replaced a manual process by creating a SQL script and Power BI dashboard to pull and visualize revenue data.
Emergency Room Patient Flow & Wait Time Optimization by Utilizing Power BI | Excel
Creating Visualization and data driven Insight for Patients Emergency Room visit report.
Employee Performance & Productivity Analysis Using Power BI and Excel
Creating Dashboard and Report of Employee work habit using Power BI and Excel.
Analyzing and Manipulation Anbessa bank database system using SQL
Analyzing and Modelling of Anbessa bank database system using MySQL And Excel
Immigration to Canada from 1980 to 2013
Analyzing and Visualization the Immigration to Canada from 1980 to 2013 using Python
Data Analytics for Insurance Cost Data Set using Python
Data Wrangling ,EDA and Model Development ad Refinement using Python and notebook
Furniture sales Overview
Transformation, Pivoting ,analyzing ,visualization and Dashboarding using Excel
Professional Certifications
My growing list of proprietary,exam-based certifications.
IBM Data Science Professional Certificate | Issued Jan 13 2025
Become _ a_ Python_Master | Issue 2nd October 2023
Become _ a_ SQL_Master | Issue 24th September 2023
Seasonal Sales Trends Analysis using Power BI |SQL server management studio 20
Data Model
Below is a screenshot of the data model after cleansed and prepared tables were read into Power BI.This data model also shows how FACTBudget hsa been connected to FACTInternetSales and other necessary DIM tables.
Marketing-Analysis-Business-Case and Optimization by Utilizing Power BI | Excel
Emergency Room Patient Flow & Wait Time Optimization by Utilizing Power BI | Excel| Power point
Finding and Insights
Total Patient analysis: Overall Total Patients is currently at 4,632. Total Patients for Age Buckets 70+ is significantly lower than other segments at 513 and significantly higher for department referral None at 2,726.
Average Satisfaction Score analysis : Overall Average Satisfaction Score is currently at 5.45, and Average Satisfaction Score for Age Buckets 70+ is significantly lower than other segments at 4.75.
Percentage No Rating analysis: Overall % No Rating is currently at 75.71%. % No Rating for department referral Gastroenterology is significantly lower than other segments, and % No Rating for Month Mar and 2 other segments is significantly higher.
Average Wait Time analysis : Overall Average Wait Time is currently at 35.53, and Average Wait Time for department referral Renal is significantly lower than other segments at 34.1.
Percentage Referred Patients analysis : Overall % Referred Patients is currently at 41.15% and % Referred Patients for department referral Renal is significantly higher than other segments at 4538.10%.
Percentage Un Referred Patients analysis : Overall % Un Referred Patients is currently at 58.85% and % Referred Patients for department referral Renal is significantly higher than other segments at 6490.48%.
Percentage Female Visit analysis : Overall % Female Visit is currently at 48.23%, and % Female Visit for Age Buckets 41-50 and Weekday Fri are significantly higher than other segments at 51.40% and 52.72%, respectively.
Employee Performance & Productivity Analysis Using Power BI and Excel
Insight from Above Dashboard
Increased employee engagement scores (+15%)
10% reduction in attrition within 12 months
Specifically and more details insights and findings
Presence Percentage : started trending down on Tuesday, January 11,2022,falling by 8.46%(8.19%) in 5 days.
Steep trend in Presence Percentage : Presence % dropped from 96.79% to 88.61% during its steepest decline between Tuesday, January 11,2022 and Sunday, January 16,2022.
Long trend in Presence Percentage : Presence % experienced the longest period of growth(+1.04%) between Sunday, January 2, 2022 and Saturday, January 8, 2022.
Recent trend in WFH Percentage : WFH % started trending up on Friday, January 7, 2022, rising by 66.69%(4.38%) in 13 days.
Steep trend in WFH Percentage : WFH% jumped from 6.57% to 10.96% during its steepest incline between Friday, January 7, 2022 and Thursday, January 20, 2022.
Long trend in WFH Percentage : WFH % experienced the longest period of growth(+4.38%) between Friday, January 7, 2022 and Thursday, January 20, 2022.
Recent trend in SL Percentage : SL % started trending up on Wednesday, January 26, 2022, rising by 331.02%(4.16%) in 4 days.
Steep trend in SL Percentage : SL% jumped from 1.26% to 5.42% during its steepest incline between Wednesday, January 26, 2022 and Sunday, January 30, 202.
Long trend in SL Percentage : SL % experienced the longest period of growth(+0.30%) between Tuesday, January 4, 2022 and Tuesday, January 25, 2022.
