Analyst in Action

In today's blog, we will take a deep dive into the basic functionality of Power BI. We will talk about the types of filters available in the Power BI whether in the query editor or at the visualization level. Let's start with the purpose of using filters that is limiting the rows on the basis of a condition or restrict the data which you don't want to showcase in your visualization. There are many types of filters available in Power BI. We will start with the filters available in the query editor. I am considering the sample superstore data. So, I have imported the Orders and Returns table and we will be applying the filter on the order date. When we select the date filters it will lead to a pop-up where you can select basic and advanced filtering currently I am selecting the advanced version. The filter will limit the data for a particular duration as you can see in the image below. You can remove the filter just by selecting the clear filter. Just to check the code of the...

Have you wondered how to increase the speed while using big data? The basic answer is to bring automation to your workflow. But the question is whether data automation alone is sufficient to improve business performance? In my previous job experience, I have come across this question and my research suggests that both of them need to work together in order to speed up the process while avoiding human errors. If you have recurring data or repetitive datasets which need to fill over different duration then these options prove out to be hefty for any business. Let's get a basic idea of data automation and data optimization before starting the battle. Consider you receive quarterly data and every time you need to enter the data manually and along with it you need to create a visualization from it. This workflow sounds like it will take a couple of days at least to narrow down the time taken and to reduce errors we use data automation. Data optimization is always been a pillar for data ...