title: How to structure/implement multidimensional data / data cube
body: <p>I've been reading into what a data cube is and there are lots of resources saying <em>what</em> it is and <em>why</em> (OLAP/ business intelligence / aggregations on specific columns) you would use one but never <em>how</em>.</p>
  
  <p>Most of the resources seem to be <a href="https://www.lucidchart.com/pages/database-diagram/database-design#section-5" rel="nofollow noreferrer">referencing relational data</a> stores but it doesn't seem like you have to use an RDBMS.  </p>
  
  <p>But nothing seems to show how you structure the schema and how to query efficiently to avoid the slow run time of aggregating on all of this data.  The best I could find was this edx class that is "not currently available": <a href="https://www.edx.org/course/developing-multidimensional-data-model-microsoft-dat224x" rel="nofollow noreferrer">Developing a Multidimensional Data Model</a>.</p>