SQL Server Data Warehouse Design Project

This project is for the design, and implementation of a Data Warehouse built using MS SQL 2005. The project requires a solid understanding and experience in developing star schemas for ecommerce retail transaction data as well as page and session level data warehouse design. We currently have a well normalized OLTP SQL 2000 database which has detailed transaction data from our eccommerce system as well as detailed records for page views and sessions. The developer who will be best candidate for this project must show some sample schemas and will be questioned via Private message on their expertise. Knowledge and experience with ETL features of SQL 2005, reporting services and SQL Server OLAP/MDX will be a big plus for this project and for ongoing development and reporting work throughout the year.

*** All candidates for this project must contact by Private Message their experience directly in this areas AND a sample eccommerce transaction star schema, AND a sample page and session star schema, AND a few examples of useful non trivial queries and what they return as an example of your domain knowledge in this area***

Skills: .NET, ASP, Data Processing

See more: data warehouse design sql 2005, MDX, what is oltp with example, what is oltp system, what is an olap database, understanding by design, system server, star services, server domain, schema design, reporting services sql, oltp examples, oltp example, oltp database example, oltp and olap examples, olap examples, olap database examples, olap database example, olap database design, olap database

About the Employer:
( 7 reviews ) Lake Park, United States

Project ID: #57564

34 freelancers are bidding on average $1221 for this job


Can be done with your 100% [login to view URL] check PM for our past work. 30 Days development + 5 Days for testing + Bug Fixing. Progress Report Weekly + Dedicated Team + You can reach team Via Email, Yahoo, MSN, More

$1500 USD in 35 days
(8 Reviews)

We are a registered 100% Export Oriented Unit(EOU) Software Company in India also registered under the Software Technology Parks of India. Established in 1994, our's is a privately held company with a focus on providin More

$1300 USD in 45 days
(6 Reviews)

Hello, I am experienced database applications developer. I know MSSQLServer(6.5-2005), SQLBase, MySQL. Also: VC++, .NET, OLEDB, ADO, [login to view URL], COM etc. Regarsd, Oleg.

$1499 USD in 1 day
(3 Reviews)

Please see PMB for details

$1400 USD in 20 days
(5 Reviews)

We have lot of project that used sql data warehousing. Please just see pmb fo detail.

$800 USD in 10 days
(14 Reviews)

Dear Sir/Madam This is with reference to your opening. I have reviewed your requirement and find myself competent to execute it. If you are satisfied with my profile, i would surely like to grab this opportunity More

$1500 USD in 30 days
(1 Review)

Dear Sir, Myself Rushikesh Patel, I was working with Anand Systems Inc from last 4 years as Sr. Web Designer/Graphic Designer/Webmaster/Web Specialist/Web Master. Please find my resume attached in .doc word format. More

$1450 USD in 28 days
(6 Reviews)

Being in database development for above 10 years your job is not so difficult. We only need to integerate the front end with the application. The application might get over earlier based on your consistent and proper r More

$1500 USD in 45 days
(1 Review)

“We are team of professional’s expertise in developing web based application using PHP/ASP/.NET and in web designing using Photoshop, Dreamweaver MX, Flash [login to view URL] reading your project description, we are highly inter More

$1300 USD in 31 days
(2 Reviews)

Dear Sir/ Madam We are a PIONEER company in Web Applications, Application development and Search Engine Optimization. Please find attached a BROCHURE of our company, [login to view URL], which contains all the details. We are More

$1500 USD in 20 days
(1 Review)

for saving your and my time, please contact me: MSN: andrewsadovuj ^

$300 USD in 10 days
(0 Reviews)

As we have already this type of [login to view URL] is easier for us to deliver within stipulated time with quality.

$450 USD in 10 days
(0 Reviews)

We are experienced in MSSQL shemas and stored procedures. We recently completed a HIPAA compliant medical records document managment system to manage over a 1m documents, please see PMB

$1500 USD in 40 days
(0 Reviews)

We are * an ISO-9001 certified * 7 years experianced in Web development and Application development. * 60 IT proffesionals * 15 Fine Arts designers skilled with flash and graphics development * 24 X 7 hours ser More

$1500 USD in 29 days
(0 Reviews)

2 years free support of this project,includes additions and alterations in [login to view URL] facility is for 24 hours and 7 days. we have experienced programmers and developers(10 years and more) for following tools and te More

$1500 USD in 30 days
(0 Reviews)

I can do this project for you.

$800 USD in 30 days
(0 Reviews)

We have such developers who can do such projects. for our other work please view [login to view URL] as we have many projects in PHP/My SQL, .Net/SQL Server Projects for our office view ht More

$1400 USD in 15 days
(0 Reviews)

We have strong experience in .NET/Java/PHP, MSSQL/Oracle/MySQL, development e-commerce solutions. We offer high quality of our job and completion the project in time. We'll provide weekly reports, email and online cont More

$1200 USD in 35 days
(0 Reviews)

Hi, I represent Provati Tech Limited which is one of the fastest growing outsourcing company. We have 30 Programmers who can handle any difficult problem. We are not only expert in C/C++/Visual Basic/Visual C++/.Net/PH More

$1300 USD in 40 days
(0 Reviews)

Our team has great experience in development system based on .Net 2.0 and MS SQL Server 2005. Such as real estate cadastre, energy monitoring system etc. We are able to do this job.

$1300 USD in 30 days
(0 Reviews)