Red Three specializes in BI and Data Integration for Finance and Accounting with Microsoft Technologies. See How We're Different.

Contact Us:

917.848.7284

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 Finance and Accounting Expertise Project Management Microsoft SQL Server and BI .................... We focus on the Microsoft Business Intelligence Stack to get the information you need out of your data. Read more Finance and Accounting Expertise .................... Our deep knowledge of complex accounting creates the reports you need from the software you already have. Read more Project Management .................... We eliminate accounting, procurement and supply chain issues to improve back office systems. Read more

Microsoft SQL Server and BI

We focus on the Microsoft Business Intelligence Stack to get the information you need out of your data.

Read more

Finance and Accounting Expertise

Our deep knowledge of complex accounting creates the reports you need from the software you already have.

Read more

Project Management

We eliminate accounting, procurement and supply chain issues to improve back office systems.

Read more

7 Steps to Better Financial Reporting
7 Keys to Cost Effective Business Intelligence

RECENT POSTS

SSRS Consultant Tip: Stored Procedures vs. Views for SSRS Reports

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

SSRS Consultant Tip: Keep Your SQL in Your Database

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

SSRS Consultant Tip: What SSRS Does Well (And What It Doesn’t)

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