Business Intelligence Consultant for Your Complex Data

Contact Us:

917.848.7284

Red Three helps clients maximize the power of their current enterprise software to improve business intelligence. We provide custom data integration and reporting capabilities so you can extract the right information from your financial systems and make smarter business decisions. Our goal is to help you get the reports you need from the software you’ve already invested in.

Improve Business Intelligence

 

How financially aware is your business? Bridge the gap between IT and finance to make smarter decisions.

Learn More

Get Custom Operational & Financial Reports

Do you have the information you need to run your business and understand what contributes to the bottom line

 

Learn More

Integrate 
Complex Data

 

Data sits on all kinds of systems. Ready to get your data clean and manageable?

Learn More

Leverage Microsoft Technologies

 

Are you maximizing the power of your current platform?  Create the reports you need from the systems you already have.

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

RECENT POSTS

ERP Implementations: 9 Months of PowerPoint; 3 Months of Panic

I once ran a 30-person team that did nothing but software implementations. Happily, software implementations haven’t been my bread and butter for some time. (It’s a lot of effort and stress). But I had a good track record in this area, and I have some proven ideas about how things should be done. Most of it boils down to one key rule: One hour of entry on the system is worth 20 hours of talking in a conference room. (Although your mileage may vary.) Even with the many failed projects in the ERP...Read more

SQL for Super Users Part 7: Date vs. Date-Time

If you haven’t read all the other parts in this series, you’ll want to start with the introductory post. I was initially unsure whether to include the topic of dates and date times in an introductory series. It tends to confuse the heck out of people. But given how often mistakes are made, it’s an important topic. So let’s give it a go. We’ll start with an example. Let’s go back to the Order table: You’ll notice the OrderDate column has more than just dates—it also has times. (I find this...Read more

SQL for Super Users Part 6: Aggregates and Having vs. Where

New to this series? Start with our intro post. So far in this series, every query we’ve built has returned details, i.e. one row of output for every row selected in the database. But sometimes, we want totals only, not details. Or maybe we want the biggest (maximum) or smallest (minimum) value of a column from the rows selected. These are called aggregates. The Ins and Outs of Aggregates In this post, we’ll focus on the “SUM” aggregate, which is just like SUM in Excel. It delivers the...Read more