![]() Here you have a list of the tasks that you should do to implement this solution. He gave us the following Excel file and the objective was, to load all the Sales Rep’s Budget (Sales Rep1, Sales Rep2, …) per Product Family for 2011 (based on fictitious data).īelow I will explain and show one of the possible solutions to this requirement: ![]() In our case we had a meeting with the Sales Manager who wanted to load the 2011 Sales Representative’s Budget into his BI system. Such situations still commonly exist therefore, the purpose of this article is to explain the process to resolve this. xls, etc) which are not as user-friendly. There are existing information systems such as CRM’s (Siebel, etc) and ERP’s (EBS, SAP, etc) where the information is stored in a way in which it is easy to extract information and feed our data warehouses, however a large number of customers still manage their information in so-called flat files (i.e.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |