Goals for Our Power BI Dashboard
We knew where we wanted to go, but how should we get there? In choosing an approach, we had a few goals in mind:
- Quick and easy way to update report data
- A way to easily report on specific time periods e.g. Fiscal YTD, Last Two Weeks, etc.
- A way to create graphs for trend analysis
- Mobile access for reports
In considering the goals, we decided this was a good opportunity to explore Microsoft’s Power BI offering in a real-use scenario. This particular project was also a proof of concept, taking an iterative approach to see what was possible, and improving upon it with as time permits between client commitments.
The current experience is enabled using Office 365, with Power BI Sites that reside in your organization’s SharePoint deployment. It includes many features that let you share your findings and your reports with others inside your organization.
The new experience is centered on PowerBI.com, a preview release of an online service where you can quickly create dashboards, share reports, and directly connect to data. The new experience also introduces the Power BI Designer, a dedicated report authoring tool that enables you to transform data, create powerful reports and visualizations, and publish to the PowerBI.com service. It also extends to all your mobile devices with dedicated viewer apps.
Given the set of available Power BI tools, we decided to use Excel as our starting point. The plan:
- Pull the data in with Power Query
- Model the data in Power Pivot (also called the Excel Data Model)
- Create pivot tables and charts in Excel connecting to data model
- Host the file in in our Office 365 SharePoint for distribution & consumption
This blog series will include a different post for each step of the plan.
What’s Up Next?
Next, we’ll show you just how to get the data with Power Query.
Follow us here to see more: