Find Jobs
Hire Freelancers

Data warehousing

$30-250 USD

Chiuso
Pubblicato quasi 6 anni fa

$30-250 USD

Pagato al completamento
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.
Rif. progetto: 17332879

Info sul progetto

36 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
36 freelance hanno fatto un'offerta media di $733 USD
Avatar dell'utente
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 Bases. I am expert in developing ETL , Data Warehouse , Reporting using Pentaho & SSIS, SSRS. I have strong command on queries too.I see your work & too much interesting in your work. My rates is also too much low. I assure you I am the best for your work. Kindly reply me so that we negotiate on price & then start working on it Have a good day Thank you
$200 USD in 3 giorni
4,8 (20 valutazioni)
4,7
4,7
Avatar dell'utente
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 working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Data Warehousing, Database Administration, Microsoft SQL Server, QlikView, SQL We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$250 USD in 3 giorni
5,0 (7 valutazioni)
4,2
4,2
Avatar dell'utente
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 about how many reports needed
$444 USD in 10 giorni
4,9 (10 valutazioni)
3,7
3,7
Avatar dell'utente
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 application development. I have a team of 10+ expert developers. I would love to discuss the work with you Please initiate chat so we can discuss better.
$250 USD in 10 giorni
5,0 (2 valutazioni)
2,7
2,7
Avatar dell'utente
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 project. Thank you, Regards.
$250 USD in 4 giorni
5,0 (5 valutazioni)
2,5
2,5
Avatar dell'utente
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 in 3 giorni
5,0 (1 valutazione)
0,3
0,3
Avatar dell'utente
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 in 10 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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. Skill Set: ASP.NET MVC, C#, Angular JS, Javascript, DWH- ELT (snowflake, star schema - dimension modeling), SSIS, SQL Server, SSRS, SSAS, Power BI(Desktop), CSS. Kindly let me know, Thank you.
$155 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 from you! Shyamalaa M.
$155 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 in 10 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 post each successful run. In case of amount and time required, we shall discuss to proceed.
$233 USD in 5 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 done your work in time, hope you can trust on me for this job thank you
$161 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
 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 developing Stored Procedures, Triggers and Tables, Views, Indexes, Query, SQL Server Profiler for trace analysis.  SSIS Package to transform the data using different Stored Procedures, Tables and controls. Worked with many flat file source related ETL processes by importing the data, cleansing the data then loading it into tables.  Worked on database management activities such as analyzing query execution plans, backing up and restoring databases on development and staging environments and performing various database maintenance tasks.  JOBs in Job Agent and Monitoring and Scheduling for Backup.  Mail using database mail systems. In addition, worked with procedures where need to call, retrieve and store data using web services.
$155 USD in 7 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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. And build dashports and rerports end of that.
$17.777 USD in 45 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hi I am having 11 years of experience in Microsoft SQL server and very good experience in EDw
$155 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 the process. If you want to go for SSIS tool then I can design the data warehouse for you. We can discuss more on chat.
$222 USD in 4 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 pretty quickly.
$277 USD in 15 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 in 4 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 in 3 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED STATES
United States
0,0
0
Membro dal lug 9, 2018

Verifica del cliente

Altri lavori del cliente

Data Visualization
$30-250 USD
Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.