Have you ever wondered what makes Power BI so fast and powerful when it comes to performance? Learn on a real-life example about data model optimization and general rules for reducing data model
Have you ever wondered what makes Power BI so fast and powerful when it comes to performance? So powerful, that it performs complex calculations over millions of rows in a blink of an eye.
In this article, we will dig deep to discover what is “under the hood” of Power…
In this article, we demystify views and explain why they should be your preferred choice when importing data from the SQL database.
In recent months, I was frequently asked if one should use tables or views when IMPORTING data in Power BI. I’ve intentionally marked word importing, as the main purpose of this article is to compare usage of views vs tables in Import mode. …
Did someone ask you to replace blank values with 0 in your reports? Maybe you should think twice before you do it
Just recently, I was watching Jeffrey Wang as a live stream guest with Reid Havens, and one of the dozen wonderful things that Jeffrey shared with the audience was the list of optimizations that the DAX engine performs when creating an optimal query plan for our measures.
And, the one…
How much would you pay if you use Power BI in a combo with Synapse Analytics? In the final part of the series, I’ve put Power BI & Synapse Analytics Serverless SQL pool to an ultimate benchmarking test and here are the results!
By introducing Azure Synapse Analytics in late 2019, a whole new perspective was created when it comes to data treatment. …
In the 2nd part of the series, learn what Synapse brings to a table for Power BI developers, and how you can leverage both tools to get an indefinite number of use-cases!
By introducing Azure Synapse Analytics in late 2019, a whole new perspective was created when it comes to data treatment. …
In the 1st part of this blog series on the integration of Power BI and Synapse Analytics, learn about the enormous flexibility that the Serverless SQL pool within Synapse brings to the table.
By introducing Azure Synapse Analytics in late 2019, a whole new perspective was created when it comes to data treatment. …
Your Power BI report is slow? Check how you can dramatically speed it up by applying some simple tricks while preserving the original report look
Can you spot the difference between the following two reports?
Yeah, neither can I!
But, there is a huuuuuge difference between those two reports! What if I tell you that the report on the right is 5x faster than the one on the left? Would you believe me? No? …
In the final part, we will take our analytics skills to another level! Not just that — based on the insights unlocked, we will recommend certain actions!
When I talk to people who are not deep into the Power BI world, I often get the impression that they think of Power BI as a visualization tool exclusively. While that is true to a certain extent, it seems to me that they are not seeing the bigger picture…
Ready for some cool data visualization? In this part, we’re building our report in accordance with some of the best data viz practices!
When I talk to people who are not deep into the Power BI world, I often get the impression that they think of Power BI as a visualization tool exclusively. While that is true to a certain extent, it seems to me that they are not seeing the bigger picture…
After we cleaned and shaped our data, it’s time to level up the game! Learn why Star schema & Power BI are match made in heaven, and how to build it directly in Power BI!
When I talk to people who are not deep into the Power BI world, I often get the impression that they think of Power BI as a visualization tool exclusively. While that is true to a certain extent, it seems to me that they are not seeing the bigger picture…
