En cours

SQL Server - Finish SQL View Report (Excel and PowerBI)

Hello - I have a developer who has been creating a report for me combining multiple SQL tables into a view so that I can use the report in Power BI and Excel. The developer is on vacation and the report/structure is ~80% complete. He has made a 15 minute video on how he has everything organized. Here is the link - [login to view URL]

.I need someone to do the following:

- adjust/complete wrong formulas

- add metrics from other tables

- ensure the data from the polled files is complete (not missing days)

If this works goes well I also need assistance on the ETL side and Power Bi/Excel if you have expertise (not required for this project). I anticipate the initial project not taking more than 5 hours

Here is correct dropbox link:

https://www.dropbox.com/s/rfn9ycu18b4bkzi/DBS%20Test_II_UnPivot_I.mp4?dl=0

Compétences : Serveur SQL Microsoft, SQL

en voir plus : microsoft on premise, configure the data source for an existing data gateway, improve power query performance, when you connect to a model in sql server analysis service, what is shown in the navigator window?, allow unrestricted measures in directquery mode, sql server analysis services, on premises data gateway recovery key, vbscript excel example sql server connection string, load excel spreadsheet sql server, report master details sql server 2005, view crystal report aspnet custom sql, comparison view mysql db2 oracle sql server, creat report using crystal sql server 2008, can excel read sql server 2005 backup, sql server 2005 save report table

Concernant l'employeur :
( 18 commentaires ) brandon, United States

Nº du projet : #17334381

Décerné à:

feninsoftech

Hi, I have 11 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenan Plus

$22 USD / heure
(40 Commentaires)
6.0

27 freelance font une offre moyenne de $19/heure pour ce travail

$20 USD / heure
(10 Commentaires)
4.5
shahzaib121

Hi Dear I have a lot of experience in Big Data , Data Analytics, Business Intelligence.I am Business Intelligence certified from Excel,Tableau, Power BI. I have done many work Requirements analysis , Data Staging, D Plus

$16 USD / heure
(15 Commentaires)
4.5
SergioAlfaroV

Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with 12 years of experience using SQL, queries, reports and dashboards design and construction, data warehousing, an Plus

$20 USD / heure
(9 Commentaires)
4.5
tangramua

Hello, I can help you to finish SQL view report (Excel and PowerBI). As for me, I'm a professional system admin with 10+ years of experience. My main specialization is LAMP stack of technologies (Linux, Apache, MySQ Plus

$22 USD / heure
(1 Évaluation)
3.8
$16 USD / heure
(8 Commentaires)
3.6
supergana

Hi - Before i start, want to let you know your video isn't opening. It says something about unpivot which is a very easy stuff. I am an IT professional with 2 decades of experience of which 18 years were with In Plus

$24 USD / heure
(8 Commentaires)
3.4
$27 USD / heure
(9 Commentaires)
3.6
marloufin

Hi, I've been in mssql for 10 years and excel vba macro for 3 years and currently creating company tools for users reporting. Willing to help you with your project, just let me know and we can discuss it further. Plus

$22 USD / heure
(5 Commentaires)
3.0
Lultu

have been working with Sql for last 13 yrs...eager to work on Power BI but never got an opportunity yet. hope to work on this.

$16 USD / heure
(3 Commentaires)
3.1
khanicha

You are correct, this will require a vey quick time frame as I will just continue the remaining Relevant Skills and Experience VBA for Access

$20 USD / heure
(1 Évaluation)
2.3
ak10790

Hello Sir , I have completed M.C.A from Pune University. I have a working Experience of 5+  years in software and web development. I believe that my qualification and skills are best match for your requirements. Fol Plus

$16 USD / heure
(1 Évaluation)
0.4
$16 USD / heure
(0 Commentaires)
0.0
jrays1993

Hi I hope I can be of help with your project. I use a lot of SQL views in my personal projects. For me, it simplifies complex database needs. I tried to play your video but I think there is something wrong with the f Plus

$22 USD / heure
(0 Commentaires)
0.0
SolaceInfotech

Hi, Greetings!!! With reference to your requirement of SQL developer, I will be happy to help you by involving my small team of full stack developer. We personally have 7+ years of experience in different techno Plus

$22 USD / heure
(0 Commentaires)
0.0
$15 USD / heure
(0 Commentaires)
0.0
mountian1997

Hi, there! I saw your proposal. I am a full time developer and have high skills in web develop by PHP & SQLite so I can complete this project. My price and time is negotiable. Let's discuss details via chat. I'll Plus

$22 USD / heure
(0 Commentaires)
0.0
$24 USD / heure
(0 Commentaires)
0.0
senthilkavi

I have good knowledge to SQL Server Development and administration. I will give the priority to complete as per client expectation and time.

$16 USD / heure
(0 Commentaires)
0.0
kalajdzieskij

Dear Sir or Madam, I am a student from Macedonia in my end year with a 9.77/10 average of grades. I am studying in the top university in my country and have been awarded two times in a row for being the top 5 students Plus

$16 USD / heure
(0 Commentaires)
0.0
ellicecapade

I can prioritise this project if you need this asap. I am a lead database administrator. You can check my profile. Thank you for your time and consideration. I’m looking forward to hearing from you soon.

$17 USD / heure
(0 Commentaires)
0.0