Convert a Template to a Website

$250-750 USD

Closed

Posted

over 8 years ago

$250-750 USD

Paid on delivery

Required Skills: T-SQL,SSIS,SSAS Requirement: I need to create a multidimensional cube which should have type 2 dimensions tables in it. we work on Kimball method .so,we started populating data from source to stage (direct load through packages ). and from stage to warehouse by creating type2 packages for the tables,so now i need to work on the etl work to populate the fact table in the data mart and after that type 2 dim tables in the datamart that will have etl work . the final stage is i need to show the type2 records in the cube through excel . I CAN SHOW U THE DOCUMENT ONCE WE GET TO KNOW thank you

Microsoft SQL Server

Project ID: 8844798

About the project

7 proposals

Remote project

Active 8 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

7 freelancers are bidding on average $640 USD for this job

@wellisfer

I have being working with SQL/SQL Server for 16 year. I'm a SQL Server specialist. I have worked with databases SQL Server with more than 7 terabytes.

$722 USD in 3 days

0.0

(0 reviews)

0.0

@aazo

I have more then 7 years of experience in writing SQL queries, creating SSIS packages and designing data mart.

$500 USD in 7 days

0.0

(0 reviews)

0.0

@johnilett

1. Once you send through the requirements. I will review and happy to either discuss any questions through skype or send questions directly to your email. 2. Will then put together a quick specification and design of exactly how the system will work and look and answer any questions you may have to make sure we are both on the same page. And everything is as expected. 3. Will go away and develop the solution using the Microsoft BI stack (Will ensure through initial investigations SQL server version, SPs are in line). 4. Will send through daily/half daily update to you on progress. 5. Will demo output and loading process so you can see as well as data produced through SSAS cube into an Excel Pivot to get output as desired. 6. Any questions, enhancements will be discussed and implemented at this point. 7. Once complete second demo if required 8. Finally will package up through a series of scripts with step by step release guide and technical document describing each component. 9. Once you receive will walk you through making sure system is fully up and running on your environment. 10. Final meeting to agree sign off. 11. Will be on hand in future for any minor support questions / More work if required in the future.

$700 USD in 5 days