Chapter 1. What Is BI and What Are BI Tools for Microsoft Dynamics GP?

There are many very good books on Business Intelligence (BI) that talk about the theory and importance of BI. There are also a lot of very good books that review how to use reporting tools with Microsoft Dynamics GP. However, we have not seen a book that cites specific examples of BI needs and GP tools, so we decided to write one and fill it with real world examples.

When we talk to GP users and to Microsoft Dynamics GP partners about their GP users, there is always one statement that rings true: I want BI, but I do not know what I want to see and how to see it.

In this book, we will review examples from real GP users, using most modules in Microsoft Dynamics GP. We'll briefly walk you through the process of how the BI needs were determined and how we selected which GP tool to use. We'll then recap the benefits obtained, frequency of use, and distribution methods for each example.

No worries if you are not a technical person. With GP and the tools being used in the following chapters, you will be able to replicate and repeat the steps in your software, using the Fabrikam sample data and then your own data. Each example will include a small section for technical matter, which includes items such as security, SQL views, and so on. This will enable you to enlist the support (if necessary) for a small portion, giving you full control of everything else.

Using these examples as a starting point will give you the experience to figure out what you need to see in your company. With each example, we'll throw in "extras" that cover some broad areas. BI reporting is one of those areas where starting can be hard, but once something exists, edits become much easier.

Building reports of all kinds, particularly those that make our customers prosper, is incredibly rewarding and fun. We hope you have fun improving your own business, using our words as your guide.