Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak

Asmaa Mohamed

Offer Asmaa work on your next project.

Egypt Tanta, Egypt
9 months 9 days back
Available for hire available for hire
on the service 11 months 9 days

Rating

Successful projects
No data
Average rating
No data
Rating
106
Data Parsing
500 place out of 787
Data Processing
745 place out of 1491

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

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