Experiments, tutorials and ideas on developing business intelligence solutions
In Australia we have weather information published on the BOM (Bureau of Meteorology) website, and as often needed we get the historical/forecast data-sets from this portal. One usually has few options around this: If the data requirement is one-off for any particular analysis or requirement Look for a download option on the portal (CSV usually) Read More …
JIRA is a great product, in numerous ways. But at times the pain of PM’s (Project Managers) is, they are unable to get the holistic view across multiple projects. This becomes more import when the resources are shared across numerous projects. So as problem defined above the solution that struck me was Just download the Read More …
Hi, This is my new article on the VSTS (Visual Studio Team Services) automation. VSTS is a popular and a very important tool in any organisation where by the developer can version their code, manage work, documentation relating the project and much more. Recently i wrote an article SQL – Backup Database Schema and SQL Read More …
Hi, In this post I would like to share the bulk insert methodology via C# rather than using SSIS. In the first place, why would i do that ??? Hmm… Well i cam across this situation when I am working with substantially large data-sets, the strategy to process them as fast as possible is to Read More …
Hi, When the data grows large, i mean really large one has to come up with ways to bring in techniques where even the slightest can make a difference. In this post I am going to share a technique where by when one is faced storing the large text data set, say receipts, articles which Read More …