Category Archives: Business Intelligence

Technology Disruption and the Illusion of Accuracy

RE: Paper vs. Technology We live in a time where change is the norm and technology is a part of our daily lives. The need to keep things “in sync” between devices, systems, processes and platforms is an ongoing challenge … Continue reading

Posted in Business Intelligence, Content Management, Information Architecture, User Adoption | Leave a comment

Simple No-Code Visual KPI Using A List Calculated Column

Products: SharePoint 2010, 2013 [Updates: Also works for 2013] There are numerous posts regarding calculated columns and the ability to display KPI images based on list values, etc.   Microsoft provides a reference to a list of the basic formulas that … Continue reading

Posted in Business Intelligence, KPI | 12 Comments

Quickly Display ERP Data in SharePoint

Products:  SharePoint 2007, 2010 I worked with a client this past week that needed critical data from their ERP System (Oracle) displayed within the context of their intranet site for broader visibility, consumption and analysis. Solution Options BCS (Business Connectivity ServicesMy first thought was … Continue reading

Posted in Business Intelligence, Excel, User Adoption | Leave a comment

Use Excel 2010 & SharePoint 2010 To Build An Interactive What-If Analysis Tool

Products:  Excel 2010, SharePoint 2010 The Challenge A client requested assistance in providing an interactive what-if analysis tool for their business users.   The tool consisted of a few variable fields and a final estimated cost field. The Environment The users had … Continue reading

Posted in Business Intelligence, Excel, SharePoint | Leave a comment

Big Data And The BI Paradigm

Company Focus:  EMC, GreenPlum, Information Builders, Hadoop, Microsoft, Oracle, Forrester Wave Update 02/07/13 Read Full Article on Hadoop Emerging as Dominant Big Data Analytics Platform Update 02/06/13 Remarkable Opportunities For Those Who Break Thru The Walls Read Full Article on … Continue reading

Posted in Big Data, Business Intelligence, User Adoption | 1 Comment

Chart Web Part Manipulation Of Genius

Tools:  SharePoint 2010, Chart Web Parts, Performance Point Update Best Practice is to use Performance Point Services for all your Dashboard Reporting Original Post I couldn’t wait to use the new Chart Web Part in SharePoint 2010 to solve a … Continue reading

Posted in Business Intelligence, SharePoint, Web Parts | 2 Comments