pivotronics

Tag: ISO

• Data Literacy SQL

  Why is SQL one of the most powerful tools in the arsenal of an Analyst?

  Out of information analysis, comes wisdom. It’s this information analysis that is one of the important reasons that created the need for storage of data. The world of databases was sprouted to address this need of data storage and many languages were born to interact and deal with the data…

  February 24, 2020
• SQL

  Oracle SQL script to generate Date Dimension data for use in Microsoft Excel Data Models

  Date dimension is that one dimension or business perspective without which an Excel Data Model cannot ever exist. Here is an Oracle SQL script to generate the data for a Date Dimension. All that you have to do is change the start date and end date values in the in…

  November 14, 2016