Key Features
Data Import Wizard
Extracts data from various sources such as data warehouses/lakes, data partners, external sources and client/media agency. Ensures the database structure is properly prepared and aligned for the subsequent modeling and decomposition modules; from simple text files, Excel, R-based Flat file, API feeds, etc.
Data Analysis and Transformations
Data is cleaned, mapped and transformed using tools such as R, Python and Alteryx. Produces correlation matrices across all variables, simple seasonality estimates, univariate model summaries on main endogenous variable, measures and detail management, basic scenario analysis, custom binning, etc.
Integrated Data Reporting
Fully integrated analytical reports and dashboards facilitate rigorous data validation, exploration and deeper data insights. Supports ongoing data reporting for general performance monitoring when ETL process is in place.
Discovery
Interactive discovery of relationships, trends, outliers, etc. for business users and analysts. A broad number of standard charting views that are best-suited to display selected data. Analytical visualizations include time series views across multiple variables, cross-correlation plots, pie-charting investment charts, correlation matrices, line charts with forecasting, aggregation options from daily to annual sums, and much more.
Unified Data Ecosystem
The entire data ecosystem is housed and managed in the secure and scalable Azure Databricks cloud-based platform. Seamless and efficient pipelines are in place to augment the data at periodic intervals as needed for modeling updates. Azure Databricks enables the data platform to be integrated with the modeling engine as well as Tableau and Power BI for post-modeling insights visualization, optimizing the overall process.