Find Jobs
Hire Freelancers

Simple Data Warehouse and Excel Power Pivot / Power BI Solution

$25-50 AUD / hour

Finalizat
Data postării: aproape 7 ani în urmă

$25-50 AUD / hour

Our client is upgrading a legacy manufacturing production system and requires a basic data warehouse solution with a PowerPivot/Power BI front end so that reports can be built on this legacy system. A prototype solution has been built and many of the components will be re-usable in production. This project is to complete the 8 data warehouse SSIS load packages which load CSV exports into predefined tables in a MSSQL DB, build up to 4 additional SSIS packages for integration with other systems and finalise 2-3 PowerPivot reports which connect to this data warehouse and provide analysis and dashboard. The system is fully designed and this is only the implementation arm, you will be required to implement the solution according to the design and ask questions where the design is not clear. You will be required to log into the development system remotely via a remote agent.
ID-ul proiectului: 14041137

Despre proiect

36 propuneri
Proiect la distanță
Activ: 7 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
Dear Client: The project scope looks doable. I did similar projects earlier. Let's discuss and based on the document we can continue the development. Thank you. Will look forward to work with you. Regards, Rasel
$30 AUD în 40 zile
4,9 (2 recenzii)
3,5
3,5
36 freelanceri plasează o ofertă medie de $36 AUD/oră pentru proiect
Avatarul utilizatorului
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$50 AUD în 20 zile
4,9 (495 recenzii)
8,4
8,4
Avatarul utilizatorului
Hi, I am Nallakumar. I have more than 10 years of experience in SSIS, Power BI and other Data Warehouse technologies. I have very good experience in MS SQL Server and Reporting also. I am ready for a discussion and take it from there. I can work using Remote Desktop. Thanks, Nalla
$30 AUD în 40 zile
5,0 (66 recenzii)
7,1
7,1
Avatarul utilizatorului
MM. Hi, I am a sql developer. You want only ETL part or also the reporting has to be done. Please let me know more about it . So that we can take things forward. Thanks.
$41 AUD în 40 zile
5,0 (422 recenzii)
6,7
6,7
Avatarul utilizatorului
I am a database and excel expert. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements ..so kindly open PM to discuss work and budget..I am based in california and can talk over phone to understand the requirements and will provide support though out the project till you are satisfied with the work.. Regards,
$40 AUD în 40 zile
4,9 (124 recenzii)
6,7
6,7
Avatarul utilizatorului
Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits dashboards via Power BI and reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo
$27 AUD în 15 zile
5,0 (69 recenzii)
6,2
6,2
Avatarul utilizatorului
Hi Based on the project description provided: 1. ETL (Extraction - Transformation - Load) packages are to be developed using Microsoft SSIS 2. About 8 SSIS packages are to be built to load the CSV files into MS SQL databases 3. About 4 SSIS packages are to be built to integrate with other systems 4. About 3 PowerPivot reports are to be finalized I would like to introduce myself as a professional with more than 5 years of experience in BI technologies (SSIS, Informatica, SQL etc) alone. My priorities have been to work on long term relationships rather than one of projects for short duration. My recent engagement was with a Netherlands customer which has gone from strength to strength for more than 3 years. Given the opportunity, I am sure you will find myself an excellent value addition to your project. Looking forward to working with you. Thanks, Nutan
$46 AUD în 40 zile
5,0 (4 recenzii)
4,5
4,5
Avatarul utilizatorului
Please review my profile. I have 7.5 years experience in SQL and 4.8 years experience in SSRS, SSIS. I have started working on POWER BI. Please let me know more details and when we will start. Sky pe jikenjd
$25 AUD în 25 zile
5,0 (15 recenzii)
3,9
3,9
Avatarul utilizatorului
Hi, I'm a DWH/ETL expert from Bulgaria (EU) with 8+ years of experience in that field. I'm proficient in wide variety of data tools: 1. ETL - SSIS, Pentaho Kettle, Oracle Data Integrator (ODI), Informatica PowerCenter. 2. Databases - MySQL, MSSQL, PostgreSQL, Oracle, Teradata and few other. 3. BI - Pentaho BI, SSAS, SSRS, PowerBI. Also, my daily job routine requires very good scripting skills: Bash, Powershell, Python, as well as deep knowledge of SQL and database performance tuning and optimization. Best Regards, Vesselin Z.
$40 AUD în 40 zile
4,7 (3 recenzii)
4,3
4,3
Avatarul utilizatorului
Hi ! Can I have the project design specification please ?
$50 AUD în 40 zile
4,9 (8 recenzii)
2,7
2,7
Avatarul utilizatorului
Hi, I am a 4+ years experienced .NET and Visual Basic 6.0 desktop application developer. Worked mostly in banking/leasing industry. I have experience with connection Visual C# to MSSQL / MySQL databases using ADO .NET or EF with LINQ. Also, I am familiar with T-SQL and database design. I have very good experience with DevExpress, especially their Reporting control. Specialized in converting Visual Basic 6.0 applications to .NET and custom controls development.
$25 AUD în 10 zile
5,0 (1 recenzie)
2,3
2,3
Avatarul utilizatorului
Hi, i am iqha, I Love to work with excell spreedsheet. I am Fast Learner n analithycal thingking. I wish you can hire me and start the job, as soon as possible.
$25 AUD în 40 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Hello, How are you? I found your job post and I’m very interested in your project. As a skilled Web / Software Programmer professional with experience developing web and software, I think you’ll find I have the skills you’re looking for. I have 10 years experience in IT Software Development and have built software, websites and web applications. Please take a look at my portfolio in my profile and my site : web-software-developer[dot]com to get an idea of the kind of software I have developed. Below is the skills I have (rate 1 to 10 ): HTML4 : 8 HTML5 : 7 Jquery : 7 PHP : 8 .NET : 8 C# : 8 VB.NET : 8 Mysql : 8 SQL Server : 8 Ionic/Cordova : 6 Graphic Design : 8 PSD to HTML : 7 Code Igniter : 8 Kohana : 7 I am looking for a long time working with you and I think I can handle your project alone. I could provide a team too If you search a team for your project development. Thank you for your time, I am looking forward to hear again from you Regards Michael Sk*pe : michaelbzone
$25 AUD în 40 zile
5,0 (2 recenzii)
0,0
0,0
Avatarul utilizatorului
A proposal has not yet been provided
$35 AUD în 40 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
A proposal has not yet been provided
$45 AUD în 10 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
A proposal has not yet been provided
$30 AUD în 20 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Possess excel skills, type writing, free lancing, compiling of data, proof reading among many others. Most importantly can get work done in a reliable & time efficient manner at a relatively cheap cost.
$41 AUD în 40 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
i have done many projects like this before in large companies and have good experience and expertise,have samples ready and quickly do this
$41 AUD în 40 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul AUSTRALIA
Melbourne, Australia
5,0
5
Metoda de plată a fost confirmată
Membru din mai 11, 2011

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.