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
已关闭
已发布大约 5 年前
$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.
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
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
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
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