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
The Best 5 Books for Power BI Developers
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
Avoiding Data Pitfalls: How to Steer Clear of Common Blunders When Working with Data and Presenting Analysis and Visualizations
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
Storytelling with Data: A Data Visualization Guide for Business Professionals
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
The Definitive Guide to DAX: Business intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel
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
Analyzing Data with Power BI and Power Pivot for Excel
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
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
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 power BI report that displays its own metadata, including refresh history
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
PowerShell script to publish Power BI reports into multiple tenants
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
Line and stacked column chart with outliers
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