Adding data leveraging cross joins

Adding data leveraging cross joins

We use joins in data to effectively report on data, but have you ever considered using them to create data? When faced with adding repetitive data for a project that applies across the board learn to leverage cross joins.

Spreadsheet with employee directory and schedule.
SQL Server Management Studio with employee data.
SQL Server Management Studio window with SQL query designer.
SQL Server Management Studio query results table.

If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining to data. But sometimes it can be difficult to know when and why to apply these tools. In this weekly series, instructor Robin Hunt explains a new skill, secret, tip, technique, best practice, or golden piece of advice in each installment. Robin covers topics that can help you do your job better, such as joining data and data designs, privacy for data, transforming and cleaning data, and making data sets and visualizing data.

Watch the Series Intro Today

Note: Because this is an ongoing series, viewers will not receive a certificate of completion.