The Blog Passion

Data Science with


Know your data: Explore it's knowledge, insights and pattern

“Without data, you’re just another person with an opinion” ~ W. Edwards Deming

Posts you may like-

Career in data science

A career in data science has a lot to offer, from hands-on learning to the chance to contribute to real-world projects. A career in data science is a highly sought-after and rewarding field that is projected to continue growing in demand. As businesses and organizations increasingly rely on data to make decisions, the need for ... Read more

Machine learning for beginners

Machine learning is a rapidly growing field that is changing the way we interact with technology. It is a method of teaching computers to learn from data, without explicitly programming them. This allows computers to identify patterns and make predictions, making it a powerful tool for solving complex problems. If you’re new to machine learning, ... Read more
Execute R script in Power BI

How to execute R script in Power BI? a comprehensive guide

In this article, I am going to discuss how we can use the analytical and visualization power of the R programming language within the Power BI. We can execute R script in Power BI to create data models, prepare reports, data cleaning, advanced data shaping and analytics, missing data computation, clustering, forecasting and many other ... Read more
Logical functions in Power BI

What are logical functions in Power BI, and how to use them?

The logical functions in Power BI are essential while writing DAX expressions. Logical functions help us in decision making to check if any condition is true or false. Once the data has been extracted through Power Query, these DAX expressions help us to fetch important information from the data. Here is an article explaining the ... Read more
“COUNT” function in Power BI

How to use the “COUNT” function in Power BI?

The COUNT() is an important function in writing the DAX formula in Power BI used. It is one of the time intelligence functions of DAX, which means it can manipulate data using time periods like days, weeks, months, quarters etc. and then use them in analytics. We apply DAX to slice and dice the data ... Read more
An overview of DAX in Power BI

An overview of DAX in Power BI

As the name suggests Data Analysis eXpressions or DAX in Power BI is nothing but collection of operators, functions and constants which we use in writing formula or expressions to return value/values. It is a native language for data analytics tools of Microsoft. DAX is also a highly versatile and functional language with the capacity ... Read more
An overview of Power Query in Power BI

An overview of Power Query in Power BI

Power Query in Power BI plays the role of a data connection technology. It does the data mashup i.e. connect, combine and refine data from many sources to meet the need of our data analysis. Power Query is available in Excel 2016 or later version of Excel. It can also be added in Excel 2010 ... Read more
Forecasting in Power BI desktop

How to do forecasting in power bi desktop?

Forecasting is predicting the future with the help of present and past data. It uses the concept of Exponential Smoothing to predict the future. The Power BI desktop has a very nifty feature of forecasting. This article will describe the process with practical data. The data has been collected from Wikipedia using the data scraping ... Read more
How to use Goal Seek and solver in Excel 2016

How to use Goal Seek and solver in Excel 2016?

Goal seek and solver in Microsoft Excel 2016 are two very important functions. These two help us to perform some back calculations. Among these two, Goal Seek is the simpler one. So let’s start with the Goal Seek function. I will demonstrate the use of Goal Seek with a very practical example. Every one of ... Read more
Create new column from existing column Power BI

How to create new column from existing column Power BI

Create new column from existing column in Power BI is very useful when we want to perform a particular analysis. Many times the new column requires clipping a string part from an existing column. Such a situation I faced a few days back and was looking for a solution. And this is when I again ... Read more