Project Goal & Data Description
Excel > AWS > Snowflake > Power BI
**1st Step in MS Excel :**Basic CleaningChange File Type To CSV
Data Pre-Processing Using Excel
**2nd Step [in AWS] :**Bucket Creation In S3Role AssigningPolicy Creation
**3rd step [in Snowflake] :**Create Warehouses, Database, Schema, TableAdvance Data CleaningStorage IntegrationFile Format and Stage CreationPipe-Line CreationNotification Alert CreationStore Procedures CreationTask CreationAlter And Call Task
4th Step [In Power BI] : Build Connection and Extract Data, Transform Data, Load Data, Dashboard Creation
The dataset provides information on the clients, accounts, and transactions of a Czech bank. The original task description of the Discovery Challenge states:
The bank wants to improve their services. For instance, the bank managers have only vague idea, who is a good client (whom to offer some additional services) and who is a bad client (whom to watch carefully to minimize the bank loses). Fortunately, the bank stores data about their clients, the accounts (transactions within several months), the loans already granted, the credit cards issued The bank managers hope to improve their understanding of customers and seek specific actions to improve services. A mere application of a discovery tool will not be convincing for them. In keeping with the original task description, our project goal is to mine and analyze this bank data in order to extrapolate from it the type of customer who makes a good candidate for a credit card.