August 26, 2017 by
Hi All, In this blog of Tableau tips I will discuss how to highlight the top and bottom in a chart . Often we come across scenarios when we have to show the maximum and minimum value in our chart view . Let us consider our superstore data. If some one asks us to show the sales across the months for the complete data set its quite easy. We can easily construct a bar chart showing us the sales across all the months . These bars by default would be same in color ( until we apply some coloring scheme). What if we are asked to show the bar corresponding to the month with highest sales as Green , the month corresponding to lowest month as Red and all other as Blue. To do this we will would use the Window_Max and Window_Min function to identify the months with max and min sales respectively to create a calculated field. Lets get going and see how we achieve it: Step 1: The first step would be to create a view to show the sales across months. To do this drag the Order Date into the Columns Mark . Right click on the Order Date and select Month that appears second in the drop down. Drag sales to the Rows and select the marks as Bar. Your screen should look like this : Step 2: To identify the minimum and maximum selling month create a calculated field High Low as  under : This calculated field compares each month  sales value to the windows maximum ( maximum sales across all months ) and the windows minimum sales ( minimum sales across all months ) and assigns the value Max if the sales is equal to windows maximum and Min if sales is equal to windows minimum sales. Step 3: Place the created field High Low on the color marks and there you go . Our bars are now colored differently for the maximum and minimum selling months. You view should be somewhat like this: Here we see that the highest sales corresponds to Nov 2017 ( Green ) and lowest sales corresponds to February 2014. For more Tableau Blogs visit my website http://www.vizzingdata.com/

August 1, 2017 by
Data Visualisation has never been easier, all thanks to Tableau. Give a read to my comprehensive blog on the same and explore the horizons you have never before : https://www.analyticsvidhya.com/blog/2017/07/data-visualisation-made-easy/

July 25, 2017 by
Hi All, Today I will show you an effective way of changing the measures and dimensions in a chart using parameter. Consider the following scenario . You have a chart that shows profit across the Sub Categories in the Superstore data. Now we would like to bring Sales in measure and Region in Dimension. Instead of going to the worksheet and changing the measures and dimension we would control the measures and dimension of the chart in the dashboard using Parameters. The following image would make the context clear : Here we see two dropdowns , one for the selection of dimension and other for the selection of Measure . The chart which has the current state of Profit across Sub Categories , would change the state with respect to the selection. For example if we select the Dimension to be Region and Measure to be Sales from the dropdown we would get the following : So lets get started and try to create this with the help of parameters. Step 1: Create a parameter “Select Dimension” for the selection of Dimension . We will consider Category , Sub-Category , Region and Segment inthis case. Step 2: Create a parameter “Select Measure” for the selection of Measure . We will consider the two measures Sales and Profit. Step 3: Create a calculated feild for Dimesion that would pass the values of the dimension parameter when selected. Step 4: Create a calculated feild for Measure that will pass the value of the measure parameter when selected. Drag Dimesion to Rows and Measures to column . Click on the two parameters we have created and from the drop down select show parameter control. Now change the value of measure and dimension from the dropdown and your chart would update automatically. Hope you guys enjoyed it. Subscribe to my mailinglist at : http://www.vizzingdata.com/ to learn Tableau from basics

July 14, 2017 by
The Women's March was a worldwide protest on January 21, 2017, to advocate legislation and policies regarding human rights and other issues, including women's rights, immigration reform, healthcare reform, reproductive rights, the natural environment, LGBTQ rights, racial equality, freedom of religion, and workers' rights. For demonstrating the use case for descriptive analysis on text data, we extracted the data of speech transcripts of multiple speakers of Women's March. The speakers include Angela Davis, Madonna, Gloria Steinem, Ashley Judd, and America Ferrera. We cleaned the data set by removing stop words, fixing normalization of keywords, and performed tokenization. The free flowing text tokens were then aggregated, linked together and run through our theme, sentiment and tone detection in order to unearth insights with respect to different speakers. For theme and sentiment detection, we used IBM Watson that takes the text as input and outputs the tone and sentiment of the text. All of the derived data was then intermingled together with the real domain knowledge. Contexts from their speeches, their themes, and keywords used were checked in other datasets such as twitter, news postings etc. In short, the following process represents the analysis flow: 1. Dataset Curation 2. Dataset Cleaning 3. Text Tokenization 4. Token Normalisation and Aggregation 5. Theme, Sentiment and Tone Detection 6. Contextual Insights using Business Analysis 7. Domain Knowledge Insights Here are the results: The overview: The term “Trump” was directly mentioned by his name in the speeches of Angela, Gloria, and Ashley in contrast to speeches of Madonna and Ferrara where “president” keyword was used to refer Donald Trump. The term “People” was used mostly by all the women, the Phrases include: "It is not - I the president, It is - We, the people (repeated thrice in Ferrera’s speech)" "Freedom struggles of black people", "Resistance to attacks on disabled people", and "Danger faced by marginalised people" Context of “I” vs “We” The term "I" was mentioned in the following statements: “I'm angry. Yes, I am outraged”- Madonna, "I am deeply honored to march with you today"- America Ferrera, “I am a nasty woman. I'm as nasty as a man who looks like he bathes in Cheetos dust”-Ashley Judd "We" was mentioned in these statements: “We dedicate ourselves to collective resistance”- Angela Davis, “We choose love. We choose love. We choose love”-Madonna, “We are here and around the world for a deep democracy that says we will not be quiet, we will not be controlled, we will work for the world in which all countries are connected”-Gloria Steinem, “We are America”- America Ferrera Top Common Themes: Main themes observed from the speeches are - Racism, Immigration, Religion and Women's Rights. The general sentiment and tone associated with these themes are negative (specifically sadness & anger on the current situation of Muslims, Immigrants, Blacks, and Women). Top Observed Tones and Personality Trait: From the overall analysis - Sadness, Disgust, and Fear are the top three observed emotional tones. Openness was observed as the major personality trait. Here is the analysis speaker by speaker 1. Angela Davis: Top Quote: “The next 1,459 days of the Trump administration will be 1,459 days of resistance.” Her top themes expressed in the speech are - Racism & Slavery, Human Rights, Violence, Religion & Immigration, Liberalism. “Resistance” was the most used word by Angela in her speech. Her top personality trait observed from the speech was “Conscientiousness” (Acting in a thoughtful way). Context - Angela Davis appealed for "Collective Resistance": Resistance to the attacks on Muslims and on immigrants, disabled people etc..She called out Trump administration will be 1,459 days of resistance Overall Sentiment - Negative (Disgust and Sadness as the emotional tone) Top Positive Words Used: ‘supremacy', 'united', 'freedom', 'rising', 'celebrate', 'thank', Top Negative Words Used: ‘murder', 'worse', 'dying', 'demands', 'attacks', 'resistance', 'struggles', 2. Madonna Top Quote by Madonna: “Welcome to the revolution of love. To the rebellion. To our refusal as women to accept this new age of tyranny. ” Her top themes expressed in the speech are -Love, White House, Unity, Tyranny. “Love” was the most used word by Madonna in her speech of total 5:10 minutes and 358 words. Her observed personality trait from the speech was also “Conscientiousness” which means - The tendency to act in an organised or thoughtful way. Context - Madonna appealed people to not fall into despair and choose Love Overall Sentiment - Positive ( -0.05 in the range of -1 to +1) Top Positive Words Used: ‘hallmark', 'good', 'right' Top Negative Words Used: ‘false', 'danger', 'refusal', 'fuck', 'shake', 'awful' Most observed Emotional Tone: Anger, likely due to her mentions most negative mentions on “White House” Top Madonna’s Tweets about the rally - Yesterday's Rally was an amazing and beautiful experience. I came and performed Express Yourself and that's exactly - Express Yourself...............So you can Respect Yourself. On Stage at the Women's March In D.C. - With My Girl Amy at the Women's March in D.C. We Go Hard or We Go Home. To view the analysis of other speakers, please share your email id. We will be happy to email it. Feel free to share your views in the comments section. :)

July 10, 2017 by
https://imadata.ninja/fevent/ Users that want to create, update and engage the participants of their events can do so on imadata.ninja. Invite Friends We allow you to invite your friends to join the event by using our powerful guest list manager or by sending out emails. Mass Email We understand that keeping people up-to-date with an event is crucial and those that host events can mass email all of their guests directly from their event manager. Likes, Comments & Shares Users have the ability to easily Like or comment on an event. Activity Feed Each event includes its very own activity feed. Search Filter By using our search filter you can easily find the events they are looking for. RSVP Potential guests to an event can RSVP one of the following options: - Attending - Maybe Attending - Not Attending Post status Attendees have the ability to easily post their statuses into the event activity feed. Start & End Times You can define the exact time their event will start and end. Privacy Control Users can control who can view and comment on their event. Categories Additional categories can be added upon request Report an Event Events can be reported to the Admins by the community to help prevent SPAM and/or remove inappropriate material that is considered to breach the terms & conditions of the site.

July 10, 2017 by
Users are able to send private messages to other users. Easily Find Friends Users can easily find their friends by using our advanced search tool when they are composing a new message. Includes ability to send a message to multiple users. Attachments Users can attach virtually anything to their messages to share with their friends. Photo and Emoji support Users can insert photos or emoji to mail body. New Message Notifications When users receive new messages, the notification system will notify them directly at the top notification bar. Manage messages Users have full control over the inbox messages and sent messages in their mailboxes. Multiple recipients Messages can be sent to multiple recipients. Quick message Users can send a quick message without going to the mail app. This way, you can send a message to recipients at everywhere on your site.

July 10, 2017 by
https://imadata.ninja/advancedphoto/ Photos are an essential section of all social network communities. Members can upload photos to a public gallery or to their own set of photo albums. While uploading photos you can decide the privacy level of who can view their photos online. Profile Photo Albums Each user has a profile photo album, which stores all of their profile photos they have uploaded. Set as Profile Picture You can easily set one of your photos as your main profile picture with a click of a button. Photo Cropping You can easily create a clean look for all your photo thumbnails. Topics Each photo can contain tags the user adds. All these tags are added to a block on the photos index page displaying what is the trending topics and will make it easier for members to search. Mature Content Control Certain images may me mature in nature and for these photos, users can enable the option to identify that it is only for mature users. Multiple Category Selection Each photo uploaded can belong to one or more categories. Categories have no limit with how many child categories it can have. Photo Tagging Users can tag their friends or themselves in their own or other photos. Rotate Photos Users can rotate their photos 90 degrees to the left or right. Photo Theater Mode Viewing photos has never been easier. By using our "Photo Theater Mode" users will be able to click on a photo and it will display the photo right on the spot so they don't lose their place on the site. Likes, Comments, and Shares Users have the ability to easily Like, Comment or Share a photo. Search Filter By using our search filter, your users can easily find photos that you are looking for. Privacy Control Users can control who can view and comment on their photos. Rate Photos Users can rate photos that have been uploaded to the public gallery and has been allowed to be rated on by other users. Users can decide if a photo is allowed to be rated on while processing their images after they have been uploaded. Report a Photo Each photo can be reported to the Admins by the community to help prevent SPAM and/or remove inappropriate material that is considered to breach the terms & conditions of the site. Add Photos to New Posts on Activity Feed While sharing feed, your users can add photos to gain more attention from other users. Multiple Photo Uploads Your users can multiple photos at a time Photo Albums Users can upload photos to the public gallery or keep their photos organized in their very own photo album. Control Downloads For each image, users can control if other users have the rights to download their photos. View All Available Sizes Users are uploading a lot of photos online and sharing them with all of their friends. We make sure your users are happy by keeping the original size of the image they have uploaded and we also create many smaller sizes depending on their need when sharing the photo.

July 10, 2017 by
https://imadata.ninja/ultimatevideo/ Privacy Control Users can control who can view and comment on their video. Search/Filter Videos Users can find the desired videos by using search and filters Likes, Comments, and Shares Users have the ability to easily like, comment or share on a video. Report a Video Videos can be reported to the Admins by other users to help prevent SPAM and/or remove inappropriate material that is considered to breach the terms & conditions of the site. Video uploading and sharing Your users can easily share video from Youtube, Vimeo, Dailymotion, Mp4, Facebook or upload video directly from computers. Categories Additional categories can be created upon request, just use the feedback feature. Allow Downloads Videos uploaded can be flagged as downloadable.

July 10, 2017 by
A notification alert will appear over each respective notification icon. Click on the icon to interact. New Friend Requests Alert appears when someone requests you to be a friend New Messages Alert appears if another user sent you a message New Notifications Users are updated on all activity related to them. Turn on/off Notification Users have full control which notification they will receive by turning the notification settings on or off by going to privacy settings notifications tab.

July 9, 2017 by
A social network community is the place to make friends and share similar interests with each other. Therefore, "friend" is one of the most important features. We provide a way for users to access their friends' list from any page on the site just a click. They will find it easy to find their friends as we provide a powerful search tool that picks up on their friend's name. Users can also list their friends that start with a particular letter of the alphabet. Relationship status Users can assign a relationship status they have with another member of the site. Keep track of request Users can keep track of all the friends' requests they have sent out as well as all the friends' requests coming in. Send e-gifts to friends Users can send out e-gifts to their friends while going to their profiles. Friends lists Each users can create their own list to group their friends in and organize all of their friendships. The friends' lists can also be displayed directly on their profiles. Birthday notifications Users can keep track of their friend's birthdays by visiting the dashboard as we notify users when their friend's birthdays are coming up. Mutual friends When viewing a users profile we list all the friends they both have in common.