Awesome video, thank you!

Brilliant example and explanation Brother 😎

Great work here and thanks so much. This is very useful and helpful.

The best way to put it so far👍 Thanks it works whether data is aggregate values or not. good way akso to create tall tables for some reasons.

You are the man

Brilliant…. Thank you

Thank you!

that was clean

Thanks but how can you have sales amount greater than the inventory amount

Hi James, for the first section where you add the column name for unpivot, how can we write it such that the column name comes from a table or a variable so that it becomes dynamic.

Great video! Thanks!

🌟🌟🌟🌟🌟

Hi james i am great fan of your teaching... could you please make a video on what are the conditions to blend two datasets in microstrategy document? Means is it enough to have one common attribute in two datasets or any other conditions.

@JamesOliver

3 жыл бұрын

I have 2 videos I created a while back on data blending that should help. kzread.info/dash/bejne/c2x5uaalkdXge5M.html and also kzread.info/dash/bejne/qmmLmcRwj9fTddY.html

Thank you. Learning SQL on my own, is there a place to download large amounts of sample data?

@JamesOliver

3 жыл бұрын

CheCheSmith Yes install sql server express and then download the sample database AdventureWorks from Microsoft

how can we know the original column name ? like SalesAmount and Week

please post a video on Microstrategy dossiers in youtube or udemy by updating your course.thanks.

Hi, James. For the first section of the video, you unpivoted. What if you want to add the results of that unpivoted data to another query?

@JamesOliver

3 жыл бұрын

If I understand you correctly, you should use CTE / WITH statements to do that