Posts Tagged ‘Paid Subscription Required’
Scripting 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 MoreUsing Remove Duplicates to Find the Latest or Earliest Record in Excel
Using Remove Duplicates to Find the Latest or Earliest Record in Excel You will learn how to leverage multi sort options to retrieve the appropriate record for your data analysis and/or reporting. Learn How To Use Remove Duplicates The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt learned different skills,…
Read MoreAuditing Data and Spreadsheets
Auditing Data and Spreadsheets One keyway to ensure privacy and protection is to audit the files. Look at the file a way another might. Let’s uncover ways to audit a file quickly by using the built in formula auditing tools for the purpose of privacy and protection. Learn How To Audit Data and Spreadsheets The…
Read MoreVisualizing data sets in Outlook
Visualizing data sets in Outlook People are constantly trying to build calendars. Knowing that Outlook reads data in the form of calendars has allowed me for decades to look over time in a calendar view – way before the project ever started. Sure we have systems in place for projects once they are real –…
Read MoreBuilding Data Sets inside of Outlook
Building data sets inside of Outlook Having my data skills means that I look at every program I use as a data machine. That means I am going to put data in it; and take data out of it. Outlook is a key form of communication, and it is a ton of data that you…
Read MoreMapping Data into Other Software Tools
Mapping Data into Other Software Tools Data everywhere – and plenty of places to put it. A key to data survival and well data quality is being able to leverage data for other places without rekeying it in. Learn core concepts for what to look for when importing and exporting data from and to other…
Read MoreDesigning relationships for databases
Designing relationships for databases Learn how to design relationships for a basic database. If you can understand how to create relational designs, then you will understand how to read great designs and deal with bad designs. Learn How To Design Relations for Databases The Data Skills Survival Kit Series If you’re a data analyst, you’ve…
Read MoreCreating a SharePoint back end from a database
Creating a SharePoint back end from a database Learn how to get the most of a relational design and a live database backend at the same time. Not everything you will do will get a large budget, but this technique can be amazing for your process and your project. Learn How To Create a Sharepoint…
Read MoreCreating tables and joins to recode data
Creating tables and joins to recode data There are times where you can’t write a enough replace commands, or conditional statements to clean bad data. Learn how to create a control table to clean data in mass. Learn How To Recode Data The Data Skills Survival Kit Series If you’re a data analyst, you’ve no…
Read More