Posts Tagged ‘LinkedIn Learning’
Testing data in your new database design
Testing data in your new database design One thing we do not do if we want good data – is skip testing the data entry. We do not have to have forms to test the data. Learn How To Test Your Database Design The Data Skills Survival Kit Series If you’re a data analyst, you’ve…
Read MoreDefining nomenclature for fields to reduce data issues
Defining a Nomenclature for Fields to Reduce Data Issues In so many organizations we name our projects based on what we find meaningful. This is great until you let more than one person name the same types of projects. Defining a nomenclature for data that involves naming like projects can be beneficial for data quality…
Read MoreVisualizing subgroups when searching for insights
Visualizing Subgroups when Searching for Insights One of the key ways to compare information is through the use of subgroups. Meaning groups of information you defined for the purpose of your analysis. Learn How To Visualize Subgroups The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt learned different skills, techniques,…
Read MoreCleaning 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 More