Posts

Showing posts from June, 2017

Business Intelligence Tools

Image
Did you ever want a full list of up-to-date business intelligence tools? I wanted that, but I couldn't find one central place on the web that lists all (or at the least most) of the business intelligence (BI) tools. Most of the sites either focus on one aspect of BI or are partial or list only popular tools or are biased. So I decided to create one central place where all of the BI tools can be listed alphabetically without any bias. This page is now added to the PublicDW project space. This is still work in progress but I think this is a good start, and with help of the community members in the future we should be able to keep this page up-to-date so that everyone benefits. Link is here Business Intelligence Tools . Currently it looks like this (below image), But please check the Business Intelligence Tools for up-to-date list and important notes.
2 comments
Read more

DWH Development related Survey results

Image
Please find below the results of DWH development related survey carried out between Dec 2016 till May 2017. Thanks to all those DWBI professionals who took part in this survey. Unfortunately we do not have many responses, We have only 48 responses even after extending the survey till May 2017 ( it was supposed to end in Jan 2017). Survey Results Survey results summary Total of 48 responses (including 1 own response) Agile is the preferred methodology of development Kimball approach (Bottom up) preferred over Inmon  approach (Top Down) Star Schema preferred over Snow flake Again thanks to all those DWBI professionals who took part in this survey. Currently open survey -   Best Version Control System for Data Warehouse Projects
Post a Comment
Read more

Popular posts from this blog

ETL developer vs Data engineer

Image
Rephrased question : ETL developer vs Data engineer Answer : Unfortunately there are no strict industry standards on these job titles. That is just one part of it. Before ETL tools such as DataStage, Informatica, Ab Initio, etc., became popular, developers were hand coding every ETL flow. These ETL tools shortened the ETL flow development time to a great extent and allowed ETL developers to focus on business rule/logic/requirement (what to implement) than how to code it or optimize the code. There are many other benefits of using a tool but I won’t go into that in this answer. So an ETL developer with experience in these tools without any programming (coding) experience was/is able to design and develop end to end data flows. Whenever new types of source/target data format comes up, these tools catch up but it takes time, i.e., the ETL tool provider (e.g. Microsoft, IBM, etc.,) adds new components/connectors within the ETL tool to be able to work with new data format. For example, let’
Read more

3 years of IBI

This week (on 19th Feb 2020) I completed 3 years of IBI. To celebrate it I have created a Dashboard in Google Data Studio. So from now on instead of using the charts in the Google Sheets I will use the Dashboard. Google Data Studio is more user friendly and mobile friendly too, also it comes with easy to use filters and drill down/up capabilities. PDF version of the first 2 pages of the shareable dashboard is attached below. I am happy to share the first 2 pages of the IBI Dashboard, reach out to me if you would like to get the Google Data Studio IBI dashboard. Once you get the dashboard (without my data of course) you can make a copy of it and point it to your IBI data (assuming you have started), add more charts, pages, etc., and use it for your benefit. Like with every year, this IBI year too I have learnt a lot about myself, made new mistakes, changed several things about me. The benefits of IBI is much more than we can think of. Use it to know it. And what are some of the
Read more