The orientation of any front-end tool will determine how well of an experience your users will feel. A good orientation usually will lead to your users feeling satisfied as they can easilly obtain what they were looking for. On the other hand, a bad orientation will lead to users being […]
Blog , In-built Features , Power BI
Posted on:
How to create relationships between datasets in Power BI
Have 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 not alone. Most visualization tools (including Power BI) introduced this feature of “relationships”, which allows you to connect datasets together. This article will explain […]
Blog , Excel
Posted on:
3 REASONS why you need to learn XLOOKUP in Excel
As a data Analyst, you will be using Excel A LOT. Some examples of its uses could be to validate data within a dashboard, create pivot tables for simple analysis, or even curate dashboards (personally not my favorite). As you use Excel, there will be many things you would want/need […]
Blog , Excel
Posted on:
XLOOKUP: 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 department with the use of their department code, finding the product name from its product ID, and finding the customer’s names that purchased from your shop […]
Blog , Visualization Talk
Posted on:
Fact & Dimension Tables: What is it and how you can use them effectively in data modeling
Data can get very messy. That is why I try my best to categorize my data into two different categories, Fact and Dimension tables. Fact and dimension tables are used by Data Engineers whenever they are formulating schema for a database. However, it can be useful information to a data […]