Testing data in your new database design

A woman working on a computer.

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 More

Defining nomenclature for fields to reduce data issues

A woman working on a computer.

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 More

Visualizing subgroups when searching for insights

A woman working on a computer.

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 More

Cleaning Survey Data for the Purposes of Analysis

A woman working on a computer.

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 More

Working with Different Group Sizes

A woman working on a computer.

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 More

Understanding and Communicating Impacts

A woman working on a computer.

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 More

Creating subgroups for use in visuals and basic analysis

A woman working on a computer.

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 More

Planning a Basic System for Data Collection

A woman working on a computer.

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 More

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

Use Copilot to Create a Draft Presentation about your Data Project

A woman working on a computer.

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