Who am i

About me

Hello, I’m a Business Intelligence Analyst and Data Strategist based in Toronto, Canada, with a focus on transforming data into actionable insights and optimizing business performance.

Professional Profile

I am a Business Intelligence Analyst and Data Strategist with a strong background in data analytics, business strategy, and technical execution. My journey from construction engineering to earning an MBA, a Bachelor’s in Business Management, and completing a Data Analytics Bootcamp from the University of Toronto has equipped me with the expertise to transform complex data into actionable insights that drive business growth and operational efficiency.

Currently, I work at Mofer Coffee, Toronto, where I lead the analysis of sales, inventory, and customer data. By leveraging tools like Power BI and Tableau, I create interactive dashboards and automated reporting systems that deliver real-time insights, helping improve decision-making and branch-level performance. I have also implemented demand forecasting models, optimizing inventory management and reducing overstock and stockouts.

Previously, as a Junior Data Analyst at Icon Business Consultancy in Addis Ababa, I developed automated reporting systems and analyzed HR and operational data using Python and SQL. My focus is on bridging the gap between data science and business strategy by delivering data solutions that empower organizations to thrive in a competitive, data-driven landscape.

Hire Me
What i can do

Skills

In an ever-evolving landscape of data and technology, possessing a diverse skill set is essential to uncovering valuable insights and driving impactful decisions. Below is an overview of the technical skills that I utilize to transform complex datasets into actionable business intelligence.

Data Analysis Tools

Skilled in Excel for advanced calculations, Power BI and Tableau for dynamic dashboards, and SSRS, SSIS, and SSAS for comprehensive reporting and integration.

Programming Languages

Proficient in Python, SQL, JavaScript (including HTML and CSS), with expertise in data processing, automation, developing interactive dashboards, and web scraping.

Database

Skilled in Microsoft SQL Server, PostgreSQL, MySQL, and MongoDB, with expertise in database management, querying, and optimizing data storage for efficient retrieval, analysis, and scalability.

Cloud Platforms

Experienced with Azure and Databricks for managing big data workloads. Utilize these platforms for scalable data processing, analytics, and deploying machine learning models, ensuring efficient handling of large datasets.

Data Science

Skilled in Machine Learning, including supervised and unsupervised learning techniques. Proficient in data preprocessing and feature engineering to build and refine predictive models for actionable insights..

Soft Skills

Possessed strong analytical thinking, problem-solving abilities, and effective communication. Skilled in collaborative teamwork, time management, and adaptability, ensuring successful project delivery and stakeholder engagement.

What i know

Skills in percent

Discover the proficiency levels of my core skills, measured in percentages to showcase my expertise. From programming and data analysis to cloud platforms and data science, these metrics reflect my commitment to mastering each area and delivering exceptional results.

Power BI
SQL
Tableau
Python
Excel
What i did

Portfolio

My skill proficiency is reflected in my extensive experience and hands-on projects. This section showcases my commitment to mastering these skills and applying them effectively to deliver impactful solutions. Click the All/any button below or Project Showcase under PORTFOLIO dropdown menu to view detailed case studies, code samples, and interactive demos. Let's dive into the journey of innovation and results!

JavaScript, Python

Global Electronic Sales Data Analysis

This project focuses on analyzing global electronic sales data to gain insights into various aspects of the business.

Tableau

Citi Bike Data Analysis and Dashboard Reporting

This project involves analyzing Citi Bike Trip History Logs to uncover key trends and unexpected phenomena in the usage of the bike-sharing service in New York City.

JavaScript

Interactive Earthquake Visualization Map

This project leverages Leaflet.js and D3.js to create an interactive map for visualizing real-time earthquake data and tectonic plate boundaries.

SQL

SQL Data Modeling, Engineering, and Analysis

This project focuses on designing and engineering a relational database system for employee data, using SQL to query, analyze, and derive insights from the data.

Python

Temperature and Air Pollution Correlation Analysis

This project explores the correlation between rising global temperatures and increased levels of PM2.5 air pollution across selected countries: the USA, Canada, Mexico, Chile, and Colombia.

Supervised Machine learning

Real Estate Price Prediction

This project focuses on predicting real estate prices in the USA using supervised machine learning(regression models).

Web Scraping

Mars News and Weather Data Analysis

This project involves web scraping and data analysis to gather Mars-related news and weather data.

Excel

Toys Factory Regional Sales Analysis

This project analyzes monthly toy factory sales data to evaluate regional performance using advanced Excel formulas. Key metrics such as Total Revenue and percentage changes provide insights for informed business decision-making.

Excel

Labor Statistics Analysis

This project analyzes US labor statistics to identify wage and employment trends across industries and states using Excel. Key metrics such as Average Wage and Total Employees provide insights for informed policy decisions and workforce planning.

Excel

MHG Booking Data Analysis

This project analyzes hotel booking data to understand customer behaviors and trends using Excel. Key metrics such as Cancellation Rate, Average Daily Rate, and Revenue provide insights for strategic decisions in the hospitality sector.

VBA

Automated Stock Data Extraction and Analysis

This project automates the extraction and processing of stock market data within an Excel workbook using a VBA script

Excel

Crowdfunding Campaign Success Analysis

This project analyzes a dataset of 1,000 crowdfunding campaigns to uncover trends and insights related to campaign success.

Unsupervised Machine learning

Cryptocurrency Clustering Analysis

This project focuses on clustering cryptocurrencies based on their market performance data.

Work Experience

I leverage data analytics to empower informed decision-making, utilizing advanced tools for automation, interactive dashboard development, and data governance. My expertise lies in optimizing data workflows and enhancing analytical strategies to drive business growth and improve operational efficiency, ensuring data-driven solutions that align with organizational goals.

Mofer Coffee Business Intelligence Analyst 2023 - Present

I analyze sales, inventory, and customer data to provide insights that drive growth, build interactive dashboards, and automate reports using Power BI and Tableau. I also implement demand forecasting models to optimize inventory and improve branch efficiency.

Icon Business Consultancy PLC Junior Data Analyst 2019 - 2022

Automated workflows, created Power BI dashboards, and improved data quality, driving efficient and informed decision-making.

Rift Valley University Research and Community Services Officer 2016 - 2019

Coordinated research and community service activities, developed analytical models and dashboards, and optimized strategies using advanced data analysis. Managed data-driven evaluations and prepared reports to support institutional goals.

Education

Aligning Business Management and MBA with Data Analytics bridges the gap between conventional business knowledge and the essential technological skills needed to proficiently handle and understand data

University of Toronto Certificate Data Analyst 2024 - 2024

Completing a data analytics bootcamp has significantly advanced my career with hands-on skills and a strong foundation, accelerating my learning and sparking a passion for excellence in the dynamic world of data analytics.

Rift Valley University Master's of Business Administration 2018 - 2020

MBA studies integrate leadership, operations, and finance for enhanced decision-making, efficiency, and innovation in the data-driven business landscape.

Rift Valley University Degree of Business Management 2017 - 2022

My BA Degree in Business Management sparked a passion for data analytics, seamlessly integrating strategic decision-making with the transformative power of data.

What i learned

Certificates

I gained hands-on experience in advanced data analysis, database management, and programming, enhancing my ability to solve complex problems, develop data-driven insights, and effectively communicate results using modern analytical tools.

SQL

PostgreSQL
SQL

Microsoft SQL Server (T-SQL)
SSIS

Microsoft SQL Server Integration Services
SSAS

Microsoft SQL Server Analysis Services
SSRS

Microsoft SQL Server Reporting Services
Business Intelegence

Microsoft Power BI
Business Intelegence

Microsoft Power BI
Python

Python Programming
Web Development

Full Stack Web Development
Java

Java Programming
Statistics

Statistics for Data Analysis

The role of statistics in business intelligence, the difference between sample and population data, and the importance of using statistical techniques to make smart predictions and data-driven decisions.

Analytics

Think Like an Analist

Introduce the analytics landscape and walk through each stage of the data analysis workflow

Excel

Excel Formulas & Functions

It is all about using formulas & functions to transform basic Excel worksheets into dynamic and powerful analytics tools.

Excel

Excel Charts & Graphs Certificate

Provides a deep, comprehensive review when, why, and how to use each type of chart, introduce key data visualization best practices.

Excel

Power Query, Power Pivot & DAX

Designed to guide through the entire BI workflow from start to finish.

Excel

Excel Pivot Tables & Charts

Essential tools for data exploration in Excel, allowing you to instantly sort, filter, and analyze your data.

Excel

Advanced Excel Dashboard Design

Designed for visualization and design principles, along with powerful techniques for creating dynamic, interactive Excel reports and dashboards.

Excel

Excel Specialist

Build a deep, expert-level skill set, including formulas, charts, PivotTables, Power Query, and more.

Excel

Excel VBA & Macrost

Build a deep, expert-level skill set, including formulas, charts, PivotTables, Power Query, and more.

SQL

MySQL Data Analytics

MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal.

SQL

MySQL Database Administration

This course, teachs how to design, optimize, and administer relational databases using MySQL Workbench.

SQL

Advanced MySQL for Marketing & Web Analytics

This course, teachs advanced MySQL techniques and help to apply them to real-world marketing and ecommerce business

SQL

Advanced MySQL Database Administration

This course, expanding into advanced concepts like replication, backup, recovery, and security, along with automation tools like stored procedures, triggers, and scheduled events.

SQL

MySQL Specialist

Become specialist in core techniques for single and multi-table analysis, including SELECT and CASE statements, table unions and joins, and database normalization best practices.

Data Analytics

Data Analytics
What my references say

Testimonial

As a testament to my professional journey, explore the perspectives of esteemed mentors, professors, and clients who have witnessed firsthand the depth of my expertise and the impact of my contributions in the dynamic realm of data analytics..

An exceptional student, demonstrating a profound understanding of data analytics concepts and methodologies, consistently delivering insightful analyses and solutions during our coursework..

Bharat J. Bharadwaj Course Instructor, University of Toronto

Gedlegeorgis has been instrumental in driving our business forward at Mofer Coffee. As our Business Intelligence Analyst, he has expertly managed and analyzed sales, inventory, and customer data. His development of interactive dashboards and automated reporting systems has provided us with actionable insights and enhanced our decision-making processes, significantly contributing to our growth and efficiency.

Milkias Tefera CEO, Mofer Coffee

Gedlegeorgis's proficiency in data analysis and his technical acumen have been impressive. His ability to translate complex data into actionable insights and optimize reporting systems is a testament to his strong analytical skills and dedication.

Selamu Abebe Database Administrator, Alabama Medicaid

Gedlegeorgis was a key asset to our team as a Junior Data Analyst, consistently delivering high-quality automated reports and insightful Power BI dashboards. His proactive approach and technical expertise greatly enhanced our data analysis capabilities and team efficiency.

Zekarias Aregay Team Leader, Icon Business Consultancy PLC

Gedlegeorgis's role as a Junior Data Analyst at Icon Business Consultancy PLC was marked by exceptional contributions to our data-driven strategy. His innovative use of Python and SQL to streamline processes and develop advanced dashboards significantly advanced our decision-making and operational excellence.

Temesgen Belete CEO, Icon Business Consultancy PLC
What i am thinking

Latest Blog

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod t empor incididunt ut labore et dolore magna aliqua. quis nostrud exercitat ion.

Sep 12, 2017

A portrait is not made in the camera but on either side of it.

Oct 4, 2017

Bad design is smoke, while good design is a mirror.

View all

Let's Talk

Phone: 1-437-775-2875

Email Me

gedlegg@gedlegeorgisgeda.com gedlegg@gmail.com
Sending your message....
Your message has been sent.
Something went wrong, please try again.