My data include pictures of some products that I manage to extract their major RGB colors into four columns as displayed in the table below ("product ID", "R", "G", "B"). Now, I want to create the fifth column "color code" to display the actual color from the RGB code. Please see the demonstration here.
I plan to use this "color code" column as a filter. I will show this column as a pallet or a drop-down list so that my users can select the color(s) that they want to see the products or other information. The platform to build the report with the filter will be BI tools (PowerBI/QuickSight) or Excel. Note that my product pictures are currently stored in AWS S3.
My initial plan is to create an image, like a square filled with the color for each product, using its RGB code. Then store those images in the data warehouse and call them for filter later.
Can you please recommend the best way to create the type of color data as described for speed and efficiency?