Kapalı

ETL & Ad Hoc Reports - Pentaho

Looking to implement a ETL solution using Pentaho Data Integration

The source Database is based on Advantage Database server Tables - OLTP from [url removed, login to view]

Open for suggestions about the target database Tables

The source tables are in 5 Locations on a VPN Windows OS – The job would run each night preparing the file for the next day reports.

Would also need to make some Guided Ad-hoc drill down reports and cubes based on the following :

KPI /facts

Product_ID (FK)

Date_ID (FK)

Location_ID (FK)

Units Sold

Price

Min Price

Max Price

Average price

In Stock

On order

Projected ‘In Stock’ at a future date - based on Info taken for sales trend on past season

Received in a given time frame

Amount to Purchase

Meters of raw materiel would be used

Location Dimensions

Loction_ID (PK)

Loction

Product Dimensions

Product_ID (PK)

Line

Size - Numeric _size, Size_attribute (S,M,L,X -42X)

Design

Category

Date Dimensions

Date_ID (PK)

DayOfYear

DayOfMonth

weekOfmonth

WeekOfYear

MonthOfyear

Year

Beceriler: Microsoft Access, MySQL, Sharepoint, Yazılım Mimarisi, SQL

Daha fazlasını gör: pentaho hoc, hoc reports, etl advantage database server, pentaho advantage database server, software solution sales, pentaho products, pentaho 5, etl job, design and drill, architecture design on line, amount received, advantage database server pentaho, preparing hoc reports, pentaho advantage database, etl pentaho design, sql server max, max sql server, etl sql, www pentaho com, vpn software

İşveren Hakkında:
( 74 değerlendirme ) Brooklyn, United States

Proje NO: #621193

Bu iş için 16 freelancer ortalamada $1194 teklif veriyor

hussainsharif

Hi I am an IBM Certified ETL Consultant and have been writing ETL's for the past two years. I have experience working with Pentaho, Informatica as well as IBM Datastage. I can easily do this job for you and write the Daha Fazla

$750 USD in 14 gün içinde
(2 Değerlendirme)
4.3
DISoln

Please check PM for my proposal

$750 USD in 25 gün içinde
(7 Değerlendirme)
4.1
astaacustech

Hi, Interesting work. Please check PMB for more info. Regards, Rajiv

$450 USD in 10 gün içinde
(9 Değerlendirme)
3.4
suryavikas

Dear Sir, I have 3+ experience in ETL and report development. I have some questions Pls check your PM Regards Surya

$600 USD in 20 gün içinde
(0 Değerlendirme)
0.0
manjulasenthil

atma nameste i am interested in doing this

$600 USD in 15 gün içinde
(0 Değerlendirme)
0.0
sixsense

Hi, We can do this project and we have experience in developing applications. Thanks 6Sense

$900 USD in 20 gün içinde
(0 Değerlendirme)
0.0
sankalp700

Please let us know when we have to start working on your project asap

$250 USD in 15 gün içinde
(1 Yorum)
0.0
taoajayi

Hello, I can definitely do this project, and I bring extensive experience with Access and ETL products. Please check your PM shortly for details. Thanks.

$400 USD in 7 gün içinde
(1 Yorum)
0.0
farrukh421

Already developed many ETLs for data extraction using Pentaho and .Net as well as, data warehousing and BI reports.

$575 USD in 15 gün içinde
(0 Değerlendirme)
0.0
projectsoftware

Innoexcel Technologies INTRODUCTION Innoexcel Technologies is a U S based leading software development MNC in India providing Cost effective Offshore Software Development Services & Outsourced Product Development Daha Fazla

$425 USD in 20 gün içinde
(0 Değerlendirme)
0.0
sjj

Hi, Please check my pm. Thanks.

$700 USD in 20 gün içinde
(0 Değerlendirme)
2.4
BIConsulting

Sir/Madam: I am associated with BusinessInsights Consulting. We are a leading software development company in India, catering to small and medium enterprises. We have developed multiple Data Warehouses using Pent Daha Fazla

$9000 USD in 55 gün içinde
(0 Değerlendirme)
0.0
Ausodev

There is very interesting project for us. We are specializing in this kind of work. Our team of DBA experts has done many similar projects and we can do this one above your expectations extremely quickly with high qual Daha Fazla

$750 USD in 7 gün içinde
(0 Değerlendirme)
0.0
phprocks

Hi, please check the PMB.

$1000 USD in 15 gün içinde
(0 Değerlendirme)
3.0
alexcarbor

I'm expert in Business Intelligence and ETL. 15 years of experience [login to view URL]

$750 USD in 20 gün içinde
(0 Değerlendirme)
0.0
fpetralbajr

I can do the Complete BI Cycle which should be as follows: 1.1 Loading and Cleansing of Data using Pentaho Data Integration 1.1.1 Automated loading of raw data using a Windows scheduler 1.1.2 Data clea Daha Fazla

$1200 USD in 15 gün içinde
(0 Değerlendirme)
0.0