Hi Rick,

Well, I think you have a more financial-economic-investment focus on this topic than me. I have started the WikiObjects project proposal from a more costumer/user view,.

Anyway what you comment is quite interesting, I answer between lines:


2017-01-23 23:05 GMT+01:00 Rick Labs <tmp2004@clbcm.com>:

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.

Are you talking about the possibility of using wikidata for calculating GDP or similiar values? for example inclunding sales revenue values in each wikidata product item? If so, I think there are several previous stages to do before even planning this, like what you comment later: well-tagged granular data.

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

There are some useful properties for tagging companies in wikidata, like "Industry"  https://www.wikidata.org/wiki/Property:P452 and ISIC code https://www.wikidata.org/wiki/Property:P1796 

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.

For tagging products there are "Brand" https://www.wikidata.org/wiki/Property:P1716 , "by product of" https://www.wikidata.org/wiki/Property:P2822, or "production statatistics" P2746.

For product properties write a list in https://www.wikidata.org/wiki/Wikidata:WikiProject_Objects

Maybe there is some way for products to inherit properties from company , I mean, if Boing is a company from Airlines Industry , Boing 747 is a product from airlines industry.
 

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.

Maybe first steps should go into ontology direction. 

Another random thought is relating TRADE NAMES, BRANDS and PRODUCTS; along with generic and industry descriptions. PATENT by country is also important.

Properties for brand is "P1716", patent"  is P1246 , for trade names should be necesary to dive into https://tools.wmflabs.org/hay/propbrowse/ searching for also for codenames , IDs , etc...

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.

BOM can achive with "Has part" property P527 , here an exmaple of use https://tools.wmflabs.org/reasonator/?&q=27000417 

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.

Here is one of the places where I see a good application , like https://octopart.com/ but open source

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...

Hehe, incredible I also was thinking in services , but this is even more far , so step by step.

greetings
 


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 (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

_______________________________________________
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata