Power Query – Part 4

There has been a big push for self service business intelligence tools by Microsoft in recent months. The center of this new universe is Microsoft Excel. I will carry on with talks about Power Query which is a self service ETL add-in for MS Excel. This tool was released in August of 2013. In addition to my blog, the online help is a good place to start learning about this tool. Last time, I demonstrated how the “reduce” section of ribbon has buttons that can refine the number of rows…

Power Query – Part 3

There has been a big push for self service business intelligence tools by Microsoft in recent months. The center of this universe is Microsoft Excel. I will keep on going with talks about Power Query which is a self service ETL add-in for MS Excel. This tool was released in August of 2013. In addition to my blog, the online help is a good place to start learning about this tool. Last time, I demonstrated how the “get external data” and “excel data” ribbon buttons can be used to export…

Power Query – Part 2

In recent months, there has been a big push for self service business intelligence tools by Microsoft. The center of this universe is Microsoft Excel which is a common application used by the data analyst. Today, I will continue talking about Power Query which is a self service ETL tool. This tool was released in August of 2013. In addition to my blog, the online help is a good place to start learning about this tool. Last time, I showed you how to find an online data source, extract the…

Power Query – Part 1

In recent months, there has been a big push for self service business intelligence tools by Microsoft. The center of this universe is Microsoft Excel, a common application used by the typical data analyst. The following four products started off as add-ins for Excel. Now, some of them are a integral part of MS Office 2013. Power Query Power Pivot Power View Power Map It is not surprising that these four business intelligence products have an offering in Office 365. I really like office 365 as a platform to share…