SPL Desktop Analysis
Data Analysis
- What to use for data analysis programming, SQL, Python, or esProc SPL?
- Something Would Free Data Scientists from Heavy Coding Work
- After Excel, What Data Analytics Tool Do We Need
- This Is Probably the Most Interactive Data Analysis Programming
- This Is Probably the Best Exploratory Data Analysis Tool
- This is probably the most user-friendly programming for Excel data analysts
- This Is Probably the Most Perfect Programming for Solving SQL Data Analysis Pain Points
- Using SQL for data analysis seems to be a false proposition
- Excel’s Advantages and Disadvantages in Data Analysis
- Data Analysis from Excel to SPL: Facing Big Data
- What Tool You Need for Quantitative Modeling? Try SPL!
- SPL, a very tool for developing quantitative strategy model
- Analytic Techniques for Business - Excel to esProc Desktop
- A laymen’s roadmap for data analysis and processing technology
- How do beginners learn SQL quickly?
- SQL is consuming the lives of data scientists
- Data Preparation Script: Python Pandas OR esProc SPL?
- Comparison between SPL and Python in processing structured data
- Looking for the Best Lightweight Data Analysis Script Tools
- Looking for suitable tools for querying and calculating large files
Practice
- Data Analysis Programming from SQL to SPL: Consecutively Rising Stocks
- Data Analysis Programming from SQL to SPL: Stock Rise Analysis
- Data Analysis Programming from SQL to SPL: Stock Indicator Calculation
- Data Analysis Programming from SQL to SPL: User Event Statistics
- Data Analysis Programming from SQL to SPL: User Event Statistics - Continued
- Data Analysis Programming from SQL to SPL: Sequential Events
- Data Analysis Programming from SQL to SPL: Population and Language Analysis
- Data Analysis Programming from SQL to SPL: Airport Analysis
- Data Analysis Programming from SQL to SPL: Medical Visit Records Analysis
- Data Analysis Programming from SQL to SPL: Access Duration
- Data Analysis Programming from SQL to SPL: Stock-out
- Interactive Data Analysis from Excel to SPL: Basic Marketing Analysis
- Interactive Data Analysis from Excel to SPL: Advanced Marketing Analysis
- Interactive Data Analysis from Excel to SPL: Consecutively Rising Stock Analysis
Desktop
- The very tool to liberate an Excelman from working overtime - SPL
- The very tool to liberate an Excelman from working overtime - ReportLite
Practice
- How to quickly merge multiple Excel files
- SPL Desktop Practice: How to Quickly Split an Excel into Multiple Excels
- Batch summary of multiple Excel spreadsheet data – done in 1 minute
- How to merge Excel tables horizontally
- How to automatically extract eligible rows in Excel
- Excel Advanced Group and Summary Method
- Set operations of data between Excel columns (intersection, union, difference)
- Set operations of Excel inter row data (intersection, union, difference)
- SPL XLL Practice: Almighty Text Splitting in Excel
- How to do Excel table association – You are out if you know only VLOOKUP
- SPL XLL Practice: Excel Interval Association
- ReportLite Practice: Generating reports with the same format using different data multiple times
- ReportLite Practice: Multi layered cross reports with complex formats
- ReportLite Practice: zoned cross report involving multi-table association
- ReportLite practice: cross report involving self-defined grouping interval
