​Successfully delivering on an EDW solution involves three core components—leadership, experience, and expertise.

Solid Quality Mentors’ consultants and mentors bring strong solution leadership skills, industry-leading technology expertise, and vast experience on the SQL Server platform. With these abilities, we can work directly with your internal team by providing in-depth technology know-how for your solution architecture, implementation best practices, and rich real-world experience. We engage with our clients and partners in this capacity in three ways:

• Mentoring – We partner with you and provide guidance throughout a project or just during key aspects of a project, leveraging our experience and expertise to come alongside your team, guiding, assisting, and empowering. In the end, you have successful solution and the internal skills to manage and extend it going forward.
• Implementation – Our team can become an integral player in your EDW solution, owning either one or more of the technology layers or focusing on a strategic area of the solution. Our deliverable is to drive that area of the solution to success, providing the best practices and approach to meet your requirements.
• Solution Architecture – We have the leading EDW solution architects from around the world on the SQL Server platform and can lead your EDW project to success by designing the overall solution, working with your team through challenging requirements, how to approach the project, and how to implement all the moving parts.

EDW Solution Leadership Delivering on an EDW solution involves more than just having the technology expertise. It requires leadership and experience. If you have a team of skilled technologists but need leadership and architecture assistance for your overall EDW solution, or specific areas within your solution, we can help: Solution Architect – SolidQ has a select group of EDW solution architects who know how all the moving parts fit together and can go from Ground 0 to success. Our solution architects are recognized by Microsoft and our clients as unmatched when it comes to leading a solution. EDW and BI Modeling – The most important aspect of an EDW solution is designing the model to meet the business objectives and achieve needed performance. A poorly designed EDW will incur high costs and put success at risk. We have worked with hundreds of companies designing the data warehouse models and working with business and IT to ensure the right model is designed. ETL Architect – The integration layer of an EDW solution typically consumes 50%-70% of the effort because of data volumes, transformation logic, data associations, and so on. Our ETL-focused mentors know the best practices and pitfalls in designing efficient, manageable, and extensible ETL and how to coordinate a team and integrate with the other layers of a solution. BI Architect – The BI tier of a solution is the touch-point for business users. A misstep here can cause perception and trust issues with the business team. Our BI-tier architects know all the delivery mechanisms, how they integrate, and how to apply the right technologies to the user needs and requirements.​

EDW Technology Expertise & Experience

We literally have written the books when it comes to how to correctly apply Microsoft technologies to building EDW solutions. If you are putting together an EDW team but need deep-dive technology expertise in one area to ensure successful design and implementation of your project, we can help. Here are our competencies:

• Parallel Data Warehouse (PDW) Expertise – We have more expertise working with Microsoft’s new large-scale EDW solution, PDW, than any partner or firm outside Microsoft (PDW targets EDW solutions larger than 40TB).
• Fast Track Appliance Expertise – For large, scale-up EDW solutions in the 5-40TB range, Microsoft Fast Track appliance combines SQL Server Enterprise Edition with prescriptive configuration for optimal performance at a lower cost. We have worked with Fast Track since its inception and can provide the guidance, configuration, and implementation you need.
• SQL Server BI Technology Expertise – The foundation for your SQL Server-based EDW solution is the Microsoft SQL Server platform. We can bring world-class expertise on the core components:
• Analysis Services
• Integration Services
• Reporting Services
• Relational Engine
• Master Data Services
• SharePoint and Custom BI Expertise – Microsoft’s primary BI technologies are delivered through SharePoint. Our core competencies focus on the BI technologies of SharePoint and custom BI solution delivery.
• Self-Service BI
• PerformancePoint
• PowerPivot
• Excel Services