Opifex Solutions is a Power BI consulting firm and Microsoft Partner with deep expertise in enterprise-scale 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.

Delivering the visibility & insights companies need to run their business better, move faster, and beat out the competition via data-driven solutions using the Microsoft Data Platform.

data and power bi stuff

Primarily focused on designing and implementing Data Warehouse and Business Intelligence solutions based on the Microsoft BI stack.

Led database design and development of client accounting database (ODS/Reporting - hybrid) as part of a scalable service-oriented application project in the pharmecutical industry.Skills Required:- Database Development (SQL Server 2012)- Implemented A/R set-based matching algorithms (TSQL)

Augmented existing Microsoft DW/BI solution to incorporate (Oracle) data source after client acquired major competitor.Skills Required:- Dimensional Modeling and Database/ETL development (SQL2008R2, SSIS, TSQL)- Cube development and optimization (SSAS, MDX)- Report development (SSRS, TSQL, MDX)- Self-Service Report development and optimization (PowerPivot, DAX)- Scorecard/dashboard design and development (PerformancePoint)- Sharepoint BI Portal admin (SSRS, PowerPivot, PerformancePoint)