Microsoft Analytics. Where to focus as an Access developer
Hi
I am an Access VBA and Excel VBA developer. I have also spent ten years working on ASP.net sites using vb.net. I am a little confused by all the the products Miccrosoft has released for analytics. I know that Power BI is used heavily but to me it isn't as good as raw SQL. Based on what organisation's are using where is Microsoft going? What should someone with my skill set focus on to keep up with Microsoft analytics? Is Access being dropped?
I am an Access VBA and Excel VBA developer. I have also spent ten years working on ASP.net sites using vb.net. I am a little confused by all the the products Miccrosoft has released for analytics. I know that Power BI is used heavily but to me it isn't as good as raw SQL. Based on what organisation's are using where is Microsoft going? What should someone with my skill set focus on to keep up with Microsoft analytics? Is Access being dropped?
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks dpearson for "Power BI does a nice job at that for us. " - that is great to know. Perhaps I should start with that
ASKER
Again this is really interesting to know "The interesting thing is we're not a Microsoft shop. We're all about Java apps and MySQL on Linux servers. But we use PowerBI for the analytics. So that opens a really big opportunity for an analytics developer as there's vastly more MySQL instances running on Linux servers waiting to be analyzed than folks running pure Microsoft stacks. "
For developing robust business solutions nothing beats Access. In the world of small to medium size businesses, I have always found Access to be a great tool. Used properly, it provides a platform that is very efficient and easy to maintain.
Of course the developer has to have a thorough understanding of the application. Also, work with your users. Amazing how they can give you insight in how to make their jobs more efficient through system enhancements.
Of course the developer has to have a thorough understanding of the application. Also, work with your users. Amazing how they can give you insight in how to make their jobs more efficient through system enhancements.
You may always say this independently on the language/tool used for the development. If you are developing long time in one language then you are becoming expert even when you don't push for it...
OTOH, I would be very cautious when MS Access application(s) should become business critical in my company. Access is good for single computer, for prototyping, for very small teams etc. But several vendors delivering Access applications which are intended for use across the midsize company means no go for me. And this is valid even when the data are stored on a SQL backend.
I can imagine how several vendors are upgrading to the given version, how users cannot test Access application when their computer is occupied by a different Access engine version or bit depth etc.
Even the medium sized business should focus on platform independent solutions.
OTOH, I would be very cautious when MS Access application(s) should become business critical in my company. Access is good for single computer, for prototyping, for very small teams etc. But several vendors delivering Access applications which are intended for use across the midsize company means no go for me. And this is valid even when the data are stored on a SQL backend.
I can imagine how several vendors are upgrading to the given version, how users cannot test Access application when their computer is occupied by a different Access engine version or bit depth etc.
Even the medium sized business should focus on platform independent solutions.
ASKER