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 , 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 , Visualization Talk
Posted on:
The Importance of Storytelling and how to effectively use it in Dashboards
Working 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 next few days identifying the data points and tables I’d require and curated my SQL query for data extraction. Everything was ready, and […]
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 […]