🎯 Key points for quick navigation: 00:09 *The video demonstrates an interactive dashboard for electric vehicle data analysis using Tableau software.* 00:35 *The data used for the dashboard will be provided via a Google Drive link in the video description.* 01:01 *The dashboard includes summary KPIs and various charts for detailed insights.* 02:25 *The dashboard features interactive filters allowing analysis from different angles.* 03:34 *Quick filters enable easy selection of specific states or manufacturers for focused analysis.* 05:27 *The dashboard design uses predominantly green colors to reflect the "green energy" theme of electric vehicles.* 10:36 *KPIs (Key Performance Indicators) provide a high-level summary of overall business performance.* 11:32 *The first KPI is total vehicles, which will be separated into BEV and PHEV categories.* 12:53 *BEV (Battery Electric Vehicle) refers to fully electric vehicles, while PHEV (Plug-in Hybrid Electric Vehicle) refers to hybrid vehicles.* 15:29 *The dashboard will include charts showing total vehicles by model year from 2011 onwards.* 18:01 *The project uses Excel 2021 (or later) and Tableau 2022.3.0 (or later), with Tableau Public as a free alternative.* 19:24 *The dataset contains approximately 150,000 rows and 17 columns of electric vehicle data.* 23:32 *70-80% of data analysis work involves understanding and preparing the data before visualization.* 25:23 *The tutorial begins with connecting to the CSV data file in Tableau Desktop.* 27:54 *Tableau's interface includes logical and physical layers for data connections.* 29:44 *Tableau maintains both the displayed field name and the original remote field name from the data source.* 31:50 *The first visualization created is for the total number of vehicles using a count distinct function.* 35:29 *The second visualization calculates the average electric range of vehicles.* 37:37 *A data source filter is applied to include only data from 2011 onwards for all visualizations.* 40:40 *A calculation is created to count the total number of Battery Electric Vehicles (BEVs).* 43:22 *A percentage calculation is added to show BEVs as a proportion of total vehicles.* 44:59 *The process is repeated to create visualizations for Plug-in Hybrid Electric Vehicles (PHEVs).* Made with HARPA AI
I've completed three dashboards of your playlist. I'll be completing the rest too. You're doing great work, brother. Keep growing. I've shared your channel in various Discord servers too. You'll soon hit 1 million subscribers.
46:00 for both tab BEV and PHEV miles should not consider in formatting as it is count of BEV and PHEV... I totally understood It is just negligible mistake by duplicating previous worksheet... BTW you doing fantastic work by giving great content with zero charges.... 💖
Thank you so much for explaining everything so well. Your explanation was incredibly helpful and made things much clearer for me. I really appreciate your effort.
Great tutorial! thanks. My Vertical container for filter shows the default text "Hold down Shift to drop floating objects....". Is there a way to hide this text from that container ? I tried to add a filter parameter over it but that text is still available.
If I want to add make as a filter and when I add it in dashboard the data in dashboard is automatically decreased even if I set filter to all. Can anyone tell me how can I add make as a filter in dashboard.
My man, its great that you posted this video, its helpful but damn, stop saying "getting or not". For people that don't know much english, they might not notice but it's quite obvious and a bit bothersome. Just an observation mate. Other than that....love the content. Cheers. .
@@timeformegaman based on what? Its an observation. Doesn't mean I am insane. I don't disrespect the guy. The video was definitely helpful and props to him for the useful tips. But....man, I can't get over him saying every now and then "getting or not". For you might be ok but not for everyone. We are all different. Good day.
@@danielbogos263 I have listened to an hour of this so far, and I am not even sure what you are complaining about. He is not a native speaker. And YOU came across as "rather annoying, a bit rude and arrogant". You disrespect him directly. Don't weasle our of your words. See yhat absolutely no one else in the comments has any issue at all woth what you are talking about, I think it would be worth some self investigation on your part about what you are hearing, and why you are so upset. It could be a growing moment for you. Or you could make hours of data analysis content your own way.
@@timeformegaman yeah man. You might be right. Reading now, I agree, it sounds a bit exaggerated. I didn't mean to be that rough. I will edit the comment and make my point a bit clearer and less rude. However, how on earth did you not notice how often he says that. I am damn surprised.😂😂
🎯 Key points for quick navigation:
00:09 *The video demonstrates an interactive dashboard for electric vehicle data analysis using Tableau software.*
00:35 *The data used for the dashboard will be provided via a Google Drive link in the video description.*
01:01 *The dashboard includes summary KPIs and various charts for detailed insights.*
02:25 *The dashboard features interactive filters allowing analysis from different angles.*
03:34 *Quick filters enable easy selection of specific states or manufacturers for focused analysis.*
05:27 *The dashboard design uses predominantly green colors to reflect the "green energy" theme of electric vehicles.*
10:36 *KPIs (Key Performance Indicators) provide a high-level summary of overall business performance.*
11:32 *The first KPI is total vehicles, which will be separated into BEV and PHEV categories.*
12:53 *BEV (Battery Electric Vehicle) refers to fully electric vehicles, while PHEV (Plug-in Hybrid Electric Vehicle) refers to hybrid vehicles.*
15:29 *The dashboard will include charts showing total vehicles by model year from 2011 onwards.*
18:01 *The project uses Excel 2021 (or later) and Tableau 2022.3.0 (or later), with Tableau Public as a free alternative.*
19:24 *The dataset contains approximately 150,000 rows and 17 columns of electric vehicle data.*
23:32 *70-80% of data analysis work involves understanding and preparing the data before visualization.*
25:23 *The tutorial begins with connecting to the CSV data file in Tableau Desktop.*
27:54 *Tableau's interface includes logical and physical layers for data connections.*
29:44 *Tableau maintains both the displayed field name and the original remote field name from the data source.*
31:50 *The first visualization created is for the total number of vehicles using a count distinct function.*
35:29 *The second visualization calculates the average electric range of vehicles.*
37:37 *A data source filter is applied to include only data from 2011 onwards for all visualizations.*
40:40 *A calculation is created to count the total number of Battery Electric Vehicles (BEVs).*
43:22 *A percentage calculation is added to show BEVs as a proportion of total vehicles.*
44:59 *The process is repeated to create visualizations for Plug-in Hybrid Electric Vehicles (PHEVs).*
Made with HARPA AI
I've completed three dashboards of your playlist. I'll be completing the rest too. You're doing great work, brother. Keep growing. I've shared your channel in various Discord servers too. You'll soon hit 1 million subscribers.
Thanks you so much for comment and sharing
Which discord server? Id like to join!
Hey, I want to learn Data Analyst from scratch. From where can I start?
46:00 for both tab BEV and PHEV miles should not consider in formatting as it is count of BEV and PHEV... I totally understood It is just negligible mistake by duplicating previous worksheet... BTW you doing fantastic work by giving great content with zero charges.... 💖
Thank you, brother! This is my first tableau dashboard, and I have just tried and learned many things!!! I'm from Sri Lanka :))
This is amazing work, really enjoyed the tutorial. A project worthy for the portfolio.
This is amazing! I am gonna follow all of your dashboard tutorials!
One of the best tableau project till date on youtube. keep it up brother.
So nicely prepared and superbly explained each steps. Wonderful. Thanks a lot.
Thanks a lot
Thank you so much for this video. I loved the green and white theme of the dashboard!
Glad you liked it!
AS ALWAYS YOU ARE BEST AND GIVES US BEST OUTPUT RESULT FROM SCRETCH THANKS A LOT SIR
Thank you so much for this project. This is so far best project.
nice video very use full for me thank you so much
Thank you Swapanjeet for this amazing project
This was really helpful. Thank you!
Thank you ! Very informative and helpful.
Thanks for explaining in more details.
Thank you so much for explaining everything so well. Your explanation was incredibly helpful and made things much clearer for me. I really appreciate your effort.
Thank for the great tutorial
Thank you from Bangladesh.
Great Work 😍👏
Great tutorial
i love your videos bro keep making more videos
Great Work Sir.
Great video!
Super explanation
Very Educative
Thanks!
Thanks a lot
Hey Swapnjeet, could you please include the images used in the dataset folder?
Dear Swapnjeet, can you also show, how to deploy this dashboard in Tableau server??
can we do model year filter at the extract level if in a extract connection ?
Great tutorial! thanks. My Vertical container for filter shows the default text "Hold down Shift to drop floating objects....". Is there a way to hide this text from that container ? I tried to add a filter parameter over it but that text is still available.
wait. how did you even create the measure?
Could you please make a video on only my SQL project? It would be very helpful.
Sir base MSRP have zero value so how can be clean this data
Can u share the kaggle link for dataset
Sir where you are adding horizontal containers, in our tableau it is adding vertical containers. And vice-versa
If I want to add make as a filter and when I add it in dashboard the data in dashboard is automatically decreased even if I set filter to all.
Can anyone tell me how can I add make as a filter in dashboard.
I want to learn tableau do you have any course?
Video course
Is there any reason why majority number of vehicles are from Washington? I expected that California should have the largest number of vehicles.
Hey, I want to learn Data Analyst from scratch. From where can I start?
will public version of tableu work here bhaiya?
Yes you can di in public version
@@datatutorials1 but bhaiya in that we cannot import data from sql na?
And you have imported data from sql in your projects right?
Can someone pls send me this data file? My drive access is blocked .
sir if possible please provide softcopy notes of tableau, else the video is just amazing
Available on my website
Can you build this with free version of tableau ?
You can build using same steps in free version as well
will you please share logo?
My man, its great that you posted this video, its helpful but damn, stop saying "getting or not". For people that don't know much english, they might not notice but it's quite obvious and a bit bothersome. Just an observation mate. Other than that....love the content. Cheers. .
Are you insane?
@@timeformegaman based on what? Its an observation. Doesn't mean I am insane. I don't disrespect the guy. The video was definitely helpful and props to him for the useful tips. But....man, I can't get over him saying every now and then "getting or not". For you might be ok but not for everyone. We are all different. Good day.
@@danielbogos263
I have listened to an hour of this so far, and I am not even sure what you are complaining about. He is not a native speaker. And YOU came across as "rather annoying, a bit rude and arrogant". You disrespect him directly. Don't weasle our of your words.
See yhat absolutely no one else in the comments has any issue at all woth what you are talking about, I think it would be worth some self investigation on your part about what you are hearing, and why you are so upset. It could be a growing moment for you.
Or you could make hours of data analysis content your own way.
@@timeformegaman yeah man. You might be right. Reading now, I agree, it sounds a bit exaggerated. I didn't mean to be that rough. I will edit the comment and make my point a bit clearer and less rude. However, how on earth did you not notice how often he says that. I am damn surprised.😂😂
@@danielbogos263
I dunno. My love of Tableau put the blinders on me. Have a good night.
Too much advs enough is enough
Jackson Patricia Jones Eric Davis Nancy