• about reply
Solidsoft Reply Logo
Menu
  • What we do
  • Pharmaceutical Sector
  • The Solid Blog
  • Newsroom
  • Contact Us
  • about Reply
Solidsoft Reply Logo

Search

Focus On

Blog

Introducing Self-Service BI with Power BI

Author: Nicholas Revell

FOCUS ON: Blog,

Before we start, let me quickly summarise some of the problems with traditional BI that we are trying to resolve. Traditional BI is characterised by the need to process and store data in intermediary data stores (e.g. date warehouses or data marts) in a form that is suitable for analysis (e.g. on-line analytical processing (OLAP) cubes). The consolidation and transformation of all this source data into a single repository involves detailed requirements analysis, specialised skills, additional infrastructure costs, and long development lead times, which often results in a system that is slow, inflexible, expensive, and too IT-centric.

Self-service BI aims to empower business users to be able to access relevant corporate data, perform their own analysis, and collaborate with others, whenever they need results, and without being dependent on IT or requiring specialised skills.

To introduce some balance, I should also mention that I am a fan of data warehouses and that they serve a number of valuable functions that are not available in self-service BI. They can add metadata to conform different data sources in the absence of a master data management system; they protect the source operational databases from direct access that could compromise security or performance, they provide higher levels of confidence in the completeness and accuracy of the data; and they can provide better performance when analysing large volumes of data. 

The fact is that self-service BI and traditional BI serve different needs and have their strengths and weaknesses. You can achieve the best of both worlds by recognising when one is more appropriate than the other and by building a self-service BI strategy on top of your existing BI platform rather than trying to create parallel systems. 

In this series I will explore the purpose and benefits of self-service BI in more detail with the following topics:

  • Realising the benefits of self-service BI
  • Reaching and empowering all your business users
  • Keeping control of your data
  • Creating an agile BI process

RELATED CONTENTS

11.07.2017

Blog

Comparison between DPA & GDPR

Before we start comparing, it’s worth highlighting that this is a bit of an “oranges & apples” thing because, technically speaking, the UK DPA (Data Protection Act) 1998 was enacted to bring British law into line with the 1995 EU DPD (Data Protection Directive, aka 95/46/EC) which is the one that is, now, being repealed and superseded by the GDPR (General Data Protection Regulation, aka 2016/679) that was adopted in 2016.

28.07.2017

Blog

MODERN VS TRADITIONAL TECHNOLOGY INTEGRATION

Every business today is looking for ways to unlock the value of their data, connect disparate systems, increase efficiency, optimise the use of current IT while at the same time keeping the organisation secure. Why? Because competitive advantage, positive customer experience and a bulging bottom line are all dependent on it.

20.07.2017

Blog

5 REAL-WORLD DRIVERS OF MODERN INTEGRATION

Technology is becoming increasingly flexible, mobile and connected- the evidence is probably either in your pocket or your hand.
Smart devices are now built around a huge number of modern applications, many of which are tied directly into business functions – in essence the line between consumer and business has blurred.

 
 
 
 
Reply ©​​ 2023​ - Company Information -
 PrivacyCookie Settings​
  • About Reply​​​
  • Inves​tors​​
  • Newsroom
  • Follow Reply on
  • ​
  • ​
​
  • ​About Solidsoft Reply
  • Privacy & Cookies Policy
  • Information (Client)
  • Information (Supplier)​