Business Intelligence Tools

There is so much effort involved in building a data analytics solution, so any tools that can help deliver faster and with a greater level of quality are worth sharing.  

 
 

POWER BI DESKTOP

Power BI is a cloud-based analytics service that enable anyone to integrate, visualise and analyse data with greater speed, efficiency and understanding.  It connects users to a broad range of data through easy-to-use dashboards, interactive reports and compelling visualisation that bring data to life.

DAX STUDIO

DAX Studio is a free tool for running DAX queries against Excel PowerPivot models or Analysis Services Tabular models. It includes an Object Browser, query editing and execution, formula and measure editing and syntax highlighting.

 
 

VISUAL STUDIO 2015

Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft.  Traditionally used for the development of applications.  Business intelligence developers can combine this with the SSDT add-in to create a comprehensive business intelligence development environment.

SQL SERVER MANAGEMENT STUDIO 2016

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server and Azure SQL Database.

 

 

VISUAL STUDIO 2015 - SSDT

SQL Server Data Tools is an add-in for Visual Studio that allows for declarative database development.  It also extend Visual Studio with templates that allow Microsoft business intelligence developers to create Integration Services (SSIS), Reporting Service (SSRS) and Analysis Serivce (SSAS) projects.

BISM NORMALISER 3

BIDS Helper is a Visual Studio add-in that enhances development functionality in SQL Server Data Tools (SSDT). It provides several features for a Tabular project that would not be available otherwise in the Visual Studio user interface.

 

VISUAL STUDIO 2015 - RTVS

R Tools for Visual Studio (RTVS) is a powerful add-in for Visual Studio.  It allows data scientist to develop and deploy R scripts taking advantage of all the other powerful features of visual studio.

BIDS HELPER 

BISM Normalizer manages Analysis Services tabular models, comparing different versions and merging differences in a safe way.