by: Sheri Blaho
Val Steed with K2 Enterprises shared a great session about Power BI (Business Intelligence) at the OSCPA Technology Conference. This tool is a little involved and will take some learning, but it is worth it. You can take a simple sales table in Excel, you can use conditional formatting to see top 10 and bottom 10 performers with a simple command…and it will change dynamically. This is a form of visual business intelligence.
PowerPivot is a tool of Power BI It will let you create data models and visualizations. Not all versions of Excel will work with Power BI. If you are already running Office 365 ProPlus or Office 2013 Professional Plus you can purchase Power BI for $17.99. However with PowerPivot you can also attach to any ODBC data sources. That combination is what makes Power BI so appealing. It can already pull data from a wide range of cloud services, including MailChimp, Zendesk, Salesforce, QuickBooks, Twilio, GitHub, Uservoice and even Google Analytics. Sage and Adobe Analytics are coming soon, and there’s a long list of others on the way.
Ultimately the inquiry tools with Power BI will allow you to state your inquiries with English language rather than formula selection criteria. The future is here now.