Tableau vs Power BI comparison - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a calculated field in Tableau that sums sales.

Tableau

SUM([1])

Drag options to blanks, or click blank then click option'

ADiscount

BProfit

CQuantity

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using a field other than Sales, like Profit or Quantity.

The SUM function in Tableau adds up all values in the specified field. Here, we sum the 'Sales' field.

2fill in blank

medium

Complete the code to filter data in Tableau to show only records where Profit is positive.

Tableau

[Profit] [1] 0

Drag options to blanks, or click blank then click option'

A<

B=

C>

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' or '=' which would not select positive profits.

To filter for positive profits, use the greater than operator '>'.

3fill in blank

hard

Fix the error in this Tableau LOD expression to calculate total sales per region.

Tableau

{FIXED [Region]: SUM([1])}

Drag options to blanks, or click blank then click option'

AQuantity

BSales

CProfit

DDiscount

Attempts:

3 left

💡 Hint

Common Mistakes

Using Profit or Quantity instead of Sales.

The LOD expression fixes the calculation by region summing the 'Sales' field.

4fill in blank

hard

Fill both blanks to create a calculated field that shows average profit per category only for profits above zero.

Tableau

IF [Profit] [1] 0 THEN AVG([2]) END

Drag options to blanks, or click blank then click option'

A>

BProfit

CSales

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' or averaging Sales instead of Profit.

The IF condition filters profits greater than zero, then calculates average profit.

5fill in blank

hard

Fill all three blanks to create a calculated field that returns 'High' if sales exceed 10000, 'Medium' if sales are between 5000 and 10000, else 'Low'.

Tableau

IF [Sales] [1] 10000 THEN 'High' ELSEIF [Sales] [2] 5000 AND [Sales] [3] 10000 THEN 'Medium' ELSE 'Low' END

Drag options to blanks, or click blank then click option'

A>

B<=

C>=

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up comparison operators or incorrect logical conditions.

The first condition checks if sales are greater than 10000 for 'High'. The second checks if sales are greater than or equal to 5000 and less than or equal to 10000 for 'Medium'. Otherwise, it returns 'Low'.

Practice

1. Which tool is known for its strong integration with Microsoft products like Excel and Azure?

easy

A. Power BI

B. Tableau

C. QlikView

D. Looker

Solution

1. Step 1: Identify Microsoft integration features

   Power BI is developed by Microsoft and integrates well with Excel, Azure, and other Microsoft services.

2. Step 2: Compare with Tableau

   Tableau is more focused on visual exploration and is vendor-neutral, so it lacks deep Microsoft integration.

3. Final Answer:

   Power BI -> Option A

4. Quick Check:

   Microsoft integration = Power BI [OK]

Hint: Microsoft tools pair best with Power BI [OK]

Common Mistakes:

• Confusing Tableau's visual strength with Microsoft integration
• Choosing other BI tools not in the comparison
• Assuming all BI tools have equal Microsoft support

2. Which of the following is the correct way to describe Tableau's primary strength?

easy

A. Built-in AI and machine learning models

B. Strong visual exploration and flexibility

C. Free and open-source software

D. Exclusive to Windows operating system

Solution

1. Step 1: Understand Tableau's focus

   Tableau is known for its powerful visual exploration capabilities and flexibility in creating interactive dashboards.

2. Step 2: Eliminate incorrect options

   Tableau is not free or open-source, does not focus primarily on built-in AI, and runs on multiple OS including Mac.

3. Final Answer:

   Strong visual exploration and flexibility -> Option B

4. Quick Check:

   Tableau strength = Visual exploration [OK]

Hint: Tableau = Visual exploration and flexibility [OK]

Common Mistakes:

• Thinking Tableau is free or open-source
• Confusing AI features with Power BI
• Assuming Tableau only runs on Windows

3. If a company wants to create a dashboard with deep integration to Microsoft Excel and publish reports quickly with minimal cost, which tool is likely to produce the best result?

medium

A. Power BI, because it integrates well with Excel and is cost-effective

B. Power BI, because it is open-source and free

C. Tableau, because it supports more data sources

D. Tableau, because it has better visual customization

Solution

1. Step 1: Analyze integration and cost needs

   The company needs strong Excel integration and low cost, which points to Power BI.

2. Step 2: Evaluate options

   Power BI integrates deeply with Excel and offers affordable licensing; Tableau is more expensive and less integrated with Microsoft tools.

3. Final Answer:

   Power BI, because it integrates well with Excel and is cost-effective -> Option A

4. Quick Check:

   Excel integration + cost = Power BI [OK]

Hint: Excel + low cost = Power BI [OK]

Common Mistakes:

• Choosing Tableau for cost reasons
• Assuming Tableau is free or cheaper
• Ignoring integration importance

4. A user tries to connect Power BI to a non-Microsoft cloud data source but finds limited native connectors. What is the likely cause and best fix?

medium

A. Power BI does not support cloud data sources; switch to Tableau

B. Power BI requires a paid license to connect to any cloud data source

C. Power BI has limited connectors outside Microsoft ecosystem; use custom connectors or APIs

D. Power BI only supports Excel files; convert data to Excel first

Solution

1. Step 1: Identify connector limitations

   Power BI has many connectors but fewer native ones for non-Microsoft clouds compared to Tableau.

2. Step 2: Recommend workaround

   Using custom connectors or APIs can extend Power BI's connectivity to other cloud sources.

3. Final Answer:

   Power BI has limited connectors outside Microsoft ecosystem; use custom connectors or APIs -> Option C

4. Quick Check:

   Connector limits fixed by custom APIs [OK]

Hint: Use custom connectors for non-Microsoft clouds in Power BI [OK]

Common Mistakes:

• Thinking Power BI cannot connect to cloud data
• Believing all connectors require paid license
• Assuming Power BI only supports Excel

5. A business wants to create highly interactive dashboards with complex visualizations and share them with users who do not have Microsoft licenses. Which tool is better suited and why?

hard

A. Power BI, because it offers free sharing without licenses

B. Power BI, because it has more visualization options

C. Tableau, because it is free for all users

D. Tableau, because it excels in visual exploration and sharing without Microsoft dependency

Solution

1. Step 1: Understand sharing and visualization needs

   The business needs complex visuals and sharing without requiring Microsoft licenses for users.

2. Step 2: Compare tool capabilities

   Tableau offers advanced visual exploration and allows sharing dashboards without Microsoft license restrictions; Power BI sharing often requires licenses.

3. Final Answer:

   Tableau, because it excels in visual exploration and sharing without Microsoft dependency -> Option D

4. Quick Check:

   Interactive visuals + license-free sharing = Tableau [OK]

Hint: For complex visuals and license-free sharing, choose Tableau [OK]

Common Mistakes:

• Assuming Power BI sharing is free for all users
• Confusing visualization capabilities
• Thinking Tableau is free software