Chips, as healthy as raw cashews – NutriScore & the implications of single indicators

Universal color schema & data visualization My son Leon, age 5, knows that in the grocery shop some cereals can have a "grade" - from letter A (green) to letter E (red) - and he knows that green is good and red is bad. This exists in some European countries and it is called NutriScore. … Continue reading Chips, as healthy as raw cashews – NutriScore & the implications of single indicators

What are translation tables in Power Query’s Fuzzy Match and why would we need them?

In Power Query, we have the option to use Fuzzy Match when merging tables. A little known feature are the Translation Tables which help in that process. Merging tables is relatively straightforward in Power Query - choose the left table, choose the right table, mark the columns for the merge to be made onto, choose … Continue reading What are translation tables in Power Query’s Fuzzy Match and why would we need them?

Протеини, който не яде… той данни не ще да събере (или за Power BI, BB Team и здравословното хранене)

BB Team (https://www.bb-team.org/) e един от най-старите сайтове в българското уеб пространство, поне по мои спомени. Спомням си, че преди около 15 години вече имаше много полезни статии за тренировки, хранене и т.н. Power BI пък от своя страна позволява ефективна визуализация и трансформация на данни и BB Team се оказа чудесен източник - хората … Continue reading Протеини, който не яде… той данни не ще да събере (или за Power BI, BB Team и здравословното хранене)

Passing parameters to Native SQL Query in Excel and Power BI

Using Power Query in Excel you can parameterize a native query to SQL server or Oracle. While this is not something new, it's very useful as with some simple data validation you can turn your Excel file into a front-end query tool. Here are four simple steps to follow:Step 1a) Write the query code & test it; Step 1b) Paste it into … Continue reading Passing parameters to Native SQL Query in Excel and Power BI

Какво е Microsoft Flow / Power Automate

Какво е, защо може да ни е полезно, колко време ни трябва да го научим. Ако работите в офис е много вероятно да имате на фирмено ниво Офис 365, а с него - и набор от услуги, които влизат в Офис пакета. Една от тези услуги е инструмент за автоматизация на процеси, който позволява, почти … Continue reading Какво е Microsoft Flow / Power Automate

How to Learn Power BI?

Often, friends & colleagues ask me about learning Power BI and the best sources to do that. Below is my answer Updated: 31/10/2019 I use several channels: on Twitter (I'm @Vitali_Burlathere) and LinkedIn I follow Marc Reguera, Amir Netz, Matthew Roche, Patrick Le Blank, Adam Saxton, Daniil Maslyk (who frequently teases info about upcoming features), David Eldersveld, Gil Raviv, Matt Allington, … Continue reading How to Learn Power BI?