Mahmoud Lashin | BI Developer | Data Analyst

Mahmoud Lashin

BI Developer | Data Analyst

Based in Cairo, Egypt

About

Passionate about the power of data analysis and how visualizing these insights can drive useful decisions for business needs. Data give us correlations but business need causation.

Skills

Projects

Cars-Supply-Chain

Cars-supply-chain Data source: Kaggle Project Steps 1- Data Gathering 2- Data Processing & Cleaning 3- ERD and Mapping 4- Database Creation 5- Data warehouse Creation 6- ETL Processing using SSIS 7- SSAS 8- SSRS 9- Excel Dashboard 10- Power BI Dashboard 11- Tableau Dashboard

Amazon Sales Analysis

After getting the required tables from SQL server, I have build a Star schema model and added a date table using DAX. Then i begin to analyze the data to get insights for product categories, sales teams, shipping methods and orders.

Education

2016 - 2021

Faculty of computer and information science

Scientific computer and all related courses like Algorithms, Data Structure, OOP, Statistics, Mathematics, Logic programming, C++, Python, and artificial intelligence.

2023 - 2024

Data Analysis Diploma ( ITI )

I have an intensive training in using analysis and visualizations tools like Power BI, Tableau, Excel, SSIS, SSAS, SSRS, Python, SQL, ETL, Data warehouse, Data cleaning and data mining.