Posts Tagged ‘LinkedIn Learning’
Using Remove Duplicates and Distinct Statements
Using Remove Duplicates and Distinct Statements You have a ton of data- it’s just not modeled and workable. You can’t quit. You must learn how to make data from the data you have. Learn How To Use Remove Duplicates & Distinct The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt…
Read MoreAdding data leveraging cross joins
Adding data leveraging cross joins A cross join in SQL is useful for creating all possible combinations of rows from two or more tables. It pairs each row from one table with every row from the other, which is helpful for generating scenarios or testing different combinations. Although it can result in large datasets, a…
Read MoreUsing Case statements for conditional logic in SQL queries
Using Case statements for conditional logic in SQL queries Creating CASE statements in SQL queries is important because it allows you to add conditional logic directly into your data retrieval process. Here’s why it’s valuable:Data Transformation: CASE statements let you transform data on the fly by applying different logic based on specific conditions. For example,…
Read MoreAnalyzing data using a matrix and conditional formats
Analyzing data using a matrix and conditional formats Have an Excel sheet with pivot tables full of data? Want to visualize those in Power BI in meaningful ways? Let Robin step you through the next part of her work making graphs out of (and gaining additional insights from) this booking data. Learn How To: Use…
Read MoreUsing various pivot formats
Using various pivot formats to tell different stories for your presentations Every visual tells a story. Learn how to use Pivots to share different stories on the same data. Learn How To: Use Different Pivot Formats The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt learned different skills, techniques, and…
Read MorePerform basic analysis
Perform basic analysis on data sets No single data set is exactly the same. Learn how to do the basic analysis techniques to learn more about your data. Learn How To: Analyze Data Sets The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools pertaining…
Read MoreUsing analysis commands
Using the analysis commands built into popular tools Most systems have some basic analysis built in to the software. Learn how to take your analysis up a step using these built-in tools. Learn How To: Use Analysis Commands The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt learned different skills,…
Read MoreBasic dates analysis
Using basic dates analysis It’s in the gap you can tell the story. This is a must watch video. This will show you how to gain some great data structure for data that needs to exist. Also, if you don’t know this trick there are reports you are unable to write and dashboards you will…
Read MoreBuilding paginated reports in Power BI
Building paginated reports in Power BI Learn how to quickly build basic paginated reports using PowerBI Report Builder. Learn How To Make Paginated Reports In Power BI 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…
Read MoreBuilding letter size reports for meetings using Power BI Desktop
Building letter size reports for meetings using Power BI Desktop Creating Power BI files that are printable or can be exported as PDF pages adds significant value for meetings and presentations. Here’s why:Accessibility: Not everyone in a meeting may have access to Power BI or the technical skills to navigate it. Printable or PDF reports…
Read More