Fermé

Data warehousing

Project Requirements:

• Select a very large dataset (unstructured in different sources like excel, sql server, flat files etc)

• Perform Data Warehousing:

1. Perform (SSIS) ETL on above selected sources. Create multiple tasks to load data into SQL server db into different tables. Schedule a refresh time task.

2. Trigger a mail everyday morning to the user regarding refresh like if it is successful or a failure refresh.

3. Inside the db tables make sure there are primary keys, foreign keys.

4. Perform analysis of data by building a cube in tabular model in SSAS with measures and dimensions using star schema. Process and browse the cube and include some DAX/MDX Queries just to show how we retrieve data from a cube.

5. Now visualise data in any of the reporting tools either SSRS or Crystal reports with some good information being visualized. Deploy the SSRS reports and analyse the data in excel.

Compétences : Stockage de données, Administration de Bases de données, Serveur SQL Microsoft, QlikView, SQL

en voir plus : data warehousing architecture, data warehouse example, data warehouse vs database, data warehouse definition and examples, what is data warehousing quizlet, data warehousing concepts, data warehouse pdf, data warehouse tutorial, data warehousing project, statistics project report using spss 100 data set, project data structure project using queue stack, oracle data warehousing 10g project insurance, data mining project using cart, data warehousing data mining project, project data warehousing data mining, project data mining data warehousing, data mining data warehousing project, project data warehousing mining, data warehousing project description, data mining project using php mysql

Concernant l'employeur :
( 0 commentaires ) United States

Nº du projet : #17332879

36 freelance font une offre moyenne de $733 pour ce travail

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(75 Commentaires)
7.0
shahzaib121

Hi Dear I have a lot of experience in DataBases ,Data Warehous,DB2 . I am DataBases + Warehouse certified from Oracle,SQL SERVER . I have done many work in Requirements analysis , Data Staging, Data Warehouse, Data Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(20 Commentaires)
4.7
schoudhary1553

Hi there..... Warm Greetings We came along with your request for Data warehousing and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(7 Commentaires)
4.2
sreenivas2903

hi its pleasure to work with etl data loading on large datasets , i am good at both sql and ssis , I can make it work and deliver in quick time and desigining cube as well, ping me for more info and please be clear ab Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(10 Commentaires)
3.7
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(9 Commentaires)
3.3
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(9 Commentaires)
3.6
sanjaykumar0111

Hi Thanks for looking on my bid I have one suggestion about last point we can use Microsoft Power BI for better visual and effective reports Relevant Skills and Experience I have 4+ year experience in web a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(2 Commentaires)
2.7
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Will use the reporting, sql server, ETL as well. Willing to take up your Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(5 Commentaires)
2.5
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(2 Commentaires)
2.3
udaydatla

Have good Experience in creating data warehouses and building ETL jobs to support the data load. Good in SSIS and data modeling as well

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
0.3
RajviSanghvi

I believe in talking through my work. If I will get this project you will have best results with no bug in given days.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(0 Commentaires)
0.0
claudioacevedo25

am a responsible and very capable person, with knowledge and experience that certify my career. It would be a pleasure to work for you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
vipul22193

Vast experience in the entire MSBI stack , i.e. DSIS , SSAS , SSRS and SQL Server makes me a perfect fir for your requirement. Worked vastly on all the three components and in depth knowledge helps me get rid of errors Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(0 Commentaires)
0.0
a7garg

Hi , I am having 7+ year of ETL experience with MSBI. I am very good in SQL. Please give me this projects. Thanks, Ankur

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(0 Commentaires)
0.0
jveselysks

Hello, I am new at freelancer.com but in my previous work i worked with Visual Studio on daily basis. Primary as SSIS tool and I used OBIEE as analytical tool but Microsoft solutions are also not new for me. If you giv Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0
Ksari

Hi, Greetings!! Thank you for your consideration. I would like to introduce myself, I've overall 7 years of experience as Senior Data Analyst (SSIS/SQL Server/ SSRS/Power BI/Python) and have extensive knowledge in de Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
0.0