Great overview! Thankful for the 'Azure-Translation' (i.e., showing how all the products fit into the overall data flow)!
@devyaninair2793 Жыл бұрын
Thanks for a simple yet insightful session
@jbrake303 жыл бұрын
Interesting concept there at the end: prototype in PBI, then get back to me. Would love to see a blog/video on advice for that you've done in the past. Great work, as usual, James!
@moesmael3 жыл бұрын
what most people are not doing, is they just explain the concept and they are not explaining what tools to be used, where you did in your presentation. Thank you for this clear explanation. I want to implement this scenario and I am looking for sample data where I can also create a data model in target SQL DB. Do you know such a dataset to be used?
@thomasleblanc47603 жыл бұрын
Excellent explanation, thanks James!!!
@bigfarmerUK3 жыл бұрын
Thanks James. Useful video in showing how to apply Azure tools in the Azure DW workspace.
@alithorbs3 жыл бұрын
Great presentation thanks James.
@dataarq9453 жыл бұрын
Thanks, James, for Clear Explanation with Concepts and Tools to use. on Azure World
@raymondtan91123 жыл бұрын
Thanks, James. Very informational
@RowlandGosling3 жыл бұрын
Nicely done James!
@RodrigoBocanegraCruz2 жыл бұрын
Thanks James. I was wondering how would you see a datavault approach in the DWH layer, considering different rules would be applied before creating the dimensional model.
@anthonybenson2 жыл бұрын
Thanks James for this video. Explains things well. I wanted to ask where you would add on a real-time API capability to support a secure API marketplace for retrieving read-only data with sub-second response times. The use case would be a replica of a healthcare EMR.
@gnans2 жыл бұрын
Neatly explained
@marcuslawson46323 жыл бұрын
Thanks for your insightful videos, James. Do you recommend getting the individual Azure products or is Synapse Analytics a better way to go now? Seems like Synapse would allow you to see everything in one place, while the individual tools you'd need to piece together everything more manually. Do I understand that right? Thanks again
@jamserra3 жыл бұрын
You have it correct. Think of Synapse as a single pain-of-glass where all the tools live under one roof and you never have to leave Azure Synapse Studio
@marcuslawson46323 жыл бұрын
@@jamserra Thank you!
@GoatSays2 жыл бұрын
Thanks James. Do architectures like this only work for large companies or do you think small-medium size businesses could benefit from this over something like a traditional on-prem model (staging-ODS-DW)?
@evogelpohl3 жыл бұрын
Great post. Been an avid reader of your blog series for years. Q: Re: Guidance for Synapse for Large Enterprises w/ mature BI: Are we now 'officially' past the era where we need to consider the ole 'hub-n-spoke' model for DW & Marts w/ separate Db-gear & architectures (hub-n-spoke = whereby you needed a DW for storage & adhoc/deep analytics, but separate SQL Srvs for domain/subject based star/models (with all their SCD characteristics & low-lat/hi-concurrency usage). What's the current guidance from MS on this?
@jamserra3 жыл бұрын
Hi Eric...I can't comment on Microsoft's guidance but my thoughts are the traditional hub-n-spoke with the spoke being a separate database is rarely used anymore. Rather, the "spoke" is the tabular model (dataset) in a star schema in Power BI
@satwikkashyap86942 жыл бұрын
Hello James, it was a great video. is there a possible medium to connect with you?
@boutrosng3 жыл бұрын
Hi James, do you have some thoughts around MDM as it relates to improving the end results of a data warehouse and the overall data within the application architecture?
@jamserra3 жыл бұрын
Hi Pete, MDM is a must in most data warehouse solutions. I always make sure to tell customers to put a MDM product in your project plan because you will need it