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

Sep 4

Tableau Desktop Foundations Exam: 40 Questions, and 20 Right Passes It

#tableau #datavisualization #dataanalysis #tutorial

10 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

Sep 4

Tableau Aliases: Rename What Readers See Without Touching the Data

#tableau #datavisualization #dataanalysis #tutorial

10 min read

Michael Nocito

Sep 4

Standard Deviation in Everyday Words: What It Measures and How to Read It

#statistics #dataanalysis #tutorial #beginners

17 min read

Michael Nocito

Sep 3

DAX Time Intelligence: DATEADD, TOTALYTD and the Month That Is Not There

#powerbi #dataanalysis #tutorial #beginners

16 min read

Michael Nocito

Sep 3

SWITCH TRUE in DAX: Segmentation, and the Band That Never Appears

#powerbi #dataanalysis #tutorial #beginners

16 min read

Michael Nocito

Sep 3

Star Schema in Power BI: Why One Flat Table Cannot Answer the Question

#powerbi #dataanalysis #tutorial #beginners

16 min read

Michael Nocito

Sep 3

CALCULATE and Filter Context in DAX, Explained on Sixteen Rows

#powerbi #dataanalysis #tutorial #beginners

15 min read

Michael Nocito

Sep 2

Percentiles, the IQR and the 1.5 Outlier Rule: How to Flag a Bad Row

#statistics #dataanalysis #tutorial #beginners

17 min read

Michael Nocito

Sep 2

What Is a P-Value? Worked by Shuffling Nine Real Orders 126 Ways

#statistics #dataanalysis #tutorial #beginners

15 min read

Michael Nocito

Sep 2

Moving Averages: Smoothing a Series Without Smoothing Away the Truth

#statistics #dataanalysis #tutorial #beginners

17 min read

Michael Nocito

Sep 2

Mean vs Median: When to Use Each, and When the Answer Changes

#statistics #dataanalysis #tutorial #beginners

16 min read

Michael Nocito

Sep 1

How Charts Mislead: Eight Distortions, Worked on One Real Table

#datavisualization #dataanalysis #tutorial #beginners

15 min read

Michael Nocito

Sep 1

Forecast Accuracy: MAE, RMSE, MAPE and the Month That Broke One of Them

#statistics #dataanalysis #tutorial #beginners

15 min read

Michael Nocito

Sep 1

Confidence Intervals and the Margin of Error: Built From Four Numbers

#statistics #dataanalysis #tutorial #beginners

16 min read

Michael Nocito

Sep 1

A/B Testing for Analysts: Sample Size First, Result Second

#statistics #dataanalysis #tutorial #beginners

16 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

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

Writing Debut

Want to connect with Michael Nocito?