{ "version": "https:\/\/jsonfeed.org\/version\/1", "title": "LEFT JOIN: blog on analytics, visualisation & data science, posts tagged: tableau", "home_page_url": "https:\/\/en.leftjoin.ru\/tags\/tableau\/", "feed_url": "https:\/\/en.leftjoin.ru\/tags\/tableau\/json\/", "icon": "https:\/\/en.leftjoin.ru\/user\/userpic@2x.jpg", "author": { "name": "Nikolay Valiotti", "url": "https:\/\/en.leftjoin.ru\/", "avatar": "https:\/\/en.leftjoin.ru\/user\/userpic@2x.jpg" }, "items": [ { "id": "56", "url": "https:\/\/en.leftjoin.ru\/all\/comparing-tableau-and-powerbi-training-programs\/", "title": "Comparing Tableau and PowerBI training programs", "content_html": "

This year I succeeded in becoming a Tableau Desktop Certified Associate. When I was thinking about how to prepare for the exam, I came across e-learning<\/a> courses from Tableau that turned out to be free for 90 days.<\/p>\n

I decided not to waste such an opportunity and complete all the 3 modules in Fundamentals at a fast pace. When I got certified, I was wondering which programs are offered by other producers of BI tools. First things first, I decided to study training materials on PowerBI. In this small article, I would like to compare Tableau and PowerBI training programs.<\/p>\n

Disclaimer: in the end, I have formed an unfairly prejudiced and positive attitude towards Tableau, so PowerBI supporters may not like this article and find it biased (in all fairness, there are also words of praise for PowerBI).<\/p>\n

After having studied the training materials, I can finally state the reasons why I am definitely in favor of Tableau as a tool for data analysis and visualization.<\/p>\n

First of all, there is a huge gap in the approach to materials and the assessment of their understanding. Although Tableau training materials are more technical and pay less attention to design, by studying through their videos you can do excellent visualization. After completing all three steps of Tableau training, a strong desire to create new stunning reports with the use of LOD Expressions, Filter Actions, and make convenient interfaces arises. However, after watching all the materials on Power BI the only question that remains is why did I waste my time?<\/p>\n

Emotions aside, there are several key points that turned out to be important after having studied the material.<\/p>\n

\n\"\"\n
This is a good dashboard according to Microsoft<\/div>\n<\/div>\n

The quality of content and training examples<\/h2>\n

If you consider the way training videos are presented in Tableau and the questions in a quiz format that are posed at the end of the covered material, you start understanding the idea of the software. But in the case of Power BI, you will be totally disappointed. Have a look for instance at the material for identifying outliers<\/a>, here Microsoft suggests building a scatter plot and visually identifying all the outliers.<\/p>\n

Design of reports and dashboards<\/h2>\n

There is some objective criticism towards Tableau training materials on the topic of graph design and control elements, but they are still neatly and beautifully made. Now have a look at the dreadful thing<\/a> that Microsoft suggests as the result of the analyst’s work. And this is a well-built dashboard<\/a> according to Microsoft.<\/p>\n

Assessment of the knowledge gained during the training<\/h2>\n

During the training at Tableau, immediately after a small lecture, you learn by applying the part of the studied material in practice. You need to click certain buttons in the interface to solve a problem. Power BI offers “labs” that are supposed to be launched from a remote machine. I didn’t manage to start a single lab; I wrote to the support 3 times and the support couldn’t solve my problem so I didn’t manage to experiment over the PowerBI tasks.<\/p>\n

\n\"\"\n
The results of the analyst’s work according to Microsoft.<\/div>\n<\/div>\n

Other points are mostly related to the software rather than the training program.<\/p>\n

Cross-platform support<\/h2>\n

I have been working with Tableau for a long time and 4 years ago I switched to Mac. After the transition from Windows, my experience of using Tableau did not change. In fact, Tableau was developing and I was developing with it, but the team did not change the key elements of the interface. I have been experimenting with building reports in PowerBI, but I was uncomfortable with different Microsoft archaisms like publications through some share-portal where you need to have an MS account and configure something through the administrator. All of this was a terrible headache.<\/p>\n

However, what struck me so much was that I could not use PowerBI on a Mac. There is absolutely no way and this is a principled stance of Microsoft which is not expected to change in the future. From my point of view, such software belongs to a B2B segment in the field of analytics, assumes the connection to all kinds of DBMS, but denies the existence of an alternative operating system which could be used by a number of potential consultants that could use and promote PowerBI as an analytical tool.<\/p>\n

Most certainly, there are some rational reasons why any software from Microsoft doesn’t work very well on Mac, but the simple truth is that for me the software remains inaccessible. Nevertheless, I wasn’t looking for an easy way out and installed PowerBI through Parallels in order to honestly consider the tools again taking into account the training materials.<\/p>\n

Visualization options<\/h2>\n

Both Tableau and PowerBI offer stunning visualization options. In fact, in this regard, PowerBI offers a video with a little more information<\/a> than usual. So, on this matter, the tools are presented equally well.<\/p>\n

Functionality<\/h2>\n

Here I want to give credits to the functionality of PowerBI. In fact, the variety of tools is extremely wide even without connecting third party libraries. For example, automatic clustering<\/a>, decomposition tree<\/a>, data profiler<\/a> and setting filters on a graph<\/a>.<\/p>\n

Internal language syntax<\/h2>\n

To work with PowerBI you need to learn DAX. It is not a programming language, but a functional language. You won’t be able to write your own code, however, you won’t even need it – all the functions are already implemented, so you should only learn how to use them. Microsoft tells about DAX quite well in the manual<\/a>. Definition of a new measure in DAX looks like this:<\/p>\n

Revenue YoY % =\r\nDIVIDE(\r\n\t[Revenue]\r\n\t\t- CALCULATE(\r\n\t\t\t[Revenue],\r\n\t\t\tSAMEPERIODLASTYEAR('Date'[Date])\r\n\t),\r\n\tCALCULATE(\r\n\t\t[Revenue],\r\n\t\tSAMEPERIODLASTYEAR('Date'[Date])\r\n\t)\r\n)<\/code><\/pre>
Preparing data for the analysis<\/h2>\n
Inside PowerBI there is a Unpivot<\/a> feature that allows bringing the data in columns with time periods into the form that is convenient to use in pivot tables.<\/p>\n
\n
\n\"\"\n\"\"\n<\/div>\n<\/div>\n
However, an ETL tool for data cleaning and wrangling in Tableau Prep also has this feature implemented<\/a>.<\/p>\n
Conclusions:<\/h2>\n
1) The training programs are built in completely different ways, the methodology of immersion into Tableau tools is more elaborate and efficient. There is an opportunity to get practical experience of solving problems and get feedback (albeit automatic).
\n2) Reports and dashboards design in training materials from Microsoft hardly look professional while Tableau’s implementation is much better.
\n3) Knowledge assessment at Microsoft is implemented at the abysmal level (absolutely perfunctory tests like in a bad school) while at Tableau it’s much better implemented, you dive into the problem, think about the answer and solve it.
\n4) Cross-platform support is not PowerBI’s strongest point, however in the case of Tableau it’s an excellent competitive advantage.
\n5) The functionality and capabilities of the tools are certainly at the highest level, and in some points, PowerBI wins.<\/p>\n
Have a look at our dashboard reviews in Tableau<\/a> and other BI tools<\/a>.<\/p>\n",
            "date_published": "2021-04-26T15:58:17+03:00",
            "date_modified": "2021-05-03T14:56:42+03:00",
            "image": "https:\/\/en.leftjoin.ru\/pictures\/1-18-1.png",
            "_date_published_rfc2822": "Mon, 26 Apr 2021 15:58:17 +0300",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "56",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "system\/library\/highlight\/highlight.js",
                    "system\/library\/highlight\/highlight.css",
                    "system\/library\/fotorama\/fotorama.css",
                    "system\/library\/fotorama\/fotorama.js"
                ],
                "og_images": [
                    "https:\/\/en.leftjoin.ru\/pictures\/1-18-1.png",
                    "https:\/\/en.leftjoin.ru\/pictures\/3-16-1.png",
                    "https:\/\/en.leftjoin.ru\/pictures\/02-original-data-ss.png",
                    "https:\/\/en.leftjoin.ru\/pictures\/02-unpivot-ss.png"
                ]
            }
        },
        {
            "id": "54",
            "url": "https:\/\/en.leftjoin.ru\/all\/tableau-dashboard-overview\/",
            "title": "Tableau Dashboard Overview",
            "content_html": "
In the previous article, we focused on the problem statement<\/a>, designed a layout, shared our goal to build a Tableau Dashboard for Superstore dataset<\/a>. The dashboard should provide insights on most profitable regions, products, customer segments and estimate key performance indicators (KPIs) over the past time.<\/p>\n
The data in SuperStore Sales reflect sales and profit of the retail chain in Canada. It includes information about customer orders, refunds, sales and geodata. But we’re mostly interested in sales data, as our main goal is to create an executive dashboard to understand company’s operating margin, find most and least lucrative product categories,  and customer segments.<\/p>\n
So here’s how the dashboard looks like:<\/p>\n
\n
\n\"\"\n\"\"\n<\/div>\n<\/div>\n
All dashboard elements are placed into containers, we can easily resize or change their hierarchy, this enables to optimize the dashboard and make it more mobile\/tablet friendly. We can also filter the data by time periods and choose a specific month and year in the top right corner, and all the charts will be redrawn automatically.<\/p>\n
The next field shows key factoids on the company performance: profit, sales, orders count, average discount, customers and sales per customer. Each of the indicators displays YOY, a statistical measure to evaluate a company’s financial progress over time. If the indicator shows positive change, a green arrow will be added, if negative – red.<\/p>\n
\n\"\"\n<\/div>\n
\n\"\"\n<\/div>\n
Below are two core charts, displaying regions (colored based on profit) and profit dynamics. We can click on a specific one to view its stats in-depth.<\/p>\n
\n\"\"\n<\/div>\n
The green dot on the right chart represents data for a selected month this year, while the blue dot displays the same month last year. When hovering these points you can see a trend line, that facilitates assessing how the company’s doing today.<\/p>\n
Let’s move to the second part,  here we placed company’s products and customers onto 3 charts. The first one, starting from the left, called bar in bar chart, where you can easily explore product efficiency. For instance, Tables is one of the most inefficient categories, with Breford CR4500 that resulted in significant losses.<\/p>\n
\n
\n\"\"\n\"\"\n<\/div>\n
Bar in bar chart implementation<\/div>\n<\/div>\n
Then goes the chart with company’s customers, by default they are sorted in descending order by profitability. The chart is linked with Top Performing Provinces, so if we want to discover best or worst customers for the selected province, the data will be redrawn automatically.<\/p>\n
\n\"\"\n<\/div>\n
\n\"\"\n<\/div>\n
Dashboard Evaluation<\/h2>\n
We evaluated this dashboard according to the criteria below. On a scale of 1 – 10, 10 being the highest, it gets the following scores from our team :<\/p>\n
    \r\n  
  1. Meets the tasks<\/a> – 10,0<\/p><\/li>\r\n  
  2. Learning curve  – 5,5<\/p><\/li>\r\n  
  3. Tool functionality – 9,0<\/p><\/li>\r\n  
  4. Ease of use – 8,5<\/p><\/li>\r\n  
  5. Compliance of the result – 10,0<\/p><\/li>\r\n  
  6. Visual evaluation – 9,7<\/p><\/li>\r\n<\/ol>\n
    This Tableau Dashboard scored 8.8 out of 10 from the team! In our perspective, the dashboard fully meets the requirements and facilitates understanding of business performance over a reporting period. We can assess profit dynamics in general or for the selected region, and effectively leverage products and customers data in measuring monetary results. The final version is available through this link<\/a>.<\/p>\n
    Please let us know your thoughts in the comments down below, how would you rate this dashboard?<\/p>\n",
            "date_published": "2020-11-06T12:07:00+03:00",
            "date_modified": "2020-11-06T12:08:32+03:00",
            "image": "https:\/\/en.leftjoin.ru\/pictures\/1@2x.png.jpg",
            "_date_published_rfc2822": "Fri, 06 Nov 2020 12:07:00 +0300",
            "_rss_guid_is_permalink": "false",
            "_rss_guid": "54",
            "_e2_data": {
                "is_favourite": false,
                "links_required": [
                    "system\/library\/fotorama\/fotorama.css",
                    "system\/library\/fotorama\/fotorama.js",
                    "system\/library\/fotorama\/fotorama.css",
                    "system\/library\/fotorama\/fotorama.js"
                ],
                "og_images": [
                    "https:\/\/en.leftjoin.ru\/pictures\/1@2x.png.jpg",
                    "https:\/\/en.leftjoin.ru\/pictures\/2@2x-3.png.jpg",
                    "https:\/\/en.leftjoin.ru\/pictures\/3@2x-1.png.jpg",
                    "https:\/\/en.leftjoin.ru\/pictures\/31@2x.png",
                    "https:\/\/en.leftjoin.ru\/pictures\/4@2x-1.png.jpg",
                    "https:\/\/en.leftjoin.ru\/pictures\/5@2x-1.png.jpg",
                    "https:\/\/en.leftjoin.ru\/pictures\/recording_6.gif",
                    "https:\/\/en.leftjoin.ru\/pictures\/6_1.png",
                    "https:\/\/en.leftjoin.ru\/pictures\/7@2x-1.png.jpg"
                ]
            }
        },
        {
            "id": "52",
            "url": "https:\/\/en.leftjoin.ru\/all\/animating-sports-data-in-tableau\/",
            "title": "Animating sports data in Tableau",
            "content_html": "
    Previously we shared how to visualize your sports data from the SwingVision app in Tableau<\/a> , using custom background and shapes. This time we are going to animate our dashboard to watch how landing locations of tennis shots changed over the match. Such an animation can be exported into a video file for later use. That’s what our result looked like in Tableau earlier:<\/p>\n