Red Three helps clients maximize the power of their current enterprise software to improve business intelligence. We specialize in enabling companies to get more from their current software without the hassle of long, drawn out “consulting” practices.
Unlike many independent consulting companies, our deep knowledge of accounting data, experience in multiple packages and practical, organized approach solves complex data and reporting needs. Our goal is to help you extract the right information from your financial systems and get the reports you need to make smarter business decisions from the software you’ve already invested in.
Microsoft SQL Server and BI
We focus on the Microsoft Business Intelligence Stack to get the information you need out of your data.
Finance and Accounting Expertise
Our deep knowledge of complex accounting creates the reports you need from the software you already have.
We eliminate accounting, procurement and supply chain issues to improve back office systems.
I hope I’ve convinced you in my previous post to develop and store your SQL on the database and my rationale for that argument. The next question is how to create and keep this code on the server. You have lots of options, such as views, stored procedures, functions, simple data marts and even SSAS. In this analysis, I’m going to focus on views and stored procedures. That’s where I spend most of my time and is most relevant for “next level” super users. Generally, I like to start with...Read more
As I started this series, I emphasized the importance of using SSRS for what it does best, not for everything it can do. I ended the post by noting the importance of having someone on your team with knowledge of T-SQL and access to the database. Whenever I make this point, whether in presentations or with colleagues, they ask me to back up my argument. So let me lay it out for you here: 1. You can’t assume that SSRS will be your only reporting tool Over the years, many IT shops have tried to...Read more
I recently presented on SSRS at the NAV Focus Conference in St. Louis. As often happens at these events, I wasn’t exactly sure who was going to show up and what they would already know. (Especially at an event like this, which had a development track but with no specified levels.) In any case, it became clear to me that many folks in the audience could benefit from a series of posts aimed at a “SSRS 102” level. They’ve mastered “SSRS 101” material—they can create a basic report and know what...Read more