Find Jobs
Hire Freelancers

Need a SSRS expert to help me set up some automated reporting and serve as a general backup for our data warehousing needs

$15-25 USD / hour

Lukket
Slået op cirka 5 år siden

$15-25 USD / hour

TLDR - if you have proven skill in SSRS, verifiable references and a strong profile on this or any other site that shows that you are a reputable contractor, please send me your information. |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| Longer version - we have successfully stood up a SQL Server (Standard license) database that replicates data from QuickBooks Enterprise via CData Sync. I am personally very proficient at writing queries, however have no experience with stored procedures or SSRS reporting. My objectives are as follows: i) Set up daily reports of aged invoices to be delivered to e-mail inboxes of specific people (6-8 of these). I will write the queries, need YOU to set up the SSRS flow and delivery. I am also interested in learning how this works so that I can improve my own skills, but do not have time to get the knowledge myself right now. ii) Help me connect a trial balance extract by month to Excel and/or Power BI in order to be able to quickly refresh my financial reporting package. iii) Help me implement best practices for our data warehouse, move towards implementing a datamart that aggregates pertinent records from 6-8 current and legacy QuickBooks files and stands ready to absorb new data from incoming acquisitions.
Projekt-ID: 18865212

Om projektet

7 forslag
Projekt på afstand
Aktiv 5 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
7 freelancere byder i gennemsnit $24 USD/time på dette job
Brug Avatar.
Hi, I am Nallakumar. I have more than 12 years of experience in SSRS reports. Please have a look at my past project review to validate the same. I don't have PowerBI experience, but I can generate Excel file using SSRS reports itself. I am ready for discussion and take it from there. Thanks, Nalla
$24 USD på 40 dage
5,0 (59 anmeldelser)
7,1
7,1
Brug Avatar.
Hi - I see that you have posted this requirement in multiple freelancing sites, so i thought i'll jump in and give my views on it. SSRS goes hand in hand with SSAS where you define cubes on your data warehouse. The datawarehouse follows a star schema (my personal favourite against snow flakes) to which data is extracted from a OLTP data structure (quickbooks in your case). While OLTP may have lot of referential integrity OLAP will not have it as write operations aren't performed. This will improve the performance. To move data from OLTP to OLAP you may use SQL, however to query data to pull reports in SSRS there is a query language called MDX. Unlike SQL which queries 2D data, MDX can query multi dimensional data represented by a star schema. I would suggest we could discuss in business terms and have a meaningful dialogue on this topic and see how we can take it forward. Gana
$24 USD på 40 dage
4,9 (11 anmeldelser)
3,9
3,9
Brug Avatar.
Hi As far as I understand you not only need a person who does fine reports in SSRS but a person who can work with SQL Server and SSIS to integrate your data to excel and Power BI. I can also help you if you want to improve your skills in SSRS and SSIS. Thanks for your attention Archil
$22 USD på 40 dage
5,0 (3 anmeldelser)
2,3
2,3
Brug Avatar.
Hi, I have 2 years experience with SSRS, interested to work on this project. Looking forward to work with you, Regards
$22 USD på 20 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
Dear Sir, Based on My past working experience , I have done exactly same projects like this, using building reports on SSRS and set distribution automatically by email with attached PDF. we can do out of box function or develop our own distribution flow solution by using C#. I also very good at develop Power BI or Power BI working with SSAS tabular mode to create data mart. looking forward to working with you . Bruce
$27 USD på 40 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for UNITED STATES
Charleston, United States
0,0
0
Betalingsmetode verificeret
Medlem siden feb. 5, 2013

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.