Datawithzon2023/2024 Premier League Dashboard (w/ Analysis)Manchester United has not been at its best this season, with them getting knocked out of the Champions League in the group stages and not…May 21May 21
DatawithzonPower BI has many connectors that allow you to pull data into the visualization tool.What is Google Sheets?Dec 19, 20231Dec 19, 20231
DatawithzonHow to get Excel files data into Power BIPower BI has many connectors that allow you to pull data into the visualization tool. This allows users to have a higher chance of getting…Dec 12, 2023Dec 12, 2023
DatawithzonHow to create relationships with multiple columns in Power BIPower BI allows you to join data from separate datasets to develop your dashboards. This elevates the work of combining the data in Excel…Dec 5, 20231Dec 5, 20231
DatawithzonTell Powerful Stories with your dashboards by using The F-Shaped Patternhe orientation of any front-end tool will determine how well of an experience your users will feel. A good orientation usually will lead…Nov 30, 2023Nov 30, 2023
DatawithzonHow to create relationships between datasets in Power BIHave you ever found yourself in a situation where you have to create a dashboard where data lies in multiple datasets? If you have, you are…Nov 27, 20231Nov 27, 20231
DatawithzonXLOOKUP: What is it, and how to use it in Excel?XLOOKUP is a lookup function that is used to find things in a table within a column. Some examples could be finding an employee’s…Nov 12, 2023Nov 12, 2023
DatawithzonThe Importance of Storytelling in DashboardsWorking as a data analyst in an MNC, I was tasked to build a dashboard to show the performance of a machine learning algorithm. I spent the…Nov 5, 2023Nov 5, 2023
DatawithzonFact & Dimension Tables: What are they and how can we use themData can get very messy. Especially when everything is consolidated into a single dataset. That is why I try my best to categorize my data…Oct 28, 2023Oct 28, 2023