Merge and Append Queries in Power BI in Hindi | Merge vs Append in Power Query | Power BI Tutorial

Merge and Append Queries in Power BI in Hindi | Merge vs Append in Power Query | Power BI Tutorial
In this video, I will teach you how to use Merge and Append queries in Power BI in Hindi. This will help you to make your data more accurate for making power bi visualizations.
Merge Queries : Merge is another type of combining queries which are based on matching rows, rather than columns. The output of Merge will be a single query with;
• There should be joining or matching criteria between two queries. (for example StudentID column of both queries to be matched with each other)
• Number of rows will be dependent on matching criteria between queries
• Number of Columns will be dependent on what columns selected in the result set. (Merge will create a structured column as a result).
Append Queries : Append means results of two (or more) queries (which are tables themselves) will be combined into one query in this way:
• Rows will be appended after each other. (for example appending a query with 50 rows with another query with 100 rows, will return a result set of 150 rows)
• Columns will be the same number of columns for each query*. (for example, col1, col2,…, col10 in the first query, after appending with same columns in the second query will result into one query with a single set of col1,col2, …, col10)
What is Power BI ?
Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
माइक्रोसॉफ्ट पावर बीआइ एक ऐसा Platform है जो Business Analysis करने के लिए कई उपकरण प्रदान करता है । यह Different Sources से Data Import करने और एकत्रीकरण, प्रदर्शन योग्य रिपोर्ट में मंथन करने के लिए रूपांतरण करने में सक्षम है। User या Organizational आवश्यकताओं के आधार पर तदर्थ विश्लेषण किया जा सकता है।
What are the Power BI Building Blocks? Power BI बिल्डिंग ब्लॉक का मतलब क्या है
1.A visualization is a type of chart built by Power BI designers. The visuals display the data from reports and datasets. Typically, designers build the visuals in Power BI Desktop.
2.A dataset is a container of data. For example, it might be an Excel file from the World Health Organization. It could also be a company-owned database of customers or it might be a Salesforce file.
3.A dashboard is a single screen with interactive visuals, text, and graphics. A dashboard collects your most important metrics, on one screen, to tell a story or answer a question. The dashboard content comes from one or more reports and one or more datasets.
4.A report is one or more pages of interactive visuals, text, and graphics that together make up a single report. Power BI bases a report on a single dataset. Often, the service organizes report pages to address a central area of interest or answer a single question.
5.In Power BI, a tile is a solitary representation found in a report or on a dashboard. It’s the rectangular box that contains every individual visual.
It is a very difficult task to anyone. If you are really interested to learn this trick then this video never lets you down. On youtube, only just few videos are available on Merge and Append Queries in Power BI in Hindi | Merge vs Append in Power Query | Power BI Tutorial.
Some Popular Videos are: -
1) What is Power Bi in Hindi | Power BI Tutorial for Beginners in Hindi: • What is Power Bi in Hi...
2) Power BI Building Blocks | Power BI Tutorial for Beginners in Hindi: • Power BI Building Bloc...
3) How to Download Power BI | Power BI Desktop को कैसे Download करे | What is Power Bi in Hindi: • How to Download Power ...
4) Import File from Excel Notepad Web to Power BI Desktop in Hindi | Power BI Desktop Tutorial in Hindi: • Import File from Excel...
5) Power BI Query Editor Tutorial in Hindi | Power BI Desktop Tutorial in Hindi: • Power BI Query Editor ...
6) Power BI Choose/Remove column in Hindi | Power BI Tutorial for Beginners in Hindi: • Power BI Choose/Remove...
7) Power BI KEEP & REMOVE Rows Hindi | Power BI Tutorial for Beginners in Hindi | Delete Row in PowerBI : • Power BI KEEP & REMOVE...
8) Power BI Split Column in Hindi | Power BI Tutorial for Beginners | How to split column in Power BI : • Power BI Split Column ...
9) How to use Group By in Power BI Hindi | Power BI Group By Option | Power BI Tutorial for Beginners : • How to use Group By in...
10) Merge and Append Queries in Power BI in Hindi | Merge vs Append in Power Query | Power BI Tutorial : • Merge and Append Queri...
/ teachtoeach
My Social Account Links Available Below: -
Facebook Page: Teachtoeach
Personal Facebook ID: / thissideash
Instagram Account: / thissideash
Twitter: / teachtoeachh
#powerbi #mergevsappendqueries #mergequeries #appendqueries #powerbitutorialforbeginners

[@gokulmehadiya289]

You are absolutely fantastic man, you cleared all the doubts related to append and merge. Thanks!! ❤

[@salmankhan-lr3yt]

I came for explanation for merge and append query now I am hooked to your channel, thanks, Great Content

[@dheerendrakumar8183]

Wow, so simple to understand. Keep it up Dude

[@gampashivakumar]

Excellent and easy understanding about merge and append , thank you

[@amrendrasharma1014]

Awesome, Neeraj Jain

[@RajeevKumar-jt8vl]

Excellent job 👍👌 keep it up,.

[@sunlittissue4992]

I like your videos . Nice way to give explanation

[@AmitKumar-gi4fo]

Yes brother amazing explain all points i really understand here.

[@srikanthp1643]

bahuth thanks bhai

[@rohan_b_ra]

superb explanation. thank you

[@rohansaini2215]

I really like the way you explain all the things one suggestion please make videos more with little complex or non matchable data for better learning because when we worked on our real data that's very unorganised. Please make videos in R programming too if possible.

[@vivekpandya9995]

thank you so much sirji

[@ashishmehrotra7308]

Good Teaching Thanks you💐💐💐💐💐👍😊

[@TeachToEach]

Welcome Ashish Bhai

[@amanbhargava2702]

Best best best 👍💯👏 explanation thank you sir

[@dheerajsaraswat1659]

Thnx Sir

[@amanbhargava2702]

Thank you😊😊😊😊

[@anshupahwa5417]

Thanks for clearing all doubts.😊

[@TeachToEach]

Most welcome 😊

[@khushijha7402]

❤❤❤❤❤❤❤ thank you so much sir

[@vivekkalshan3589]

Very very useful for us thanku sir

[@deepakgupta6764]

Very nice explained. 🙏

[@pragatigupta4818]

Well explained thank you for the video!

[@TeachToEach]

Thanks Pragati for appreciating.

[@shikharbhardwaj1352]

Very clearly explained thanks man...!!!

[@TeachToEach]

Dhanyawad Shikhar

[@interestingfactsbysagartha6178]

Thanks sir

[@tanweerabbasabbas649]

Thank you

[@sameersd86]

great video for new learners well defined

[@TeachToEach]

Thanks your comment it really meant for me. Nobody appreciating my work seriously. I was doing since 2017. Anways Thanks sameer buddy

[@deepakdhikale9211]

Hey its very helpful for beginners like me.. keep uploading

[@TeachToEach]

Thank You Deepak

[@deepakdhikale9211]

@@TeachToEach .Hey one more demand if possible please make a video related to ETL with power BI with live example

[@zarakhan1518]

Thank you sir from Pakistan

[@snehalgawari4258]

Best efforts you are taking to teach

[@TeachToEach]

Thanks Sneha

[@neerajjain230]

Thanks. Neeraj Jain

[@shahpuria5491]

Great sir

[@TeachToEach]

Thanks

[@suhasshirbavikar9496]

super presentation

[@sanjay-behura]

Very nice videos, I learn a lot from your teaching

[@TeachToEach]

Thanks & Subscribe my new channel "Data Ki Pathshala" for learning Advance excel from beginning : kzbin.info/door/iEXQV0bco3yokjRQgCJIgw

[@seematiwari8508]

Very informative.

[@TeachToEach]

Thanks for the comment Seema

[@abhilashshukla854]

Bhai you have great knowledge and very polite way of explaining

[@TeachToEach]

Dhanyawad

[@Ayush_2_3_1_7]

@@TeachToEach sir data provid kar dete

[@travelerinsane277]

Best Video....Nice Explanation

[@TeachToEach]

Thank you so much 🙂

[@rakeshmahakud110]

Really helpful

[@TeachToEach]

Good to hear from you

[@sunilrawat8955]

Bahut badiya

[@TeachToEach]

Welcome Sunil

[@KochurChulkani]

❤❤❤

[@debuvlogs20]

Great Video dear Pray me to get Job in this field..Awsome Video.. Keep it up

[@TeachToEach]

Definately Brother

[@lalitsingh-ni7cg]

Kya bat h ashish Sir

[@TeachToEach]

Oho Lalit ...Thanks Bhai

[@masudrahman8410]

Awesome brother

[@TeachToEach]

Dhanywad

[@riazahmedmalik]

Great

[@TeachToEach]

Thanks Riaz

[@amanbhargava2702]

Most important question in interview

[@vishwajitmane6992]

All video is very excellent

[@TeachToEach]

Thanks Vishwajit

[@vishwajitmane6992]

Can you please send no

[@vishwajitmane6992]

Sir can u tell me which tools and language are required in data analytics

[@SocialMedia-io1tz]

best

[@khushboopunmiya7998]

Please also explain the fuzzy aspect which is coming under merge queries

[@atrt6740]

Which Intel processor is good for running power bi and excel?

[@think3technology640]

DAX Functions ke upar Videos bano.

[@ROHITSINGH-fv2fw]

with your explanation please provide a excel sheet for practice . we can only watch your video never be practices please provide a excel worksheet for every video.

[@awaiaahmad3417]

i am Pakistani , your video very help for me , i am student , i request make video these top SSIS,ssrs,ssas Thanks

[@TeachToEach]

Thanks & Subscribe my new channel "Data Ki Pathshala" for learning Advance excel from beginning : kzbin.info/door/iEXQV0bco3yokjRQgCJIgw

[@ennweeaay6108]

When we have need to to use merge option

[@chandupatil1713]

why city faridabad data not showing in the new colums, faridabad is different city ? waiting for your answer?

[@azizahmedkhan669]

Hi I have 3 excel files with same type of data for 3 different years, how can i append all of them in 1 file

[@satyampandita5229]

Bro can you please provide me the tables for practice purposes

[@techopublikaledefrencho4681]

Yaar tu to zabardast padhata hai waise Bipinrawat apke kounhai😂😂😂

[@TeachToEach]

Mere Jijaji ka Bhai

[@praveentomar124]

How can be apply join more than 2 tables

[@Jitenderkumar-yp1rn]

Sir... kya Merge wala option only matching ke liye hi hota hai...??

[@TeachToEach]

Yes

[@sam80166]

sir, plz share all this excel data file, which you have used in all your videos

[@neerajjain230]

Where i can find part - 15 power bi

[@TeachToEach]

Its not uploaded Bro... Soon you will get Power BI 15

[@prashantvarun23]

where is the dataset

[@rakeshsugandh4301]

bhai apna mobile no de sakte ho,

[@TeachToEach]

Rakesh aap bataye

[@Sanaullahkhan-yh2dx]

nice