At DAGTEC we can extract the raw data from your IT systems, cleanse it and transform it into a useful form to analyse and model it. We use a variety of techniques including machine learning. We can find the features and trends in your data and turn them into actionable insights for your business.
Data Warehouse & ETL
In computing the extraction of data and conversion into a proper format ready for analysis is known as Extract, Transform and Load (ETL). At DAGTEC we can extract your data from a multitude of data sources and transform it into a properly formatted and structured data set. This may require data cleansing. This is where we attempt to detect and correct any corrupt or inaccurate data often caused by user entry errors. The resulting data set is then loaded into its final storage place such as a data warehouse ready for data mining. We can also migrate data between various sources and targets, formats and structures.
Data Visualisation
A common form of data visualisation are dashboards which often provide Key Performance Indicators (KPIs) relevant to your organisation. Dashboards typically contain summaries, key trends, comparisons and exceptions using simple to understand plots and tables. A business dashboard is designed to show which parts of a business are operating well and which parts need maintenance. At DAGTEC we can custom design any dashboard or other data visualisation with KPIs useful to your business.
Business Intelligence
Another form of data visualisation is Business Intelligence (BI). The goal of business intelligence is to improve business decision making using facts. BI can be used to identify and develop new strategic business opportunities. BI applications often use data gathered from a data warehouse. A data warehouse contains the subset of business data relevant to decision making. Business Intelligence is often presented as a combination of enterprise reporting, analytics and dashboards. At DAGTEC we have experience building data warehouses and implementing BI applications.
Machine Learning
Predictive data mining or Machine Learning (ML) involves the creation of computer algorithms that can learn from and make predictions on data. Example applications include predicting future customer behavior, online product recommendations and document classification. Machine learning algorithms work primarily on pattern recognition and mathematical optimisation. Machine learning tasks are often categorised into classification, regression or clustering problems. Using machine learning and your data, DAGTEC can help you make predictions.