RaqForum 25 No.
1,314 View  • 
     ...

6 Personnel Usage and Data Analysis

 

The path for non-professionals to learn SPL

Understanding

Actually, Python is far beyond you
What programming language should none professionals learn?

How do beginners learn SQL quickly?
A laymen’s roadmap for data analysis and processing technology

The very tool to liberate an Excelman from working overtime - SPL
The very tool to liberate an Excelman from working overtime - ReportLite

Analytic Techniques for Business - Excel to esProc Desktop

What to use for data analysis programming, SQL, Python, or esProc SPL?

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 Sheets 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

esProc Desktop and Excel Processing

esProc Desktop and Excel processing (2021)
Excel & Desktop Data Processing Q&A
SPL CookBook

Desktop Practice: Subject on merging Excel files
Desktop Practice: Subject on Splitting Excel File
Series on Solving Excel Puzzles Using SPL: Data Filtering Issues
Series on Solving Excel Puzzles Using SPL: Association & Comparison

 
 •  1,314 View  •