- Robust, performant solutions targeting core business processes
- New capabilities and logic to enhance existing BI solutions
- Integration and enrichment of source data into robust analytical data models
At its core, Frontline Analytics is comprised of enthusiastic Microsoft BI developers striving to become better at their craft. Consultants at Frontline simply love to develop, test and enhance BI solutions to maximize their own capabilities as well as the resources and features of the MS data platform. Our team maintains advanced development knowledge and experience with DAX, Power Query (M), T-SQL, PowerShell and more.
- DAX measures and queries for Power BI and Analysis Services Tabular data models
- Power Query (M) expression queries to access, transform, cleanse, integrate, and enhance data to drive analytics
- T-SQL queries, procedures, and objects to support data warehouses and data retrieval and integration processes
- Custom PowerShell scripts to process (refresh) Analysis Services Tabular and Power BI models and for custom administration solutions