fbpx

Ready to be a Kusto Detective with Azure Data Explorer?

Your detective journey starts with the Kusto Detective Agency for Azure Data Explorer. This is a really fun way to learn the Kusto Query Languate (KQL)! Patrick gets you started! And, it's FREE! Kusto Detective Agency: https://detective.kusto.io/

Ready to be a Kusto Detective with Azure Data Explorer?2023-01-31T09:24:45-05:00

What the French Toast is a Slowly Changing Dimension???

Want to know more about a slowly changing dimension? What about the different types? Patrick goes through examples and ties in the surrogate key! Sample: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20230124%20-%20SCD%20Demo.sql Handling Type II Dimension with the MERGE Statement https://sqldownsouth.blogspot.com/2010/11/handling-type-ii-dimension-with-merge.html Slowly Changing Dimension https://en.wikipedia.org/wiki/Slowly_changing_dimension Star Schema The Complete Reference https://amzn.to/3QJjw2E

What the French Toast is a Slowly Changing Dimension???2023-01-24T07:13:27-05:00

Allow users to Show and Hide columns in a Power BI Paginated report!

In a Power BI Paginated Report, you can allow your report consumers to customize what they see in the report such as which columns they want in their table or matrix. Patrick shows you how! Sample RDLs: https://github.com/guyinacube/demo-files/blob/master/video%20demos/RDL/20230118%20-%20Paginated%20Show%20Hide%20Columns.zip

Allow users to Show and Hide columns in a Power BI Paginated report!2023-01-18T07:26:47-05:00

What is a Common Table Expression (CTE) and how do you use them?

We've had some questions about what a Common Table Expression (CTE) is. Patrick describes what they are and how you can use them in SQL Server or Azure Synapse Analytics. WITH common_table_expression (Transact-SQL) https://learn.microsoft.com/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16 Sample Scripts - https://github.com/guyinacube/demo-files/tree/master/video%20demos/Synapse

What is a Common Table Expression (CTE) and how do you use them?2023-01-17T08:06:43-05:00

How to handle Aggregation tables with Averages in Power BI

Using Aggregation Tables in Power BI? Average calculations not working because they aren't hitting the agg? Patrick explains why this is happening and how you can correct it to get the expected result.

How to handle Aggregation tables with Averages in Power BI2023-01-04T07:15:36-05:00

To Surrogate Key or Not…

We've talked about using a surrogate key in your data warehouse whether that's Azure Synapse Analytics or something else. Patrick looks at why you should consider this even if you aren't using a slowly changing dimension.

To Surrogate Key or Not…2023-01-03T07:53:08-05:00

Build a Slicer Panel in Power BI (2022/2023)

Let's look at how to build a slicer panel in your Power BI Report! This can help to reduce visuals on the canvas and also make for an app like experience. There are some things to think about though. For a trip down memory lane, here's Adam's 2019 Slicer Panel Video: https://www.youtube.com/watch?v=xy9nmSQeUWg

Build a Slicer Panel in Power BI (2022/2023)2022-12-15T07:57:26-05:00

A Power Query tip for you

You probably know that you can concatenate strings in Power Query. Not big news there. But do you know how to change the order of how things are concatenated? Patrick shows you how!

A Power Query tip for you2022-12-14T07:15:12-05:00
Go to Top