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!
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!!
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.
Hey Mo, solid walkthrough for tableau. I will say that that the tutorial goes by super fast, and I say its more of a walk through as most of the time it is just telling me what to do and where to click rather than giving a brief explanation of what everything does. Some little details were glossed over too quickly, and anyone who would not really be experienced in anything tech I think would not really be able to finish this video. I also suspect that since this is slitghtly older, your tableau probably works a little different than ours, like adjusting the parameters of discrete/continuous + by year/month/day/hour/exact date. I had to figure that one out on my own. Another thing is on 21:37 you dragged the time into the colors section. It doesn't work if you just drag it, I had to figure out that you had to hold CTRL then drag it so that the time doesn't leave the rows.When you do that, and you try to re-add the time back into rows, the colors are all messed up, which is another thing I have to figure out why that is.
I wouldn't say this is the best of tutorials I've seen. He doesn't explain why he creates certain measures. He is just telling what to do and how to do it.
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 😁
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 🙂
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 : )
I enjoy your videos alot and i find them quite easy to follow. I am having struggles doing a particular task on this one. I am not able to change the MIN Month and Max Month to continuous. Thats because when i right click and drag them into the details bar but it doesnt not display the window where i will select continuous.
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)
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
When you hit a 100k subs do an analysis on your RU-vid 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 amazing Video One thing i am confuse with that sometime you use python for a Project and sometimes you use Excel sometimes sql and also in powerbi So whats the purpose of each and especially when to use each in the work and where to start sequence wise from your Data Analytics projects kindly guide us It will help all of us a lot mo thankyu
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
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
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.
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.
@@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.
From 12:48 to 12:56 the reference band bit is quite different in current version of Tableau which is causing errors. It would be amazing if you address this issue
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 ?
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?
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 ?
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 😃
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.
@@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
When I select the target set for actions at 12:18, I get a warning of "Missing field on sheet 1," and when I move my cursor over that, it says "moving average period," though it is already there.
Thank you so much for the video! I just wanted to ask something my visualisations are not working the way it shows after the reference band settings. Can anybody please help me with this!
I'm at loss on how to start using Visual Studio. Would've been great if you began from the start or if you could post a link here which would helpe me! Thanks.
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!
hello Mo ! thanks for your super clear tutorial. one question, i tried to make actions to my sheet but it keeps saying that i have missing field on my sheet. anyone who knows how to troubleshoot this can help me :) thanks a lot !
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...
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!
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 😁
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 😄
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.
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.
@@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. 👌🏻
@@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.
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 😁
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!
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 😃
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.
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.
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!
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 😁
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 ?
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
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 😄
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?
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...
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!
@@lukebosson7823 OMG! Thank you very much! I've been struggling with Actions function for 3 days (it did not see Moving Average Period field in the working sheet), the problem was in data type🥲I set it in Day but changed to Exact Date after your comment , now everything works 😮💨thank you again!!!!!
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!
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.
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!
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).
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?
@@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
@@CK30585 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!
@@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 RU-vid . I know the basics of python
@@CK30585 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.
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 ??
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!
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!
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.
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!
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>
First of all thank you for content but if you don't explain what you are doing, the video doesn't necessary. Just mouse click sound and you are saying what you click.
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?
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.
@@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 ?
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?
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.
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?
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.
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
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.
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 RU-vid 😃 There's already auto-generated English captions, so I don't see why not!
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?
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
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
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! 🤔
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.
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!
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 😁
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
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!
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 😁
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...
@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.
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 😃