Power of Excel VBA (part 1)
This blog is mostly about Power BI, but I spent many years working with Excel VBA before I switched to working with Power BI full … Read More
This blog is mostly about Power BI, but I spent many years working with Excel VBA before I switched to working with Power BI full … Read More
As I mentioned earlier, there are a lot of good books for Power BI developers. It’s hard to select only 5 of them. But if … Read More
There are a lot of good books Power BI developer can read. It’s hard to select only 5 of them. But I decided that I’ll … Read More
If your job is to talk with people about numbers (any numbers: profit and loss, salary, election results, number of stars in the universe) then … Read More
This books doesn’t require a lot of comments. It’s the DAX Bible. The Definitive Guide to DAX means what it says – it’s The Definitive … Read More
While you can import one table from an Excel file into Power BI and start adding fields into a visual, in most cases your data … Read More
I usually don’t read books with step by step instruction like “click File, then click Open”. I start working with a new tool right away … Read More
A crazy Power BI idea is in my head. It rather doesn’t make much practical sense, but such crazy ideas sometimes lead to useful solutions for the … Read More
I’m working with multiple Power BI tenants, workspaces and reports. It’s a pain to log out (I’m always logged in with an account for previous report), copy … Read More
In this post I’ll show how to handle a time series of data with outliers (extremely high values). For example, number of new COVID-19 deaths … Read More