The Journal
Practical SQL, Python, data science and AI guides, written from real practice — not just to rank.
DAX Fundamentals for Power BI
DAX fundamentals explained: SUM, COUNTROWS, DIVIDE, RELATED, VAR and the X-iterators, with real results from one small Sales…
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,…
Power Query in Power BI Explained
Power Query in Power BI explained: the six merge join kinds, Group By, unpivot, fill down and up,…
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,…
Free Excel Alternatives: Sheets, LibreOffice, WPS
Free Excel alternatives compared: Google Sheets in depth (QUERY, IMPORTRANGE, ARRAYFORMULA), plus LibreOffice Calc and WPS Spreadsheets.
Excel Interview Scenarios, Solved in Excel
Eight practical Excel interview scenarios, from finding a top performer to cleaning messy names, each solved and run…
Excel Shortcuts, Calculation and Sharing
Excel shortcuts, calculation modes, iterative calculation, and sheet, workbook and sharing protection, each demonstrated with real results from…
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…
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…