|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
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
– 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.