Vizly: AI-powered data analysis

Try for yourself

Analyzing Inventory Data from Excel with Visualization

VP_Test.xlsx

Missing file

Visualize inventory distribution by brand.

Can you tell me the inventory on hand by client and Class

Sure! I'll calculate the inventory on hand by Client and Class.
Here is the inventory on hand by Client and Class:
ClientClassOn Hand
AltairKey Card19000.0000
AltairUmbrella350.0000
BiltmoreKey Card82000.0000
Courtyard InnKey Card17000.0000
Hotel SaintBody Lotion231.0000
Hotel SaintBody Wash270.0000
Hotel SaintConditioner279.0000
Margaritaville Times SquareKey Card15000.0000
Marriott BonvoyKey Card30000.0000
MosaicKey Card8000.0000
MosaicLuggage Tag14000.0000
Renaissance HonoluluUmbrella200.0000
SmythLuggage Tag8000.0000
The ElserKey Card80000.0000
The GatesKey Card12000.0000
The GregorianKey Card9000.0000
The JosephKey Card40000.0000
The NewburyKey Card21070.0000
ViceroyKey Card168000.0000
ViceroyLuggage Tag15000.0000
xBody Lotion397148.5000
xBody Wash94361.0000
xCandle12.0000
xConditioner105823.6216
xHand Wash34848.0000
xKey Card74000.0000
xLuggage Tag28000.0000
xRestaurant3606.0000
xShampoo105002.8128
xUmbrella500.0000
Feel free to ask any more questions you may have!

can you visualize the amount of body wash that we have on hand

Sure! I'll visualize the amount of body wash that we have on hand.

Vizly

AI-powered data analysis

Try for yourself