Copyright All rights reserved by sophia.Jones

AFFECTO Nordics Survey Results – Business Analytics and Information Management – key drivers of lasting success

AFFECTO Nordics Survey Results – Business Analytics and Information Management – key drivers of lasting success. Affecto – One of Sweden’s premier Business Intelligence consulting company has published a new report which is the result of a survey done in spring of this year, highlighting the value of Business Analytics and Information Management for Nordic Organizations. A similar survey was published by Affecto back in 2010 but it was still headed “Business Intelligence”. At the time only one third of the companies had documented their BI strategy while 47 per cent were in the process of initiating strategy work. This time the survey’s main focus was on technologies used, the benefits generated for various functions and the degree of maturity
Continue reading...

KPI, Metrics

Want to measure the Business Analytics initiatives in your organization? Here are the 8 Key Metrics according to #SAS that matter

  Using analytics to get business insights has always have been crucial for making business decisions. The difference is that it’s a lot easier now with the help of advanced technology. According to SAS the mainstream business analytics market is expected to exceed to $50 billion by 2016 and yet we have medium sized to fairly large sized organizations who are struggling to extract value from the gigabytes, terabytes & petabytes of information that’s lying around on huge servers, excel files, local access based applications etc. The biggest challenge according to industry reports is “finding analytical talent” but according to my personal experience finding analytical talent is one small piece of the puzzle. I am not saying it’s not hard
Continue reading...


Information Systems – web definition “(Information System) data system: system consisting of the network of all communication channels used within an organization” Information Systems – Wikipedia definition: “Information system (IS) is the study of complementary networks of hardware and software (see information technology) that people and organizations use to collect, filter, process, create, and distribute data. The study bridges business and computer science using the theoretical foundations of information and computation to study various business models and related algorithmic processes within a computer science discipline Any specific Information System aims to support operations, management and decision making. In a broad sense, the term is used to refer not only to the information and communication technology (ICT) that an organization uses, but also to the way in which people interact with this technology in support of business processes.” The
Continue reading...


Data to Insight to Action – Technology cannot replace an understanding about your products, processes and customers

Let’s get real and let’s accept it – we all are dealing with an avalanche of information. Most of the organizations are spending more money on storing the large volumes of data than getting the respective return on investment in terms of data insights to make informed decisions. One of the fundamental beliefs and expectations from any Business Intelligence Tool is to make drill down easier and faster. That’s alright though as that’s what is expected from the tools – to make data insight easier. But if the data consumers aka business users don’t know how to select what is important to look at, what questions to ask and then how to interpret the results – trust me the Business
Continue reading...

10 Reasons Why you should be using SQL Server Reporting Services?

In my company we use SQL Server Reporting Services extensively for operational reporting and so far,  it has been well received As part of my job I also conduct trainings and workshops evangelizing the company’s BI offerings to our business users globally. There is one question that is being asked fairly often: I reply to this question by highlighting some key benefits and the business users are usually nodding happily looking content with my answer. Also because it’s a decision made by the team in Group IT, the users tend to assume that we (I and my team) are skilled enough to make the right choice for them :-). I did a training session last week and this question was asked again.
Continue reading...

Excel Dashboard

6 Key Factors that make Excel Unique and Provide users with Digital Data Power

Let’s get it straight, Excel is the most versatile and widely used software applications of all time, used by a broad spectrum of people – from novices keeping track of their groceries spend to multi-billion dollar international corporations forecasting profits and losses. For a large number of companies of various sizes across many industries, Excel is the heart of the organization. Excel can be used across all the stages of data life cycle (data generation, data collection, data organization, data visualization, data analysis, and data mining) and this versatility makes it the most preferred tool for Business Intelligence. Following are the 6 Key factors which make Excel Unique: DATA GENERATION – Excel is extremely easy and common as a data
Continue reading...

Five Pillars for Creating a Business Intelligence Culture in an Organization

Being a consultant has been both a very rewarding and a painful experience.  Rewarding because I saw my clients happy faces after successful projects and painful because I never really became part of any team, let alone becoming a part of the organization. The positive side of all this experience is that I saw both the best and the worst side of many organization cultures because whether we like it or not, every organization (big or small) on this planet has a culture – a mix of attitudes, habits, practices that expresses the organization’s collective self-image and expectations. A company’s culture is key in making an average team outstanding OR destroying a great team. In my personal experience (and probably
Continue reading...

Agile Data Modeling is collaborative and evolutionary

Agile data modelling is an extensive topic and there have been many books written on the subject. Scott Ambler, an expert on agile database techniques ( defines agile data modelling as follows: The key here are the terms COLLABORATIVE, INCREMENTAL and ITERATIVE. All of these terms have very specific meanings in agile development context which bring with them special benefits: Collaborative Data Modelling – The term “Collaborative” in this context emphasizes on modelling directly with stakeholders so they are actively involved. It effectively combines analysis and design and ‘cuts to the chase’ of producing a data model which means working software and documentations rather than ‘the establishing shot’ of recording data requirements (only documentation). Incremental Data Modelling – The term
Continue reading...

The challenges that the Next Generation Dashboards must overcome

This afternoon I attended a lecture at Copenhagen Business School on Data Visualization by Stephen Few, a leading authority on the subject. It was an inspiring lecture where Stephen emphasized that by following some basic principles and a basic understanding of a human brain’s capacity of absorbing the information we can create compelling data visualizations which connect directly with the users. When we talk about data visualization, it is inevitable to not talk about Dashboards as a way of presenting the data. Dashboards have long been used with the aim to provide a view of data from different perspectives. The need for timely and succinct business intelligence continues to grow as the executives need critical information to seize opportunities faster than
Continue reading...

Impactful BI and Analytics Strategy – following some best practices might be helpful as TECHNOLOGY IS ONLY PART OF THE STORY

I have been in the technology and BI industry for a good number of years and one thing I can say with certainty that in today’s volatile times, experience or intuition cannot be relied on making effective decisions. There is an increasing demand to respond faster more than ever with insights into ongoing organizational events (both internal and external) based on facts. A growing number of organizations are gradually moving towards more PERVASIVE BUSINESS INTELLIGENCE with the support of defined processes (as much as they can be defined) and a range of BI and analytics technology. Spending on business analytics software is constantly increasing (worldwide spending in 2012 was nearly $33 billion. Source: IDC) and TECHNOLOGY IS ONLY PART OF THE STORY.
Continue reading...