Amira Salama
BI Analyst at Envase Technologies
Data Analytics at Udacity
Egypt
Hi, I'm Amira Salama!
BI Analyst at Envase Technologies
Ex-Banker transitioned into a Data analyst role after completing Advanced Data Analysis Nanodegree from Udacity, Google Data Analytics Certificate, Machine Learning Cross Skilling Nanodegree. Holder of MBA, I've Diverse experience in financial operations and customers’ data, with +10 years of experience in a Senior Officer role. I'm Passionate about Customer Experience and Learning, Right now I'm working as a BI Analyst I've designed tens of ad-hoc reports and dashboards crafted according to customers' needs and targeted towards better data driven decisions Skills: SQL , Python, R, Data Visualization with Tableau, Power BI and Google Data Studio, A/B & Hypothesis Testing
Experience
Envase Technologies
BI Analyst
January 2022 - Present
• Designed +50 Ad-hoc reports using SQL and Info Maker software targeted to customers’ needs and requests. • Built 10s of Dashboards, KPIs using Tableau, Google Data Studio and Microsoft Power BI and Excel, to track sales and management performance.
EBE
Banking Senior Officer
September 2006 - January 2019
• Daily Checking Customers’ Data integrity and Quality, answering customers’ queries and requests • Supervised Reports and daily operations, customers’ and clearing checks inside branches, coordinated. • Communicated with bank departments and branches, examined corporate and personal financial documents. • Queried CRM , daily transactions ensuring proper authorization, prepared ad-hoc reports & updating Customers' data according to compliance regulations.
Education
Data Analytics
Udacity
Graduated in 2022
Data Mining and Machine Learning
IBM
Graduated in 2021
Certificates & Badges
No certificates or badges added
Projects
Latest Month Sales Moving Avg Comparison
•https://public.tableau.com/app/profile/amira.salama/viz/SalesMovingAvgComparison/SalesMovingAvgVisualizations and Data Analysis
How does the latest month Sales compare to the prior X months average?
Dynamic KPI Dashboard
•https://public.tableau.com/app/profile/amira.salama/viz/KPIDashboard_16644003968440/KPIDashboardVisualizations
Dynamic KPI Dashboard based on Sales, Profit , Profit Ratio and # of orders with Subcategory Ranking that changes when clicking on any of the KPIs in a descending order.
Dynamic Month Over Month Change
•https://public.tableau.com/app/profile/amira.salama/viz/MOMChange/MOMVisualizations and Data Analysis
Creating a table showing the last three months of Sales/Profit/Avg. Days to Ship values and evaluate the change in the latest month compared to the previous one.
Superstore Bottom 20 Performing States
•https://public.tableau.com/app/profile/amira.salama/viz/ProfitLossStates/TemplateVisualizations
Credits: Mastering Tableau 2021 (Marleen Meier, David Baldwin) Book, and The Post How to use hex-tile maps to eliminate the Alaska effect, this Dashboard features the the bottom 20 performing States (as Hex-tile Maps) in terms of profit/Sales Ratio
Languages
Arabic
Native
English
Professional
French
Intermediate
Skills
SQL
Python
Pandas
Tableau
A/B Testing (Split Testing)
Sybase
Microsoft SQL Server
Excel
Power BI
Data Analysis
Marketing Analytics
Data Analytics Developer
Ready for a personalized experience? We use cookies and similar technologies to tailor our site just for you. By clicking 'Accept', you're giving us the thumbs up to use cookies and similar technologies. 🍪