Wednesday, February 24, 2010
Monday, February 22, 2010
IPL's Now $4.1Billion Enterprise
The swagger of IPL commissioner Lalit Modi at the venues where he is a regular is in keeping with the staggering opulence of the annual T20
cricket tournament he created. By wrapping his tournament in a multi-billion dollar money-spinning cocoon, Mr Modi has been able fend off all the controversies, twists and turns thrown at IPL every season since its inception in 2008.
A new study carried out by a UK-based brand valuation consultancy, exclusively for ET, affirms the IPL’s cash-cow prowess, so much so that it threatens to eclipse the English Premier League, the copybook used by Mr Modi to launch the event. As an enterprise, IPL’s overall brand value has more than doubled to $ 4.1 billion, or Rs 18,998 crore, in 2010 from a year ago, says Brand Finance. The only such comprehensive analysis of the IPL puts the combined brand value of all franchises at $333 million, or Rs 1,542 crore.
IPL’s sweeping popularity in a cricket-crazy nation has unlocked unprecedented value for its owner, BCCI, and the eight team franchises. With two more teams in from 2011, Brand IPL is set for another big commercial leap. The Brand Finance study has treated IPL as a single commercial entity, aggregating the income that BCCI and the franchises will generate, and their expenditure. All cross-charged income and expenditures have been ignored to arrive at the total worth, which it terms as the IPL Branded System (see graphic for methodology).
“IPL can be seen as a precursor to emerging global brands out of developing nations and will definitely enjoy a first-mover advantage,” says Brand Finance India MD Unni Krishnan. Mr Modi is understandably elated at the success of his brainchild. “This is just the beginning and there’s huge value to be unlocked still.”
According to the study, Chennai Super Kings (CSK) has emerged as this year’s most valuable team with a brand value of $ 48.4 million, or Rs 224 crore, replacing Kolkata Knight Riders (KKR) at $ 46 million, or Rs 213 crore.
Rajasthan Royals at $ 45.2 million, or Rs 209 crore, is third in the pecking order. Much of CSK’s rise on the brand graph is being attributed to MS Dhoni, who has led by example. "With IPL’s ratings and royalties on the rise, it doesn’t come as a surprise to me," says N Srinivasan, MD of India Cements, the owner of CSK.
The astronomical leap in brand value by IPL ingests its emerging revenue potential too. “Other global benchmarks such as the EPL may be valued at $12 billion, but IPL has a better potential in value creation as there are no limits in audience and sponsors,” says Mr Krishnan.
Still, there are some gathering clouds. Sustaining the brand commercially will be a challenge, notes Brand Finance. Mr Modi is unperturbed. “I see the value of IPL doubling each year for the next few years.” Though franchises may not be in dire need for funds, he says sooner or later they’ll look to list on the stock market. “I know that some are already toying with the idea.”
S
cricket tournament he created. By wrapping his tournament in a multi-billion dollar money-spinning cocoon, Mr Modi has been able fend off all the controversies, twists and turns thrown at IPL every season since its inception in 2008.
A new study carried out by a UK-based brand valuation consultancy, exclusively for ET, affirms the IPL’s cash-cow prowess, so much so that it threatens to eclipse the English Premier League, the copybook used by Mr Modi to launch the event. As an enterprise, IPL’s overall brand value has more than doubled to $ 4.1 billion, or Rs 18,998 crore, in 2010 from a year ago, says Brand Finance. The only such comprehensive analysis of the IPL puts the combined brand value of all franchises at $333 million, or Rs 1,542 crore.
IPL’s sweeping popularity in a cricket-crazy nation has unlocked unprecedented value for its owner, BCCI, and the eight team franchises. With two more teams in from 2011, Brand IPL is set for another big commercial leap. The Brand Finance study has treated IPL as a single commercial entity, aggregating the income that BCCI and the franchises will generate, and their expenditure. All cross-charged income and expenditures have been ignored to arrive at the total worth, which it terms as the IPL Branded System (see graphic for methodology).
“IPL can be seen as a precursor to emerging global brands out of developing nations and will definitely enjoy a first-mover advantage,” says Brand Finance India MD Unni Krishnan. Mr Modi is understandably elated at the success of his brainchild. “This is just the beginning and there’s huge value to be unlocked still.”
According to the study, Chennai Super Kings (CSK) has emerged as this year’s most valuable team with a brand value of $ 48.4 million, or Rs 224 crore, replacing Kolkata Knight Riders (KKR) at $ 46 million, or Rs 213 crore.
Rajasthan Royals at $ 45.2 million, or Rs 209 crore, is third in the pecking order. Much of CSK’s rise on the brand graph is being attributed to MS Dhoni, who has led by example. "With IPL’s ratings and royalties on the rise, it doesn’t come as a surprise to me," says N Srinivasan, MD of India Cements, the owner of CSK.
The astronomical leap in brand value by IPL ingests its emerging revenue potential too. “Other global benchmarks such as the EPL may be valued at $12 billion, but IPL has a better potential in value creation as there are no limits in audience and sponsors,” says Mr Krishnan.
Still, there are some gathering clouds. Sustaining the brand commercially will be a challenge, notes Brand Finance. Mr Modi is unperturbed. “I see the value of IPL doubling each year for the next few years.” Though franchises may not be in dire need for funds, he says sooner or later they’ll look to list on the stock market. “I know that some are already toying with the idea.”
S
Kathryn Bigelow's 'The Hurt Locker' wins best film, director at BAFTAs
Kathryn Bigelow's Iraq war movie "The Hurt Locker" swept the board at the BAFTA awards, winning the best film and director awards and leaving ex-husband James Cameron almost empty-handed.
Bigelow picked up six gongs out of eight she was nominated for on Sunday, and was the first woman to win the best director award for her movie portraying elite soldiers tasked with defusing bombs in the heat of combat.
Collecting her best film award from US actor Dustin Hoffman, she said the prize was "beyond our wildest imagination."
"This is so unbelievable, we're just so deeply honoured and humbled," said the director at the London awards ceremony.
"The Hurt Locker" also picked up prizes for original screenplay, cinematography, editing and sound at the ceremony, which attracted stars including Uma Thurman, Kate Winslet and Colin Firth.
The war film beat Cameron's 3D, computer-animated blockbuster "Avatar" to the major prizes -- both had been nominated for best film and best director.
"Avatar", the world's biggest-ever grossing movie, picked up just two awards from eight nods for special visual effects and production design.
The BAFTAs come two weeks before the Oscars where "Avatar" and "The Hurt Locker" are also locked in a dead heat, leading the field with nine nominations each.
A glittering ceremony, the BAFTAs is one of the most hotly anticipated events in the film calendar and thousands of fans packed out London's Covent Garden to catch a glimpse of the A-listers as they arrived.
Colin Firth won the best actor award for his role in "A Single Man", in which he plays a gay academic fighting with grief.
"What (director) Tom Ford doesn't know is I have the email in my outbox telling him I could not possibly do this," he said.
"I was about to send this when a man came to repair my fridge... I don't know what's best for me so I would like to thank the fridge guy."
Carey Mulligan scooped the prize for best actress for her part in "An Education", a coming-of-age drama set in 1960s London.
The Oscar-nominated 24-year-old has blossomed into one of Hollywood's most sough-after actresses despite being rejected by three drama schools.
Best film not in the English language went to French prison drama "A Prophet", directed by Jacques Audiard.
Best supporting actor went to Austrian Christoph Waltz, for his part as a Nazi in Quentin Tarantino's film "Inglourious Basterds", and best supporting actress went to Mo'Nique for her role in "Precious."
It was also revealed at Sunday's ceremony that Prince William will become the British Academy of Film and Television Arts' (BAFTA's) fifth president, following in his grandfather's footsteps.
The 27-year-old, who succeeds legendary director Richard Attenborough, was greeted with huge cheers from crowds lining the red carpet on his arrival.
British actress Vanessa Redgrave received a standing ovation when she received the Academy fellowship, the highest accolade from the British Academy for contribution to film.
She follows industry heavyweights who have previously received the honour, including Charlie Chaplin, Alfred Hitchcok and Steven Spielberg.
Bigelow picked up six gongs out of eight she was nominated for on Sunday, and was the first woman to win the best director award for her movie portraying elite soldiers tasked with defusing bombs in the heat of combat.
Collecting her best film award from US actor Dustin Hoffman, she said the prize was "beyond our wildest imagination."
"This is so unbelievable, we're just so deeply honoured and humbled," said the director at the London awards ceremony.
"The Hurt Locker" also picked up prizes for original screenplay, cinematography, editing and sound at the ceremony, which attracted stars including Uma Thurman, Kate Winslet and Colin Firth.
The war film beat Cameron's 3D, computer-animated blockbuster "Avatar" to the major prizes -- both had been nominated for best film and best director.
"Avatar", the world's biggest-ever grossing movie, picked up just two awards from eight nods for special visual effects and production design.
The BAFTAs come two weeks before the Oscars where "Avatar" and "The Hurt Locker" are also locked in a dead heat, leading the field with nine nominations each.
A glittering ceremony, the BAFTAs is one of the most hotly anticipated events in the film calendar and thousands of fans packed out London's Covent Garden to catch a glimpse of the A-listers as they arrived.
Colin Firth won the best actor award for his role in "A Single Man", in which he plays a gay academic fighting with grief.
"What (director) Tom Ford doesn't know is I have the email in my outbox telling him I could not possibly do this," he said.
"I was about to send this when a man came to repair my fridge... I don't know what's best for me so I would like to thank the fridge guy."
Carey Mulligan scooped the prize for best actress for her part in "An Education", a coming-of-age drama set in 1960s London.
The Oscar-nominated 24-year-old has blossomed into one of Hollywood's most sough-after actresses despite being rejected by three drama schools.
Best film not in the English language went to French prison drama "A Prophet", directed by Jacques Audiard.
Best supporting actor went to Austrian Christoph Waltz, for his part as a Nazi in Quentin Tarantino's film "Inglourious Basterds", and best supporting actress went to Mo'Nique for her role in "Precious."
It was also revealed at Sunday's ceremony that Prince William will become the British Academy of Film and Television Arts' (BAFTA's) fifth president, following in his grandfather's footsteps.
The 27-year-old, who succeeds legendary director Richard Attenborough, was greeted with huge cheers from crowds lining the red carpet on his arrival.
British actress Vanessa Redgrave received a standing ovation when she received the Academy fellowship, the highest accolade from the British Academy for contribution to film.
She follows industry heavyweights who have previously received the honour, including Charlie Chaplin, Alfred Hitchcok and Steven Spielberg.
Monday, February 15, 2010
To Convert Rows to Columns
The post explains how to convert rows into columns
The data will be in the below format after doing the operations in SQ
CASE, NAME, COL_NAME
BCO, BCO Name, X_ATTRIB_01
BCO, Comment, X_ATTRIB_02
CRN_APPS_CODE_MAPPING, APPS Code, X_ATTRIB_03
CRN_APPS_CODE_MAPPING Endorsement, X_ATTRIB_04
AKCOV, Billing Code, X_ATTRIB_06
AKCOV, Class Of Car, X_ATTRIB_05
AKCOV, Comments, X_ATTRIB_02
The Target data must be in the below format
BCNAME,X_ATTRIB_01,X_ATTRIB_02,X_ATTRIB_03,X_ATTRIB_04,X_ATTRIB_05
BCO, BCO Name, Comment
CRN_APPS_CODE_MAPPING, , ,APPS Code, Endorsement
AKCOV, ,Comments, , , Class Of Car, Billing Code
To Achieve this we follow the below flow and conditions
SQ--->EXP--->AGG--->TGT
Create the output ports based on the columns you require. In my condition I require 32 columns so I created 32 output ports
The condition is based on the Name and SRCHSPEC columns so based on these I calculated in the expression transformation
O1 (OUT) ---> IIF (NOT ISNULL (SRCHSPEC) AND COL_NAME = 'X_ATTRIB_01', NAME)
The same is calculated to all the 32 columns
All the 32 output ports and the SRCHSPEC are passed to the aggregator transformation
group by SRCHSPEC
Create 32 output ports and the following calculations is used in all output ports base on the Input column
Out1 (OUT)----> MAX(DECODE(NOT ISNULL(O1),1,O1))
Pass SRCHSPEC and all 32 output ports to the target
The data will be in the below format after doing the operations in SQ
CASE, NAME, COL_NAME
BCO, BCO Name, X_ATTRIB_01
BCO, Comment, X_ATTRIB_02
CRN_APPS_CODE_MAPPING, APPS Code, X_ATTRIB_03
CRN_APPS_CODE_MAPPING Endorsement, X_ATTRIB_04
AKCOV, Billing Code, X_ATTRIB_06
AKCOV, Class Of Car, X_ATTRIB_05
AKCOV, Comments, X_ATTRIB_02
The Target data must be in the below format
BCNAME,X_ATTRIB_01,X_ATTRIB_02,X_ATTRIB_03,X_ATTRIB_04,X_ATTRIB_05
BCO, BCO Name, Comment
CRN_APPS_CODE_MAPPING, , ,APPS Code, Endorsement
AKCOV, ,Comments, , , Class Of Car, Billing Code
To Achieve this we follow the below flow and conditions
SQ--->EXP--->AGG--->TGT
Create the output ports based on the columns you require. In my condition I require 32 columns so I created 32 output ports
The condition is based on the Name and SRCHSPEC columns so based on these I calculated in the expression transformation
O1 (OUT) ---> IIF (NOT ISNULL (SRCHSPEC) AND COL_NAME = 'X_ATTRIB_01', NAME)
The same is calculated to all the 32 columns
All the 32 output ports and the SRCHSPEC are passed to the aggregator transformation
group by SRCHSPEC
Create 32 output ports and the following calculations is used in all output ports base on the Input column
Out1 (OUT)----> MAX(DECODE(NOT ISNULL(O1),1,O1))
Pass SRCHSPEC and all 32 output ports to the target
To Concatenate Two rows column data into a single column
Hi,
Affetected_areas, Coverage_comments, Claim_Id, Unit_Id
Garage,Test,1234-1,4567-1-2
Garage,Testing,1234-1,4567-1-2
Mall,To_Test,1234-1,4567-1-2
Garage,Test,1234-1,4567-1-2
Garage,Testing,1234-1,4567-1-2
Mall,To_Test,1234-1,4567-1-2
The target data must be
Affetected_areas, Coverage_comments, Claim_id, Unit_id
Garage,Test;Testing, 1234-1, 4567-1-2
Mall, To_Test, 1234-1, 4567-1-2
Garage,Test;Testing, 1234-1, 4567-1-2
Mall, To_Test, 1234-1, 4567-1-2
To acheive this follow the below flow
SQ---->SRT----->EXP---->AGG--->TGT
In the expression transformation create four variable ports for Affected_areas, Claim_Id, Unit_Id and output port for the calculations. The Order is important
CC_Calc (VAR) -----> IIF(Affected_areas=AA_Prev AND Claim_Id = CI_Prev AND Unit_Id = UI_Prev,CC_Calc||';'||Coverage_comments,Coverage_comments )
AA_Prev (VAR) ------> Affected_areas
CI_Prev (VAR) --------> Claim_Id
UI_Prev (VAR) --------> Unit_Id
OUT_CALC (OUT) ------->CC_Calc
Pass these values to the Aggregator Transformation group by the three ports and connect to the target the desired output is achieved.
To Create file dynamically based on the ID
When you want to create a file dynamically with file name and the data with same details must go the same file we can do this by simple methods.
For Ex:
Claim_Id, Claimant_Name, Claim_Unit
15243,Rags,12354
15243,Rags,12356
15243,Rags,12375
15245,Mars,12355
15246,Pras,12388
In order to generate a file based on the Claim_id we have to do the following steps.
In target create the Filename port.
If the source is the relational source the flow is
SQ—->EXP—->TC——>TGT
In the SQ Query give the order by clause
If the source is the flat file follow
SQ—->SRT—->EXP—->TC—->TGT
Steps followed in the Expression transformation are
Create 2 variable and output ports in the expression transformation.
file_status_v (VAR)—-> IIF ((expgrp_prev = 0) OR (Claim_Id= expgrp_prev),’N',’Y' )
expgrp_prev (VAR)—-> Claim_Id
file_status (Out) —–> file_status_v
filename_o (Out) —–> CONCAT(CONCAT(‘Timmy’,Claim_Id),’.txt’)
After the expression transformation use this below condition in Transaction Control Transformation
IIF
(
file_status = ‘N’,TC_CONTINUE_TRANSACTION,TC_COMMIT_BEFORE
)
Then connect the output ports to the target and the filename_o to the filename port in the target.
The file will be as follows.
Timmy15243.txt
Timmy15245.txt
Timmy15246.txt
Introduction
I hope every one is doing fine with good health 
I wanted to share my knowledge on Data warehousing and Informatica with all the guys around…I also want to post some interesting topics..I hope that I would succeed in the endorsement.
So gimme the suggestions if something is wrong in my future posts…
Cheers,
Timmy
Subscribe to:
Posts (Atom)
