DEV Community

Michael Nocito profile picture

Michael Nocito

Data analyst, eight years of enterprise data migration. I write step by step guides for analyst work and build browser practice kits for SQL, Excel, Python, Power BI and Tableau.

Location Glassboro, New Jersey Joined Joined on  Personal website https://michaelnocito.github.io/analyst-prep-kit/

Work

Data analyst

Your Tableau Dashboard Needs Two or Three Views, Not Eight
michaelnocito profile

Your Tableau Dashboard Needs Two or Three Views, Not Eight

#tableau #datavisualization #dataanalysis #tutorial
Comments
11 min read

Want to connect with Michael Nocito?

Create an account to connect with Michael Nocito. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
Stage 4: Clean and De-dupe
michaelnocito profile

Stage 4: Clean and De-dupe

#dataengineering #database #career #tutorial
Comments
4 min read
The Eight Stages of a Data Migration
michaelnocito profile

The Eight Stages of a Data Migration

#dataengineering #database #career #tutorial
Comments
6 min read
Tableau Sets: What IN and OUT Actually Mean
michaelnocito profile

Tableau Sets: What IN and OUT Actually Mean

#tableau #datavisualization #dataanalysis #tutorial
Comments
10 min read
Tableau Relationships: What the Noodle Actually Does
michaelnocito profile

Tableau Relationships: What the Noodle Actually Does

#tableau #datavisualization #dataanalysis #tutorial
Comments
12 min read
Tableau Concepts, Start to Finish
michaelnocito profile

Tableau Concepts, Start to Finish

#tableau #datavisualization #dataanalysis #tutorial
Comments
19 min read
Tableau Sorting: A Rule That Re-Runs, or an Order You Froze
michaelnocito profile

Tableau Sorting: A Rule That Re-Runs, or an Order You Froze

#tableau #datavisualization #dataanalysis #tutorial
Comments
11 min read
SQL Window Functions: How to Get the Top Row Per Group
michaelnocito profile

SQL Window Functions: How to Get the Top Row Per Group

#sql #database #tutorial #beginners
Comments
15 min read
GROUP BY and HAVING: How to Summarize Rows Without Getting a Fake Answer
michaelnocito profile

GROUP BY and HAVING: How to Summarize Rows Without Getting a Fake Answer

#sql #database #tutorial #beginners
Comments
13 min read
SQL Foundations, Start to Finish
michaelnocito profile

SQL Foundations, Start to Finish

#sql #database #tutorial #beginners
Comments
15 min read
SQL CTEs: How to Build a Query in Steps You Can Check
michaelnocito profile

SQL CTEs: How to Build a Query in Steps You Can Check

#sql #database #tutorial #beginners
Comments
12 min read
Report or Analysis?
michaelnocito profile

Report or Analysis?

#dataanalysis #career #tutorial #beginners
Comments
10 min read
What Is Data Analysis?
michaelnocito profile

What Is Data Analysis?

#dataanalysis #career #tutorial #beginners
Comments
14 min read
SQL Aliases: How to Read a Query Out Loud
michaelnocito profile

SQL Aliases: How to Read a Query Out Loud

#sql #database #tutorial #beginners
Comments
13 min read
How to Verify an AI Agent Actually Did the Work
michaelnocito profile

How to Verify an AI Agent Actually Did the Work

#dataanalysis #career #tutorial #beginners
Comments 1
12 min read
SQL JOINs: How to Join Two Tables Without Losing or Doubling Rows
michaelnocito profile

SQL JOINs: How to Join Two Tables Without Losing or Doubling Rows

#sql #database #tutorial #beginners
Comments 1
17 min read
How to Build a Tableau Dashboard and Story
michaelnocito profile

How to Build a Tableau Dashboard and Story

#tableau #datavisualization #dataanalysis #tutorial
Comments
13 min read
Technical Tenacity: What to Do When the Tools Fight Back
michaelnocito profile

Technical Tenacity: What to Do When the Tools Fight Back

#dataanalysis #career #tutorial #beginners
Comments
6 min read
COUNT in SQL, Explained for Beginners
michaelnocito profile

COUNT in SQL, Explained for Beginners

#sql #database #tutorial #beginners
Comments
6 min read
Entity Resolution: One Real Thing, Many Messy Names
michaelnocito profile

Entity Resolution: One Real Thing, Many Messy Names

#dataanalysis #career #tutorial #beginners
Comments
6 min read
The SQL CASE Expression, Explained for Beginners
michaelnocito profile

The SQL CASE Expression, Explained for Beginners

#sql #database #tutorial #beginners
Comments
9 min read
How SQL and Python Work Together in Data Analysis
michaelnocito profile

How SQL and Python Work Together in Data Analysis

#python #pandas #dataanalysis #tutorial
Comments
5 min read
Why Exploratory Data Analysis Matters
michaelnocito profile

Why Exploratory Data Analysis Matters

#dataanalysis #career #tutorial #beginners
Comments
8 min read
Your Data Is Never Fully Clean, and Analysts Ship Anyway
michaelnocito profile

Your Data Is Never Fully Clean, and Analysts Ship Anyway

#dataanalysis #career #tutorial #beginners
Comments
6 min read
Operationalization: Turning Fuzzy Questions Into Measurable Definitions
michaelnocito profile

Operationalization: Turning Fuzzy Questions Into Measurable Definitions

#dataanalysis #career #tutorial #beginners
Comments
6 min read
Data-Driven Thresholds: Picking Cutoffs You Can Defend
michaelnocito profile

Data-Driven Thresholds: Picking Cutoffs You Can Defend

#dataanalysis #career #tutorial #beginners
Comments
5 min read
How to Handle Large Datasets
michaelnocito profile

How to Handle Large Datasets

#dataanalysis #career #tutorial #beginners
Comments
7 min read
Git and GitHub for Analysts
michaelnocito profile

Git and GitHub for Analysts

#dataanalysis #career #tutorial #beginners
Comments
5 min read
How to Set Up a SQL Database for Beginners
michaelnocito profile

How to Set Up a SQL Database for Beginners

#sql #database #tutorial #beginners
Comments
6 min read
Your First Analysis Is the Role You Are Targeting
michaelnocito profile

Your First Analysis Is the Role You Are Targeting

#dataanalysis #career #tutorial #beginners
Comments
11 min read
How to Comment SQL So It Teaches
michaelnocito profile

How to Comment SQL So It Teaches

#sql #database #tutorial #beginners
Comments
12 min read
loading...