Power BI continues to Shock and Awe us all, month after month. In the December release of Power BI Desktop, I saw the GANTT chart and we had a use case to update task dates and descriptions on project plans for a client. Background After coming to America 3 years ago and learning DAX through Power Pivot Pro’s excellent intro to Tabular models, I met
Read MoreGame-Changing Planning and Forecasting with Power BI
Power BI keeps innovating. In November 2019 Microsoft released the long awaited Decomposition Tree. This enables companies to analyze, forecast and make predictions to support decision-making.
Read MoreState of the Art Report Writer in Power BI
Historically, BI Systems have lacked Financial Report Writers. Not anymore. Power ON’s Financial Report Writer is built around 4 concepts: · Row Definitions Define the lines and calculations in your report. Take advantage of advanced DAX Formulas or client side calculations · Column Definitions Users can define QTD, YTD, Monthly, Budget vs Actual, Actuals to Current data, and Forecast for the remainder of the year?
Read MoreAvanade and Power ON
at Microsoft Business Application Summit In today’s blogpost Ed Bobrin, Avanade Executive & Global Lead of Data & AI Center of Excellence, shares his experiences from the Microsoft Business Application Summit 2019. Along with all the AI and Machine Learning solutions that were launched, Ed discusses our Strategic Partnership and Power On’s place in the future of Power BI: ”Power On’s Visual Planner and Table
Read MoreOracle Essbase Hyperion–Writeback in Power BI
Instead of SmartView – Use Power BI Oracle Essbase – Hyperion is holding a 31% market share of a $2.4Bn market for CPM applications according to AppsRunTheWorld. The report is from 2017. Gartner has since then given up using the term CPM as companies are looking to combine BI, Budgeting and Planning in tools like Power BI. Power ON has now enabled this migration by
Read MoreOracle and Power BI Write-Back
Power ON is now supporting write-back from Power BI directly to an Oracle DB. The Table Editor custom visual has proven to be a powerful solution for companies that are deploying Power BI. Via the Visual Planning WebService, the table editor can now write to any Oracle database. Here is how it works: Create a Power BI Desktop Workbook by connecting it to the
Read More