Linkedin - Learning The Data Skills Survival Kit
Course details
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 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 the growing numbers of analytics practitioners and data workers do their job better, such as joining data and data designs, privacy for data, transforming and cleaning data, and making datasets and visualizing data. Check back every other week for new videos! Note: Because this is an ongoing series, viewers will not receive a certificate of completion
01 - New This Week/01 - Adding data leveraging cross joins.mp4 18.59 MiB 02 - Introduction/01 - Series intro.mp4 5.80 MiB 03 - Joining Data/01 - Creating unique identifiers between two data sets.mp4 32.73 MiB 03 - Joining Data/02 - Joining with common data between two unrelated data sets.mp4 43.74 MiB 03 - Joining Data/03 - Using anti-joins to search for data.mp4 29.71 MiB 03 - Joining Data/04 - Working with full outer joins.mp4 14.89 MiB 04 - Data Designs/01 - Normalizing data to achieve a data design.mp4 17.27 MiB 04 - Data Designs/02 - Model or Merge—and what's the difference.mp4 46.60 MiB 05 - Privacy and Protection Techniques for Data/01 - Using functions to mask data.mp4 31.13 MiB 05 - Privacy and Protection Techniques for Data/02 - Creating aggregated datasets.mp4 31.38 MiB 06 - Transforming Data and Cleaning Data/01 - Using Unpivot to build data sets from survey results.mp4 27.16 MiB 06 - Transforming Data and Cleaning Data/02 - Cleaning data from a PDF in PowerBI.mp4 18.72 MiB 06 - Transforming Data and Cleaning Data/03 - Duplicate vs. reference in Power Query.mp4 29.71 MiB 06 - Transforming Data and Cleaning Data/04 - Cleaning data from a folder of files in PowerBI.mp4 17.89 MiB 06 - Transforming Data and Cleaning Data/05 - Build conditional functions to make data.mp4 47.64 MiB 07 - Making Data Sets/01 - Using Remove Duplicates to create data sets.mp4 30.21 MiB 07 - Making Data Sets/02 - Using union queries to bring together data sets in SQL.mp4 37.69 MiB 07 - Making Data Sets/03 - Using append queries to combine spreadsheets.mp4 18.38 MiB 07 - Making Data Sets/04 - Using make tables to normalize a denormalized data set.mp4 36.34 MiB 07 - Making Data Sets/05 - Building date tables in Power BIPower Query.mp4 33.08 MiB 07 - Making Data Sets/06 - Using joins and update queries to create markers in the data.mp4 41.51 MiB 08 - Visualize Data/01 - Edit visual interactions.mp4 29.89 MiB 08 - Visualize Data/02 - Build letter size for reports using Power BI Desktop.mp4 23.72 MiB 08 - Visualize Data/03 - Build paginated reports.mp4 15.98 MiB 08 - Visualize Data/04 - Use different pivot formats to share stories.mp4 16.72 MiB 09 - Basic Analysis/01 - Perform basic analysis on datasets.mp4 33.06 MiB 09 - Basic Analysis/02 - Using analysis commands built into popular tools.mp4 26.63 MiB 09 - Basic Analysis/03 - Basic dates analysis.mp4 34.08 MiB 09 - Basic Analysis/04 - Analyzing data using a matrix and conditional formats.mp4 30.51 MiB 09 - Basic Analysis/05 - Using Case statements for conditional logic in SQL queries.mp4 29.92 MiB Ex_Files_Data_Skills_Survival_Kit_2022_Q4.zip 1.27 MiB Ex_Files_Data_Skills_Survival_Kit_2023_Q1.zip 1.25 MiB Ex_Files_Data_Skills_Survival_Kit_2023_Q2.zip 3.66 MiB Ex_Files_Data_Skills_Survival_Kit_2023_Q3.zip 2.31 MiB Ex_Files_Data_Skills_Survival_Kit_2023_Q4.zip 904.07 KiB