Merging data and building basic calculations into a data set

A woman working on a computer.

Merging data and building basic calculations into a data set Learn how to merge data from different sources and build basic calculations into a dataset. See how to analyze data by creating a comprehensive dataset for further analysis. Learn How To Merge and Calculate Data The Data Skills Survival Kit Series If you’re a data…

Read More

Adding data leveraging cross joins

A woman working on a computer.

Adding data leveraging cross joins We use joins in data to effectively report on data, but have you ever considered using them to create data? When faced with adding repetitive data for a project that applies across the board learn to leverage cross joins. Learn How To Leverage Cross Joins The Data Skills Survival Kit…

Read More

Using date functions to create follow up data

A woman working on a computer.

Using date functions to create follow up data When you have data; you can use it to create valuable data sets to help automate or notify for other processes. Learn how to use date functions to create valuable follow up and notifications data. Learn How To Use Date Functions The Data Skills Survival Kit Series…

Read More

Build letter size for reports using Power BI Desktop

A woman working on a computer.

Build letter size for reports using Power BI Desktop You need all the features of PowerBI desktop, but at the end of the refresh process this information needs to be packaged and sent via PDF. Discover how to adjust your layouts to get the best of PowerBI and meet the delivery requirements Learn How To…

Read More

Build paginated reports

A woman working on a computer.

Build paginated reports Learn how to quickly build basic paginated reports using PowerBI Report Builder. Learn How To Build Paginated Reports 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 sometimes it can be difficult to know when and why…

Read More

Building a brief for a data project

A woman working on a computer.

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 More

Establishing a cohort data set

A woman working on a computer.

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 More

Adding additional data to your cohorts

A woman working on a computer.

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 More

Leveraging the Advanced Editor in Power Query to share cleaning routines

A woman working on a computer.

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 More

Creating simple data sets with basic visuals for presentations

A woman working on a computer.

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 More