ADS Capstone Chronicles Revised

7

analysis and informed decision-making. The integration of diverse data types into a centralized database facilitates complex queries and data mining, essential for extracting actionable insights. This consolidated data infrastructure supports the overall objective of optimizing operational processes and enhancing the competitive positioning of the business in the market.

Figure 1 Display of Attributes Collected and Uploaded Into Azure SQL Database From Various Operational Sources of Data

necessary transformations such as data cleansing and normalization. These processes prepare the data for seamless integration into the Azure SQL Database. This regular updating and

Periodic data refreshes are used to ensure the dataset remains up to date. Scheduled pipelines extract data from various sources and perform

51