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-

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
Add data from website to Power BI desktop

How to add data from website to Power BI desktop

Different webpages are rich source of data. Either structured or unstructured, these data are very useful and can provide good insights. Power BI has recently added and enhanced the existing feature of data extraction from the web. This feature was already compelling, with the recent enhancement it has become even more powerful. In this article ... Read more
Join tables in Power BI desktop

How to join tables in power bi desktop: a practical example

Joining tables is an important feature to combine information from several tables. We can join tables in Power BI desktop with a very nifty merging feature provided with it.. In this article, I am going to demonstrate how to join tables in Power BI desktop with some practical data. The data are all open source. ... Read more
Map visualization in Power BI

How to create a map visualization in Power BI with example

Map visualization in Power BI is a very useful feature to show location-wise values. In this article, I will demonstrate how to use this feature with a practical example. I have used maps a lot with ArcGIS to create boundary maps and display locations as supplementary information. It certainly requires expertise and considerable time. Being ... Read more
Measures in Power BI

How to use Measures in Power BI? a practical example

Measures in Power BI are really a beautiful feature. They are fast in the calculation, has the benefit of reusability. Measures can be applied to multiple tables. We create measures to obtain counts, averages, sums, ranking, percentiles, aggregating year to dates and many more handy calculations. Measures are dynamically calculated. And most importantly it gets ... Read more
Images (1)

How to create data model relationships in Power BI

Data model relationships are the core of Power BI. The report preparation and visualization becomes very easy if data modelling is done well. So here in this article, we will discuss data modelling relationship with a simple example. A common misconception among Power BI users is that Power BI is all about visualization. But that ... Read more
An introduction to Power BI

An introduction to Power BI for data visualization

Microsoft’s Power BI is a very popular and most frequently used data visualization business intelligence tool. This is an introductory article on Power BI which will be followed by a series of practical problem-solving articles. So it will be “learning by doing”. Data exploration and visualization is the most basic yet very important step in ... Read more

How to do Exploratory Data Analysis (EDA) with python?

This article presents a thorough discussion on how to perform Exploratory Data Analysis (EDA) to extract meaningful insights from a data set. And to do this I am going to use Python programming language and its four very popular libraries for data handling. EDA is considered a basic and one of the most important steps ... Read more