Business Intelligence Consultant for Your Complex Data
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.
Get Custom Operational & Financial Reports
Do you have the information you need to run your business and understand what contributes to the bottom line?
Data sits on all kinds of systems. Ready to get your data clean and manageable?
Leverage Microsoft Technologies
Are you maximizing the power of your current platform? Create the reports you need from the systems you already have.
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
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
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