Learn how to create powerful insights from imperfect data by building conditional logic in Power BI. In this Data Survival Skills session, Robin demonstrates how to merge CSV and Excel sources, bringing together wholesale costs and order details into a unified dataset. By walking through step-by-step examples, she shows how to build conditional columns that…
Read More
Learn how to clean and combine data from multiple files in Power BI. Managing monthly files can be tedious—but Power Query’s From Folder command makes it seamless. In this Data Survival Skills session, Robin demonstrates how to combine and clean multiple rebate files stored in a single folder. Instead of manually appending each month’s data,…
Read More
Learn how to choose the right approach when reusing datasets in Power Query. In this Data Survival Skills session, Robin explains the difference between duplicating and referencing queries—and when to use each. By walking through examples in Excel and Power BI, she shows how duplicates create independent copies of your transformed data, while references maintain…
Read More
***For best viewing experience log in to LinkedIn*** June 13, 2023 – Helen Wall returns for this fantastic talk about languages, coding, and data. The discussion covers problem solving, what is and is not programming, and how we determine which tools we should use for different tasks. If any of those topics sound good, you…
Read More