Technical guides, tutorials, and development best practices
When building Python scripts that connect to databases, APIs, or other services, one of the first challenges you’ll face is how to securely handle credentials. Hardcoding passwords in your scripts is a security risk. Environment variables are better but still have limitations. The Python keyring library offers an elegant solution by leveraging your operating system’s…
Table-Valued Functions (TVFs) are a powerful but underutilized feature when working with MicroStrategy. They allow you to create highly tuned database queries that return result sets as tables, giving you fine-grained control over how data is retrieved and processed before it reaches the analytics layer. What Are Table-Valued Functions? A Table-Valued Function is a user-defined…
When building date hierarchies in MicroStrategy or any analytics platform, most developers include the standard forms: Year, Quarter, Month, and Day. But there are several additional date forms that can dramatically improve the reporting experience for your users. Beyond the Standard Date Hierarchy A well-designed date hierarchy goes beyond the basics. Consider adding these additional…
Business Intelligence development teams often struggle with project management. Traditional software development tools don’t always map cleanly to BI workflows, and spreadsheet-based tracking quickly becomes unmanageable. Jira, when configured thoughtfully, can be an excellent project management platform for BI development. Why Jira for BI? Jira’s flexibility makes it well-suited for BI projects because: Customizable workflows:…
