Introduction to database connections in Excel for efficient risk control – Part 4Part 4: How to insert data from an excel sheet into a database table In previous articles we discussed how to connect to the database and...
Basic Business Reporting with Tableaunot a step-by-step training, but rather an invitation to spend one afternoon exploring the new tool by yourself. This way you will not only
Introduction to database connections in Excel for efficient risk control - Part 3Part 3: Database connections in Excel – Tricks with Oracle In the article “Introduction to database connections in Excel for efficient...
Introduction to database connections in Excel for efficient risk control - Part 2Part 2: Creating dynamic queries in Excel with VBA In the last article, we introduced how to use the EXCEL interface to connect EXCEL...
Introduction to database connections in Excel for efficient risk control - Part 1Part 1: How to make automatic reports Introduction: Microsoft Excel and SQL database are the basic tools of data analysis. Regular tasks...