A case study project using SQL Server Integration Service (SSIS), and It's also a DWH implementation concept.
Data, resources, and tools, to help your business thrive. GSMA Services are here to enable companies and organizations within the telecoms ecosystem, to do business together more effectively. As well as to maintain the standards and reputation of the industry. Our services are underpinned by unique, accurate, and comprehensive data. Information, only a trade organization like the GSMA can collate. Especially, when it comes to device intelligence, since we manage the Type Allocation Code (TAC) system on behalf of the industry. The 8-digit TAC forms the first part of the International Mobile Equipment Identity (IMEI), which identifies each individual mobile device and its model specification. The first eight digits of an IMEI make up the Type Allocation Code (TAC). The TAC indicates the manufacturer and model of the particular device. So, all device models from a particular manufacturer will have the same TAC.
This project uses fake datasets related to the field of communication (such as IMSI / IMEI / TAC / SNR), but I would like to highlight this project that reviews concepts and topics that can be applied in any other project, and the part of the field of Tele-communication in this series is extremely limited.
- Extract Data from CSV files.
- Process and transfer data.
- Dealing with data that do not meet the quality requirements like Nulls and missing values.
- Error Handling
- Archive files that have been processed and transferred.
- Auditing the processed data.
