Elysiate blog
Practical guides for privacy-first developer tools, SEO and content operations, data and file workflows, cloud and API security, AI engineering, and sustainable freelance work. Everything here supports the same philosophy as our browser-based utilities: your data stays on your device until you choose otherwise.
Page 12 of 49
- 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 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 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 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 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 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 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 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.