Scribd
Upload
12 views6 pages

Taxonomy and Data Analysis Overview

Amrutha Varshini.DS is a senior data analyst from Mysore with over 7 years of experience, having worked on various projects involving data cleansing, enrichment, and quality checks. She has contributed to creating item repositories and automation tools to streamline product classification and data normalization. Amrutha aims to grow professionally and financially while leveraging her skills in the digital commerce and MDM domains.

Uploaded by

jagga024
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views6 pages

Taxonomy and Data Analysis Overview

Amrutha Varshini.DS is a senior data analyst from Mysore with over 7 years of experience, having worked on various projects involving data cleansing, enrichment, and quality checks. She has contributed to creating item repositories and automation tools to streamline product classification and data normalization. Amrutha aims to grow professionally and financially while leveraging her skills in the digital commerce and MDM domains.

Uploaded by

jagga024
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Good morning/Good afternoon sir

➢ I’m Amrutha [Link]. ‘m from Mysore. I completed my schooling in Mysore. I graduated


from Bahubali College of engineering in electronics and communication, I’m 2014 passed out.
➢ I joined unilog content solutions in 2014 as a Data analyst. I’m presently working as senior data
analyst with 7+ years’ experience
➢ I have worked in projects namely Crescent electric, Grainger, SDI, Orgill. In this projects I have
done data cleansing and data enrichment
➢ Later I joined BPT project there I used to do quality check for data enriched files, After QC we
initiate delivery process, in this step we run a Unilog vertical tool for features and attribute
labels normalisation and also we use description tools to run descriptions for TD(120), LD and
SD(40)
➢ Then I joined process engineering team in 2018 by cracking internal job posting conducted by
Unilog. My main task in PE team was creating Item repository, Master taxonomy and supporting
the creation of automation tool
*Item Repository and Master Taxonomy: From the previously existing data base we created a
common and unique taxonomy and also done data revamping to normalise the product data
* Automation Tool: Coming to automation part, we helped in creation of data base by providing
keywords or synonyms so that this data base would help in minimizing the human involvement
in creating taxonomy
(The main intension of the automation tool is to automatically classify the products by simply
providing keywords such as Product name, product name synonyms, MFR, Brand, [Link].,
descriptions etc.)
➢ I have mainly worked on taxonomy for industrial control, lamps and wiring devices
➢ Presently ‘m part of US QA team. Here we do quality analysis for all the completed Unilog files

I want to grow by learning and improving myself in this domain. I also want to grow professionally and
financially to look after my parents.

➢ Taxonomy: Product categories and subcategories organized in hierarchical structure(It is a 3 or 4


level hierarchical structure)
➢ Classification: The placement and organization of products into their respective
categories(Noun/Modifier, Hierarchical structure, UNSPSC, ETIM)
➢ Data Enrichment: Product enrichment is also known as catalog enrichment. The practice of
adding relevant information to products or catalogs to help users to find relevant products
easily (Using Client raw data we identify noun/modifier, data source using MFR & [Link], extract
information like features application, attribute values, image, pdf etc. from MFR and third party
sites)
➢ Data Cleansing: In this data cleansing we just extract product information from the input
descriptions to fill the attribute values
➢ Data Normalization/Standardization: It is set of rules and standards given by clients it is followed
to make sure that data is clean and consistent to share across different divisions
➢ Template: Set of attribute(Defining attributes(Size), Mandatory attributes(Material, colour),
Common attributes(other specifications)

TAXONOMY, SCHEMA and SKU BUILD TEST (TSST)


UNSPSC: United Nation Standard Product Service Code (8 digit)
00 00 00 00 (Segment, Family, class, commodity)
12 – Chemicals (Additives, Solvents, Wax, Oil)
14 – Paper Materials (Paper Materials, Paper Products)
15 – Fuels (Fuels, Lubricants)
21 – Farming and Fishing Equipment’s (Agricultural, Forestry and Landscape, Fishing and
Aquaculture equipment)
23 – Industrial Equipment (Industrial Manufacturing and Processing Machinery and Accessory)
(Industrial Drilling Tools, Industrial Milling Tools)
24 – Material Handling (Trucks, Storage Bins, Basket, Bags, Tank, Cylinder, Packaging Materials)
25 – Military and Private Vehicles and Accessories and Components (Motor Vehicles, Railway
and Tramway Machinery and Equipment, Aircraft, Transportation Components and Systems)
26 – Power Generation and Distribution Machinery and Accessories (Motors, Batteries, Power
Generators and Electrical Wires)
27 – Tools and General Machinery (Hand Tools, Pneumatic/Hydraulic Machinery & Equipment)
31 – Manufacturing Components and Supplies (Bearing, Bushing, Seals, Gaskets, Hardware,
Paint, Primers, Tape Sealants) 30- Plumbing
32 – Electronic Component (Resistors, Capacitors, Diode, Transistor)
39 – Electrical (Lamps and Lightbulbs and Lamp Components, Electrical Boxed and Enclosures,
Fuse, Circuit Breakers, Electrical Switches and accessories)
40 – Distribution and Conditioning System (Cooling Equipment and Parts and Accessories,
Ventilation, Boilers, Pipe Fittings, Valve, Duct, Hoses, Pumps, Filters)
41 – Laboratory and Testing Equipment (Temperature/Humidity and Heat Measuring
Instruments, Pipettes, Test Tubes)
42 – Medical Equipment (Dental Equipment and Supplies, Patient Clothing
43 – Information Technology and Telecommunications (Communication Devices, Mobile Phones,
Radio, Computer and Accessories, Network Equipment, Datacom and Network Connectivity,
Fibre Optic Cable, Patch Connector, Patch Panels, Software)
44 – Office Equipment (Calculators, Desk Supplies, Writing Instruments)
45 – Printing and Photographic and Audio and Visual Equipment and Supplies (Printing and
Publishing Equipment, Photographic or Filming or Video Equipment, Cameras)
46 – Defence and Law Enforcement and Security and Safety Equipment and Supplies (Light
Weapon, Missiles, Personal Safety and Protection, Safety Apparel, Footwear, Safety Glasses,
Mask, Gloves, Ear Plugs)
47 – Cleaning Equipment (Water Treatment and Supply Equipment, Laundry, Dry Cleaning
Equipment, Ironing Machines, Trash Bags, Vacuum Cleaner)
49 – Sports Equipment (Fitness Equipment’s, Sports Accessories)
50 – Food Beverage (Meat, Nuts and Seeds, Sea Food, Dairy Products, Nutritional Supplements)
51 – Drugs and Pharmaceutical Products (Drugs, Antibiotics)
52 – Domestic Appliances (TV, Fridge, Dish Washer) 53 – Personal Care
56 – Furniture (Office Furniture, Outdoor Furniture)
60 – Musical Instruments (Keyboard Instruments, Violins, Guitars)

TAXONOMY, SCHEMA and SKU BUILD TEST (TSST)


# Motors: Motor is machine that converts electrical energy to mechanical energy
* AC Motor (Brushless)
* DC Motor (Brushed/Brushless)
* Direct Drive
* Linear Motors
* Servo Motors
* Stepper Motors (Electrical Motors| AC Motors)
Type, Voltage, Amperage, Wattage, Frequency, Phase, RPM, HP Rating, Shaft Size, Mounting
Type, Rotation, Temperature, Dimensions(Example: Electric Motors, Fan)
# Light Bulb: Electrical Bulb is a device which produces light when electricity is passed through
its terminals
* Incandescent Lamps
* Compact Fluorescent Lamps
* Halogen Lamps
* LED Lamps (Lamps & Lightbulbs|Incandescent Lamps|Incandescent – Reflective)
Type, Voltage, Amperage, Power Rating, Frequency, Lamp Designation, Shape, Lamp Type, Lamp
Base, Lumens, Average Life, Ballast Type, CRI, Colour Temperature, Lamp Finish, Beam Type,
Beam Angle, Dimmable, Enclosure Type, Mounting Type, Bulb Material, Colour, Temperature,
Dimensions

# Circuit Breaker: It is an automatic switch designed to protect an electrical circuit from damage
caused by excess current from short circuit
* Standard Breakers (Distribution Equipment & Accessories|Circuit Breakers|Arc-Fault Circuit
Breakers)
* Ground Fault Interrupter Circuit Breakers (GFCI)
* Arc Fault Interrupter Circuit Breakers (AFCI)
Type, Voltage, Amperage, Frequency, Phase, Interrupt Rating, Frame, Trip Type, Trip Range,
Number of Poles, Actuator Type, Connector Type, Wire Size, Mounting Type, Temperature,
Material, Colour, Finish, Dimensions

# Fuse: It is a safety device that protects electrical circuits from the effects of excessive currents
* AC Fuse(Fuses, Blocks & Holders|Special Purpose Fuses|Cartridge Fuses)
* DC Fuse
* Cartridge Fuse
* High Voltage Fuse
* Thermal Fuse
*Automotive, Blade/Bolted Fuses
* SMD (Surface Mount Fuse)
Type, Voltage, Amp, Indicating/Non Indicating, Rejection/Non-Rejection, Interrupt Rating, Class,
Frequency, Response Time, Terminal, Mounting, Body Type, Element Type, Body Size, Material

TAXONOMY, SCHEMA and SKU BUILD TEST (TSST)


# Bearings: A Bearing is a machine element that’s constrains relative motion to only the desired motion
and reduces friction between moving parts. (Bearings|Ball Bearings|Angular Contact Ball Bearings)

* Ball Bearing, Cylindrical Bearing, Tapered Bearing, Needle Bearing

Type, Bore Diameter, OD, Number of Rows, Width, Closure Type, Load, Bearing Material, Seal Material,
Cage Material, Speed, Temperature, Finish

# Valves: A Valve is a device or natural object that regulates, directs or controls the flow of a fluid by
opening, closing or partially obstructing various passage ways.

* Isolation Valves: Ball, Butterfly, Diaphragm, Gate, Pinch, Piston & Plug Valves

* Regulation Valves: (Valves & Actuators|Fire Valves| Fire Butterfly Valves)

* Relief Valves: Pressure release and vacuum relief valves (Valves & Actuators|Shut-Off Valves|Ball
Valves)

* Non- Return Valves: Swing Check and Lift Check Valves

Type, Nominal Size, Connection Type, Pressure Rating, Opening Size, Body, Ball, Seat, Seal, Stem
Material, Packing, Actuation/Operator, Flow (Cv), Industrial Standards, Construction, Temperature

# Pump: A Pump is a mechanical device that uses to transfer different fluids from one location to
another (Pumps & Filtration|Hydronic Pumps|Hydronic Circulating Pumps)

* Axial Flow Pump

* Centrifugal Pump

* Piston Pump

* Plunger Pump

* Rotary Pump

* Reciprocating Pump

* Submersible Pump

Type, Voltage, Amperage, Power Rating, Frequency, Pressure, Flow Rate, Inlet Size, Outlet Size, Max
Head, Maximum Suction Lift, Viscosity, Speed, Cord Type, Mounting, Temperature, Dimensions

# Fittings: A fitting is adapter is used in pipe systems to connect straight section of pipe (Elbow, Tess,
Couplings, Unions, Plugs and Valves)

Adapter Sleeve: Type, Shaft, ID, OD, OAL, Thread Size, Width, Material
Locknut: Type, Thread Size, Thread Direction, Height, Material, Finish, Temperature

TAXONOMY, SCHEMA and SKU BUILD TEST (TSST)


Industrial Controls
Industrial Control & Automation | Motor Controls & Accessories |Contactors (Definite Purpose
Contactors, IEC & NEMA)
Industrial Control & Automation |Motor Controls & Accessories |Starters (IEC & NEMA)
Industrial Control & Automation |Motor Controls & Accessories |Relays |Overload Relays
Industrial Control & Automation |Motor Controls & Accessories |Relays |General Purpose Relay

Industrial Control & Automation |Control Stations & Accessories |Pilot Light Control Stations
Industrial Control & Automation |Control Stations & Accessories |Pushbutton Control Stations

Industrial Control & Automation |Drives & Accessories |AC Variable Frequency Drives

Industrial Control & Automation |Pushbutton, Pilot Light & Switch Accessories |Pushbutton
Legend Plates
Industrial Control & Automation |Pushbutton, Pilot Light & Switch Accessories |Pilot Light
Legend Plates

Industrial Control & Automation |Pushbuttons & Pilot Lights |Pushbuttons |Illuminated |
Explosionproof
Industrial Control & Automation |Pushbuttons & Pilot Lights |Pushbuttons |Non-Illuminated
|Explosionproof

Industrial Control & Automation |Barcode Scanners & Readers |Barcode Scanners
Industrial Control |Power Supplies |DC Power Supplies

Industrial Control & Automation |Limit Switches & Accessories |Rotary Actuated Limit Switches
|General Purpose
(Volt, Amp, watt, Number of poles, Contact type, Contact configuration, Contact rating,
mounting, temp, dimensions)

Switches: it interrupts the current flow in the circuit


Wiring Devices| Safety & Disconnect Switches |Toggle Switches, Decorative Switches, Rocker
Switches, Fan Control Switches, Motor Switches, Keylock Switches, Tumbler Switches, Paddle
Switches, Pull Chain/Cord Switches, Rotary Switches
(Volt, Amp, Frequency, Power Rating, Contact Configuration, Number of poles, mounting,
enclosure, temp, Dimensions)
Wiring Devices|GFCI Devices|GFCI Receptacles
Wiring Devices|Straight Blade Devices|Surge Protection Isolated Ground Receptacles

Patch Cords
Wires and Cables| Data Communications and Networking| Fiber Optic Systems| Patch Cord

TAXONOMY, SCHEMA and SKU BUILD TEST (TSST)


(Coductor Size, Conductor Type, Connector Type, Strand, Vol, Amp, Cord Length, Inculation
Material, Jacket Material, Colour, Temperature)
Wires and Cables| Data Communications and Networking| Fiber Optic Systems| Cable
Assemblies
Wires and Cables| Data Communications and Networking| Copper Systems| Cable Assemblies
Patch Cords, Patch Panels, Modules, Connectors and Plugs

Lights
Lamps & Lightbulbs|Incandescent Lamps|Incandescent – Reflective, Flood Bulbs, Coated,
Decorative, Specialty, General Purpose, Tubular, Globe, A-line

Lamps & Lightbulbs|Fluorescent Lamps|Fluorescent – Circline, U-Bent, Coated, Liner, Compact,


Speciality
Lamps & Lightbulbs|Halogen Lamps|Halogen - A-Line, Tubular, Reflector, Speciality, Decorative

Lamps & Lightbulbs|High Intensity Discharge|HID - Metal Halide, HID - Low Pressure Sodium,
HID - High Pressure Sodium, HID - Mercury Vapor, HID – Coated

Lamps & Lightbulbs|LED Lamps|LED – Reflective, Linear, Decorative, General Purpose, U-Bent,
Tubular
Capacitor: It is store electrical charge
Resistor: Is has an electrical resistance it is used in electrical circuit for protection
Transistor: It is semiconductor device used to amplify electrical signals
Transformer: It is device that transfers electric energy from one AC circuit to one or more other
circuits either increasing or reducing voltage

Codifyd has 20+ years’ experience, It is serving both B2B and B2C distributors
Main Head Quarters in Chicago
Founder: Sanjay Agarwal is founder & CEO
Codifyd excels in digital commerce services, MDM implementation and maintenance, Content
and data service and ecommerce implementation
This is company is one of the leading companies in MDM and ecommerce domain
I hope I can learn and contribute towards the company in a positive way with my skills and
knowledge in this domain
I will extend working hrs and complete assigned work soon instead of working hard I will work
smart
I want to grow and improve myself in this domain and also I want to grow professionally and
financially
Thanks for the interview have a wonderful day

TAXONOMY, SCHEMA and SKU BUILD TEST (TSST)

Common questions

Powered by AI

Categories such as Electronics (32 – Electronic Component) and Information Technology and Telecommunications (43) might present the most complexity in classification due to the rapid advancement and constant evolution of products in these fields. The diversity of components such as resistors, capacitors, and network devices adds to the complexity, requiring detailed attribute data and accurate classification to keep up with new releases and specifications .

An automation tool reduces human involvement in taxonomy creation by using a database of keywords and synonyms to automatically classify products. By providing details such as product name, synonyms, manufacturer, brand, part numbers, and descriptions, the automation tool can organize products into appropriate categories without the need for manual classification. This streamlines the process, increases efficiency, and reduces potential human error .

A master taxonomy organizes product categories consistently across a company's catalog, enabling more efficient management by simplifying product classification and retrieval. It helps in maintaining data uniformity across different platforms and can enhance searchability, ensuring that customers and internal systems have clear and logical structures to access products. This can effectively reduce errors in product listings and improve the customer experience by making it easier to find related items .

Data enrichment enhances the overall quality of a product catalog by adding relevant information which helps users find products more easily. This is achieved by identifying nouns and modifiers from client raw data, extracting features, application details, attribute values, images, and PDFs from manufacturers and third-party sites. This process ensures the catalog is informative and detailed, improving user experience and searchability .

A data analyst might face challenges in maintaining consistency as different divisions may have varying standards and requirements. Ensuring that normalization rules and standards are effectively communicated and followed requires careful coordination and regular review. Additionally, integrating disparate data sources without losing critical information and ensuring that all divisions align with the normalized data format can be complex and require continuous updates and monitoring .

Using standardized coding systems like UNSPSC facilitates global trade and logistics by providing a common language for identifying products. This standardization improves communication between international trading partners, enhances procurement processes, and simplifies compliance with trade regulations. It also aids in inventory management and data analysis, allowing companies to maintain consistency and accuracy across various markets .

An effective data cleansing process is critical to maintain the accuracy of a company's product database as it involves extracting and correcting errors in product information. By ensuring that attribute values are correctly filled from input descriptions, data cleansing allows for consistent and precise product listings, minimizing the risk of misinformation. This accuracy is crucial for improving product discoverability, ensuring regulatory compliance, and maintaining a competitive edge in customer satisfaction .

The key elements involved in taxonomy development include creating a common and unique hierarchical structure, often 3 or 4 levels deep, which organizes products into categories and subcategories. This involves the use of data from existing databases, data enrichment to add relevant information, and data normalization/standardization to ensure consistency across divisions. Automation tools are also used to minimize human involvement by classifying products using provided keywords, such as product name and synonyms, manufacturer, brand, and descriptions .

Relays and circuit breakers both serve as protection and control devices in electrical circuits but differ significantly in their functions. Relays are used to switch circuits on and off by controlling a high-power circuit with a low-power signal, suitable for signal transmission and control circuits. In contrast, circuit breakers are designed to automatically interrupt current flow to protect an electrical circuit from damage caused by overloads or short circuits, providing more direct protection by cutting off power supply in the event of a fault .

Attributes enhance the searchability and usability of product data sheets by defining specific product characteristics, such as size, material, and color. This detailed information allows users to filter and search for products more precisely, improving user experience. Defining mandatory, common, and optional attributes ensures that essential information is always available, facilitating easy comparisons and informed decision-making .

You might also like