Looking through the WINDOW – Calculating customer lifetime value with new DAX functions!
New window functions are one of the most important enhancements to the DAX language ever! Learn how to leverage them to calculate a customer lifetime...
Mastering DP-500: Synapse Serverless SQL and file types – the ultimate guide!
CSV? Parquet? Delta? Which file format should you use to get the best out of Synapse Serverless SQL pool? Let's demistify pros and cons of...
Mastering DP-500 Exam: Dedicated vs Serverless SQL in Synapse – Which should I use?!
Which Synapse pool should I use in different business scenarios? If you've asked yourself this question, keep reading and by the end of this article...
Mastering DP-500 Exam: Explore and Visualize Data using Synapse SQL pane
Do you fancy a quick data visualization for your ad-hoc queries over SQL pools in Azure Synapse Analytics? Synapse Studio gets you covered!
Hybrid tables in Power BI: extending beyond time-related scenarios!
Hybrid tables are one of the most powerful features in Power BI! And, it's not (just) about separating "hot" and "cold" data...You can basically leverage...
3 reasons to use views instead of tables in Power BI!
When using a relational database as the data source for Power BI solutions, most report creators choose to take an easier path - import the...
Solved! Query folding for native SQL in Power BI
Writing a native SQL query in Power BI will break query folding, right? Well, not anymore...
Query folding – tricks, lies & ultimate performance test!
In the final part of the Query folding series, learn more tricks, find out when the View Native Query lies, and finally spot the difference...
How to capture SQL queries generated by Power BI
Put smile on your face and provide your DBA with all the necessary info about SQL queries generated by Power BI!
Synapse Serverless SQL & Power BI – having fun with PIVOT!
Check how the latest improvements to Synapse Serverless SQL pool can help you create one of the most popular Power BI transformations in more optimal...