Upwork home
Sign up
Project Catalog
DesignDesign
Video & AudioVideo & Audio
Development & ITDevelopment & IT
MarketingMarketing
Writing & TranslationWriting & Translation
MoreMore

You will get Designed and implemented a Data Warehouse in SQL Server using a Star Schema

Malak S.Status: Offline
Malak S.
Preview imagePreview imagePreview imagePreview imagePreview imagePreview image

Let a pro handle the details

Buy Database Optimization & Design services from Malak, priced and ready to go.
Malak S.Status: Offline
Malak S.
Preview imagePreview imagePreview imagePreview imagePreview imagePreview image

Let a pro handle the details

Buy Database Optimization & Design services from Malak, priced and ready to go.

Project details

designing and implementing a star schema data warehouse using SQL Server to organize and analyze operational data from multiple excel files. the project include:

Data modeling: created a star schema with dimension tables

Data integration: imported raw excel files into SQL Server and transformed them into a clean relational model

Extract transform load process: loaded and validated data across all dimension and fact tables while ensuring referential integrity with foreign keys

Data analysis: wrote SQL queries to generate insights
Database Type
MySQL, MS SQL, SQLite, PostgreSQL, MongoDB, Azure Cosmos DB
What's included
Service Tiers Starter
$20
Standard
$45
Advanced
$60
Delivery Time 2 days 4 days 7 days
Number of Revisions
123
Number of Tables Added
2510
Schema Diagram
-
Permissions Setup
-
Import/Export Data
Admin Panel Setup
-
-
Optional add-ons You can add these on the next page.
Fast Delivery
+$2
Additional Revision
+$2
Additional Table Added (+ 1 Day)
+$2
Schema Diagram (+ 1 Day)
+$2
Permissions (+ 1 Day)
+$2
Admin Panel Setup (+ 1 Day)
+$2
Malak S.Status: Offline

About Malak

Malak S.Status: Offline
Data engineer
Giza, Egypt - 2:23 pm local time
I’m a passionate Data Engineer with hands-on experience in designing data pipelines, managing databases, and building reporting systems using Python and SQL Server. I help businesses turn raw data into clean, structured, and actionable insights.

What I Can Do for You

Build ETL pipelines with Python (extracting from CSV, Excel, APIs, or databases, cleaning, and loading into SQL Server).

Design and implement databases & data warehouses (fact & dimension tables, star/snowflake schema).

Develop automation scripts in Python for data cleaning, validation, and transformation.

Optimize SQL queries, stored procedures, and database performance.

Create dashboards & reports by connecting SQL Server with BI tools (Power BI).

Perform data analysis & business insights (sales, HR, finance, customer behavior).

Handle data migration projects from Excel/legacy systems into SQL Server.

Steps for completing your project

After purchasing the project, send requirements so Malak can start the project.

Delivery time starts when Malak receives requirements from you.

Malak works on your project following the steps below.

Revisions may occur after the delivery date.

review client's excel files and requirements

design or adjust the SQL Server database schema

Review the work, release payment, and leave feedback to Malak.