How To Extend Power BI’s Functionality

Did you ever want to take Power BI (Business Intelligence) to the next level and have it go beyond just a dashboard and report? How about refreshing your Power BI data model and publishing to a network file share? What about using Power BI for budgeting, planning, and forecasting?

Well, now you can with Power ON BI! Power ON BI offers the following application:

1. Power Update

   1. With Power Update, it automates Power Query refreshes and publishes Excel and Power BI Desktop workbooks to:
      1. SharePoint
      2. OneDrive
      3. File Share
      4. Power BI service

2. Power Planner

   1. With Power Planner, you can build a SSAS Tabular or Power Pivot model in Excel and use Power Planner to combine the best visualization tool in the marketplace with excellent spreading, goal seeking, in-cell calculations, and top-down and bottom-up budgeting.

3. Power BI Visual Planning

   1. With Visual Planning, you can now edit data in a dashboard or report. Users may add and change numbers and comments, observe the visualization updates, and save those changes back to the data repository. Visual Planning does this while respecting Role Based Security.Visual Planner includes the following functionality:
      1. Table Editor
      2. Budgeting
      3. Line Item Detail with Budgets
      4. Master Data Management
      5. Predictions – with Azure Machine Learning and ‘R’

Visit Power ON BI today to see all of their great applications and features in more detail.  Stay tuned for additional Power BI posts that will help your company become a data-driven organization.

BARRY CROWELL, MBA | BI/EDW Solution Architect

Barry is a Microsoft SQL Certified Professional with a strong knowledge of the Microsoft’s BI Stack (SSIS, SSRS, SSAS and Power BI). He has architected, developed and deployed clients’ Business Intelligence needs using Microsoft’s BI Stack and/or Solver’s BI360.  His solutions have included SSIS ETL tools, SSRS reports and dashboards, Excel dashboards, Power BI reports and dashboards, and SSAS cubes. He has performed implementations as the lead consultant and/or end-user project manager. Barry has over 20 years of experience working in accounting and the Microsoft Dynamics GP industry, and in various industries such as housing authorities, universities, Tribal governments, and casino hospitality. He possesses a Bachelor’s Degree in Accounting and Business Administration from Black Hills State University and a Master’s in Business Administration from La Salle University.  Barry’s experience in both the IT consultant field and experience as an accountant gives him the ability to understand the issues from both the IT and Finance prospective, and provide a solution that fits the needs for all parties involved.