Best Practices/Steps/Documents to prepare for Migration from QlikView to Looker.

DickyMohanty
Participant III

Hi Team,

We are pretty much new to Looker and starting to explore. 

Can someone here please help with Best Practices/Steps/Documents to prepare for Migration from QlikView to Looker? 

0 2 470
2 REPLIES 2

DickyMohanty
Participant III

Hi Team,

Any possible suggestions here ? 

Dawid
Participant V

There aren’t documents like that. Even though the software is different but in the end is not as much about whether you’re moving from Tableau to Looker, Qlik to Looker, Looker to PowerBi (you still need to understand how they name the same things/features) but more about the data model you have in your data warehouse and how to build it in Looker. 

But that’s more Looker knowledge. I think you need to prepare few things:

  1. What is possible in QlikView but not in Looker (important as your business users may be used to certain things)
  2. Get to know Looker’s limitations (subset of 1.)
  3. LookML - this layer is especially important if you don’t have a good data model. It may make you want to build a Data Model on top of LookML
  4. Start small - migrate few explores of main entities of your table - check the data. Then make data modelling decisions whether you need all the joins, what features of Looker can make the BI experience better

Do not try to migrate everything at once. Start small and open it up to more people for data quality checks and feedback what they need.

Migration is also a great moment to do a lot of clean-up and removing unused fields, tables, joins - my favourite part 😄