Data & Database Workflows (page 7 of 26)
PostgreSQL, SQL, CSV, JSON, Excel, PDF, and conversion pipelines — practical workflows for working with structured data safely.
- How To Connect Excel To A Database
A practical guide to connecting Excel to a database, covering SQL Server and other database connectors, Power Query, refresh settings, credentials, native SQL, ODBC-style legacy options, and common troubleshooting patterns.
- How To Connect Google Sheets To SQL Data
A practical guide to connecting Google Sheets to SQL data, covering BigQuery with Connected Sheets, Apps Script JDBC for MySQL, PostgreSQL, SQL Server, and Oracle, plus refresh strategy, permissions, and common mistakes.
- How To Create Relationships In Power BI
A practical guide to creating relationships in Power BI, covering table structure, keys, one-to-many relationships, filter direction, model design, troubleshooting, and real reporting examples.
- How To Export SQL Results To Excel
A practical guide to exporting SQL results to Excel, covering Excel connections, SSMS result export, SQL Server Import and Export Wizard, CSV fallbacks, refresh strategy, formatting, and row-limit considerations.
- How To Extract Text Before Or After A Delimiter In Excel
A practical guide to extracting text before or after a delimiter in Excel using TEXTBEFORE, TEXTAFTER, LEFT, RIGHT, MID, FIND, and cleanup patterns for business spreadsheets.
- How to Find and Remove Duplicates in SQL
A detailed guide to finding and removing duplicate rows in SQL, including safe workflows, duplicate detection queries, ROW_NUMBER cleanup patterns, and ways to prevent duplicates from coming back.
- How to Find Slow SQL Queries
A detailed guide to finding slow SQL queries, including query logs, execution plans, pg_stat_statements, Query Store, slow query logs, lock analysis, and how to identify the queries that hurt performance most.
- How To Highlight Duplicates In Google Sheets
A practical guide to highlighting duplicates in Google Sheets covering conditional formatting, COUNTIF formulas, duplicate checks, common mistakes, and real reporting and cleanup workflows.
- How To Remove Duplicates In Excel
A practical guide to removing duplicates in Excel covering the Remove Duplicates tool, UNIQUE function, duplicate checking workflows, common mistakes, and real spreadsheet cleanup patterns.