About the Customer
Industry: Product Designing
The USA based client is associated with one of the product designing companies which provides excellent and reliable service. By blending technology and design; the organization builds a strong identity for the business and boost customer loyalty. For more than 2 decades, they are at the forefront of creating change through design and delivering measurable value for the clients.
The organization is trusted by millions of users and is recognized by leading industry experts for its excellent solutions. With the most reliable service and designing solution, the organization is serving every type of customer across the USA, China, London, Europe, and many other countries.

Key Challenges
Since the organization is rapidly growing globally for its unique services, it has a large amount of MIS data which was needed to be analyzed and stored in the cloud to get rid of infrastructure management and improve productivity as well. There was a need to integrate data effortlessly in a single form as it was staggered in various data sources.
Data Sources:
- Azure Data Lake: For storing, analyzing and building massive data from business applications
- U-SQL: Analyze BI data for different end users to build own dashboard with ease
- Azure Data Factory: to create data-driven workflows in cloud and ETL processing (to integrate disparate data sources)
- Business Application: to capture the master data and transactions
- 3rd party data source: to capture transactions from different business applications
Key challenges faced are:
- Consolidate the data from OLTP and different 3rd party APIs
- Define Architect design of Azure data lake to store the consolidated data
- ETL processing of consolidated data for BI Analytics using U-SQL
- Timely execution of ETL processing in Azure Data Factory
- Data generation by power user and end user to build customize dashboard itself

Our Solution
SPEC INDIA designed a Business Intelligence solution which helped to develop a customized dashboard. The solution covers the following features:
- Azure data lake service is used to develop data store object irrespective of the data type which helped to gain high performance
- U-SQL, A Microsoft query language is used to develop ETL tool for transforming raw data and storing it in Azure Data Lake
- Tabular Model is created to process the fact and dimension data for end user’s analysis
- Power BI, A Business Intelligence Service is used to build a user-friendly dashboard and report using the tabular model

Tools & Technologies

Business Benefits
- Provides a valuable and useful set of information which improved productivity
- Standardized data across the organization
- Provides detailed information about organization performance through historical data
- Easy and smooth navigation throughout the data reduced complications
- Analysis process became more intuitive which improved business user experience and helped in the better decision making
- A full view of organization data enabled the team to improve focus and facilitated to gain competitive advantage