Using the data available on the website [login to view URL], extract information about the companies operating in your hometown. You will use the financial statements available from the Ministry of Public Finance for at least 4 consecutive years.
To identify the companies in the searched area, it is necessary to use the data from the National Office of the Trade Register, available on the same platform (Extract CUI, Name, Locality / Localities).
Since the financial data are structured in several files, depending on the types of balance sheets of the companies, you will have to make their unions, with the common data from the balance sheet. Then you will make a join with the name and address of the companies, depending on the CUI from the data set processed above.
Use Tableau Prep for all the processing so far and any other cleaning operations you deem necessary.