Posts Tagged ‘LinkedIn Learning’
Cleaning Survey Data for the Purposes of Analysis
Cleaning Survey Data for the Purposes of Analysis There are some visuals that can not be created when data collected through surveys is not effectively transformed. Learn how to leverage techniques for cleaning survey fields that might capture mutliple answers and preparing it for visuals. Learn How To Clean Survey Data The Data Skills Survival…
Read MoreWorking with Different Group Sizes
Working with Different Group Sizes In data studies there can be a two group comparison and there can also be a size difference in the groups. Learning how to look at responses based on two groups and of vastly different sizes can help you see insights that are otherwise not as easily seen. Learn How…
Read MoreUnderstanding and Communicating Impacts
Understanding and Communicating Impacts Often times numbers are thrown on a page and it can be impossible to know what they mean if you do not dig a little deeper. Learn how work with a basic loan amortization and show impact. Learn How To Understand and Communicate Impacts The Data Skills Survival Kit Series If…
Read MoreCreating subgroups for use in visuals and basic analysis
Creating subgroups for use in visuals and basic analysis Being able to transform data doesnt always mean a calculation like price * quantity. It can mean building text based calculations to allow for further study and analysis. Learn how to create subgroups with formulas. Learn How To Create Subgroups with Formulas The Data Skills Survival…
Read MorePlanning a Basic System for Data Collection
Plan a Basic System for Data Collection Databases that capture data in real time with live data is a different design than data designs that are to just collect and report on data. Understanding data collections is a key to my survival. Learn How To Plan a System The Data Skills Survival Kit Series If…
Read MoreScripting 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 visualizations. Learn How To Script Views The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt…
Read MoreUse Copilot to Create a Draft Presentation about your Data Project
Use Copilot to Create a Draft Presentation about your Data Project It will not be the final draft but learn how to leverage the power of Copilot with your data to create a great first draft for discussions with the project team. Learn How To Use Copilot for Draft Presentation The Data Skills Survival Kit…
Read MoreUsing Remove Duplicates to Find the Latest or Earliest Record in Excel
Using Remove Duplicates to Find the Latest or Earliest Record in Excel You will learn how to leverage multi sort options to retrieve the appropriate record for your data analysis and/or reporting. Learn How To Use Remove Duplicates The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt learned different skills,…
Read MoreAuditing Data and Spreadsheets
Auditing Data and Spreadsheets One keyway to ensure privacy and protection is to audit the files. Look at the file a way another might. Let’s uncover ways to audit a file quickly by using the built in formula auditing tools for the purpose of privacy and protection. Learn How To Audit Data and Spreadsheets The…
Read MoreVisualizing data sets in Outlook
Visualizing data sets in Outlook People are constantly trying to build calendars. Knowing that Outlook reads data in the form of calendars has allowed me for decades to look over time in a calendar view – way before the project ever started. Sure we have systems in place for projects once they are real –…
Read More