Data Validation Custom Rules

Data Validation

Below is an example of data validation where I created a custom rule that makes it that the date a vendor received via ACH must be in year of 2024, more than 2 days after processed date, and cannot fall on either a Sunday or Saturday. I used the AND, YEAR, WEEKDAY, and < >(does not equal) symbols in my formula.


Comments

Post a Comment

Popular posts from this blog

Ranking of UC Schools from Top 110 Ranked National Universities of 2024

Link to GitHub:  https://github.com/sgng-hub/2024unviersityranking Link to Dataset: https://www.kaggle.com/datasets/raymondtoo/the-world-university-rankings-2016-2024 Dataset Official Source: https://www.timeshighereducation.com/world-university-rankings/2024/world-ranking This project is about writing SQL query to find the ranking of top 110 world universities that are part of the University of California System I included a link to Looker Studio visualization of the query     
Read more

Remove Duplicates

Image
One Way to do this is to use the UNIQUE funciton, which is what I often use. For example, I have several vendor codes for different invoice number. Use the Unique function and it will remove all duplicates and give you only the unique vendor codes. This is helpful when I do entry in the accounting software, especially when there is over 500+ lines of vendor codes. Alternatively, you can use ALT + A + M to remove duplicates, so definitely will start using that more!
Read more

Power BI

Image
First of all, all credit goes to Linkedin Learning and Joshua Rischin, Company Director of Axium Solutions. I watched the video and followed along how to create a dashboard using Power BI. There is a title, a line chart, waterfall chart, and a slicer to filter for a specific state's sale on top right. Most notably, if I clicked on one of the bars on the waterfall chart, then it the line chart above will also filter for that specific product category. Please see Power BI screenshots below How it Looks in Power BI Exported into Powerpoint
Read more