Assessment 1: Connecting to BI Marts. This assessment is to test if you are able to create a connection to the data warehousing tools that we use and build BI models on top of it. This is important as all our BI logic is served as APIs on top of DuckDB. Given the above dataset in Assessment 1, create a motherduck warehouse, and import the data into the warehouse. Once data is imported, You can create some random queries to try to understand the data. (Be creative) Bonus: Once you have done some random queries on the imported data, you can connect to a FastAPI api, and expose the results of the queries as APIs. Continue reading...
