This repository a compilation of notes and tools for data warehousing, the ETL process, and data visualization for educational/experimental purposes only and not intended to be used as a base for an actual Business Intelligence workflow.
- Designing a data warehouse
- Elasticstack in a nutshell
- Extract Transform Load
- Bringing it all together
- Perspective
- Identify a business case and design a data warehouse
- Find/Create multiple data sources to operate on
- Prepare a MySQL/MariaDB data source
- (optional) Prepare a csv file
- Setup an Elasticsearch stack
- Setup Elasticsearch
- Setup Kibana
- Setup Logstash
- Prepare a quick start POC
- Design the data warehouse
- Prepare an ETL process
- Create dashboards/cubes in Kibana
- (optional) Make reports
- Makefile is responsible for interacting with the compose files.
- The requests.http file is used with REST Client to test requests against Elasticsearch.