Posts Tagged ‘Paid Subscription Required’
Using Joins and Update Queries to Create Markers in the Data
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 table allows…
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 Use Append Queries The Data Skills Survival Kit Series If you’re a…
Read MoreUsing union queries to bring together data sets in SQL
Using union queries to bring together data sets 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 Data Skills Survival…
Read MoreBuild conditional functions to make data
Build conditional functions to make data The ability to create conditional formulas in Power BI is essential because it transforms raw data into meaningful, reliable information tailored for specific reporting needs. This capability is key to generating insights that drive informed decision-making and business success. Learn How To Build Conditional Functions The Data Skills Survival…
Read MoreCleaning data from a folder of files in Power BI
Cleaning data from a folder of files in Power BI Each week represents a new set of information for your reports. Learn how to create a report or spreadsheet by pulling data from a folder that automatically adds that data to your report. Learn How To Clean Data From A Folder The Data Skills Survival…
Read MoreCleaning data from a PDF in Power BI
Cleaning data from a PDF in PowerBI Let’s face it- sometimes the only information you have is in a beautiful formatted PDF file. Not to worry, you can clean it like it’s a spreadsheet. Learn how to overcome PDF formatting challenges and build a clean data set. Learn How To Clean Data From A PDF…
Read More