Converting IRS Form 990 XML to text and Excel

Uli Bethke Flexter, XML

In 2016, the IRS released data in electronic form to the nonprofit sector. Each of these files, contains data about nonprofit finance and more. You can get all that data from Amazon Web Services ( AWS). Researchers could now analyze data without time and the cost-consuming process of converting paper records to digital records by manual data entry or Optical ...

Oracle SQL Developer Data Modeler with Snowflake

Federico Sicilia Oracle, Snowflake

Why Oracle SQL Data Modeler Oracle Sql Developer Data Modeler (SDDM) is a free-to-use data modeling tool born to support developers while designing their database, or architecture, at a logical, relational or physical level, even storing and versioning changes in an easy and comprehensible way. However, if you are a data engineer, then you might have already used it at ...

The future of ETL and the limitations of data virtualisation and NoETL.

Uli Bethke ETL

Data has limited value if we don’t transform, integrate, model (either data modelling and building predictive models) or cleanse it. Collecting raw data for no apparent reason or business case leads to the widespread data hoarding disorder. The concept of NoETL and related ideas of data federation for logically integrating data from disparate data stores (now rebranded as data virtualisation) ...

Sampling in Snowflake. Approximate Query Processing for fast Data Visualisation

Martin Goebbels Snowflake

Introduction Making decisions can be defined as a process to achieve a desirable result by gathering and comparing all available information. The ideal situation would be to have all the necessary data (quantitatively and qualitatively), all the necessary time and all the necessary resources (processing power, including brain power) to take the best decision. In reality, however, we usually don't ...