Google Track

Showing posts with label Business intelligence. Show all posts
Showing posts with label Business intelligence. Show all posts

Saturday, December 28, 2013

Which Of The Five Types Of Data Science Does Your Startup Need?

by TOMASZ TUNGUZ

facepalm-1024x442.png
 Credit: O'Reilly

Startups, you are doing data science wrong. That’s the title of a post penned by Ryan Weald in GigaOm this week. Weald echoes DJ Patil’s idea: “product-focused data science is different than the current business intelligence style of data science.”
Weald points to a different model of data scientist, an engineer, not a statistician, who can perform queries and based upon some insights, improve the product with a few code changes and a push to git.
I like Weald’s post but disagree on one point. I don’t think there is one type of data scientist, but five.
  1. Quantitative, exploratory data scientists tend to have PhDs and use theory to understand behavior. I count Hal Varian, Chief Economist at Google, and Redpoint’s own Jamie Davidson, among them. Varian’s team researches the advertiser dynamics within the ads auction and compares those dynamics to theoretical auction models like the Vickery auction. By combining theory and exploratory research, these data scientists improve products.
  2. Operational data scientists often work in the finance, sales or operations teams at Google. In the AdSense ops team where I started, we had a star data analyst who each week would discuss our team’s performance: our email response times, the satisfaction scores of our publishers, and changes in publisher behavior by segment. His work provided a feedback loop to improve the team’s tactics and efficiency. Only infrequently were these insights used to influence product.
  3. Product data scientists tend to belong to product management or engineering. This is the group of data scientists Weald writes about. PMs and engineers sift through logs and analysis tools to understand the way users interact a product and leverage that knowledge to refine the product. At Google, the ads quality team analyzed user clicks data to improve ad targeting.
  4. Marketing data scientists segment the user base, evaluate the performance of advertising campaigns, match product features to customer segments, and design content marketing campaigns. The marketing data scientist creates awareness and leads for the sales team, helping generate revenue.
  5. Research data scientists create insights as a product. Nate Silver is arguably the most famous of them. Silver’s work doesn’t influence a product; the analysis is the product itself. Sometimes the data science leads to a thought leadership whitepaper, or a blog post, or a financial report. It’s rarer for startups to employ research scientists because the output isn’t tied to revenue. But larger companies like Google do, think tanks do, financial institutions do.
These five types of data scientists span almost every department of knowledge work. Sometime in the past thirty years, data science became inextricable from the day-to-day operation of these teams. Product, marketing, eng, sales all use data to make decisions. These teams use data to identify, understand and implement feedback loops and to reinforce the behavior a company desires.
To talk about data scientists might be too myopic. Your startup may need a research data scientist or one with a PhD. Or it may need an engineer with an understanding of basic statistics who can work up and down the Rails stack. Or another type all together.
Like any role, when hiring or recruiting a data scientist it’s important to identify what the key problems facing the business and the relevant skills the right candidate will need to solve those challenges.

Wednesday, May 29, 2013

THE NORWEGIAN BI BAROMETER


The Norwegian BI barometer: A survey of BI maturity in the Norwegian market
Are Norwegian companies best in class when it comes to using information for management purposes? Or are they laggards compared to other countries, relying on gut feeling and experience? For the first time there will be a large scale survey of BI maturity in Norway. The survey will give an indication of the level of maturity in using BI in Norwegian companies. The survey will point out which areas are more mature, and which require more attention, both in total and divided by industry and company size. Is your company more or less mature than the industry average? Which areas are most and least mature? Get useful pointers for your own BI efforts at this presentation.

TICKETS


GOBI2013 will be held in Oslo Spektrum June 10th 2013. When registering you get full access to the sessions, restaurants, cafes, expo and entertainment for the whole conference.
The web shop for conference tickets will ease the job of managing your tickets. Through the web shop you can buy any number of tickets and assign them to co-workers and/or friends who shall attend the conference. Each individual attendee is responsible for updating his or her contact information. When required information has been registered, the ticket will be sent directly to the attendee. Tickets are sent as a PDF containing a QR code on e-mail. Attendees must bring the QR code for registration at the conference site on June 10th. A conference pass will be created and handed out at registration.
Price: 5.900 NOK (EarlyBird, until 15.04.2013)
Price: 6.900 NOK (LateBird after 15.04.2013)
Tickets for GOBI2013 are administrated by Macsimum Event AS
Post Conference Seminar with Cindi Howson and Wayne Eckerson
Want to get the most out of the gurus while they’re in Oslo? Would you like to have a deep-dive seminar with BOTH keynote speakers? Attend the GOBI post-conference seminar on June 11th.
Price: 3.900 NOK (Without valid GOBI pass)
Price: 2.900 NOK (With valid GOBI pass from June 10th)

Questions about tickets? Contact: webshop.gobi@eventsystems.no

Sunday, September 30, 2012

IT Training By Experts

At Technitrain we believe the best way to learn a technology is to learn from an expert. Our courses are taught by top consultants who have a wealth of hands-on experience to share and who can answer all of your difficult questions. You'll acquire the practical skills you need to do your job as well as learn the tips and tricks that only the experts know.

Here is the link to more information.

Our trainers are the best in their field: Microsoft MVPs, authors and well-known bloggers such as Chris Webb, Gavin Payne, Christian Bolton.

Thursday, August 23, 2012

A BI Architectures Approach to Modeling and Evolving with Analytic Databases


Major shifts converging in today's BI environment bring the opportunity to discover new answers to old questions about what BI architectures are about and how they are designed.



August 21, 2012

By John O'Brien, Principal, Radiant Advisors



Whether you have been a BI architect managing a production data warehouse for many years or are embarking on building a new data warehouse, the new analytic technologies coming out today have never been so powerful and complex to understand. In fact, with so many analytic technologies available on the market, they are somewhat overwhelming as we struggle to make sense of what to do with them and which ones to use with our existing environments.



This is good for BI architects because it brings us back to BI architecture fundamentals, key data management principles, pattern recognition, and agile processes, along with BI capabilities that challenge classic BI architecture best practices to design what clearly makes sense to meet the demands of business today.



There are major shifts converging in today's BI environment, and these changes bring with them the opportunity to discover new answers to old questions about what a BI architecture is all about and how an architecture is designed. As I explore these questions in this article, I will focus on three main themes: BI architectures are strategic platforms that evolve to their full potential; good architectures are based on recognizing data management principles (patterns and so-called best practices are discovered later); and BI architecture design is purposeful at every stage of development and technology decisions follow this purpose.



Architecture Maturity and Information Capabilities



We have all seen the research that says BI architectures evolve into robust information platforms and value over time. BI teams have focused on increasing value through maturing their data warehouses from operational reporting to data marts to data warehouses and finally to enterprise data warehouses. This evolutionary approach is typical when balancing pressing tactical needs for information delivery with strategic development, and is found in many companies where business demands for information drive towards a data warehouse platform.



The classic data warehouse is the last thing to be built, if ever, because the emphasis remains on quicker delivery first and information consistency later. Unfortunately, this leads to data warehouses that reflect current information needs and doesn't foster the evolution of a mature analytics culture.



Instead, an architecture based on BI capabilities focuses on nurturing the analytic culture of the business community by first educating user communities about the BI capabilities available and then on business subject data that is delivered via BI capabilities. This approach centers the data warehouse architecture on BI capabilities such as information delivery; reporting and parameterized reporting; dimensional analytics for goals achievement; and advanced analytics for gaining insights, to name a few. These discussions recognize that the same consistent data has many usage patterns, behaviors, and roles in the decision process. A BI architecture that is designed in this way ensures that data models and chosen analytic technologies are best suited to their intended purpose.



However, this BI-capabilities approach is contrary to some BI architects' belief that there should be an all-in-one data warehouse platform in the enterprise.



Sunday, June 3, 2012

Accelerating Insights from Your Data

In this special webcast, Tim O'Reilly, founder and CEO of O'Reilly Media, talks with Microsoft Technical Fellow Dave Campbell about the new and exciting tools emerging for data analysis and insight.

With machine processing power and data storage growing cheaper by the day, the value is now moving to the data itself. New options allow for the refinement and combination of data like never before. Where data was once "locked" behind applications, these file sources are now opening up, allowing people and organizations to find new ways to analyze existing as well as new data for faster and deeper insights. From creating a language translation tool with raw machine data, to real-time traffic redirection, the potential benefits that can be realized from the evolution in insights is unlimited.

Tune into the webcast and see how Microsoft is working with the data community to develop new tools that will unlock insights from previously unimaginable sources at breakneck speeds.

For more information, please visit www.microsoft.com/bigdata.


Tuesday, May 15, 2012

Effective big data strategies detailed


Businesses beginning a big data analytics program with advanced business intelligence software may be concerned about affordability. However, according to PC Advisor, there are easy steps that companies can take to make sure that their deployments are successful. These steps include deep research into the business case at hand and prudent financial planning.



Careful planning


"[Big data is] new technology solving a business problem that we often haven't proved. That's important for CIOs to keep in mind," financial consultant Jeff Muscarella told PC Advisor. "The business is going to be coming to them with all sorts of half-baked ideas for what they can do with Big Data. They have to ask: Will it really drive revenue? How and for how long?"
According to the source, carefully vetting business ideas for new big data projects is vitally important for CIOs trying to save money on their big data projects. Gathering details on each projected usage of data means less chance of failure. The source urged companies to target their big data projects, to fire "bullets" rather than "cannons" at specific problems that can provide value for the company. Muscarella told the source that companies can start small to prove that a process works before moving to the company-wide infrastructure level.



Myths vs. reality


As a widely hyped technology often presented as the future of business intelligence, advanced analytics and big data have received a large amount of press. To avoid business confusion, several publications have offered clarifications of what the technology can and cannot offer companies. The Economic Times stated that any business with a product to sell and any company hoping to help make up the potential market for big data. As companies begin to harness the power of big data, competitors could take of the systems in a bid to compete on an even level.
The source sought to puncture myths about what big data can and cannot do. It stated that big data's endgame is unknown, and that many of the features of big data analytics are still spoken of in the future tense. The source found that companies can already use the technology to provide "amazing" customer insights from vast quantities of "irrelevant stuff." While it is important to be careful when integrating big data, making the effort could become a required part of business strategy

Industry News from: http://www.panorama.com/industry-news/article-view.html?name=Effective-big-data-strategies-detailed-774397&utm_source=dlvr.it&utm_medium=facebook

Thursday, May 10, 2012

Predictive Analytics and Data Mining




Derive useful insights to make evidence-based decisions

Today's organizations accumulate huge volumes of data from a variety of sources on a daily basis. However, turning increasingly large amounts of data into useful insights and finding how to better utilize those insights in decision making remains a challenge for most.

To get answers to complex questions and gain an edge in today's marketplace requires powerful, multipurpose predictive analytic solutions so you can learn from, utilize and improve on knowledge gained from vast stores of data. BIandIT Ltd provides a wide range of software for exploring and analyzing data to help uncover unknown patterns, opportunities and insights that can drive proactive, evidence-based decision making within your organization.

Text mining applies the same analysis techniques to text-based documents. The knowledge gleaned from data and text mining can be used to fuel strategic decision making.



Components of Predictive Analytics and Data Mining

Exploratory Data Analysis – Get dynamic visualization, advanced statistical techniques and core data mining capabilities to quickly identify relationships and opportunities.

Model Development and Deployment – Streamline the data mining process to create highly accurate descriptive and predictive analytic models based on large volumes of data.

Analytics Acceleration – Generate faster results and improve data governance with in-database analytics.

Scoring Acceleration – Maximize the performance and accuracy of your analytic models.




Tuesday, April 24, 2012

Time Series and its application in Predictive Analytics

Time Series Foundation (TSF) is an open, .NET platform for exploring and prototyping new algorithms in time series analysis and forecasting. TSF is based on state space model methodology that includes all types of exponential smoothing, some autoregressive algorithms, and innovative algorithms for event detection and calendar event impact prediction. TSF relies on Excel charting and presentation APIs by implementing an Excel interop layer. Numerical and graphical results of time series analysis and forecasting can be put in programmatically generated workbooks with the help of this layer. TSF also offers an Excel add-in that exposes a large subset of the platform's functionality through the Excel ribbon UI.


Time Series Foundation is discussed by a research developer in Microsoft.

Monday, April 23, 2012

Benefits from BI in Hospitality

Every Business today take advantages of Business Intelligence solutions, so Hospitality is one of them.
I tried to spot the most important benefits that hospitality industry has from Business Intelligence:


- Profile Guest & Business Segments by any combination of criteria. Break out, analyze and compare these segments on demographics, stay patterns, etc.

- Identify your best guests & uncover those with the highest potential for additional nights or services

- Perform Drill Down & Side-By-Side Analysis or filter on any variable with no limitations to “dimensions” and no cubes to rebuild

- Compare alternative target segments or multiple characteristics side-by-side, even if they overlap

- Track Performance across time: Guests, Return Rate, Length of Stay, Frequency, Recency, Room Rate, upgrades, etc. Track by: Division, Product Line, Guest

Segment, Booking Source/Channel, Geography/Property…any variable on file

- Identify Challenges & Opportunities to quickly spot where your business or guest segments are excelling or under-performing. Monitor changes and easily drill down to see the factors driving this performance

- Access Executive Dashboards tailored for at-a-glance & measuring performance, right at the fingertips of managers across your organization

BI in Hospitality

Success in the increasingly competitive hospitality industry is dependent on prompt knowledge of what’s going on in the operation. The need to know customer information: who they are, what they buy, and how likely they are to come back again, can be elusive. Additionally, the time-sensitive nature of business metrics makes it difficult to answer certain questions such as: What are daily sales results on an individual property? What are the average expenses per day? What are labor costs? What is the daily cash position? The sheer volume and time-sensitive nature of events in the hospitality industry can be overwhelming. Hence information becomes the essential ingredient to success in the hospitality industry.


A Business Intelligence solution enables analysis by exception and gives decision-makers of multi-location organizations a robust way to decipher and analyze information gathered at each level. BI tool helps aggregate, process and visualize data from disparate sources, multiple applications, allows decision-makers to quickly identify and address trends or potential problems. BI enables decision-makers to move from speculative decision-making to fact-based decision-making based on knowledge.

Business intelligence is simply the people, processes, and technologies that turn data into information. It is the key strategic opportunity for successful hospitality corporations.

Information Challenges in Hospitality Industry:

- Enormous amounts of data in multiple, disparate systems makes single enterprise wide view becomes challenge

- Revenue management is dynamic and constantly changing resulting complexity in pricing optimization and forecasting strategies

- Tremendous challenge in meeting customers’ expectations and preferences due to constant pressure of capturing, analyzing, and creating the right message / offer using the right medium and at the right time

Why BI:

- Essential tool for protecting market share

- Identifying unproductive rate strategies

- Uncovering new revenue opportunities

- Beat the competition

- Dynamic MIS & ad-hoc Reports to understand your current market position

- Illuminate future performance trends

- Compile detailed picture of competitive environment (who is traveling & from where)

Thursday, April 5, 2012

Big Data, the amazing thing

Big data is a term applied to data sets whose size is beyond the ability of commonly used software tools to capture, manage, and process the data within a tolerable elapsed time. Big data sizes are a constantly moving target currently ranging from a few dozen terabytes to many petabytes of data in a single data set.

In a 2001 research report[15] and related conference presentations, then META Group (now Gartner) analyst, Doug Laney, defined data growth challenges (and opportunities) as being three-dimensional, i.e. increasing volume (amount of data), velocity (speed of data in/out), and variety (range of data types, sources). Gartner continues to use this model for describing big data.






Whether through blogs, twitter, or technical articles, you’ve probably heard about Big Data, and a recognition that organizations need to look beyond the traditional databases to achieve the most cost effective storage and processing of extremely large data sets, unstructured data, and/or data that comes in too fast. As the prevalence and importance of such data increases, many organizations are looking at how to leverage technologies such as those in the Apache Hadoop ecosystem. Recognizing one size doesn’t fit all, we began detailing our approach to Big Data at the PASS Summit last October. Microsoft’s goal for Big Data is to provide insights to all users from structured or unstructured data of any size. While very scalable, accommodating, and powerful, most Big Data solutions based on Hadoop require highly trained staff to deploy and manage. In addition, the benefits are limited to few highly technical users who are as comfortable programming their requirements as they are using advanced statistical techniques to extract value. For those of us who have been around the BI industry for a few years, this may sound similar to the early 90s where the benefits of our field were limited to a few within the corporation through the Executive Information Systems.

Analysis on Hadoop for Everyone

Microsoft entered the Business Intelligence industry to enable orders of magnitude more users to make better decisions from applications they use every day. This was the motivation behind being the first DBMS vendor to include an OLAP engine with the release of SQL Server 7.0 OLAP Services that enabled Excel users to ask business questions at the speed of thought. It remained the motivation behind PowerPivot in SQL Server 2008 R2, a self-service BI offering that allowed end users to build their own solutions without dependence on IT, as well as provided IT insights on how data was being consumed within the organization. And, with the release of Power View in SQL Server 2012, that goal will bring the power of rich interactive exploration directly in the hands of every user within an organization.
Enabling end users to merge data stored in a Hadoop deployment with data from other systems or with their own personal data is a natural next step. In fact, we also introduced Hive ODBC driver, currently in Community Technology Preview, at the PASS Summit in October. This driver allows connectivity to Apache Hive, which in turn facilitates querying and managing large datasets residing in distributed storage by exposing them as a data warehouse.

Sunday, March 25, 2012

Avarage Calculations in MDX

Average is very important function to calculate Key Figures of your business. Here are some samples of Average-Avg(), starting with basic to more advanced calculations like deep diving into Moving Averages :

WITH
  MEMBER [Measures].AvgProductSales AS
    Avg
    (
      NonEmpty
      (
        [Product].[Product].[Product].MEMBERS
       ,[Measures].[Sales Amount]
      )
     ,[Measures].[Sales Amount]
    )
SELECT
  [Measures].AvgProductSales ON 0
 ,[Date].[Date].[Date].MEMBERS ON 1
FROM [Adventure Works];

WITH
  MEMBER [Measures].AvgProductSales AS
    Avg
    (
      [Product].[Product].[Product].MEMBERS
     ,[Measures].[Sales Amount]
    )
SELECT
  [Measures].AvgProductSales ON 0
 ,[Date].[Date].[Date].MEMBERS ON 1
FROM [Adventure Works];

WITH MEMBER [Measures].AvgProductSales
  AS Avg(EXISTING [Product].[Product].[Product].MEMBERS, [Measures].[Sales Amount])
SELECT {[Product].[Product Categories].[Subcategory].[Bike Racks]
       ,[Product].[Product Categories].[Subcategory].[Bike Stands]
       } ON 0
, [Date].[Date].[Date].MEMBERS ON 1
FROM [Adventure Works]
WHERE [Measures].AvgProductSales
;

// Avg over Filter
WITH
  MEMBER [Measures].AvgGrowingProducts AS
    Avg
    (
      Filter
      (
        [Product].[Product].[Product].MEMBERS
       ,[Measures].[Sales Amount] > ([Measures].[Sales Amount],ParallelPeriod([Date].[Calendar].[Month]))
      )
     ,[Measures].[Sales Amount]
    )
SELECT
  [Measures].AvgGrowingProducts ON 0
 ,Descendants
  (
    [Date].[Calendar].[Calendar Year].&[2003]
   ,[Date].[Calendar].[Date]
  ) ON 1
FROM [Adventure Works];

// Correct Avg over Filter
WITH
  MEMBER [Measures].Growth AS
    IIF
    (
      [Measures].[Sales Amount] > ([Measures].[Sales Amount] ,ParallelPeriod([Date].[Calendar].[Month]))
     ,[Measures].[Sales Amount]
     ,NULL
    )
   ,FORMAT_STRING = 'Currency'
  MEMBER [Measures].AvgGrowingProducts AS
    Avg
    (
      [Product].[Product].[Product].MEMBERS
     ,[Measures].Growth
    )
SELECT
  [Measures].AvgGrowingProducts ON 0
 ,Descendants
  (
    [Date].[Calendar].[Calendar Year].&[2003]
   ,[Date].[Calendar].[Date]
  ) ON 1
FROM [Adventure Works];

//

WITH MEMBER [Measures].AvgByDayOfWeek AS
  Avg(
   Exists(
    NULL:[Date].[Date].CurrentMember,
    [Date].[Day of Week].CurrentMember)
  , [Measures].[Sales Amount])
SELECT [Measures].AvgByDayOfWeek ON 0
--, [Product].[Product].[Product].MEMBERS ON 1
, [Date].[Date].[Date].MEMBERS ON 1
FROM [Adventure Works]
;
WITH MEMBER [Measures].AvgByDayOfWeek AS
  Avg(
   Nest(
    NULL:[Date].[Date].CurrentMember,
    [Date].[Day of Week].CurrentMember)
  , [Measures].[Sales Amount])
SELECT [Measures].AvgByDayOfWeek ON 0
--, [Product].[Product].[Product].MEMBERS ON 1
, [Date].[Date].[Date].MEMBERS ON 1
FROM [Adventure Works]
;

// ===========
// Running sum
// ===========

// Typical approach for running sum
WITH
  MEMBER [Measures].RunSales AS
    Sum
    (
      NULL : [Date].[Date].CurrentMember
     ,[Measures].[Sales Amount]
    )
SELECT
  [Measures].RunSales ON 0
 ,[Date].[Date].[Date].MEMBERS ON 1
FROM [Adventure Works];

// Trying to optimize...
WITH
  MEMBER [Measures].RunSales AS
    Sum
    (
      Union
      (
        NULL : [Date].[Calendar].Parent.PrevMember
       ,
        [Date].[Calendar].FirstSibling : [Date].[Calendar].CurrentMember
      )
     ,[Measures].[Sales Amount]
    )
SELECT
  [Measures].RunSales ON 0
 ,[Date].[Date].[Date].MEMBERS ON 1
FROM [Adventure Works];

// Forcing back into block mode
WITH
  MEMBER [Measures].RunSales AS
      Sum
      (
        NULL : [Date].[Calendar].Parent.PrevMember
       ,[Measures].[Sales Amount]
      )
    +
      Sum
      (
        [Date].[Calendar].FirstSibling : [Date].[Calendar].CurrentMember
       ,[Measures].[Sales Amount]
      )
SELECT
  [Measures].RunSales ON 0
 ,[Date].[Date].[Date].MEMBERS ON 1
FROM [Adventure Works];

// Better caching...
WITH
  MEMBER [Measures].RunMonthSales AS
      Sum
      (
        NULL : [Date].[Calendar].CurrentMember
       ,[Measures].[Sales Amount]
      )
  MEMBER [Measures].RunSales AS
      ([Measures].RunMonthSales, [Date].[Calendar].Parent.PrevMember)
    +
      Sum
      (
        [Date].[Calendar].FirstSibling : [Date].[Calendar].CurrentMember
       ,[Measures].[Sales Amount]
      )
SELECT
  [Measures].RunSales ON 0
 ,[Date].[Date].[Date].MEMBERS ON 1
FROM [Adventure Works];










Saturday, March 24, 2012

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.

Tuesday, March 20, 2012

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.

Monday, March 12, 2012

Another approach to Time Intelligence


Best Parctices for Time Scale solution
This is an original method that I use when I build SSAS Cubes and it is time to share it with you

Time Intelligence is a common issue for every OLAP structure because Time as dimension apperars in every OLAP project, in every Cube you build, despite business model or type. To handle Time Intelligence good in calculations, aggregations and optimization, you need to use Timescale as well. With Timescale I mean: MonthToDate (MTD), YearToDate (YTD), LastYear(LY) etc..., all these very important to everyday use of Business Intelligence solutions.

Now I will take to technical steps to implement this genius way of handling with Timescale and Time calculations.
First you create a Table for Timescale in the source (in you DB, DWH or Data Mart), with 3-4 columns and 3-4 records for example. Here is a sample for that:


Based on this table you create a Dimension Timescale where Columns are Attributes and Records are Members of that Dimension.
After that, I go to DSV of our Cube, on every Fact Table that needs Timescale (usually all need Timescale) I add Named Calculation FK_Timescale with value 'PE', as in the image above:





















I create a relationship FK_Timescale of the Fact Table to Timescale table in Data Source View (DSV) and after I build the Cube I do the same in Dimension Usage, where I create Regular relation between Fact Table and Timescale Dimension as shown above:




















I create 2 name sets for MTD and YTD right after Calculate; and the MDX for that is shown above :

CALCULATE;
-- Period to date
-- Month to Date
[Timescale].[Timescale].[MTD] = Sum(MTD([Time Dim].[Hierarchy].CurrentMember),[Timescale].[Timescale].[PE]);
-- Year to Date
[Timescale].[Timescale].[YTD] = Sum(YTD([Time Dim].[Hierarchy].CurrentMember),[Timescale].[Timescale].[PE]);

Now, you have ready implemmented Timescale in the Cube for all your Measures, so you do not need to calculate Timescales for each Measure. Instead of having MTD(YTD) Revenue, you just use Revenue measure and change Timescale from PE to MTD(YTD). Test this with Excel, through Data Connection to OLAP Cube and enjoy possibilities. This way is proven more dynamic, flexible and optimized for query performance.

I would be very pleased and that will help me keeping posting good things about BI, if you find time from your busy schedule to suggest, critic or to share with love this blog or this particular content.

Regards,
Besim

Friday, March 9, 2012

BIandIT.com, a website that is going to have all important things in BI

My web site is Under Construction and is going to have the hotest topics and trends in Business Intelligence. You can find elegant solutions in Business Intelligence, special calculated members, Time Intelligence, Customer Intelligence, Competition Intelligence, Market Intelligence, Spatial Intelligence and Predictive Analytics. The site will have also Office Templates for Business Start-ups, for Market Analysis, ROI, First Year Costs etc... www.biandit.com is comming SOON :)