Archive for April 2023

Learn how to turn detailed records into aggregated datasets that reveal insights without exposing sensitive information. In this Data Survival Skills session, Robin demonstrates how to group customer credit limits in Excel and then scale the analysis in Power BI. By merging client profiles with credit data, she shows how to build state- and city-level…

Learn how to protect sensitive information in reports and presentations by masking data in Excel. In this Data Survival Skills session, Robin demonstrates practical strategies for hiding confidential details—like credit card numbers—while keeping data useful for grouping, sorting, and analysis. Using Excel functions such as LEFT, CONCAT, REPLACE, and REPT, she shows how to reveal…