Lipid metabolism is recognised as being central to growth, disease and health. Lipids, therefore, have an important place in current research on globally significant topics such as food security and biodiversity loss. However, answering questions in these important fields of research requires not only identification and measurement of lipids in a wider variety of sample types than ever before, but also hypothesis-driven analysis of the resulting 'big data'. We present a novel pipeline that can collect data from a wide range of biological sample types, taking 1 000 000 lipid measurements per 384 well plate, and analyse the data systemically. We provide evidence of the power of the tool through proof-of-principle studies using edible fish (mackerel, bream, seabass) and colonies of Bombus terrestris. Bee colonies were found to be more like mini-ecosystems and there was evidence for considerable changes in lipid metabolism in bees through key developmental stages. This is the first report of either high throughput LCMS lipidomics or systemic analysis in individuals, colonies and ecosystems. This novel approach provides new opportunities to analyse metabolic systems at different scales at a level of detail not previously feasible, to answer research questions about societally important topics.