Find Jobs
Hire Freelancers

Simple Data Warehouse and Excel Power Pivot / Power BI Solution

$25-50 AUD / hour

Selesai
Dibuat hampir 7 tahun yang lalu

$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 Proyek: 14041137

Tentang proyek

36 proposal
Proyek remot
Aktif 7 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
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 dalam 40 hari
4,9 (2 ulasan)
3,5
3,5
36 freelancer menawar dengan rata-rata $36 AUD/jam untuk pekerjaan ini
Avatar Pengguna
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 dalam 20 hari
4,9 (495 ulasan)
8,4
8,4
Avatar Pengguna
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 dalam 40 hari
5,0 (66 ulasan)
7,1
7,1
Avatar Pengguna
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 dalam 40 hari
5,0 (422 ulasan)
6,7
6,7
Avatar Pengguna
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 dalam 40 hari
4,9 (124 ulasan)
6,7
6,7
Avatar Pengguna
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 dalam 15 hari
5,0 (69 ulasan)
6,2
6,2
Avatar Pengguna
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 dalam 40 hari
5,0 (4 ulasan)
4,5
4,5
Avatar Pengguna
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 dalam 25 hari
5,0 (15 ulasan)
3,9
3,9
Avatar Pengguna
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 dalam 40 hari
4,7 (3 ulasan)
4,3
4,3
Avatar Pengguna
Hi ! Can I have the project design specification please ?
$50 AUD dalam 40 hari
4,9 (8 ulasan)
2,7
2,7
Avatar Pengguna
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 dalam 10 hari
5,0 (1 ulasan)
2,3
2,3
Avatar Pengguna
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 dalam 40 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 40 hari
5,0 (2 ulasan)
0,0
0,0
Avatar Pengguna
A proposal has not yet been provided
$35 AUD dalam 40 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
A proposal has not yet been provided
$45 AUD dalam 10 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
A proposal has not yet been provided
$30 AUD dalam 20 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 40 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 40 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera AUSTRALIA
Melbourne, Australia
5,0
5
Memverifikasi Metode pembayaran
Anggota sejak Mei 11, 2011

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.