Data & Database Workflows (page 20 of 40)
PostgreSQL, SQL, CSV, JSON, Excel, PDF, and conversion pipelines — practical workflows for working with structured data safely.
- How Analysts Can Learn SQL From Excel
A practical guide for analysts learning SQL from Excel, covering mindset shifts, spreadsheet-to-SQL concept mapping, first queries, learning order, Power Query bridges, and how to practice without getting overwhelmed.
- How To Build A Sales Dashboard In Power BI
A practical guide to building a sales dashboard in Power BI, covering data structure, cleanup, measures, visuals, KPI design, layout strategy, and the common mistakes that make sales dashboards less useful.
- How To Clean Messy CSV Files With Power Query
A practical Power Query workflow for cleaning messy CSV files before analysis, reporting, or downstream imports.
- How To Combine Columns In Google Sheets
A practical guide to combining columns in Google Sheets using ampersands, CONCATENATE, TEXTJOIN, and ARRAYFORMULA, with examples for names, labels, reporting strings, and cleaner shared spreadsheet workflows.
- How To Combine Multiple Excel Files With Power Query
How to combine multiple Excel files with Power Query for repeatable reporting and consolidation workflows.
- 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.