How to conduct CRM Data Analysis
CRM data stores contain extremely rich, multi-faceted, and interconnected datasets that are invaluable sources of information on a company’s markets, customers, and sales and marketing operations. These latent treasure troves of data just need to be teased out with the appropriate analyses, but it is extremely important that these analyses be set up as correctly and as optimally as possible from the start. Step 1: Investigating the Ins and Outs of Your CRM Data The first step is to survey the landscape by getting full access to your CRM system. You should get a good rundown of how your sales and marketing teams have been using the data. Next step here is to make sure you understand the pathologies of the data, itself — the number and causes of corrupted records, duplicates, missing values, censored values, etc. Any sufficiently large dataset will contain errors and issues, and CRM data is particularly susceptible because it is mostly manually entered, and is a mixture of structured and unstructured data. Step 2: Grouping the Data Together To do anything meaningful with the data, you need to get it together in an easily accessible place — for example, as a series of spreadsheets, a set of interconnected tables, or a whole relational database that allows you to run queries and reports. Not only will you need to extract the raw data from your CRM, you’ll also need to deal with the data issues that crop up through the standardization of format and normalization of data values. You can use Excel or R software for this purpose. a. Defining the Units of Analysis It includes the grouping of data into market segments. In each market segment, the customers are supposed to have similar needs and buying behavior, so you can develop “ideal customer” profiles. b. Conducting an Exploratory Analysis Once you have gotten all the data in place, you will want to start doing some data profiling and initial exploratory analysis of the data you have pulled together in order to a) develop a sense of the data; and b) detect any potential issue early on. An exploratory analysis can be done simply using the basic functions in Excel such as AVERAGE(), STDEV(), MAX(), MIN(), MEDIAN(). These functions are flexible enough to ignore blank or erroneous data points, and so are easily applied without requiring a lot of preparatory work. Doing light exploratory analysis will also enable you to detect any systematic issue with the data and see what valuable information you might need to append to the data using external sources. Step 3: Mapping Out Your Analyses After that arduous step of getting your data pulled together and set up for the big analysis, you’re closer to uncovering a hidden treasure trove of customer insights. First, you need to work on mapping out the analytical steps you are going to perform. Because there are millions of potential analyses you can do on any sufficiently rich datasets, it is important that you limit your focus strictly to the analyses that will contribute to your objectives. Therefore, you should start first by defining the kind of conclusions that you want to get and work backward from the expected results to the analyses that will provide those results. Setting the Foundation of Your Analysis: Identifying Two Basic Components This is generally in the form of “analysis of X over Y”. Eg: Trends over time or productivity across the sales team. This is usually the most common of data analysis Common Types of analyses you can do with CRM Data. For reference, I’ve provided a sample analysis that can be done with CRM data. Step 4: Executing the Analyses and Interpreting the Results Once you have fully fleshed out your plan and properly prepared, you are finally ready to dive in and start analyzing the data with your powerful toolsets of statistical models and data manipulation scripts. At this point, you can set up templates and automation steps so that when you redo the analysis with a subset of the data or an entirely different dataset, you do not have to start from scratch. For each analysis, think of the ultimate answers that you are looking for, and optimize your calculation steps so that you get exactly those answers — no more, no less. The less data you touch, the fewer the steps you carry out, the less error prone your results are, and the easier it is to replicate your work. For each completed analysis, try to stay focused on the evidence that you are trying to get and the hypothesis you are trying to prove or disprove so that you can sharply evaluate the results and avoid getting bogged down in analysis paralysis. Step 5: Visually Presenting Your Insights To really make an impact with your analysis, you will need to pull together all of the disparate results, and most importantly, connect the dots together to form a holistic view and a consistent narrative of the insights that arise.
BEGUILING FACTS OF ODISSI DANCE FORM Dancing is not only a sports, it is one’s passion, dedication, hard work and love. Being privileged enough to be Indians, we have a lot of scope to learn various kind of dance forms. Be it western or classical, India is hailing in all platforms. There are eight kind of classical dance forms out of which Odissi is one. We all know many things related to odissi dance form but I want to focus light on those topics which is not so known to the people. 1- Odissi dance is also known as Orissi in ancient and older literature. Panchama Veda is also is one of it’s popular name. 2- This type of dance form was originated in Hindu temples of Orissa, India. 3- It is considered to be the oldest classical dance form of India. 4- In history it is mentioned that the dance was performed to expresses religious stories, incidents and spiritual ideas of Hindu Gods and Goddesses specially of Lord Jagannath, Shiva and Surya. 5- According to history, this dance form was mainly performed by the women. 6- Odissi depictions are found in the form of inscriptions and sculptures in temples like Sun temple and Brahmeswara. Also found in the Ranigumpha caves at Udaygiri. 7- Tribhanga is the most important and unique feature of Odissi. Which means three parts break in literature. It is the independent movement of head, chest and pelvis . 8- Abinaya, the body movements are used in Odissi to show and express different posture and attitudes. 9- Mudra is also an important element of Odissi dance. The term Mudra is refers hand position which denotes different types of emotion. 10- Odissi is considered a dance of love, joy and delight with deep and intense passion that is true and fresh, divine and human. Thus the style is soft and lyrical with patches of high pleasure. 11- Over a period of time, three schools of Odissi dance has developed. They are Mahari, Nartaki and Gotipau. 12- The Mahari system came from the Devadasi tradition, the royal courts dance was known as the Nartaki tradition and in the Gotipau tradition of Odissi dance, young boys dress up in female attires and enacted female roles. Some famous Odissi dancers are Hare Krishna Behera , Aditi Bandyopadhyay, Anita Babu , Arpita Venkatesh, Surendranath Jena, Chitra Krishnamurti, Dona Ganguly who is the wife of famous former captain of Indian cricket team, Sourav Ganguly.
STATUE OF LIBERTY
INTERESTING FACTS ABOUT STATUE OF LIBERTY The Statue of Liberty is a gigantic and massive neoclassical sculpture on Liberty Island in New York Harbor in New York city, in the United States. Some interesting and riveting facts about the same are:- 1- The statue of liberty’s full name is Liberty Enlightening the World. 2- Lady Liberty herself is a rendition of the Roman goddess of freedom, Libertas. 3- The seven spikes on the statue’s crown represents the seven continents and oceans of the world. 4- Statue of Liberty was a gift to America from France in 1886. It was created by Edourd de Laboulaye of France. This giant statue honors the friendship and the allegiance to liberty between France and The United States. 5- The head of the statue was displayed at the World’s Fair in Paris in 1878, before the statue appeared in America. 6- From the ground to the top of the torch the statue measures 93 metres, and weighs 204 metric tonnes. 7- 300 different types of hammers were used to create the copper structure. 8- The visitors have to climb 354 stairs to reach the statue’s crown where they can relish the view of New York from 25 windows. 9- Rumor exists that the statue’s face was modeled after the sculptor’s mother, Charlotte. 10- The statue of Liberty has a Morton’s toe, which means that the second toe is larger than the first toe. 11- She holds a torch and tablet upon which is inscribed the date of American Declaration of Independence (July 4, 1776). 12- The statue’s original torch was substituted in 1984 by a new copper torch covered in 24k gold leaf. 13- The statue turned green because of damage. Her exterior is copper that has turned colors due to oxidation. But this green coating serves as protection from further corrosion. 14- Two people have successfully committed suicide by jumping off the statue, one in 1929, and the other in 1932. Few others also tried but survived. 15- It is thought that Lady Liberty is hit by approximately 600 bolts of lightning every year since she was built.
INDIA LEADS IN MANY FIELD We all are proud of India. Being Indian, we all love to know and explore more about India. I am going to share some facts of India in which India leads in world comparison. 1- India is very famous for films, whether it be bollywood or regional. It has gained many awards and appreciation all the way. But one thing which we may not know that India is the largest producer of films in the world. 2- In India we respect and worship cows. It provides many Indians the daily earnings and occupation which indeed makes India the largest milk producer of the world. 3- India is the world’s largest importer of arms. But India has never invaded or attacked a country. 4- India has the largest amount of vegetarians in the world. For the reason Pizza Hut opened a pure vegetarian restaurant in the country. Apart from this, two leading brands, KFC and McDonals also had to introduce a vegetarian menu specially for India. 5- The world’s largest road network is in India—over 1.9 million miles of roads cover the country. 6- With 1.2 billion people, India is world’s largest democracy. 7- India has the world’s largest school in terms of students. The school is situated in Lucknow and it’s name is City Montessori School. It has more than 45 thousand students. That is a huge number! 8- India has the largest number of mosques in the world, even more than any other Islamic country. There are nearly 300,000 mosques in India. 9- The great religious gathering, Kumbh Mela, which occurs after every 12 years, is the world’s largest gathering of people. This gathering is visible from space. 10- The world’s biggest family lives in India. One man, 39 wives and 94 children.
TOP FIVE DESERTS ONE MUST TRY WHILE TRAVELLING TO ODISHA Let’s start with some glace on Odisha. It is situated in the eastern coast of India surrounded by four states, Jharkhand, Chattisgarh ,West Bengal and Andhra Pradesh.The current population is 44.5 crore with the literacy rate of 75%.The state is protected by the blessings of Lord Jagannath. It’s capital is “The city of Temples” ,that is, bhubaneswar.It was once said that Odisha people or Odias are the best cooks in India.Sweets of Odisha holds a special position.The deserts are just awesome and something different which separates it from the sweets of other regions in India.Whether it be dry sweets or syrupy...it just takes off the taste.Now specifying the top popular sweets are:- 1-CHENNA PORA It is a cheesecake kind of thing.It is one of the most famous sweets of Odisha and is considered to be Lord Jagannath’s favourite dish and thus often offered to him in Puri temple.This sweet can be found in any corner of Odisha, selling in grams.The lingering taste of burnt home-made cottage cheese and semolina combined with sugar syrup simply blows away your mind.It is baked for several hours until it turns red and the caramelised sugar gives it the perfect and desired taste. Simple,creamy,light.......just perfect .It can really turn your bad day to a good one. 2-PITHAS It is one of the major sweets found in Odisha.It is a traditional desert in fact.No festival or occasion is complete without this delicious desert.It can be found in any sweet shop or in any ordinary stalls on road sides.It has a outer covering made of flour and the inner stuffing may be of any kind like using coconut and milk or dry fruits and caramelised chenna.The stuffing is filled in and the beautiful shape is given followed by frying it.At the end it is soaked in sugar syrup which completes it as a mouth watering one.The three most famous kind of pitha are chenna poda pitha,enduri pitha and chittau pitha. 3-RASABALI The sweet dished is garnished with cardamoms and soaked in thick flavoured milk. Served in Lord Jagannath temple as a part of chappana bhogas, this delicacy trace its origni from Kendrapara district in Odisha.The flavoured milk left after eating the sweet is just heaven.Definitely one should try this. 4-KHIRA SAGARA This basically represents a common sweet dish in India which is known as rasamalai.The sweet has depiction in Hindu mythological scripture about Laxmi serving Vishnu and Madhusudana with it.It consists of small balls of chenna which is soaked in condensed and flavoured milk. The main unique taste is because of the saffron and cardamoms which blend them overall as a lingering taste.The milk base in khira sagara is thick,rich and creamy which bound to melt your heart. 5-MALPUA This is a mouth-watering dish which is mainly served in odia thalis.It is also often served as sakala dhupa (morning food) to Lord Jagannath.This is basically a pancake which is prepared using milk,flour,smashed ripe banana and coconut batter. These pancakes are then fried and soaked in sugar syrup. Cardamom seasoning gives this a special taste. This is a simple sweet dish which is quite heavy and eating two or three can fill your stomach.So one must take the privilege to taste it.
Types of Data
Types of Data: 1. Nominal Data: The word Nominal comes from the Latin word nomen, which means name. They can be differentiated using a simple naming system, hence can be called as labels. They don’t have any quantitative value. Eg. M-Male and F-Female 2. Ordinal Data: In an ordinal data set, the order of the values matter. It may indicate a temporary position, superiority but arithmetic operations are not applicable to them. Eg. Page numbers of a book. 3. Interval Data: In an interval data set we know about the order and the exact difference between the values. Statistical analysis is applicable here. Eg. Temperature, in degrees Fahrenheit. 4. Continuous and Discrete data: Continuous data represent measurements. They can be measured along a continuous scale which can be subdivided into infinitely fine sub-divisions. Eg- The amount of petrol bought at a petrol pump can take any value between 0 to 8 liters. Discrete Data: Discrete data is based on counts. Only a finite number of values is possible, and the values cannot be subdivided meaningfully. Eg: No. of students in a class( we cannot have a half student)
Prime Minister Narendra Modi congratulates ISRO
The Prime Minister has given his heartiest congratulations towards the launch of PSLV today. This success in the new year will bring benefits of the country's rapid strides in technology to our farmers, citizens and fishermen. The launch also marked the 100th satellite from ISRO. In a series of tweets the Prime Minister has conveyed his heartfelt wishes and has placed a high confidence in the future of the country. The tweet also mentioned that benefits of our country's success would be available to our partners as well. Out of 31 satellites, 28 belonging to 6 other countries are carried by today's launch. The "Cartosat-2 Series" satellite and 29 others will be inserted into 505km sun synchronous orbit. It is the seventh remote sensing satellite in its series and has mission life of five years. The satellite has been developed from addressing multiple aspects like monitoring urban and rural applications, coastal land use regulation, managing services like road networks and water distribution, detecting changes in geographical features and creation of maps. Last year PSLV had suffered a setback in August, but with this being the first flight since then and a step to show that the workhorse rocket is back in the game for reliable satellite launches in the low earth and polar orbits. AS Kiran, ISRO's Chairman, had accepted that there were problems last august but this successful launch proves that those problems were correctly addressed and rectified. Jitendra Singh, Minister of State from Prime Minister's Office, called it as a historic day and a great headway for the country. A brainstorming session between space scientists and officials from different government departments will be organised to understand the diverse applications of space technology in transforming India. The country has steadily been progressing in the field of space related activities with the latest event adding another feather to the cap. ISRO in particular has been taking rapid strides and justifying the expectations of the whole country. The milestone has garnered nationwide interest and will also highlight the efforts put in by the people involved in making it successful. The leaders are recognising these efforts and we can hope for more investment on this front.
A basic definition of organic gardening is gardening without synthetic fertilizers and pesticides. But organic gardening is much more than simply replacing manmade chemicals with those derived from natural sources. It is a philosophy of gardening that supports the health of the whole system. In an organically managed yard or vegetable garden the emphasis is on cultivating an ecosystem that sustains and nourishes plants, soil microbes and beneficial insects rather than simply making plants grow. Creating this ecosystem begins with improving the soil. Adding organic matter by mixing compost into the soil increases its capacity to retain water and nutrients and supports beneficial microbes, which are essential to healthy plant growth. Compost can be made at home from grass clippings, leaves, yard debris, and kitchen scraps, or purchased from garden centers and mulch suppliers. Because of the many turkey farms in our area, turkey compost is the most readily available commercially made compost in our region. Another way to add organic matter to the soil is to grow cover crops and turn them into the soil just as they begin to flower. Cover crops that can be seeded at this time of year include buckwheat, cowpeas, millet, and soybeans.
focus on lesson not on problems
Let me tell you a story: When I was 14 years old, I fractured my spine playing hockey. It was one of the most painful experiences of my life. To me, hockey was everything--I loved that sport more than anything else in the world, and I was determined to play in the NHL. I used to watch The Mighty Ducks with my hockey gloves on, acting out the scenes in front of the television with my hockey stick in the living room, my mom yelling from the kitchen reminding me to be careful and not break anything. When I fractured my spine, I knew I would never play hockey again. In an instant, my childhood dream fell apart. For weeks, I had to wear a Velcro brace around my back. The fracture was big enough to make walking extraordinarily painful, but small enough that I couldn't have surgery. The only thing to do was take Advil and let it heal on its own. At first, I was extremely depressed. I was an awkward teenager and didn't have many friends. The only place I felt like I fit in was on the ice with other people who loved hockey as much as I did. And I'll admit, at first I did what was easy. I blamed everyone else. I was angry and I felt like nothing would ever go right for me, and I refused to even give myself the option of finding the lesson in what had happened. Instead, I just focused on the problem. With nothing else to do, I sat up in my room and started playing World of Warcraft on the computer. 3 years later, and I was one of the highest rated 3v3 players in North America. I was in talks with sponsors. I was considering not going to college so that I could become a professional gamer. I had one of the most-read World of Warcraft blogs on the Internet at a time when blogging was still relatively new (2007). And most of all, I had discovered my love for writing. What could have been seen as a debilitating injury, ended up propelling me to find a new interest, become one of the best players in the world, and ultimately help me find a new dream.