when I thought my teacher was the best , then I found James Oliver....wow ....what an explanation ......wow ......i understood it from a better perspective now ....Thank you Sir James
@helovesdata84833 жыл бұрын
I like how you go through a real-life project. I wanted to get an idea of how I would begin a job once I get into this field. This is great!
@helovesdata8483 Жыл бұрын
I'm returning with more knowledge than previously...lol Wouldn't it be beneficial to start with the business process? How were you able to run the new environment in parallel with the existing, if you are moving the data? I think I'm getting something mixed up here.
@danhendo46643 жыл бұрын
Thanks you so much! Your thought process is so well explained, this video is gold.
@bilalmujahid9239 Жыл бұрын
This video is goldie gold. Thank you.
@i_maverickmonica3 жыл бұрын
Thanks! you explain things in simple words, great solution !
@Ayuk13 жыл бұрын
Beautiful illustrations. Clear and easy to understand. Thanks alot
@JamesOliver3 жыл бұрын
Really appreciate the kind words. :)
@michaela643 жыл бұрын
Hi James, Nicely done, how you explain step-by-step what is going on in a project. This shows you need to understand business requirements, the architecture which needs to be migrated and the data warehouse architecture, where you want to integrate.
@thangtran1452 жыл бұрын
Thanks, you made it easy to understand!
@hiwotworkneh51014 жыл бұрын
Awesome video!! Subscribed👍
@NattyWerewolf4 жыл бұрын
You’re a legend
@filibertogarced2 жыл бұрын
Great vid 👌 Thanks for explaining everything so detailed 🙂
@SimohmedRaiss3 жыл бұрын
Amazing ! Very helpful
@andynelson23403 жыл бұрын
Wow, this is so informative. Thanks 😊
@thirumalaip64584 жыл бұрын
Thanks for the video. Can we please have more deep dive sessions on building a datawarehouse.
@JamesOliver4 жыл бұрын
I don't see why not. Was there any particular aspect of building a data warehouse you had in mind?
@thirumalaip64584 жыл бұрын
@@JamesOliver Yes more insights on the design and the ETL part. Maybe you can start a series on Udemy on how to build an EDW end to end.
@norpriest5213 жыл бұрын
@@thirumalaip6458 Can you recommend a book for EDW design please. Thank you.
@axequalsb84313 жыл бұрын
Great Video!!!
@jerzykepinski2 жыл бұрын
This is nice. Thanks!
@olukimkan3837 Жыл бұрын
This is a sharpener, sharpened some rough edges. Cheers
@NattyWerewolf4 жыл бұрын
Thanks so much. Subscribed !!
@Diamond_Hanz3 жыл бұрын
omg... this is great!
@pathfinder7503 жыл бұрын
How does this only have 5k view?
@rapo1074 жыл бұрын
James... could you please make a video on edit links on metrics and thresholds on attribute? Thanks in advance
@sangnykungkea80112 жыл бұрын
Can you upload the video demo the process build in SQL please!
@Fourtitude442 жыл бұрын
good video
@rezwanakhatun10152 жыл бұрын
Hi James, thank you so much for your thorough and detailed explanations and analogies. I really found your video helpful. One question I have on my mind, how long did it take for you to complete building and designing the DWH? What was the overall time frame for this project to deliver this solution to business?
@JamesOliver2 жыл бұрын
Great question. This was done under a compressed timeline that not only included building the data warehouse but a new reporting environment and making the users comfortable with the new environment through training. The total time was approximately 6 months. However, under normal conditions, this is extremely aggressive but I had no choice so there were many sleepless nights and long weekends. Because I was the main architect doing most of the technical work I was able to save time by cutting out overhead and providing all the direction to the DBA and ETL teams.
@rezwanakhatun10152 жыл бұрын
@@JamesOliver Thank you so much for your response, really appreciate it!😊
@JoshuaWilsonNZ3 жыл бұрын
What was total project time from spec to users using the EDW ? Intrigued because I'm about to start building a dwh for the org I work for. That tip about the views was genius! much easier for devs to have something to shoot for that's in front of them, compared to doing discovery work.
@JamesOliver3 жыл бұрын
Sorry for not answering sooner, missed this one but I would say make sure that the subject matter experts (ie those that understand the data best) are made to feel like they are part of the project. When building a data warehouse inevitably the devs will have many questions about the data and they cannot be waiting on people for answers or it can significantly impact the timeline. Do the developers have prior data warehouse experience?
@JoshuaWilsonNZ3 жыл бұрын
@@JamesOliver The org is quite fresh to modern data practices. Undeniably the devs will be enrolled in all the conversations. Its green fields here, likely we would bring in extra skill required. My big concern is the business doesn't have a clear picture on what end state should look like. I have my own vision for it, just wanted a baseline for total time if alignment is succinct across the biz
@JamesOliver3 жыл бұрын
Yes it can be a challenge for the business to wrap their heads around what this is going to do for them. Funny enough I’m starting up a new Edw project myself and I presented to leadership and made sure I used examples they could relate to. For example, are there a specific report request for an executive that took forever to deliver because IT had to go hunting down the data? Let them know this will bring these requests down from weeks to days or months to weeks with a data warehouse. That should help.
@rapo1074 жыл бұрын
Hi james... can we expect frequent uploads on microstrategy? Please make more videos on mstr.
@JamesOliver4 жыл бұрын
ramesh pedakotla Yes, they will continue. Just been taking some summer vacation time with family so uploads have slowed for now. :)
@rapo1074 жыл бұрын
@@JamesOliver.. enrolled in udemy for your videos.. 😊
@JamesOliver4 жыл бұрын
@@rapo107 Thank you so much for enrolling! :)
@NattyWerewolf4 жыл бұрын
Do you use python for data cleaning ?
@JamesOliver4 жыл бұрын
I do not use Python for data cleansing but you absolutely could. Typically I would handle data cleansing at the source if possible.
@boobkoo3 жыл бұрын
You forgot to mention that you use Kimball method to build your DW. Also there is other options as well.
@rdbtumpy3 жыл бұрын
Too much circumlocution. bored. stopped in the middle.