Midelco data model

Table Articles

Table Article Sales

Table Brands

Table Maingroups

Table Subgroups

Table Groups

Table Suppliers

Table Shops

Table Seasons

Table Colors

Table Subcolors

Table Themes

Table Countries

Table Cities

Table Bullet Details

Table Bullet Groups

Table Eancodes

Table Web Action Codes

Table Web Retour Reasons

Table Web Group Subtypes

Table Parameter Types

Table Parameters

Table Article Bullets

Table Article Links

Table Article Model Links

Table Customers

Table Card Registrations

Table Sales Period

Table Article Prices

Table Stocks By Article

Table Stocks Per Shop

Magical SQL for Midelco with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Ready to get instant access to
all your company data ?