Category:

London PUG

LondonPUGDataViz -2

by Prathy Kamasani 12 May 2018

written by Prathy Kamasani

The dataset for the next LondonPUGDataViz is The Newyork time bestseller data from Wikipedia. It looks like only data between 2000 to 2018 years seem better. So it’s up to you, you can go for one year or ten years, your wish!

Dataset:

https://en.wikipedia.org/wiki/Lists_of_The_New_York_Times_Fiction_Best_Sellers

https://en.wikipedia.org/wiki/Lists_of_The_New_York_Times_Non-Fiction_Best_Sellers

When you click on the URL, it gives you the list. If you wish you can use power query to import data from all years or use the model from here https://1drv.ms/f/s!Avm7gbgZtlMlv3B9wc7d5cico0p- which already has Power Query to import data from Wikipedia.

Once you finish, please email your model to Prathy@outlook.com, we will showcase all models at next London Power BI User Group. You can find previous LondonPUGDataViz models here – LondonPUGDataViz

Prathy

12 May 2018 0 comment

#LondonPUGDataViz London PUG LondonPUG

LondonPugDataViz – 1

by Prathy Kamasani 12 May 2018

written by Prathy Kamasani

As some of you already know, we started #LondonPugDataViz at London Power BI User Group for completing two successful years. I am hoping LondonPugDataViz by all of us lead to more success in the years to come.

Thank you Mariusz and Sean for taking part in #LondonPUGDataViz, there were not many submissions, but I am sure it will grow over the time. Here are all submissions:

Dataset: https://github.com/fivethirtyeight/data/blob/master/bob-ross/elements-by-episode.csv

Submission by Mariusz Repczynski:

Submission by Sean Green:

Submission by Prathy Kamasani:

You can download all models here: https://1drv.ms/f/s!Avm7gbgZtlMlv2-1fgdQM6CWw8qh

Hope these models give some inspiration with your storytelling. If you are interested, why don’t you participate in our next one – https://prathy.com/2018/05/londonpugdataviz-2/

Regards,

London PUG

12 May 2018 0 comment

#LondonPUGDataViz London PUG

#LondonPUGDataViz

by Prathy Kamasani 23 April 2018

written by Prathy Kamasani

With inspiration from many DataViz blogs, especially from Story Telling With Data and DataDuo, I thought to start #LondonPUGDataViz. Mainly to encourage interactivity of our User Group. Its been almost two years since we began our User Group, our next event is the Second Anniversary. Since we started, we followed the same format so that this new activity will be something exciting :).

Many of our attendees come to us saying how the Power BI User Group helped them. I am hoping this new activity will help them more. At our last event, many of our User group attendees were excited about this new challenge. So, the plan is every month we come up with an open dataset, and we ask our attendees to create something using Power BI. There are no limitations; Creativity is the limit!

At every event, we dedicate 30 min to showcase these reports. Recently I watched a video related to photography, where they mentioned how working in a group could help each other with the creativity angle. You will be surprised to see how different people shoot the same place with different perspectives and how that perspective entirely transforms the story behind the picture. In the same way, we are hoping this activity will encourage us to learn from each other with their different perspectives of storytelling.

People who know me in person knows that I like painting, maybe because of that, for the very first LondonPUGDataViz, I’ve gone for Bob Ross Paining data set. I promise we go for a more sensible dataset for the next one. Not only because it is related to painting, but it is a small, simple csv. Something simple to start!

I am really hoping people get involved, if anyone out there wants to get involved, here is the dataset – http://bit.ly/LondonPugChallenge1 . I will write a blog post with all submissions, at least there will be mine, and I have few friends whom I am going to push to create some reports 😉

Till next time,

Prathy 🙂

23 April 2018 0 comment