/GIFs/Simple-Animation.gif?width=600&name=Simple-Animation.gif)
5 min read
TimeXtender Tuesday - Episode 33
One of the sure things about data is that it is not always in the format needed for analysis. This episode of TimeXtender Tuesday focuses on using pivot and unpivot functions to quickly prepare data for analysis in the correct format.
The pivot and unpivot relational operators allow you to change table-valued expressions into another table, so it can be visualized in a way that fits your business needs. PIVOT turns unique values from one column into multiple columns, whereas UNPIVOT does the opposite and rotates columns in a table into values. Watch now to see an example of how it all works.
If you'd like to review previous TimeXtender Tuesdays sessions, check out our TimeXtender Tuesday playlist on YouTube.
- Registration Form - TimeXtender Tuesday
- YouTube Playlist - TimeXtender Tuesday
- Feedback and Idea Submission Form - TimeXtender Tuesday
Taking it further:
6 min read
Debunking Three Common Misconceptions About Data Modeling
May 4, 2023 Written by Aaron Powers, Content Marketing Specialist
3 min read
Get FREE Access to BARC's New Report: The State of the Data Vault
May 1, 2023 Written by Micah Horner, Product Marketing Manager, TimeXtender