Asmaa Mohamed
Offer Asmaa work on your next project.
Rating
CV
Detail-oriented Junior Data Analyst with a passion for transforming raw data into actionable insights.
Skilled in statistical analysis and data visualization, I uncover trends and patterns that support strategic decision-making. With a strong foundation in tools such as Excel, SQL, Power BI, and Tableau, I deliver impactful freelance analytics and visualization services that help organizations make informed, data-driven decisions, optimize performance, and achieve their goals.
In addition to data analysis, I have gained over 15 years of experience at Kafr El-Sheikh University in database management, web design, graphic design, and digital library systems—contributing to well-rounded technical expertise and problem-solving abilities.
Skills and abilities
Programming
Services
Portfolio
-
TRAINING CENTER PERFORMANCE ANALYSIS
Data Parsing• Description: An interactive dashboard showing fees, Training courses performance
• Tools Used: Power Bi, Excel
• Data Source: the center Excel Sheets
• Story:
… 1- Exporting Data from Excel to Power BI
2- Using Power Bi:
• Data cleaning
• Measures
• Creating Visuals
• Arrange Visuals, Adding Filters to create interactive Dashboard showing the Performance
-
SALES ANALYSIS USING EXCEL & ACCESS
Data Parsing• Description: An interactive dashboard showing Sales Analysis
• Tools Used: Excel
• Data Source: Access Files
• Story:
… 1- Getting data from Access files
2- Using power pivot:
a. Creating tables relationships
b. Calculations with DAX language
i. Revenue
ii. COGS
iii. Profit
iv. Profit Margin
v. Working Days
vi. Avg Profit/Day
3- Pivot table for each data set
4- Pivot charts
5- Designing Interactive Dashboard with filters displays Sales Analysis
-
NORTHWIND DATA ANALYSIS USING SQL SERVER & EXCEL
Data Parsing• Description: An interactive dashboard showing Sales Analysis
• Tools Used: SQL Server, Excel
• Data Source: Northwind SQL Database
• Story:
… 1- In SQL, Creating Queries & Views for:
o Product performance
o top10 customers
o Net Sales Per Year
o Top Sales Products
o Employee Sales
o Order Timing Per Hour
o Delivery Days Avg.
o Top Suppliers
o Orders by Country
o Not Ordered Products
o Totals
2- Exporting Data to Excel
o Creating a Pivot table for every data set
o Creating Pivot charts
• Designing Interactive Dashboard with filters displays Sales Analysis