Data warehousing

Cerrado Publicado hace 5 años Pagado a la entrega
Cerrado Pagado a la entrega

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.

Data Wahrehousing Administración de bases de datos Servidor de Microsoft SQL QlikView SQL

Nº del proyecto: #17332879

Sobre el proyecto

36 propuestas Proyecto remoto Activo hace 5 años

36 freelancers están ofertando un promedio de $733 por este trabajo

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 Más

$200 USD en 3 días
(20 comentarios)
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 Más

$250 USD en 3 días
(7 comentarios)
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 Más

$444 USD en 10 días
(10 comentarios)
3.7
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 Más

$250 USD en 10 días
(2 comentarios)
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 Más

$250 USD en 4 días
(5 comentarios)
2.5
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

$222 USD en 3 días
(1 comentario)
0.3
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.

$155 USD en 10 días
(0 comentarios)
0.0
prameshoviam

Hi, I am a individual freelancer and not from company. I am a FULL Stack MS Technologies developer. Currently i am looking for new work and would like work with you. I am flexible and independent freelancer. S Más

$155 USD en 3 días
(0 comentarios)
0.0
shyamalaam

Dear Employer, I have gone through your requirement and i would like to apply for your datawarehousing job. i have previous similar work experience to finish the work on time and within budget. Happy to hear fro Más

$155 USD en 3 días
(0 comentarios)
0.0
saraaben

My skill set is a perfect match for the job requirements. In particular, my data warehousing skills make me an ideal candidate for the project.

$200 USD en 10 días
(0 comentarios)
0.0
Jagvir1993

Currently my full time job description matches with your requirement. I am working on data ware housing including informatica ETL post which qlikView reporting since last 2 years. I can also provide you data testing po Más

$233 USD en 5 días
(0 comentarios)
0.0
roshanasim

hi , i am doing job in data warehouse from 2012 in a well known company, where i work as a database administrator also have a complete knowledge about microsoft sql server, qlikveiw, i can help you in this project and Más

$161 USD en 2 días
(0 comentarios)
0.0
waosisi

Professional team, good at machine learning and big data analysis, there are former big data analysts of aliyun among the team members, hoping to help you

$200 USD en 3 días
(0 comentarios)
0.0
BinduPshah

 A professional with engineering background having 12 years of experience in IT industry.  I have professional knowledge of working on SQL, T-SQL, Server migration, SSIS, QA scripting, Manual testing.  T-SQL for d Más

$155 USD en 7 días
(0 comentarios)
0.0
devmaslan

Can use one built-in ETL solution for all your flatfiles,excels and sql source to staging data on your environment and build a data warehouse by cleaning, de-duping, managing with best approach regarding to your goal. Más

$17777 USD en 45 días
(0 comentarios)
0.0
kashrifu

Hi I am having 11 years of experience in Microsoft SQL server and very good experience in EDw

$155 USD en 3 días
(0 comentarios)
0.0
raj16burad

Being an expert in data warehouse I can complete your requirement using BODS tool and generate reports on the data using BO reporting tool as per your requirement. Along with it, I'll design the entire documentation of Más

$222 USD en 4 días
(0 comentarios)
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 Más

$277 USD en 15 días
(0 comentarios)
0.0
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.

$166 USD en 4 días
(0 comentarios)
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

$155 USD en 3 días
(0 comentarios)
0.0