Posts by pwsadmin
Start preparing for CompTIA Data+
Learn more about CompTIA Data + here.
Read MoreData Analyst Apprentice
Data Analyst Apprentice About the Role As a Data Analyst Apprentice, you will transform raw data into actionable insights that support business decisions. You will work with databases, data sets, and basic analysis. You will develop visualizations that can be standalone or part of a larger data effort for dashboards. You will have process automation…
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 MoreProtected: Auburn MBA Program
There is no excerpt because this is a protected post.
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