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

Understanding the NAV Database, Part 2—Fields in NAV That Aren’t in SQL Server

In May, I’m presenting at the NAVUG Focus conference on the topic of “BFFs with SSRS.” (Not a title I chose. Please.) In preparation, I’ve been doing more work on the database, and I thought it worth writing up some of my findings. In this post, I’m going to review three fields that are in the NAV table but aren’t (or aren’t obviously) in SQL Server: Option fields Flow filter fields (FlowFilter) Sum index fields (SumIndexFields). If you’re new to NAV, you should start with my Understanding the...Read more

Azure SQL Database vs. SQL Server on an Azure Virtual Machine

I’m working on my first paid project using Azure. Previously, I’d set up test databases in Azure but nothing focuses the mind like having to get something working for a real client. I am hardly an Azure expert, but most of my clients are interested in or using some sort of cloud application, of which Azure SQL database is one. So, part of my motivation for writing this post is to get my thoughts clear. Why Azure SQL Database Should Work for Me and My Clients In the SQL server universe, I spend...Read more

3 Rules Nonprofits Should Follow When Approving Budgets

As a consultant, I’ve spent many hours on the technical aspects of budgeting. I’ve designed models, developed spreadsheets, downloaded and uploaded data, and of course, written lots of financial statements. I’ve also budgeted for my own business as well as other companies where I’ve worked. So, I know something about budgets. But, recently, in my volunteer position as treasurer of my local Y, I’ve been thinking about how a nonprofit board should approve a budget. The challenge of any nonprofit...Read more