Power Query

Profitability and cost management requires data from multiple different sources and systems both financial and operational. Magic Orange utilizes Microsoft Power Query to retrieve data in a highly automated and scalable fashion. As part of our vision we empower our clients, by enabling them to leverage the skills gained from utilizing the Microsoft tools to increase their effectiveness. With Power Query requiring no coding, it forms an excellent means for our clients to transform and manage their data without the need for technical resources.

Power Query is a data connection technology that enables you to discover, connect, combine, and refine data sources to meet your analysis needs. Features in Power Query are available in Excel and Power BI Desktop. With Power Query you can research for data sources, make connections, and then shape that data (remove a column, change a data type, merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports.


Microsoft South Africa

3012 William Nicol Drive



+27 11 361 9000