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 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 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 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 More