Architect, Populate and Explore a Data Warehouse for Business Intelligence -- 2 - 29/11/2017 16:46 EST

€30-250 EUR

Closed

Posted

over 6 years ago

€30-250 EUR

Paid on delivery

The data warehouse should meet the following minimum requirements: - At least 3 sources of relatable data must be included - At least 1 source of data must be structured - At least 1 source of data must be unstructured - An ETL process is required to extract data from the original sources, clean the data, transform it into a suitable structure for your data warehouse data model, and load your data warehouse - It must be possible to run the ETL strategy multiple times - The data warehouse must support 3 non-trivial BI queries Written report

Database Administration

Project ID: 15761854

About the project

9 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

9 freelancers are bidding on average €341 EUR for this job

@veskojl

Hi, I'm a DWH/ETL/BI expert from Bulgaria (EU) with 8+ years of experience in that field. I'm proficient in wide variety of data tools. Relevant Skills and Experience 1.ETL-SSIS, Pentaho Kettle, Talend, Oracle Data Integrator (ODI), Informatica. 2.Databases-MySQL, MSSQL, PostgreSQL, Oracle, Teradata and a few others. 3.BI-Pentaho BI, SSAS, SSRS, PowerBI, Cognos Proposed Milestones €100 EUR - M1: Find, review, approve and prepare the data sources €300 EUR - M2: Create the DWH structure: fact tables, dimensions, €300 EUR - M3: Implement the ETL €50 EUR - M4: Other requests from the client Is this a home/course project or some real work?

€750 EUR in 14 days

5.0

(1 review)

0.0

@CHREHAN

I have almost 5+ years of experience in Business Intelligence, ETL, Database Development, Database Optimizations, Database Design and BigData. Relevant Skills and Experience My area of expertise are ETL (SSIS) SSAS Pentaho BI SUIT PDI Database Designing Database Development Query Optimization. SQL Scripting Client Issues Fixations Creating reports Cassandra Proposed Milestones €277 EUR - Architect, Populate and Explore a Data Warehouse When to start work on ?

€277 EUR in 10 days

4.7

(6 reviews)

0.0

@sunilmudunuri

I have 9 years of experience in SQL Server design, development and optimization. I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design Relevant Skills and Experience 1) Sql Server 2005/2008/2012, 2) MYSQL 3) Oracle (PL/SQL), 4) SSIS, SSRS and SSAS, 5) Data analytics using R-Programming and SAS. Proposed Milestones €155 EUR - I would be able to deliver your solution within the timeline with better quality

€155 EUR in 3 days

0.0

(0 reviews)

0.0

@tandonsneha

I have worked as a DW modeler, ETL and SQL person for many years in big 4 consulting companies. This project is like an everyday task for me. Relevant Skills and Experience Data Warehousing Data Modeling SQL , Oracle PL/SQL, Oracle Expertise Proposed Milestones €200 EUR - Data Model €200 EUR - DataWarehouse and complete implementation Additional Services Offered €1200 EUR - Complete end to end ETL and data integration project What is the ETL tool to be used for process? What is the perferred database vendor for this project?

€400 EUR in 10 days

0.0

(0 reviews)

0.0

@amitnm

Have 7 years of experience in building datawareshouses for top financial institutions in India Relevant Skills and Experience I have following relevant skills 1. DataModelling 2. Informatica (ETL) 3. Oracle/Teradata/PostgresSQL Proposed Milestones €100 EUR - Project Plan €111 EUR - Requirement Gathering to understand source systems and BI reports €200 EUR - Data Model (Dimension, Fact and Reporting tables) €200 EUR - Technical Design (ETL Load Strategy, Source to Target Mappings) Additional Services Offered €300 EUR - ETL Development €100 EUR - Unit and System Testing

€611 EUR in 7 days