BI Concepts | Analytics Advisory
  • Home
  • Services
    • Modern Data Platform
    • Data Services
    • Marketing Analytics
    • Tableau Starter
    • Tableau Licences
    • Tableau Hosting
    • Tech Stack
  • Trainings & Events
    • Tableau Desktop Fundamentals
    • Tableau Desktop Intermediate
    • Tableau Desktop Advanced
    • Tableau Prep
    • Events
  • Meet the Team
  • Get in touch
  • BI Blog

Blog about BI quarrels.

Tableau and the cube - an unholy marriage

30/10/2019

0 Comments

 
Starting in May 2019 I got an assignment in an international institution in Basel. They were hiring tableau devs and I wanted to focus my career more towards business intelligence. Since I think people should interpret with their domain knowledge, not wasting time struggling to get high quality data sets together. In the interviews I was warned that there is certain limitations with tableau working with cubes.

And my dear, yes there are. You cannot create calculated fields with dimensions. It is hard to browse through the underlaying data in the cube since tableau can only show field names and other attributes of these fields except the content. That is why we use Excel or SSMS (SQL Server Management Studio).

What's new then with a cube? Although you are limited with the calculated fields, you are able to compensate with a feature called calculated member. This MDX operated calculated field is more powerful and can also work with dimensions. This allows you to group dimensions or rename/give them an alias. Which is not working in a cube environment.

But there is hope, the experience will not be great but there is some tips and tricks I will provide in this blog. Soon more to come.

0 Comments

    Categories

    All
    Automation
    Data Analytics
    Data Culture
    Data Sharing
    Data Visualisation
    Digital Transformation
    Google Analytics 4
    Master Data Management
    Snowpipe
    Technology Stack

    Archives

    March 2023
    December 2022
    September 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    September 2021
    July 2021
    October 2019

    RSS Feed


    Subscribe to our newsletter

BI Concepts GmbH
Deuberrainweg 6
8807 Freienbach
Switzerland

Swiss Commercial Register Entry
VAT No (UID): CHE-434.247.552
(founded in 2020)
  • Home
  • Services
    • Modern Data Platform
    • Data Services
    • Marketing Analytics
    • Tableau Starter
    • Tableau Licences
    • Tableau Hosting
    • Tech Stack
  • Trainings & Events
    • Tableau Desktop Fundamentals
    • Tableau Desktop Intermediate
    • Tableau Desktop Advanced
    • Tableau Prep
    • Events
  • Meet the Team
  • Get in touch
  • BI Blog