powerplanning

Take advantage of Excel Power Pivot and enable write-back to your data warehouse


1 Comment

Power Query is Awesome, but…..

With Microsoft’s focus on Business Intelligence in Excel and with Power BI Designer(www.powerbi.com), the most powerful tool in the toolshed that sets PowerBI aside from competition is Power Query.

It can read data from virtually anywhere. From structured data sources like SQL Server, SSAS, Oracle, MySQL, Access, Oracle and DB2 to JSON/Odata, Facebook, SalesForce, CSV, Excel and Active Directory. It can also read whole folders of files, like a hive.

Power Query is more than a query tool, it’s a fully fledged ELT(popular version of ETL) tool. You can Extract, Load then Transform to Power Pivot, and even to a SQL Server with an Excel Add-in. This is extremely powerful in enabling self service BI.

However, there is no way to schedule Power Query in an efficient way; you currently have to manually kick off the jobs.

But Wait – There is a solution!!! Power Update from the PowerPivotPro team enables you to schedule Power Query Excel Workbooks. Download a free version of this popular tool.

This blog article from Rob Collie explains how it works.

Check it out.

Excel – Power Query and Power Update

image

   
Advertisements


2 Comments

Enable write-back on any Pivot Table with Power Plannner

Any Pivot Table you can now turn into a Budgeting, Forecasting or Planning solution!

    Get Started:

  • Install Power Planner
  • Enable Cell Editing in the Pivot Table
  • Budget and Forecast on any new or existing model

image

Enjoy Features:

– Multi User Budgeting and Forecasting Features

– Goal Seeking on any number

– Even and Seasonal Allocations

– Revenue Forecasting

– HR Budgeting

– Capital Expenditure

– Driver based planning

– Collaboration and commenting

Go to our website for more information.