Architected and Implemented a Data Lake for a Big5 Consulting Firm

The customer was looking to digitize their business operations. As a part of that, they were in need of a partner to do a technical proof of concept on Cortana analysis suite (CAS’s) data lake set of offerings. Some of the needs were:

1. Bring in data from multiple cloud tenants into a single location
2. Run Descriptive and Predictive Analytics on those data
3. Establish a regular schedule as well as data organization for the above
4. Need for one consolidated version of data points

Not disclosed

The customer is a part of a global network of professional services firms providing audit tax and advisory services where part of their operations are carried out in Australia.

Aspire did a detailed analysis and brought in the data from different sources into Data Lake Store using Data Factory

1. Used U-SQL for Descriptive, and Azure Machine Learning (ML) for Predictive Analytics. It combines the power of Declarative(SQL) as well as Imperative(C#) programming.
2. Used Azure Data Factory to create multiple Data pipelines for data orchestration and scheduling.
3. Cortana analysis suite (CAS) provided an integrated set of components.
4. Azure ML provided an extensive and extensible set of algorithms, reducing the need to look for an external source.