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
Coming back to life* – and counting empty columns
Now, the blog was inactive for over two years, but it is coming back to life! Lots of changes on the personal side (moving to a new country, a new language and a baby, among other things). Many times I was about to post something and then life stopped me. The problem There was a … Continue reading Coming back to life* – and counting empty columns
Drill-Through to Subtotal’s Details in Power BI
A friend asked me about a way to allow users to display line level information - what you normally do with a drillthrough page - however, not for a single line, but for all currently selected items in the table object, i.e. if you have a simple table, like the one below: How can we … Continue reading Drill-Through to Subtotal’s Details in Power BI
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
Switching items with a radio buttons in Power BI
If you don't have the time to read the full article, here's a 1 min GIF below. But if you do, I'd b happy if you read further: The detailed explanation: I was working on a demo to show the benefits of using a disconnected table when I decided to try and make something interesting … Continue reading Switching items with a radio buttons in Power BI
Въведение в Power BI – видео
Имах удоволствието да направя семинар за Power BI в СофтУни - ето и видеото: https://www.youtube.com/watch?v=Ekzxhgz_Pk0&feature=youtu.be Семинар по 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?