Data Validation

Enhanced Data Profiling in Power Query: GUI and Table.Profile Function with 2nd Argument

Data Analysis, Data Validation, Power BI, Power Query /

Hello Data Enthusiasts! Sometimes, it’s important to check how good your data is in your tables. Even though you usually do this when getting the data ready to find out if there any outliers or issues with your data for correction, it’s handy to have a report for regular users too. That way, if they […]

Enhanced Data Profiling in Power Query: GUI and Table.Profile Function with 2nd Argument Read More »

Data Validation – Use a Formula to Validate Email Addresses

Data Validation, Excel Tips, Total Posts /

Data validation is a powerful Excel feature that can be used to restrict what data can or should be entered in a cell. You can setup data validation to prevent users from entering invalid data. Fowmy AbdulmuttalibFowmy Abdulmuttalib is a Microsoft-certified business intelligence professional with extensive experience in finance, accounting and data analytics. Currently, he is employed

Data Validation – Use a Formula to Validate Email Addresses Read More »