M Language from Scratch in Power Query for Power BIWhat is Power Query? Power Query is Power BI鈥檚 data preparation layer. It lets you connect, clean, and reshape data from Excel, SQL, CSVs, folders, web APIs, and more鈥攂efore analysis. You build steps once, and Power Query repeats them on every refres...Oct 11, 2025 路 31 min readdatascienceexplanations.hashnode.dev
Core Concepts In Tableau馃搶 Core Tableau Concepts 1. Data Connection & Preparation Connecting to different data sources (Excel, SQL, CSV, Cloud, etc.) Live vs Extract connections Joins, Unions, Blends Data types (string, number, date, boolean) Data roles (dimension vs m...Sep 17, 2025 路 2 min readdatascienceexplanations.hashnode.dev
Tableau Sorting / Grouping / FilteringSorting Quick Ways to Sort in Ascending and Descending Order in Tableau Select the Chart Make sure your bar chart is active (for example, Sales by Sub-Category). Use the Sort Buttons on the Toolbar On the top toolbar, you鈥檒l see two sort icons: ...Sep 13, 2025 路 13 min readdatascienceexplanations.hashnode.dev
Data Analytics exercise 1 with Tableau (CrossFit Games 2019)Introduction In this exercise, real-world CrossFit Games 2019 data will be used to practice preparing, cleaning, and organizing data in Tableau. The connection to multiple data sources will be established, and they will be combined through unions and...Sep 13, 2025 路 4 min readdatascienceexplanations.hashnode.dev
馃搳 Sales Analysis - Power BI End-to-End ProjectIntroduction I built an end-to-end Power BI solution on the Maven Market retail dataset (Canada, Mexico, USA) to turn raw CSVs into an exec-ready sales & product performance dashboard. The objective was simple: answer leadership questions fast鈥擶hich ...Sep 4, 2025 路 20 min readdatascienceexplanations.hashnode.dev
