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 Hindi | Power BI ...  
2) Power BI Building Blocks | Power BI Tutorial for Beginners in Hindi:    • Power BI Building Blocks | Power BI T...  
3) How to Download Power BI | Power BI Desktop को कैसे Download करे | What is Power Bi in Hindi:    • How to Download Power BI | Power BI D...  
4) Import File from Excel Notepad Web to Power BI Desktop in Hindi | Power BI Desktop Tutorial in Hindi:    • Import File from Excel Notepad Web to...  
5) Power BI Query Editor Tutorial in Hindi | Power BI Desktop Tutorial in Hindi:    • Power BI Query Editor Tutorial in Hin...  
6) Power BI Choose/Remove column in Hindi | Power BI Tutorial for Beginners in Hindi:    • Power BI Choose/Remove column in Hind...  
7) Power BI KEEP & REMOVE Rows Hindi | Power BI Tutorial for Beginners in Hindi | Delete Row in PowerBI :    • Power BI KEEP & REMOVE Rows Hindi | P...  
8) Power BI Split Column in Hindi | Power BI Tutorial for Beginners | How to split column in Power BI :    • Power BI Split Column in Hindi | Powe...  
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 Power BI Hindi...  
10) 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 ...  

   / teachtoeach  
My Social Account Links Available Below: -
Facebook Page: www.facebook.com/Teachtoeach
Personal Facebook ID:   / thissideash  
Instagram Account:   / thissideash  
Twitter:   / teachtoeachh  
#powerbi #mergevsappendqueries #mergequeries #appendqueries #powerbitutorialforbeginners