This was first an OLAP cube system that used my ETL programs to retrieve data from a Cosmos DB NoSQL database, convert it from JSON format to a relational format, and then load it into a SQL Server database where it was cubed by SSAS (SQL Server Analysis Services). Tableau was then used for the reporting tool. Power BI would have been better but that was not an option here unfortunately.
I built the entire system. And I can show some snippets of the system documentation that I also generated here as this being a Federal contract these materials are in the public domain.
This was very useful as I used an OLAP cube to monitor and check the loading of data in another production cube.
I've done this before (such as at AT&T) and it's very useful because you can virtually instantly see the status of all of your data - Is all the data that was expected there? Is some data missing? If so, what data specifically?
This OLAP cube to monitor an OLAP cube is really useful because you can very, very quickly answer all these questions without having to run a series of OLAP or DB queries and then evaluate the results.
Extremely useful in large production OLAP cube systems!
