Hot Bloggers
  • 8 Entries
    0 Followers
  • Experienced Senior Business Consultant with a demonstrated history of working in Retail & Healthcare Industry. Skilled in Data Analytics , Market Analysis,Statistical Analysis, Market Research, and Data Visualization. Strong consulting professional with a Master of Business Administration (MBA) focused in Finanace And Marketing from IBS Hyderabad. I am also a Tableau Public Featured Author and am passionate about storytelling using Tableau. Follow me on my blog : http://www.vizzingdata.com/
    4 Entries
    0 Followers
  • Data is my world! Love data visualization!
    2 Entries
    0 Followers
  • Data Scientist with core experience in building automated solutions using natural language processing, machine learning problems, data visualisations and noSQL databases for different industries such as healthcare, social media, insurance and e-commerce - About 3.5 years of experience in industrial data science and analytics, lead small teams of sizes 2 - 8, graduated from computer science and engineering background - Hands on experience with descriptive analytics, predictive analytics, data engineering, text mining, data visualisation, automated data pipelines and big data - NLP Experience: Have built several text classification models by using word2vec, Topic modelling using LDA, Opinion Mining, Entity Extraction, Grammar based corpus parsing, document similarity etc. - ML Experience: Practical experience of several predictive analytics problems - regression, classification, clustering, forecasting. Have used ensemble modelling techniques - bagging and boosting. Models such as - random forests, xgboost, neural networks, CNN and RNNs, collaborative filtering, SVD, PCA, feature engineering and model tuning. - Data Engineering and Big Data Experience: Built large scale data mining engines, REST APIs using flask and Django, Data visualisation using d3.js, google charts. Have used mongo, elastic, redis, celery, hbase, apache phoenix, and apache spark in my works.
    2 Entries
    0 Followers
  • System Engineer at BH Telecom / PhD researcher, lecturer and data scientist Passionate about innovation, creative ideas, economy for good, and networking.
    2 Entries
    0 Followers
Recent Blogs
  • Public
    Tableau -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    The previous article in the series highlighted the steps to create a waterfall chart in Tableau. Today we will discuss about a interesting chart in Tableau : Combination of scatter plot and a pie chart , a scatter pie chart. Sounds interesting , Right ? Lets go ahead and do this using our standard dataset – Sample Superstore Data. We will try to plot the sales and profit on the scatter plot and then try to split each circle in a pie with three marks for Categories. To achieve this we will use LOD calculation in Tableau. To understand more about LOD refer to the article here . Step 1: Create a calculated field to calculate the sales and Profit across states. Step 2: Drag the measure Sales for State in the Columns Shelf and the measure Profit for States in rows shelf. Step 3: Drag state into the detail Shelf and change the mark type to pie. Bring the measure Sales for State to size. Increase the size and your worksheet will now look like this: Our job in now almost done. Add Category to the colors pill and the measure Sales  to the Angle pill. There we go , our Scatter pie chart is now ready The Tableau Workbook can be found here : Scatter Pie Plot   Rahul Singh http://www.vizzingdata.com/ References  Namrata Sawant Jonathan Drummey    
    Favorites 18 Views
    Favorites 18 Views
    Favorites 18 Views
  • Public
    Tableau -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    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 : [img]https://imadata.ninja/PF.Base/file/attachment/2017/08/e1806bb9d0ae9a4631e7f3bd81a5df9c_view.png[/img] Step 2: To identify the minimum and maximum selling month create a calculated field High Low as  under : [img]https://imadata.ninja/PF.Base/file/attachment/2017/08/fed7a085cb2794430f853b6b6785169b_view.png[/img] 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: [img]https://imadata.ninja/PF.Base/file/attachment/2017/08/c062bd96626ab4c73027967dc33daca1_view.png[/img] 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/
    Favorites 12 Views
    Favorites 12 Views
    Favorites 12 Views
  • Public
    Tableau -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    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/ [img]https://imadata.ninja/PF.Base/file/attachment/2017/08/17867f7d746d3b4947c11676aed9d5f0_view.jpg[/img]
    Favorites 12 Views
    Favorites 12 Views
    Favorites 12 Views
  • Public
    Tableau -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    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 : [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/704b9eebced13ccbcb0b988e5d6fdd7c_view.gif[/img] 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. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/b3ff2fea11ac7bc748ed83574cbdec82_view.png[/img] Step 2: Create a parameter “Select Measure” for the selection of Measure . We will consider the two measures Sales and Profit. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/7ea139aaa37b7692d5251c046c97293c_view.png[/img] Step 3: Create a calculated feild for Dimesion that would pass the values of the dimension parameter when selected. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/85b3eda0235d1c7aaf66d0488d0066a3_view.png[/img] Step 4: Create a calculated feild for Measure that will pass the value of the measure parameter when selected. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/c85a10b8b682a6997dcd4933ffae07f1_view.png[/img] 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
    Favorites 10 Views
    Favorites 10 Views
    Favorites 10 Views
  • Public
    Data Visualization -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    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: [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/c2698ed4a975632b68251db2f8a5de23_view.png[/img] 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). [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/a7b4190120c45776e1fe698ab02b0bdf_view.png[/img] 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. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/2446df7103162063c977d206f6eec5f9_view.png[/img] “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', [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/186b17b7519b0455554d6a15868f0252_view.png[/img] 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. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/6d8470445bfcb508d0a56aa4bdaa2fef_view.png[/img] “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. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/3ef2d4028a453e0204e919d404d33bb8_view.png[/img] 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. :)
    Favorites 12 Views
    Favorites 12 Views
    Favorites 12 Views
  • Public
    Site Feature -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    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.
    Favorites Views
    Favorites Views
    Favorites Views
Most Favorited
  • Public
    Tableau -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    The previous article in the series highlighted the steps to create a waterfall chart in Tableau. Today we will discuss about a interesting chart in Tableau : Combination of scatter plot and a pie chart , a scatter pie chart. Sounds interesting , Right ? Lets go ahead and do this using our standard dataset – Sample Superstore Data. We will try to plot the sales and profit on the scatter plot and then try to split each circle in a pie with three marks for Categories. To achieve this we will use LOD calculation in Tableau. To understand more about LOD refer to the article here . Step 1: Create a calculated field to calculate the sales and Profit across states. Step 2: Drag the measure Sales for State in the Columns Shelf and the measure Profit for States in rows shelf. Step 3: Drag state into the detail Shelf and change the mark type to pie. Bring the measure Sales for State to size. Increase the size and your worksheet will now look like this: Our job in now almost done. Add Category to the colors pill and the measure Sales  to the Angle pill. There we go , our Scatter pie chart is now ready The Tableau Workbook can be found here : Scatter Pie Plot   Rahul Singh http://www.vizzingdata.com/ References  Namrata Sawant Jonathan Drummey    
    Favorites 18 Views
    Favorites 18 Views
    Favorites 18 Views
  • Public
    Tableau -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    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/ [img]https://imadata.ninja/PF.Base/file/attachment/2017/08/17867f7d746d3b4947c11676aed9d5f0_view.jpg[/img]
    Favorites 12 Views
    Favorites 12 Views
    Favorites 12 Views
  • Public
    Tableau -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    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 : [img]https://imadata.ninja/PF.Base/file/attachment/2017/08/e1806bb9d0ae9a4631e7f3bd81a5df9c_view.png[/img] Step 2: To identify the minimum and maximum selling month create a calculated field High Low as  under : [img]https://imadata.ninja/PF.Base/file/attachment/2017/08/fed7a085cb2794430f853b6b6785169b_view.png[/img] 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: [img]https://imadata.ninja/PF.Base/file/attachment/2017/08/c062bd96626ab4c73027967dc33daca1_view.png[/img] 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/
    Favorites 12 Views
    Favorites 12 Views
    Favorites 12 Views
  • Public
    Tableau -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    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 : [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/704b9eebced13ccbcb0b988e5d6fdd7c_view.gif[/img] 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. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/b3ff2fea11ac7bc748ed83574cbdec82_view.png[/img] Step 2: Create a parameter “Select Measure” for the selection of Measure . We will consider the two measures Sales and Profit. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/7ea139aaa37b7692d5251c046c97293c_view.png[/img] Step 3: Create a calculated feild for Dimesion that would pass the values of the dimension parameter when selected. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/85b3eda0235d1c7aaf66d0488d0066a3_view.png[/img] Step 4: Create a calculated feild for Measure that will pass the value of the measure parameter when selected. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/c85a10b8b682a6997dcd4933ffae07f1_view.png[/img] 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
    Favorites 10 Views
    Favorites 10 Views
    Favorites 10 Views
  • Public
    Site Feature -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    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.
    Favorites Views
    Favorites Views
    Favorites Views
  • Public
    Site Feature -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    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.
    Favorites Views
    Favorites Views
    Favorites Views
  • Public
    Data Visualization -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    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: [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/c2698ed4a975632b68251db2f8a5de23_view.png[/img] 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). [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/a7b4190120c45776e1fe698ab02b0bdf_view.png[/img] 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. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/2446df7103162063c977d206f6eec5f9_view.png[/img] “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', [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/186b17b7519b0455554d6a15868f0252_view.png[/img] 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. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/6d8470445bfcb508d0a56aa4bdaa2fef_view.png[/img] “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. [img]https://imadata.ninja/PF.Base/file/attachment/2017/07/3ef2d4028a453e0204e919d404d33bb8_view.png[/img] 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. :)
    Favorites 12 Views
    Favorites 12 Views
    Favorites 12 Views
  • Public
    Tableau -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    Original post: https://nikkiyu.co/2017/06/21/how-to-create-a-yoy-line-graph-in-tableau/ Line graph is simple, neat and one of the most popular charts that I use in my work. Today, I want to create a line graph to compare daily revenue with the same day last year. The challenge is that Tableau does not have Month/Day date format. See below: I have been tried several ways. Now, I will show you the simplest way, which are only two steps. Step 1: Create a Month/Day field. This is actually not a date, but a string. Step 2: Drag Month/Day to Columns shelf, and Revenue (anything you want to compare) to Rows shelf. Graph type should be Line. Then drag YEAR(Date) to Color. It is basically done! Really simple huh?! This method also take care of 2/29/2016. You may see a gap between 2/28/2017 and 3/1/2017 because 2017 does not have 2/29. This is what we expect to see. Some people use Lookup function, which may have issue when we have different number of days between two years. For this graph in my work, we show year over year average based on rolling 7 day average, which uses a table calculation. I will show you how to do it by two steps as well. Step 1: Right click the field on Rows shelf, then select Add Table Calculation. Step 2: The Calculation Type is Moving Calculation. Summarize values using Average. Previous values should be 6 and next values should be 0 because I need rolling 7 days. Compute using Table (across) based on Month/Day because Month/Day is on Columns shelf. One more thing: by doing this, the line graph will show up until 6/26/2017 (Today is 6/21/2017) due to moving 7 days average table calculation. I would like to show data until yesterday (6/20/2017). We can use a Lookup function to control the end date. Drag Lookup Date function to Filters shelf. Select True. Then the line graph will be: Now, revenue year over year trend by rolling 7 day average is done!
    Favorites 13 Views
    Favorites 13 Views
    Favorites 13 Views
  • Public
    Site Feature -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    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.
    Favorites Views
    Favorites Views
    Favorites Views
  • Public
    Tableau -Oct 26, 2017
    by - Oct 26, 2017
    - Oct 26, 2017
    Posted by - Oct 26, 2017
    Original Post: https://nikkiyu.co/2017/07/05/how-to-create-a-stacked-bar-chart-that-adds-up-to-100-in-tableau/ Bar chart is probably one of the simplest charts that every data analyst uses all the time. It is simple but very effective. I am working on a web traffic report, which needs to compare website visits by device category (desktop, mobile and tablet) over time. I think a stacked bar chart could be applied to this case. Instead of comparing total number of visits, I care more about the percentage of visits by device category. Today, I will show you how to create a stacked bar chart that adds up to 100% in Tableau. Step 1. Drag Date to column shelf. Make sure you choose Discrete Exact Date by right clicking Date on column shelf. Step 2. Drag Visits to row shelf. Graph type is Bar. Step 3. Drag Device Category to Color. Step 4. Instead of showing total visits comparison, I would like to present % of visits per device every day. Right click Sum(Visits) on Row shelf, then click Add Table Calculation. Calculation Type is Percentage of Total and Computing Using is Table (down). Step 5. Command (or Ctrl) + drag Sum(Visits) table calculation to Label mark in order to show the percentage of total visits per device on the stacked bar graph. It is done! The key to create a stacked bar chart that adds up to 100% is the usage of table calculation. Tableau provides powerful functions of table calculations and window calculations. I will show you more in my next blogs. https://nikkiyu.co/2017/07/05/how-to-create-a-stacked-bar-chart-that-adds-up-to-100-in-tableau/
    Favorites 16 Views
    Favorites 16 Views
    Favorites 16 Views