Thank you Ruth! As a PBI user for 5 years now and a follower of yours for years I COULD NOT AGREE MORE. You're speaking the truth 100%. The number of workarounds and excuses that come from MS about those workarounds is insane just like you said. It drives me crazy. MS can't even get the basics right in PBI, yet they continue to push for newer "functionality" like Datamarts before addressing fundamental problems. It's a lot of lipstick on a pig. Thanks again for always telling it like it is.
11:25 agree with you. Microsoft has been focused on updating PBI Service to be a PBI Desktop online, rather than improve PBI itself. For me, over the last 2 years the best software improvement has been Field Parameterslast month. I am still complain about why visualization actions on Excel and Power Point are more user friendly and easy to get/learn compare with PBI. Why PBI can't be like Tableau? Why PBI can't have a right click mouse bottom menu on everything.
I love this feature, because I can now build the model, create the relations, formulate the DAX, and some other of my team can paint the dashboard... There are some good designers but with low technical level, and before now, we couldn't work together in the same file. Now we can (almost at 100%). If I'm not wrong, this is a huge improvement
There are already quite many tools/ technologies to manage data (DWH, dataflows, data lakes, datasets….),this is another one, but for us that paint dashboards for a living, more is needed. Hopefully 2023 will be the year!
fully agree with you regarding Power BI Desktop Online. As of now, even business users and data analysts are able to build a data model using Power BI Desktop, publish it into Power BI Service and build a report using Power BI Dataset connector. If they have permissions, they are also able to set a schedule refresh like in Power BI Datamarts. The only advantage I see so far is that all actions (getting data, transform it, build a data model and build report) can be done in the Power BI Service. Maybe I still need to experiment a bit more, but I still have some question marks about Power BI Datamarts, e.g. how we can track the changes, support for import mode, any performance benefit compared to the Power BI Dataset connection, etc.
Thanks for the great summary, couldn't agree more. I was following the release and kept having the feeling this really doesn't seem like a big improvement, but thought I must be missing something
Agree. Another re-modelling new etl etc is not required. I don't get it. What is the difference between a data mart and a pbix that you used Power Query to do the ETL and upload to the service without visualisation?
@@CurbalEN perhaps, but I don't see the advantage. Perhaps it is just smaller models for business areas created by data modellers that are pre-made for analysts, that you just connect your PBIX to and don't have to do any modelling.
There could be advantages as you could have more computer power in the cloud, people could work on the same model easier, version control perhaps can be easier implemented… my only complaint is that there should be a balance between development in data management side and information side. We get too little on the information side.
"Business users would not sit and build mini data warehouses" I couldn't agree more!, and certainly Datamarts makes sense only thinking if it's going to replace Power BI Desktop and making available to Mac and Linux users. I've checked Datamarts feature, and OK... may be I'm a classic, but i still relay so far on Power BI Desktop than Datamarts. Epical sentences from The Data Loom book, Thanks Ruth!! 🙌It'll be on my reading list for this summer. And very interesting reflexion about visualization needs, there is a long road to run (against strong competitors, by the way)
👏👏 Awesome analysis and editorial! I think you summarized what many of us are thinking/feeling not only about Datamarts but also about the direction where MS is taking Power BI... Still a fanboy but often concerned recently... I hope MS will heed your advice.
Totally agree with your sentiment. I find the whole microsoft ecosystem so confusing. Finally when I feel I understand how the products fit together, or how to configure them, it's either rebranded or replaced, just for the sake of change. I really really really hope they don't abandon powerbi desktop in favour of a pure online version.
Where the tool is, I seriously couldn’t care less ( unless they make it a hot mess like they did with with dataflows). My biggest frustration is the lack of development on the data viz, reporting features for us that work in the information business. Why don’t you want it in the cloud?
Probably no real incentive to fix the features that really matter. 'We integrate with everything under the sun' is probably a much easier sell to the decision makers than 'you have complete control over every visualisation element' (for arguments sake). Most of my clients choose powerbi as they are already invested in the Microsoft ecosystem. Turning on powerbi becomes very easy. Do to use Tableau? I haven't tried to develop a full visualisation in powerbi service, but if its anything like powerapps, trying to get pixel perfect precision is just painful.
No, I haven’t used Tableau. I was tempted when it was possible to connect power bi data with tableau using xlma but it is only premium so kind of pointless unfortunately, otherwise maybe it would have been best of worlds!
Hi Ruth, do you think this service will be replacing the microsoft analysis services? i have the impression that power users will be finding all the services now directly in the power bi environment. thank you
Thanks for your video. I thought I was the only one struggling to understand why datamarts was such a hyped feature. I'm sure it has it's place, but it doesn't seem like it solves any major problems for my organization. If we can't make data accessible to other types of users today via dataflows, datasets and composite models, then I don't think datamarts are going to change that. I also appreciate you perspective on the industry as a whole.
Thank you for making this video on Datamart. I've seen so many videos on datamart and this is probably the only one that makes sense to me. Thank you Ruth! 🙏
I completely agree with you! No Power BI experts will excite with this DataMart(Web-PBI Desktop). Moreover, it's more expensive than DataFlows(Just Pro req.). Because you need Premium(it seems like they want more users who can buy more premium nodes). *** Just to conclude.. datamart is only useful(with expenses) for Mac PBI Users. Not sure, if the datamart is accessible from PBI desktop or not :) ... --------> I like your Honesty (y) in revealing the fact!
My understanding the biggest update of "Data Marts" is making Power BI covering all the main tools of working with Data in one platform. 1) ETL (Power Query) as a visual pipeline. (Quite similar to other products such as Alteryx). This is quite exciting for Power Query users. 2) Landing Data into data warehouse from Power Query.This is the 1st time Power BI is able to do something like (Super exciting) Although I hope they will allow other Data warehouses not only Azure. 3) Visualise the data from the data warehouse - bringing the exciting Visual from desktop to online.
After watching multiple videos telling me that datamarts are going to change my life (guys in the cube), I still couldn't see how and what the selling point was. Glad to hear that it has caused others the same confusion. I avoid PBI online for a reason and i do not want to have to learn another "self service" tool which offers no real value on top of Power apps, power automate, power pages, power BI, excel and the list goes on. To be a true master at excel alone takes many years.... Also completely agree about the visual side of Power BI - I Wonder how long PBI will continue to sit in the top right Gartner quadrant....Final point i feel like the self service side is a bit of an illusion. I still see many business users who struggle with a lookup let alone using the above list for self service. In fact i do not think i have come across one user in the workplace who is able to use these outside of IT and then we get to the whole issue that IT do not understand the business resulting in another failed implementation....
I agree with you, the struggle is real for both IT and businesses. I work with a lot of businesses and they do well with power bi but when their needs become more advanced (which is a good thing) they will need help and that is probably why the market is exploding for PBI professionals. Thanks for sharing! I truly appreciate to hear other people’s thoughts on the status and direction that the power bi platform is taking. /Ruth
My journey is creating a well functioning pbi app with well liked and used reports for a factory in a big company. Everything I built was based on the raw source data from lake with rather advanced SQL to solve ETL. I was good at it so I got an invite to work at central IT for the company. The target architecture at central IT is Sources -> Lake -> Data Warehouse (Oracle) -> Tabular. I recently took a course in ODI because I felt blocked/bored by not being able to do the ETL work. To me, this seem really close to ODI but much more user friendly but perhaps less powerful - which got me really excited actually! In my setting, the ETL process always dictate what you can visualize and always causes long lead times in projects. Since ETL causes long lead times the customer feels like they need to get everything from source leading to confusing tabulars/models that are unusable. It's a vicious circle that perhaps is broken because this is so easy to use and co-use with customers? Is that the redeeming factor? Thanks for your insights.
Thanks for sharing your thoughts, it helps me frame my understanding of things that I don’t naturally work with. From the perspective of: let’s squeeze some great information/insights out of this data, power bi has been a dream when it comes to getting the data, transforming it and asking questions but it fails short on the last mile which is data viz and data presentation. No super clean and accessible dataset will compensate for that and that is why I am crying for help: more focus is needed in the viz/reporting layer imo. Hope it makes sense :)
I haven't gone into a detailed review of the online benefits of this new feature, but seeing the comments, I agree with you, however in defense of MS, if the final model of a DataMart was useful and gave input to other processes, maybe management and sharing were easier or more specialized from Power BI Service, or maybe that's where they wanted to take this feature. Regards Ruth, you're awesome 👍
@@CurbalEN Thanks for confirmation. so it potentially will have similar issues as Cognos Data Modules. I am not sure why it can’t be done like Power Apps where Version control is in-built.
Grateful for the online version as my company is almost exclusively on Apple computers and IT doesn't give any support to help them get Power BI desktop installed. This way I'll be able to easily get people working on Power BI without having to do all of the workarounds and fighting IT
Thank you Ruth, completely agree. Microsoft continue to update the wrong areas of the product whilst promoting it to business users as 'plug & play' ie really simple to use to get analysis insight. When in fact, information workers (great term, thank you!) have to understand data structure, interpret business requirements and fiddle around with visuals to get something genuinely insightful and intuitive for the customer.
I understand that MS has to sell the product, I just wish they invest more into developing the desktop and I think they are going to do it now? Let see!
Totally agree that MS needs to adress some problems prior developing new features. In my daily basis i feel that for creating some objects i need to create huge and complex formulas in DAX, and right now I am seriously thinking in learning R. I really like DAX, don't get me wrong, but there's room for improving. Anyway, i'm going to learn R, first because knowledge is always good and secondly because I am comparing against a code that i do not even know (it might have good and bad things). By the way @Curbal, what do you recommend, R or Python? I saw a video you did about it but i was dated from 2018... Thank you!
Remember Power BI is a platform that helps us manage and visualize data, but no much progress has been made in the viz realm and therefore my complain.
I used to use Tableau years before got into Power BI around a year ago. I really enjoy using Power BI but damn it lacks A LOT of creativity and data VIZ capabilities compared to Tableau. Thanks to Deneb there is a chance to be creative.
The biggest news is that finally we've got one stop shop for people want to have their data in Excel and Power Bi with RLS enabled (with additional semantics as a bonus). As for dataset... I don't buy anything you cannot modify wih Tabular Editor. But I couldn't agree more on data visualization front more - we should be able to conditionaly program columns, rows adn headers, create progress bars, have ICBS standards etc... I mean this should be more like working with AdobeXD or Figma
I think the strength is going to come in where a business has disparate data marts that require a single reporting point (due to takeovers etc.) The datamart format should be a strong band aid fix while larger projects work to update and centralise existing systems.
Completely agree with you Ruth, we are tired of learning data management tools, and what we have is enough, but for example we still don't have a prpoer shape map visual that you can plot multiple layers on it and show titles!! Mapping is still really poor in Power BI
@@CurbalEN Unfortunately, this Azure map is not working! I providde the same shape file that works on the shape map visual but it doesn't work on the Azure map, even the one shipped with Excel is far better than the one in Power BI
I was leading Data empowerment/self-service program in my company: Dataflows do not have Row Level Security, on the other hand Dataset does not allow adding additional Tables into model (there is a preview feature "DirectQuery for PBI datasets and AS"). I needed this feature to be official, but Microsoft is pushing now Datamarts that is requesting Premium per User 😭
Datamarts? Tableau’s advantage is that they are better at the viz layer and sales force will accelerate the data management one. We need someone to start caring for the viz layer in power bi :(
I will tell it in my natural language (just for the pleasure) Ce que vous dites résonne parfaitement comme le chemin à suivre Il faut une vision, les bons outils à maturité, 2023 c'est proche, we will see Merci encore pour ce partage
I'm not sure if you ever tested Qlik, the associative engine gets you into the next level in terms of analyzing data that you cannot get with an SQL based engine.
Thanks but I think qlik needs to be bought by a bigger company in order to get enough funds to survive, like tableau did, otherwise it will find it hard to compete. Hopefully I am wrong :(
@@CurbalEN Qlik was bought some time ago and has been very active on acquisitions. Let us see who is best fit to survive, an independent Qlik or a small part of a bigger business Tableau... i bet that Qlik will still be a thriving company in 5/10 years and Tableau will be completely diluded into the Salesforce forest. Check the innovation provided by Qlik in the last year and compare it with what Microsoft and Tableau presented... You'll be surprised.
I really hope they make it and thrive!! Competition is critical for innovation and for us customers to have options. Have a link for a webinar I can check? Qlik was a Swedish startup :)
I really like - love Power BI, yet as Ruth said, this improvement release was not an exact (based on user needs) update or imrpovement. It was more a move from MS on the basis of applying 2 core strategies of the company. A) It is a proprietary products company, so they must strategically move towards, making cash from every available improvement towards the users (users in the end will pay for everything regarding PowerBI). B) MS is considering itself, a Cloud-Company based on the speech and strategic intention of its CEO.
Seems Microsoft has fully outsourced the Vis development to 3rd parties. They feel happy and we, the end-users, should struggle with different custom visuals for simplest use cases such as html content, Gantt chart, etc.
I think business users will still sturggle with building a data model and it will end up going back to the engineers to do it anyway. If it was that easy they could just be building datamodels in desktop!
I think MS is trying to kill 2 or more birds with one stone :). I don't think that M$ makes a lot of $ from Pro licenses rather Premium is their cash cow. So they HAVE TO bring more tools/tech under Premium umbrella. And adding self managed reporting db makes a lot of sense from that perspective. And If you already have Power bi premium it MAY simplify the overall solution and reduce overall cost, but will allow MS make more $. If you don't it will be one more incentive to buy premium or maybe they will start charging by usage which would make more sense
Not sure more features will move small and mid companies to premium, but enterprise probably will. MS has to make money, no shame on that, but I wish they would balance between the data layer and the viz/reporting layer :(
Thank you Ruth! As a PBI user for 5 years now and a follower of yours for years I COULD NOT AGREE MORE. You're speaking the truth 100%. The number of workarounds and excuses that come from MS about those workarounds is insane just like you said. It drives me crazy. MS can't even get the basics right in PBI, yet they continue to push for newer "functionality" like Datamarts before addressing fundamental problems. It's a lot of lipstick on a pig. Thanks again for always telling it like it is.
Fingers crossed they will start to pay attention to the viz layer soon !!
11:25 agree with you. Microsoft has been focused on updating PBI Service to be a PBI Desktop online, rather than improve PBI itself. For me, over the last 2 years the best software improvement has been Field Parameterslast month. I am still complain about why visualization actions on Excel and Power Point are more user friendly and easy to get/learn compare with PBI. Why PBI can't be like Tableau? Why PBI can't have a right click mouse bottom menu on everything.
I don’t know and I wish it was :(
I love this feature, because I can now build the model, create the relations, formulate the DAX, and some other of my team can paint the dashboard... There are some good designers but with low technical level, and before now, we couldn't work together in the same file. Now we can (almost at 100%).
If I'm not wrong, this is a huge improvement
There are already quite many tools/ technologies to manage data (DWH, dataflows, data lakes, datasets….),this is another one, but for us that paint dashboards for a living, more is needed. Hopefully 2023 will be the year!
Nice analysis on gathering data vs actually doing something with it!
fully agree with you regarding Power BI Desktop Online. As of now, even business users and data analysts are able to build a data model using Power BI Desktop, publish it into Power BI Service and build a report using Power BI Dataset connector. If they have permissions, they are also able to set a schedule refresh like in Power BI Datamarts. The only advantage I see so far is that all actions (getting data, transform it, build a data model and build report) can be done in the Power BI Service. Maybe I still need to experiment a bit more, but I still have some question marks about Power BI Datamarts, e.g. how we can track the changes, support for import mode, any performance benefit compared to the Power BI Dataset connection, etc.
It will come, these are early days for datamarts!
Thanks for the great summary, couldn't agree more. I was following the release and kept having the feeling this really doesn't seem like a big improvement, but thought I must be missing something
As always, somebody is going to be super excited about it (and are already) for us in the information business is not what we need :(
Agree. Another re-modelling new etl etc is not required. I don't get it. What is the difference between a data mart and a pbix that you used Power Query to do the ETL and upload to the service without visualisation?
Maybe it will allow to us to create pbix in the cloud ?
@@CurbalEN perhaps, but I don't see the advantage. Perhaps it is just smaller models for business areas created by data modellers that are pre-made for analysts, that you just connect your PBIX to and don't have to do any modelling.
There could be advantages as you could have more computer power in the cloud, people could work on the same model easier, version control perhaps can be easier implemented… my only complaint is that there should be a balance between development in data management side and information side. We get too little on the information side.
Just finished reading The Data Loom. Wonderful and insightful. Thank you so much Ruth for recommending!
I loved it too ! Will recommend more books in the future :)
Hey Ruth! Great video!!
What else you recommend to read?
Hans Rosling Factffullness
"Business users would not sit and build mini data warehouses" I couldn't agree more!, and certainly Datamarts makes sense only thinking if it's going to replace Power BI Desktop and making available to Mac and Linux users.
I've checked Datamarts feature, and OK... may be I'm a classic, but i still relay so far on Power BI Desktop than Datamarts.
Epical sentences from The Data Loom book, Thanks Ruth!! 🙌It'll be on my reading list for this summer. And very interesting reflexion about visualization needs, there is a long road to run (against strong competitors, by the way)
Happy Reading Antonio, it is a great book!
Ruth , this sentence of this book just blew my mind , thanks for sharing.
Yeah, he is spot on even today :(
👏👏 Awesome analysis and editorial! I think you summarized what many of us are thinking/feeling not only about Datamarts but also about the direction where MS is taking Power BI... Still a fanboy but often concerned recently... I hope MS will heed your advice.
Fingers crossed 🤞 and thanks, nice to know I am not the only one feeling this way!
Totally agree with your sentiment. I find the whole microsoft ecosystem so confusing. Finally when I feel I understand how the products fit together, or how to configure them, it's either rebranded or replaced, just for the sake of change. I really really really hope they don't abandon powerbi desktop in favour of a pure online version.
Where the tool is, I seriously couldn’t care less ( unless they make it a hot mess like they did with with dataflows). My biggest frustration is the lack of development on the data viz, reporting features for us that work in the information business.
Why don’t you want it in the cloud?
Probably no real incentive to fix the features that really matter. 'We integrate with everything under the sun' is probably a much easier sell to the decision makers than 'you have complete control over every visualisation element' (for arguments sake). Most of my clients choose powerbi as they are already invested in the Microsoft ecosystem. Turning on powerbi becomes very easy. Do to use Tableau? I haven't tried to develop a full visualisation in powerbi service, but if its anything like powerapps, trying to get pixel perfect precision is just painful.
No, I haven’t used Tableau. I was tempted when it was possible to connect power bi data with tableau using xlma but it is only premium so kind of pointless unfortunately, otherwise maybe it would have been best of worlds!
Hi Ruth, do you think this service will be replacing the microsoft analysis services? i have the impression that power users will be finding all the services now directly in the power bi environment. thank you
Good question, analysis services will probably survive for bigger dataset, at least for now. Let’s see.
@@CurbalEN thanks!
Good points Ruth. DM is also a read only Azure SQL Direct Query model currently.
Yes, let’s see how it evolves!
Thanks for your video. I thought I was the only one struggling to understand why datamarts was such a hyped feature. I'm sure it has it's place, but it doesn't seem like it solves any major problems for my organization. If we can't make data accessible to other types of users today via dataflows, datasets and composite models, then I don't think datamarts are going to change that. I also appreciate you perspective on the industry as a whole.
Hi Ruth, Do you know if a datamart retreive data from different power bi tennants? or do we have to copy them manually to datamart on main tenant?
I don’t know, maybe someone in the Community.powerbi.com knows?
They need to implement Stephen Few's DataViz practices in the Desktop. Starting with bullet chart inside Matrix....
And able to sort the columns and width with a property In the format pane rather than a custom column…the basics are not there yet either !
Thank you for making this video on Datamart. I've seen so many videos on datamart and this is probably the only one that makes sense to me.
Thank you Ruth! 🙏
Glad it helped!
I completely agree with you! No Power BI experts will excite with this DataMart(Web-PBI Desktop). Moreover, it's more expensive than DataFlows(Just Pro req.). Because you need Premium(it seems like they want more users who can buy more premium nodes). *** Just to conclude.. datamart is only useful(with expenses) for Mac PBI Users. Not sure, if the datamart is accessible from PBI desktop or not :) ... --------> I like your Honesty (y) in revealing the fact!
My understanding the biggest update of "Data Marts" is making Power BI covering all the main tools of working with Data in one platform.
1) ETL (Power Query) as a visual pipeline. (Quite similar to other products such as Alteryx). This is quite exciting for Power Query users.
2) Landing Data into data warehouse from Power Query.This is the 1st time Power BI is able to do something like (Super exciting) Although I hope they will allow other Data warehouses not only Azure.
3) Visualise the data from the data warehouse - bringing the exciting Visual from desktop to online.
After watching multiple videos telling me that datamarts are going to change my life (guys in the cube), I still couldn't see how and what the selling point was. Glad to hear that it has caused others the same confusion. I avoid PBI online for a reason and i do not want to have to learn another "self service" tool which offers no real value on top of Power apps, power automate, power pages, power BI, excel and the list goes on. To be a true master at excel alone takes many years.... Also completely agree about the visual side of Power BI - I Wonder how long PBI will continue to sit in the top right Gartner quadrant....Final point i feel like the self service side is a bit of an illusion. I still see many business users who struggle with a lookup let alone using the above list for self service. In fact i do not think i have come across one user in the workplace who is able to use these outside of IT and then we get to the whole issue that IT do not understand the business resulting in another failed implementation....
I agree with you, the struggle is real for both IT and businesses.
I work with a lot of businesses and they do well with power bi but when their needs become more advanced (which is a good thing) they will need help and that is probably why the market is exploding for PBI professionals.
Thanks for sharing! I truly appreciate to hear other people’s thoughts on the status and direction that the power bi platform is taking.
/Ruth
very nice analysis. It is good to point that out so when we do our jobs, we remember what are we doing it fore.
Thanks Ronald!
Ruth speaks Truth. Reading the comments. Everyone seems to agree with this.
Depending of which side of the data business you are on, my take will make sense or not. I know plenty of people that disagrees with me 😂
My journey is creating a well functioning pbi app with well liked and used reports for a factory in a big company. Everything I built was based on the raw source data from lake with rather advanced SQL to solve ETL. I was good at it so I got an invite to work at central IT for the company. The target architecture at central IT is Sources -> Lake -> Data Warehouse (Oracle) -> Tabular. I recently took a course in ODI because I felt blocked/bored by not being able to do the ETL work. To me, this seem really close to ODI but much more user friendly but perhaps less powerful - which got me really excited actually!
In my setting, the ETL process always dictate what you can visualize and always causes long lead times in projects. Since ETL causes long lead times the customer feels like they need to get everything from source leading to confusing tabulars/models that are unusable. It's a vicious circle that perhaps is broken because this is so easy to use and co-use with customers? Is that the redeeming factor?
Thanks for your insights.
Thanks for sharing your thoughts, it helps me frame my understanding of things that I don’t naturally work with.
From the perspective of: let’s squeeze some great information/insights out of this data, power bi has been a dream when it comes to getting the data, transforming it and asking questions but it fails short on the last mile which is data viz and data presentation.
No super clean and accessible dataset will compensate for that and that is why I am crying for help: more focus is needed in the viz/reporting layer imo.
Hope it makes sense :)
I haven't gone into a detailed review of the online benefits of this new feature, but seeing the comments, I agree with you, however in defense of MS, if the final model of a DataMart was useful and gave input to other processes, maybe management and sharing were easier or more specialized from Power BI Service, or maybe that's where they wanted to take this feature. Regards Ruth, you're awesome 👍
Not saying datamarts are not useful, just saying that we have enough data management tools we need more information tools, that’s all :)
Do you know how version control will work with Datamart based solutions?
I am afraid not :(
@@CurbalEN Thanks for confirmation. so it potentially will have similar issues as Cognos Data Modules. I am not sure why it can’t be done like Power Apps where Version control is in-built.
I meant I don’t now how it will work?
Grateful for the online version as my company is almost exclusively on Apple computers and IT doesn't give any support to help them get Power BI desktop installed. This way I'll be able to easily get people working on Power BI without having to do all of the workarounds and fighting IT
That is a great point, Thanks for sharing :)
@@CurbalEN I just ordered the book you showed. Thanks for the recommendation.
It is a great book, you will enjoy it :)
Thankyou very much for shedding some light on this subject.
It is just a hunch, not sure if my theory is true though…
Thank you Ruth, completely agree. Microsoft continue to update the wrong areas of the product whilst promoting it to business users as 'plug & play' ie really simple to use to get analysis insight. When in fact, information workers (great term, thank you!) have to understand data structure, interpret business requirements and fiddle around with visuals to get something genuinely insightful and intuitive for the customer.
I understand that MS has to sell the product, I just wish they invest more into developing the desktop and I think they are going to do it now? Let see!
Totally agree that MS needs to adress some problems prior developing new features. In my daily basis i feel that for creating some objects i need to create huge and complex formulas in DAX, and right now I am seriously thinking in learning R. I really like DAX, don't get me wrong, but there's room for improving. Anyway, i'm going to learn R, first because knowledge is always good and secondly because I am comparing against a code that i do not even know (it might have good and bad things). By the way @Curbal, what do you recommend, R or Python? I saw a video you did about it but i was dated from 2018... Thank you!
For data only R but python is a powerful programming language so you will have more uses. It depends on what you want to use them for?
@@CurbalEN Power BI mainly
Then I would choose R
Good point! Power BI is visiliazation tool and dont' make it too complex. Focus!!!
Remember Power BI is a platform that helps us manage and visualize data, but no much progress has been made in the viz realm and therefore my complain.
Ruth, Muy buena Explicación y apoyo su comentario..Esperemos que Microsoft tome en en cuenta su opinion. Saludos
Saludos Víctor!
I used to use Tableau years before got into Power BI around a year ago. I really enjoy using Power BI but damn it lacks A LOT of creativity and data VIZ capabilities compared to Tableau. Thanks to Deneb there is a chance to be creative.
Yes, agree!! My saviour is charticulator :)
The biggest news is that finally we've got one stop shop for people want to have their data in Excel and Power Bi with RLS enabled (with additional semantics as a bonus). As for dataset... I don't buy anything you cannot modify wih Tabular Editor. But I couldn't agree more on data visualization front more - we should be able to conditionaly program columns, rows adn headers, create progress bars, have ICBS standards etc... I mean this should be more like working with AdobeXD or Figma
The fact that you need an external tool to do basic things in power bi says it all :(
I think the strength is going to come in where a business has disparate data marts that require a single reporting point (due to takeovers etc.)
The datamart format should be a strong band aid fix while larger projects work to update and centralise existing systems.
True , that should work!
Completely agree with you Ruth, we are tired of learning data management tools, and what we have is enough, but for example we still don't have a prpoer shape map visual that you can plot multiple layers on it and show titles!! Mapping is still really poor in Power BI
They have now Azure maps, is that not good ? I haven’t done much with it yet
@@CurbalEN Unfortunately, this Azure map is not working! I providde the same shape file that works on the shape map visual but it doesn't work on the Azure map, even the one shipped with Excel is far better than the one in Power BI
The shape map needs some serious love, I agree!!
I was leading Data empowerment/self-service program in my company: Dataflows do not have Row Level Security, on the other hand Dataset does not allow adding additional Tables into model (there is a preview feature "DirectQuery for PBI datasets and AS").
I needed this feature to be official, but Microsoft is pushing now Datamarts that is requesting Premium per User 😭
They might change the tier later, they did it with dataflows. Let’s see…
10:51 other competitors are doing the same, such as Salesforce, perhaps Tableau is coming soon and Alteryx is on it.
Datamarts? Tableau’s advantage is that they are better at the viz layer and sales force will accelerate the data management one. We need someone to start caring for the viz layer in power bi :(
@@CurbalEN Not Datamarts, online versions of the Desktop product.
Ahhh got you!
I will tell it in my natural language (just for the pleasure)
Ce que vous dites résonne parfaitement comme le chemin à suivre
Il faut une vision, les bons outils à maturité, 2023 c'est proche, we will see
Merci encore pour ce partage
le français est une si belle langue
i always considered PowerBi datasets as datamart... and PowerBi DataFlow as datalakes...
And you might have been right on the money all along 👏👏
I'm not sure if you ever tested Qlik, the associative engine gets you into the next level in terms of analyzing data that you cannot get with an SQL based engine.
I have never used Qlik, but the users I know really love the tool!
@@CurbalEN you should. Let me know if you want to know the next level that you are looking for.
Thanks but I think qlik needs to be bought by a bigger company in order to get enough funds to survive, like tableau did, otherwise it will find it hard to compete. Hopefully I am wrong :(
@@CurbalEN Qlik was bought some time ago and has been very active on acquisitions. Let us see who is best fit to survive, an independent Qlik or a small part of a bigger business Tableau... i bet that Qlik will still be a thriving company in 5/10 years and Tableau will be completely diluded into the Salesforce forest.
Check the innovation provided by Qlik in the last year and compare it with what Microsoft and Tableau presented... You'll be surprised.
I really hope they make it and thrive!! Competition is critical for innovation and for us customers to have options.
Have a link for a webinar I can check?
Qlik was a Swedish startup :)
Bought my copy of Data Loom!
It is a great book 📚!!
Thanks! couldn't agree more!
Glad to know I am not alone!
I really like - love Power BI, yet as Ruth said, this improvement release was not an exact (based on user needs) update or imrpovement. It was more a move from MS on the basis of applying 2 core strategies of the company. A) It is a proprietary products company, so they must strategically move towards, making cash from every available improvement towards the users (users in the end will pay for everything regarding PowerBI). B) MS is considering itself, a Cloud-Company based on the speech and strategic intention of its CEO.
Thank you
Totalmente de acuerdo! Qué buen video.
Muchas gracias John!
Thanks for this!
Coudnt agree with you more.
Thanks!
I agree completely.
Thanks for sharing !
Sounds like composite models with extra steps
At the moment it kind of is? Including power query of course
Thanks
Super thanks!
¡Super de acuerdo!
🎉🎉
Seems Microsoft has fully outsourced the Vis development to 3rd parties. They feel happy and we, the end-users, should struggle with different custom visuals for simplest use cases such as html content, Gantt chart, etc.
Hopefully not for long :(
I hope the 'PBI desktop online' would not be janky
Me too, dataflows is still horrible :(
I think business users will still sturggle with building a data model and it will end up going back to the engineers to do it anyway. If it was that easy they could just be building datamodels in desktop!
I think MS is trying to kill 2 or more birds with one stone :). I don't think that M$ makes a lot of $ from Pro licenses rather Premium is their cash cow. So they HAVE TO bring more tools/tech under Premium umbrella. And adding self managed reporting db makes a lot of sense from that perspective.
And If you already have Power bi premium it MAY simplify the overall solution and reduce overall cost, but will allow MS make more $. If you don't it will be one more incentive to buy premium or maybe they will start charging by usage which would make more sense
Not sure more features will move small and mid companies to premium, but enterprise probably will.
MS has to make money, no shame on that, but I wish they would balance between the data layer and the viz/reporting layer :(
"I want more, I need more..." - Ruth
You are saying I am needy? 😂
I told you 6 days ago: My understanding was that datamart is just a PBI dataset being fully online.
👏👏👏
Whoa ❤
A++
☺️
so honest so true :)
sometimes diversity is killing efficiency :D
😂
Microsoft is very bad at naming things.
And worst at renaming them! 😂😂(goals to metrics)
I could not agree more... I think the tab where you can browse datasets in PBI Service has changed three times since I started using it.
😂