What we Do
Opifex Solutions is a Power BI and Analysis Services consulting firm with deep expertise in architecture, design, and performance optimization. We help companies of all sizes, in most industries with a variety of needs. The only commonality is that these companies want trusted experts who've done the work and advise on experience.
ARCHITECTURE & DESIGN
Be confident that your up-front design decisions will set you up for success.
Are you stuck on a particular issue? Or is performance just generally slow? We can identify the root cause quickly and get you back to focusing on more important things.
Your business is too important for costly mistakes or re-work. From start to finish, one of our experts will handle your implementation.
TRAINING / COACHING
Whether it’s a week of on-site team training or a day of 1-on-1 immersion, let us help you build value in the workforce you’ve invested in.
SSAS HEALTH CHECK
The SSAS Health Check is a doctor’s visit for your Analysis Services database. During the Health Check, we will evaluate your entire Analysis Services environment, from the hardware, to the OS, to the database itself. We collect and analyze key metrics to determine what is healthy and what needs help, and provide a complete report including actionable recommendations to help you get the most out of your environment.
- 35-point Inspection
- Installation & Configuration
- Windows Event Logs
- 24hr Resource Utilization Analysis
- Security & Administration
- Backup & Disaster Recovery
- Prioritized Action Plan
- 100-point Inspection
- Everything in the STANDARD
- 24hr Query Workload Performance Analysis
- 24hr Processing Workload Performance Analysis
- Long Running MDX Queries Analysis
- Best Practices Design Review (Modeling, MDX, DAX)