Power BI has many connectors that allow you to pull data into the visualization tool. This allows users to have a higher chance of getting their data into Power BI without any additional tools. Today, we’ll be covering one of the most common connectors used in Power BI, Excel. What […]
Blog , Power BI , Power BI Connectors
Posted on:
How to get Excel files data into Power BI
Power BI has many connectors that allow you to pull data into the visualization tool. This allows users to have a higher chance of getting their data into Power BI without any additional tools. Today, we’ll be covering one of the most common connectors used in Power BI, Excel. What […]
Blog , Power BI Basics
Posted on:
How to create relationships with multiple columns in Power BI
Power BI allows you to join data from separate datasets to develop your dashboards. This elevates the work of combining the data in Excel using LOOKUP functions, as it can be done within Power BI itself with a few clicks. If you are unsure of how you can use relationships […]
Blog , Visualization Talk
Posted on:
Tell Powerful Stories with your dashboards by using The F-Shaped Pattern
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:
SUMIFS: What is it, and how to use it in Excel
SUMIFS allows you to add numeric types based on certain specified criteria. Some examples could be finding out the total salary of each department, the number of inventory in a particular warehouse, and your total expenses for the month. It is extremely useful when you have a dataset that can […]
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:
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 […]