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.
Of the pillars of linked-data:
* People
* Places (geo-names)
* Organizations (corporate, public, non profit, trade, social....)
* Tme/data(Events)
* Products
I think Products is probably the very most difficult for free/open
source to really address well. And then there are the services...
Rick
On 1/20/2017 6:46 AM, Quico Prol wrote:
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
<https://www.wikidata.org/wiki/Property:P859> (Sponsor) and P176
<https://www.wikidata.org/wiki/Property:P176> (Manufacturer) , It's an
starting point.
2017-01-19 6:10 GMT+01:00 Rick Labs <tmp2...@clbcm.com
<mailto:tmp2...@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
<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 <mailto:Wikidata@lists.wikimedia.org>
https://lists.wikimedia.org/mailman/listinfo/wikidata
<https://lists.wikimedia.org/mailman/listinfo/wikidata>
_______________________________________________
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
