Sandra Dsouza

Data Aspirant

[email protected] +44 7442672361

Resume

Hello, I am

Sandra Dsouza.

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About Me

Creative and Ambitious Logistics and Supply Chain Management graduate with strong expertise in data analytics and experience in logistics modeling, operations management, and process optimization. Proficient in tools such as Excel, Power BI, SQL, Python, and Tableau, with the ability to analyze and interpret complex datasets to drive insights and improve business performance across various industries.
Currently expanding my focus into Project Management to enhance my ability to lead and execute projects effectively. Known for adaptability, teamwork, and solving problems through data-driven decision-making. Seeking opportunities to leverage my data analytics and technical skills to optimize business processes and deliver meaningful results in any data-focused industry.

Key Skills

Mysql

Excel

PowerBI

Supply chain

Logistics

My Projects

Sales and Finance Analytics

Domain/Function: Sales and Finance

Business Insights - 360

Domain/Function: Business Insights - 360

Consumer Goods Ad-Hoc Insights

Domain/Function: Consumer Goods

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Foundations: Data, Data, Everywhere

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/sandra-d-6b44b8231/

Call Me

+44 7442672361

GitHub

https://github.com/Sandra281298

Excel Project

Sales and Finance Analytics

Domain/Function: Sales and Finance

AtliQ Hardware is moving from handwritten reports to an Excel-based reporting system to combat financial losses. Project will create a tool for analysing sales and financial performance, enabling quick identification of key metrics and trends. This aims to support decision-making and drive growth.

View Project
Engagement

View Project
on GitHUB

View Project
on Power-Point Presentation

Other Tools

Power pivot

Power Query

Pivot Table

Dax

Power-Point Presentation

Conditinal Formatting

M-Language

Excel

Customer Sales Performance

Market Sales Performance

Project Details

In this project, I aimed to convert raw sales data into meaningful business insights through a structured approach involving three key stages:
1.Extract, Transform, Load (ETL) with Power Query-Performed data cleaning tasks like removing duplicates, renaming columns, and merging tables to create a unified and accurate dataset.
2. Advanced Analysis with Power Pivot & & DAX-Leveraged Power Pivot for advanced calculations and utilized Data Analysis Expressions (DAX) to analyze the data. Established relationships within the data model using Diagram View to ensure accurate and insightful analysis.
3.Dynamic Reporting with Pivot Tables-Created interactive and visually appealing reports using Pivot Tables, making the analysed data easy to interpret and action upon.

PowerBI Project

Business Insights - 360

Domain/Function: Business Insights - 360

AtliQ is a rapidly growing hardware company that distributes a wide range of products across numerous countries through various channels, including retail, direct sales, and distributor networks. This includes online and physical store sales. To support its expansion and drive data-driven decision.

View Project
Engagement

View Project
on GitHUB

Other Tools

SQL

PoweBI

Excel

Dax Studio

Power-Point

Languages- M

DAX

Executive View

Domain Knowledge

Project Details

Planning: Created a Project Charter with objectives, timeline, and risks.
Data Collection: Designed a date table in Power Query for better analysis
Data Loading & Validation: Imported data, conducted quality checks.
Data Transformation: Cleansed and transformed data using Power Query.
Modeling & DAX: Developed data models and measures with DAX.
Dashboard Development: Built interactive dashboards for Finance, Sales, Marketing, and Supply Chain.
Validation & Feedback: Ensured data integrity and incorporated stakeholder feedback.
Deployment: Published reports on Power BI Service with automated refreshes.

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-Hoc Insights

Domain/Function: Consumer Goods

In this project, I delved into 10 Ad-hoc queries, untangle key details about top products, customers, markets, and crucial metrics like gross price, pre-invoice deductions, manufacturing costs, and sales quantity. It's all about turning data into actionable insights!

View Project
Engagement

View Project
on GitHUB

View Project
on MySQL

Other Tools

Mysql

Power-Point Presentation

Excel

AtliQ Market in APAC Region

10 Ad-Hoc Request

Project Details

Tools Used:
- MySQL Workbench (For getting insights using SQL)
- Microsoft Excel (For data visualization)
- Microsoft PowerPoint (For presentation)
Knowledge gained in:
1. Database Exploration with MySQL Workbench.
2. Data Management Concepts.
3. Database Design Principles.
4. Data Integrity and Relationships.
5. SQL Querying Expertise.
6. Advanced Query Techniques.
7. Understanding Datatypes.
8. Window Functions.
9. Database Optimization Techniques.