Archive for October 2024
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 enhance your analysis. Learn How To Establish a Cohort Data Set The Data Skills Survival Kit Series If you’re a…
Read MoreAdding 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 cohort. Learn how to join your cohort data for your analysis projects. Learn How To Add Additional Data The Data…
Read MoreLeveraging the Advanced Editor in Power Query to share cleaning routines
Leveraging the Advanced Editor in Power Query to share cleaning routines When you work in a team but on solo projects you can find yourself with some advanced cleaning routines. These routines could likely be shared with others on the team to reduce the amount of cleaning that you do collectively for common projects. Learn…
Read MoreCreating 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 to align with your organization’s style and brand. Learn How To Create Simple Data Sets & Visuals The Data Skills…
Read MoreAnalyzing 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 segments effectively. Learn How To Analyze Top & Bottom Scenarios The Data Skills Survival Kit Series If you’re a data…
Read MoreDesigning a basic system for data capture
Designing a basic system for data capture Learning how to design basic systems even if it is just building a basic tables is a survival skill for sure. It helps you survive by letting you consider fields, rules and visualize roadblocks, pathways, potholes, you name it. When you learn to design systems then you can…
Read MoreUse Copilot in Excel to teach you about the data
Use Copilot in Excel to teach you about the data The goal of this video is to show how to ask basic prompts to quickly learn about the data which will help you further validate your own work and the stuff that is produced by Copilot in Excel. Learn How To Use Copilot to Learn…
Read MoreUse 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 everything perfect initially. Learn How To Build Functions with Copilot The Data Skills Survival Kit Series If you’re a data…
Read MoreUse 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 Kit Series If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining to data. But…
Read MoreUse 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 Data Insight The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt learned different skills, techniques,…
Read More