by Gil Raviv | Apr 9, 2018 | Book, Popular
The draft of my book is almost ready (I even have few Excel formulas that are showing me, that I have already wrote 93% of the books, and a total of 359 draft pages so far). This weekend, after finishing 44 pages on M, I wanted to share with you, in this post, a...
by Gil Raviv | Feb 7, 2018 | Book, Popular
Today I am excited to share a second excerpt from the draft manuscript of my book. Today’s excerpt is the first part of chapter 11, which discusses basic text analytics, and a cool technique to detect multiple keywords in textual feeds using Cartesian Product....
by Gil Raviv | Jan 4, 2018 | Popular
Many people will say that 2017 was the year of the Bitcoin. Whether you have invested in cryptocurrency or not, here is your best Power BI tool to play with different What-If scenarios. Select the initial invested amount, set the buy and sell dates, and enter the time...
by Gil Raviv | Sep 26, 2017 | Popular
Follow @gilra Last week, Microsoft moved Office Store to App Source. As a result, all of the custom visuals of Power BI are now available in the new site. As promised here, today I will share the main query (M code) that I used to web-scrap AppSource website. You can...
by Gil Raviv | Aug 10, 2017 | Popular
As a follow-up for the tutorial here, in today’s blog post, we will show you how to use an improved version of the Table Comparison implementation, and apply a comparison of rows with matching keys. The solution can be used for many purposes: Audit repetitive...
by Gil Raviv | Jul 7, 2017 | Popular
In today’s post, we will go over Tableau’s last four claims against Power BI (as was published by Tableau here), and we will demystify them. If you missed the last episode, go here, to learn the first 4 Ways Power BI Falls Short – Or Not. If you are...
