- October 5, 2017
- Posted by: Gerard
- Category: PBCS, PowerBI
Why is PBCS and Power BI such a good match?
Primarily because the strength of one is the weakness of the other.
What are the strengths of PBCS?
- Create budgets and forecasts
- Functionality to write data back to system
- Create workflow and approvals process
- Add line item details and notes
- Drill thru ability to ERP Ledgers
What are the strengths of Power BI?
- Create excellent data visualizations and dashboards
- Integrate financial and non-financial data into dashboards
- Ability to load both numerical and text based data
- Affordable solution providing excellent return on investment
- Development is agile and fast
What do PBCS and Power BI have in common?
- Both are cloud based
- Both can load data from many different sources
- Both can produce highly formatted tabular reports
- Both have excellent Excel integration
- Both are attached to major companies and they are investing heavily in the technologies
- PBCS = Oracle
- Power BI = Microsoft
The combination of PBCS and Power BI is explosive. Use PBCS as the foundation of the Budgeting and Forecasting process. It’s ability to easily generate driver based budgets and forecasts are its core strength. Perform complex calculations and currency conversions in PBCS as well.
Use Power BI to create insightful visualizations and dashboards based off the data from PBCS. There are a number of ways to extract the data from PBCS. To start simply use SmartView in Excel to extract the data in a tabular format. Then you can load this data to the Power BI desktop for dashboard creation and publishing. This is a very quick and easy way to get started with PBCS and Power BI.
However, you may want to create a more systematic and robust approach. You can export out the data and dimensions from PBCS and load to a Star Schema. The Star Schema can then be used by Power BI to create any number of Dashboards and Reports. You can also use the Star Schema and build a Tabular Analysis Services application. Power BI and Excel can report directly off the Analysis Services application.
There are many options available in terms of solution design with PBCS and Power BI.
If you want to be a Finance Rockstar utilizing PBCS and Power BI together is definitely the way to go.
Download information in a neat 1 page PDF → PBCS and Power BI – A Perfect Match
Example of Extracting Data from PBCS Via SmartView and loading into Power BI
The data was extracted from the sample Vision database that comes with PBCS.
Step 1: Extract the data from PBCS using SmartView. In this case I extracted the data in tabular format.
Step 2: Check Data: After Loading the data into Power BI compare Net Revenue by Sales Region to ensure data got loaded correctly.
Total Revenue in Essbase = 358,411,771
Total Revenue in Power BI = 358,411,771
Step 3: The final result is below. By the way this report has been embedded and is fully interactive. Please try it out!
This report can also be accessed from here.
Just one final point. The reports can be created on an Ad Hoc basis such as above. Also they can be fully automated by extracting all the data from Essbase and loading it into a star schema. This data load could be scheduled to run at any time such as overnight or regular intervals during the day. The big advantage of this approach is that all the Essbase data is exposed to Power BI and dashboards can be created as required without having to extract another data set.
The combination of the Oracle EPM Suite and the Microsoft BI Stack is very powerful. These technologies enable any finance department to transform fully into cloud based solutions.
If you have any questions please contact us at email@example.com