Data Skills Survival Kit
The Data Skills Survival Kit
New episode every other week!
+
Courses Offered
+
Training in person
1. million+
Asynchronous Learning
Joining Data
Working with full outer joins
Working with full outer joins Often times we find as data workers we are trying to determine what is on two data sets. We want to see everything that matches or doesn't match from two ...
Data Survival Skills, Joining Data, Training, Videos
Using anti joins to search for data
Using anti joins to search for data We know that data sets cannot be achieved efficiently without adjusting joins so we learn about left and right joins. Then as we produce these results sometimes we ...
Data Survival Skills, Joining Data, Training, Videos
Joining data with common data between two unrelated data sets
Joining data with common data between two unrelated data sets Joining data is part of the life of a data analyst. The problem is that most data sets that need to be joined exist in ...
Data Survival Skills, Joining Data, Training, Videos
Creating unique identifiers between two data sets
Creating unique identifiers between two data sets When a join is required, and the field doesn't exist, you must learn to create a field to create a unique identifier. This will allow you to enjoy ...
Data Survival Skills, Joining Data, Training, Videos
Data Designs
Scripting views for SQL databases
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 ...
Data Designs, Data Survival Skills, Training, Videos | LinkedIn Learning, Paid Subscription Required
Designing relationships for databases
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 ...
Data Designs, Data Survival Skills, Training, Videos | LinkedIn Learning, Paid Subscription Required
Creating a SharePoint back end from a database
Creating a SharePoint back end from a database Learn how to export a relational database from Access to SharePoint, enabling real-time data access with tools like Excel and Power BI. By leveraging SharePoint's features, you ...
Data Designs, Data Survival Skills, Training, Videos | LinkedIn Learning, Paid Subscription Required
Model or Merge- and what’s the difference?
Model or Merge- and what's the difference? You may wonder, "When is it best to model or to merge?" In this video we show the difference so you can decide based on your project needs. ...
Data Designs, Data Survival Skills, Training, Videos
Normalizing data to achieve a data design
Normalizing data to achieve a data design Normalizing data is typically the skill of a database designer, but when you are an analyst, you design data sets. No keys on how to break data to ...
Data Designs, Data Survival Skills, Training, Videos
Privacy and Protection Techniques for Data
Creating aggregated datasets
Creating aggregated datasets Creating aggregate data sets is vital for effective data analysis and decision-making. Aggregation involves summarizing large volumes of detailed data into a more manageable and meaningful form, which helps in identifying trends, ...
Data Survival Skills, Privacy and Protection, Training, Videos
Using Functions to Mask Data
Using Functions to Mask Data Exploring Different methods to mask data for privacy (because data privacy is crucial data governance skills for all). Learn How To Use Functions To Mask Data The Data Skills Survival ...
Data Survival Skills, Privacy and Protection, Training, Videos
Transforming and Cleaning Data
Creating tables and joins to recode data
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 ...
Data Survival Skills, Training, Transforming and Cleaning, Videos | LinkedIn Learning, Paid Subscription Required
Merging data and building basic calculations into a data set
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 ...
Data Survival Skills, Training, Transforming and Cleaning, Videos | LinkedIn Learning, Paid Subscription Required
Build conditional functions to make data
Build conditional functions to make data The ability to create conditional formulas in Power BI is essential because it transforms raw data into meaningful, reliable information tailored for specific reporting needs. This capability is key ...
Data Survival Skills, Training, Transforming and Cleaning, Videos | LinkedIn Learning, Paid Subscription Required
Cleaning data from a folder of files in Power BI
Cleaning data from a folder of files in Power BI Each week represents a new set of information for your reports. Learn how to create a report or spreadsheet by pulling data from a folder ...
Data Survival Skills, Training, Transforming and Cleaning, Videos | LinkedIn Learning, Paid Subscription Required
Duplicate vs Reference in Power Query
Duplicate vs Reference in Power Query To duplicate or to reference, that is the question. The answer truly depends on the outcome you are trying to achieve. Learn the differences of both commands and how ...
Data Survival Skills, Training, Transforming and Cleaning, Videos
Cleaning data from a PDF in Power BI
Cleaning data from a PDF in PowerBI Let's face it- sometimes the only information you have is in a beautiful formatted PDF file. Not to worry, you can clean it like it's a spreadsheet. Learn ...
Data Survival Skills, Training, Transforming and Cleaning, Videos | LinkedIn Learning, Paid Subscription Required
Using Unpivot to build data sets from Survey Results
Using Unpivot to build data sets from Survey Results Surveys are used to capture a ton of data. These tools typically provide some initial information but to really analyze and visualize some data you must ...
Data Survival Skills, Training, Transforming and Cleaning, Videos
Making Data Sets
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 ...
Data Survival Skills, Making Data Sets, Training, Videos | LinkedIn Learning, Paid Subscription Required
Using date functions to create follow up data
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 ...
Data Survival Skills, Making Data Sets, Training, Videos | LinkedIn Learning, Paid Subscription Required
Leveraging the Advanced Editor in Power Query to share cleaning routines
Leveraging the Advanced Editor in Power Query to share cleaning routines Use the Advanced Editor in Power Query to manage and share data cleaning routines by leveraging M code. Walk through connecting to data sources, ...
Data Survival Skills, Making Data Sets, Training, Videos | LinkedIn Learning, Paid Subscription Required
Using Remove Duplicates and Distinct Statements
Using Remove Duplicates and Distinct Statements You have a ton of data- it's just not modeled and workable. You can't quit. You must learn how to make data from the data you have. Learn How ...
Data Survival Skills, Making Data Sets, Training, Videos | LinkedIn Learning, Paid Subscription Required
Using Joins and Update Queries to Create Valuable Markers
Using Joins and Update Queries to Create Valuable Markers in the data Joins can provide you a valuable way to link information, but they can also be used to create valuable markers or fields in ...
Data Survival Skills, Making Data Sets, Training, Videos | LinkedIn Learning, Paid Subscription Required
Building Date Tables in Power BI, Power Query
Building Date Tables in Power BI & Power Query Creating date tables is important in data analysis because they provide a structured way to analyze data over time. A date table includes every date within ...
Data Survival Skills, Making Data Sets, Training, Videos | LinkedIn Learning, Paid Subscription Required
Using Make Tables to normalize a denormalized data set
Using Make Tables to normalize a denormalized data set We can't always control how we receive data. However, once we have that data we can make decisions that will help us better report on the ...
Data Survival Skills, Making Data Sets, Training, Videos | LinkedIn Learning, Paid Subscription Required
Using Append queries to combine spreadsheets
Using Append queries to combine spreadsheets You may discover that all your data is siloed into many different spreadsheets even though they contain the same structure. Learn how to create simple appends to create the ...
Data Survival Skills, Making Data Sets, Training, Videos | LinkedIn Learning, Paid Subscription Required
Using Union Queries to bring together data sets from other tables/views in SQL
Using Union Queries to bring together data sets from other tables/views in SQL Unions can be a valuable concept to understand when your data sets are in different tables or by different unique queries. Learn ...
Data Survival Skills, Making Data Sets, Training, Videos | LinkedIn Learning, Paid Subscription Required
Visualizing Data
Build letter size for reports using Power BI Desktop
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. ...
Data Survival Skills, Training, Videos, Visualize Data | LinkedIn Learning, Paid Subscription Required
Build paginated reports
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 ...
Data Survival Skills, Training, Videos, Visualize Data | LinkedIn Learning, Paid Subscription Required
Building a brief for a data project
Building a brief for a data project We spend so much time on techniques to visualize data but little on how to get the information into the hands of others. It's not always about the ...
Data Survival Skills, Training, Videos, Visualize Data | LinkedIn Learning, Paid Subscription Required
Creating simple data sets with basic visuals for presentations
Creating simple data sets with basic visuals for presentations Learn how to create simple datasets and transform them into visually appealing charts and graphs using Microsoft Excel. Discover techniques for formatting and customizing these visuals ...
Data Survival Skills, Training, Videos, Visualize Data | LinkedIn Learning, Paid Subscription Required
Basic visualization of cohort data
Basic visualization of cohort data Visualize cohort data using Power BI to show progression over time. Cover structuring data for visualization and using matrix visuals to illustrate cohort progression. Learn How To Visualize Cohort Data ...
Data Survival Skills, Training, Videos, Visualize Data | LinkedIn Learning, Paid Subscription Required
Using various pivot formats
Using various pivot formats to tell different stories for your presentations Every visual tells a story. Learn how to use Pivots to share different stories on the same data. Learn How To: Use Different Pivot ...
Data Survival Skills, Training, Videos, Visualize Data | Conditional Formats, CrossTab, LinkedIn Learning, Paid Subscription Required, Pivot, PowerBI
Building letter size reports for meetings using Power BI Desktop
Building letter size reports for meetings using Power BI Desktop Creating Power BI files that are printable or can be exported as PDF pages adds significant value for meetings and presentations. Here's why:Accessibility: Not everyone ...
Data Survival Skills, Training, Videos, Visualize Data | LinkedIn Learning, Paid Subscription Required
Edit visual interactions
Edit visual interactions Learn how to create interactive dashboards with a few static items that never update. Learn How To Edit Interactions In Dashboards The Data Skills Survival Kit Series If you're a data analyst, ...
Data Survival Skills, Training, Videos, Visualize Data | LinkedIn Learning, Paid Subscription Required
Basic Analysis
Establishing a cohort data set
Establishing a cohort data set There are times when you want to study the behaviors of a data set, and how one group might compare to others. Learning how to establish a basic cohort will ...
Basic Analysis, Data Survival Skills, Training, Videos | LinkedIn Learning, Paid Subscription Required
Adding additional data to your cohorts
Adding additional data to your cohorts Once cohorts data sets are established you will find yourself leveraging them for various studies. You will find it can be helpful to add additional data points to your ...
Basic Analysis, Data Survival Skills, Training, Videos | LinkedIn Learning, Paid Subscription Required
Analyzing top and bottom scenarios
Analyzing top and bottom scenarios Analyze the top and bottom scenarios within a dataset using Power BI. Covers how to present data context, filter top and bottom records, and create visualizations to compare different data ...
Basic Analysis, Data Survival Skills, Training, Videos | LinkedIn Learning, Paid Subscription Required
Using Case statements for conditional logic in SQL queries
Using Case statements for conditional logic in SQL queries Creating CASE statements in SQL queries is important because it allows you to add conditional logic directly into your data retrieval process. Here's why it's valuable:Data ...
Basic Analysis, Data Survival Skills, Videos | Conditional Logic, LinkedIn Learning, Paid Subscription Required, SQL
Analyzing data using a matrix and conditional formats
Analyzing data using a matrix and conditional formats Have an Excel sheet with pivot tables full of data? Want to visualize those in Power BI in meaningful ways? Let Robin step you through the next ...
Basic Analysis, Data Survival Skills, Training, Videos | Conditional Formats, CrossTab, LinkedIn Learning, Paid Subscription Required, Pivot, PowerBI
Perform basic analysis
Perform basic analysis on data sets No single data set is exactly the same. Learn how to do the basic analysis techniques to learn more about your data. Learn How To: Analyze Data Sets The ...
Basic Analysis, Data Survival Skills, Training, Videos | LinkedIn Learning, Paid Subscription Required
Using analysis commands
Using the analysis commands built into popular tools Most systems have some basic analysis built in to the software. Learn how to take your analysis up a step using these built-in tools. Learn How To: ...
Basic Analysis, Data Survival Skills, Training, Videos | LinkedIn Learning, Paid Subscription Required
Basic dates analysis
Using basic dates analysis It's in the gap you can tell the story. This is a must watch video. This will show you how to gain some great data structure for data that needs to ...
Basic Analysis, Data Survival Skills, Training, Videos | LinkedIn Learning, Paid Subscription Required
Leveraging Copilot for Data in Microsoft Excel
It's tough to claim survival skills when Copilot is quite new, right? Technically, AI itself isn't new, but Copilot as a tool is a recent addition to the market. Learning how to use it effectively, understanding its strengths and weaknesses, is all part of the process.
Use Copilot in Excel to teach you about the data
Use Copilot in Excel to teach you about the data By structuring the data into a table and using Copilot, you can quickly get insights such as the number of records and unique values, and ...
Copilot for Data in Microsoft Excel, Data Survival Skills, Training, Videos | LinkedIn Learning, Paid Subscription Required
Use Copilot to build basic functions in Excel
Use Copilot to build basic functions in Excel Use Copilot in Excel to assist in building basic functions and calculations. Watch how Copilot can guide you through solving calculation issues, even if it doesn't get ...
Copilot for Data in Microsoft Excel, Data Survival Skills, Training, Videos | LinkedIn Learning, Paid Subscription Required
Use Copilot to do basic cleanup commands
Use Copilot to do basic cleanup commands Use Copilot in Excel for basic data cleanup tasks, such as removing unnecessary columns and formatting data. Learn How To Use Copilot Cleanup Commands The Data Skills Survival ...
Copilot for Data in Microsoft Excel, Data Survival Skills, Training, Videos | LinkedIn Learning, Paid Subscription Required
Use Copilot to see insights in your data
Use Copilot to see insights in your data How to leverage Copilot in Excel to explore data insights, including removing unnecessary columns and visualizing population changes over time. Learn How To Use Copilot for ...
Copilot for Data in Microsoft Excel, Data Survival Skills, Training, Videos | Copilot, LinkedIn Learning, Paid Subscription Required
Use Copilot in Word to build documentation about your data project
Use Copilot in Word to build documentation about your data project Use Copilot in Microsoft Word to assist with documentation and research for data projects. Experience how Copilot can generate tables and lists from text ...
Copilot for Data in Microsoft Excel, Data Survival Skills, Training, Videos | Copilot, LinkedIn Learning, Paid Subscription Required
Designing Relational Databases
Designing a basic system for data capture
Designing a basic system for data capture This video reveals a key data skill, like joining data sets or creating impactful visualizations. You'll gain powerful tips to become a more efficient and accurate data analyst, ...
Data Survival Skills, Designing Relational Databases, Training, Videos | LinkedIn Learning, Paid Subscription Required
Diagramming Data and Processes
Diagramming Data and Processes Visualizing data inside your head into diagrams can be a key skill. However, to be able to visualize data - you might have to build this skill. Learn keyways to get ...
Data Survival Skills, Designing Relational Databases, Training, Videos | LinkedIn Learning, Paid Subscription Required
Need Help With Your Data?
ThinkData creates customized training solutions for companies of all sizes, tailored to what your team needs most.