Creating a Fact Table that Intersects with Multiple Dimensions Using R and/or SQL

Optimizing Dimensional Modeling for Time Series Data with Multiple Timestamps in SQL Server and Azure SQL Database