Data & Database Workflows (page 17 of 40)
PostgreSQL, SQL, CSV, JSON, Excel, PDF, and conversion pipelines — practical workflows for working with structured data safely.
- CSV To Excel Cleanup Workflow
A practical guide to cleaning CSV files in Excel with a repeatable workflow covering import, Power Query cleanup, text splitting, trimming, deduplication, type conversion, validation, and handoff into reporting.
- CSV To Power BI Guide
A practical guide to CSV and Power BI covering file import, Text/CSV connector behavior, Power Query cleanup, combining multiple CSVs, OneDrive and SharePoint sync, refresh strategy, and troubleshooting.
- DAX Filter Context vs Row Context
A practical guide to DAX filter context vs row context, covering measures, calculated columns, iterators, CALCULATE, context transition, and the most common Power BI mistakes that come from confusing the two.
- DAX For Beginners
A beginner-friendly guide to DAX covering measures, calculated columns, row context, filter context, CALCULATE, common starter functions, and a practical learning path for Power BI reporting.
- DAX Measure vs Calculated Column
A practical guide to DAX measures vs calculated columns, covering context, row-level logic, model storage, performance tradeoffs, and the most common Power BI design mistakes.
- DAX Single Value Cannot Be Determined Error
A practical guide to fixing the DAX 'single value cannot be determined' error, covering row context, filter context, SELECTEDVALUE, HASONEVALUE, aggregation choices, and common modeling mistakes.
- DAX Time Intelligence Guide
A practical guide to DAX time intelligence covering date-table requirements, classic versus calendar-based patterns, YTD, MTD, prior period, year-over-year comparisons, and common Power BI mistakes.
- DAX Too Few Arguments Error
A practical guide to the DAX 'Too few arguments' error, covering required vs optional parameters, missing commas, broken nesting, common function signatures, and a step-by-step troubleshooting workflow.
- DAX vs SQL For Analysis
A practical guide to DAX vs SQL for analysis, covering source-side queries, model-driven measures, grouping, interactivity, KPIs, time intelligence, and when analysts should use one, the other, or both together.
- DAX vs SQL
A practical guide to DAX vs SQL covering purpose, syntax, use cases, performance tradeoffs, model design, reporting workflows, and when analysts should use one, the other, or both together.