One of the phases of the project for the implementation of ERP information systems is retrieving data. These can be master data (partners, contacts, pricelists, etc.) or financial data. Most of them are retrieved from the company’s old information system, which is often exported as TXT or CSV files. Excel has a mechanism for retrieving entire files and manipulating data, which will be discussed in the text that follows …
PowerBI Desktop application allows you to import data from many sources: file, database, BI solution, “Big“ (unstructured) data, Microsoft “cloud” (Azure), the web page … Given the fact that there is no good report without quality data I think it is appropriate to devote one recipe especially to this problem. Below, I’ll show you how, with the help PowerBI Desktop you can import, purge and combine various data.
Although Excel is the best software to work with tables, we often create them in other software. Also, tables are commonly used for data exchange, when they are exported as tables in a text file as “Comma Separated Values”. In this file, each row of the table is a separate line in the text, and the values that are in the columns are separated by commas (hence the name). In the text that follows, we will show how to import text from one such file …