Friday January 11, 2019
This week I interviewed Lawrence Coffee and Mike Lovelace at the Aventine Hill office in San Antonio both of whom introduced Power BI – an impactful tool to visualize the metrics that drive your organizations strategic objectives. Lawrence is the Senior Manger of Business Intelligence (BI) and Mike, as a CFO advisor provides executive advisory services for needs surrounding the Chief Financial Officer position.
Where does your organization fall in the BI and Data Analytics maturity progression? In our interview, this maturity progression was likened by Mike to the human process of crawl, stagger, walk, and finally run. In the beginning your organization is focused on what happened and why did it happen. According to Lawrence, these are forms of descriptive and diagnostic analytics, though commonly known as BI. As organizations mature – they will start focusing on what will happen, which is Predictive analytics, though frequently referred to as Advanced Analytics or Data Analytics. Further along in the maturity cycle organizations begin to focus on ways to make it happen, which is known as Prescriptive analytics, or AI.
Power BI is a Microsoft product, which was originally bundled with SQL Server 2012 as a more advanced BI visualization tool for SQL Server data. In 2013 it was launched as an Excel add-on in September 2013. In July 2015 a stand-alone product ‘Power BI’ was launched by Microsoft – built off the prior Excel add-ons Power Query, Power Pivot and Power view. The tool is powerful data visualizations platform for all your organizations metrics. This product enables you to create interactive dashboards, reports and alerting capabilities, which can be consumed on any device (Desktop, tablets and mobile phones). You can ‘Slice’ data to filter the view of your report. This and other interactive features provides real-time monitoring capabilities of your organizations performance to get ahead of issues and/ or your competition. Spot trends on the fly and identify issues or opportunities before impact.
Both mentioned the Gartner magic quadrant report, which reminded me of Kaplan's Balanced Scorecard. The Balanced Scorecard shows four dimensions of firm success in different areas. Likewise, the Gartner quadrant shows multiple measures on the same page. The three current magic quadrant leaders for Business Intelligence tools are Tableau, Power BI and Qlikview. Amazingly, though Power BI was just launched in 2015, according to research by Robert Walters it enjoys a 51% share of the market as compared to Tableau’s 20% and Qlikview’s 14%. Oracle and SAP have in house products performing similar functions and have a combined 15% share.
Given any data set one might then say that Power BI allows one to extract, transform, and then load (ETL) your data into a more automated manner, which allows you to keep your data refreshed on a cadence you need to get the data when and where you need it.
In summary, Power BI displays Key Performance Indicators (KPI) in ways not easily possible prior to this software. This is important, as accountants seek ways to better turn data into information for their audience. Of note, the price of Power BI is markedly lower as compared to the older BI platforms is competes with.
Lawrence and Mike joined me in this audio summary of our discussion.
Power BI is all about data visualization. It produces dashboards and metrics by translating data into easy to understand information.

190109_0057S12
Extra Bonus
Check out this article by Lawrence on Creating a Dashboard in Power Point