Archive for July 2023
Edit visual interactions
Edit visual interactions Learn how to create interactive dashboards with a few static items that never update. Learn How To Edit Interactions In Dashboards 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…
Read MoreUsing Joins and Update Queries to Create Valuable Markers
Using Joins and Update Queries to Create Valuable Markers in the data Joins can provide you a valuable way to link information, but they can also be used to create valuable markers or fields in your data when you don’t have a field already to use. Learn how to mark data set information based on…
Read MoreBuilding Date Tables in Power BI, Power Query
Building Date Tables in Power BI & Power Query Creating date tables is important in data analysis because they provide a structured way to analyze data over time. A date table includes every date within a certain range, along with details like the day, month, year, and whether it’s a weekend or holiday.Having a date…
Read MoreUsing Make Tables to normalize a denormalized data set
Using Make Tables to normalize a denormalized data set We can’t always control how we receive data. However, once we have that data we can make decisions that will help us better report on the data. Learn How To Normalize Denormalized Data The Data Skills Survival Kit Series If you’re a data analyst, you’ve no…
Read MoreUsing Append queries to combine spreadsheets
Using Append queries to combine spreadsheets You may discover that all your data is siloed into many different spreadsheets even though they contain the same structure. Learn how to create simple appends to create the one data sets you need. Learn How To Append Queries The Data Skills Survival Kit Series If you’re a data…
Read MoreUsing Union Queries to bring together data sets from other tables/views in SQL
Using Union Queries to bring together data sets from other tables/views in SQL Unions can be a valuable concept to understand when your data sets are in different tables or by different unique queries. Learn how to make them consistent to be used in Union queries. Learn How To Use Union Queries In SQL The…
Read MoreIntermediate Power Query
Intermediate Power Query Are you tired of spending valuable time hopping from one spreadsheet to another in search of the data you need for your reports? It can be frustrating and inefficient, causing unnecessary delays and potential errors. But what if there was a better way? What if you could update your data in one…
Read MoreGetting Started with Power Query
Getting Started with Power Query Power Query is a game-changer in Excel. Whether you’re currently using vlookups, concatenates, pivots, or frequently updating data, this course is an opportunity you don’t want to miss.In addition to mastering Power Query, our course provides you with essential skills to effectively manage data in Excel. You’ll learn how to…
Read MoreUnderstanding and Building SQL Queries
Understanding and Building SQL Queries In this course, you don’t need to grasp the entire universe of SQL to master writing great queries. We’ll guide you on a journey towards understanding and confidently building queries. Join us on this course as we break down the complexities of SQL into manageable steps, empowering you to write…
Read MoreGetting Started with Microsoft Power BI
Getting Started with Power BI Dashboards, Smashboards – if you’re only surviving with basic pivots and charts accompanied by slicers, you’re missing out on the amazing tools that Power BI has to offer. It’s time to leave behind the hard way of doing things and embrace a new day of efficiency and productivity! Join us…
Read More