ID Title Author Label 1 Easy analysis of Excel 2 Excel,ETL,Import,Export 2 Early commute: Easy to pivot excel 3 Excel,Pivot,Python 3 Initial experience of SPL 1 Basics,Introduction 4 Talking about set and reference 4 Set,Reference,Dispersed,SQL 5 Early commute: Better weapon than Python 4 Python,Contrast,Install 6 Handling Alignment Grouping 10 Basics 7 Open-source SPL:The Breaker of Closed Database Computing System 9 SPL,Database 8 The impasse of SQL performance optimizing 6 SQL 9 Enhance Excel Calculations by Clipboard 5 Excel 10 Samples of Comparing Files 8 Compare,File 11 The Open-source SPL Redefines OLAP Server 7 SPL,OLAP 12 SQL Query over File Examples 11 SPL,SQL 13 Detailed discussion on pivot 7 SPL,Pivot,Basics 14 DQL Practices – Data Permission 12 SPL,DQL 15 In Excel, parse hexadecimal numbers and make queries 21 Excel,Parse 16 In Excel, judge whether a word has duplicate letters 17 Excel 17 Writing AWS Lambda Functions in SPL 15 SPL,AWS 18 Excel Column-to-row transposition on a multi-row header Excel file 13 Excel 19 SPL Programming Exercise - Chapter 9 Grouping 12 SPL,Basics 20 Locate Operation on Ordered Sets 14 Basics