This dataset contains insights into a collection of credit card transactions made in India, offering a comprehensive look at the spending habits of Indians across the nation. From the Gender and Card type used to carry out each transaction, to which city saw the highest amount of spending and even what kind of expenses were made, this dataset paints an overall picture about how money is being spent in India today. With its variety in variables, researchers have an opportunity to uncover deeper trends in customer spending as well as interesting correlations between data points that can serve as invaluable business intelligence. Whether you’re interested in learning more about customer preferences or simply exploring unbiased data analysis techniques, this data is sure to provide insight beyond what one could anticipate
Data Source The Source of this dataset is https://www.kaggle.com/datasets/thedevastator/analyzing-credit-card-spending-habits-in-india
Data Cleaning After getting data import the dataset in mysql with table name : credit_card change the column names to lower case before importing data to mysql .Also replace space within column names with underscore. while importing make sure to change the data types of columns. by defualt it shows everything as varchar.
Data Modelling Import data in Power Bi by connecting mysql and power Bi together with the help of mysql connector.After that basic cleaning ,data modelling process start by adding some keys.
Tools Used Excel,Mysql,Power Bi