Hi,
I've read your requirement. As I've experience in Dimension Modeling I can help you resolve the issues you are getting in the Date Dimension. Please let me know if you are interested.
Here's a brief about me :-
I've overall 15 years of experience in Software Development.
Last 7 years, I've been working on BI projects in Telecom and Realty sector, mostly involved in the creation of ETL ( Data Extraction, Transformation and Loading) packages using Microsoft SSIS for data migration and cleansing form Flat Files(,csv, .txt), Databases (SQL Server, Oracle, Postgresql ), XML files, etc., Dimension Modeling and also involved in development of reports (Tabular, Matrix, Charts, Drill Down and Drill Through reports etc.) and dashboard using SSRS
I've sound knowledge of databases (SQL Server 2016/2012/2008/2005, Oracle 11g, 12c) as throughout my career I've
written many complex sql queries, stored procedures, functions, views etc. also experienced in query performance tuning.
Following are my skill set :
Database/Datawarehouse - SQL Server, Oracle
MSBI : (SSIS, SSRS, SSAS)
Dotnet - C# (core), ASP.Net (core)
Thanks & Regards
Tusar Nandi