Power BI: Customer Personality Analysis.
This project was inspired by the Data Science Project on Customer Personality Analysis with Python that was created by Aman Kharwal. I used a dataset that provided on Kaggle. My goal was to create a similar project, but use Power BI instead of Python. I used Power BI and Power Query to prepare/clean data, created fact and dimension tables for data modeling, and connected them with relationships. I also created measures and calculated columns for grouping and the calculation process. Finally, I created the visualizations below to show the results of the analysis.
Please view the sections below and see my DAX for this project on GitHub.
Data Source:
This project uses data provided on Kaggle.
Data Preparation: Power Query, DAX, Modeling
- Data Cleansing and Preparing with Power Query
Original data is in CSV file contains 29 columns and 2240 rows. Connect data source to Power BI then use Power Query to prepare data.
- Create Fact table and Dimension tables
Customer table
Product table
Purchase Type Table
Data Modeling with Power BI Desktop Connect tables together with one to many relationship.
Data Analysis and Reporting
Create Calendar Table, Calculated Columns and Measures with DAX
Example of Calculated table, Calculated Columns and Measures.
Data Visualization:
Use the Histogram, Scatter Chart, Stacked bar chart, Pie chart and Donut chart. Add Cards and Slicer for information of each segment. Finally, add Buttons to navigate drill down information.
Please take a look at some of the other Analytics projects in my Siri Shultz - Power BI Portfolio.
Visit my homepage here: Siri Shultz