Wednesday, September 2, 2020

Consonants of the english language Essay Example | Topics and Well Written Essays - 2000 words

Consonants of the english language - Essay Example hangeable, increasingly steady, the law of their transformations is more conâ ­stant, or possibly better learned, and they oftentimes reâ ­main fixed in the composed language, after they have been lost or changed in sound. Henceforth, in explores into the historical backdrop of language they are of cardinal significance, and thus have only enâ ­gaged the consideration of etymologists, while, then again, their alleged lastingness, changelessness and uniqueness of character have driven them to be quite dismissed. Be that as it may, actually, consonants are a long way from being so very much separated. The facts demonstrate that their disparities are commonly more effectively valued by the ear, however less handily imitated by the tongue, than those between vowels. The vague verbalization of consonants in Danish, the conâ ­founding of the hard and delicate hints of g in certain lingos of Arabic, and of I and r in the Polynesian islands, the sepâ ­aration in Italian and Spanish of consonants are joined in English consonants. Subsequently the words regularly lose all likeness from which they started, and it is the concealment or change of consonants that masks them. (Ladefoged Peter, 1988 p. 123) Abyss and different expressions of comparable completion are prevalently articulated as dissyllables, and in bloom, be-torn, chest, and chrisom presented a composed vowel. The consonant m doesn't promptly join even with a precedâ ­ing fluid, and consequently the profane articulation ellutn, helium, for edge, steerage, and the word alarum for caution. It is maybe in this hesitance of m to be connected with a previous fluid, and the clarification of the concealment of the I medicine, quiet, and different expressions of comparable consummation are found. (Ladefoged Peter, 1988 p. 142) On the off chance that we talk about the arrangement of consonants we should call attention to that sounds are made by altering an airstream. There are numerous focuses at which that flood of air can be altered. Creating a consonant sound relies upon the situation of vocal folds, they are either opened or shut. On the off chance that

Saturday, August 22, 2020

The Advantages and Disadvantages of Spell Checkers

The Advantages and Disadvantages of Spell Checkers A spell checker is a PC application that distinguishes potential incorrect spellings in a book by alluding to the acknowledged spellings in a database. Likewise calledâ spell check, spell-checker, spellchecker andâ spelling checker. Most spell checkers work as a component of a bigger program, for example, a word processor or web index. Models and Observations Dont they show you how to spell these days?No, I answer. They instruct us to utilize spell-check.(Jodi Picoult, House Rules. Simon Schuster, 2010) Spell Checkers and the Brain Analysts have discovered that when we work with PCs, we regularly succumb to two subjective ailmentscomplacency and biasthat can undermine our presentation and lead to botches. Mechanization lack of concern happens when a PC quiets us into an incorrect feeling that all is well with the world. . . .The greater part of us have encountered lack of concern when at a PC. In utilizing email or word-preparing programming, we become less capable editors when we realize that a spell-checker is grinding away. (Nicholas Carr, All Can Be Lost: The Risk of Putting Our Knowledge in the Hands of Machines. The Atlantic, October 2013)[W]hen it comes to autocorrect, spellcheck, and their kind, the individuals who might censure advanced innovation for language rot are not so much off-base. Our minds appear to turn out to be less careful when we realize a linguistic security net will get us. A recent report found that understudies who got a high score on the verbal segment of either the SAT or the Gmat missed twice the same number of blunders editing a letter in Microsoft Word with the program’s squiggly hued lines featuring likely mix-ups as they did when the spell-check programming was killed. (Joe Pinsker, Punctuated Equilibrium. The Atlantic, July-August 2014) Microsofts Spellchecker Microsofts language specialists additionally track word demands, just as much of the time amended words, to survey whether those words ought to be added to the Speller word reference (Speller is the trademark name of Microsofts spell-checker). One late solicitation was artificial leather, which means a plastic false cowhide, which was included as a result of a campaigning exertion by the gathering People for the Ethical Treatment of Animals. On the off chance that youve got the most recent products from Microsoft, bonded leather shouldnt get a red squiggly.In different cases, genuine words are deliberately kept out of the projects word reference. A calender is a machine utilized for a specific assembling process. In any case, a great many people consider calender to be an incorrect spelling of schedule. The scribes at Microsoft have chosen to keep calender out of the projects word reference, figuring that by the day's end its progressively valuable to fix such huge numbers of incorre ctly spelled schedules, than it is to oblige the sensibilities of a little subset of the populace who happen to know about, and need to expound on, calenders. Comparative homophones (PC individuals call them basic confusables) incorporate words like rime, kame, quire, and leman. (David Wolman, Righting the Mother Tongue. Collins, 2008) The Limitations of Spellcheckers Indeed, you must be very acceptable at spelling and perusing so as to utilize a spellchecker adequately. Normally, in the event that you have incorrectly spelled a word the spellchecker will offer a rundown of choices. Except if your underlying endeavor is sensibly near the right spelling, you are probably not going to be offered reasonable other options, and, regardless of whether you will be, you must have the option to comprehend what is on offer. You and your understudies additionally must know about the confinements of spellcheckers. To begin with, you may accurately spell a word however just utilize an inappropriate one; for instance, After I had eaten my super I hit the sack. A spellchecker won't recognize that it ought to be dinner not super (did you detect the mix-up?). Second, the spellchecker doesn't perceive some entirely satisfactory words. (David Waugh and Wendy Jolliffe, English 5-11: A Guide for Teachers, second ed. Routledge, 2013) Spellcheckers for Writers With Learning Disabilities Spellcheckers have upset the lives of numerous dyslexic individuals and act the hero of ambushed editors. A few obstacles despite everything emerge, as when homophones are utilized mistakenly. The discourse choice spellchecker can beat these challenges by giving definitions and utilizing them in sentences for explanation and significance. Some think that its supportive if the spellchecker is killed when they are doing the main draft of a bit of composing, in any case the incessant interferences (as a result of their many spelling blunders) meddle with their train of thought.(Philomena Ott, Teaching Children with Dyslexia: A Practical Guide. Routledge, 2007) The Lighter Side of Spellcheckers This expression of remorse was imprinted in the Observers For the Record section on March 26, 2006: A section in the article underneath succumbed to the scourge of the electronic spellchecker. Old Mutual got Old Metal, Axa Framlingon became Ax Framlington and Alliance Pimco became Aliens Pico.The Rev. Ian Elston was thinking ahead to Christmas administrations when his PC spell-checker changed the presents of the Wise Men to golf, frankincense and myrrh. (Ken Smith, Day of the Dead. HeraldScotland, November 4, 2013)

Chronicle of a death foretold :: English Literature:

Narrative of a demise anticipated Narrative of a demise anticipated by Gabriel Garcia Marquez is a invented novel. It was initially written in Spanish yet was later meant English. The story started on the morning of Santiago Nasar’s murder. We are being recounted to the story in first individual view by an anonymous storyteller who has observer the occasions that happened. I think there is a dreamlike and dull tone; I get the inclination that the storyteller is researching the homicide since we are recounted to the story years after the fact from an omniscient perspective and all the characters’ musings are shared. There were two fundamental subjects that I took note. The primary subject was the ticket unpowerful the ladies are in the story. This is indicated when Marquez composes The siblings were raised to be men. The young ladies were raised to be married.† This portion shows the seriousness of the lives ladies lead in the saved Colombian culture of the town. A lady's value as a spouse was estimated by her magnificence related to her capacity to smoothly run all parts of a family. The possibility that the lady in a marriage is relied upon to endure is noteworthy no lady enters marriage hoping to be bliss except if she is lucky enough to love whichever man chooses to court her. In this Spanish culture, in contrast to Western culture, marriage did not depend on affection. There is likewise the significance of social conventions like respect. The twin siblings murder Santiago Nasar in light of the fact that he took their sister’s virginity away. Likewise, I became mindful the there in an accentuation on the dream that Santiago had, with the trees and the climate on the day he was killed. Some reviewed that it came down and some said that it was radiant. One strategy utilized in the story as a theme as enchantment authenticity. This is the consolidation of phenomenal or legendary into reasonable fiction. I seen that Marquez continues rehashing the homicide before it happened, this assisted with building tension. From the second section I comprehended that the storyteller infers that Santiago is blameless for the wrongdoing he passes on for. Be that as it may, in the event that he is blameless, at that point who took Angela Vicario’s virginity? The fierceness of the social shows encompassing ladies becomes clear in this section. Since she was not a virgin when she wedded, not exclusively is Angela relinquished by her significant other, yet she is beaten by her mother. The twofold guidelines of her way of life are featured by the truth that the storyteller, Santiago and some different companions are all at a whorehouse doing whatever they please. This tale helped me to remember the trouble of getting occasions.

Friday, August 21, 2020

Tom's of Maine Research Paper Example | Topics and Well Written Essays - 500 words

Tom's of Maine - Research Paper Example Tom’s circulation procedure is selling its items through wellbeing food stores and mass market outlets. Company’s items incorporate toothpastes, mouthwash, antiperspirant, dental floss, cleanser, cleanser, shaving cream, and a line of home grown wellbeing helps and concentrates. (Reference for Business). From an unassuming start of obtained capital of $5,000, organization has become a top indented organization procuring a large number of dollars every year. In 2006, the 84% controlling stake of the organization was offered to Colgate-Palmolive on conditions that it will hold the way of life of Tom’s Brand. Motivation behind the deal is to move in the production of another business from honey bees. In a general extension, clients search for help administrations running from right utilization of item and making the item practical. In particular, in view of research and written works evaluated, individuals need items that find real success and items that don't hurt the planet (Dougherty and Murthy 2009). Same creators said individuals need data; Buyers are intrigued on substance and naming; Buyers are intrigued on nature of the item as opposed to speed of conveyance and need devotion programs. Curiously, these aftereffects of overview could be identified with what bolster administrations purchasers from Toms, Inc need. Specifically, purchasers of Toms, Inc items need: sheltered and successful items. For example, individuals were frightened on the item security embarrassment of Tom’s toothpaste uncovered by Guciardi, 2011, in a post in the Natural Health Society. Ensuing remarks from clients of this item demonstrated unwaveringness to the brand, didn't accept the charges, and even inquired about to discover reality. Disposing of squanders is a developing issue in any network. To help in condition assurance, organization propelled Tom’s of Maine Recycle Program wherein void plastic containers of cleanser of any brand, and other plastic items including

Uses of Technology in Music Education Essay Example

Employments of Technology in Music Education Essay Innovation has had a tremendous impact in the melodic segment of my training, more so than some other subject. While the fundamental utilization of innovation in many subjects is PC innovation, I encountered numerous different sorts of innovation while finding out about music.One of the thoughts that I have for music instruction later on is for understudies to have the option to create unique foundation sounds for study hall readings and performances. There will be programming programs intended to be utilized explicitly by little youngsters. With these projects music will be created utilizing non-conventional methods, for example, attracting lines to form a song. Understudies will have the option to organize a bit of music utilizing a MIDI sequencer to change instruments and timbres. They will likewise have the option to try different things with various mixes of sounds utilizing a MIDI sequencer to adjust the components and attributes of the music. Song, concordance, mood, timbre, a nd structure, will be confined, changed, and components, for example, ritards, accelerandos, and crescendos will be made and controlled. To put it plainly, I would like to make it basic and simple for little youngsters to appreciate the great sentiment of making a piece out of music.Notation programming, for example, Finale, Sibelius and Garage Band empower understudies to make or mastermind voices as well as instruments. They give an approach to tune in to an organization as it is being made and to print neat scores and parts. Utilizing documentation programming can improve creations utilizing an assortment of instruments and ranges. Understudies can play back their sytheses utilizing an assortment of timbres. Notes can be entered in sync time or continuous. Utilizing documentation programming as opposed to making by hand permits the writer to hear the structure as it is being composed and to make snappy, clean changes to the piece. Different kinds of programming are going with pro gramming. This remembers Band-for a-Box and MakeMusic/Coda which will really go with the player as the person plays a performance. This innovation extraordinarily improved my capacity to perform solo presentations and to get ready for them.A basic type of innovation is the mallet, which is a type of a switch. Sledges can be found wherever from a development laborers belt to within a piano. The mallets that are found in a piano don't hit nails yet strings. The keys on the console are pivoted to little sledges with delicate finished heads that hit the strings. Figuring out how to play the piano is immensely significant in finding out about music and how to get music. It is far simpler to see interims on a piano console than it is on some other instrument. The educator has a simpler time utilizing a console to show an interim than they would playing it on an instrument on the grounds that the console permits the interim to be viewed as well as heard.A new bit of innovation that additio nally ends up being a viable in training music is an iPod. iPods help people in general by gathering DVD and CD assortments. They additionally help music educators when the instructor is giving a listening model. My own involvement in an iPod being utilized as an instructing device was in an ethnomusicology class in secondary school. My instructor had the option to rapidly and effectively progress among pieces and tunes that we as a class needed to examine and look at. When contrasting two pieces, it is least demanding to analyze them in the event that they are heard one after another, which an iPod permits to happen.If something very similar were to be endeavored utilizing two unique CDs, at that point it would be a lot harder to look at the two pieces due to an a lot bigger hole between the two listenings. The iPod likewise assists with discovering tunes all the more rapidly. It requires some investment to discover a melody on an iPod where you can look one after another in order by title, craftsman, arranger, collection, or by play list. This procedure takes considerably more time while looking through a CD assortment. Since my instructor had the option to utilize an iPod instead of CDs, the class was significantly more effective and insightful.One of the most accommodating devices a music educator can utilize when showing understudies how to play a piece accurately is a metronome. This device is utilized to keep a beat at a consistent rhythm and the more costly ones can likewise sub-partition the beat into any number of parts and even fill in as a tuner too. Metronomes began as non-electric, injury up boxes that had a pendulum with a load at the top. Rather than swinging to and fro with the weight arranged at the base of the pendulum, a metronomes pendulum would shake to and fro. The lower the weight was put, the quicker the rhythm. These metronomes were not as accommodating as current metronomes in view of their failure to sub-separate the beat. Youthful artists regularly think that its VERY difficult to keep a consistent beat so a metronome is the ideal apparatus for a music instructor to use to improve this skill.Technology clearly has made educating and finding out about music a lot simpler. I trust that later on, I will have the option to help advance more music innovation and further improve the simplicity with which music is instructed.

Thursday, July 2, 2020

Hult Prize Helps Inspire Business Ideas and Incubate Startup [Kiplinger] Hult Blog

Discover transformative new businesses taking shape during the Hult Prize competition for students across the globe. By Ruisha Qian for Kiplinger.com. For full article please click here. Ahmad Ashkar is the founder and CEO of the Hult Prize, a start-up accelerator for social good recognized in 2012 by President Bill Clinton and Time Magazine as one of the top five ideas changing the world. Each year, the Hult Prize takes on one of the planet’s toughest challenges, such as water, education and food crises. College students from around the world present new business ideas in regional rounds of competition hosted by Hult International Business School and its campuses in Boston, San Francisco, London, Dubai and Shanghai. Regional winners were announced in May and will attend the Hult Accelerator, an incubator for start-ups, in July. They will present their final pitches at the Clinton Global Initiative’s annual meeting in New York in September, and the winner will receive a $1 million prize donated by Swedish billionaire Bertil Hult. Kiplinger’s spoke with Ashkar about the competition. Here are excerpts from the conversation: A good example? M.Paani, founded by entrepreneur Akanksha Hazari, won the Hult Prize in 2011. What she did was capture a trend, which is that more people in India’s urban slums have mobile phones than access to a toilet or clean water. The question was how to use the desire of telecommunication companies to target this market and to create subsidies to fund clean water. m.Paani set up a rebate program. Every time the villagers use a specific mobile carrier, the carrier pays a commission to m.Paani, which uses part of the money to fund water development projects. It’s a win-win — the incentive for villagers to use one carrier is high, and the cost of rebates for the carrier is cheaper than doing marketing and advertising. Interconnectivity of the poor and the rich has gone seamless. There is a huge opportunity for Western retailers to access the poor. Two or three dollars a day makes billions. Continue reading the article  here. Make the most of what your career has to offer with a Masters in International Business from Hult. To learn more, take a look at our blog Taking me beyond business: Finishing my masters with the Hult Prize Finals, or give your employability a huge boost with an MBA in international business. Download a brochure or get in touch today to find out how Hult can help you to explore everything about the business world, the future, and yourself. Hult Rotation offers you a chance to study in a truly global way. Our rotation program allows you to study and be immersed in some of the finest cities in the world. 📠¸: @jasminmanzano . Hult Rotation offers you a chance to study in a truly global way. Our rotation program allows you to study and be immersed in some of the finest cities in the world. 📠¸: @jasminmanzano . Each year, Hult seeks to enroll a talented and ambitious incoming class from all over the world. We look for diverse students with a wide range of experiences, perspectives, and interests—students who will thrive in our unique educational atmosphere. Are you ready for a truly global experience? 📠¸: @iambrunadiniz . Each year, Hult seeks to enroll a talented and ambitious incoming class from all over the world. We look for diverse students with a wide range of experiences, perspectives, and interests—students who will thrive in our unique educational atmosphere. Are you ready for a truly global experience? 📠¸: @iambrunadiniz . We’re excited to start 2020 on a ranking high! Hult is proud to have been placed #28 in Poets Quants 2020 rankings for Best Undergraduate Business Schools in the US. Taking a huge leap of 32 places from our 2019 position, we’re also very happy to have secured top positions in key categories like: life-changing experience, practicality of the degree, and global immersion. . With five global campuses, a student body of over 130 nationalities, and a learn-by-doing approach—Hult offers a student experience like no other. . We’re excited to start 2020 on a ranking high! Hult is proud to have been placed #28 in Poets Quants 2020 rankings for Best Undergraduate Business Schools in the US. Taking a huge leap of 32 places from our 2019 position, we’re also very happy to have secured top positions in key categories like: life-changing experience, practicality of the degree, and global immersion. . With five global campuses, a student body of over 130 nationalities, and a learn-by-doing approach—Hult offers a student experience like no other. . â€Å"I’m from an engineering background and needed a whole new skill set for the industry I wanted to switch to. I learned a lot about myself and how I deal with being out of my comfort zone. I learned both soft and hard skills, from how to work in very diverse teams to key accounting metrics and strategy. I was surprised by how weak I was at certain tasks in English or how strong I actually was in other areas. Hult gave me opportunities to try new things and meet people from places I never thought I would have friends. . My internship experiences gave me the chance to broaden my view of different cultures and different companies. I had the opportunity to work and live with people whose values differed from people in my home country. I thought that this would be difficult, but it gave me the chance to reflect on my own values and assess if they were a result of my home country environment or if they were intrinsically mine. . Diederick ter Kulve (@diederick.terkulve) Netherlands Masters in International Business . â€Å"I’m from an engineering background and needed a whole new skill set for the industry I wanted to switch to. I learned a lot about myself and how I deal with being out of my comfort zone. I learned both soft and hard skills, from how to work in very diverse teams to key accounting metrics and strategy. I was surprised by how weak I was at certain tasks in English or how strong I actually was in other areas. Hult gave me opportunities to try new things and meet people from places I never thought I would have friends. . My internship experiences gave me the chance to broaden my view of different cultures and different companies. I had the opportunity to work and live with people whose values differed from people in my home country. I thought that this would be difficult, but it gave me the chance to reflect on my own values and assess if they were a result of my home country environment or if they were intrinsically mine. . Diederick ter Kulve (@diederick.terkulve) Netherlands Masters in International Business . Say a big hello to our Bachelor of Business Administration program cover star, Elisa Orus Plana âÅ" ¨ . â€Å"I’m excited for the future—especially that I cant predict whats going to happen. Maybe Ill end up in Mexico working for a trading company or maybe in Africa, developing my own business. Everything is possible, and the options are constantly changing. I love the idea that Im never going to be stuck doing the same job until the end of my life if I dont want it to be like this. . Hult really supports me and my ambitions and truly believes that we deserve to be considered as professionals as well as students. Here, I get to express not just my opinions but all elements of myself. From my creative side with the Fashion Society to my finance and business sides in Trading Club and the Management Consulting Club. We get a different type of learning here. Not just essential knowledge and theory, but practical skills and mindset. The school is always evolving. We’re encouraged to innovate and to always look for new ways of doing traditional things. We learn how to be more confident and become aware of how we can impact our environment. The school aims to help you become a better version of yourself and to stand out from the crowd.â€Å" . Elisa Orus Plana French Bachelor of Business Administration Class of 2021 Say a big hello to our Bachelor of Business Administration program cover star, Elisa Orus Plana âÅ" ¨ . â€Å"I’m excited for the future—especially that I cant predict whats going to happen. Maybe Ill end up in Mexico working for a trading company or maybe in Africa, developing my own business. Everything is possible, and the options are constantly changing. I love the idea that Im never going to be stuck doing the same job until the end of my life if I dont want it to be like this. . Hult really supports me and my ambitions and truly believes that we deserve to be considered as professionals as well as students. Here, I get to express not just my opinions but all elements of myself. From my creative side with the Fashion Society to my finance and business sides in Trading Club and the Management Consulting Club. We get a different type of learning here. Not just essential knowledge and theory, but practical skills and mindset. The school is always evolving. We’re encouraged to innovate and to always look for new ways of doing traditional things. We learn how to be more confident and become aware of how we can impact our environment. The school aims to help you become a better version of yourself and to stand out from the crowd.â€Å" . Elisa Orus Plana French Bachelor of Business Administration Class of 2021"> During the final days of 2019, you probably reflected on what you’ve accomplished this year—and even this decade—and what you’d like to achieve in 2020. Let us know in the comments below. During the final days of 2019, you probably reflected on what you’ve accomplished this year—and even this decade—and what you’d like to achieve in 2020. Let us know in the comments below. â€Å"The first time we did group work on the program, I went head-to-head with a colleague. It taught me a lot about how I see people, how people see me, and how conflict can be resolved in a kind and productive way. The best feedback you get, when delivered constructively, is the most critical because it really feeds into how you lead. I’ve completely reversed my leadership style—the result is so much richer and more powerful when you lead from behind and lead with strength. . Studying in tandem with working, whilst challenging, gave me the perfect platform to directly apply learning concepts into my business environment, the competitive landscape, and the real-estate industry as a whole. When I started the program, I was very happy in my corporate role. But my courage and aspirations grew to the point that I took on a whole new direction. Having my career coach, Joanna, as a sounding board allowed me to really be strategic and get to know myself. She coached me thro ugh all the interviews, the research, and the questions. It went in parallel with what I was doing academically and after six months everything just clicked. . I went into the EMBA knowing I had nothing to lose and I’ve come out with everything. Great strength, global friends, amazing learning, mentors from professors, a job I love, and the knowledge that I can set my mind to achieve anything and with the right support and resources I’ll get there.† . Kashani Wijetunga British, New Zealand Sri Lankan Associate Director Senior Strategy Consultant CBRE EMBA Class of 2019 . â€Å"The first time we did group work on the program, I went head-to-head with a colleague. It taught me a lot about how I see people, how people see me, and how conflict can be resolved in a kind and productive way. The best feedback you get, when delivered constructively, is the most critical because it really feeds into how you lead. I’ve completely reversed my leadership style—the result is so much richer and more powerful when you lead from behind and lead with strength. . Studying in tandem with working, whilst challenging, gave me the perfect platform to directly apply learning concepts into my business environment, the competitive landscape, and the real-estate industry as a whole. When I started the program, I was very happy in my corporate role. But my courage and aspirations grew to the point that I took on a whole new direction. Having my career coach, Joanna, as a sounding board allowed me to really be strategic and get to know myself. She coached me thro ugh all the interviews, the research, and the questions. It went in parallel with what I was doing academically and after six months everything just clicked. . I went into the EMBA knowing I had nothing to lose and I’ve come out with everything. Great strength, global friends, amazing learning, mentors from professors, a job I love, and the knowledge that I can set my mind to achieve anything and with the right support and resources I’ll get there.† . Kashani Wijetunga British, New Zealand Sri Lankan Associate Director Senior Strategy Consultant CBRE EMBA Class of 2019 . â€Å"It was now or never. I knew that I’d have likely stayed in my neighborhood for years to come if I didn’t take this opportunity. I’d not lived or studied outside of the U.S. before. So I left my job as a global strategist at an advertising agency and moved halfway around the world. I’ve come back a more culturally aware, well-versed person. I’ve realized that everything is a learning experience and an opportunity for growth. Ill definitely carry this mindset with me into the future. Technology and social media allow us to be different people in several places at once. Im excited to see how I can establish myself in whatever city Ill be lucky enough to call home and still maintain deep connections with people all over the world. I’m inspired by my classmates every day. Hearing some of their life stories and how getting this degree fits into their greater mission has been very humbling. My biggest challenge has been finding the ‘right’ path for me. There have been rooms Ive felt like I shouldnt be in, but now Im proud to feel as though I truly belong, wherever I am.† . Dwayne Logan, Jnr. American MBA Class of 2019 . â€Å"It was now or never. I knew that I’d have likely stayed in my neighborhood for years to come if I didn’t take this opportunity. I’d not lived or studied outside of the U.S. before. So I left my job as a global strategist at an advertising agency and moved halfway around the world. I’ve come back a more culturally aware, well-versed person. I’ve realized that everything is a learning experience and an opportunity for growth. Ill definitely carry this mindset with me into the future. Technology and social media allow us to be different people in several places at once. Im excited to see how I can establish myself in whatever city Ill be lucky enough to call home and still maintain deep connections with people all over the world. I’m inspired by my classmates every day. Hearing some of their life stories and how getting this degree fits into their greater mission has been very humbling. My biggest challenge has been finding the ‘right’ path for me. There have been rooms Ive felt like I shouldnt be in, but now Im proud to feel as though I truly belong, wherever I am.† . Dwayne Logan, Jnr. American MBA Class of 2019 . Happy New Year, Hultians! . Happy New Year, Hultians! .

Tuesday, May 26, 2020

Application of Business Intelligence - Free Essay Example

Towards Achieving Competitive Advantage through the Application of Business Intelligence Abstract Business Intelligence (BI) plays an important role in providing decision makers with increased ability to take advantage of all available information by making correct and accurate strategic decisions. Making this kind of decisions keeps businesses competitive. Many researches discuss the importance of implementing Business intelligence (BI) solutions. Analytic reporting and data mining tools are parts of Business Analytics which can serve data integration, analytics applications and data warehouse. . The motivation for advantage in business analytics is extensive. Telecommunications operators in particular can greatly benefit if they consolidate and gain global visibility across their numerous, detailed and varied data. The most obvious expected benefits are improved operations processes such as customer service, marketing research, and budgeting. Recent research shows that companies which leveraged business analytics have achieved Return on Investment (ROI) in excess of 100%. Thus it is easy to justify investment in these tools. This investigation is based around a literature survey on Business Intelligence, Business Analysis and Data Warehousing which leads to the identification of strategic issues, challenges and factors to be studied when a Business Intelligence solution is sought by an industry. As a result of the ex perience and understanding gained a Business solution is designed and developed for Telecom operators that build on wide knowledge in the telecom industry to deliver a system that fits well with Telecom operators business models, operational processes and decision-making requirements. Chapter 1: Introduction 1.1. Overview â€Å"In todays highly competitive and increasingly uncertain world, the quality and timeliness of an organisations business intelligence (BI) can mean not only the difference between profit and loss but even the difference between survival and bankruptcy.† (Moss Atre, 2003) The term BI originated from Gartner Group in 1989 by Howard Dresner and it was in that period (early 90s) that BI emerged within the industrial world. Academic interest came later in the mid-90 and evolved greatly ever since (Ou Peng 2006); (Golfarelli, Rizzi Cella 2004). (Howson 2008) describes BI as; â€Å"Business Intelligence allows people at all levels of an organisation to access, interact with, and analyse data to manage the business, improve performance, discover opportunities, and operate efficiently†. Over many decades the corporate world used to gather and store massive amounts of data. They believed that such data had been very important. Indeed, their data were very important but they were unable to use them in solving lots of problems. They were sure that the information they need for taking decisions was hidden in their data but they could not dig it out. So, the data were really valuable but they could rarely benefit from them because they were unable to analyse them. To benefit from the data, organisations need tools to retrieve, summarise and interpret such data to be meaningful and useful for decision making. To fulfill such needs, Business Intelligence (BI) concepts began to arise. BI tools were developed to deal with raw data extracting the required information and knowledge in the form of tables, reports, graphs, pies, charts, diagrams, etc. When BI is deployed effectively, all that data become a strategic asset. We find in competitive environments, the mobile telecommunications operators are focusing on subscriber requirements not only formative service contributions but also determining the network and impact the organisational arrangem ent of the mobile telecommunications operators to focus on specific types of subscribers. Competition has resulted in two distinct trends in the telecommunications industry: * Strengthening of position Carriers trying to get new market share by offering new services, in an effort to compete, perhaps through merging with other success carrier or acquisitions  · Convergence Offering multiple services like form of packages or bundles of products based on customers requirements or specific sales areas. To achieve competitive advantage Telecommunications companies have to use BI solutions like data warehousing, business analytics, performance and strategy and user interface. The typical data warehousing environment involves extraction and loading of data from multiple transactional systems into a data warehouse (or data mart), which is in turn accessed by BI tools and analytic applications. A query on data in the data mart can be 100 times more performing than a similar query in a normalized relational schema typically found in transactional systems. It is also common not to allow end users direct access to the transaction processing systems to perform business analytics to avoid degradation in transactional system performance when analytic processing is conducted. 1.2. Why Business Intelligence? Business Intelligence (BI) in a typical context refers to the use of Business Analytics to significantly enhance decision making at all levels of a business. Business Analytics includes a group of software applications such as reporting and data mining tools which are supported by data integration, data warehousing and analytic applications. Rapidly evolving technology, razor-thin profit margins, intense global competition and eroding customer loyalty mean that in order to survive and thrive, telecommunications companies must be smarter and more agile than ever. The motivation for investment in BI is varied. Telecom operators in particular can greatly benefit if they consolidate and gain global visibility across their numerous, detailed and varied data. The most obvious expected benefits are improved operations processes such as customer service, marketing research, and budgeting. A recent research shows that the companies that leveraged business analytics have achieved ROI i n excess of 100%, so the investment in these tools is easy to justify. To support decision-making processes, such as marketing operation, or customer relationship management, it is necessary for organisations to deploy suitable solutions to support the decision-making requirements of end users. A data warehouse or data mart provides the essential source for a fact-based decision support system. 1.3. BI Applications There are two types of BI solutions the first one is Technology solutions which distribute information with business framework, but without the strong process or application context of business solutions. The other one is BI business solutions goes beyond deliverance of information to fill a key role in business outcomes. 1.3.1. Technology solutions Decision Support Systems (DSS): Support managerial decision-making usually day-to-day tactical Executive Information Systems (EIS): Provide metrics-based performance information consolidation, forecasting, analysis, etc. to support decision making at the senior management level Online Analytical Processing (OLAP): Tools to support business analysts with capability to perform multidimensional analysis of data (e.g., â€Å"what if† analysis of a business problem) Managed Query Reporting: Provides quick and easy access to business data with such capabilities as predefined reporting applications, wizard driven data access, report formatting and templates, web-enabled query tools sets and end user report writers and publishers Data Mining examines data to discover hidden facts in databases using techniques such as machine learning, statistical analysis, pattern/relationship recognition to the most atomic level data; mining tools infer predictive and descriptive information Operational Data Services: Close the loop of business value by enhancing operational processes and systems, and by providing operational services such as operational reporting that would otherwise require reconciling data from multiple operational databases. 1.3.2. BI Business Solutions Customer Analysis Knowing the customer, maximizing customer value, measuring customer satisfaction and loyalty, etc Marketplace Analysis Evaluating the market space, customers, products, competitors, targeted marketing, etc Performance Analysis To optimize and streamline the ways that a business uses its human resources, financial, equipment, Sales Channel Analysis To devise, implement and evaluate sales and marketing strategies, then use feedback to continuously enhance the sales process Productivity Analysis Business metrics and analysis for activities such as quality improvement, defect analysis, capacity planning, asset management, etc Behavioural Analysis Understanding and predicting trends and patterns those provide business advantage, such as: purchasing trends, e-commerce on-line behaviour, etc. Supply Chain Analysis Benchmark, monitor and enhance supply chain activities from materials ordering through product/service delivery 1.4. BI Components Framework The BI components framework identifies the parts of a BI program and the relationships among them. The framework consists of three layers: Business Layer The components needed for BI to fit seamlessly into business organizations, processes, and activities. Administration Operation Layer The components that connect technical components with business components Implementation Layer The technical components needed to capture data, turn data into information, and deliver that information to the business. Business Layer The business layer is made up of: * Business Requirements The reasons to implement BI, and the kinds of results needed including information needs, essential business metrics, etc.  · Business Value The benefits anticipated from or achieved by BI including such things as increased revenue, improved profit margins, risks mitigated or avoided reduced costs, * Program Management The ongoing activities of managing the BI program for maximum business value including establishing enterprise structures and standards, synchronizing multiple and parallel projects, realigning with changing business needs, etc. * Development The project activities that create and deploy BI and DW products including methodology, project decomposition, project success measures, Administration Operation Layer The administration operation layer is composed of: * BI Architecture Frameworks, standards, and conventions that describe BI environment components and the relationships among them including business, data, technology, organizational, and project architectures. * Business Applications Business processes and procedures that access and/or receive information and employ that information to achieve business results. * Data Resource Administration Policies, procedures, and processes for data governance including data owner, steward, and custodial responsibilities. * BI DW Operations Execution, monitoring, and maintaining acceptable quality, availability, and performance of the DW and BI functions and services Implementation Layer The implementation layer consists of: * Data Warehousing Systems, processes, and procedures to integrate data and prepare it to become information.  · Information Services Systems, processes, and procedures that turn data into information and deliver that information to the business. 1.5. Why Have a Data Warehouse? The data warehouse is a main enabler of BI and one of its cornerstones. The two main components of a data warehouse are its Data Model and its extraction, transformation and loading (ETL) processes. The data warehouse is typically loaded from multiple transactional systems then accessed by BI tools and analytic applications. Since this data consolidation process typically includes data quality assurance, the resulting data warehouse becomes the reliable company-wide. Another important benefit is that a query on data in the data warehouse can be hundreds of times faster than a similar query in a normalized relational schema typically found in transactional systems. It is also common not to allow end users direct access to the transaction processing systems to perform business analytics to avoid degradation in transactional system performance when analytic processing is conducted. Yet another benefit is that data warehouses allow for storage of historical data that is usuall y purged from the source transaction processing systems at certain intervals while the data warehouse storage is normally sized for multiple years of data. Finally, multi-dimensional BI tools such as Discoverer will not operate efficiently on top of transactional systems, but need the data imported and structured in a special way inside a data warehouse to produce acceptable performance (fact tables, dimensions, materialized views, OLAP cubes, etc). Above are some of the reasons Telecom operators have opted to invest in Data Warehouse solution, to gain the power to understand and better serve their subscribers as well as having fact-based marketing and financial decision making ground. 1.6. Aims and Objectives Aims: * To identify business intelligence components, and their interactions in the efforts to provide improved competitive advantages. * To study the effect of using BI tools by telecommunications carriers on performance (customer care, marketing, increased market share) Objectives: * Study available research literature and practitioners reports on BI in order to Identify the main BI factors, their attributes as well as their interactions * Identify the currently used BI tools and their expected benefits * Apply business intelligence tools for customer care management data and marketing data and study their effects on performance measured in terms of increased market share against other companies. * Develop context dependent guidelines for the selection and use of the most suitable BI tools 1.7. Outcomes and deliverables A report detailing the following: * Literature review * Identification of Business Intelligence components, attributes and their interactions * A discussion of Business Intelligence tools and their expected benefits * An explanation of applying Business Intelligence tools through the analysis of case studies * An evaluation of using Business Intelligence tools * Context dependent guidelines for the selection and use of the most suitable Business Intelligence tools 1.8. Project Type: Research and Evaluation Project, Industry based 1.9. Research methodology Case study of developing a Data Mart for Call Detail Record (CDR) analysis to identify customers behaviour based on implementing proposed solution on Churn Management Analysis model to help the CRM and Marketing Departments in determining their plans and promotions, This investigation uses mainly the action research approach. In addition, a literature review is presented. In action research, the researchers interact with a project to apply a data mart as one of business intelligence tools and in-depth information is elicited. Chapter 2: Literature Review 2. 2.1. What is Data Warehouse â€Å"Data Warehousing is an architectural construct of information systems that provides users with current and historical decision support information that is hard to access or present in traditional operational data stores. The need for data warehousing from Business perspective In order to survive and succeed in todays highly competitive global environment: Decisions need to be made quickly and correctly, the amount of data doubles every 18 months, which affects response time and the sheer ability to comprehend its content and rapid changes To provide the organizations with a sustainable competitive advantage Customer retention, Sales and customer service, Marketing and Risk assessment and fraud detection† (Alex Berson Stephen J.Smith, 1997) AS we see here, author builds his definition on the purpose of Data Warehouse, which is decision support information, the Data Warehouse architecture which is easy access to get needed information for users and which business are as will be effected by using Data Warehouse. â€Å"The Data Warehouse is nothing more than the union of all the constituent data marts.† (Ralph Kimball, et al, 1998) Here both previous author are defining Data Warehouse according to their contents as a group of data sources assuming that all data store roles intake, integration, distribution, access, and delivery â€Å"A data warehouse is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions† (W.H. Inmon 1999) Here previous author is defining Data Warehouse according to their characteristics, which are subject-oriented, time variant, nonvolatile collection of data to achieve easy queries through large business databases. â€Å"The concept of data warehousing is really quite simple. Data from older systems is copied into a new computer system dedicated entirely to analyzing that data. Normally, the data warehouse will store a substantial amoun t of historical data. Users of this system are able to continuously ask or query it to retrieve data for analysis. The intent of the data analysis is to better understand what is happening, or what did happen, within a company or organization. The value of better understanding is better decision making. There is a tangible value to better decision making for every organization across all industries.† (Paul Westerman, 2000) AS we see here, author builds his definition on the purpose of Data Warehouse, which is decision support system for organisations by analyse data, and the relation between Data Warehouse and Operational Database which is come from. But required data not copied from Operational Database, but it is processed before inserting into Data Warehouse. â€Å"The definition of Data Warehouse is data-oriented and does not include all the processes connected with the Data Warehouse technology. In order to get a process oriented definition, the term Data Warehousi ng became more popular: Warehousing refers to a set of processes or an architecture that merges related data from many operational systems to provide an integrated view of data that can span multiple business divisions. Connected with the Data Warehouse concept appears in 1993 the term OLAP (Online Analytical Processing) that is â€Å"a category of software technology that enables analysts, managers and executives to gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information that has been transformed from raw data to react the real dimensionality of the enterprise as understood by the user.† (J. Moreira, J. Sousa / Investigac ¸ ËÅ"ao Operacional, 2006) According to previous author, the definition is based on the Data Warehouse functionality and technologies processes which are used in Data Warehouse, that more than definition but going deeply into technical architecture. â€Å"A data warehouse is the collec tion of data extracted from various operational systems, transformed to make the data consistent, and loaded for analysis. With some business users, â€Å"data warehouse† has become a dirty word, associated with â€Å"expensive,† â€Å"monolithic,† and of no business value. Other terms, such as reporting database and data mart, are also used and may sound less monolithic to some business stakeholders. In reality, they both serve similar purposes but might have different scope and technical architectur†e. (Howson, 2008) Here we see that the author define the Data Warehouse from business point of view which declare that Data Warehouse is costly without business value, but that definition is so simple and consider as criticism of data warehouse. Finally, we can find that data warehouse brings the data from the underlying heterogeneous databases, so that a user only needs to make queries to the warehouse instead of accessing individual databases. The co- operation of several processing modules to process a complex query is hidden from the user. Effectively, a data warehouse is built to provide decision support functions for an enterprise or an organisation. 2.2. What is Business Intelligence â€Å"Business Intelligence is the conscious, methodical transformation of data from any and all data sources into new forms to provide information that is business driven and results oriented.† (Biere, 2003) We can find that this definition is declaring the general framework of BI technologies according to Input and Output prospective, but without mention of working processes â€Å"BI is neither a product nor a system. It is an architecture and a collection of integrated operational as well as decision-support applications and databases that provide the business community easy access to business data.† (Moss Atre, 2003) We see that this definition is declaring the purpose of BI which is decision-support applications with mentioning the general architecture of BI Many organisations are faced with unprecedented growth in the sheer amount of internal and external data available to them. In many instances, organisations create information systems to deal wit h business requirements as these develop, often leading to many disparate systems. As a result, many organisations end up with voluminous data about their business but relatively little business knowledge (Harrington, in Nemati 2005: 66). We see that this definition is declaring the needs of different organisations to BI to transforming their several Data sources into effective business knowledge which is based on huge business data. â€Å"In particular, BI means leveraging information assets within key business processes to achieve improved business performance. It involves business information and analysis that are: Used within a context of key business processes, Support decisions and actions and Lead to improved business performance† (S. Williams, N. Williams, 2006) We see that this definition is declaring the needs of different organisations to BI to analyse their information through business processes to use analysis results in decision making to get the best improvement in performance so improving organisation profit. This is based on the purpose of using BI. â€Å"BI provides a means for extracting information from the clutter that would be useful for reporting and decision-making purposes. Not surprisingly, the information technology (IT) industry coined the phrase ‘business intelligence,† (Chou, Tripuramallu Chou 2005:344). We see that this definition is explaining the BI as organising mess data to useful in reporting and decision-making purposes â€Å"BI is a broad category of application programs and technologies for gathering, storing, analysing, and providing access to data.† (Z. Michalewicz, et al 2006) We can find this definition of the general working processes into BI applications. Without explaining how to execute mention processes and given input or required output. â€Å"Business Intelligence (BI) is an umbrella term that combines architectures, tools, databases, applications and method ologies. It is, like IT and MIS, a content-free expression, so it means different things to different people.† (E. Turban, et al 2008) So, we can define Business Intelligence as a collection of applications which facilitate organisations for learning knowledge from their existing data. Chapter 3: Business Intelligence As illustrated in 1, data is organizational facts periodically collected by organisations in the form of bits, numbers, symbols and objects. Information can be extracted by processing and restructuring data, i.e. Information is organised data. And, knowledge is generated by integrating information to get facts, relationships that have been discovered. So, knowledge is the main component of any decision-making process. The general goal of most BI systems is to access data from different sources, transform these data into information then into knowledge and finally provide an easy-to-use graphical user interface to display this knowledge. So, a BI system is responsible for preparing information from data then mining data to get knowledge which is presented in a friendly way to enhance the users ability to make good decisions. BI can transform an environment that is reactive to data to one that is proactive. A major goal of the solution is to automate and integrate as many steps and functions as possible. Another goal is to provide data for analytics that are as tool-independent as possible. (Biere, 2003) 3.1.1. Business Requirements for BI Business Context Drivers, Goals, and Strategies Business Drivers Forces that cause a need to act * improved competition * altering regulations * altering economy * Amalgamation or acquisition * Altering marketplace * Altering workforce * Altering technology Business Goals Desired outcomes of actions * Improved market share * Improved customer share * improved customer retention * cost reduction * improved revenue * improved profit margins * reduced cycle time Business Strategies Planned means to achieve goals: * Competitive pricing * Innovative product packaging * Customer loyalty programs * Outsourcing and partnerships * New sales channels * supply chain optimization * New delivery channels 3.1.2. Business Value The Business Case for BI The minimum business case for BI demands evidence that benefits are achievable, showing that investment will create a positive return, a foundation to assess results and measure their value, and a means to quantify and allocate costs. Both cost and value can be elusive. Some aspects of each are readily measurable. Cost and value assessments need to be performed at the start of a BI program, and continuously throughout the life of that program. Valuation models and metrics include: Return on Investment (ROI) ROI is the most common and readily understood of BI program valuation models. Measuring ROI throughout the life of a BI program provides basic metrics to assess BI effectiveness but little information to take corrective action or make improvements. In its simplest form, ROI can be expressed as comparison of value received (revenues generated and costs avoided) with costs incurred within a designated time period. ROI measures for BI programs include many challenges first in identifying the impact of information, then in determining the value of those impacts. Cost determination may also be elusive, in particular identifying and quantifying indirect costs. Return on Assets (ROA) ROA complements ROI for valuation of a BI program. Where ROI measures value relative to expenses, ROI compares value received from BI (revenue generated, costs and risks avoided) with the value of assets essential to BI deployment. Assets to be considered go beyond the obvious technical infrastructure hardware, software, storage, etc. to include the data used to provide BI information. BI offers opportunities to increase the value realized from data assets. Total Cost of Ownership (TCO) TCO models provide a structure to capture all costs associated with a BI program. Cost categories include hardware, software, staffing, and services. All costs including development, deployment, operation, support, and enhancement are included. TCO is total cost of the program from inception to the present. Measuring TCO for multiple time periods (program-to-date, year-to-date, current fiscal period, etc.) provides complete and substantial cost measures to be used in ROI and ROA calculations. Total Value of Ownership (TVO) TVO models provide a structure to capture value of all benefits derived from a BI program. Value categories include revenue received, costs avoided, and cost of risks avoided. All Measuring TVO for multiple time periods (matching those for TCO measures.) provides complete and substantial value measures to be used in ROI and ROA calculations. Time to Payback Time to payback is a predictive measure that estimates the point in time when TVO will be equal to TCO for a BI program. Regularly estimating time to payback and monitoring changes in the estimate is useful when managing the BI program. 3.1.3. Business Analytics Business Metrics and Business Management Metrics-Based Management Business metrics are specific, defined, quantifiable indicators of performance or behaviour in some aspect of a business. Metrics that are aligned with business goals and defined as standard measures of those goals are most useful for business management. A higher education institution, for example, may set a goal of having all undergraduate students complete a degree in four years. Time-to-degree metrics measuring by academic discipline, student demographics, financial aid availability, etc. help to measure achievement of the goal and identify actions that will help to improve time-to-degree performance. Periodic measures over time supply information about trends, provide feedback about effectiveness of previous actions, and help to plan future actions. Three general business management disciplines are common. BPM has two distinct meanings. It has been used for both Business Process Management and Business Performance Management. The two are similar in their use of metrics as part of business management discipline. They differ in goals, scope, and kinds of metrics. BAM Business Activity Management (or Monitoring) is yet another metrics-based discipline unique goals, scope, and kinds of metrics. Customer Relationship Management (CRM) is a customer-focused approach to meeting business goals. Supply Chain Management (SCM) focuses on product/service delivery sequences to meet business goals. Business Process Management This BPM discipline applies metrics to a single business process to maximize its contributions to overall business goals. The internal workings of the process are invisible, so the metrics are about things external to the â€Å"black box† the product, customers, suppliers, inputs, events, etc. Business Performance Management This BPM approach applies similar metrics across multiple business processes to maximize goal oriented performance across the enterprise. This version of BPM also employs metrics for products, customers, etc. but with an enterprise perspective. It recognizes dependencies among processes, and acknowledges that many processes may have overlapping suppliers, events, and inputs. Business Activity Management BAM applies metrics within a single business processes to optimize that process to best achieve business goals. Where BPM treats the process as a â€Å"black box,† BAM looks inside the box. BAM metrics measure activities and the workforce that performs those activities. Customer Relationship Management CRM applies metrics to maximize customer value, enhance customer satisfaction, and increase customer retention. It focuses on measures of customers and business interactions with those customers customer value, customer loyalty, customer satisfaction, customer behavior, etc. Supply Chain Management SCM applies metrics across multiple business processes to optimize the entire sequence of activities that supply a product or service to a customer. The sequence from materials ordering, through manufacturing, to product delivery involves a complex set of activities and dependencies among those activities. Metrics related to demand, materials, inventory, warehousing, resources, and delivery all have a role in SCM. Performance Dashboards for Information Delivery Dashboards Defined Business analytics supply the metrics necessary to support disciplines like BMP, BAM, CRM and SCM. Performance dashboards are a popular way to present analytics in a concise form for executive and management review and action. Key performance indicators (KPI) metrics are the fundamental elements of performance dashboards. KPIs are presented in visual formats that highlight current performance, trends, forecasts, and alerts clearly and concisely. Ideally, the dashboard is integrated with underlying analytic applications to support drill-down to selected detail. Dashboards Metrics Dashboard metrics are based on a short list of KPIs that the business has determined to be the most important variables in achieving business goals. Some common metrics include: * Financial profitability, sales by location, revenue growth trends, and average product cost, margins by product/service line, etc. * Market market share, marketing campaign effectiveness, purchasing trends, customer base changes- % of new vs. existing, etc. * Customer satisfaction, product availability, and product returns, * Logistics order to delivery time, JIT inventory levels, supply chain vendor performance * Resource Performance personnel productivity, return on key assets, production capacity, regulation compliance, Deploying Dashboards Some BI technology vendors offer dashboards that can be purchased and customized to the specific goals and KPIs of a business. Alternatively, the dashboard can be a custom product developed by the IT department using metric data management and visualization technologies. Where multiple analytic tools and applications have been deployed in a non-integrated form, a dashboard may prove to be a useful portal to a variety of analytic information and metrics. A portal of this type may drive standardization of business metrics and consistency of analytic applications across the organization. Scorecards for Information Delivery Scorecard Defined Scorecards are applications that generate and display key performance indicators and other business analytics through the context of a specified methodology for comparing business performance to business goals. A scorecard is: * Used to manage business performance within and across processes and organizations, * Methodology based, * Integrated into the overall BI environment. Scorecard Metrics Using the Balanced Scorecard methodology as an example, the organization is viewed from four perspectives: Financial, Customer, Business Processes and Learning Growth. Objectives, metrics, and targets are defined for each view. Then data is collected and analyzed for each component, providing a comprehensive framework of cohesive and coherent metrics that represent the business vision and strategies. In this example, some of the metrics could be: * Financial total sales cost of sales, percentage revenue by product and increased profitability. * Customer customer satisfaction, customer service, brand awareness, percentage of repeat shoppers and new shoppers. * Business Process percentage of back orders, on time delivery, average order cycle, * Learning and Growth training funds, percentage trained and untrained, time between courses, hours of training by employee and number of mentors per employee. Deploying Scorecards Some vendors offer scorecard products1 but technology does not make a scorecard culture. Business-driven, top-down development that addresses training, standards, strategies, goals, metrics, targets, systems, and data collection is essential to successful scorecard deployment. Sustained effort, patience, and leadership are necessary to adopt the disciplines of scorecard management and to become a scorecard culture. Chapter 4: BI THEORETICAL FRAMEWORK Each of these components is described in the following sections. 4. 4.1. 4.1.1. 4.1.2. 4.1.3. 4.1.4. Data Warehouse 4.1.4.1. Data Warehouse Characteristics Data Warehouse is trend of getting data after processing to be integrated, subject oriented, non-volatile, time-variant, accessible, meets business information needs and process of turning data into information. Integrated: Data Warehouse provides a complete source of information for the business. Provides needed data without accessing multiple sources, using several technology platforms with potentially inconsistent data. Subject-oriented: Data and information is organised and presented as business subjects aligned with information needs. Time-Variant: The warehouse contains historical information and current information of the. Structures and intervals are kept consistent across time, allowing time specific analytics such as trend analysis. Stable: The warehouse provides information stability just get information written to the warehouse is not overwritten. Accessible: Warehouse is to provide easily accessible information to business people. Meets Business Information Needs: Data Warehouse provides an organised data source, against which a variety of standard tools can be applied by business knowledge workers to manipulate 4.1.4.2. Warehousing Data Stores Central Data Warehouse (HUB) As previously discussed, Inmon defines a data warehouse â€Å"a subject oriented, integrated, non-volatile, time-variant, collection of data organized to support management needs.† (W. H. Inmon, Database Newsletter, July/August 1992) the intent of this definition is that the data warehouse serves as a single-source hub of integrated data upon which all downstream data stores are dependent. The Inmon data warehouse has roles of intake, integration, and distribution. Kimballs Definition (BUS) Kimball defines the warehouse as â€Å"nothing more than the union of all the constituent data marts.† (Ralph Kimball, et. al, The Data Warehouse Life Cycle Toolkit, Wiley Computer Publishing, 1998) This definition contradicts the concept of the data warehouse as a single-source hub. The Kimball data warehouse assumes all data store roles intake, integration, distribution, access, and delivery Differences in practice Given these two major definitions of the data warehouse Inmons (hub-and-spoke architecture) and Kimballs (bus architecture), what are the implications with regard to the five roles of a data store intake, integration, distribution, access and delivery? Table 1 Main Differences between Inmon and Kimball according to roles of Data Store Inmon Warehouse Kimball Warehouse intake fills the intake role, but may be downstream from staging area Fills the intake role downstream from â€Å"backroom† transient staging integration Primary integrated data store with data at the atomic level Integration through standards and conformity of data marts distribution Designed and optimized for distribution to data marts Distribution is insignificant because data marts are a part of the data warehouse access May provide limited data access to some â€Å"power† users Specifically designed for business access and analysis delivery Not designed or intended for delivery Supports delivery of information to the business 4.1.4.3. Data Warehousing Architectures Hub vs. Bus Architecture Hub Spoke Architecture The hub-and-spoke architecture provides a single integrated and consistent source of data from which data marts are populated. The warehouse structure is defined through enterprise modeling (top down methodology). The ETL processes acquire the data from the sources, transform the data in accordance with established enterprise-wide business rules, and load the hub data store (central data warehouse or PSA). The strength of this architecture is enforced integration of data. Table 2 Pros Cons of Hub Spoke Architecture Pros Cons * Produces a flexible enterprise architecture * Retains detail data in relational form * Eliminates redundant extracts from operational data sources * Integration is consistent and enforced across data marts * Requires considerable front end analysis long start-up time * Warehouse grows large quickly high startup costs and maintenance * Design to delivery time is too long BUS Architecture The Bus Architecture relies on the development of conformed data marts populated directly from the operational sources or through a transient staging area. Data consistency from source-to-mart and mart-to-mart are achieved through applying conventions and standards (conformed facts and dimensions) as the data marts are populated. According to Kimball, the warehouse manager establishes, through a very short data architecture design phase, a focused and finite overall data architecture, which defines the scope of integration for the complete warehouse. The manager then oversees construction of each data mart. Over time, as enough data marts are developed â€Å"the promise of an integrated enterprise data warehouse† is realized. The strength of this architecture is consistency without the overhead of the central data warehouse. Table 3 Pros Cons of BUS Architecture Pros Cons * Integration done where and when the business needs it * Less up front modeling required * Start up costs are less * Higher risk of data inconsistency * Standards dont have enterprise view * May have to rework existing data marts as operational sources change 4.1.4.4. Business Intelligence Processes Data Access Processes Data access processes are those activities performed by business people who want to receive data that they will analyze, interpret, or use locally and individually. These processes are usually performed by people who have some skill in working directly with data. They are generally not strategic processes, but tactical or operational in nature. Data access processes are supported by tools with ad hoc query, report generation, and data retrieval capabilities. A single data access process may use several of these features. For example, a process to send a customer survey: †¢ Perform an ad hoc query to determine the number of customers who meet particular selection criteria. †¢ Repeat queries while refining selection criteria until the number of customers matches the desired size of the survey population. †¢ Use a report generator to create and format a report of customers to receive the survey that includes name, address, etc. †¢ Use data retrieval fea tures to download the report in a digital format. †¢ Merge the digital report with the survey to format and print personalized surveys to be mailed to each customer. This example describes a business process. The purpose is to produce a survey not simply to retrieve data. From determining the survey population to producing the survey document, the process is facilitated by data access capabilities. Information Delivery Processes Information delivery processes differ from data access processes in two very significant ways: (1) They provide information not just data; and (2) They are initiated by automated systems not by individuals. Further, information delivery processes are likely to participate in strategic and tactical activities, where data access processes work in the range of tactical to operational. Information delivery technologies include: †¢ OLAP, which delivers metric information for interactive analytical, †¢ report publish subscribe capabilities, †¢ dashboards and scorecards that present performance indicators, business metrics, alerts, trends, and forecasts in visual formats, †¢ Analytic applications that package many information delivery capabilities for specific business purposes. Information delivery processes enable business activities such as fraud detection, supply chain optimization, performance management, etc. Data Mining Data mining is a process of knowledge discovery â€Å"a means for finding new intelligence from collections of data. †¦ The process of discovering patterns that lead to actionable knowledge from large data sets through one or more traditional data mining techniques, such as market basket analysis, or clustering.† (David Loshin, 2003) Data mining is a process performed by business people, although it may be enabled by technology and assisted by IT staff. Fundamental to discovery of new knowledge is the ability to recognize discoveries in context of the business situations where they provide value and can drive effective business actions. While data mining may be goal-oriented or less specific the knowledge being sought is always that which is not yet known to the business person. Technology is an essential part of data mining; without it, people simply do not have the capacity to examine large collections of data and uncover implicit patterns. Data mining software applies logic and algorithms to inductively identify patterns and relationships inherent in data, and sometimes to infer rules from those patterns. Data mining enables discovery and facilitates awareness. People then interpret the patterns and inferences, and apply judgment to achieve insight and understanding. Applied Analytics BI technology can provide analytics (trends, alerts, forecasts, and other business metrics) but technology cant act upon those metrics. Analytics are applied in context of business processes (sales, marketing, delivery, product development, etc.) and functions (managing customer relations, managing the supply chain, etc.). Like data mining, application of analytics is a process performed by business people. Awareness of trends and predictions, determination of responses, and decisions about the form and implementation of those responses are all part of applied analytics. Ultimately, the value of analytics is in the actions that result from them, not in the metrics themselves. Only by acting upon the information provided does BI provide value, increase effectiveness of business tactics, and enhance the strategic position of an enterprise. 4.1.4.5. Data Warehouse Environment Data warehouses comprise a multifaceted environment that spans the information systems spectrum from operational transaction systems to systems designed for executive and front-line decision makers. There are four main elements of a data warehouse environment: 1. Source systems 2. ETL 3. Data warehouse repository 4. Reporting tools and portals 1. Source Systems Source systems provide the raw material for the data warehouse and business intelligence systems. The design and implementation of these applications is outside the scope of the data warehouse, and source systems are typically treated as black boxes. Some of the considerations we have with regard to source systems are listed below.  · The amount of time available to extract data from the system: Source systems such as ERP and CRM systems have limited windows of opportunity to perform maintenance or execute long-running data extractions. Those constraints must be balanced against the need to regularly refresh the data warehouse.  · The ability to execute incremental extractions: Some legacy systems may not support extractions based on timestamps or other indicators of new or modified data. In these cases, the next phase (ETL) must distinguish new and modified data from existing data already in the data warehouse.  · Multiple sources of information: Multiple applications may maintain overlapping information, such as customer records. Prior to building the data warehouse, designers need to determine whether a particular record will be the record of source or whether partial data from multiple sources must be combined to form a record of source. Operational systems have often evolved independently of each other. The adoption of enterprise software such as ERP and CRM systems provides the basis for consistent data sources in many organisations. However, legacy systems with inconsistent data representations are still common and need to be reconciled within the data warehouse environment. This is one of the responsibilities of ETL systems. 2. ETL ETL stands for Extraction, Transformation and Load Systems. The development and management of ETL processes often require a majority of the time and resources in a data warehouse project. The extraction process focuses on getting data out of the source systems and into a staging area for further processing. The transformation process uses raw data from multiple source systems, scrubbing and reformatting the data to create a consistent data set. Some of the most common operations are applying consistent coding schemes, removing duplicate records, reformatting text data, sorting, calculating derived date attributes, looking up foreign key references, joining data streams, and aggregating data. After applying a series of transformations, the cleansed data is loaded into the data warehouse in the final format familiar to business intelligence users. 3. Data Warehouse Repository The data warehouse repository is the long-term, historical, integrated database that supports business intelligence operations. Most are built on relational database management systems and advanced users combine them with OLAP systems as well. 4. Reporting Tools and Portals Reporting tools provides us with defined reports that are generated automatically and distributed to users according to advanced OLAP tools. o Ad Hoc Query Tools These systems allow users to run parameterized reports on an as-needed basis or to create their own custom reports. Ad hoc query tools are suitable when end users have a solid understanding of the underlying business process modeled in the data warehouse and seek a detailed review of information. o Dashboards Dashboards are reporting tools that display key performance indicators. These are especially useful for executives and others who need a high-level view of an organisation or operation. o Visualisation Tools Visualisation tools combine the best of both ad hoc query tools and dashboards. Like dashboards, visualisation tools can simultaneously provide a high-level view of several measures. Users can drill into the detail of underlying information. Visualisation tools are suitable for both analytic and no analytic users. o Portals A portal can provide the flexible access to data warehouses needed by executives and line of-business managers throughout an organisation. Portals are ideal delivery vehicles for business intelligence reporting. Portals are easily customized to provide quick access to frequently used reports. 4.1.5. Business Analytics Bi technology can provide analytics capabilities which analyzing stored data. 4.1.5.1. Online Analytical Processing (OLAP) It is a capability that focuses on analysing and exploring data. While reporting tools focus on accessing data for monitoring purposes. OLAP change the focus from â€Å"what† is happening, to exploring â€Å"why† something is happening. To declare that the â€Å"why,† users didnt know in accurate way what information they are searching for and instead will search and drill within a data set to display specific details. OLAP gives us interactive analysis by different dimensions and different levels of detail. 4.1.5.2. Data Mining Data mining is a process performed by business people. Technology is an essential part of data mining; without it, people simply do not have the capacity to examine large collections of data nor uncover implicit patterns. 4.1.6. Performance and Strategy Cherry Tree Co., 2000 mention that Organisations are increasingly utilising analytical tools in conjunction with CRM applications to improve the effectiveness of marketing campaigns. BI tools offer a strategic, tactical and functional framework to address business analysis needed across the entire organisation. 3 summarises a few of the characteristics that influence the need for advanced analytical capabilities. While this is an oversimplification of the numerous benefits and analysis, it does provide an illustration of the value recognized throughout the organisation. One specific example pointing to the value of increased analytical capabilities is the use of tools to evaluate marketing campaigns. 4.1.7. User Interface To benefit from the above mentioned BI components; users need an easy-to-use interface. The user interface is used to present information in a way that is easy to read. It presents graphs, charts, tables, etc. that show the organisations performance. Visual technologies are used to make the user interface more attractive and understandable to users. Chapter 5: Business Intelligence Solution Overview With the rapid growth and continued emergence of new telecom services, having an analytical platform to give management full visibility of their business and support decision making is considered a big challenge. The BI solution:  § Is a suitable solution that copes with current and future business and technology requirements  § Quickly realizes ROI  § Achieves timeliness quality of data  § Is a one source for all information  § Attains proper authentication of data  § Offers user-friendly reporting and analytical tools 5.1. General Features In this section well explain each feature in proposed solution from business point of view 5.1.1. Data Model The BI product includes a â€Å"subscriber-centric† data model which is adapted to the telecom industry where emphasis is to understand the subscriber past behavior to detect patterns and to guide marketing campaigns, new services, credit policy, and customer service, ultimately maximizing revenue and customer loyalty and minimizing churn. 5.1.2. User Interfaces BI solution uses Oracle Discoverer version 10g for its Presentation and Analytics layer. Discoverer is now recommended by Oracle for both standard reports and analytical reports with a choice of 3 user-friendly clients: desktop, web, and web plus. Each tool gives users different level of features and control to match the business role. Charts and 1-click export to Excel are standard features. BI solution uses Oracle Portal to provide an advanced web interface for all reports. The BI solution Portal includes a KPI dashboard that clearly shows where company key metrics currently stand in relation to the company objectives. With easy-to-manage ETL processes enabling simplified operation and quality control, the BI solution offers near-real-time access to be validated and quality controlled business data for trend analysis. BI solution also offers real-time reporting on transactional data when such immediate access is needed. Analytical reports and portal-based dashboards with KPIs and score cards such as this will keep the decision-makers informed and give them the tools to drill-down, analyze, and make the right informed decisions. 5.1.3. ETL Performance and Data Quality ETL performance is a key factor in evaluating any BI solution. There is a limited time window every day for ETL and the system should perform within that window now and under future heavier loads. BI solution achieves this goal by using at its core high-performance ETL code generated by Oracle Warehouse Builder which leverages the full features of the Oracle database to produce extremely fast ETL. BI solution includes ETL, which is tested in live Telecom environments. This ETL performance however should not come at the price of compromised data quality. BI solution uses high-performance ETL code generated by Oracle Warehouse Builder which includes data cleaning and transformation as part of the ETL and adds custom ETL monitoring tools that allow operators to efficiently validate the data for completeness before making it available to end-users reports. A most important feature of BI solution is that it creates enough metadata as part of its ETL processes to build a solid audi t trail that company revenue assurance department can use to validate and prove the accuracy and completeness of the data. With all data clearly published in one place and certified by revenue assurance, the BI has what it takes to be accepted as the â€Å"One Source† of information for the company. 5.2. Features for Business Users 5.2.1. Features for Sales, Marketing and Finance Users This section lists examples of reports (Analytics Layer) that can be developed on top of the BI solution Telecom Data Warehouse. The BI solution Data Model shall provide adequate data to develop these listed reports, from which the customer can pick-and-choose the ones it wants or propose new ones that best fit its business needs and particular requirements. The BI solution can provide any report as long as an adequate data source is available. BI solution implementation methodology follows a phased approach that quickly puts usable components in the hands of users. During the detailed analysis phase which follows the customers acceptance of the solution proposal, BI team shall work with the customers IT and business users to produce a drawing of each report. BI team shall subsequently identify the data source(s) for each report, and based on this analysis plus the customers business priorities reach a consensus on which reports will be delivered in which phase. 5.2.1.1. Call Analysis 1. Distribution of Calls * Traffic trend (by call type, by hour, by date, by day type, by weeks, by months). * Operator incoming/outgoing minutes. * Usage patterns time of day (peak, off peak). * Hourly usage patterns. * Total minutes used in any time period. * Average call duration (calls 1min, 1-2 min and so on). * International roaming breakup. * Calls by Tariff Zone. * Calls by Base Stations. 2. Distribution of Services 3. Interconnect Analysis (traffic by interconnect partner/trunk/destination). 5.2.1.2. Prepaid Vouchers Scratch Cards 1. Scratch Cards * Recharging denomination trends, with possible linking of trend to subscriber demographic and usage profile (such as heavy SMS users or heavy International callers). * Recharging time trends (number of days between two card scratched) by subscriber profile (if profile is known). * Number of cards sold by different distribution channels (assuming ERP system tracks scratch card distribution by serial number). 5.2.1.3. Subscribers 1. History of Subscriber Base * Split based on categories and types (normal, VIP, corporate, etc). * Daily Activations/re-activations/disconnections. * Aging of subscribers by category. 2. Geography of Subscriber Base * Connection locations. * Location splits (number of customers per location). 3. Service usage by subscriber category 4. Behavior of Churn Subscribers * Churn based on ARPU Segments. * Churn based on Demographics. * Churn based on credit and payment history. * Churn based on history of technical problems and complaints. 5.2.1.4. Revenue Analysis 1. Charges, invoices, sales (business volume). 2. Settlements with Partners * Volume of charges, account balance for dealers, roaming partners, content providers etc. 3. Profitability of Tariffs * Average Revenue Per User (ARPU) analysis with an option to view from and to a particular date. * Number of subscribers in different balance segments. 4. Debt analysis 5.2.1.5. Distribution Channels POS and dealers analysis * Daily Sales. * Receipts. * Stock. 5.2.2. Features for Customer Service and Contact Center BI solution handles all metrics for a multi-channel contact center that includes phone, IVR, fax, email, and web contacts. Here are few of the many metrics BI solution can produce: 5.2.2.1. Phone Metrics * % Service Level * ASA (Average Answer Delay) * Average Talk Time * Average Hold Time * Total Work Time * Average Work Time * Average Not Ready Time * AHT (Average Handling Time) * And many more †¦ 5.2.2.2. IVR Metrics * % of Calls transferred to the contact center * % of Calls handled by IVR * % of Calls abandoned by IVR * % of terminated Calls Wrong password * % of terminated Calls Wrong Credit Card * % of terminated Calls Wrong Option * % of Calls per language 5.2.2.3. Complaint Metrics * Number of Complaint per subscriber * Average Time to assign * Average Time to pending * Average Time to solve * Average Time to resolve * Average Time to reassign Metrics such as number per subscriber, average handling time, % of channel exceeding the service level, etc., are also handled for Fax, E-mail, and Web channels. 5.3. Specialized BI Applications / Modules This section lists some specialized modules that are planed as part of the BI solution product to further leverage the BI solution data warehouse for complex analysis that the standard Discoverer analysis tool may not fully cover, or in case complex business logic is best represented programmatically while keeping the user interface simple. 5.3.1. Churn Analysis and Prediction Churn is best predicted when based on all relevant and measurable factors such as a particular combination of tariff plan, usage pattern, demographics, credit rating, and history of call center complaints. The more of these factors are captured in the data warehouse, the more sophisticated the analysis and the more accurate the prediction. The BI solutio