Find Jobs
Hire Freelancers

Simple Data Warehouse and Excel Power Pivot / Power BI Solution

$25-50 AUD / hour

Terminado
Publicado hace casi 7 años

$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 del proyecto: 14041137

Información sobre el proyecto

36 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 40 días
4,9 (2 comentarios)
3,5
3,5
36 freelancers están ofertando un promedio de $36 AUD /hora por este trabajo
Avatar del usuario
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 en 20 días
4,9 (495 comentarios)
8,4
8,4
Avatar del usuario
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 en 40 días
5,0 (66 comentarios)
7,1
7,1
Avatar del usuario
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 en 40 días
5,0 (422 comentarios)
6,7
6,7
Avatar del usuario
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 en 40 días
4,9 (124 comentarios)
6,7
6,7
Avatar del usuario
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 en 15 días
5,0 (69 comentarios)
6,2
6,2
Avatar del usuario
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 en 40 días
5,0 (4 comentarios)
4,5
4,5
Avatar del usuario
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 en 25 días
5,0 (15 comentarios)
3,9
3,9
Avatar del usuario
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 en 40 días
4,7 (3 comentarios)
4,3
4,3
Avatar del usuario
Hi ! Can I have the project design specification please ?
$50 AUD en 40 días
4,9 (8 comentarios)
2,7
2,7
Avatar del usuario
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 en 10 días
5,0 (1 comentario)
2,3
2,3
Avatar del usuario
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 en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 40 días
5,0 (2 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$35 AUD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$45 AUD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$30 AUD en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 40 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
Melbourne, Australia
5,0
5
Forma de pago verificada
Miembro desde may 11, 2011

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.