Learn how to choose between merging data into a single dataset or modeling data across multiple related tables in Power BI. In this Data Survival Skills session, Robin demonstrates how to import customer, orders, plants, and vendor data, then explore two approaches: merging queries for a unified dataset and building relationships for a relational model.…
Read More
Learn how to break down combined datasets into clean, structured tables. In this Data Survival Skills session, Robin shows how to normalize data by separating information on plants, vendors, orders, and customers. By identifying relationships like one-to-many links and spotting missing fields such as order dates or IDs, she demonstrates how to model your data…
Read More
Discover how to compare and combine two lists of information to get the full picture. In this Data Survival Skills session, you’ll watch Robin use Excel’s Power Query to analyze top-selling products and top-requested products on the website. By performing a full outer join, she creates a complete dataset that shows both where the lists…
Read More