Tableau - Data Blending
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- Tableau - Data Blending
Lecture By: Mr. Pavan Lalwani, Tutorials Point India Private Limited
Get FLAT 10% on latest Tableau certication course(Use Coupon "TH-cam"):
bit.ly/31H9qYE
Watch More Videos at:
www.tutorialsp...
#tableau #tableautraining #tableaututorial #TutorialsPoint #Tutorix #OnlineCourses
![ว้าว!ลุงบีมแบกทองมารับขวัญหลานกันยกบ้าน [cc] แดนแพทตี้ SS2 | EP.49 |](http://i.ytimg.com/vi/Osihq1OAs-4/mqdefault.jpg)
To Get Certification, Click Here: bit.ly/43cTRUQ
Use coupon "TH-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
This is the best online tutorials I have ever seen. Pavan is an excellent tutor. He is very young, confident, smart and intelligent. His methods of teaching is very good. It is very easy to understand him. He has done a great job. Thanks Pavan!!! You are The Best.
Very true, I am a believer👌!
and the videos are not long. short and straight to the point.
Yes...its really true
OMG I love this format of teaching tableau! You get all the benefits of watching and seeing him interact and you still get the tableau canvas right there! Well done.
I back this as well; great way of presenting the features
@@NoMoneyNoQuality can you send the data i am confused with other data he said it's mentioned below but can't find
You’re a superb teacher! Haven’t seen anyone teach like this, better than Edureka and Simplilearn a thousand times over, they put me to sleep.
Thank you👊👍
Right
This is a very clear, simple and easy to follow video. It is much better than what I have paid for my training where the trainer is an absolute disgust and asks everyone questions than explaining the concept. Thanks for explaining this so well..
Passed the desktop specialist exam a few days ago. These videos really helped, thanks!
Where can I find Data Blending dataset which he has been used in the video.. Can you please help me out🙏
How did you add the two databases to tableau in the first place. You should have started from there
Well explained! would be nice if you can share the datasets which are edited as this video
your tutorials are really REALLY helpful! & the format is great cuz it is easy to follow very friendly. Thanks a lot!
Excellent videos to learn Tableau. Could you please send the link to download the Data blending files- coffee sales and office sales
Thank you Pavan for making this nice video on Data Blending!
Absolutely great video. A very clear exploration of data blending. Thanks a lot.
Where can I find Data Blending dataset which he has been used in the video.. Can you please help me out🙏
i really apppreciate, this is the best tutorial I've found ever,
quick and basic but very informative. I really like your video.
What is the significance of establishing a primary data source? What should you consider when choosing which data source should be the primary data source? How about the secondary data source?
your way of teaching is Awesome but please provide the sample file you are using, in the description !!
Thank you so much I love your tutorials on Tableau but please upload dataset to practice. Thank you much :)
Hi, Thank you for providing Tableau videos, which are very useful for me. I am watching all your videos one by and now I am at Data Blending Video. could you please guide me where will I get the examples excel files which you shown in the video like Office City Sale and Coffee chain sale excel files.
im confused. if i have multiple data sources how do i combine them all together without having two separate graphs/?
Its easy to learn , Is this because of your teaching way ? Thank you Boss.
The way you explained is Excellent 👏🏻👏🏻
Can you aggregate a data source to a higher level of granularity to match the second data set within tableau? So that we can establish a 1 to 1 relationship for data blending?
Your tutorials are really helpful, thank you!
please also provide the dataset, so that we can apply the same
Where can I download the Excel files used in above example?
Thank God u I got ur video
Happy to learn with u
Thank you! I’m no longer confused about data blending :)
where can i find excel data sheets used in this video?
most vital question is....The office city sales data is related to coffe or not? Office city sales of what?
your video is nice, however, in the beginning you said "in join we combine data from multiple data sources" . we do this in "Cross-database join" not in "Join". In join we combine tables from the same database/data source. There is only one data source connection in data source page in join.
There are two columns that has north, east, west, etc in the first sheet. Do not assume until you have tested the sheets.
I watched the video 3 times, now I understand this
At 7:42, do you have 1 or 2 visualizations (since you have Coffee Sales and also Office Sales)?
sir your all videos are very useful.
Hi. Great tutorials. I have a doubt here When you compared Coffee sales and Office Sales I found Washington is missing only Ohio and Texas are showing in Office sales. But, in Excel sheet Office sales in State column Washington is there. How to bring that also into graph. Please explain me. Once again thanks for your great way of explanation
lakxmi lakxmi bcz washington is not matching with other source data state
Hi Lakshmi,
It's working on the concept of left join. So when he selected the primary data which has (taxes, ohio & washington), Tableau caluated the sum of taxes, ohio Two states sales which was common on another data set and represented Graph. Likewise when he selected another data, it shows all the states in there with the sum of (taxes & ohio).
Thanks
Whats the advantage of this blending metod over the tradicional left, right inner or full joins?
Mr. Pavan, What monitor are you using for this tutorial? It allows you to demonstrate as you are using and I'm truly amazed by the ease of use.
There is no link to download the data
These videos are nothing but great!
i want to download the excel sheet but by clicking this link i am going to your website where i cant find your sheet pls help me out
In sheet 1 once you are displaying data from secondary source then it includes all states as well as its sales ..then why you are displaying sales from primary source again, it means the same?
teaching style is very impressive
so easy to learn from you.
All videos are just for beginners no advance level topics like tab level security . complex joins like two or more types of joins on same data source. Covered simple and basic information only
I have a very similar example, however my 2nd data source has the same Column name, and I would want to filter it by "If it contains data form a different data source's column".Any ideas?
07:32: Why don't you see sales from Washington state on the graph? The secondary database pulls sales for only two states while it has three states in it. How do you fix this?
Amazing Lecture!
can you tell me where is the video of joins??
Great video. I appreciate your explanation of Data Blending. It helped a lot!
Wer we can download the database? Excel sheets?
Can you explain Data blending two or more difference databases such as , sql server and My sql , or mysql and oracle mongodb etc.. ?
You just confused me, you said Joins are the technique through which we are able to combine data from multiple data sources but in Joins we are only able to combine tha data from the same data sources na?
where can i download this tableau file to practice ? Thank you .
Here only 2 column and more column we can add are not...?
There only fixed name if any new name add
In copy(coffee) sale and office cang... It's difficult name's..?
Can you tell me answer any one...
where did washington go in the combined graph? 7:32
In sheet 1 we compared the coffee sales and office sales for various states but Washington data was not coming for office - only texas and Ohio got mapped ... How we will get all the states from both data source in the sales comparison ?
It's working on the concept of left join. So when he selected the primary data which has (taxes, ohio & washington), Tableau caluated the sum of taxes, ohio Two states sales which was common on another data set and represented Graph. Likewise when he selected another data, it shows all the states in there with the sum of (taxes & ohio).
In sheets --> data sources it is showing multiple connections instead of data source names. So i'm unable to do the blending process.. How can i change from multiple connections to data source names in page sheet
Please upload the TABLEAU CRM videos in full course
sir the data you are using. from where we have to download it
Great video sir...thank you so much and keep it up...
Any guidance on why adding totals would not work?
Sir I get online data from DCS in excel, I want to create graph of that data on interval of 15 min ...Can you create video on this topic?
Hi how to enable data blending feature in tableau
you are showing two excel sheets you have any link to download that file for learner
I got the concept but not able to download this format of blending for hands-on. Please reply if how can I get this file for blend my data
How do you join/ blend an excel spreadsheet with a sql custom query ?
I notice with Data Blending you can't sort the visual
🎉 great sir
I Am facing issues in data blending, it is creating duplicate calculations during graph,
Sir data blending is not visible, how to enable this
Can you help in how to download the excel files, which you are showing in the videos
Can you tell me whether the relationship u created between territory and region exist in sheet 2.
If not how u map both data using territory in the last visualization.
did you get the solution, because i have the same doubt.
please provide excel sheet link
Even I have the same question
Can we blend published data sources in Tableau Server ?
Awesome presentation, but I don't find data files.
i have some doubts regarding this topic ( DATA-BLENDING ).. Can you clarify me Mr.Pavan Lalwani
Can it be possible to combine three data sources
Hi, nice videos.
I have one query please tell how you added two file in data blending
Raghav sharma
Here is the step how to add two files in data blending.
Step-1 : Add the excel file (eg: superatore) and drag the ORDER sheet to the data field
Step-2 : Go to the Sheet 1 --> From Toolbar select Data--> New data source --> add new excel file
Step-3 : Select the required sheet from excel file and drag it to the data field
Step-4: Again to the sheet 1 in tableau ( as mentioned in step-2) --> now you will find 2 data fields
Hi, there is a >5 nulls available in office sales can anyone tell what does this means?
excellent tutorial - thank you. concerning @7:31, I noticed we no longer see Washington sales data, does this mean, that when blending, the primary data source excludes rows where secondary source’s key values aren’t present in the primary’s table?
yeah its basically left join where every rows in the primary data source and the common rows(data) in the secondary data source gets displayed
Why would anyone dislike it.. 😑
Hmmmm
why you created a relationship between regions ?
How to download data that present in the video
Very well Explained.
So in your example you simply ignore the state of Washington from the secondary data source? Seems like you would be presenting flawed data.
how do we decide which table should be primary data source and which one should be secondary data source ?
Yes
where is sample files please upload
Hello Pavan it would be helpful if you provide excel sheets for practice.
can any body tell from where we can get data sets
How to download excel sheets can you please share the link
where can i get the files
How many max datasources we can blend at a time
Where is the link of data? can you please help
how to dowload the dataset explained in the above video
Your tutorials are super helpful. Where can I find the excel file for the tutorials?
same question i have .plss reply if get ans..
Where we download the file
Great teaching
the data source links are not appearing
Thanks
why is washington not in second graph?
can anyone share the link for data set?