You will get Data warehouse design and ETL scripts


Project details
You will receive all the SQL scripts needed to:
1. Create empty data warehouse
2. SQL scripts for initial data loading
3. SQL Scripts for periodic incremental data loading
3. Documentation on data warehouse and ETL
4. Documentation on Reportable elements and approach to implement dash boards
1. Create empty data warehouse
2. SQL scripts for initial data loading
3. SQL Scripts for periodic incremental data loading
3. Documentation on data warehouse and ETL
4. Documentation on Reportable elements and approach to implement dash boards
Database Type
MySQL, MS SQLWhat's included
| Service Tiers |
Starter
$1,000
|
Standard
$5,000
|
Advanced
$6,000
|
|---|---|---|---|
| Delivery Time | 15 days | 60 days | 70 days |
Number of Revisions | 1 | 1 | 1 |
Source Code |
Optional add-ons
You can add these on the next page.
Additional Revision
+$100About Ravindran
Relational Databases. Data warehouse design, ETL, Data analytics
Bengaluru, India - 7:12 am local time
design and Data Analytics. I have extensive experience in Marketing,
Retail, Sales, Outbound Logistics domains. My experience includes
conceptualizing and steering projects in:
1. Software product development
2. Data warehousing and Data visualization
3. Preparation of data for statistical modelling
4. Presentation of statistical models with interactive user interface
5. Optimization of statistical models according to user specified
constraints
6. Coaching in Data Warehouse design and ETL development
Steps for completing your project
After purchasing the project, send requirements so Ravindran can start the project.
Delivery time starts when Ravindran receives requirements from you.
Ravindran works on your project following the steps below.
Revisions may occur after the delivery date.
Source Data study and analysis
At the end of this step I will present a document that clarifies my understanding of the source data for approval
Data warehouse design
At the end of this step I will present the ERD of the data warehouse and provide explanation on the various tables. In addition I will also present a reportable elements matrix to be reviewed and approved by the client