Excel Import ISAM Error Fix
The "Could not find installable ISAM" error hits when importing modern Excel (.xlsx) files via SQL Server Import Wizard.
National Weather Service Data Collector
Built a fun weekend project with my son to collect hourly National Weather Service observations into SQL Server while he learned SQL. The PowerShell script pulls current conditions from NWS stations, stores data cleanly, and includes full DB scripts plus a Power BI dashboard for visualization. Open-source on GitHub for anyone to clone, run, or extend.
Ways to get data out of Essbase
DataExport scripts, and Grid API offer fast but limited access without dynamic calculations. Modern connectors and tools like Power BI's native Essbase integration or BluePrint Conduit provide simpler, more governed paths for low-latency data delivery into BI workflows.