Forum Discussion
Janaya1
2 years agoFrequent Visitor
Question on Data Cleaning/Pre-Work
I have a large wide data set (hundreds of columns and each row is a new batch or lot) with data from manufacturing runs and I am trying to set up the data in the most usable way. This is data over se...
parry2k
2 years agoSuper User
Janaya1 It is very tough to answer without looking at the data. The starting point and goal should be to work towards a star schema Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
Maybe if you can share sample data (just create dummy data) with some expected outputs, it will help to provide some details.
Don't share any sensitive information.
- Janaya12 years agoFrequent Visitor
Thank you! I created some fake data and visualizations I'm looking for. I had to end up deleting a bunch of the data to make the character limit for the post but it should still work.