{"id":201,"date":"2023-06-08T16:31:16","date_gmt":"2023-06-08T15:31:16","guid":{"rendered":"https:\/\/zdebla.me\/?p=201"},"modified":"2023-06-18T20:20:27","modified_gmt":"2023-06-18T19:20:27","slug":"choosing-the-right-data-vizualition-application","status":"publish","type":"post","link":"https:\/\/zdebla.me\/index.php\/2023\/06\/08\/choosing-the-right-data-vizualition-application\/","title":{"rendered":"Choosing different data visualition\/BI applications"},"content":{"rendered":"\n

When I first started working with business intelligence applications, I was wondering which one to start with. I did some googling, even asked ChatGTP about it. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

I started with Power BI<\/strong>, as it uses a UI similar to MS Office. I started to really like it, mainly because it used basically the same Power Query <\/strong>interface for data transformation as Excel. PQ remained until now my main tool for data transformation\/cleaning. <\/p>\n\n\n\n

The main reason I stopped using Power BI for visualisations is its pricing model and embedding capabilities. In order to embed <\/strong>a visulisation on a public website, one has to use the Premium <\/strong>version of the application. Another common obstacle is that to even use Power BI Service<\/strong>, the web platform one has to have a business or school email account (I fortunately got it after creating this website and domain).<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Having started with Tableau<\/strong> I got to like it as well, especially the numerous visualisation capabilities. The part I don’t like is how dependant it is it’ s web platform, not having a possibility for a local save.<\/p>\n\n\n\n

The third visualisation\/BI tool I am using the (Google) Looker Studio<\/strong>. It is not feature-heavy but has easy controls and good connectors. It uses a bit different names for the visualisation fields (dimension, metrics ..), which are more constistent with the google data idealogy, but for example what I really like is the “smart grid” which allows smoothing stacking of different visualisations next to each other.<\/p>\n\n\n\n

Getting to the point <\/strong><\/p>\n\n\n\n

Anyhow, what I wanted to say by this article is that using any of these apps is very similar. Professionally it is called “transfarable skills”<\/strong>. Creating visualisation in neither of these is very similar.<\/p>\n\n\n\n

What is important, is the preceding work<\/strong> – sourcing, transforming, cleaning and modeling the data<\/strong>. <\/p>\n\n\n\n

Once one has the dataset and the data model prepared, finishing it in any of these applications is not too different from each other. <\/p>\n\n\n\n

\n\n\n\n

Here is example of preparing the same visualisation in Power BI <\/em>and in Tableau<\/em>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Source of the able below is The Path to Insights: Data Models and Pipelines<\/em>, the second course of the Google Business Intelligence Professional Certificate<\/em><\/p>\n\n\n\n

\n\n\n\n
Tool<\/strong><\/th>Uses<\/strong><\/th><\/tr><\/thead>
Azure Analysis Service (AAS)<\/td>Connect to a variety of data sources. Build in data security protocols. Grant access and assign roles cross-team. Automate basic processes<\/td><\/tr>
CloudSQL<\/td>Connect to existing MySQL, PostgreSQL or SQL Server databasesAutomate basic processes. Integrate with existing apps and Google Cloud services, including BigQuery. Observe database processes and make changes<\/td><\/tr>
Looker Studio<\/td>Visualize data with customizable charts and tables. Connect to a variety of data sourcesShare insights internally with stakeholders and online. Collaborate cross-team to generate reports. Use report templates to speed up your reporting<\/td><\/tr>
Microsoft PowerBI<\/td>Connect to multiple data sources and develop detailed models. Create personalized reports. Use AI to get fast answers using conversational languages. Collaborate cross-team to generate and share insights on Microsoft applications<\/td><\/tr>
Pentaho<\/td>Develop pipelines with a codeless interface. Connect to live data sources for updated reports. Establish connections to an expanded library. Access an integrated data science toolkit<\/td><\/tr>
SSAS SQL Server<\/td>Access and analyze data across multiple online databasesIntegrate with existing Microsoft services including BI and data warehousing tools and SSRS SQL Server. Use built-in reporting tools<\/td><\/tr>
Tableau<\/td>Connect and visualize data quickly. Analyze data without technical programming languages. Connect to a variety of data sources including spreadsheets, databases, and cloud sources. Combine multiple views of the data in intuitive dashboards. Build in live connections with updating data sources<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

When I first started working with business intelligence applications, I was wondering which one to start with. I did some googling, even asked ChatGTP about it. I started with Power BI, as it uses a UI similar to MS Office. I started to really like it, mainly because it used basically the same Power Query […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-201","post","type-post","status-publish","format-standard","hentry","category-articles"],"_links":{"self":[{"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/posts\/201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/comments?post=201"}],"version-history":[{"count":4,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/posts\/201\/revisions"}],"predecessor-version":[{"id":348,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/posts\/201\/revisions\/348"}],"wp:attachment":[{"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/media?parent=201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/categories?post=201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/tags?post=201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}