Import and Export Analysis. Simplified

Data & Analysis

Gobal import and export data with multi level product categorization. Read more

Consulting

Import and Export data processing and reporting. See case studies

Trends

Yearly quantity trends for import and export of various products.

Reports

Reporting of key figures in document and graphical format. Sample report

Custom made analytics for your need !

Importer/Exporter
Take data driven decisions and add new products and destinations that are profitable for import/export.
Trade Associations
Trade body in need of import and export summary ? We can help with data and analysis.
Consulting Companies
Leave us with all the data processing activities while you focus on the strategy part for your client
Law Firms
Working on anti-dumping, safeguard or other trade remedies ? We can provide data and analysis as required
Logistics Companies
Define new routes or add capacities to existing one's based on volume trends of import and export

Send us your requirement

Import and Export Data

Multi level product categorization for import and export data

We categorize import and export data in various products with multi level product categorization. For example, let's see for Chapter 72
First level: We categorize the data in broad categories (Steel, Stainess Steel, Ferrous Scrap, Ferro Alloys and Metallics)
Second level: Each of the category is then further categorized. Steel is categorized in more than 30 products like Billets, Wire Rods, Tinplate, etc. Likewise, Ferrous Scrap is categorized as HMS, SS Scrap, etc. Product list for Chapter 72
Third level: Based on specific requirement, a product is then further classified by sub level category. For example, Coated Products as Prepainted or Galvanized, etc or Electrical Steel by Grain/Non Grain Oriented.
Fourth level: Based on client's engagement, we provide further categorization by Grade or Thickness or other parameters. Download a trial pack
The product categorization is done on the basis of key words in the product description and HSN number based on the logic duly agreed with our clients.
We offer ready to use reports for most of the Chapters wherein two levels of categorization is already existing with us. Further customization is prepared basis consulting engagement with clients.

Data visualization and reporting

Whether you need a standard monthly report or a customized solution, we offer Excel based macro reports which are highly customizable, can be accessed offline and easy to share with your team. We also build solutions on Tableu and Google Data Studio. Also, we provide reports in Microsoft Word and PowerPoints as per your requirement.
Ready to download sample files for your reference.
1. Excel based Dashboard for Chapter 72
2. Report on imports under Chapte 72.
3. Report on exports under Chapter 72
4. Report on import of Coated Products.
5. Report on import of Ferrous Scrap
6. Report on import of Aluminium Scrap
7. Report on export of Aluminium Ingots

Download the complete trial pack. Please enter details below and submit.
*Required

Data consulting

Methodology

We provide an end to end solution for your import and export data consulting requirements.
1. Data compiling: We source from inhouse and other providers to prepare the complete raw data based on your requirement
2. Data processing: This is the most critical step wherein we clean the data, remove duplicate entries and then categorize data based on parameters provided by you.
3. Analysis: Based on your requirement, we analyze the data and prepare excel sheets, pivot tables and various charts.
4 Reports: We finally prepare the report based on your required format, document, presentation or excel based dashboard.

Case Study 1 - Categorization of Coated Products

Requirement: Coated products are imported under Chapter 72 primarily in HS codes 7210, 7212 and 7225. The task was to categorize the imports into various products like Prepainted, Galvanized, Galvannealed, etc.
Data Processing: Coated products are categorized in 14 sub-products. A list of key words were compiled for each of the product. Search and categorization based on HS codes and key words were compiled in a program that processed the data and categorized in various products.
Analysis and Reports: Once the data was categorized, analysis and reports were prepared based on quantity imported and price of import.
Inquire now

Case Study 2 - Price trend for Stainless Steel Scrap import for 304 Grade

Requirement: Stainless Steel Scrap (SS Scrap) is the second most imported product under Ferrous Scrap caetgory. SS Scrap comes in various grades like 304, 316, etc. The task was to prepare a price trend for 304 Grade import of SS Scrap.
Data Processing: A list of SS Scrap grades was compiled and then the data was categorized by various grades.
Analysis and Reports: Once the data was categorized, a trend of import price was prepared for import of SS Scrap 304 Grade.
Inquire now

Case Study 3 - Non Grain Oriented (Electrical Steel) analysis by Grade

Requirement: One of our clients, a leading company that imports Electrical Steel wanted a report on the import of Non Grain Oriented Electrical Steel by Grade. Electrical Steel is imported under Chapter 72.
Data Processing: Two steps were involved here. Firstly, the data was categorized in GO and Non Grain Oriented. Secondly, once the Non Grain Oriented data set was available, a list of grade was compiled and then the data was categorized by various grades.
Analysis and Reports: Once the data was categorized, analysis and reports were prepared based on quantity imported and price of import for Non Grain Oriented.
Inquire now

Case Study 4 - Stainless Steel Coils - Extracting Grade, Width and Thickness

Requirement: Stainless Steel Coils are one of most imported products under Chapter 72. Some of our clients were in need of data to be categorized by Grade. Additionally they required Width and Thickness to be separately mentioned.
Data Processing: Firstly the data was categorized by Grade. Secondly, our analytics team worked on compiling a program that extracted thickness and width from product description. The data was then categorized by grade, thickness and width.
Analysis and Reports: Once the data was categorized, analysis and reports were prepared based on quantity imported and price of import.
Inquire now

Case Study 5 - Preparing a dashboard with custom made reports for Chapter 72 import and export

Requirement: Import and export data is a large data set that keeps on adding every month with new data. Several of our clients wanted a ready made report to evaluate fixed parameters every month, for example, A report organized in descending order of quantity for imports from various countries along with import price.
Data Processing: Import and export data for Chapter 72 was categorized by various products on the basis of HS codes and keywords present in product description.
Analysis and Reports: Once the data was categorized, an Excel based dashboard was prepred with 5 most common used reports that users could click on and see the reports.
Inquire now