Data Modeling Issues in Power BI
Budget: $750 – $1,500 USD
The purpose of this project is to fix issues with the data model in an existing Microsoft Power BI dashboard.
I’m currently adding additional functionality to an existing Power BI dashboard, and unfortunately, the data tables have become more complex. I have 2 tables in particular that need to be joined but based on how they’re built, it causes a many-to-many relationship.
Both tables contain similar data but one table contains data at a more granular level. In addition, both tables contain multiple “data series” which means some records can show up more than one time in the data set because they are part of multiple “data series”. This component of the data model causes a many-to-many relationship between the two tables and subsequently causes duplication in the data.
I’m looking for someone with data modeling experience in Microsoft Power BI and handling many-to-many relationships. I will need you to fix the relationship issue and eliminate the duplication in the data.
I’m currently adding additional functionality to an existing Power BI dashboard, and unfortunately, the data tables have become more complex. I have 2 tables in particular that need to be joined but based on how they’re built, it causes a many-to-many relationship.
Both tables contain similar data but one table contains data at a more granular level. In addition, both tables contain multiple “data series” which means some records can show up more than one time in the data set because they are part of multiple “data series”. This component of the data model causes a many-to-many relationship between the two tables and subsequently causes duplication in the data.
I’m looking for someone with data modeling experience in Microsoft Power BI and handling many-to-many relationships. I will need you to fix the relationship issue and eliminate the duplication in the data.