Dataanalysis - DEV Community

Skip to content

DEV Community

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Aug 26

Excel Tables vs Ranges: What Ctrl+T Actually Changes

#excel #dataanalysis #tutorial #beginners

14 min read

Aug 26

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

#dataanalysis #career #tutorial #beginners

13 min read

Aug 24

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

#excel #dataanalysis #tutorial #beginners

17 min read

Aug 23

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

#excel #dataanalysis #tutorial #beginners

14 min read

Aug 23

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

#excel #dataanalysis #tutorial #beginners

14 min read

Aug 22

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

#python #pandas #dataanalysis #tutorial

10 min read

Aug 22

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

#excel #dataanalysis #tutorial #beginners

12 min read

Aug 22

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

#dataanalysis #career #tutorial #beginners

9 min read

Aug 21

Excel Just Summed Your ID Numbers and Said Nothing

#excel #dataanalysis #tutorial #beginners

6 min read

Aug 21

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

#python #pandas #dataanalysis #tutorial

16 min read

Aug 20

One Row at a Time, or All Rows at Once

#excel #dataanalysis #tutorial #beginners

6 min read

Aug 20

The Finding That Was Just Your Own Definition

#excel #dataanalysis #tutorial #beginners

6 min read

Aug 20

Four Numbers Across the Top Do More Than Four Charts

#excel #dataanalysis #tutorial #beginners

6 min read

Aug 20

Show the Unit Without Breaking the Number

#excel #dataanalysis #tutorial #beginners

6 min read

Aug 19

Chart Design Basics: Take Things Away, Then Point

#excel #dataanalysis #tutorial #beginners

6 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.