Scripting views for SQL databases

A woman working on a computer.

Scripting views for SQL databases Learn how to take your SQL queries and script them into Views. These objects can then be used by other software like PowerBI, and Excel to build valuable reports and visualizations. Learn how to script views The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt…

Read More

Designing relationships for databases

A woman working on a computer.

Designing relationships for databases Learn how to design relationships for a basic database. If you can understand how to create relational designs, then you will understand how to read great designs and deal with bad designs. Learn How To Design Relations for Databases The Data Skills Survival Kit Series If you’re a data analyst, you’ve…

Read More

Creating a SharePoint back end from a database

A woman working on a computer.

Creating a SharePoint back end from a database Learn how to get the most of a relational design and a live database backend at the same time. Not everything you will do will get a large budget, but this technique can be amazing for your process and your project. Learn How To Create a Sharepoint…

Read More

Creating tables and joins to recode data

A woman working on a computer.

Creating tables and joins to recode data There are times where you can’t write a enough replace commands, or conditional statements to clean bad data. Learn how to create a control table to clean data in mass. Learn How To Recode Data The Data Skills Survival Kit Series If you’re a data analyst, you’ve no…

Read More

Merging data and building basic calculations into a data set

A woman working on a computer.

Merging data and building basic calculations into a data set Learn how to merge data from different sources and build basic calculations into a dataset. See how to analyze data by creating a comprehensive dataset for further analysis. Learn How To Merge and Calculate Data The Data Skills Survival Kit Series If you’re a data…

Read More

Adding data leveraging cross joins

A woman working on a computer.

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. Learn How To Leverage Cross Joins The Data Skills Survival Kit…

Read More

Using date functions to create follow up data

A woman working on a computer.

Using date functions to create follow up data When you have data; you can use it to create valuable data sets to help automate or notify for other processes. Learn how to use date functions to create valuable follow up and notifications data. Learn How To Use Date Functions The Data Skills Survival Kit Series…

Read More

Build letter size for reports using Power BI Desktop

A woman working on a computer.

Build letter size for reports using Power BI Desktop You need all the features of PowerBI desktop, but at the end of the refresh process this information needs to be packaged and sent via PDF. Discover how to adjust your layouts to get the best of PowerBI and meet the delivery requirements Learn How To…

Read More

Build paginated reports

A woman working on a computer.

Build paginated reports Learn how to quickly build basic paginated reports using PowerBI Report Builder. Learn How To Build Paginated Reports The Data Skills Survival Kit Series 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…

Read More