DPWBI Combinar Consulta

Summary

This video tutorial guides viewers through combining queries in Power BI's Power Query editor to consolidate sales data. It demonstrates merging three Excel tables: one with sales transactions (city code, product code, and units), one with product details (product code, description, and price), and one with city information (city code and description). The process involves identifying common columns for merging, adding a custom column to calculate total sales, and configuring tables for report generation. The tutorial concludes with creating visualizations to display sales totals by city, product, and seller.