Run SQL Server queries from Cerewro using sqlcmd or Invoke-Sqlcmd, process the results with PowerShell and automatically generate a formatted Excel with charts and totals. Schedule the job for daily email delivery.
Run the daily sales SQL query on the "SQLPROD" server, generate an Excel with the results sorted by amount and send it to management@company.comImportExcel PowerShell module with Install-Module ImportExcel. Cerewro uses it automatically if available.