HOANG HOANG THUC

Define the business needs: Finance - We is trying to evaluate the a consumer's creditworthiness (based on historical financial and personal information). Solution: We will need to aggregate data based on transition, customer, jobs, addresses and date. It will be evaluated based on credit score (historical financial and personal information) To do: Create Finance dummy data by Python, use SSIS to ETL raw data and build data warehouse on MS SQL, migrate SQL database to Snowflake cloud database. Finally, visualize data on PowerBI.;

Business Scenario: E-commerce Service Company A is one of the large e-commerce companies capable of providing international products to customers. Items shipped domestically need at least 14 days of inspection before shipping to customers. Some products are stocked before and can be delivered to customers in a short time. To be able to supply products on company A well, it needs to have good supply warehouses for customers. Including warehouses in many provinces before shipping to customer addresses (districts, districts, wards). Which issues need to be calculated ? To do: Create E-commerce dummy data by Python, use SSIS to ETL raw data and build data warehouse on MS SQL, migrate SQL database to Snowflake cloud database. Finally, visualizedata on PowerBI. ;