Tag: Power Query

Power BI- Empower the User Conference Recap

This year at KTL’s empower the User Conference one of the hottest topics was Microsoft’s Power BI. No surprise here after it was one of the most popular categories at Microsoft Dynamic’s Convergence back in March. 

For those who haven’t heard of Power BI before here is a short synopsis. Power BI is an excel add-in tool made up of 4 components: Power Pivot, Power Query, Power View, and Power Map. Power Pivot and Query are used for data preparation while power view and map are used for data visualization. These tools can take large amounts of data from virtually any system and harness it for real-time, powerful analytics. One of the huge differentiators of Power BI from other analytics tools is that you can combine resources from multiple data centers. Typically, when people want to see the profitability of an organization they look at the financial data. However, this is not always the only factor, especially in today’s world that is driven by technology and social media. 

Read More »
July 2, 2015

Part 5 of 5: Power BI, Sharing the Wealth

We have put a lot of hard work into this blog series with building a patron analysis so now it’s time to share the wealth of our analysis insights with the rest of the company.  Power BI’s web site and mobile approach with the deployment of Office 365 and refreshable data through a Data Management Gateway, is the perfect solution.  The Data Management Gateway has come a long way since the first version and with version 1.2 it now supports many data source types from Power Query connections.

Read More »
October 24, 2014

Power Query–The Heavyweight Champ of Power BI

What is Power Query? Power Query is a self-service data extraction tool that is a free add-in for Excel 2010 or higher. It allows users that are already comfortable with Excel a smaller learning curve to start enjoying Power Query. Power Query has a vast array of options that it can use as data sources…

Read More »
July 22, 2014