Hi Quico,
Thanks for your info about JOINS between PRODUCTS and COMPANIES.
It gets me thinking of just how complex it can be.
Concerning PRODUCTS what instantly pops into my mind (with an
accounting/finance background) is that the PRODUCT object should
ideally fall singularly into one of the COMPANY's reported
SEGMENTS (finest granular detail in public financial statements).
Then there should be a reasonable ability to sum up sales by
company by INDUSTRY. Then each industry should report singularly
into a SECTOR, and the sum of all the sectors should agree with
GROSS DOMESTIC PRODUCT.
For example, here is one listing of INDUSTRIES:
Aerospace & Defense Electronics | Airfreight & Surface
Transportation | Airlines | Alternative Energy | Autos & Auto
Parts | Business, Education & Professional Services |
Chemicals | Electric Utilities | Electrical Equipment &
Multi-Industry | Engineering & Construction | Food Producers |
Food Retailers | Gaming & Lodging | Homebuilders &
Building Products | Integrated Oil | Leisure | Machinery | Master
Limited Partnerships (energy sector) | Metals & Mining | Paper
& Packaging | Restaurants | Retailing/Broadlines &
Hardlines | Retailing/Department Stores & Specialty Softlines
| Semiconductors | Shipping | Software | Telecom & Networking
Equipment.
The above need to be aggregated. For example the following
economic SECTORS:
Basic Materials | Capital Goods/Industrials | Consumer | Energy |
Technology, Media & Telecommunications
International flow of goods (via product category, customs
designations, import/export duties, etc.), regional, national and
full global INPUT - OUTPUT tables, and analysis of transportation
(freight at the regional, state, national and international
levels) -- all very much rely on high quality PRODUCT
classifications at the granular level.
The devil is in the details, especially when there is inter
divisional sales, and inter company ownership. Accountants want to
tabulate direct and indirect COSTS, leading to PROFIT/LOSS.
Economists want to tabulate output and VALUE ADDED, for the most
part unconcerned with INVENTORY buildup. The two models are
difficult to fully reconcile without well tagged granular data.
Another random thought is relating TRADE NAMES, BRANDS and
PRODUCTS; along with generic and industry descriptions. PATENT by
country is also important.
Then from some (distant in my case) exposure to manufacturing
there are things like the RAW MATERIALS, BILL OF MATERIALS,
EXPLOSION of the BoM into manufacturing steps (and lead times,
labor requirement by JOB TITLE), ASSEMBLIES or MODULES, WORK IN
PROCESS INVENTORY, and FINAL PRODUCTS.
I think of the practical aspects of auto parts - all those books
and diagrams, plus all the vendors offering the same part - yet
you still often need an experienced parts counter person (Sherpa /
expert) to get the correct part on the first try. Wiper
blades/spark plugs/oil filter/head lamps cross reference
charts...over time a real nightmare.
Appliance manufacture and spare parts wholesaler "games" with
part numbers to obfuscate reality and maintain proprietary sales
flows.
Non OEM repair parts.
I am interesed in one of its linkages, Products by a company (your last section) , I am started a wikiproject proposal about this https://meta.wikimedia.org/wiki/WikiObject there are several wikidata properties than joins products and companies like P859 (Sponsor) and P176 (Manufacturer) , It's an starting point.
2017-01-19 6:10 GMT+01:00 Rick Labs <tmp2004@clbcm.com>:
I'm taking a look at Company Data on WikiData and its use at WikiPedia. Interested in learning and/or formulating both the short term and long term plans.
I've created a very tentative and preliminary outline of the possible scope under my WikiData user space: https://www.wikidata.org/wiki/User:Rjlabs/WikiData_Company_ Data_Project
Looking for anyone interested in Company Data and its linkages. I have a good background in Company Data, and its analysis from a U.S. prospective but would love participation from UK, EU, Asian and other country company data experts. I especially need guidance from the WikiData developers/oncologists/project management regarding current and potential scope, and potential help with some of the detailed technical aspects.
Feel free to discuss here, email me, or post to the Discussion page related to the above link.
Suggestions as to how to kick this off and connect with all the correct people up front very much appreciated.
Thanks!
Rick Labs, CPA, CFA
_______________________________________________
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata
_______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata