Posts

Showing posts from November, 2019

1000 days of Individual BI

Image
For those who have been following my IBI (Individual Business Intelligence or Individual BI) journey I am very happy to announce that I have completed more than 1000 days of data capture. On 15th November, 2019 I completed 1000 days. I had started capturing data from 19th Feb 2017. Based on the analysis of own data I have found some interesting patterns, learnt a lot about myself, stopped myself from doing the same mistakes again, noticed changes in patterns, etc. The benefits that I get from Individual BI are way too many. And therefore I will definitely continue IBI as long as I am able to do it. I will be happy to conduct a session based on demand. Let me know. Some of the charts are provided below to give you an idea of the possibilities with own data captured in a structured way consciously. Gaps in the above chart are because there was no weighing scale on those days or weight was not measured on those days. 
Post a Comment
Read more

Before and Beyond Data Visualization

Image
Presenting at EU DataViz 2019, Luxembourg on 12th November was such an honour. Thanks to the Publication Office of the European Union for the opportunity. It was a great experience both in listening to other inspiring speakers and also to present the topic of "Before and beyond data visualization". In my talk, I used two examples; Individual Business Intelligence (Individual BI or IBI) and PublicBI EUProc solutions to talk about before and beyond data visualization sections respectively. It was interesting to note that there were many people who were interested in the IBI example than I had expected, and some also had questions about data security. If any organizations (companies, colleges, etc,) would like me to present the topic of Individual BI at their premises I will be more than happy to do that.  My slides are attached below, if there are problems with the pages below, use this link - https://drive.google.com/file/d/1vll-ugWPh6MoCwxqDj3Eo1d6BkcR
Post a Comment
Read more

Value of data

Image
On 15th of November, 2019 I completed 1000 days of Individual Business Intelligence (Individual BI or IBI).  Everybody says data is an asset. I say, the data I have about myself is priceless. But, I was just wondering  if I were to estimate the price of the data I have collected over last 1000+ days, how much would it be worth? I have 104 data points (ideas, mistakes, dreams, health, work, happy days, etc.) captured for over 1000 days. Let's consider 1 EUR per data point.  So 104000 EUR Time spent in filling IBI data capture sheet everyday until now (1014 days) = 110.8 hours So around 11000 EUR (assuming 100 EUR per hour) Time spent in analyzing data until now (1014) = 76.5 hours So around 7600 EUR  So in total it is minimum worth 104K+ 11K+ 7.6K = 122600 EUR Would I sell my data? I don't think so. Would I share my data for a good cause? May be some of it.  I think if data is an asset, then we should also put a
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

KABI - The new Agile Methodology for BI Projects - Implement BI projects quicker happily

Image
KABI is a new agile software development methodology useful for achieving quicker implementation of Business Intelligence (BI) solutions. The methods defined in KABI can also be used in full or in part for any other non BI projects that share similar characteristics as BI development projects.  The word KABI is created by combining "KA" from KA nban and "BI" from B usiness I ntelligence. KABI is a lightweight, iterative, continuous feedback based agile software development methodology that enables every team member to work to their full potential even when there are several unknowns, resource constraints, dependencies and unpredictability of work load. Thereby KABI ensures optimal team productivity throughout the project duration. At the heart of KABI is " Peer Inspiration ".  Every team member plays an important role and every team member works in an exemplary way. They do their part of the job so well that it inspires the whole team. " Mutual
Read more

BI Architect course and BI Tool question

Received two questions, 1 through LinkedIn and other through blogger. Sharing details of Q&A here for the benefit of wider audience. Question 1:  I want to start with a career in BI, and I am planning to get trained in it. The institute covers MSSQL, Power BI, MSBI, Tableau desktop 10, Informatica developer and admin, Azure data factory, SQL DBA, QLIK sense, Data warehousing. Is this all that is needed? Reply : Regarding getting into BI, the best way is to get into a team where you can learn from experienced people in the team. Regarding courses, just based on the list, that's quite a lot for a training, but it depends on what exactly is provided as part of the training. Need more details about the training. Then once the link was provided, I had a check and provided below reply. Note - Link or institute name is not shared here intentionally to avoid any confusion that I am promoting any institutes.  Reply :   I have had a look into the link, as a course for a b
Read more