Power BI has been around for a while, but it’s recently received more development attention and has become a decent reporting tool for small and mid-sized organizations. Power BI lets you easily assemble informational dashboards that can be viewed in browsers and mobile devices.
The pricing is simple and inexpensive: https://powerbi.microsoft.com/en-us/pricing/
Power BI is essentially a web application that allows you to connect to data within your organization, create graphical reports, and distribute to users.
OFFER: If you send me your corporate email address, I’ll send you a link to these dashboards so you can see how they operate. You will need to sign up for a Power BI login. It’s free, and easy to do. Send me an email here: firstname.lastname@example.org
The Power BI Desktop tool allows you to create the reports and connect to the data. The power BI web portal allows you to distribute the reports by sharing them with users you select.
There are a variety of data connectors that you can use to get data:
For my example I connected to SQL Server Analysis Cubes that are part of the Dynamics GP solution.
This is the Power BI Desktop where you get your data, create your report, and publish to the Power BI web portal. You can see the fields I selected to use from my SQl Server Analysis cube, and the various graph formats you have available:
Once you complete the reports and group them together for a dashboard, you publish them to the Power BI web portal. You can further arrange them in the web portal to get the results you want. You can then share the dashboards with others.
There are apps for IOS and Android devices that allow you to easily view these on mobile devices.
Here’s a dashboard that has three graphs. These three graphs are interrelated so that a user can interact with the dashboard.
If the user selects one customer, or state, or product, the other two graphs change to fit that selection:
Here’s a dashboard I created to show well on a mobile device. On an iPhone, these three graphs stack up vertically:
This is a screen shot of this dashboard on my iPhone:
The information on these reports is easily updated. You can manually do it in Power BI Desktop, or select the “Connect live” option when you get the data from SQL Server, and the data will be refreshed when the users requests it.
You should also check out Fredrik Hedenström’s post here. This link give you immediate access to an Power BI report.