¶ Data Analytics projects
| Case study | Summary | Domains covered | Tech stack |
|---|---|---|---|
| Case Study 'FRO' 'Financial Risk Optimization' |
How can we accelerate financial risk optimization for complex contracts by streamlining simulations through scalable cloud infrastructure and smart engineering? | #equity_derivatives #pricing #prescriptive_analytics #CRISP_DM #Archimate #parallel_computing #cloud_cost_optimization #distributed_logging |
#python #AWS_EMR #AWS_Glue #Ray #Nginx |
| Case Study 'DDM' 'Delta Data-mining' |
How can we use machine learning and cloud-based data-mining to validate large-scale report discrepancies after a pricing model upgrade? | #feature_engineering #unsupervised_machine_learning #PL_Explain #data_mining #association_rules #Bayesian_statistics #big_data #market_basket_analysis #FPGrowth |
#python #Spark #AWS_EMR #AWS_Glue #KNIME |
| Case Study 'LPS' 'Logic programming for strategies' |
How can we evaluate the performance of various optimization strategies implemented with logic programming, for instance the ones of a popular code-breaking game? | #logic_programming #ontology #knowledge_base #concurrency #prescriptive_analytics #hypothesis_testing #RESTful_API_design #XAI #CRISP_DM |
#datalog #java #python #jupyter |
| Case Study 'ERB' 'Entity-Resolution Benchmarking' |
How can we ensure reliable cross-source entity-resolution, required to build an economic report, by benchmarking several record-linkage solutions ? | #MDM_MasterDataManagement #ML_classification #Confusion_matrix #technology_selection #Concentration_indices #Record_Linkage #Entity_Resolution #String_Similarity #Fuzzy_Matching #Data_Wrangling #CrossSectional_Reporting |
#python #Elasticsearch #KNIME #SPARQL #RDF #wikidata_API #SQL #MSSQL #PowerBI #Archimate |
| Case Study 'TXM' 'Text mining' |
How can we accurately extract data from visually formatted market-sentiment reports (i.e. semi-structured data, with a variable structure) and transform it into structured, machine-readable data for further analysis and integration? | #text_mining #lexers #semi_structured_data #market_sentiment #supervised_machine_learning |
#groovy #regex #CRF_conditional_random_field #C++ |
| Case Study 'MID' 'Musical Instrument Detection' |
How can we assess the effectiveness of algorithms in classifying sounds from orchestral instruments? | #supervised_machine_learning #deep_learning #unstructured_data #DSP #FFT #audio_signal_processing |
#sklearn #python #SVM_Support_Vector_Machines #ANN #MLP_multi_layer_perceptron |
¶ Domain-specific projects
| Case study | Summary | Domains covered | Tech stack |
|---|---|---|---|
| Case Study 'BI' | How can we design a secure online platform for business intelligence that offers lineage and dataset documentation supported by its pipeline-as-code approach? | #Analytical queries #data_pipeline_management #BI_Business_intelligence |
#dbt #duckdb #Lightdash |
| Case Study 'RW' | How can we design an optimized workflow in a Process design editor that integrates manual tasks with real-time activities triggered by external IoT streams like temperature sensors? | #BPMN #Event_driven_applications #Business_rules_engines |
#Camunda #REST |
| Case Study 'HP' | How can we implement a distributed file-processing workflow on a corporate Windows LAN where we are not allowed to install any distributed software? | #map_reduce #semaphores |
#make #redis #windows |
| Case Study 'OD' | How can we design a highly consistent transactional data model using table inheritance in a object-oriented relational database? | #ORDBMS #object_relational_databases |
#postgresql_extensions |
| Case Study 'TD' | How can we design a data model that supports concise time-based queries using data versioning in a relational time-travel database? | #versioned_database #time_travel #temporal_databases #delta_tables #data_warehousing #SCD #slowly_changing_dimensions |
#mysql_extensions #SQL |
| Case Study 'CW' | How can we choose and deploy a software for building a personal portfolio website that offers excellent diagram support, Wiki-style editing, full data ownership, and accessibility from anywhere, while also optimizing for cost and zero-maintenance deployment on the cloud? (this is about this website) | #software_selection #SWAT #self_hosting #web_application #networking #cloud_cost_optimization #VAR_value_at_risk |
#AWS #AWS_fargate #neo4j #graph_database |
¶ Live Analytics projects (web applications)
| Case study | Summary | Domains covered | Tech stack |
|---|---|---|---|
| Case Study 'LR' | How can we develop and deploy a secure, multi-tenant web application on the cloud to track multi-currency bank accounts, integrate with official historical forex rates providers, monitor Cash Forex exposure, and generate Value-at-Risk predictive reports? | #web_application #OpenID_Connect #OIDC #IdP #UML_sequence_diagrams #SaaS #external_API_integration #analytics |
#AWS #AWS_Cognito #Grails #Groovy #Neo4j #Docker #javascript_frameworks #Webix.js #OAuth2 |
| Case Study 'BP' | How can we develop and deploy a secure, multi-tenant, personal task planner web application on the cloud that uses a simulation algorithm to optimize long-term task scheduling, ensuring the best variety within time and proportion constraints? | #web_application #SPA #RESTful_API_design #analytics |
#AWS #Python #Javascript_frameworks #Webix.js #Flask #Docker #Mongodb |
