New: 6 free SQL practice datasets with 300+ questions — try the SQL Compiler →
Free · No signup needed

The Journal

Practical SQL, Python, data science and AI guides, written from real practice — not just to rank.

Power BI

DAX Fundamentals for Power BI

DAX fundamentals explained: SUM, COUNTROWS, DIVIDE, RELATED, VAR and the X-iterators, with real results from one small Sales…

October 5, 2026 10 min read
Power BI

Power BI Data Modeling and Relationships

Power BI data modeling explained: star versus snowflake, which way a filter actually travels, many-to-many and bridge tables,…

October 5, 2026 11 min read
Power BI

Power Query in Power BI Explained

Power Query in Power BI explained: the six merge join kinds, Group By, unpivot, fill down and up,…

October 5, 2026 12 min read
Power BI

Power BI Basics: Desktop, Service and Mobile

Power BI basics: Desktop versus Service versus Mobile, the publish workflow, Import versus DirectQuery, and what a dataset,…

October 3, 2026 11 min read
Excel

Free Excel Alternatives: Sheets, LibreOffice, WPS

Free Excel alternatives compared: Google Sheets in depth (QUERY, IMPORTRANGE, ARRAYFORMULA), plus LibreOffice Calc and WPS Spreadsheets.

September 27, 2026 12 min read
Excel

Excel Interview Scenarios, Solved in Excel

Eight practical Excel interview scenarios, from finding a top performer to cleaning messy names, each solved and run…

September 27, 2026 13 min read
Excel

Excel Shortcuts, Calculation and Sharing

Excel shortcuts, calculation modes, iterative calculation, and sheet, workbook and sharing protection, each demonstrated with real results from…

September 27, 2026 13 min read
Excel

Excel Power Query and Data Model Explained

Excel Power Query and the Data Model explained: Applied Steps, common transformations, relationships versus VLOOKUP, and a first…

September 27, 2026 10 min read
Excel

Excel What-If Analysis: Goal Seek, Data Tables

Excel What-If Analysis explained: Goal Seek, one and two-variable Data Tables, Scenario Manager, and when to use Solver…

September 27, 2026 10 min read
Scroll to Top