Forum Discussion
How to model soccer data ?
My suggestion is that you send me your PBIX file so you can save time for and for you.
My guessing is that you are trying to build a Dataset off your guessing 🙂
Sure! The only thing a made up is reducing the dataset the minimum required and switch from local league handball to public soccer 😀
Please see attached the dataset with english headers ...
My issue with this is that the datamodel somehow is bad practice because different way of filtering cannot be accomplished with just a lean data table setup.
Remark: this is considered to be a proof of concept and not the final dataset. that's why power query steps are a little messy 😉
Datasat: https://1drv.ms/u/s!AhmA5aJ6VboGhOswCkcY0CS-PJ_TrQ?e=gTLS8B
First, Hi Germany 😉 and you can name it Football instead of soccer, am originally from Tunisia 😀.
Second, thank you for sharing your file because it's gonna be easier for me to help you.
Now, I have to say that your Model is not quite optimised
You need to look to obtain a Star Schema with correct Relationships. A Star Shema will make life easier to develop a good report.
So what is the issue you are facing? How can I help you? I still didn't understand what's your point! Can we do this step by step and show me by screenshots the desired Outcome?
Alright, thanks Amine!
Actually, I have really issues in describing the problem that exists in my head. I know about the star schema and it worked for almost every other data model I have built, but just for this one I really struggle ...
Maybe I rephrase my question and I go one step back again:
1) I have raw data as provided in FT_Ticker and FT_Games (or maybe it's a dimension table - let's see). All of the rest is done by myself during ETL.
2) What would you propose if I want to answer the two questions in one datamodel:
-> Please show me all games for one specific team?
-> If I have one match identified, how can I see the liveticker for this match?
I guess by answering those two questions you'll face my challenge.
Nico
OK, To begin with here is a good model
To answer your first question the model allows to select a team a see the matches and the event for each player.
HOWEVER your model and Tables are missing a very important Fileds which are the "Dates". All supposedly Fact tables FT_Games , FT_Games-unpivot and FT_Ticker are all missing column dates, Like when did this match occure, when did this player have a yellow card... also to see the ticker in Live mode when the match is on you would need another type of connection to the FT_Ticker, like Direct Query mode. Last but not least the FT_Ticker table needs to contain a column for the GameID in order to know "This Player had an Event in what Game at what Date". These columns must existe somewhere, keep digging my friend.
Hope this is your first step to glory 🙂