• Many businesses are confused by analytics terminology such as measures, metrics, and KPIs (key performance indicators). This confusion seeps into strategy documents, reports, and elsewhere, weakening communication lines within and between business units and leadership teams.
    Data management

    0 Comments

  • Types of databases and DBMS (with examples)

    by Mitchell Tweedie, Jun 26, 2018

    A DBMS is software for creating and managing databases. There are over 300 systems falling into 11 categories of organising data. Which is right for you?
    Data management

    0 Comments

  • 3 times spreadsheet databases ruined everything

    by Mitchell Tweedie, Jun 21, 2018

    You could write a book on all the times spreadsheets have done something dumb. You could even follow up with a sequel covering times humans did something dumb and their spreadsheet did nothing to stop them.
    Data management

    0 Comments

  • How to migrate from spreadsheets to a DBMS

    by Mitchell Tweedie, Jun 15, 2018

    Spreadsheets are databases, and they work well. Why would you ever want to leave a spreadsheet? Here’s a few reasons why; Database Management System (DBMS) can scale - spreadsheets don’t scale.
    Data management

    0 Comments

  • Databases vs spreadsheets: Excel, Access, MySQL

    by Mitchell Tweedie, Jun 11, 2018

    The world’s largest taxi company (Uber) owns no cars and the world’s largest hotel (Airbnb) owns no property. Traditional industries no longer rule the world, 1s and 0s do. Data is digital oil. Like oil, data calls for extracting and refining tools. Handle both with care.
    Data management

    0 Comments