In this paper, a multidimensional model and an ETL workflow for blockchain data analysis are proposed. The workflow makes use of state-of-the-art open source tools and traditional data warehousing techniques to implement an extensible and efficient solution for the extraction, transformation, loading, and querying of data. Two scripts are implemented that aim at streamlining the ETL process, therefore simplifying the replication of the workflow to carry out a data analysis. Moreover, an exemplary use case demonstrating the analytical potential of the multidimensional model is presented and evaluated. Finally, strengths and limitations of this approach as well as the potential of future research are shown.