Posts Tagged ‘Paid Subscription Required’
Use Copilot in Word to build documentation about your data project
Use Copilot in Word to build documentation about your data project Use Copilot in Microsoft Word to assist with documentation and research for data projects. Experience how Copilot can generate tables and lists from text inputs, streamlining the process of creating comprehensive project documentation. Learn How To Build Documentation w/ Copilot The Data Skills Survival…
Read MoreDiagramming Data and Processes
Diagramming Data and Processes Visualizing data inside your head into diagrams can be a key skill. However, to be able to visualize data – you might have to build this skill. Learn keyways to get started and using a variety of tools available to begin to diagram data and processes. Learn How To Diagram Data…
Read MoreBasic visualization of cohort data
Basic visualization of cohort data Visualize cohort data using Power BI to show progression over time. Cover structuring data for visualization and using matrix visuals to illustrate cohort progression. Learn How To Visualize Cohort Data The Data Skills Survival Kit Series If you’re a data analyst, you’ve no doubt learned different skills, techniques, and tools…
Read MoreUsing Remove Duplicates to Create Data Sets
Using Remove Duplicates to Create Data Sets 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 to Create Data Sets The Data Skills Survival Kit Series If you’re a data analyst,…
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 Different Pivot Formats to Share Stories
Using different pivot formats share stories 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 tools pertaining to data. But…
Read MorePerform basic analysis on Datasets
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 built into Popular Tools
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 More