Identifying Customer Buying Pattern in Power BI – Part 1

This article is part 1 of a retail analytics market-based analysis in Power BI.  In part 1, we will analyze customer purchasing frequency for various products, and the trend across years.

Identifying And Analyzing The Data

We will be using a sales sample file to identify the field elements for customer purchase behavior. You can download this Excel file, which looks like the image below.

According to the sales table, the product identification is Product_Description_Index and the customer identity is Customer_Name_Index.

We will sort the Customer_Name_Index in ascending order to determine the number of times Customer_Name_Index = 1 has