BEST END TO END DATA ANALYTICS PORTFOLIO PROJECT

BEST END TO END DATA ANALYTICS PORTFOLIO PROJECT | TABLEAU & PYTHON

Рет қаралды 108,462

Күн бұрын

GET YOUR DATA JOB ➡ mochen.info/
ULTIMATE DATA PORTFOLIO: Everything you need to get your data job ➡ mochen.info/ultimate-data-por...
PATREON: Even more detailed data analysis content ➡ / mo_chen
1:1 MENTORSHIP PROGRAM: I put my heart and soul into this program. I'm here to help you succeed ➡ mochen.info/1-1-mentorship-lp/
CourseCareers: Start the FREE Data Analytics Introduction Course Now ➡ coursecareers.com/a/mochen?co...
Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡ • Portfolio Projects
┋Community & Socials┋
/ discord ⬅ Join our Discord Data Community
/ mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
/ mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
/ mo_chen_1 ⬅ Figuring out what I want to do in this space...
┋Professional Certificates┋
CourseCareers ➡ coursecareers.com/a/mochen
DataCamp Courses & Certifications ➡ datacamp.pxf.io/c/4216860/111...
Google Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Google Advanced Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Tableau Business Intelligence Professional Certificate ➡ imp.i384100.net/TableauBIAnalyst
Microsoft Power BI Data Analyst Professional Certificate ➡ www.coursera.org/professional...
IBM Data Science Professional Certificate ➡ imp.i384100.net/IBMdataScience
Google Project Management Professional Certificate ➡ imp.i384100.net/GoogleProject...
┋Timestamps┋
00:00 Intro and the dataset
02:04 Data gathering, exploration and manipulation
06:55 Tableau visualisations summary
08:18 Moving average visualisation
16:18 Total rides visualisation
18:04 Temperature vs wind speed heatmap
20:02 Weather and hour bar charts
22:32 Formatting the worksheets
30:14 Creating the dashboard
36:45 Recap of the project
38:21 Outro
┋The project┋
Link to the github repository (contains all of the files you need to follow along or re-create the project at home) ➡︎ github.com/mochen862/LondonBi...
Link to dataset on Kaggle ➡︎ www.kaggle.com/datasets/hmavr...
Link to the London Bike Rides Tableau dashboard ➡︎ 📈 public.tableau.com/app/profil...
Thanks so much for taking a little time out of your day to watch this!

Пікірлер: 241

@kavitvichhivora7025 Жыл бұрын

Just made me realize how important it is to learn Tableau

@mo-chen Жыл бұрын

Hi Kavit, it is very important indeed to be able to visualise your data. Thanks a lot for watching!

@rodrigohernandez5537 Жыл бұрын

Hey Mo, I´m based in Mexico and I recently stumbled with your chanel. I got to say your content is amazing and you have really inspired me not to give up on my journey to become a Data analyst. I have very little experience with tools like Excel, Python and SQL but I think Im getting there(I started about 3 months ago). Thanks for all the free content!

@mo-chen Жыл бұрын

Hi Rodrigo, I’m so glad to hear this! One of the reasons I started my channel was to help and connect with like-minded people : ) Thank you so much for watching and all the best with your journey!!

@itsbearableforthisweek Жыл бұрын

Hey, you are doing such a great job! I love how easily I am able to understand your videos. Keep up the good work, THANK YOU.

@mo-chen Жыл бұрын

Hi proncy yolo, I'm so glad you get value out of the video. I will certainly try my best to keep on creating good content. Thanks so much for watching : )

@donaldokorejior1981 6 ай бұрын

Was the first time I was able to follow a project through from start to finish. Much appreciated Mo 👏

@mo-chen 6 ай бұрын

Glad I could help!

@pilarreyes6839 11 ай бұрын

Thank you for your videos Mo. They are very relevant and interesting. I can't imagine the amount of work behind editing all this content, great job!😊

@mo-chen 11 ай бұрын

Thank you so much for watching and for your kind words! It does take quite a bit of time to edit all these videos, but it is definitely worth it for comments like this one 😁

@pacarkendra-ik8cl 4 ай бұрын

thank you so much! as a newbie this video helps me a lot to learn about tableau!

@TA_Tactics 4 ай бұрын

That was an amazing walkthrough.👏

@clarielealmeida6225 Жыл бұрын

It's incredible!! Thank you!!

@mo-chen Жыл бұрын

Thanks a lot clariele 😃

@c0s1m4 Жыл бұрын

Your explainations are so clear, thank you for your efforts. :)

@mo-chen Жыл бұрын

Hi C0S1M4, I’m glad you found it easy to follow, thanks for watching!

@elghark 5 ай бұрын

Tableau part was a hell to follow. Damn....

@juliom3552 Жыл бұрын

I learnt more with this video that with full online courses. Great work and thank you.

@mo-chen Жыл бұрын

I'm glad you found the video useful! Thanks a lot for watching Julio 😃

@duonghoangbang2106 Жыл бұрын

Thank you a lot, I will be your fan in many next videos!

@mo-chen Жыл бұрын

Thanks so much for watching 😃

@ufukeskici 3 ай бұрын

Firstly, this is a very good portfolio project. Thanks for sharing. But why there is so rush in this video (also same for your other videos)? I expect more explanation for the details especially for the formulas in Tableau.

@user-ls4xk3zd6n 7 ай бұрын

Hello Mo! 1. Thank you SOO much! You literally open my eyes to data analytics and I'm now on my way to sending cv's to land my first data analyst job. 2. I love the way you explain, and your videos overall, however, I'm clueless as to how you connected the dataset to the Visual Studio Code? I'm really keen on following your videos, and you've been of great help. Thanks in advance

@pew2pao459 Жыл бұрын

awesome stuff! thank you

@mo-chen Жыл бұрын

I'm glad you liked it, thanks for watching 😃

@denidota6393 5 ай бұрын

Superb content.. I really appreciate it.. Thankyou so much

@krystledianne3707 Жыл бұрын

I'm studying Data Analytics, your videos are amazing! Keep going Mo. I learn a lot from your videos.

@mo-chen Жыл бұрын

Hi Krystle, I will try my best to keep on delivering great content! I'm so glad you get value out of the videos, thanks so much for watching : )

@johnadoga9765 4 ай бұрын

i'm studying too, what's your linkedin let's connect?

@brianhooch Жыл бұрын

I Really appreciate this kind of content, wish to find more like this, new follower

@mo-chen Жыл бұрын

Hey Brian, I’m glad like the content! I wish to make many more, thanks a lot for watching: )

@koa1663 6 ай бұрын

Hi Mo, absolutely love your content and it has helped me so much as a recent Computer science graduate. I just wanted to ask how you document your data and analysis for the projects and add it to your portfolio ?

@skylertaylor1970 8 ай бұрын

Thank you so much Mo!

@mo-chen 8 ай бұрын

I'm glad you liked it! Thanks for watching 😃

@geet7594 Жыл бұрын

Hi MO.. Thank you so much for this content. Appreciate your effort. I have been working in the data world for quite a few years now mostly into the ETL side. Now I have planned to take DA seriously and am going for masters this Sept. Would refer your videos for my homework 🙂

@mo-chen Жыл бұрын

Hi Geet, thanks so much for watching and all the best with your master’s degree : )

@oguduabrahamonyedikachisen8554 Жыл бұрын

what school are you enrolling in for masters though?

@prashlovessamosa Жыл бұрын

This is gold.

@mo-chen Жыл бұрын

Hi Prashant, I’m glad you found it useful! Thank you so much for watching : )

@TheMISBlog Жыл бұрын

Very useful video, Thanks

@mo-chen Жыл бұрын

Hi TheMIS Blog, thanks so much for watching!

@Chanezk Жыл бұрын

a big thank for your help !

@mo-chen Жыл бұрын

Thanks for watching Chaz_life 😃

@Chanezk Жыл бұрын

@@mo-chen keep moving on 🙌

@Faisaljaffer Жыл бұрын

Thank You MO ♥

@mo-chen Жыл бұрын

Hi Faisal, no problem at all! Thanks for watching : )

@eduardofreire3387 4 ай бұрын

Can I use it on power bi? Sorry for this kind of question, it might be obvious. I intend to follow the step by step. Thank you for sharing this knowledge! Hugs, Eduardo | São Paulo | Brazil

@trediaz4012 Жыл бұрын

I'm going to watch your videos back-to-back when I get a chance. I am working on becoming an analyst. I should be completing the Google cert abd GS AA degree in May. Afterwards, I am planning to attend WGU for their DA Bachelors. After that, I'll go to Texas State for their Masters DA

@mo-chen Жыл бұрын

Hi Tré, thank you so much for watching : ) Sounds like you have a great plan already, I wish you all the best on your studies and learning!

@datawit 10 ай бұрын

Hey Mo, thanks for the amazing content of creating this fantastic data visualization! I have learned a ton!! I have included this form into my portfolio project, but I am trying to find another dataset for it. By any chance, do you have any suggestions on which dataset also go well with this type of visualization?

@mo-chen 10 ай бұрын

Try looking on Kaggle 😄

@yerocastrocontabilidad Жыл бұрын

Very interesting .😊

@mo-chen Жыл бұрын

Thanks Yero 😁

@zabashhd459 9 ай бұрын

Perfect do some more projects like this

@mo-chen 9 ай бұрын

Already have 😃 Check out this playlist!

@thuglaza4728 Жыл бұрын

When you hit a 100k subs do an analysis on your KZfaq statistics lol. Joking aside, I just found your channel and the content really good. I hope you will continue this. Learning a lot from you 🙌

@mo-chen Жыл бұрын

Hi THUGLAZA, thanks a lot! I will certainly try my best to deliver useful content. Thank you so much for watching!

@h_k369 27 күн бұрын

nice video

@user-nx2xb5xc5s 5 ай бұрын

you are the best

@mayoLJS 2 ай бұрын

Hey Mo, great visualization, can I achieve this with power BI and if so, can you help with tutorial?

@thekushalgaikwad Жыл бұрын

Awesome. Easy to understand. It was exciting to follow along. By the way, Which keyboard key are you pressing at 7:33 to highlight the area?

@mo-chen Жыл бұрын

Hi Kushal, I’m glad you liked the video, thanks a lot for watching! I’m pressing the Control key, it’s a feature that I use within PowerToys.

@iman.ezatfar 3 ай бұрын

Hey there, Thanks for your video. I have a problem in my dashboard, when I change day to week and month, everything changes but I cannot see my line chart, although I can see the period line, but no line ! why?

@patrickmandengue5813 11 ай бұрын

Hey Mo, just to tell you that I am your first fan, I really appreciate your video and by the way I wish to meet you on day Initially, I am an auditor, financial analyst with FMVA in course, and since I saw your video I started studying Data Analysis To vis CFI that is Business Intelligence Data Analyst (BIDA)

@mo-chen 11 ай бұрын

Thanks a lot for watching and all the best with your data analysis journey 😃

@RohitSingh-pd7zr 11 ай бұрын

Hey Mo, thanks for the video. Obviously, very informative video on how to build your portfolio.

@mo-chen 11 ай бұрын

I’m glad you liked it, thanks for watching 😃

@meghanshrao5878 Ай бұрын

Could you help me understand why are we using min month and max month as details in every other worksheet?

@Jobfynd1 9 ай бұрын

We need more projects 👍

@mo-chen 9 ай бұрын

There are numerous other end to end Excel, Tableau and Python projects and analysis on the channel. Feel free to check them out!

@mattlee3296 4 ай бұрын

I want to follow along and try out this tutorial but I'm struggling really hard with the VScode part. I tried following step by step and installed Python on my PC but none of the code is working. Could you please explain how you were able to get the Python code working? Thank you.

@Lant3an 3 ай бұрын

Hey, I’m really curious how much of an impact does knowing R have in DA job rn, I’ve been learning it but I just have feeling that this is not as important as python for instance, what’s your opinion ?

@ramrod5972 7 ай бұрын

whats your visual stuido settings like? I keep getting errors when running your examples.... for example: FileNotFoundError: [Errno 2] No such file or directory: 'C:\\Users\\15598\\Downloads\\Portwebsite\\Untitled-1' PS C:\Users\15598\Downloads\Portwebsite>

@maxmat_ Жыл бұрын

Hello! Amazing video! Could someone answer why the moving average period feature does not work when compile dashboards into story? The line does not change the color based on the set highlighted and reference band does not appear as well. Thank you!

@mo-chen Жыл бұрын

Hi Maksym, thanks a lot for watching! It’s because you haven’t changed your action to a dashboard action yet. Watch the bit that starts at 35:27, that will solve your problem.

@billyxxmario Жыл бұрын

Hi MO, thank you for your effort to make this video, can I ask something? Did you do the data preprocessing before? Like duplicated data elimination and missing value handling? By the way, I already subscribed you immediately 😁

@mo-chen Жыл бұрын

Hi Mario 👋 The data was already clean when downloaded from Kaggle. But you're right, you should always check for duplicated values and decide how to handle missing values. Thanks a lot for watching 😄

@Idontthinkilive 7 ай бұрын

Hello Mo, How can i put my dashboard to my resume?

@mayurghadge9442 Жыл бұрын

Thanks this was a great video! I had a question, why was the 'Moving Average Period Set' was created? What is it's objective?

@mo-chen Жыл бұрын

Hi Mayur 👋 The set is created so we can differentiate between what time period we actually select vs what we do not select (i.e. what we highlight vs what we don't). Thanks a lot for watching 😁

@samarthgupta2358 Жыл бұрын

HI Mo, great tutorial as always! keep the good work up. The only think I feel that lack in this project was to know why we are doing, what we are doing, i.e. why we selected moving average period with count or why min or max, because i also want to know the thought process of a Data Analyst. Please suggest some course or book to actually think like an Analyst.

@mo-chen Жыл бұрын

Hi Samarth 👋 Thanks for the very constructive feedback! I don't have a specific book or course that I can recommend on thinking like a data analyst unfortunately. The thought process for me developed throughout the years from all of the learning I've undertaken. Learning more about data visualization can help you a lot with choosing what metrics to show and how.

@israelgodwin7376 11 ай бұрын

@@mo-chen I agree with him Mo. I really don't know why we're doing somethings (like creating the fields, sets and adding actions) and I got confused or lost when highlighting the moving averages. But I must say, you create good contents Mo. I like your video. Thank you.

@mo-chen 11 ай бұрын

@@israelgodwin7376 I'm sorry you got confused. Is there anything specific I could do in my delivery to make it easier for you to follow?

@user-uh2sk3vw2r Ай бұрын

Hi Mo, how would you create the same in Power BI?

@piyushkale4574 5 ай бұрын

Hey there!! I am getting error while creating a calculated field for moving average period. Can someone pls help me out here

@tommyhutomo4763 7 ай бұрын

Impressive tutorial! I want to ask something, after you create a dashboard like that, how to present it to your boss? You make it as a power point?

@mo-chen 7 ай бұрын

I send the actual link to the Tableau dashboard 😁

@yutahebihime 5 ай бұрын

I didn't get how { SUM(INT([In Range] * [Count]) } calculates the number of bike rides

@croldan20 11 ай бұрын

Thank you for your video Mo. I don't understant the conditional in order to calculate the minimun month ( if [Moving Average Period set] then [Moving Average Period] END ) Can you explain this to me please? Thank you!

@mo-chen 11 ай бұрын

You need this calculated field to be able to select the highlighted values only on the line chart using your dashboard action. Thanks a lot for watching 😁

@srofficial803 Ай бұрын

Can we visualizing in google collab instead of Tableau.

@shubhamshigwanrollno.4327 Жыл бұрын

Hi MO.. Great explanation loved the video, actually, I am fresher in this field and I want to build projects for python, SQL, and powerbi can you please suggest some projects for each so I can add to my resume

@mo-chen Жыл бұрын

I'm glad you liked the video! I don't currently have any other project videos, but I definitely plan on making more. So for now, my advice would be to find something interesting on Kaggle and use that data for the basis of your project. Thanks a lot for watching 😄

@salswain63 4 ай бұрын

hey this is a cool project but itd be better it you do the VScode part step by step instead of just going over what you had already done so we can connect the dots from the beginning.

@nobodylovesme6428 10 ай бұрын

Beautiful! I’m sorry if i missed the point. This is how you do thing(technicaly) but i feel like i don’t understand what is the main point of this dashboard and what do they want from from it? Sorry I’m new.

@mo-chen 10 ай бұрын

Don't apologize, it's a great question! In this video, I wanted to show you an end-to-end project where you gather the data, clean and transform and then produce a dashboard because often times as a data analyst - you'd have to do similar processes at work.

@nobodylovesme6428 10 ай бұрын

@@mo-chen Thanks for your response. It would be great for someone new in this field like me if i understand the purpose of visualizations and why we choose this type of viz or chart for that data or relation. I think this video is not for beginner but it is very good and your dashboard very beautiful with the color u choose. I hope more videos will come soon. 👌🏻

@mo-chen 10 ай бұрын

@@nobodylovesme6428 I made a video on Data Storytelling. Feel free to check it out, it'll give you insights on why and how we present things the way we do.

@nickdao5480 10 ай бұрын

I'm having trouble creating the sum by hour visualization. When I drag Time into rows as a discrete field by hour, it creates rows for each hour on each day instead of hours 0-24. What am I doing wrong?

@mo-chen 10 ай бұрын

Without seeing what exactly you've done up to the point, it's really hard for me to tell what went wrong 😅 Maybe you could try again from scratch as the visualizations definitely work as long as you follow closely.

@johnadoga9765 4 ай бұрын

I followed your steps while inputting the datetrunc() but it's showing "the calculation contains errors", i'm not seeing help online, any guide on how to pass that, i'm stucked!

@jamesb-yj9cc 2 ай бұрын

make sure lowercase day/month/year in the parameter part

@mauricecolon4359 Жыл бұрын

Good Videos, straight to the point but they lack the why behind the methodologies. Honestly there not too beginner friendly. I wish I could send my cohorts to your tableau videos. But keep up the content I enjoyed it overall...

@mo-chen Жыл бұрын

Hi Maurice, thanks a lot for the feedback. I'm glad you liked the content overall! The way I structure my content has to suit a wide range of audiences, and this video specifically isn't about how to use Tableau, but rather how you can create something in Tableau to add to your portfolio. I might make a How to get started in Tableau video in the future : ) Thanks so much for watching!

@Rapha_Carpio Жыл бұрын

Bro how you do that thing of “lightning “ the mouse It takes long time like organise the information and the slides you need to show and read

@mo-chen Жыл бұрын

It’s an app called PowerToys. You can get it on Windows 😄

@ameenabdulbarr8342 Жыл бұрын

great video, I tried what you also did but the highlighted values could not show on the set

@mo-chen Жыл бұрын

Thanks Ameen! Did you change your action to a dashboard action?

@ameenabdulbarr8342 Жыл бұрын

@@mo-chen I really don't know since I'm new to Tableau, I would check though

@ameenabdulbarr8342 Жыл бұрын

@@mo-chen just checked it out no I didn't

@emanueldananjaya2648 11 ай бұрын

Hello, good video always but I have some issue here where I couldn't download the datasets on vscode with the kaggle API. I've downloaded the kaggle.json and move the file into the .kaggle folder but why it seems doesn't work for me?

@mo-chen 11 ай бұрын

I'd recommend searching the exact error message on Google, that should solve your problem. Thanks a lot for watching 😄

@ceciliaap6069 Ай бұрын

Can someone explain why 12:25 not working with mine? I've followed all the steps correctly but apparently that 'ticks' still not working. Does this have something to do with the latest version of tableau? I'm completely lost...

@lukebosson7823 13 күн бұрын

Hey Cecilia, I got stuck their too!!! I figured it out. We have to do one final step that Mo didn't seem to do in the video: You need to convert your dates fields to 'Exact dates'. For example: 1 - Right click on the Column 'Moving Average Period' 2 - Scroll down and click 'Exact Date' Make sure they are set to 'Continuous' as well. Check that Min and Max month are also set to 'Exact Dates'. Hope this helps!

@juliusdv6657 4 ай бұрын

13:01 - My max and min calculated fields are auto aggregated to average. Because of this, I cannot create the in range calculate field/measure. Any way to fix this?

@youssufhaddad959 2 ай бұрын

If you're still didn't figure this out, make sure of the state " { MAX(IF [Moving Average Period Set] THEN [Moving Average Period] END) } " with curly brackets

@zabashhd459 7 ай бұрын

Hi Mo what would you call this Dashboard and Intermediate or Professional Dashboard ?

@mo-chen 7 ай бұрын

Intermediate to Advanced I'd say 😁

@comebackcs 5 ай бұрын

I repeat every step from 8:18, but when I move "Moving average period" calculated field to Culumns, something goes wrong. It doesn't ask me which field I want to drop and the visualisation is different. What could be the issue? The same when I move MIN & MAX month to the "Detail" section. PLEASE HELP!

@earlvincent97 5 ай бұрын

You need to RIGHT CLICK to drag the field not left click

@comebackcs 5 ай бұрын

@@earlvincent97 right click doesn’t work on Mac

@earlvincent97 5 ай бұрын

@@comebackcs try holding down the options key and dragging

@sakshinakashe04 Жыл бұрын

Hi I am having some issue with the moving average period measure part I am getting an error there, error is "Argument 'day' tp DATETRUNC must specify a date part ('year','month',etc). Can you please help me resolve this ??

@mo-chen Жыл бұрын

Hi Sakshi, without knowing exactly what you did leading up to the point where you encountered the error, I'm not sure I'll be able to help. Please just re-try the steps before, and make sure all your calculated fields and parameters exist and are correct. Sorry!

@shriyakenkre1474 Жыл бұрын

Hello Sakshi, I faced a similar issue, So when you create a parameter-Moving average period, make sure to put the values of day, week, month exactly as Mo has done. I put day with a capital D and I encountered the same issue as you. Hope this helps!

@mo-chen Жыл бұрын

@@shriyakenkre1474 Well done Shriya 😄

@vivinthomas 3 ай бұрын

@@shriyakenkre1474 Thanks Shriya !! It really worked.

@facundopallares8153 Жыл бұрын

Si en el futuro puedes poner subtitulos en español en tus videos seria muy agradecido. SALUDOS DESDE URUGUAY MONTEVIDEO (latam) me gusta mucho tu contenido y es inspirador.

@mo-chen Жыл бұрын

Hi Facundo 👋 Thanks so much for watching. I'm not sure if I'll be able to include Spanish subtitles, but hopefully AI can soon make auto-translated captions available on KZfaq 😃 There's already auto-generated English captions, so I don't see why not!

@VuNi1234 Жыл бұрын

hey mo... while using DATETRUNC([Moving Avg Period],[Time]) its throwing an error - asking to specify date part(year , month etc). we are specifying with the parameter right! am i going wrong some where! 🤔

@mo-chen Жыл бұрын

Hi Nishanth 👋 It's hard to say why the error is occuring without seeing everything you've done up to the point. Check out Sakshi Nakashe's comment and the replies to it. They had the same problem I believe and they figured it out.

@VuNi1234 Жыл бұрын

@@mo-chen thank you, I, will check.

@AlexMar-r Жыл бұрын

so you saved the data set you manipulated in Visual studio as an Excel csv. file ? then import it intoTableu ?

@mo-chen Жыл бұрын

Hey Alex, yes that's correct. I downloaded the file programtically using the Kaggle API, then transformed the downloaded CSV file and wrote the dataframe out to my local directory as an Excel file to use in Tableau.

@AlexMar-r Жыл бұрын

@@mo-chen thank you sir ,i did the whole thing , is Tableu something you use every day ? i just got two courses done from google and Ibm Data science , and Data Analytics , im trying to break into Finance side of things ? im a Graphic designer by trade any tips where to start ?

@mo-chen Жыл бұрын

@@AlexMar-r In my current role I do use Tableau every day. Check out my website for learning materials and a roadmap datawithmo.com/. Hope this helps!

@anshumaangarg8156 11 ай бұрын

Hello Mo, Impressive Project Mo. The Visualizations are self-explanatory...great job 👍👍 Actually I am getting missing field on sheet 1 error when I do steps: 1) Click on Worksheet-->Actions-->Add Action-->Change Set Values 2) Name: Update Moving Average period Set 3) Source sheet: Sheet 1 4) Target Set : Moving Average Period Set 5) Running the action will : Assign values to set 6) Clearing the selection will : Keep Set values After performing all these actions , I get error saying ...."Missing field on Sheet 1(Moving Average Period)" ....What should I do ?

@mo-chen 11 ай бұрын

Hi there, I believe someone had a very similar question before on Tableau Community. Check it out here community.tableau.com/s/question/0D54T00000C65PvSAJ/action-missing-fields-on-a-sheet-both-sheets-from-the-same-source. Hope this helps! Thanks a lot for watching 😃

@croldan20 11 ай бұрын

@anshumaangarg8156, Did you manage to solve it?

@adikaahmad 9 ай бұрын

Hi, when u drag and drop 'Moving Average Period' to columns, use right click instead of left click like in the video and then choose Continuous. You can do the same things on 'Min Month' and 'Max Month'. For me it solved my error. Hope it's help.

@Somi_nix 9 ай бұрын

@@adikaahmad huaa thanks dude!! makasi mas, saya stuk disitu soalnya

@nicholastadeusantosdasilva8986 8 ай бұрын

@@croldan20 Hi! I had to click on the Moving Avarage Period, Min Month and Max Month metrics with the left button and click on the "Exact Date", because even whit the metrick in a "Continuous" form, the date selection action wasn't working. Hope it helps

@zaikoshi Жыл бұрын

Bro! I'm really stuck over here. My company is asking me to create financial model for credit scoring system for microcredit. I have no idea where to start since im a junior data analyst and the only data analyst in my company. i have no idea where to start. Please help

@mo-chen Жыл бұрын

Hi Adam, this is a pretty difficult problem to tackle if you have no modelling experience. Unfortunately there's no quick way to solve this, you won't become an expert credit risk modeller overnight. But you can definitely learn it fast if you put in the effort. You should probably Google for credit risk modelling and find courses or any other resources that can help you. I found a Udemy course here www.udemy.com/course/credit-risk-modeling-in-python/. Hope this helps, and thanks a lot for watching!

@HermioneVivi-nq4px 9 ай бұрын

Hello, first of all i wanna thank to you for your kindness by making this video😊 I got stuck in minute 13:52, it says the calculation contains errors because of the symbol (>=). Anybody know how to fix that? Thank you!

@mo-chen 9 ай бұрын

I'd suggest re-doing everything up until that point the exact same way. The calculated field definitely works so maybe you made a mistake before when calculating other fields that go into this specific calculated field. Thanks a lot for watching 😁

@billionairepodcast 4 ай бұрын

Could you remake this video ? It's really lack of explanation about the parameter, filter etc. There are tons of errors with the latest tableu also.

@shriyakenkre1474 Жыл бұрын

Can you explain this to me? {SUM(INT([In Range])*[Count Of Bikes])} How exactly does the INT function work because the In Range contains dates right? Also can you explain the whole formula? Thank you!

@mo-chen Жыл бұрын

Hi Shriya 👋 We use In Range to only count the bike rides within the period we select. The INT function refers to (In Range * Count), not just In Range, as you have to convert the output of the multiplication to integer type. Try it without INT, and you'll get an error message which should tell you what's wrong (i.e. you should convert to INT).

@themalibaba.9662 3 ай бұрын

WHAT? What is the point of 2:00 - 6:00 if it downloads as CSV? on mac anyways

@themalibaba.9662 3 ай бұрын

oh you cleaned or rewrote it... ok ok. I assume this is faster than sheets excel? but more costly for employer

@arpitgautam1431 3 ай бұрын

Hey Mo Idk why I am getting the error of " argument 'Day' to DATETRUNC must specify a datepart('year','month', etc.) when i am creating "Moving Avg Period Measure" ? Can you suggest a solution 9:48

@shreypanzz 2 ай бұрын

i am having the same error , did you fix it ?

@vinayak261 Ай бұрын

@@shreypanzz the parameter value(day, week , month) should be in small case

@commenter260 8 ай бұрын

is it possible to build this data visualisation in angular or is it possible to import this to my angular project

@mo-chen 8 ай бұрын

I’ve never used angular before so I won’t be able to answer this one unfortunately 😅

@bejukacarlson6454 5 ай бұрын

hello chen, i love the video. but i encountered an issue while practicing. i followed the steps in converting the 'season' and 'weather' column. But my result for the 'season column showed "Nan". what could be the problem?

@sudhnwaghorpade7652 5 ай бұрын

it had happened because you must have executed map function more than once, restart the kernel and again run all the cells in sequence and run each, map(season_dict) and map(weather_dict) only once.

@bejukacarlson6454 5 ай бұрын

@@sudhnwaghorpade7652 Thank you very much. I'll work on it and give you feedback.

@salsadiaries5081 5 ай бұрын

I tried doing that and it worked for Season but it's still NaN for weather - is there any other way? @@sudhnwaghorpade7652

@sujitdhas174 10 ай бұрын

Which one has most demand in india power bi or tabluea

@mo-chen 10 ай бұрын

I'm not familiar with the workforce skills needed in India so unfortunately I can't answer this. Just look through the job postings for the roles you want, and see which one they require. Thanks for watching 😁

@ArunKumar-bp5lo 11 ай бұрын

show set and reference band not showing for me

@mo-chen 11 ай бұрын

Hi there 👋 Unfortunately without knowing what exactly you did in your workbook, I won't be able to answer this question. One thing you could do is to right-click on your set and choose show set.

@garryanggadita6532 5 ай бұрын

Tableau update goddamn confusing, why my Action missing field in sheet? is anybody have the same issue?

@vinayak261 Ай бұрын

me too Did you find a way around?

@artkustik 6 ай бұрын

Exactly at 12:18 when selecting the target set there appears an error on my tableau saying "Missing field on sheet 1 - Moving Average Period" Does anybody have the same issue? I followed all the steps in the video 3 times and its always there.. doesnt make sense to continue because the selecting of the dates doesnt work... I would love to finish this though... Other than that great video...

@manojgowdavenkatachalamurt3421 6 ай бұрын

@datawithmo I'm facing the same issue too. Tried looking through various sites on the web, couldn't resolve it. Any help to resolve this is appreciated.

@billionairepodcast 4 ай бұрын

is it still unresolved ?

@artkustik 4 ай бұрын

yes... thanks.@@billionairepodcast

@KasYo4u 2 ай бұрын

same problem

@vinayak261 Ай бұрын

make sure that you've selected the exact date option for Moving average period which I assume is in the column section of your visualization.😉

@davestevo6752 Жыл бұрын

Great video! With 2-4 hours of study every day, in how many months is it possible to be ready to look for a job?

@mo-chen Жыл бұрын

Hi Dave, thanks a lot for watching : ) Before I answer your question, could I just ask what your starting point is? Are you completely new to data and analytics or you already have some experience?

@ck4638 Жыл бұрын

@@mo-chen Hi Mo. I have a question. Is learning Power BI better than learning Tableau? If some one work in only SQL as Data analyst, which visualization is better to learn for future prospects? How much Python learning is required? Thanks

@mo-chen Жыл бұрын

@@ck4638 Great question, I wondered this myself a while ago. Both are excellent visualisation tools, which one you should learn should depend mainly on which company you want to work for as each organisation will have their own preferred BI tool. I’ve used both by now, and switching from one to the other isn’t that difficult at all!

@ck4638 Жыл бұрын

@@mo-chen thanks for quick reply. How much python is required to become a data scientist? Pandas and numpy and matpotlib are enough? I am learning python only by watching python projects like yours on KZfaq . I know the basics of python

@mo-chen Жыл бұрын

@@ck4638 No problem at all! Pandas, numpy and matplotlib are a great foundation, but remember as a data scientist you’ll have to do a lot of modelling, so you’ll need to understand the maths and statistical concepts as well.

@nari1071 7 ай бұрын

Can i work with R instead of python ?

@mo-chen 7 ай бұрын

Yes, of course. Python is a general programming language, while R is a statistical programming language. It just depends on what your use cases and preferences are.

@SasiKumar-nx7or 11 ай бұрын

Hi Mo when I am creating the min month, it's becoming aggregate function! how to fix?

@mo-chen 10 ай бұрын

I’m afraid without seeing what exactly you’ve done in your workbook, I won’t be able to help here. Please try and redo and the steps as they definitely work in the video. Thanks a lot for watching 😃

@kevinlau6424 7 ай бұрын

Also running into the same issue. Followed the exact steps at timestamp 11:20 but instead of the calculated field going under "Tables" with Moving Average Period, Moving Average Period Set it goes below a line and is grouped with the rest of the calculated fields. Also when dragging my Min Month and Max Month onto the detail page it is labaled as AGG(Max Month) and AGG(Min Month)@@mo-chen

@tompham4004 7 ай бұрын

@@kevinlau6424 I am having the same exact issue.

@tompham4004 7 ай бұрын

@@kevinlau6424 @SasiKumar-nx7or This solution worked for me! Hope this isn't too late. Put this for the calculated field for Max Month: { FIXED : MAX(IF [Moving Average Period Set] THEN [Moving Average Period ] END) } This puts the Min Month and Max Month under Tables.

@kunj3440 2 ай бұрын

Were you able to solve this issue? Having the same problem. Are you using the browser version of tableau public? @@kevinlau6424

@elnugroho Жыл бұрын

:( i'm stuck in 12:23. Mine always said missing field and cannot work. any idea to fix guys?

@mo-chen Жыл бұрын

Hi Larasati, can you be a bit more specific please? What doesn't work and what's missing?

@marcericsson9815 Жыл бұрын

@@mo-chen Hi! Same here. The error she comments appears editing the set action: Missing field on Sheet 1-> Moving Average Period. But I tried to redo the project but the error always appear on the same point. Then I click OK but when I select a specific segment of the graph, the set of the right remains equal without any change. Any tips?

@user-fv1yg6xm2k Жыл бұрын

@Larasati An Hi I have same problem. You can fix this when you drop the Moving Average Period into Columns, choose the 'Continuious' and 'Extract date'.And so on when you drop Max/Min Month into Detail.Just try some selection to make sure your variable display as same as MO

@arianawzad5668 8 ай бұрын

@@user-fv1yg6xm2k Woah, Thanks for the fix tip

@donaldokorejior1981 6 ай бұрын

@@user-fv1yg6xm2kyou are awesome bro. God bless you

@subbiga 3 күн бұрын

you have good content but there are lot of issues, for example 1. I'm trying to understand what each is but you are not explaining what each value is and there are lot of issues arising due to version changes or so. 2. But you need to create a better video to explain this much easier and better

@mariambeme 9 ай бұрын

Please de first part the Py part step by step pleeeese, I couldn't follow you into vz!!!!

@mo-chen 9 ай бұрын

I'm afraid I won't make a separate video on that 😅 The code is in the in description. I also included the final excel file that I used for the visualizations so it's not a problem if you didn't code along 😃

@ShowBizJunkie 7 ай бұрын

I like your video but the problem is that tableau public has a newer version different from the one you used 7 months ago. I am having the most problem with the band. When I change Min month to continous, it changes it to Day(min month). When you dragged min month to detail in the marks card, I got a totally different output. If you want more people to come to you, you should update your videos from time to time. Also you selected a complex project for newbies like us. I am not understanding anything what you are doing, I am simply monkeying you. I don't know why you created a moving average period and duration and then why you created a set. Suggestion: when you create any tutorial first decide who is your audience (beginners, intermediates or expert) then title it according and choose projects that can be understood by these 3 levels. Thanks for listening.

@mo-chen 7 ай бұрын

Thanks for the suggestions 😄

@rubayetalam8759 9 ай бұрын

hii, please make proper playlists, it's hard to find videos in your channel

@mo-chen 9 ай бұрын

Yes, you're right. I should 😁 I'll go make some right now!

@salsabilemed6700 8 ай бұрын

good video but could u plz go more slow

@mo-chen 8 ай бұрын

I'll try my best next time 😃

@jaswanth6452 Жыл бұрын

is machine learning required for data analyst,,,,,,,,,"which I hate the concept most"

@mo-chen Жыл бұрын

Hi there, generally no but what you’ll need to do on a day to day basis as a data analyst will vary widely based on your job responsibilities are and which company you work for

@jaswanth6452 Жыл бұрын

@@mo-chen currently I am pursuing data analyst course in which you have to pay extra massive amount for machine learning I am confused to take it or not machine learning

@mo-chen Жыл бұрын

@@jaswanth6452 like I said, it’s not a must to know machine learning but it’s always a good to have. Look at some jobs that you think you’d like to do in the future and see if those jobs have machine learning as a requirement in the description, roles, responsibilities, etc

@jaswanth6452 Жыл бұрын

@@mo-chen which we use more for data analyst is it EXCEL or PANDAS industry used more maximum

@mo-chen Жыл бұрын

@@jaswanth6452 Excel is a must. Some jobs will require you to know a programming language as well. If the programming language is Python, then pandas and numpy are the go to libraries for data analysts.

@sultanurrahmanshuvo9921 9 ай бұрын

hello sir, how are you getting true and false value in sheet 2 "IN Range". I am getting only null value. Can you please help me with that? kzfaq.info/get/bejne/pNJpmL2dlq-ze30.html

@mo-chen 9 ай бұрын

It's hard to fix the problem without knowing what exactly you did prior to this step. Please re-start the project and follow closely 😃 Everything in the Tableau workbook definitely works. You can download the whole workbook for reference.

@sultanurrahmanshuvo9921 8 ай бұрын

@@mo-chen Thank you so much Sir. I was gonna comment that I already re-started multiple times but then after seeing your comment I have given it a try again and this time not only i just fixed my issue but also I have learned a lot of things. The main issue was in "In Range" table condition, I applied "Moving Average Period" parameter and also messed up in various places.

@jackfrost8969 4 ай бұрын

Absolutely no explanation. This is not begineer friendly at all.

@58451nam 3 ай бұрын

explanation may make the video longer

@jackfrost8969 3 ай бұрын

@@58451nam I would happily take the longer version if it meant I would understand the intuition behind the steps.

@specialone2604 5 ай бұрын

im sorry i love ur vids but this is the worst tableau tutorial ever, even if it isnt aimed at beginners, u have to actually say what youre doing, the way youre doing it is basically just to show off your skills, no benefit to the viewer at all

@pspc890121 9 ай бұрын

Hi thank you for the video! I would want to ask if I wanted to put this on my resume would this be a suitable project to put? And also what are the thought process or thoughts behind this project that can be more elaborated! Thank you so much!

@mo-chen 9 ай бұрын

Yes, this would absolutely be fine to put on your resume! With regards to the thinking behind the project, I'll leave that to you so you can put your own touch on it 😃