Pragmatic Works

 PW is a team of dedicated and passionate SQL Server and BI professionals on a mission to help developers and DBAs operate more efficiently through our innovative products, solutions and training for data platforms. We offer software that simplifies the development and management of SQL Server, and we deliver top-tier SQL Server training offerings and[…]

Oracle 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[…]

Write-back Options in Power BI

Early January 2018, Microsoft launched a new custom visual that enables users to enter data in Power BI. Basically, the custom visual opens up a Power Apps solution, checks permission for the end-user, and let end-users add, modify and delete data directly in the SQL Database. Now there are multiple ways to let end-users analyze[…]

Planning Process and Solutions are in Transition

Budget Once – Forecast Forever Power BI provides unparalleled ability to analyze your data, uncover potentials and reveal problems. Exactly what you need when creating budgets or doing forecasting. Why is it that traditional BI solutions do not have forecasting capabilities, except IBM Planning Analytics? IBM just combined Cognos and Watson to enable customers to[…]

Visual Planning Webinar with Pragmatic Works

   Please view the webinar we developed together with our strategic partner, Pragmatic Works.Per Solli presents write-back in Power BI with Matrix, Table Editor, Workflow, full Security Models, Commenting and Sub-Reporting and Pop-Up. Visual Planning is turning Power BI into a fully fledged Planning solution for the Enterprise. Corporate Performance Management in a new dimension.[…]

Power BI on LOCALHOST

SERIOUSLY. Power BI now runs stand-alone on a laptop. Power ON’s Integrated Business Suite is running on localhost, disconnected from the internet. What this means for business users is that Power BI can run inside the corporate Firewall. “You will also be able to confidently scale to thousands of users, because Power BI Report Server[…]

Visual Planning for Power BI on both Cloud and On-Premises

Microsoft just made available today, what is expected to be the final preview of Power BI Report Server before launch. ”When you buy Power BI Premium, your subscription includes capacity in the cloud for the Power BI service as well as a license to run Power BI Report Server in your own on-premises capacity. If[…]

Consolidation and Inter-Company Reconciliation with Excel or Power Planner

If you want to move away form your current over-priced, outdated CPM solutions, Power BI and Power Pivot is here to help. Additionally if you add Power Planner to the mix, you can enable the Corporate Performance Management data in a completely different light: Powered by: Step 1: Create a data model: (No Worries, it’s[…]