Tips, techniques, and insights for the MicroStrategy platform
AllScient founder Ryan Forsythe shares his perspective as a MicroStrategy power user on how organizations can get the most out of the platform. With over 20 years of hands-on experience and recognition as a 6-time MicroStrategy Community Grandmaster, Ryan has seen firsthand what separates successful MicroStrategy implementations from those that underperform. The key differentiator isn’t…
Ryan Forsythe, founder and Chief Analytics Officer of AllScient, sat down to answer five questions about his experience with MicroStrategy, the evolving analytics landscape, and what’s next for data-driven organizations. About Ryan Ryan started AllScient in 2001 and has spent over two decades helping enterprises build information strategies and analytics platforms. He is a 6-time…
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…
