1. Open or create an Excel file using `excel_file(open)` or `excel_file(create-empty)` to obtain a `sessionId`.
2. Perform data manipulation tasks using tools like `excel_range(set-values)` and `excel_range_format(set-number-format)`.
3. Convert data ranges to Excel Tables using `excel_table(create)` for structured references and enhanced functionality.
4. If needed, create Power Query queries using `excel_powerquery(create)` to import and transform data.
5. Refresh Power Query queries using `excel_powerquery(refresh, refreshTimeoutSeconds=120)` to load data into the workbook.
6. Add tables to the Data Model using `excel_table(add-to-datamodel)` for DAX measure creation.
7. Create DAX measures using `excel_datamodel(create-measure)` to perform calculations on the data.
8. Save and close the Excel file using `excel_file(close, save=true)` to persist the changes.
SynapticSkills