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

已关闭
已发布大约 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.
项目 ID: 18865212

关于此项目

7提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
7威客以平均价$24 USD/小时来参与此工作竞价
用户头像
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 在40天之内
5.0 (59条评论)
7.1
7.1
用户头像
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 在40天之内
4.9 (11条评论)
3.9
3.9
用户头像
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 在40天之内
5.0 (3条评论)
2.3
2.3
用户头像
Hi, I have 2 years experience with SSRS, interested to work on this project. Looking forward to work with you, Regards
$22 USD 在20天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在40天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Charleston, United States
0.0
0
付款方式已验证
会员自2月 5, 2013起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。