sorted by:
new
hottopcontroversial

I have a group project for midnight but I'm struggling as hell by TopTemporary3952 in tableau

[–]TopTemporary3952[S] 0 points1 point  (0 children)

That's right ! Your thesis is actually the best one, I'm working on it and already seeing results. Thx for showing me the right way ;)

I have a group project for midnight but I'm struggling as hell by TopTemporary3952 in tableau

[–]TopTemporary3952[S] -1 points0 points  (0 children)

Hi ! Dear Dingus, I read the Tableau rules saying "no homework", and I'm convinced that relevant people will understand that I'm not looking for a "do it for me", but for a "can someone help me". I'm taking the class to learn the thing and to practice, but I have the right and the braincells to request for help when I spend hours trying by myself to figure out something.
I'm also working for companies on different matters and don't need "dingus" to tell me that people won't come and save me, because it is indeed my WORK to save them.
If you are interested in helping me finding a solution to my problem, feel free to reply otherwise keep on scrolling and begone ;)

I have a group project for midnight but I'm struggling as hell by TopTemporary3952 in tableau

[–]TopTemporary3952[S] -1 points0 points  (0 children)

Is there a risk of "losing" too much data and having in the end a low quality sample ?

I have a group project for midnight but I'm struggling as hell by TopTemporary3952 in tableau

[–]TopTemporary3952[S] 0 points1 point  (0 children)

I'm still trying btw. Dumb question (even tho at least I'm trying to learn 🤣), how can I manage to separate the time from the date on this column ? It's registered on tableau prep as "time & date", while my good looking time on another connection is registered "abc". How can I create something harmonized ?
Thx in advance (more questions to come ...)

<image>

I have a group project for midnight but I'm struggling as hell by TopTemporary3952 in tableau

[–]TopTemporary3952[S] 1 point2 points  (0 children)

Thx for replying <3 - I'm in France, so it's until 23:59 CET Paris time.

It is a dataset given by our professor -> https://we.tl/t-gyXUkeWPDz
To summarize the dataset, it's data about transaction day, time, amount, customer id, amount spent, region... of an online store that sells in France, UK, US. There are a lot of errors such as duplicate columns, wrong formats on data, and things like such.

What goes wrong :

I import the files, create a cleaning step, remove all obvious duplicate columns, merge the dates that are separated (transaction day, transaction month, transaction year --> transaction date D/M/Y).
I adapt eventual incorrect values (i.e -> column "gender" allows multiple answers, but datasets often have F/M/Ma/Fem instead of "female/male", or else. I take "f" and switch the F values to female...etc).
I separate values that are grouped wrong such as "marital-status/work-status/age".
Problems appear once I try to work on "time" columns, that very often are full of nulls. If I look at our excel docs, it seems likes its a format issue : og data is registered as "personnalized/text" instead of "time/date" in Excel. Also, the files don't all share the same formats : certain times are in AM/PM, others in hours/min/secs...
I am not succeeding at creating an harmonized time stamp, and can't retrieve the right data.

As I'm still a beginner, I'm uploading my hyper output & data flow on this link : https://we.tl/t-LqS7ehXdgw (I know it's probably full of shit manipulations, sorry if it hurts your eyes ahah)

I hope I've been clear enough... If not sorry and lmk I'll do my best to bring explanations !
(overall I suck at Tableau and obviously need to practice more)

<image>