Migrating from Tableau to Power BI

[amitchandak]

Introduction

In the ever-changing world of business intelligence and analytics, it is very common that you might have to shift from one BI tool to another.

Tableau is one of the leading business intelligence tools with amazing visualization.

Power BI is also a leading business intelligence tool with huge options for data preparation, modeling, and complex solutions.

You might come across a situation where you might have to migrate to Power BI from Tableau.
From my experience, I am listing down things you need to unlearn from Tableau and learn/ relearn in PowerBI during this migration process

Unlearn
1. Table Calculations
2. Level of Details
3. one Sheet/page, One visual
4. Meaning of Dashboard
5. Custom Tooltips/ ToolTip Page
6. Dual Axis with Any Visual
7. Dynamic Axis using column
8. Text Parameter
9. Matrix of visuals (Add additional rows and columns and make Matrix of the visual)
10. Filter Context
11. Slicer Interaction in dashboard

Learn
1. Data Model with power query
2. Need for Star Schema
3. Date Table
4. How to use in-memory tables — can be used of LOD
5. Row Context, how you match current value with complete data to the dataset for that column — Can be used LOD, subtotal, grand total
6. Small Multiples
7. Bookmarks, Dynamic M Parameter — For Dynamic axis
8. Use of Independent Table
9. How Power bi filter works
10. Small Multiples
11. Tooltip Page
12. Sync Slicer in Report
13. Report is as good as dashboard
14. Power BI Service dashboard

Important Links
Download Power BI: https://www.microsoft.com/en-us/download/details.aspx?id=58494
Tableau: https://www.tableau.com/products/desktop/download

Register

Power BI: https://powerbi.microsoft.com/en-us/get-started/

Tableau: https://id.tableau.com/register?clientId=ecQVCrwX7MGfJ1FC9JvfjjHt0TfxRTYT

Important Link Power BI: https://community.powerbi.com/t5/Community-Blog/Important-Links-every-Power-BI-enthusiastic-should-b...

Source File Location: https://github.com/amitchandakpbi/powerbi/blob/main/Sales%20Data%20Used%20in%20Video.xlsx

To help you further in detail, I have created a playlist — “TABLEAU vs POWERBI” of 24 videos covering a few topics and comparisons between the two. Check out the videos! I will be awaiting your responses.

Series Link- https://www.youtube.com/playlist?list=PLPaNVDMhUXGYzjFASXjdY7GNoFxvlkR54

1. Getting Started & Data Loading

2. Calculated Field/ Calculated Column

3. Measure

4. Bar/Clustered Bar

5. Table Visual

6. Matrix

7. Pie Visual

8. Stacked Visual

9. TreeMap Visual

10. Quick Calculations/Measures

11. LOD- FIXED (Level of Details)

12. LOD Include (Level Of Details)

13. LOD exclude (Level of Details)

14. Parameter/What if Parameter

15. MAP Visual

16. Scatter Visual

17. Time Intelligence

18. Animations

19. Measure Slicer

20. Axis Slicer

21. Tableau Vs Power BI- Chapter 21: Tableau ATTR

22. Tableau Vs Power BI- Chapter 22: Makedate/Date, Today, Dateadd and datediff

23. Tableau Vs Power BI- Chapter 23: How to create groups

24. Tableau Vs Power BI- Chapter 24: Rank - Dense Rank

So what is your list of unlearning and relearning topics, when you migrate from Tableau to Power BI? Please do share your experience and struggles in the comments section.

Click Here to access all my blogs and videos in a jiffy via an exclusive visual glossary using Power BI.

Please like, share, and comment on these. Your suggestions on improvement, challenges, and new topics will help me explore more.
You Can watch my Power BI Tutorial Series on My Channel, Subscribe, Like, and share

Get the Source file to work on - Here