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.

Glassboro, New Jersey Joined on Jul 24, 2026 https://michaelnocito.github.io/analyst-prep-kit/

Work

Data analyst

Pinned

Michael Nocito

Aug 12

SQL Foundations, Start to Finish

#sql #database #tutorial #beginners

15 min read

Michael Nocito

Aug 11

How to Verify an AI Agent Actually Did the Work

#dataanalysis #career #tutorial #beginners

13 min read

Michael Nocito

Aug 31

Temp Table vs View in SQL: A Saved Answer or a Saved Question

#sql #database #tutorial #beginners

13 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

Michael Nocito

Aug 31

Subquery vs CTE in SQL: Same Logic, One You Can Check

#sql #database #tutorial #beginners

14 min read

Michael Nocito

Aug 31

Running Total in SQL: The Window Frame That Decides the Answer

#sql #database #tutorial #beginners

14 min read

Michael Nocito

Aug 31

How to Reconcile Two Tables in SQL When the Row Counts Match

#sql #database #tutorial #beginners

14 min read

Michael Nocito

Aug 30

When to Index a Table: A Practical Guide for Analysts

#sql #database #tutorial #beginners

15 min read

Michael Nocito

Aug 30

Funnel Conversion in SQL, and the Step That Shows 100%

#sql #database #tutorial #beginners

14 min read

Michael Nocito

Aug 30

SQL Date Functions: How to Group by Month Without Losing One

#sql #database #tutorial #beginners

16 min read

Michael Nocito

Aug 30

Cohort Retention Analysis in SQL, Step by Step

#sql #database #tutorial #beginners

14 min read

Michael Nocito

Aug 29

How to Set Up DuckDB (Run SQL on a CSV With No Import Step)

#sql #database #tutorial #beginners

10 min read

Michael Nocito

Aug 29

pandas read_csv: Your First DataFrame, and What It Guessed

#python #pandas #dataanalysis #tutorial

14 min read

Michael Nocito

Aug 29

pandas pct_change and cumsum: Percent Change and Running Totals

#python #pandas #dataanalysis #tutorial

13 min read

Michael Nocito

Aug 29

pandas merge: Left Join, Inner Join, and the One That Doubled the Revenue

#python #pandas #dataanalysis #tutorial

13 min read

Michael Nocito

Aug 28

Handling Missing Values in pandas: dropna, fillna and What Each One Claims

#python #pandas #dataanalysis #tutorial

14 min read

Michael Nocito

Aug 28

pandas drop_duplicates: keep='first', and the Row It Chose For You

#python #pandas #dataanalysis #tutorial

13 min read

Michael Nocito

Aug 28

How to Install Tableau Public (And Which Free Tableau You Actually Need)

#tableau #datavisualization #dataanalysis #tutorial

12 min read

Michael Nocito

Aug 28

How to Install Python for Data Analysis (And Why pip install Then Fails)

#python #pandas #dataanalysis #tutorial

13 min read

Michael Nocito

Aug 27

How to Install Power BI Desktop (Including on a Locked-Down Work Laptop)

#powerbi #dataanalysis #tutorial #beginners

11 min read

Michael Nocito

Aug 27

How to Install PostgreSQL for Beginners (And Whether You Need To)

#sql #database #tutorial #beginners

11 min read

Michael Nocito

Aug 27

How to Set Up Jupyter Notebook (And Why Your Environment Is Missing From the Kernel List)

#python #pandas #dataanalysis #tutorial

13 min read

Michael Nocito

Aug 27

How to Import a CSV into Power BI (And the Three Dropdowns Nobody Reads)

#powerbi #dataanalysis #tutorial #beginners

11 min read

Michael Nocito

Aug 26

Where to Find Free Datasets to Practice With (And How to Pick One)

#dataanalysis #career #tutorial #beginners

13 min read

Michael Nocito

Aug 26

How to Export SQL Results to CSV and Excel (Without Wrecking the Data)

#sql #database #tutorial #beginners

10 min read

Michael Nocito

Aug 26

Excel Tables vs Ranges: What Ctrl+T Actually Changes

#excel #dataanalysis #tutorial #beginners

14 min read

Michael Nocito

Aug 26

SUMPRODUCT Explained: Multiply Down, Then Add

#excel #dataanalysis #tutorial #beginners

13 min read

Michael Nocito

Aug 25

Remove Duplicates in Excel Without Losing Data

#excel #dataanalysis #tutorial #beginners

14 min read

Michael Nocito

Aug 25

Power Query for Beginners: The Steps That Run Again Next Month

#excel #dataanalysis #tutorial #beginners

15 min read

Michael Nocito

Aug 25

How to Make a Pivot Table, and Read the Answer It Gives You

#excel #dataanalysis #tutorial #beginners

18 min read

Michael Nocito

Aug 25

Month-over-Month Growth in Excel, and the Month That Is Not There

#excel #dataanalysis #tutorial #beginners

13 min read

Michael Nocito

Aug 24

INDEX MATCH vs VLOOKUP: The Lookup That Survives a New Column

#excel #dataanalysis #tutorial #beginners

17 min read

Michael Nocito

Aug 24

Nested IF vs IFS in Excel: The Order That Silently Relabels Your Data

#excel #dataanalysis #tutorial #beginners

14 min read

Michael Nocito

Aug 24

How to Use IFERROR in Excel, and What It Quietly Hides

#excel #dataanalysis #tutorial #beginners

15 min read

Michael Nocito

Aug 23

Excel Dynamic Arrays: FILTER, UNIQUE and SORT in One Formula

#excel #dataanalysis #tutorial #beginners

14 min read

Michael Nocito

Aug 23

Excel Dates: Serial Numbers, Text That Looks Like a Date, and How to Fix It

#excel #dataanalysis #tutorial #beginners

15 min read

Michael Nocito

Aug 23

Excel Drop Down Lists and Data Validation, and the Paste That Removes Them

#excel #dataanalysis #tutorial #beginners

14 min read

Michael Nocito

Aug 23

Conditional Formatting Based on Another Cell

#excel #dataanalysis #tutorial #beginners

14 min read

Michael Nocito

Aug 22

How to Clean Messy Data in Excel: TRIM, CLEAN and the Space You Cannot See

#excel #dataanalysis #tutorial #beginners

14 min read

Michael Nocito

Aug 22

How to Connect Tableau to Your Data (And What Happens the Moment You Do)

#tableau #datavisualization #dataanalysis #tutorial

11 min read

Michael Nocito

Aug 22

How to Connect Python to a SQL Database (Straight Into a DataFrame)

#python #pandas #dataanalysis #tutorial

10 min read

Michael Nocito

Aug 22

How to Connect Excel to a SQL Database (And Stop Pasting)

#excel #dataanalysis #tutorial #beginners

12 min read

Michael Nocito

Aug 22

How to Review AI-Generated SQL Before You Trust the Number

#dataanalysis #career #tutorial #beginners

9 min read

Michael Nocito

Aug 22

How to Practice SQL Online With Nothing Installed (And Where Your Data Goes)

#sql #database #tutorial #beginners

11 min read

Michael Nocito

Aug 22

Where to Get a Sample Database to Practice SQL (And How to Check It Loaded)

#sql #database #tutorial #beginners

13 min read

Michael Nocito

Aug 22

Customer Segmentation in SQL With CASE WHEN

#sql #database #tutorial #beginners

14 min read

Michael Nocito

Aug 21

Which SQL Database Should You Install?

#sql #database #tutorial #beginners

6 min read

Michael Nocito

Aug 21

VLOOKUP vs XLOOKUP: Which One to Use, and How to Switch

#excel #dataanalysis #tutorial #beginners

13 min read

Michael Nocito

Aug 21

NULL in SQL: Why = NULL Finds Nothing and What to Write Instead

#sql #database #tutorial #beginners

14 min read

Michael Nocito

Aug 21

Month-over-Month Growth in SQL: LAG, the Growth Formula, and the Traps

#sql #database #tutorial #beginners

15 min read

Michael Nocito

Aug 21

How to Find Duplicate Rows in SQL (and Decide What Counts as One)

#sql #database #tutorial #beginners

15 min read

Michael Nocito

Aug 21

Calculated Column vs Measure in Power BI: The Rule That Decides

#powerbi #dataanalysis #tutorial #beginners

14 min read

Michael Nocito

Aug 21

pandas GroupBy: How to Summarize a DataFrame Without Losing Track of Your Rows

#python #pandas #dataanalysis #tutorial

16 min read

Michael Nocito

Aug 21

SUMIFS and COUNTIFS: Add Up Only the Rows That Match

#excel #dataanalysis #tutorial #beginners

12 min read

Michael Nocito

Aug 21

Excel Just Summed Your ID Numbers and Said Nothing

#excel #dataanalysis #tutorial #beginners

6 min read

Michael Nocito

Aug 21

Sort Your Bar Chart or It Means Nothing

#excel #dataanalysis #tutorial #beginners

5 min read

Michael Nocito

Aug 21

Make One Control Drive Every Chart on the Page

#excel #dataanalysis #tutorial #beginners

6 min read

Michael Nocito

Aug 21

SQL Comment Syntax by Database: MySQL, PostgreSQL, SQL Server, SQLite, Oracle

#sql #database #tutorial #beginners

5 min read

Michael Nocito

Aug 21

COMMENT ON TABLE: How to Store a Table Description in the Database Itself

#sql #database #tutorial #beginners

6 min read

Michael Nocito

Aug 21

How to Comment in SQL: -- and /* */, and the Two Traps That Break a Query

#sql #database #tutorial #beginners

9 min read

Michael Nocito

Aug 21

A Pivot Table Is a Question, Not a Report

#excel #dataanalysis #tutorial #beginners

6 min read

Michael Nocito

Aug 21

Percentages Are the Whole Story and Excel Hides Them

#excel #dataanalysis #tutorial #beginners

5 min read

Michael Nocito

Aug 21

Pick the Chart Your Number Already Decided

#excel #dataanalysis #tutorial #beginners

6 min read

Writing Debut

Want to connect with Michael Nocito?