How to create a conceptual model of a system? One of the most important task of an analyst is to turn the requirements provided by the client or user into a physical model. There are many methodologies to represent business rules that will be implemented in an information system. On this post we will use … Continue reading “Systems Modeling (part 1)”
Javascript Object Notation (JSON) is a standard text-based format to structure data based on Javascript object syntax. We can see this format being used to transfer data in web applications. { “firstName”: “Robert”, “lastName”: “Patrick”, “age”: 37, “address”: { “streetAddress”: “21, Glory Street”, “city”: “Boston”, “state”: “MT”, “postalCode”: “100-8888” }, “phoneNumbers”: [ { “type”: “home”, … Continue reading “C# – Load Json data in your .Net application”
You don´t ?! but you should! Colaboratory, or “Colab” for short, is a product from Google Research. Colab allows anybody to write and execute arbitrary python code through the browser, and is especially well suited to machine learning, data analysis and education. More technically, Colab is a hosted Jupyter notebook service that requires no setup … Continue reading “Python – Do you know Google Colaboratory ?”
In this exercise we will create a simple Web Application just to upload an excel file and send it to a python program. We will implement this solution to perform the steps described in the flowchart below. 1 – The user will upload a file to application 2 – The file will be sent to … Continue reading “C# – Create a website to upload an excel file and process it on a Python program.”
On this post we will do an exercise in which we will read data from an Excel file and insert this data into a SQL Server database table. Consider the situation in which you want open an excel file to perform some mathematical operations and after that insert the results into a database table. Note … Continue reading “Python – Inserting data from Excel file into Database table”
Let´s imagine a situation that you have a small market in which you have the inventory stored in a database table. In this table we have the date, the product code and the quantity available, but we don´t have the information for all days. The information in the tables refers only to the days the … Continue reading “SQL – Filling Gaps Between Dates”
Sometimes you have a lot of things to do, but you don´t have the means for that, so you will have to create your own means. We will apply this “philosophy” to present the data you have in your database, but you don´t have access to any reporting tool. In this case, we will create … Continue reading “C# – Create Your Own Report”
In this post we will work on a database connection using python. It´s very simple, let´s see how it works! Obviously you need the python installed on your system. For this exercise I am using verson 3.9.2. On the database side, we are using a table from Microsoft SQL Server with sales information. Although there … Continue reading “Python – Querying data from SQL Server”
Let´s say that you have a list of clients which you would like to insert into your database. If you don´t have access to an ETL Tool (such as Oracle Data Integrator, IBM DataStage, Microsoft Integration Services…) maybe it could look like a problem, but it’s not. You can use the BULK INSERT command to … Continue reading “SQL Server – Loading Data from csv file with BULK INSERT”
Different from the other SGBDs solutions, you can´t have a netezza instalation as easily as you can access the microsoft or Oracle site to download the latest database version. If you want to have a Netezza instalation you will have to spare a few hundreds of thousands dollars to acquire a server. While you don´t … Continue reading “IBM PureData – Create a Netezza environment on your computer”
