tag:blogger.com,1999:blog-5793476743615764134Fri, 13 Feb 2026 23:22:52 +0000Tableau Softwaredata visualizationstutorialsMoscowinternetthe worldQGISdemographics profileRussian regionsdata handicraftreal estatedeathsocial networksthe CISthe NetherlandsТуториалFacebookKazakhstanPetersburgalcoholcrimeenergyfoodnatural gasrankingswomenAzerbaijanRussian languagebusinesscorruptioninvestmentmapmarriagemilitarynot seriously:)trafficOn this blog I publish charts, maps, data visualizations and provide links to interesting sources of data around the web. I am interested in Russia and the CIShttp://russiansphinx.blogspot.com/noreply@blogger.com (Russian Sphinx)Blogger112125tag:blogger.com,1999:blog-5793476743615764134.post-4956664294505514188Fri, 11 May 2018 20:38:00 +00002018-05-11T13:42:03.012-07:00<!--[if gte mso 9]> <![endif]--><!--[if gte mso 9]> Normal 0 21 false false false DE X-NONE X-NONE <![endif]--><!--[if gte mso 9]> http://russiansphinx.blogspot.com/2018/05/talend-data-preparation-tutorial-part-1.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-2659426622028923013Fri, 11 Dec 2015 18:08:00 +00002015-12-14T08:54:49.082-08:00data visualizations Ich habe Daten über in Deutschland ansässige Ausländer gefunden. Solche Daten gibt es schon seit langer Zeit, denn Deutschland hat mindestens seit dem Mittelalter das „Meldewesen“:&nbsp;&nbsp;alle müssen sich in der Stadt, in der sie wohnen, melden, auch die Deutschen – einfach so vor sich hin leben geht nicht! Aus diesen Daten habe ich eine Visualisierung gebastelt. Vieles daran kann man sich http://russiansphinx.blogspot.com/2015/12/auslander-in-deutschland.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-3663056585771654984Sun, 22 Mar 2015 18:04:00 +00002015-03-22T11:04:50.799-07:00data visualizationsEurostat has published statistics on renewable energy sources in the European Union. Below my data visualization showing how countries are dealing with their energy targets. http://russiansphinx.blogspot.com/2015/03/energy-from-renewable-sources-in-eu.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-8068093130910021784Mon, 09 Mar 2015 14:02:00 +00002015-03-09T07:02:58.944-07:00You don't need any geo software to produce a map, a cupboard is perfectly enough. Some time ago I've found in museum of Haus der Geschichte in Bonn this map of German local food specialties. The map is fully interactive, you can open each part to check what is inside. No computer, no programming involved and a nice interactive map was created. (You can click on the photos to enlarge them, yes http://russiansphinx.blogspot.com/2015/03/german-food-mapped.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-354525105145940147Fri, 16 Jan 2015 10:29:00 +00002015-01-16T03:07:51.517-08:00tutorials Extracting data from PDF There are plenty of people who strongly believe that the best place for their data is PDF, everyone does it, statistical offices, international organizations. There is only one reason behind it, their pleasure, yes they find it pleasurable to imagine people who try to extract their data from PDF. OK the reality is a bit different the format was created to present http://russiansphinx.blogspot.com/2015/01/free-data-journalism-tools-data.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-10979228090728992Wed, 10 Dec 2014 11:24:00 +00002014-12-10T03:25:07.851-08:00This post starts series of posts with free tools for data journalism. To make everything clear, I have nothing against paid apps but I just wanted to show that having strong willingness to work with data and no budget is enough to build a working place for a data journalist / yourself / data blogger / student / random person who likes data. In more romantic words, love for data is everything, youhttp://russiansphinx.blogspot.com/2014/12/free-data-journalism-tools-time-lines.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-8771748695556196285Tue, 09 Dec 2014 13:10:00 +00002014-12-09T05:12:20.892-08:00tutorialsYou can use KML files to store routes of your trips, bird migration, geographical discoveries or whatever you want. Later you can use KML files to present created geo data in Google Fusion Tables. // Please select&nbsp;Settings&nbsp;=&gt;&nbsp;Quality&nbsp;=&gt;&nbsp;720p&nbsp;HD&nbsp;and&nbsp;Full Screen&nbsp;at the bottom of the youtube film for your own comfort and mental stability, http://russiansphinx.blogspot.com/2014/12/creating-and-saving-path-as-kml-file-in.htmlnoreply@blogger.com (Russian Sphinx)1tag:blogger.com,1999:blog-5793476743615764134.post-2368103650962658472Wed, 03 Dec 2014 13:36:00 +00002014-12-04T05:01:25.194-08:00QGIStutorials You can use KML files to create maps in Google Fusion Tables.&nbsp; Comments to the tutorial: I keep everything in folders, it's not a must but when you have a few polygons or lines or points it's easier to keep order. I segregate everything by type, so for example polygons and points are never in the same folder, I do this just in case if I wanted to export KML to shape file. This tutorial http://russiansphinx.blogspot.com/2014/12/how-to-create-kml-file-to-store-your.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-7399634688778620677Tue, 25 Nov 2014 18:36:00 +00002014-11-25T10:36:39.188-08:00QGIStutorialsIt's a list from my perspective, I work mainly with geo data for Europe and Asian post Soviet Union countries. I wanted to keep all my sources in one place so I started this list, which I am planning to update when I find something interesting. I focus on open source shape files. If you came across a website with shape files and you want to share it with me, it will be the happiest day of my http://russiansphinx.blogspot.com/2014/11/shape-file-directory.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-9182795127125327775Tue, 18 Nov 2014 13:14:00 +00002014-11-18T05:30:16.862-08:00data visualizationsmapПортал открытых данных правительства Москвы опубликовал географические координаты московских велодорожек. Общая длина велодорожек состоит 111 км. Самая длинная велодорожка находится в парке «Лосиный Остров». Я хотела сделать карту поинтереснее и добавить другие данные к велосипедным геоданным, но не нашла ничего подходящего. На моей карте можно включить Street View чтобы увидеть фотографии. ===http://russiansphinx.blogspot.com/2014/11/cycle-lanes-of-moscow.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-837915551861574855Mon, 17 Nov 2014 09:09:00 +00002014-11-17T01:17:17.556-08:00tutorialsData Wrangler is a hero of this tutorial. It's free online tool to transform data. There are three reasons why it's worth to use Data Wrangler: it's very easy to use although it's simple it offers many useful functions the app's done by nice people The app has limitations, Wrangler only supports up to 40 columns and 1000 rows. If you are planning to work with something bigger than that, then http://russiansphinx.blogspot.com/2014/11/reshaping-data-in-data-wrangler.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-60416153120937014Mon, 10 Nov 2014 13:14:00 +00002014-11-10T10:30:46.302-08:00data visualizations I'm totally addicted to archaeological documentaries. My favourite archaeological site is Göbekli Tepe, google it, it's just WOW. In July 2014 Klaus Schmidt, who headed the excavations at the site, passed away. I started to thinking about doing something in this field. I wanted to analyse some data devoted to Göbekli Tepe, but I couldn't find anything. Archaeological data published in the http://russiansphinx.blogspot.com/2014/11/something-old-something-new.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-4574048873111111914Thu, 06 Nov 2014 15:38:00 +00002014-11-06T09:42:22.592-08:00QGIStutorials First you have to install SimpliPy Note that the plug-in says: You must have installed Shapely 1.2.18 or you will get an error installing or using this plug-in. Shapely is open source. ============================================== Here you can learn what&nbsp;simplifying geometries of shape files is. ============================================== SimpliPy was successfully http://russiansphinx.blogspot.com/2014/11/simplifying-geometries-of-polygon-shape.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-1315095691120234116Wed, 05 Nov 2014 08:40:00 +00002014-11-12T13:49:24.563-08:00data visualizations I was playing with population data but I wanted to do something different so I took into account data for a long period. I prepared population comparator, a tool to compare how the growth of population proceed in countries. Don't get wild and don't select too many countries as it will be impossible to see anything. The biggest growth of the population was caused by discovering oil. http://russiansphinx.blogspot.com/2014/11/how-world-has-changed-from-1960.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-397222433656580641Tue, 28 Oct 2014 14:20:00 +00002014-11-17T06:09:45.449-08:00data visualizationsI've done a cycling map of London. Not everything was as I planned. I was searching for a line shape file of the London's cycle lanes, as logical would be adding length of cycle lanes per ward or any data set saying about an average commuting distance to work. I asked Transport for London and a few cycling organizations based in London for the shape file but nobody was able to help me. There'shttp://russiansphinx.blogspot.com/2014/10/cycling-in-london.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-600680912519168060Fri, 24 Oct 2014 11:34:00 +00002014-10-24T04:34:22.426-07:00QGIStutorials If your map works very slowly and you have to wait for a respond for a loooooooooong time, it's a clear sign that you need to simplify the geometries of the shape files. Polygons are drawn by joining vertices by lines. Simplifying them means getting rid of some vertices. As you can see on the image, it slightly changes shape of the polygon. Many shape files consists of big http://russiansphinx.blogspot.com/2014/10/simplifying-geometries-of-polygon-shape_24.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-5439412829548943905Mon, 20 Oct 2014 16:57:00 +00002014-10-20T09:57:22.506-07:00QGIStutorials A point shape file in QGIS looks like this: This tutorial can't be used for a line shape file or... ...polygon one. Open your shape file in QGIS: Right click on layer and select Open Attribute Table... Enable editing. Open the field calculator by clicking on the icon with an abacus :) Double-click on the $x in&nbsp;Geometry&nbsp;and give a name to thehttp://russiansphinx.blogspot.com/2014/10/how-to-export-point-shape-file-to-csv.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-7581787387701661906Fri, 08 Aug 2014 10:15:00 +00002014-08-08T03:15:26.359-07:00tutorialsThere're new maps in Tableau 8.2. Now you can choose between Tableau (the new maps) and Tableau Classic (the old ones, not medieval maps but just from 8.1 version). You switch between the two options here: Enter Map Options to get a variety of choices that will blow your mind (hmmm not so many but still useful and worth checking). Tick the Streets and Highways box. Compare the maps http://russiansphinx.blogspot.com/2014/08/maps-in-tableau-82-street-level.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-3015702124984905568Wed, 06 Aug 2014 20:14:00 +00002014-08-06T13:14:51.910-07:00Feel free to use this template in your Tableau projects, just remember about placing the information about the owner of the original shape file. You can check&nbsp;Tableau template for London wards too. Learn About Tableau http://russiansphinx.blogspot.com/2014/08/tableau-mapping-template-for-london_6.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-2778233192508516672Wed, 06 Aug 2014 20:01:00 +00002014-08-07T05:18:53.306-07:00If you've searched for a Tableau mapping template for London, you can stop googling :) If you need other templates for the UK, you should check&nbsp;http://tableaumapping.bi Tableau Mapping is a website where Tableau users share their maps created from open shape files, feel free to join them. Situation with shape files is complex as only in some countries the Statistics Offices publish them forhttp://russiansphinx.blogspot.com/2014/08/tableau-mapping-template-for-london.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-4446067991847488052Thu, 26 Jun 2014 16:43:00 +00002014-06-26T09:44:10.807-07:00tutorials The official name of this tooltip's the ubertip, but the devil's tooltip shows its real nature. Ubertips appear after clicking on row or column headers, when clicking on a mark or data item in the view, they don't appear. Let's analyse this example. After clicking on the text in the heading, the tooltip pops up. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &http://russiansphinx.blogspot.com/2014/06/devils-tooltip-ubertip-in-tableau.htmlnoreply@blogger.com (Russian Sphinx)2tag:blogger.com,1999:blog-5793476743615764134.post-923368159553314729Sun, 15 Jun 2014 10:23:00 +00002014-12-10T04:30:06.887-08:00tutorials Maps should be simple, simple to make and simple to use. I simplify shape files to use them in Tableau but you can use them in other apps too. Why should you do this? Speaking in simple words Tableau draws maps by joining nodes with lines in order given by ShapeToTab. If there are many nodes Tableau has to work harder and performs slower. Besides that it is a great way of spending freehttp://russiansphinx.blogspot.com/2014/06/simplifying-shapefiles-in-mapshaper.htmlnoreply@blogger.com (Russian Sphinx)2tag:blogger.com,1999:blog-5793476743615764134.post-1176552204996367388Wed, 11 Jun 2014 20:28:00 +00002014-06-11T13:29:46.926-07:00 I am planning to add a few posts about data in the real world, yes life and data also exist outside the internet. I have no idea how I will achieve this as I do not go out so often. Keep your fingers crossed :)&nbsp; If you are into a data analysis, you have argued with your data more than once. Pieces of data software have made you crazy. Be honest, you have insulted Excel or any other http://russiansphinx.blogspot.com/2014/06/arithmeum-part-1.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-5408688984408335557Wed, 11 Jun 2014 19:02:00 +00002014-06-11T12:03:39.599-07:00 Если тебе интересна эта тема тоже стоит посмотреть эту визуализацию данных. Я сравнила данные с переписи населения 2010 года с 1926 годом. English version is here.&nbsp; Learn About Tableau http://russiansphinx.blogspot.com/2014/06/blog-post_11.htmlnoreply@blogger.com (Russian Sphinx)0tag:blogger.com,1999:blog-5793476743615764134.post-7880015946745410496Sun, 25 May 2014 17:38:00 +00002014-06-11T11:29:45.415-07:00 I've decided to spend one week living on the edge of poverty to get the data for the Tableau's Quantified Self Viz Contest. My food budget was $2.35 per day (it's calculated by government organization), I stayed in Poland so prices are from there. Learn About Tableau It's impossible to create a good diet with such budget and any social campaignes promoting healthy food wouldn't http://russiansphinx.blogspot.com/2014/05/poor-diet.htmlnoreply@blogger.com (Russian Sphinx)0