- Robust, performant, and secure Microsoft BI solutions
- New capabilities and advanced 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. Our team maintains advanced development skills and experience with DAX, Power Query (M), T-SQL, PowerShell and other technical tools to deliver the best solutions possible aligned to our clients needs.
Examples of our work:
- Power BI Administration solutions to help organizations manage and monitor their Power BI environment
- Row-level and/or column-level security implemented in Azure Synapse Analytics, Azure SQL Database, Analysis Services, or Power BI datasets
- Advanced DAX calculations and queries for Power BI and Analysis Services Tabular models to derive greater insights
- Power Query (M) expression queries to access, transform, cleanse, integrate, and enhance data to drive analytics
- T-SQL queries, procedures, and database objects to support data warehouses and data movement and integration processes
- Custom PowerShell scripts and Azure Automation Runbooks to process (refresh) Analysis Services Tabular and Power BI models and for custom administration solutions
- Advanced paginated reports targeting Power BI Premium capacity, Power BI Report Server, or SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS) packages to load to load and optionally transform or integrate source data.