Tutorial
Hands-on walkthroughs for SQL, Python, Excel and visualisation tools — every example is runnable, not a screenshot.
121 articles in Tutorial · Page 1 of 14
How to Use Concat In Sql: Complete Guide & Examples
Master concat in sql across PostgreSQL, MySQL, SQL Server, Snowflake, and Oracle. Learn CONCAT vs CONCAT_WS syntax, NULL handling traps, and indexing tips.
How to Use Python List To String: Complete Guide & Examples
Master how to convert a Python list to a string using .join(), list comprehensions, map(), and delimiters like commas, spaces, and newlines.
Free Excel Practice Sheets & Datasets: 10 Real Workbooks
Download 10 free synthetic Excel practice workbooks for data analytics. Practice VLOOKUP, XLOOKUP, pivot tables, SUMIFS, and business-style dashboards.
Tableau Marks Card Guide: Color, Size, Filters & Sorts
Master the Tableau Marks Card to control color, size, detail, and visual sorts. Fix disappeared cards, scale big datasets, and build clean KPI scorecards.
Tableau Data Types and Roles Guide
Master tableau data types, dimensions, and measures. Learn how discrete blue and continuous green pills shape visual axes, headers, and query performance.
VSCode SQLTools PostgreSQL Guide
Master vscode sqltools postgresql setup in 4 steps. Connect databases, configure schemas, fix query traps, and run SQL directly in Visual Studio Code.
Free Datasets for Data Analysis: Top Sources & Projects
Best free datasets for data analysis, SQL, and Excel. Direct download links, 5 portfolio project blueprints, and real-world cleaning trap fixes.
Tableau Storytelling With Data: Complete Guide & Examples
Master Tableau storytelling with data. Transform dashboards into executive narratives with live story points, calculated fields, and interview frameworks.
Excel Relative Reference: Cell Formula Guide for Analysts
Master Excel relative reference formulas without drift. Learn relative vs absolute syntax, audit large sheets, and fix calculation errors with ease.