Jesper Lowgren
Jesper Lowgren
  • 36
  • 885 093
Data Profiling Explained in Under 5 Minutes! - with templates
Data profiling involves analyzing and summarizing a dataset's characteristics to understand its structure, quality, and content. It is a fundamental building block for other data activities, like cleansing and transformation.
00:00 - Start
00:29 - Use-Cases
01:10 - Data Profiling
01:22 - Data Structure Profiling
01:52 - Data Quality Profiling
03:00 - Data Profiling Process
03:08 - Step 1: Collect Data
03:20 - Step 2: Understand Data Structure
03:27 - Step 3: Explore Data
03:48 - Step 4: Analyze Data Quality
Data Profiling Report Template: www.dropbox.com/scl/fi/14nvdvfripoet9zo81lzb/Data-Profiling-Report-Template.docx?rlkey=mq3gawe38vi2f59zx02hrx3cl&st=5jhkf8a1&dl=0
Data Structure Report Template: www.dropbox.com/scl/fi/uw5pwkr41rzednnjnxaz6/Data-Structure-Review-Report-Template.docx?rlkey=a0oyydcgkp9sntqb9feq3lage&st=falony4t&dl=0
#datacleaning #datacleansing #datamigration
zhlédnutí: 295

Video

Data Strategy Framework with Expert Insights on Data Democratization and Data Protection
zhlédnutí 3,2KPřed 2 měsíci
Data strategy is a misunderstood yet critical capability to thrive in the digital world. In this video, part 2, Jesper Lowgren and Louise Davey expand on the DALO data strategy framework by unpacking the Data Democratization and Data Protection capabilities. DALO is a modern and purpose-built digital strategy framework, developed specifically to guide organisations through a digital and data wo...
The Four Success Factors of Data Migration
zhlédnutí 7KPřed 2 měsíci
Data migration is one of the key reasons digital transformation fails. This video unpacks four key factors for data migration success. Three are well-known, but the fourth is poorly understood and critical for success. 00:00 - Start 00:15 - Introduction 01:04 - Data Migration Definition 01:55 - Source Data Quality 03:10 - Current State Data Model 03:59 - Target State Data Model 04:57 - Process ...
Game-Changing Data Strategy Framework with Expert Insights
zhlédnutí 4,6KPřed 4 měsíci
Data strategy is misunderstood yet one of the most critical capabilities to thrive in the digital world. In this video, Jesper Lowgren and Louise Davey present a new data strategy framework, DALO, developed specifically to guide organisations through a digital and data world infused with AI. #DataStrategy #DataManagement #DataGovernance 00:00 - Start 02:04 - A New Data Strategy Framework 02:56 ...
Speak Like A Consultant - 8 Technology Terms Unpacked!
zhlédnutí 9KPřed 7 měsíci
This video unpacks the 8 most common technology terms and explains how to apply them and use them correctly. 00:00 - Start 00:14 - Introduction 01:14 - Common Misused Terms 01:55 - The System 02:48 - The Architecture 03:37 - The Model 04:14 - Quiz 1 05:01 - The Framework 05:34 - The Methodology 06:11 - The Design 06:26 - The Blueprint 06:50 - Quiz 2 07:17 - The Infrastructure 07:35 - CRM Exampl...
How to Become a Data-Driven Business !! - part 2
zhlédnutí 9KPřed 8 měsíci
This video addresses one of the most talked about, and least understood, topics of today: How to Become Data-Driven. In part 2, we share a data-driven assessment and an industry case study. In part 1, we shared a data-driven and a data-driven framework - czcams.com/video/2HWPWgXJRlA/video.html 00:00 - Start 01:10 - The Data-Driven Framework 03:03 - Industry Case Study
How to Become a Data-Driven Business !!
zhlédnutí 15KPřed 10 měsíci
In this video, Dr Haibo Yang and I explore one of the most talked about, and least understood, topics of today: How to Become Data-Driven. In part 1, we will share the nature of being data-driven and a data-driven framework. In our next video, part 2, we will share a data-driven assessment and an industry case study. 00:00 - Start 00:08 - Intro 01:09 - Data-Driven Definition 03:20 - Data-Driven...
Unlock your Data with Microsoft Fabric
zhlédnutí 13KPřed 10 měsíci
Microsoft Fabric is a new data offering, based on OneLake, to connect all of an organisation's structured, semi-structured and unstructured data, to take an organisation to the next level. In this video, produced on behalf of DXC, I am discussing OneLake, structured, semi-structured and unstructured data with Dr Haibo Yang. 00:00 - Start 00:08 - Introduction 01:02 - Microsoft Data Strategy 02:0...
Data Warehouse vs Data Lake vs Data Lakehouse
zhlédnutí 42KPřed rokem
New technologies like the Data Lakehouse is fuelling the AI revolution well beyond ChatGPT. It provides organisations with the ability to combine all its data, structured, semi-structured and unstructured for reporting, business intelligence and predictive analytics, using tools and techniques such as machine learning.
Simplification Framework for Digital Transformation
zhlédnutí 12KPřed rokem
This video goes into the heart of digital and business transformation by looking at the true reasons why more than 70% of transformations fail. It introduces the Simplicity-Complexity theory that provides an approach for simplifying the complex, which is essential because complexity doesn't scale. 00:00 - Start 00:11 - Intro 03:36 - Simplicity-Complexity Theory 05:14 - Tools of Navigation 06:43...
ChatGPT Misunderstands The Microservices Architecture
zhlédnutí 5KPřed rokem
Microservices are a hot technology topic, but can they be used for everything? This video examines microservices, what they are and how they work, and consults ChatGPT on when to use, and not to use them. 00:00 - Start 00:28 - Intro 01:08 - Microservices vs SOA 01:28 - Monolithic vs Microservices 01:47 - Explanation of Microservices 05:07 - Microservices Decision-Matrix 06:27 - Design Patterns ...
Operating Model Design in Successful Digital Transformation
zhlédnutí 30KPřed rokem
The operating model is often overlooked when organisations transform, resulting in new technology running old business processes. This video explains the concepts behind an operating model and why a target operating model is critical to successful business transformation. 00:00 - Start 00:15 - What Problems Are We Trying To Solve? 01:52 - What is an operating model? 03:47 - How does it work? 07...
How To Build an IT Capability Model - Framework and Source Files Included!
zhlédnutí 31KPřed rokem
This video describes how to build an IT capability model without a business capability model, using a business operating model. The IT capability model framework is included both pdf and source files. 00:00 - Start 00:10 - Introduction 02:31 - The IT Business Capability Model Template 06:54 - The Current State Capability Assessment 07:45 - The Future-State Capability Assessment Links czcams.com...
How to Define a Minimum Viable Product (MVP) for Agile Success
zhlédnutí 15KPřed rokem
One of the hardest things to do, and perhaps the most important success factor for agile success, is to define a minimum viable product. This video outlines the four critical success factors that few understand or talk about. 00:00 - Start 00:34 - Background of Agile 02:11 - Anatomy of Agile 03:15 - The Minimum Viable Product 05:38 - The Bane of Exceptions 07:23 - The MVP Mindset Change #AgileM...
Solution vs Enterprise Architecture Tutorial
zhlédnutí 74KPřed rokem
Solution vs Enterprise Architecture Tutorial
Data Architecture vs Management vs Governance
zhlédnutí 22KPřed 2 lety
Data Architecture vs Management vs Governance
Customer Journey Mapping Aligned to Business Strategy
zhlédnutí 38KPřed 2 lety
Customer Journey Mapping Aligned to Business Strategy
What does Thought-Leadership (vs Regurgitation) Look Like?
zhlédnutí 12KPřed 2 lety
What does Thought-Leadership (vs Regurgitation) Look Like?
Business Architecture and Capability Mapping to Build Agile and Scalable Solutions
zhlédnutí 37KPřed 2 lety
Business Architecture and Capability Mapping to Build Agile and Scalable Solutions
Customer Journey Mapping Tutorial
zhlédnutí 115KPřed 2 lety
Customer Journey Mapping Tutorial
Customer Experience Strategy 2022
zhlédnutí 20KPřed 2 lety
Customer Experience Strategy 2022
Business Model Canvas vs Lean Canvas
zhlédnutí 19KPřed 2 lety
Business Model Canvas vs Lean Canvas
Database Normalization 5th Normal Form
zhlédnutí 19KPřed 2 lety
Database Normalization 5th Normal Form
Digital Disruptive Forces in the Business Events Industry - What Now?
zhlédnutí 758Před 2 lety
Digital Disruptive Forces in the Business Events Industry - What Now?
Capability Mapping Mastery in less than 15 minutes!
zhlédnutí 81KPřed 2 lety
Capability Mapping Mastery in less than 15 minutes!
Database Normalization 1NF 2NF 3NF
zhlédnutí 155KPřed 3 lety
Database Normalization 1NF 2NF 3NF
Pyramid Principle - The MECE Framework Explained - How To Turn Any Idea Into A Winning Pitch
zhlédnutí 9KPřed 3 lety
Pyramid Principle - The MECE Framework Explained - How To Turn Any Idea Into A Winning Pitch
The Pyramid Principle - The SCQA Formula to Turn Any Idea into a Winning Pitch
zhlédnutí 9KPřed 3 lety
The Pyramid Principle - The SCQA Formula to Turn Any Idea into a Winning Pitch
Data Architecture: Data-Driven Design for Scale and Automation - Part 2
zhlédnutí 9KPřed 3 lety
Data Architecture: Data-Driven Design for Scale and Automation - Part 2
To Disrupt, or not to Disrupt, that is The Digital Question DIG Festival Keynote Presentation
zhlédnutí 343Před 3 lety
To Disrupt, or not to Disrupt, that is The Digital Question DIG Festival Keynote Presentation

Komentáře

  • @hinaque4505
    @hinaque4505 Před 3 dny

    Loved the video and the analogy, Thanks from Australia.

    • @JesperLowgren
      @JesperLowgren Před 2 dny

      And a big thank you from Australia (Melbourne)!

  • @jorgecalderon7369
    @jorgecalderon7369 Před 5 dny

    Thanks Jesper for explain and bring to us these knowledge, and also for make easier to understantd this subject.

  • @paulctx
    @paulctx Před 6 dny

    I like the video but the comment section seems ..uh.. "sus".

  • @SyncCryo
    @SyncCryo Před 8 dny

    Can I send you a look at a moderation page I want to create but am unsure how to normalise correctly?

    • @JesperLowgren
      @JesperLowgren Před 7 dny

      Of course 😄!

    • @SyncCryo
      @SyncCryo Před 7 dny

      @JesperLowgren Awesome! How can I contact you so I can send my draft of the page?

    • @JesperLowgren
      @JesperLowgren Před 7 dny

      @@SyncCryo jlowgren at outlook.com

    • @SyncCryo
      @SyncCryo Před 6 dny

      @@JesperLowgren Great! I've dropped you an email.

    • @SyncCryo
      @SyncCryo Před 4 dny

      @JesperLowgren Thank you! I've sent you the draft moderation page. Let me know when you can take a look 🙏

  • @Barbara__y8a9
    @Barbara__y8a9 Před 9 dny

    Stay ahead of the game with an exclusive interview featuring Binance’s CEO on future developments

  • @FrozenFlames243
    @FrozenFlames243 Před 11 dny

    Bro is right on spot no BS pure inflammation subscribe we need more of this, mf just nailed entire data storage in 9 minutes that is perfection.

  • @Aradhyafouzde4
    @Aradhyafouzde4 Před 13 dny

    I am changing my slides for a cto presentation... awesome explanation

  • @trudie8341
    @trudie8341 Před 15 dny

    This is 100%

  • @lubapeace9151
    @lubapeace9151 Před 17 dny

    Thank you Jesper for your analogy of data lake vs warehouse using IKEA!

  • @abravictech
    @abravictech Před 17 dny

    👌

  • @iwuce101
    @iwuce101 Před 25 dny

    Arguably one of the most inciteful videos on CZcams. Very clear explanations

  • @kimchijam
    @kimchijam Před měsícem

    quick and simple, nice

  • @One808
    @One808 Před měsícem

    The video mentions a PDF that has descriptions of each capability, but the link is to a PNG. And the Archimate file doesn't appear to hold any descriptions either. Am I missing something?

  • @thomaskaiser2475
    @thomaskaiser2475 Před měsícem

    Can a PK have a relationship with its FK counterpart in more than one table?

    • @JesperLowgren
      @JesperLowgren Před měsícem

      Yes it can! For example, a Contact with PK contact_id can be an FK in both a Leads table and an Opportunity table.

    • @thomaskaiser2475
      @thomaskaiser2475 Před měsícem

      @@JesperLowgren wow thanks a lot! I had such a hard time and conflicting information on that as a 2 week old initiate.

    • @thomaskaiser2475
      @thomaskaiser2475 Před měsícem

      @@JesperLowgren Now i just need to know what those diagrams with the Diamonds and rectangles and bubbles and numbers is called so i can find out what they mean. Im just starting the textbook: Fundamentals of Database Systems Seventh Edition.

    • @JesperLowgren
      @JesperLowgren Před měsícem

      @@thomaskaiser2475 my pleasure, I get excited when others get value from my videos 😄.

    • @JesperLowgren
      @JesperLowgren Před měsícem

      @@thomaskaiser2475 I had a quick look and the book seems to use several notations, including UML (which is object modelling, not data modelling). Data modelling is based on the concept of a one-to-many relationship, which can be described using different notations. I used the crowfoot notation in the video.

  • @markkevnjflores
    @markkevnjflores Před měsícem

    Thaaaank you!

  • @realshinsa
    @realshinsa Před měsícem

    thanks, and i have an exam on tuesday

  • @AJAJAJA662
    @AJAJAJA662 Před měsícem

    enlightening and educational

  • @frartenzo
    @frartenzo Před měsícem

    jesper you are really an awesome teacher!

  • @user-wo2tk5ew9q
    @user-wo2tk5ew9q Před měsícem

    Insightful

  • @FiremanSam60
    @FiremanSam60 Před měsícem

    I'm confused...how does "A capability" describe what an organisation does? Is a capability not an attribute that enables an organisation to do what it does?

  • @mahmoudismail8776
    @mahmoudismail8776 Před měsícem

    this video was exactly what i needed . you're great instructor

  • @shortslife4212
    @shortslife4212 Před měsícem

    interesting take on data migration. very helpful!

  • @canvas_gopi
    @canvas_gopi Před měsícem

    how did you edit the video? which tool did you use to create this beustiful video?

  • @bushairthayyil1946
    @bushairthayyil1946 Před měsícem

    Good explanation

  • @RajibChoudhury-qt2er
    @RajibChoudhury-qt2er Před měsícem

    Jesper, will you do a video on data mapping?

  • @robertodecegliaspadavecchi1736

    thank you for this video. you made data migration interesting and understandable. I appreciate your effort and expertise

  • @aleksandrsuvorov9632
    @aleksandrsuvorov9632 Před měsícem

    You have made data migration interesting, well done 👍!

  • @TrueMuslim242
    @TrueMuslim242 Před měsícem

    Wow, this is the most interesting video on data migration I've ever seen.

  • @monjurulislam3191
    @monjurulislam3191 Před měsícem

    a must- watch video for anyone who works in data migration

  • @michelmamiherintsoarainian2923

    This is your best video so far Jesper

  • @UbedLaghari-bx8xq
    @UbedLaghari-bx8xq Před měsícem

    Very informative 😄

  • @MDRASHID-cf1oi
    @MDRASHID-cf1oi Před měsícem

    This video is a true thought- leadership! Outstanding!🎨,

  • @SadiaKhan-kt6ey
    @SadiaKhan-kt6ey Před měsícem

    Makes perfect sense 🙌

  • @jaanzawi6367
    @jaanzawi6367 Před měsícem

    I never thought of data migration this way👍

  • @dearvp
    @dearvp Před měsícem

    A data migranion strategy that makes sense!

  • @nasidyjean8022
    @nasidyjean8022 Před měsícem

    Please make a video on data transformation and data mapping

  • @victorsonde
    @victorsonde Před měsícem

    Great explanation. Love it 👍

  • @dakshajmera9044
    @dakshajmera9044 Před měsícem

    This man seriously doesn't blink at all !!! Am I the only one who noticed this ??

  • @elibedoya4058
    @elibedoya4058 Před měsícem

    very clear information. It helped me a lot with my marketing assignment. Thank you!

  • @not_nev
    @not_nev Před měsícem

    thank you for real doc Jesper Lowgren Sheldon ❤

  • @Hillgrov
    @Hillgrov Před měsícem

    Why do every book and online resources have different definitions and rules for the normalization forms.. I've just watched 3 videos and read 2 articles.. none of them are in agreement.

  • @user-mj4py2zr9q
    @user-mj4py2zr9q Před měsícem

    This video is a true thought-leadership! Outstanding! 🎨.

  • @yssplays2620
    @yssplays2620 Před měsícem

    THE BEST NORMALIZATION EXPLAINING EVER

  • @habbekratzz
    @habbekratzz Před měsícem

    Thanks Jesper

  • @UbedLaghari-bx8xq
    @UbedLaghari-bx8xq Před 2 měsíci

    Amazing video 🙌🙌🙌

  • @sayandas1925
    @sayandas1925 Před 2 měsíci

    This video is a true thought-leadership! Outstanding! 🎨

  • @ahmedd1w
    @ahmedd1w Před 2 měsíci

    This is your best video so far Jesper

  • @ALMASUDRANA-ve5oo
    @ALMASUDRANA-ve5oo Před 2 měsíci

    thank you for this video. you made it easy to follow and interesting. I appreciate your effort and expertise

  • @Rodrigo-of6lb
    @Rodrigo-of6lb Před 2 měsíci

    Masterful, do you think it possible to ask me to share the presentation

  • @daves4026
    @daves4026 Před 2 měsíci

    awesome video thanks for sharing