DBInsight's Blog

Archive for Business Intelligence

BI Corner – Analytics Wars, Excel\Power Pivot vs Tableau

This article from Rob Collie, What is Power Pivot’s #1 Competitor, was not only interesting because it highlighted where standard Excel falls down in analytics and how Tableau has exploited this for their own marketing. It also particularly interesting with respects to the two comparison charts showing the Time Investment Required vs Lifetime of Report […]

Continue Reading →

Posted in: Business Intelligence, Power BI

Leave a Comment (0) →

Use Power BI to Forecast Server Capacity

Microsoft recently announced the Power View forecasting feature which is available when running Power View in HTML 5 format through their Power BI for Office 365 cloud offering. For those that don’t know, the Power BI for Office 365 official description is … Power BI is a cloud-based service that works with Excel to provide a […]

Continue Reading →

Posted in: Business Intelligence, Capacity Planning, DBA, Power BI

Leave a Comment (0) →

Why are Business Intelligence Projects So Different?

Have you ever wondered why BI projects are so different to the traditional IT development projects? I found this article 8 Ways that Business Intelligence Projects are Different (here) by Analytics8 that succinctly outlines the differences and what to watch out for when taking on a BI project. In summary, some of the core differences […]

Continue Reading →

Posted in: Business Intelligence

Leave a Comment (0) →

Design and Build a Data Warehouse in 65% Less Time

Recently DBInsight completed a major BI/Data Warehouse project in just 79 days, utilizing a new Data Warehouse development tool called Dimodelo Architect. DBInsight built a data warehouse for Legal Aid Queensland with 28 Dimension and 20 Facts in just 79 days. This included gathering requirements, installing and configuring an SQL Server 2012/SharePoint 2010 environment, developing […]

Continue Reading →

Posted in: Business Intelligence, SQL Server Tools

Leave a Comment (0) →

BI Corner – Enterprise BI Project using Microsoft Tools

Jen Underwood from the SQL Server BI Blog, describes her journey of evaluating Microsoft BI tool offerings to support the requirements of an Enterprise BI Project. In the article Jen outlines the enterprise dashboard requirements that had to be supported and highlights (for her BI project) that the latest MS BI toolset (eg. Power BI […]

Continue Reading →

Posted in: Business Intelligence

Leave a Comment (0) →

Microsoft’s In Memory Strategy for SQL Server

It’s quite interesting that Microsoft’s SQL Server 2014 release has a number of In Memory performance optimisation features.  The clock speeds of CPUs have not significantly increased over the last few years  but memory has become relativity cheap and the 64 bit Windows platforms now provide substantial scope to run high memory footprints. Therefore it […]

Continue Reading →

Posted in: Business Intelligence, Performance, SQL Server 2014

Leave a Comment (0) →
Page 1 of 2 12