Tag: Business Intelligence

Microsoft’s Master Data Management as a system?

, ,
Master Data Management (MDM) is important because dirty data means poor adoption, poor decisions and poor BI, but to think of it as a separate system is very difficult.[quote align=”right” color=”#999999″]Imagine SAP having to accept…

How to Install Pubs Database in SQL Server 2012 in 1 query

, ,
Upon request I published how to install Pubs database for SQL Server 2012. Several have had trouble attaching it following the guide for How to install Northwind for SQL Server 2012. One can download Northwind and Pubs here: http://www.microsoft.com/en-us/download/details.aspx?id=23654 where…

Stock out counts and other inventory balances

, ,
A client recently asked why their measure for Zero Inventory Counts (stock out counts) was running long, and you’d think getting a list of times you didn’t have inventory would be easy. Except, it depends on how you are figuring that out.…

Identifying Product Line Profitability through Landed Cost Analysis

, ,
Edit: The webinar is closed for registration (February 5th 2013) Establishing landed costs for the products that a company handles can be a tricky business. There are freight costs, but they are not generally by SKU. There is trade promotional…

SQL Server 2012 SP1 is out!

, ,
To all Business Impact Clients: Microsoft released on the 19th November, the first Service Pack (SP1) for SQL Server 2012. One can find the list of fixes in their support article: http://support.microsoft.com/kb/2674319 and read more about…