In this project, I took data from reports and moved it into SQLite and Excel using Python. I organized the data in SQLite and used SQL to count how many times customers made payments. I also used Common Table Expressions (CTEs) to make complex queries easier and faster.
This project shows my skills in data handling, database management, SQL, and data visualization using Python and Power BI.
**This is not real data and is not related to any organization. It is used solely as an example for this project.
STEP 1: Question what you want to see on the report
STEP 2: Extract data from the report into SQLite using Python
STEP 3: Extract data from the report into an Excel sheet using Python
STEP 4: Count the frequency based on the number of times customers make payments