CMBI can help you unlock the full potential of SQL Server's services for business intelligence, reporting and analytics capabilities. Choose on-premise, cloud or hybrid cloud.
CMBI for SQL Server BI and Analytics
CMBI have extensive experience in SQL Server BI projects of all shapes and sizes. We build solutions from the ground up using inexpensive and flexible licensing models and best practice design patterns. We also support and enhance existing SQL Server reporting solutions.
Contact us today to see how we can help you harness the full potential of SQL Server BI in your organisation.
SQL Server Components
We provide a brief description of some of the major components of the SQL Server stack below.
SQL Server Database EngineBuild your data warehouse for large or small deployments. Table partitioning, compression, and the MERGE statement are key features that assist with typical data warehouse challenges. |
|
Integration Services (SSIS)Extract data from your operational systems, spreadsheets, and external sources and load them into the data warehouse. Enhance data quality with fuzzy logic and data cleansing tools. Schedule and manage simple or complex ETL loads. |
|
Reporting Services (SSRS)Create standard parameterised reports or more complex dashboards with navigation, drilldowns, KPIs and indicators. Schedule reports for delivery by email or create data driven subscriptions. |
|
Analysis Services Cubes (SSAS)Create a data model that can hold billions or records whilst being fast and easy to query for end users and analysts. Analysis Services databases can be queried using Excel Pivot Tables, Performance Point, Reporting Services, and many more third parties BI tools including Strategy Companion Analyzer and Tableau. |
|
Analysis Services Data Mining (SSAS)Create predictive models for grouping customers, market basket analysis, trend prediction, and text mining. One of the most undervalued tools in the SQL Server BI stack is the data mining. It is easier to use than you might think and can answers questions that would be very difficult to address with traditional query based analysis. |
|
Power BIPower BI is a reporting tool that allows end users to create and automate complex reports and analysis, which can then be published into the cloud. A full Mobile BI solution is also available on a subscription service. |
SharePoint Online Business Intelligence Components
You can create a powerful business intelligence solution with standalone SQL Server products. However, if you add SharePoint Online into the mix you have an array of choices for collaboration, self-service BI, publishing and interactive dashboards. More than ever before SQL Server and SharePoint are tightly integrated.
Excel ServicesUsing Excel you can create interactive dashboards with Analysis Services or PowerPivot. But how do you publish these insights so that everyone else in the organisation can benefit? Excel Services is the answer. You can chose to publish a whole workbook, individual worksheet, or even a single chart. End users can browse and interact with your dashboard using their web browser but with no requirement for a local Excel install. |
About CMBI
CMBI designs and develops business intelligence and analytics solutions for clients in Sydney and regional NSW. CMBI technology expertise includes Power BI, Power Pivot, Excel, SQL Server, Analysis Services, SharePoint BI and Tableau.