by Melissa Coates | Dec 30, 2016 | SQL Chick
This is part 3 of a discussion about a new service in Microsoft Azure: Azure Analysis Services. Azure AS is a Platform-as-a-Service (PaaS) offering which is in public preview mode (as of December 2016). Part 1: Why a Semantic Layer Like Azure Analysis Services is...
by Gil Raviv | Dec 27, 2016 | Data Chant
As promised here, in today’s post I am sharing an Excel template that analyzes Salesforce Opportunities, and allows you, with a single click of Refresh All in Excel’s Data tab, to get the latest data from Salesforce and auto-populate it into the report. You can...
by Gil Raviv | Dec 23, 2016 | Data Chant
In today’s blog post I would like to share with you a new bug, that I recently found in Power Query. It is relevant for all versions of Excel, Power Query and Power BI Desktop November Update 2016. As some of you are not in the mood to chase some bugs (Happy...
by Gil Raviv | Dec 20, 2016 | Data Chant
A Power Query Mystery I recently stumbled upon a mysterious Power Query behavior. A Power Query query was pulling data from an external Excel workbook that was hosted on a corporate Intranet. The data included exchange rate numbers which were updated on a daily basis....
by Gil Raviv | Dec 14, 2016 | Data Chant
As a special gift to you for the coming holidays, I am about to share a FREE Excel template that analyzes Salesforce opportunities. While the template is going to be available to all readers by end of 2016, you can be to first to try it, by subscribing to my blog....