LNlorenzo nicholasindatascienceexplanations.hashnode.dev路Oct 11, 2025 路 31 min readM 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...00
LNlorenzo nicholasindatascienceexplanations.hashnode.dev路Sep 17, 2025 路 2 min readCore 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...00
LNlorenzo nicholasindatascienceexplanations.hashnode.dev路Sep 13, 2025 路 13 min readTableau 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: ...00
LNlorenzo nicholasindatascienceexplanations.hashnode.dev路Sep 13, 2025 路 4 min readData 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...00
LNlorenzo nicholasindatascienceexplanations.hashnode.dev路Sep 4, 2025 路 20 min read馃搳 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 ...00
