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

Asmaa Mohamed

Offer Asmaa work on your next project.

Egypt Tanta, Egypt
8 months 12 days back
Available for hire available for hire
on the service 10 months 13 days

Rating

Successful projects
No data
Average rating
No data
Rating
106
Data Parsing
490 place out of 762
Data Processing 1
714 place out of 1472

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