BEST END TO END DATA ANALYTICS PORTFOLIO PROJECT | TABLEAU & PYTHON
Рет қаралды 113,451
Күн бұрын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 ➡ • Data Analysis Portfoli...
┋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!
@pacarkendra-ik8cl 6 ай бұрын
thank you so much! as a newbie this video helps me a lot to learn about tableau!
@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!!
@pilarreyes6839 Жыл бұрын
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 Жыл бұрын
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 😁
@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 : )
@TA_Tactics 5 ай бұрын
That was an amazing walkthrough.👏
@donaldokorejior1981 8 ай бұрын
Was the first time I was able to follow a project through from start to finish. Much appreciated Mo 👏
@mo-chen 7 ай бұрын
Glad I could help!
@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!
@user-ls4xk3zd6n 9 ай бұрын
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
@elghark 6 ай бұрын
Tableau part was a hell to follow. Damn....
@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!
@denidota6393 6 ай бұрын
Superb content.. I really appreciate it.. Thankyou so much
@clarielealmeida6225 Жыл бұрын
It's incredible!! Thank you!!
@mo-chen Жыл бұрын
Thanks a lot clariele 😃
@duonghoangbang2106 Жыл бұрын
Thank you a lot, I will be your fan in many next videos!
@mo-chen Жыл бұрын
Thanks so much for watching 😃
@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 😃
@koa1663 8 ай бұрын
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 ?
@pew2pao459 Жыл бұрын
awesome stuff! thank you
@mo-chen Жыл бұрын
I'm glad you liked it, thanks for watching 😃
@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: )
@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?
@skylertaylor1970 10 ай бұрын
Thank you so much Mo!
@mo-chen 9 ай бұрын
I'm glad you liked it! Thanks for watching 😃
@ufukeskici 5 ай бұрын
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.
@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 6 ай бұрын
i'm studying too, what's your linkedin let's connect?
@prashlovessamosa Жыл бұрын
This is gold.
@mo-chen Жыл бұрын
Hi Prashant, I’m glad you found it useful! Thank you so much for watching : )
@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!
@TheMISBlog Жыл бұрын
Very useful video, Thanks
@mo-chen Жыл бұрын
Hi TheMIS Blog, thanks so much for watching!
@eduardofreire3387 5 ай бұрын
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
@Faisaljaffer Жыл бұрын
Thank You MO ♥
@mo-chen Жыл бұрын
Hi Faisal, no problem at all! Thanks for watching : )
@Chanezk Жыл бұрын
a big thank for your help !
@mo-chen Жыл бұрын
Thanks for watching Chaz_life 😃
@Chanezk Жыл бұрын
@@mo-chen keep moving on 🙌
@user-nx2xb5xc5s 6 ай бұрын
you are the best
@datawit 11 ай бұрын
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 11 ай бұрын
Try looking on Kaggle 😄
@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!
@arneshguru4263 Күн бұрын
Next level tableau creation 👏🏻....had to keep chat gpt open to understand the parameters and calculated fields 😂
@mo-chen Күн бұрын
Glad you liked it
@mayoLJS 4 ай бұрын
Hey Mo, great visualization, can I achieve this with power BI and if so, can you help with tutorial?
@zabashhd459 10 ай бұрын
Perfect do some more projects like this
@mo-chen 10 ай бұрын
Already have 😃 Check out this playlist!
@yerocastrocontabilidad Жыл бұрын
Very interesting .😊
@mo-chen Жыл бұрын
Thanks Yero 😁
@patrickmandengue5813 Жыл бұрын
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 Жыл бұрын
Thanks a lot for watching and all the best with your data analysis journey 😃
@DakshinaVijayakumar 6 күн бұрын
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!
@h_k369 2 ай бұрын
nice video
@RohitSingh-pd7zr Жыл бұрын
Hey Mo, thanks for the video. Obviously, very informative video on how to build your portfolio.
@mo-chen Жыл бұрын
I’m glad you liked it, thanks for watching 😃
@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.
@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.
@AntonioMartinez-fu1ed Ай бұрын
How do you do for the table drop field appears when drag and drop?
@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 Жыл бұрын
@@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 Жыл бұрын
@@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?
@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 😄
@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 😁
@iman.ezatfar 5 ай бұрын
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?
@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 😄
@tommyhutomo4763 9 ай бұрын
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 9 ай бұрын
I send the actual link to the Tableau dashboard 😁
@meghanshrao5878 2 ай бұрын
Could you help me understand why are we using min month and max month as details in every other worksheet?
@Jobfynd1 10 ай бұрын
We need more projects 👍
@mo-chen 10 ай бұрын
There are numerous other end to end Excel, Tableau and Python projects and analysis on the channel. Feel free to check them out!
@Idontthinkilive 8 ай бұрын
Hello Mo, How can i put my dashboard to my resume?
@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!
@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!
@Lant3an 4 ай бұрын
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 ?
@mattlee3296 6 ай бұрын
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.
@user-uh2sk3vw2r 2 ай бұрын
Hi Mo, how would you create the same in Power BI?
@croldan20 Жыл бұрын
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 Жыл бұрын
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 😁
@nobodylovesme6428 Жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
@@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 11 ай бұрын
@@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.
@ramrod5972 9 ай бұрын
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>
@salswain63 6 ай бұрын
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.
@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
@piyushkale4574 7 ай бұрын
Hey there!! I am getting error while creating a calculated field for moving average period. Can someone pls help me out here
@johnadoga9765 6 ай бұрын
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 3 ай бұрын
make sure lowercase day/month/year in the parameter part
@srofficial803 3 ай бұрын
Can we visualizing in google collab instead of Tableau.
@emanueldananjaya2648 Жыл бұрын
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 Жыл бұрын
I'd recommend searching the exact error message on Google, that should solve your problem. Thanks a lot for watching 😄
@nickdao5480 Жыл бұрын
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 Жыл бұрын
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.
@yutahebihime 6 ай бұрын
I didn't get how { SUM(INT([In Range] * [Count]) } calculates the number of bike rides
@juliusdv6657 5 ай бұрын
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 4 ай бұрын
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 8 ай бұрын
Hi Mo what would you call this Dashboard and Intermediate or Professional Dashboard ?
@mo-chen 8 ай бұрын
Intermediate to Advanced I'd say 😁
@HermioneVivi-nq4px 10 ай бұрын
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 10 ай бұрын
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 😁
@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!
@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.
@anshumaangarg8156 Жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
@anshumaangarg8156, Did you manage to solve it?
@adikaahmad 11 ай бұрын
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 11 ай бұрын
@@adikaahmad huaa thanks dude!! makasi mas, saya stuk disitu soalnya
@nicholastadeusantosdasilva8986 10 ай бұрын
@@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!
@commenter260 10 ай бұрын
is it possible to build this data visualisation in angular or is it possible to import this to my angular project
@mo-chen 10 ай бұрын
I’ve never used angular before so I won’t be able to answer this one unfortunately 😅
@ceciliaap6069 2 ай бұрын
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 Ай бұрын
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!
@arailympernebay712 2 күн бұрын
@@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!!!!!
@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 4 ай бұрын
@@shriyakenkre1474 Thanks Shriya !! It really worked.
@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).
@comebackcs 7 ай бұрын
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 6 ай бұрын
You need to RIGHT CLICK to drag the field not left click
@comebackcs 6 ай бұрын
@@earlvincent97 right click doesn’t work on Mac
@earlvincent97 6 ай бұрын
@@comebackcs try holding down the options key and dragging
@sujitdhas174 Жыл бұрын
Which one has most demand in india power bi or tabluea
@mo-chen Жыл бұрын
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 Жыл бұрын
show set and reference band not showing for me
@mo-chen Жыл бұрын
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.
@arpitgautam1431 5 ай бұрын
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 3 ай бұрын
i am having the same error , did you fix it ?
@vinayak261 2 ай бұрын
@@shreypanzz the parameter value(day, week , month) should be in small case
@themalibaba.9662 5 ай бұрын
WHAT? What is the point of 2:00 - 6:00 if it downloads as CSV? on mac anyways
@themalibaba.9662 5 ай бұрын
oh you cleaned or rewrote it... ok ok. I assume this is faster than sheets excel? but more costly for employer
@bejukacarlson6454 7 ай бұрын
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 6 ай бұрын
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 6 ай бұрын
@@sudhnwaghorpade7652 Thank you very much. I'll work on it and give you feedback.
@salsadiaries5081 6 ай бұрын
I tried doing that and it worked for Season but it's still NaN for weather - is there any other way? @@sudhnwaghorpade7652
@billionairepodcast 5 ай бұрын
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.
@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?
@CK30585 Жыл бұрын
@@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 Жыл бұрын
@@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!
@CK30585 Жыл бұрын
@@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 Жыл бұрын
@@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.
@nari1071 9 ай бұрын
Can i work with R instead of python ?
@mo-chen 8 ай бұрын
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.
@garryanggadita6532 7 ай бұрын
Tableau update goddamn confusing, why my Action missing field in sheet? is anybody have the same issue?
@vinayak261 2 ай бұрын
me too Did you find a way around?
@mariambeme 10 ай бұрын
Please de first part the Py part step by step pleeeese, I couldn't follow you into vz!!!!
@mo-chen 10 ай бұрын
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 😃
@artkustik 8 ай бұрын
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 7 ай бұрын
@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 5 ай бұрын
is it still unresolved ?
@artkustik 5 ай бұрын
yes... thanks.@@billionairepodcast
@KasYo4u 4 ай бұрын
same problem
@vinayak261 2 ай бұрын
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.😉
@SasiKumar-nx7or Жыл бұрын
Hi Mo when I am creating the min month, it's becoming aggregate function! how to fix?
@mo-chen Жыл бұрын
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 9 ай бұрын
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 8 ай бұрын
@@kevinlau6424 I am having the same exact issue.
@tompham4004 8 ай бұрын
@@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 4 ай бұрын
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 9 ай бұрын
@@user-fv1yg6xm2k Woah, Thanks for the fix tip
@donaldokorejior1981 8 ай бұрын
@@user-fv1yg6xm2kyou are awesome bro. God bless you
@salsabilemed6700 9 ай бұрын
good video but could u plz go more slow
@mo-chen 9 ай бұрын
I'll try my best next time 😃
@subbiga Ай бұрын
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
@user-zk6je9mg5e 21 күн бұрын
U r so pretty,but it’s too difficult for me 😢
@mo-chen 20 күн бұрын
You can do it!
@rubayetalam8759 10 ай бұрын
hii, please make proper playlists, it's hard to find videos in your channel
@mo-chen 10 ай бұрын
Yes, you're right. I should 😁 I'll go make some right now!
@sultanurrahmanshuvo9921 10 ай бұрын
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 10 ай бұрын
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 10 ай бұрын
@@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.
@ShowBizJunkie 8 ай бұрын
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 8 ай бұрын
Thanks for the suggestions 😄
@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.
@jackfrost8969 5 ай бұрын
Absolutely no explanation. This is not begineer friendly at all.
@58451nam 4 ай бұрын
explanation may make the video longer
@jackfrost8969 4 ай бұрын
@@58451nam I would happily take the longer version if it meant I would understand the intuition behind the steps.
Fabiosa Best Lifehacks
Рет қаралды 38 МЛН