Basic Calculations in MDX

// Connect to 2005 Adventure Works

// Gross margin using 1-a/b
WITH
  MEMBER [Gross Margin] AS
       1
    -
        [Measures].[Internet Total Product Cost]
      /
        [Measures].[Internet Sales Amount]
    , FORMAT_STRING = 'Percent'
  MEMBER [Max Gross Margin] AS
    Max
    (
      (
        [Customer].[Customer Geography].[Customer]
       ,[Product].[Product Categories].[Subcategory]
       ,[Date].[Calendar].[Calendar Year]
      )
     ,[Measures].[Gross Margin]
    )
SELECT
  [Measures].[Max Gross Margin] ON 0
FROM [Adventure Works];

// Gross margin using (b-a)/b
WITH
  MEMBER [Gross Margin] AS
      (
        [Measures].[Internet Sales Amount]
      -
        [Measures].[Internet Total Product Cost]
      )
    /
      [Measures].[Internet Sales Amount]
    , FORMAT_STRING = 'Percent'
  MEMBER [Max Gross Margin] AS
    Max
    (
      (
        [Customer].[Customer Geography].[Customer]
       ,[Product].[Product Categories].[Subcategory]
       ,[Date].[Calendar].[Calendar Year]
      )
     ,[Measures].[Gross Margin]
    )
SELECT
  [Measures].[Max Gross Margin] ON 0
FROM [Adventure Works];

Industry News

Cloud computing changing future of BI

2012-03-23
With the onset of cloud technology, many different sectors of the business and personal world are rapidly changing. From the focus on personal computers to mobile tablets, and from legacy systems to IaaS and SaaS systems, it goes without saying that in the coming years consumers can expect a technological revolution.

All these emerging systems are impacting business intelligence as well. A recent IDC study predicts that the market for big data technology and business intelligence software will grow from $3.2 billion in 2010 to $16.9 billion in 2015.

Furthermore, Gartner predicts that companies will nearly be forced into using these new technologies or risk losing a competitive edge. According to a new Gartner study, 85 percent of Fortune 500 corporations will fail to effectively use big data to get an advantage.

According to Jeff Kaplan, managing director of THINKstrategies, businesses must adopt some semblance of business intelligence and analytics software in order to maintain an edge that may have previously been established with legacy systems.

"Without all these cloud-based resources and tools, most organizations would be unable to cope with today's explosive growth of data," he said.

The Future of Mobiles

How the future of mobile phones will be shaped by human and business request. What is going to happen
with smartphones and what with dumbphones? These are the questions that this embed presentation from Business Insider aims to answer. ENJOY!

Analytics in Sports

I am fan of football and my favorite team is FC Barcelona. Combining sports, specially football with Analytics is just amazing.

Mike Walsh, futurist

In our VK2012 was invited Mike Walsh and he had a keynote about technology future. He instisted that the future of the World is DATA and claimed the most important profession of the future will be Data Scientist. Let the future begin and let say I am a Data Scientist.

Universe in your table

Microsoft Surface brings the Universe in your desk

BI for Customers

BI for everyone, does it sound familiar!

It is a fact that Business Intelligence was dedicated to big companies, enterprises because they have that amount of data to be considered interesting for analytics and BI. Now, Gartner started the idea of Bi for mid-size and small businesses, so they need attention too based on BI surveys. But, have you ever thought for a BI solution in Customer Level, or more detailed do you think you can handle a personal BI solution.
ELA will give you the answer.

ELA solution for Customer Intelligence

What ELA is actually?

Elegant Analytics represents the name of a general BI solution in or group of methodologies in Analytics that adapts to every Business profile. In this case, ELA will provide solution for personal finance and planning of your budget. The name of the product is PFI (Personnal Finance Intelligence). Inspired by the TV Show “Luksusfellen” here in Norway, this BI end-user tool may be a solution for all these who fail to maintain well their own economy and for those who want to perform their economy as well. The purpose of this project is to create a Customer Analytical Cube that would process data for each bank costumer using his/her history for its own benefit and then answer you most important queries that users do against their own data.

This solution will include also benchmarking against an Imaginary subject (Ola Nordman) that can be Min, Max or Avg of the customer’s measures in a certain region, for a period of time, similar age group, sex and income levels.

For having more controle and planning your own economy, will be an extra parameter as Target, so users (bank customers) will put their targets for costs and income a month, quarter or a year ahead and always will be warned when they are about to achieve the amount they targeted.

If you want to read more then follow the link where you can download the full project.