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.
Anyone who’s in software development, and works directly with business users, knows that no matter how much things change, one rule remains: You never get credit for what’s hard. You may, however, get credit for what’s pretty. In that spirit, I’m going to write a few posts on making things prettier in SSRS. And today, I’m going to discuss conditional formatting. By conditional formatting, I basically mean making things turn red when there’s a problem. I’m not talking about fancy charts. I’m...Read more
In an earlier couple of posts, I had described three critical elements of SQL Server security: pieces, people and permissions. For a non-technical person (such as, perhaps, an auditor) to understand SQL Server security, they need to have a grasp of all three elements. You can read more about the four pieces of SQL Server as well as the different types of people (i.e. logins). In this post, I’m going to cover the third essential element: Permissions. Part III: Permissions Now we have the pieces...Read more
In an earlier post, I explained three essential elements of SQL Server security: pieces, people and permissions. Your auditor (or any other non-technical person) will need to have an understanding of all three parts to understand how security works in SQL Server. In this post, I’m going to explain the second element: People. Part II: The People While a database with no access would be secure, it wouldn’t be all that useful. So how do we tell SQL Server who gets access to the system? We start at...Read more