BEST END TO END DATA ANALYTICS PORTFOLIO PROJECT | TABLEAU & PYTHON
Вставка
- Опубліковано 21 лип 2024
- Get access to my exclusive content by joining my mailing list ➡ mochen.info/
Support me on Patreon ➡ / mo_chen
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!
Was the first time I was able to follow a project through from start to finish. Much appreciated Mo 👏
Glad I could help!
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!!
Just made me realize how important it is to learn Tableau
Hi Kavit, it is very important indeed to be able to visualise your data. Thanks a lot for watching!
thank you so much! as a newbie this video helps me a lot to learn about tableau!
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.
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 : )
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
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!😊
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 😁
I learnt more with this video that with full online courses. Great work and thank you.
I'm glad you found the video useful! Thanks a lot for watching Julio 😃
That was an amazing walkthrough.👏
Tableau part was a hell to follow. Damn....
Thank you a lot, I will be your fan in many next videos!
Thanks so much for watching 😃
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.
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 ?
It's incredible!! Thank you!!
Thanks a lot clariele 😃
Your explainations are so clear, thank you for your efforts. :)
Hi C0S1M4, I’m glad you found it easy to follow, thanks for watching!
I'm studying Data Analytics, your videos are amazing! Keep going Mo. I learn a lot from your videos.
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 : )
i'm studying too, what's your linkedin let's connect?
I Really appreciate this kind of content, wish to find more like this, new follower
Hey Brian, I’m glad like the content! I wish to make many more, thanks a lot for watching: )
Superb content.. I really appreciate it.. Thankyou so much
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
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 Geet, thanks so much for watching and all the best with your master’s degree : )
what school are you enrolling in for masters though?
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 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 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!
This is gold.
Hi Prashant, I’m glad you found it useful! Thank you so much for watching : )
awesome stuff! thank you
I'm glad you liked it, thanks for watching 😃
How do you do for the table drop field appears when drag and drop?
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?
Thank you so much Mo!
I'm glad you liked it! Thanks for watching 😃
When you hit a 100k subs do an analysis on your UA-cam 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 🙌
Hi THUGLAZA, thanks a lot! I will certainly try my best to deliver useful content. Thank you so much for watching!
Hey Mo,
great visualization, can I achieve this with power BI and if so, can you help with tutorial?
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.
Very useful video, Thanks
Hi TheMIS Blog, thanks so much for watching!
Could you help me understand why are we using min month and max month as details in every other worksheet?
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>
I didn't get how { SUM(INT([In Range] * [Count]) } calculates the number of bike rides
Hey there!! I am getting error while creating a calculated field for moving average period. Can someone pls help me out here
a big thank for your help !
Thanks for watching Chaz_life 😃
@@mo-chen keep moving on 🙌
Hello Mo, How can i put my dashboard to my resume?
Perfect do some more projects like this
Already have 😃 Check out this playlist!
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.
Thank You MO ♥
Hi Faisal, no problem at all! Thanks for watching : )
Very interesting .😊
Thanks Yero 😁
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)
Thanks a lot for watching and all the best with your data analysis journey 😃
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 ?
nice video
you are the best
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?
Try looking on Kaggle 😄
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!
Thanks this was a great video!
I had a question, why was the 'Moving Average Period Set' was created?
What is it's objective?
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 😁
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.
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
It’s an app called PowerToys. You can get it on Windows 😄
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
Hi Mo, how would you create the same in Power BI?
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 😁
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?
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.
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!
make sure lowercase day/month/year in the parameter part
Hey Mo, thanks for the video. Obviously, very informative video on how to build your portfolio.
I’m glad you liked it, thanks for watching 😃
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?
I'd recommend searching the exact error message on Google, that should solve your problem. Thanks a lot for watching 😄
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.
Can we visualizing in google collab instead of Tableau.
We need more projects 👍
There are numerous other end to end Excel, Tableau and Python projects and analysis on the channel. Feel free to check them out!
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?
I send the actual link to the Tableau dashboard 😁
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!
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 😁
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.
@@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?
WHAT? What is the point of 2:00 - 6:00 if it downloads as CSV? on mac anyways
oh you cleaned or rewrote it... ok ok. I assume this is faster than sheets excel? but more costly for employer
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!
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 😄
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.
@@mo-chen thank you, I, will check.
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 😄
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 UA-cam 😃 There's already auto-generated English captions, so I don't see why not!
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.
Tableau update goddamn confusing, why my Action missing field in sheet? is anybody have the same issue?
me too
Did you find a way around?
show set and reference band not showing for me
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.
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!
You need to RIGHT CLICK to drag the field not left click
@@earlvincent97 right click doesn’t work on Mac
@@comebackcs try holding down the options key and dragging
great video, I tried what you also did but the highlighted values could not show on the set
Thanks Ameen! Did you change your action to a dashboard action?
@@mo-chen I really don't know since I'm new to Tableau, I would check though
@@mo-chen just checked it out no I didn't
is it possible to build this data visualisation in angular or is it possible to import this to my angular project
I’ve never used angular before so I won’t be able to answer this one unfortunately 😅
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
i am having the same error , did you fix it ?
@@shreypanzz the parameter value(day, week , month) should be in small case
so you saved the data set you manipulated in Visual studio as an Excel csv. file ? then import it intoTableu ?
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 ?
@@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!
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!
@@shriyakenkre1474 Well done Shriya 😄
@@shriyakenkre1474 Thanks Shriya !! It really worked.
Hi Mo what would you call this Dashboard and Intermediate or Professional Dashboard ?
Intermediate to Advanced I'd say 😁
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).
Which one has most demand in india power bi or tabluea
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 😁
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.
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.
@@sudhnwaghorpade7652 Thank you very much. I'll work on it and give you feedback.
I tried doing that and it worked for Season but it's still NaN for weather - is there any other way? @@sudhnwaghorpade7652
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.
is it still unresolved ?
yes... thanks.@@billionairepodcast
same problem
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.😉
Can i work with R instead of python ?
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.
Hi Mo
when I am creating the min month, it's becoming aggregate function! how to fix?
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 😃
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
@@kevinlau6424 I am having the same exact issue.
@@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.
Were you able to solve this issue? Having the same problem. Are you using the browser version of tableau public?
@@kevinlau6424
:( i'm stuck in 12:23. Mine always said missing field and cannot work. any idea to fix guys?
Hi Larasati, can you be a bit more specific please? What doesn't work and what's missing?
@@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?
@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
@@user-fv1yg6xm2k Woah, Thanks for the fix tip
@@user-fv1yg6xm2kyou are awesome bro. God bless you
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 😃
@anshumaangarg8156, Did you manage to solve it?
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.
@@adikaahmad huaa thanks dude!! makasi mas, saya stuk disitu soalnya
@@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
Please de first part the Py part step by step pleeeese, I couldn't follow you into vz!!!!
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 😃
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
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? ua-cam.com/video/nl9eZl1IOKI/v-deo.html
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.
@@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.
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?
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 UA-cam . 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.
hii, please make proper playlists, it's hard to find videos in your channel
Yes, you're right. I should 😁 I'll go make some right now!
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.
Thanks for the suggestions 😄
U r so pretty,but it’s too difficult for me 😢
You can do it!
good video but could u plz go more slow
I'll try my best next time 😃
is machine learning required for data analyst,,,,,,,,,"which I hate the concept most"
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
@@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
@@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
@@mo-chen which we use more for data analyst is it EXCEL or PANDAS industry used more maximum
@@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.
Absolutely no explanation. This is not begineer friendly at all.
explanation may make the video longer
@@58451nam I would happily take the longer version if it meant I would understand the intuition behind the steps.
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