I used CSV files as data sources, extracted them, adjusted the data types, and performed data cleaning using Power Query in Power BI. Then, I modeled the tables into dim tables and fact tables. I also created measures to simplify calculations using DAX, providing a numerical foundation to measure various metrics for each table to meet the business requirements.