Swiss Bank Analysis
Embedded PowerBi Environment
Details
Problem Statement: Swiss Banking Act, the federal law is most known for Article 47, the specifications regarding banking secrecy. Article 47 makes it a federal crime to disclose the information or activity of clients banking domestically to foreign entities, third parties, or even Swiss authorities without either a) consent or b) an accepted criminal complaint.
This active law makes. After this Law of 1934 was passed, Swiss bankers traveled across Europe to advertise the country's banking secrecy during World War II. As European countries began to increase taxes to finance the war, wealthy clients moved their holdings into Swiss accounts to avoid taxation. Gradually it became a norm for not just Europeans but also other parts of the world to move their accounts to Swiss banks.
Due to this, the Swiss started handling transactions from different currencies, transactions modes and banking modes. Now the problem statement is to interpret what modes of banking have a high impact on swiss bank?
This project includes extracting data from the public database of swiss bank and transforming it into powerbi dashboards.Parameters of this problem statement is currency, types of banking, types of transactions in the span of 10 years i.e from 2012 to 2022.
Dashboards explain the impact of time on the international transactions, the impact of currency on both incoming and outgoing transactions.
Observation: Dollars have a high impact in swiss bank transactions. The value of the Dollar and the market value of the Swiss bank is codependent at least to the owned country, followed by euros, swiss franc and other currencies. There is no serious decline in the transaction. Incoming transactions are higher compared to outgoing and resident banks are more active compared to non resident bank over the 10 years of span.