--- title: "lorenzo nicholas (@lorenzonicholas) | Hashnode" description: "Just Learn. Read the latest articles by lorenzo nicholas on Hashnode." url: "https://hashnode.com/@lorenzonicholas" --- @lorenzonicholas # lorenzo nicholas @lorenzonicholas 路 Joined May 2025 Just Learn ### [M Language from Scratch in Power Query for Power BI](https://datascienceexplanations.hashnode.dev/m-language-from-scratch-in-power-query-for-power-bi?utm_source=hashnode&utm_medium=feed) What 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... 31 min read 路 [datascienceexplanations.hashnode.dev](https://datascienceexplanations.hashnode.dev/m-language-from-scratch-in-power-query-for-power-bi?utm_source=hashnode&utm_medium=feed) [Oct 11, 2025](https://hashnode.com/posts/m-language-from-scratch-in-power-query-for-power-bi/68e9d168baf2d41b28e7fa3a) ### [Core Concepts In Tableau](https://datascienceexplanations.hashnode.dev/core-concepts-in-tableau?utm_source=hashnode&utm_medium=feed) 馃搶 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... 2 min read 路 [datascienceexplanations.hashnode.dev](https://datascienceexplanations.hashnode.dev/core-concepts-in-tableau?utm_source=hashnode&utm_medium=feed) [Sep 17, 2025](https://hashnode.com/posts/core-concepts-in-tableau/68ca90226d03b2c2f4fd2327) ### [Tableau Sorting / Grouping / Filtering](https://datascienceexplanations.hashnode.dev/tableau-sorting-grouping-filtering?utm_source=hashnode&utm_medium=feed) Sorting 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: ... 13 min read 路 [datascienceexplanations.hashnode.dev](https://datascienceexplanations.hashnode.dev/tableau-sorting-grouping-filtering?utm_source=hashnode&utm_medium=feed) [Sep 13, 2025](https://hashnode.com/posts/tableau-sorting-grouping-filtering/68c57df1f3c233f6cf9e7e1b) ### [Data Analytics exercise 1 with Tableau (CrossFit Games 2019)](https://datascienceexplanations.hashnode.dev/data-analytics-exercise-1-with-tableau-crossfit-games-2019?utm_source=hashnode&utm_medium=feed) 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... 4 min read 路 [datascienceexplanations.hashnode.dev](https://datascienceexplanations.hashnode.dev/data-analytics-exercise-1-with-tableau-crossfit-games-2019?utm_source=hashnode&utm_medium=feed) [Sep 13, 2025](https://hashnode.com/posts/data-analytics-exercise-1-with-tableau-crossfit-games-2019/68c524e74660b27fa5ea12c8) ### [馃搳 Sales Analysis - Power BI End-to-End Project](https://datascienceexplanations.hashnode.dev/sales-analysis-power-bi-end-to-end-project?utm_source=hashnode&utm_medium=feed) Introduction 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 ... 20 min read 路 [datascienceexplanations.hashnode.dev](https://datascienceexplanations.hashnode.dev/sales-analysis-power-bi-end-to-end-project?utm_source=hashnode&utm_medium=feed) [Sep 4, 2025](https://hashnode.com/posts/sales-analysis-power-bi-end-to-end-project/68b8f5413507c8b7d2b9c6c7)