Jesper Lowgren
Jesper Lowgren
  • 36
  • 864 372
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
Переглядів: 223

Відео

Data Strategy Framework with Expert Insights on Data Democratization and Data Protection
Переглядів 3,2 тис.Місяць тому
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
Переглядів 7 тис.Місяць тому
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
Переглядів 4,5 тис.3 місяці тому
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!
Переглядів 8 тис.7 місяців тому
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
Переглядів 9 тис.7 місяців тому
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 - ua-cam.com/video/2HWPWgXJRlA/v-deo.html 00:00 - Start 01:10 - The Data-Driven Framework 03:03 - Industry Case Study
How to Become a Data-Driven Business !!
Переглядів 14 тис.9 місяців тому
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
Переглядів 13 тис.10 місяців тому
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
Переглядів 40 тис.Рік тому
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
Переглядів 12 тис.Рік тому
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
Переглядів 5 тис.Рік тому
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
Переглядів 28 тис.Рік тому
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!
Переглядів 31 тис.Рік тому
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 ua-cam.com...
How to Define a Minimum Viable Product (MVP) for Agile Success
Переглядів 15 тис.Рік тому
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
Переглядів 71 тис.Рік тому
Solution vs Enterprise Architecture Tutorial
Data Architecture vs Management vs Governance
Переглядів 21 тис.Рік тому
Data Architecture vs Management vs Governance
Customer Journey Mapping Aligned to Business Strategy
Переглядів 37 тис.2 роки тому
Customer Journey Mapping Aligned to Business Strategy
What does Thought-Leadership (vs Regurgitation) Look Like?
Переглядів 12 тис.2 роки тому
What does Thought-Leadership (vs Regurgitation) Look Like?
Business Architecture and Capability Mapping to Build Agile and Scalable Solutions
Переглядів 36 тис.2 роки тому
Business Architecture and Capability Mapping to Build Agile and Scalable Solutions
Customer Journey Mapping Tutorial
Переглядів 113 тис.2 роки тому
Customer Journey Mapping Tutorial
Customer Experience Strategy 2022
Переглядів 20 тис.2 роки тому
Customer Experience Strategy 2022
Business Model Canvas vs Lean Canvas
Переглядів 19 тис.2 роки тому
Business Model Canvas vs Lean Canvas
Database Normalization 5th Normal Form
Переглядів 19 тис.2 роки тому
Database Normalization 5th Normal Form
Digital Disruptive Forces in the Business Events Industry - What Now?
Переглядів 7552 роки тому
Digital Disruptive Forces in the Business Events Industry - What Now?
Capability Mapping Mastery in less than 15 minutes!
Переглядів 79 тис.2 роки тому
Capability Mapping Mastery in less than 15 minutes!
Database Normalization 1NF 2NF 3NF
Переглядів 150 тис.2 роки тому
Database Normalization 1NF 2NF 3NF
Pyramid Principle - The MECE Framework Explained - How To Turn Any Idea Into A Winning Pitch
Переглядів 9 тис.3 роки тому
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
Переглядів 9 тис.3 роки тому
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
Переглядів 8 тис.3 роки тому
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
Переглядів 3413 роки тому
To Disrupt, or not to Disrupt, that is The Digital Question DIG Festival Keynote Presentation

КОМЕНТАРІ

  • @kimchijam8720
    @kimchijam8720 4 дні тому

    quick and simple, nice

  • @One808
    @One808 5 днів тому

    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 6 днів тому

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

    • @JesperLowgren
      @JesperLowgren 6 днів тому

      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 6 днів тому

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

    • @thomaskaiser2475
      @thomaskaiser2475 5 днів тому

      @@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 5 днів тому

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

    • @JesperLowgren
      @JesperLowgren 5 днів тому

      @@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 7 днів тому

    Thaaaank you!

  • @realshinsa
    @realshinsa 8 днів тому

    thanks, and i have an exam on tuesday

  • @AJAJAJA662
    @AJAJAJA662 11 днів тому

    enlightening and educational

  • @frartenzo
    @frartenzo 14 днів тому

    jesper you are really an awesome teacher!

  • @user-wo2tk5ew9q
    @user-wo2tk5ew9q 15 днів тому

    Insightful

  • @FiremanSam60
    @FiremanSam60 19 днів тому

    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 20 днів тому

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

  • @shortslife4212
    @shortslife4212 20 днів тому

    interesting take on data migration. very helpful!

  • @canvas_gopi
    @canvas_gopi 20 днів тому

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

  • @bushairthayyil1946
    @bushairthayyil1946 20 днів тому

    Good explanation

  • @RajibChoudhury-qt2er
    @RajibChoudhury-qt2er 20 днів тому

    Jesper, will you do a video on data mapping?

  • @robertodecegliaspadavecchi1736
    @robertodecegliaspadavecchi1736 20 днів тому

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

  • @aleksandrsuvorov9632
    @aleksandrsuvorov9632 20 днів тому

    You have made data migration interesting, well done 👍!

  • @TrueMuslim242
    @TrueMuslim242 20 днів тому

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

  • @monjurulislam3191
    @monjurulislam3191 20 днів тому

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

  • @michelmamiherintsoarainian2923
    @michelmamiherintsoarainian2923 20 днів тому

    This is your best video so far Jesper

  • @UbedLaghari-bx8xq
    @UbedLaghari-bx8xq 20 днів тому

    Very informative 😄

  • @MDRASHID-cf1oi
    @MDRASHID-cf1oi 20 днів тому

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

  • @SadiaKhan-kt6ey
    @SadiaKhan-kt6ey 20 днів тому

    Makes perfect sense 🙌

  • @jaanzawi6367
    @jaanzawi6367 20 днів тому

    I never thought of data migration this way👍

  • @user-yk7vj8ch9c
    @user-yk7vj8ch9c 20 днів тому

    A data migranion strategy that makes sense!

  • @nasidyjean8022
    @nasidyjean8022 20 днів тому

    Please make a video on data transformation and data mapping

  • @victorsonde
    @victorsonde 22 дні тому

    Great explanation. Love it 👍

  • @dakshajmera9044
    @dakshajmera9044 23 дні тому

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

  • @elibedoya4058
    @elibedoya4058 24 дні тому

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

  • @not_nev
    @not_nev 27 днів тому

    thank you for real doc Jesper Lowgren Sheldon ❤

  • @Hillgrov
    @Hillgrov 28 днів тому

    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 Місяць тому

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

  • @yssplays2620
    @yssplays2620 Місяць тому

    THE BEST NORMALIZATION EXPLAINING EVER

  • @habbekratzz
    @habbekratzz Місяць тому

    Thanks Jesper

  • @UbedLaghari-bx8xq
    @UbedLaghari-bx8xq Місяць тому

    Amazing video 🙌🙌🙌

  • @sayandas1925
    @sayandas1925 Місяць тому

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

  • @ahmedd1w
    @ahmedd1w Місяць тому

    This is your best video so far Jesper

  • @ALMASUDRANA-ve5oo
    @ALMASUDRANA-ve5oo Місяць тому

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

  • @Rodrigo-of6lb
    @Rodrigo-of6lb Місяць тому

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

  • @daves4026
    @daves4026 Місяць тому

    awesome video thanks for sharing

  • @emansaadallah5808
    @emansaadallah5808 Місяць тому

    This video was exactly what I needed.You answered all my questions and cleared all my doubts.You are both great instructors 🙇‍♂️

  • @user-sy3tp2sb2y
    @user-sy3tp2sb2y Місяць тому

    I learned a lot about the differences between data democratization and data protection. Thanks for sharing! 👍

  • @Hinduboys952
    @Hinduboys952 Місяць тому

    Clear and informative! 👍

  • @mr.bizarre8740
    @mr.bizarre8740 Місяць тому

    Very interesting perspective on data democratization and data protection. It really helps me to understand about this topic much clear.

  • @dmitriyserg-
    @dmitriyserg- Місяць тому

    Thank you for this video 👏🏻👏🏻👏🏻

  • @kvelez
    @kvelez Місяць тому

    Thanks.

  • @ludmilaguzman7118
    @ludmilaguzman7118 Місяць тому

    enlightening and educational

  • @DoomMaster-ku3vf
    @DoomMaster-ku3vf Місяць тому

    A data migration strategy that makes sense!

  • @thesilencer3
    @thesilencer3 Місяць тому

    Wow, this video was an eye-opener. 🤯 Workable

  • @user-dh6px8ob1s
    @user-dh6px8ob1s Місяць тому

    keep them coming! A case study would be fantasti

  • @anowarabegum7780
    @anowarabegum7780 Місяць тому

    Thank you for this video Jesper and Louise. Well done ,