My ideas, tips and comments on data, analytics and visualization
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
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
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
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?
BB Team (https://www.bb-team.org/) e един от най-старите сайтове в българското уеб пространство, поне по мои спомени. Спомням си, че преди около 15 години вече имаше много полезни статии за тренировки, хранене и т.н. Power BI пък от своя страна позволява ефективна визуализация и трансформация на данни и BB Team се оказа чудесен източник - хората … Continue reading Протеини, който не яде… той данни не ще да събере (или за Power BI, BB Team и здравословното хранене)
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
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 в СофтУни - ето и видеото: https://www.youtube.com/watch?v=Ekzxhgz_Pk0&feature=youtu.be Семинар по Power BI в СофтУни
Какво е, защо може да ни е полезно, колко време ни трябва да го научим. Ако работите в офис е много вероятно да имате на фирмено ниво Офис 365, а с него - и набор от услуги, които влизат в Офис пакета. Една от тези услуги е инструмент за автоматизация на процеси, който позволява, почти … Continue reading Какво е Microsoft Flow / Power Automate
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?
Vitali on Data 