00:03 A database schema represents the structure of the data. 00:40 Understanding the structure and relationships of data in a database is called the schema. 01:17 Schema on Read vs. Schema on Write 01:56 A good data schema is important for efficient and fast queries. 02:30 Consuming oceans of data with no conform schema for slow analytics 03:04 The concept of engineering analytical schema remains important for feeding information to business users. 03:41 Documentation inputs and conceptual data model are important for development. 04:16 Intricity specializes in defining future state data warehouses and executing on their deployment. Crafted by Merlin AI.
Why go through the “interview” process? Why not just use logic, common sense, and best practices? You could use that as a draft and save a lot of time by just doing it. Coming up with data isn’t complicated; it only gets complicated when you turn that data into code.
If you're going to define conformity across process owners, you're doing to need to talk with them to know what data objects they want to use. Once you know that you can define the conformity which you can define in a model.
so an account in World of warcraft could be the first point in the graph which connects to many other points like Characters on your wow account - which each of those characters connect to additional points to - class and name and pets and friends that they have, etc
Great explanation! Master Data Management is crucial for maintaining data integrity across an organization, ensuring consistency and reliability for informed decision-making. Thanks for sharing!
Uhhh actually DAG is a custom track clan for the popular game Mario Kart Wii and we have hopes in the future to become one of the top clans with great leadership from Mystique as well good team bonding from our peers. Please research your facts before you spout out a bunch of random information.
@@justinolsen488anything past late 7 automatically defrags when needed. Do not defrag an SSD. SSDs only suffer damage from defragging via shit tons of wear leveling from the writes.
@@networkoperations SSDs don't get damaged by defragmenting, it's just pointless because there are already no moving parts. Modern SSDs can handle tens or hundreds of millions of write operations no problem.
I used to have a picture of the Statue of Liberty outside my office (When I was CIO), the caption said "Bring Us Your Problem, Not Your Solution." The business and IT roles where confused, intime, and with total cost transparency ( I cancelled all "IT" projects that did not have a Business Sponsor and started over) the business came to realize the cost drivers for IT (them) and took responsibility for collaborating among themselves regarding what projects where mutually beneficial before they came to the table with needs and nice to have for the year. This enabled IT to support real business initiatives with and articulated value. You could ask any IT type in the hall what they were up to and they could tell you in the context of a real business need.
@@Intricity101 lol, not much unlike the 37 years in "IT". I finally was in a position to try things I thought would solve the root of most IT "issues" and that is IT taking on things they should not. For example - Implementing Business Solutions, (implementing the tools, infrastructure, applications the business has architected without IT or Architecture review); IT trying to convince the business what is valuable to them, taking "orders". The organization needed transparency as to what costs were realized for IT services, and why, and by whom. I initiated a monthly review process to provide the "business" with a forum for them to share among themselves what objectives they had. This resulted in communication that simply didn't happen before, the results were very impactful to the organization and the long-term relationship with their new partner, "IT".
Well done, but introducing the concept of 'conspiracy theory' into the video was not necessary nor productive. You could have used a much more appropriate alternative. Ostracising that concept within your fine video diminishes the overall message and borders on a category error. The term 'conspiracy theory' was re-introduced into society, in its present form, by the CIA during the mid 1960s in order to create a means to control and inhibit public concerns over their involvement in the assassinations of President John F. Kennedy, Robert Kennedy. Dr. Martin Luther King, and Malcolm X. The term has since been used to corral in any other public concerns since that time by transforming the meaning into a pejorative which then inhibits the open debate of any topics which they need to control. Conspiracies are and have been a part of humanity's search for truth for thousands of years. Visit any construction site near you an you'll find them in terms of the misuse of funds or the use of foreign non-union workers. You introduce your own misunderstanding and bias into a very fine video on a completely different subject.
Awesome content, all of your vids are easy to understand complex concepts. Do you have any suggestions for me to upskill myself for data engineering not for the basics but designing efficient scalable pipelines, optimizing the overkill etc. Some professional courses or must read books ? I'd really appreciate!
I’m so glad you’re liking the videos. In the Indian culture it’s common for them to have gurus. Basically personal mentors, I think this is kind of a lost art but I think it really is the key to powerful insights that stick for a long time. My data management mentor passed away last year, which was really a blow for me. I’ve been lucky enough to be able to dip into an entire team of consultants, which has been probably the greatest asset that I’ve had. Of the technical books that I have read I kind of feel like they are either too zoomed in so that they become irrelevant quickly over time, or they are way way way too zoomed out so there’s no resolution as to how it’s applicable. I don’t know if you have kept up with our ProTalks, but we do those monthly and the “what’s new” section is always more than we can fit on the slide… the singularity is knocking on our door 🙃 In terms of data modeling, I would recommend a book called The Data Warehousing Toolkit. It’s an old book, but the concepts in it are rock solid when it comes to modeling data for business use. There are other data, modeling books and methodologies like Data Vault, which are definitely interesting for certain use cases.
@@Intricity101 Thank you so much for your answer! I'll keep up with ProTalsk, they seem very interesting as well. Also the book suggestions top notch! You're right I'm also looking for myself a mentor or a small community where I can learn and grow