Dibatalkan

2 hour Task -> SQL Optimization with excel report Output

The time spent on this project needs to be 1-2 hours (3 hours max) and 1 day to complete. If you can't complete the task in this time frame please don't bid

If you can do this task and reduce in 50% or more the time it takes to run we are interested in paying you for this task and assigning you new tasks! Just run the sp on your local machine and show us the time it took originally and then run it again after optimization and show the time improvements and we will hire you and pay for the job and talk about new tasks

We are using this SQL optimization project to evaluate and select experts for our other ongoing projects, this optimization itself is MINIMALLY critical and the most important factor here to find qualified SQL experts who can improve eficiency (time) of the stored procedure to run and improve the output format (to excel with filters, headers etc).

We can award you the job and create milestone if you can show us this optimization and then release it once we run the job on our aws and confirm the optimization.

Output of this stored procedure should be to excel with some minimal formating (filter and freeze top row, font, and highlight some columns like the exemple excel that we attatched), currently we copy/paste results to excel then manually apply filter and other modifications and we want to avoid this.

Some details:

We have a mobile phone rental service and we need to audit the phone bill every month from the phone company then we need to recalculate the amounts that we will charge our clients. The stored procedure we are putting below is the primary report generators we use calculate amounts to charge our clients.

Currently it takes 45 min to load (on a [login to view URL] aws server) and has never been optimized for speed.

1) We're in the hopes that this can be significantly reduced (1/4 the time or less) with proper optimization.

2) we would like the output to go directly to excel with some modifications (filter/freeze top row, change font size, color columns). Example desired excel output attached

Download link for Database backup -> [login to view URL]

user -> freelancer

password -> freelancer01

Example execute the stored procedure for january 2019 and also extract below:

EXEC CobFullClaro_Load 1,2019 -- to load the data

EXEC CobFullClaro_Extract 1,2019 -- to extract

Cheers and good luck

Marcio

Kemahiran: Pentadbiran Pangkalan Data, Pengaturcaraan Pangkalan Data, Excel Macros, Excel VBA, Pelayan Microsoft SQL

Lihat lagi: sql bak excel, mysql excel report, sql access excel vba, good database design principles, database table design best practices, ssrs million rows, what do you use to automate data analysis in excel, excel vba automation examples, excel macros for data analysis, bad database design examples, ssrs report taking too long to render, report output convert excel, getting report output excel oracle apps, standard report output excel oracle 11i, oracle report output excel format, view oracle application report output excel, generate excel data report output oracle, getting data mdb output excel report, generate oracle report output excel, oracle 11i report output excel

Tentang Majikan:
( 35 ulasan ) RIO DE JANEIRO, Brazil

ID Projek: #18906527

3 pekerja bebas membida secara purata $158 untuk pekerjaan ini

Proolancer

Hello, I m a web and desktop developer with 8 years of experience in Sql & Excel too ,I did many management web system during my professional life, I can do what you want in the deadline just contact me and we can di Lagi

$30 USD dalam 5 hari
(7 Ulasan)
3.8
hemsingh1

SQL, EXCEL expert with over 9 years of experience. Can help to optimize the query as needed & can start right away. Thanks

$222 USD dalam sehari
(0 Ulasan)
1.7
writinginvaderz

Writing Invaders is a group of independent professional writers and website developer and scholars from everywhere throughout the world. Together, we give best quality aid to secondary school, undergraduate, Masters Lagi

$222 USD dalam 3 hari
(0 Ulasan)
0.0