You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP
25 March 2013
Free GP Dashboard
The dashboard, and my presentations are all available on the front page at http://www.dynamicaccounting.net.
10 December 2012
27 November 2012
The Dynamics GP Blogster: Microsoft Dynamics GP Excel Dashboards
07 November 2012
Business Intelligence Investigation - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
25 September 2012
The State of Self-Service Reporting - The Microsoft MVP Award Program Blog - Site Home - MSDN Blogs
All of these apply to Dynamics GP and at I.B.I.S. we've used all of them with various clients (well, except for maybe Power View on Excel. 2013 since that technically hasn't been released yet. I'm playing with it for my next GP book).
Seriously, you need to read this.
01 August 2012
About Dynamics, Development and Life: Creating an Enterprise Data Warehouse (EDW) for Consolidated Business Intelligence (CBI) Series
08 May 2012
For Business Intelligence and Reporting, the Client is Excel | MSDynamicsWorld.com
My new article is up at MSDynamicsWorld.com and as far as I am concerned, For Business Intelligence and Reporting, the Client is Excel
01 March 2012
Winston-Salem SQL PASS Meeting « The Death of Reason
Dwight Specht spoke at the Winston-Salem SQL PASS Meeting.
Check out his post for the details.
29 February 2012
Why Do Agile BI? | DynamicsCare
Over at DynamicsCare Dwight Specht ask at Why Do Agile BI?
28 February 2012
Who Uses BI? « The Death of Reason
Dwight Specht asks Who Uses BI? To be perfectly clear, when Dwight says that he has met 1 stupid person in the last 10 years, he’s not talking about me.
11 July 2011
BI Focus 2011
If you have an interest in Business Intelligence with Dynamics GP or if you use FRx or Management Reporter you need to take a look at the BI FOCUS 2011 event from GPUG going on in Dallas in August.
This event is designed around getting the information you need out of Dynamics GP. There will be sessions on PowerPivot, FRx, Management Reporter, SSRS, Sharepoint and more.
Getting data in to Dynamics GP is great but the value comes with getting information out.
01 June 2011
Let’s Get FOCUSED on FRx & BI in Texas - Microsoft Dynamics Community
If you’re interested in BI check out GPUG’s BI event coming to Texas this summer. There’s more at Let’s Get FOCUSED on FRx & BI in Texas - GPUG Events & News.
31 May 2011
PragmaticWorks Webinar–Free SQL Training
PragmaticWorks is offering free SQL Server 2008 Business Intelligence.
It’s not strictly GP related but don’t pass up free BI training.
12 May 2011
Weekly Review: SQL Data Mining Add In.
Microsoft BI marches forward. The latest cool tool is also free. Microsoft has released its Data Mining Add In for SQL Server. While not necessarily GP specific it should work just fine against GP databases and cubes. I could spend a whole bunch of bits here telling you about it but why don't you just go here and see for your self how cool this is.
One caveat, this requires Office 2007 and SQL Server 2008 so some of you may not be ready for it yet.
Originally Posted by Mark at 5/18/2009 09:00:00 AM
05 April 2011
Slicing Dynamics GP 2010 Data in Microsoft Excel Dashboards
Over at the Dynamics GP Blog they’ve got a nice look at Slicing Dynamics GP 2010 Data in Microsoft Excel Dashboards.
This dovetails well with my upcoming Convergence presentation on Excel so if you want to see more stuff like this, come to my Convergence session!
10 March 2011
Dynamics GP - Learn & Discuss: Top 10 Challenges on Delivering BI to the Masses at Microsoft
Vaidy made it to Tech-Ed 2011 Middle East and has coverage of a session looking at the Top 10 Challenges on Delivering BI to the Masses at Microsoft
02 March 2011
Feature of the Day - Inside Microsoft Dynamics GP
With the upcoming release of GP 2010 R2, Inside Microsoft Dynamics GP is back with a new Feature of the Day. In this installment they look at some of the new Business Intelligence features coming in R2.

23 June 2010
One Version of the Truth
I’ve got a new article up on MSDynamicsWorld.com looking at reporting and business intelligence around Dynamics GP. It’s titled,
Does Microsoft Dynamics GP Deliver One Version of the Truth to Your Organization?
12 April 2010
Business Intelligence - Who Cares?
I think the number of people interest in BI is higher than his 2% estimate. Based on the interest we’re seeing in Analysis Cubes and Excel Reports the key to BI seems to be accessibility and ease of use. I expect PowerPivot and Excel 2010 to make BI even more accessible over the next year.
06 January 2010
OLAP PivotTable Extensions for Excel


