This is great. In my company they are using qlik sense but only for the department of stadistic. And only stadistic release the data to the other sectors from there. I am in marketing so I proposed to use power bi for my sector and they are asking me why I dont use qlik sense. Now I can explain much better the why. Also It is much easier to teach.
Working with both tools I still prefer Qlik. It is easier to modify the data if the structure is not how you want it which is often the case in real life and business situations. If you have proper data solutions, marts in a dwh for example, Power bi can be used for the final visualization but still Wlik seems to be way more powerful
On top of that you have full capacity of building up a whole etl process through different layers and task chaining. In that regard gar ahead of Microsoft
1. To pull the data from external data connections, Is it possible to connect those DB connections in Power BI like Qlik Sense? 2. Is Data Warehousing works in Power BI?
Great video! I have some more queries, does power bi have a QMC kinda feature? and Does Power BI have like qlikNprinting tool? I know Qlik is used for loading millions of data but how big data can be loaded in power bi? Thanks!
Qlik has vast data loading capabilities. I have built Qlik dashboards with 300 million records, and a quick response. Relatively speaking, Power BI has a hard time loading anywhere near that amount of data. And when you start to stress the Power BI data load limit, the performance falls off a cliff. Power BI does have an option where you do not load the data, but instead externally reference the data. This gets past the Power BI data load limit, but the performance is even worse. If you think you will be using large data sets (many millions of records), I would recommend that you avoid Power BI
You can connect to a powerbi dataset (stored in the cloud /pbi service) then connect to another dataset. You are asked to switch to direct query mode. Ok. Then add another dataset and another and another... Then you create the relations among them and upload this dataset (dataset built from datasets) to the cloud (pbi service). Then you can connect to this huge dataset in live mode just as if it was a single, tiny, dataset.
QlikSense is one of the leaders in the BI tools so the adoption is great. However the other leaders like Tableau and Power BI is a tough challenger for QlikSense.
Hi Abishek . considering the cost of maintaining ( Subscription cost ) how costly is Qlik compared to Powerbi. As PowerBi i can manage basic things with 0 Cost to 10$ per month. Is Qlik going to cost more?
Overall good video, but it could have been better. I think you should have done a little more research. The only information useful to me was from 12th minute to 14th minute. You did not talk about ETL Capability and QVD support in Qlik. You can use Extension objects and Mashups in Qlik. The cost of PowerBI License is super cheap. You did not talk any about what DAX, M or anything else does.
Qlik has no-coding tools that let you load data and create a dashboard. To build the most sophisticated solutions, you will want to use coding to load the data in a more controlled manner. Some of the more complex display techniques will require coding-like knowledge to control how data is displayed. For instance, if you want a chart to always show, say, last years financials vs this year's financials, even when filters are selected that would otherwise change the results, then you will need to use some advanced, coding-like techniques to control the display of data.
I do prefer Qlik, but if you are building dashboards with a small amount of data (a few hundred thousand records by maybe a dozen fields or less) then Power BI is a perfectly capable product.
Hello Abhishek. Would you happen to have an email or could I use Facebook Messenger to contact you? I have some questions about both of these platforms and was hoping for some clarity from a seasoned veteran. Thanks.
![Qlik Sense Basic Tutorial for beginners [Complete Tutorial] - Getting started - Part-1-of-10](http://i.ytimg.com/vi/zs24DVVIALU/mqdefault.jpg)
One thing that works in favor of Power BI learning is users who use advanced excel find it easy to adopt to Power BI.
Great suggestion!!!
I am one of those, actually after learning power bi i recognized the power of Excel new features like power query, power pivot and power view)))
OCD kicking in when the points for Power BI started to appear. If you know you know!! Otherwise everything well explained..!! Kudos!!
This is great. In my company they are using qlik sense but only for the department of stadistic. And only stadistic release the data to the other sectors from there. I am in marketing so I proposed to use power bi for my sector and they are asking me why I dont use qlik sense. Now I can explain much better the why. Also It is much easier to teach.
Thank you! Great video! I like the term "data story", I wish I will be able to tell great stories with my data soon!
Working with both tools I still prefer Qlik. It is easier to modify the data if the structure is not how you want it which is often the case in real life and business situations. If you have proper data solutions, marts in a dwh for example, Power bi can be used for the final visualization but still Wlik seems to be way more powerful
On top of that you have full capacity of building up a whole etl process through different layers and task chaining. In that regard gar ahead of Microsoft
1. To pull the data from external data connections, Is it possible to connect those DB connections in Power BI like Qlik Sense?
2. Is Data Warehousing works in Power BI?
What is the future scope of qlick sense
Left out the huge difference in Qliks direct ETL capability that isn't really useable in PowerBI.
Using power query you can do the ETL similar to Qlik and it is integrated in the power bi.
@@AbhishekAgarrwal Yes, but its no where near the same.
Great video! I have some more queries, does power bi have a QMC kinda feature? and Does Power BI have like qlikNprinting tool? I know Qlik is used for loading millions of data but how big data can be loaded in power bi?
Thanks!
Qlik has vast data loading capabilities. I have built Qlik dashboards with 300 million records, and a quick response. Relatively speaking, Power BI has a hard time loading anywhere near that amount of data. And when you start to stress the Power BI data load limit, the performance falls off a cliff. Power BI does have an option where you do not load the data, but instead externally reference the data. This gets past the Power BI data load limit, but the performance is even worse. If you think you will be using large data sets (many millions of records), I would recommend that you avoid Power BI
You can connect to a powerbi dataset (stored in the cloud /pbi service) then connect to another dataset. You are asked to switch to direct query mode. Ok. Then add another dataset and another and another... Then you create the relations among them and upload this dataset (dataset built from datasets) to the cloud (pbi service). Then you can connect to this huge dataset in live mode just as if it was a single, tiny, dataset.
Thank you. This is exactly what I needed
Thanks for making this video sir
This is very useful for decision making what we going to study in the current scenario ...
Glad you found it useful.
I wanted to connect to servicenow datasource and pull incident and change trends. How can we connect to a datasource
Please do comparison between Qlik Sense & Domo
what is the equivalent to Qlikview Cyclic Dimension or Group in Power Bi?
Qliksense has a desktop version now?
How does Qliksense performing currently? Is it still high in demand in the market when compared to other BI tools.
QlikSense is one of the leaders in the BI tools so the adoption is great. However the other leaders like Tableau and Power BI is a tough challenger for QlikSense.
Which tool has better scope in market
Based on what I am observing right now, Power BI is definitely in a lot of demand.
Hi Abishek . considering the cost of maintaining ( Subscription cost ) how costly is Qlik compared to Powerbi.
As PowerBi i can manage basic things with 0 Cost to 10$ per month.
Is Qlik going to cost more?
as far as i know. qlik is less expensive than power bi.
Give me a best suggestion to start learning qlik sense or power bi
Go with Power BI.
Overall good video, but it could have been better. I think you should have done a little more research. The only information useful to me was from 12th minute to 14th minute. You did not talk about ETL Capability and QVD support in Qlik. You can use Extension objects and Mashups in Qlik. The cost of PowerBI License is super cheap. You did not talk any about what DAX, M or anything else does.
Sir, Which is easy to learn and which is demanded job 2022
Power BI
Do we need to know coding to learn and work on qlik sense?
No coding
Qlik has no-coding tools that let you load data and create a dashboard. To build the most sophisticated solutions, you will want to use coding to load the data in a more controlled manner. Some of the more complex display techniques will require coding-like knowledge to control how data is displayed. For instance, if you want a chart to always show, say, last years financials vs this year's financials, even when filters are selected that would otherwise change the results, then you will need to use some advanced, coding-like techniques to control the display of data.
What's the future of qliksense ? Can you please let me know?
Overall great.. there is a lot of adoption by various MNCs.
@@AbhishekAgarrwal is catalyst methodology also widely used?
@@luisalichia5225 can you explain what is catalyst methodology?
@@AbhishekAgarrwal they do provide astandardized etl process within qliksense . it involves scripting.
Ye course se hum work from home kar sakte hai kya sir
Best solution is to use a true etl tool to completely scrub the data then use qlik/power for the analytics. Both are terrible and inefficient at etl
Thanks for the class... 😃
But, can I import QlikSense data into power bi?
when you say qlik sense data you mean QVD?
Abhishek can we have a word?
Qlik is better than power bi tool
I do prefer Qlik, but if you are building dashboards with a small amount of data (a few hundred thousand records by maybe a dozen fields or less) then Power BI is a perfectly capable product.
Hello Abhishek. Would you happen to have an email or could I use Facebook Messenger to contact you? I have some questions about both of these platforms and was hoping for some clarity from a seasoned veteran. Thanks.
sure..its abhishek.agarrwal@gmail.com