visual studio analys service and integration

Goal n. 1 Using the Adventure Works database for MSSQL Server 2016 (Full version), the goal is to build a data warehouse/data mart that allows to describe/characterize:

- The customers;

- Habits of consumption;

- Relationship with the AdventureWorks;

- Satisfaction with purchased services and products;

- And other information that might be relevant.

Goal n. 2

Using Adventure Works database for MSSQL Server 2016 (Full version), the second goal is to build a data warehouse/data mart that allows to characterize and evaluates sales performance by employee, store, region, country, category, sub-category and product model. The data warehouses must be fully defined and installed in Analysis Service. Visual Studio project, the SQL scripts to generate all DB tables and relationships.

Can be done all in one single project

The main goal of this task is the implementation of
the Extraction, Transform and Load
– ETL process, in such way that:
- It allows to fullfil the warehouse with all the n
ecessary data extracted from the
AdventureWorks database (and others, if included);
- The main goals of the task number one should guid
e the implementation of the task
number two – the final result is to supply answers
to the questions defined on the task
number one;
- The full data warehouse, including the data uploaded by the ETL process, should be deployable into the Analysis Service;
- Changes to the structure of the data warehose are allowed, but should be justified;
- The efficiency of the ETL process will be taken into account at the final evaluation of
the task;
- Three values will be reserved to the implementation of Slow Change DImensions – type Two (or other).

Habilidades: .NET, Programação C#, Microsoft Access, Microsoft SQL Server , SQL

Ver mais: error service notification command defined anywhere, xml web service integration, submit coupon service, web service integration api, joomla web service integration, web service integration joomla, salesforce net web service integration, vanilla forum integration single sign, service provider single page website, java axis web service integration, mobile sms service integration aspnet, ads submit automatic service, visual studio sharepoint intranet integration, payment service integration aspnet, java web service openldap single sign session control, joomla file sharing service integration, php video chat service integration, fedex web service integration php

Acerca do Empregador:
( 0 comentários ) Portugal

ID do Projeto: #16061723

10 freelancers are bidding on average $206 for this job


Greeting, I have understood your visual studio analys service and integration task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 yea Mais

$200 USD in 3 dias
(11 Comentários)

Hi Dear Data Warehouse , Databases expert are here. We have a team expert in DataBases , Data Warehouses specifically using SQL SERVER , Oracle etc Relevant Skills and Experience We have done so many projects using th Mais

$250 USD in 3 dias
(16 Comentários)
$244 USD in 5 dias
(8 Comentários)
$155 USD em 1 dia
(2 Comentários)

Respected Sir/Madam. Through this proposal I would like to convince to assign this task or project.I will give my best result and satisfaction apart of the work. Relevant Skills and Experience Asp.net MVC MsSql/MySql/ Mais

$150 USD in 3 dias
(1 Comentário)

I am expertise in loading data to warehouse and building reports , let us know for further clarification and work Relevant Skills and Experience BI Developer having excellent skillset in SSIS and TSQL , currently work Mais

$222 USD in 5 dias
(2 Comentários)

hi i am a senior web developer .net, c# programming is my favorite subject Relevant Skills and Experience .net, c# Proposed Milestones $222 USD - discuss

$222 USD in 3 dias
(0 Comentários)
$266 USD in 3 dias
(0 Comentários)

I have good experince in microsoft [url removed, login to view] i was working in capgemini india pvt ltd as a team lead.i have inplemented many projects in ssis,ssas,ssrs. Relevant Skills and Experience Presently i was work Mais

$255 USD in 5 dias
(0 Comentários)
$100 USD in 5 dias
(0 Comentários)