Archive for October 2024
Building a brief for a data project
Building a brief for a data project We spend so much time on techniques to visualize data but little on how to get the information into the hands of others. It’s not always about the final product. You may find there are lots of project details and creating an effective brief will be a life…
Read MoreEstablishing 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 Use the Advanced Editor in Power Query to manage and share data cleaning routines by leveraging M code. Walk through connecting to data sources, editing queries, and transferring cleaning routines between Excel and Power BI. Learn How To Leverage Advanced Editor The Data Skills Survival…
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 This video reveals a key data skill, like joining data sets or creating impactful visualizations. You’ll gain powerful tips to become a more efficient and accurate data analyst, even if you’re new to the field. Learn How To Design a System for Data Capture The Data Skills Survival…
Read MoreUse Copilot in Excel to teach you about the data
Use Copilot in Excel to teach you about the data By structuring the data into a table and using Copilot, you can quickly get insights such as the number of records and unique values, and then refine the data further using Power Query. Learn How To Use Copilot to Learn the Data The Data Skills…
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 More