FOLLOW US     
           
    + 34 951 16 49 00    
Spanish Italian English
ERASMUS+

Accelerating Cross-Border transaction of SME

Business Intelligence Sources and Resources for SMEs' Internationalization
Descargar    Play Audio

Introduction

The following script tries to introduce new terms, databases, methods and methodologies on the field of BI (business intelligence: https://en.wikipedia.org/wiki/Business_intelligence) for SMEs (small-and-medium-sized-enterprises: https://en.wikipedia.org/wiki/Small_and_medium-sized_enterprises). The conception of the script is the following:

introduction of basic knowledge elements (like translation potential, lexica)
declaration of tasks for learning by doing (see exercises) 
demonstration of useful resources (e.g. databases, analytical tools)
signalisation of phenomena in advanced level

The script would like to support the “learning by doing” principle and to increase the capability to handle alone successfully and efficiently. The SMEs should be able after the using this script to use this general knowledge for solving other problems even in an autodidactive way effectively…

The consequences listed for each topic summarize the most important sentences about BI for SMEs on the field of internationalisation.

Definitions – basic level
The following chapters try to introduce the phenomenon “being internationalised” from the point of view of languages: 

Lacks on translation potential - WIKIPEDIA
As you could already see, almost each topic can be interpreted in a successful way based on the WIKIPEDIA (and other online lexica-like sources). They are free and good enough to introduce seemingly complex phenomena. The entrepreneurs can derive a feeling about the potential of being internationalised if they check in WIKIPEDIA whether a term descripted in English is also presented in the own language?! 

The cultures having lacks of translations and/or own preparation works in lexica can have a higher risk potential being not up-to-date enough… It is important: there can be more articles in case of similar keywords: https://en.wikipedia.org/wiki/Internationalization

Examples: 
in case of the term “business intelligence” there are articles in 37 languages. 
The same value is in case of the term “SME” is 30.
Tasks/exercises: 
Please, check each term used in this script in WIKIPEDIA and 
in case of lacks try to create the appropriate article in your own language!
Consequences: 
The less is the capability of following the trends in the world, 
the less is the internationalisation potential.

EUR-LEX
The general services (like https://translate.google.com/, where you can also translate complex phrases (cf. https://translate.google.com/#en/hu/business%20intelligence), can not always deliver adequate solutions. 
However, for specific terms detailed definitions can be offered to: e.g. https://translate.google.com/#en/hu/windchill. 
In case of frequently, wide-ranged used terms (like: turnover - https://translate.google.com/#en/hu/turnover) there can be valid a lot of meanings. Some of online translation services make possible to hear, how expression should be used in spoken environments or which language is belonging to a given term at all?
If a term was ever used in legal contexts in the EU, then the services of EUR-LEX (http://eur-lex.europa.eu/homepage.html?locale=hu) can be involved to clarify, what should be searched in an other (official) language: e.g.  

Examples: 
First step for using EUR-LEX is a definition of a search term / keyword: e.g.
http://eur-lex.europa.eu/search.html?qid=1477727434259&text=sme&scope=EURLEX&type=quick&lang=en 

The second step is to identify an appropriate rule: e.g. http://eur-lex.europa.eu/legal-content/HU/TXT/?qid=1477727434259&uri=CELEX:32013R1287

The last step is to search for the term in the description in the original and after that in the targeted language(s). It can be, that one-word-terms in a given language are presented in other languages just a phrase…

Tasks/exercises: 

Please, try to follow the above mentioned steps 

for arbitrary chosen terms by you!

Consequences: 

The less is the capability of searching for adequate phrases,

the less is the internationalisation potential.

Abbreviations
Nowadays a lot of abbreviation are used in general. 
To identify what do they stand for, is relative simple: 
Examples: 
http://www.abbreviations.com/SME or e.g. 
http://www.acronymfinder.com/SME.html
Tasks/exercises: 
Please, filter each abbreviation from this script and 
check a set of them in the suggested services!
Consequences: 
The less is the capability of following the trends of languages, 
the less is the internationalisation potential

Terms
In this chapter terms will be briefly explained and 
for additional information further URLs will also be presented:
Examples:
BI – „Business intelligence (BI) can be described as "a set of techniques and tools for the acquisition and transformation of raw data into meaningful and useful information for business analysis purposes” https://en.wikipedia.org/wiki/Business_intelligence 

internationalization: “For the term in computing, see Internationalization and localization. In economics, internationalization is the process of increasing involvement of enterprises in international markets, although there is no agreed definition of internationalization. There are several (25) internationalization theories which try to explain why there are international activities.” https://en.wikipedia.org/wiki/Internationalization 

Online data assets for SMEs on the field of internationalization

Each of the following URLs should be investigate in detail. Why?

The general statistics make possible to detect differences between objects like countries, counties, settlements, branches, etc. Country profiles (as the quasi most frequently created comparative views) offer chances to see in a simple way, how other cultures think about the same phenomena…

The Google Trend Services can be seen as a kind of marketing survey service (free of charge). By using of Google Trends services it is possible to explore, what kind of trends were valid for searching terms over 10 years according e.g. countries, topics, media channels…

The enterprise information can be important for analyses of competitions…

Real estate information help e.g. in case of searching for new headquarters…

Price/performance comparison of products/services support also the analyses about competitors…

The following data sources are worth testing for own purposes:
International statistics like
UNO: http://www.un.org/en/databases/index.html 
OECD: http://stats.oecd.org/ 
EUROSTAT: http://ec.europa.eu/eurostat/data/database 
Stock markets: 
https://www.bloomberg.com/markets/stocks 
http://www.reuters.com/finance/global-market-data 
Currency exchange rates
http://www.x-rates.com/
http://fx-rate.net/historical/ 

The following data sources are worth testing for own purposes:
International statistics like
FADN (farm accountancy data network: http://ec.europa.eu/agriculture/rica/database/database_en.cfm) 
FAO: http://faostat.fao.org/ 
Solvency/risk indices for 
enterprises (e.g. from CREDITREFORM, or http://e-beszamolo.kim.gov.hu) 
countries (e.g. from Moodies, Fitch Ratings, etc.)

The following data sources are worth testing for own purposes:
Google Trends information about search activities in diverse topics: https://www.google.com/trends/ 

Real Estate information: 
http://rochester.nydatabases.com/database/real-estate-database
https://en.wikipedia.org/wiki/Category:Online_real_estate_databases 

Price-performance information of products/services
https://www.shopify.ca/blog/7068398-10-best-comparison-shopping-engines-to-increase-ecommerce-sales 
http://www.ebizmba.com/articles/shopping-websites
… (further recommendations)

Tools/methods/techniques

The below listed terms can/may only be learned following the principle “learning y doing”. Of course, this “doing” can also be a kind of virtual activity like interpreting Youtube-videos:
OLAP: 
http://olaponline.radar-soft.com/Demos/HtmlOLAPAnalysis.aspx
http://miau.gau.hu/olap 
pivot: 
see Excel, - https://www.youtube.com/watch?v=Vx-Fuw46VbY 
or Open Office - https://www.youtube.com/watch?v=UbShK4TF6OI 


expert system generation: http://miau.gau.hu/myx-free/ego/ 

MS Office – Excel: SOLVER - https://www.youtube.com/results?search_query=using+excel+solver 

similarity analysis (online and free): http://miau.gau.hu/myx-free/coco/index.html 

GIS tools (e.g. Google Maps API – in advanced level)

… (further recommendations)

Examples: see Youtube-videos

Tasks/exercises: Define task for yourself based on the further modules in the course (see next slide)

Consequences: Without appropriate methods, techniques, the using of data can not help enough!

Creating scenarios for impact simulation of trading, marketing actions
Deriving price/performance ratios in frame of public procurement processes
Forecasting of future values in the markets
Exploring connections between variables/force fields in the markets
Calculating indicators for benchmarking
Reporting time series for competitor’s characteristics



Keywords

Business Intelligence course

Description

The following script tries to introduce new terms, databases, methods and methodologies on the field of BI (business intelligence: https://en.wikipedia.org/wiki/Business_intelligence) for SMEs (small-and-medium-sized-enterprises: https://en.wikipedia.org/wiki/Small_and_medium-sized_enterprises). The conception of the script is the following: introduction of basic knowledge elements (like translation potential, lexica) declaration of tasks for learning by doing (see exercises) demonstration of useful resources (e.g. databases, analytical tools) signalisation of phenomena in advanced level

Bibliography