How I Set Up My Data Analysis Workflow | Real Example Using Crime Dataset

Описание: 💬 Viewer Question: "How do you usually set up your data analysis environment?"

In this video, I answer that question step-by-step—using a real-world scenario based on incarceration data. I walk you through how I:

✅ Retrieve and prep the data
✅ Create a pivot table in Excel
✅ Build a bar chart to visualize crime types and probation eligibility
✅ Format the final dashboard-style output for reporting

This is exactly how I approach data requests in my job as a government data analyst —and you can follow the same method with just Excel!

📌 We answer this real-world request:
“Can you analyze recent incarceration trends by crime type and probation eligibility?”

🔽 Download the sample dataset I used here: https://tinyurl.com/2k64hr4t

📘 Want to learn Python, SQL & Power BI for data analytics?
Grab my eBook: Data Analytics Kickstart: https://www.datageekismyname.com/ebook

==============================
Support my channel
🔔 Don’t forget to LIKE & SUBSCRIBE for more Python & Data Analysis tutorials!    / @datageekismyname  
☕ Want to Buy Me A Coffee: https://buymeacoffee.com/datageekismy...
Or 💎 Donate on PayPal : https://www.paypal.com/donate/?hosted...
==============================

Thank you for watching!
_________________________________________

⏳ Timestamps ⏳
00:00 Intro
00:38 "What is a Data Analyst?
01:23 A walkthrough for a real-world common workflow
04:28 Reviewing the dataset for preparation
04:48 The question for the requested data
06:23 Removing duplicates in Excel by column
07:19 Reviewing filters for N/A values or Blanks in Columns in Excel
08:10 Create a Pivot Table (Table) in Excel
10:42 How to copy the pivot table with values only and clean it up
12:45 Create a Visualization in Excel from the table
13:27 How to title the Visualization in Excel
14:00 Ending comment

#excel #dataanalyticstraining #pivottables #crimedata #realworldprojects #visualization #exceldashboard #datavisualizationtips

Disclaimer: This content is for educational purposes only. Affiliate links may be included, and I may earn a small commission at no extra cost to you. Thank you for supporting the channel!