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).

Kemahiran: .NET, Pengaturcaraan C#, Microsoft Access, Pelayan Microsoft SQL, SQL

Lihat lagi: microsoft reporting services projects, visual studio analysis services download, visual studio 2015 analysis services, visual studio 2017 ssdt, visual studio 2017 ssis, business intelligence for visual studio 2017, visual studio 2017 analysis services, ssdt for visual studio 2015, 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

Tentang Majikan:
( 0 ulasan ) Portugal

ID Projek: #16061723

9 pekerja bebas membida secara purata $205 untuk pekerjaan ini


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 Lagi

$200 USD dalam 3 hari
(11 Ulasan)
$155 USD dalam sehari
(12 Ulasan)

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 Lagi

$250 USD dalam 3 hari
(16 Ulasan)
$244 USD dalam 5 hari
(9 Ulasan)

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/ Lagi

$150 USD dalam 3 hari
(1 Ulasan)

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 Lagi

$222 USD dalam 5 hari
(2 Ulasan)
$266 USD dalam 3 hari
(0 Ulasan)

I have good experince in microsoft [login to view URL] 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 Lagi

$255 USD dalam 5 hari
(0 Ulasan)
$100 USD dalam 5 hari
(0 Ulasan)