Showing posts from 2017

Idea for new year resolution - IBI

In case anyone is looking for an idea for new year's resolution, I would like to suggest IBI (Individual Business Intelligence). You probably have tried to know yourself socially, religiously, spiritually, etc., and probably failed. Give a try to know yourself better factually with IBI.  For the past 313 days I have spent around 5 to 7 minutes every single day to capture data (quantitative and qualitative) about me, range of data points (dreams, ideas, movie time, work hours, family time, health, etc.) that I think are important to me.  Have I made lot of money with this? No, in fact I make 40% less money than I used to make after I switched to part-time work.  If money is the only thing that drives you, this won't make much sense.  I have this feeling that everything is connected but we don't see the connections, the deeper we go, the more connections we will see.  I don't want to bore you with my personal data, but at the same time I want to create awaren

Business Intelligence Jobs, skills and tools analysis report

Independent, unsponsored and unbiased exploration and analysis of current trends in business intelligence jobs, skills and tools in demand based on reliable, verifiable and real BI job requirements. Several days of hard work (with passion, without obligation and hence very joyful), and lots of learning in the process. And business intelligence jobs, skills and tools analysis report published today. Full report available on Reportpedia   for free download.  Happy holidays and happy reading.

KABI webinar invite

Agile software development team? bored of stand-ups? do you feel stand-up has become more of an attendance marker? Give DDAS (Daily demo and sync-up) a try, see  KABI for details.  First public KABI introductory webinar on 14th December 3 PM CET,  if interested join online meeting at, no registration required.

Best Report Contest - Looking for Data or BI enthusiasts

Reportpedia requires 2 more volunteer data or BI enthusiasts to be part of the best report selection committee to carry out totally unbiased review and selection in the first of its kind report contest Contact me if you are interested or share with people who you think would do justice to this role. Participants cannot be in the committee in the month they are participating.

Best Report Contest

Reportpedia has launched first of its kind contest, a series of monthly best report contest starting from Dec 2017. Every month there will be a winner (best report of the month) who will get recognized, win prizes including cash prizes. Also, a chance to win the mega prize Best Report of the Year.  For more details check out the Best Report Contest page. Analyze publicly available data, share information and insights with worldwide audience, help someone out there get curios about a topic or force them to think. Get recognition, win prizes and enter winners' photo gallery.

Want to become a volunteer?

Passionate about business intelligence and data? Want to do something more during your spare time? Become a volunteer. For more details and FAQs please visit .  You may also share it with your friends, colleagues or family members who are not into BI, who knows? they may even develop an interest for BI and Data. Partial screenshot below.

Datainformability - Latest entry into NFR

Datainformability   - The ease with which information can be derived from data should go into the list of important non-functional requirements (NFR) along with other NFRs' like availability, maintainability, security, etc. Goal should be to reduce the time taken to derive information from data to the minimum possible, of course conforming to all functional and other NFRs, while designing any application. Data is an important asset because we can derive information from it. So datainformability should be given its due importance i.e., every application should store data in a way that it is easy to derive information, instead of passing the responsibility to downstream applications. Some of the points (non-exhaustive) to be considered are Are we storing data including metadata? Storing enough and correct data? Is it easy to extract data? Easy to detect changes and extract only incremental data? Easy to analyze data? Are we standardizing data within the applic

IBI in less than 10 minutes

As promised to my friends, here is the shorter version of the IBI video

IBI webinar video

The IBI webinar video streamed live on 8th September, 2017 is here

IBI webinar preparation and invite

How many ideas? How many of them materialized? How many happy days? How many dreams? and many more questions like these. Individual Business Intelligence (IBI) answers (or at least tries to answer) all of these with real data. In preparation for tomorrow's free webinar on IBI , I started carrying out some basic data analysis and visualization  on the  6+ months data (own and self accumulated data). While sharing of results is not required I have still shared it to give an idea about possibilities. Some results are published here in the IBI forum . Those interested to know more about IndividualBI please join the live webinar tomorrow (refer PublicBI for details on webinar ). Searching for full article about IBI?  see IBI

IBI webinar invite

Posted in Linkedin ( Sep 2017) as part of the invite for the IBI webinar. Based on the current trend in #data accumulation and usage of data, it looks like the day is not far when 1) There will be state and central ministers for data like we have ministers for coal, petroleum etc.  Data is an important asset not just for commercial businesses but  for a nation too. Does any country already have this (not talking about statistics department)? 2) Companies  will be taxed based on the amount of data accumulated. And companies will add data in the assets column in the balance sheet. Any company already adds data as an asset in the balance sheet? 3) Rich kid or poor kid is determined by the amount of high quality data the kid inherits from his/her parents. 4) Self-reflection is done with consciously captured own data. For the first 2 points I have nothing more to add at the moment. If you are interested in the 3rd and 4th point then join my public webinar on "

Why big data is actually small?

Posted an article with full details in Linkedin see Why big data is actually small? "Compared to the Universe anything and everything is very small" , wait I am definitely not going to use that line as a supporting point to present my point of view on why the so-called big data (#bigdata) is actually small. It's just a reminder of the fact that me, you, us, planet earth and this whole solar system is so tiny compared to the Universe and we shouldn't be making things look bigger than it really is . To say in other words we shouldn't be giving something more importance than it actually deserves. For those, who don't have the time (10 minutes) or patience to read the whole article, the reality and the gist is, big data is just a subset of data , a subset cannot be bigger or larger than the whole. No matter how big or large or complex big data is, it has to be smaller, less complex than data. Data is an asset , one of the most important asset in

Looking at Data is also an art

Looking at Data is also an art  posted in Linkedin. For some of us, when we look at a painting we cannot appreciate it, we cannot connect to it, we just ignore it and move on. And for some of us, we like its appearance, its colour, composition, frame, presentation and the image that it creates in our minds, we like it, we may appreciate the person who has created it, we may even share it, but it ends there. And then there are those very few people, who can passionately spend hours looking at the same painting, that we glanced for a second or so, and are able to decipher the hidden story behind the painting, discover multiple stories looking at it from various points of view, appreciate the finer details, get motivated and inspired by it, learn from it and use the learning to improve whatever they are doing. What and how much we comprehend from a painting depends on our experience and the way we look at it . From my point of view this is exactly the same story when we look at data .

BI Jobs in Germany - Tips and Templates

Many job seekers requested for tips about how to find and apply for BI jobs in Germany. So I felt there was a real need to provide pointers to job seekers. Here is a list of tips and couple of templates that I think could be useful for your Business Intelligence (BI) job search in Germany and hopefully you get your dream job. Some of the points could be applicable for other jobs too and not just limited to business intelligence jobs, However, I do not have experience in other areas or sufficient knowledge to confirm this. Before I start with my list of tips I would like to bring your attention to these disclaimer points below.  Disclaimer: All points here are my own views and it does not represent the views of my current or previous employers or any of my clients. This is based on my 10+ years of BI experience, which includes several years of experience both as an interviewer and an interviewee, experience of reviewing hundreds of CVs and around 5 years of living and working

Launched was launched in the early hours of 9th July 2017. To mark the launch an article ( - BI Jobs World Wide ) was posted on LinkedIn. 

Business Intelligence Tools

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.

DWH Development related Survey results

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

Public Data Warehouse

Vision Build Public Data Warehouse, i.e. world's best and biggest data warehouse to serve general public throughout the world. Details Public Data Warehouse (PublicDW) Public Data Warehouse, a data warehouse built by PublicDW community and used by users across the world. I believe, PublicDW has the potential to become the world's best and biggest data warehouse. Biggest because PublicDW will not be limited by data stored in it by products/subject areas/departments /enterprises/organizations and it will not be limited to use by any specific group but be available for general public across the world. And it is one of the biggest challenges. Best because it will be developed with the best practices, best technologies and best tools and methods.  Currently, there is no data warehouse that a global community can build and users around the world can use. AFAIK and based on my quick search this will be the very first attempt to achieve something like this. Data w

Discover yourself factually with Individual Business Intelligence (IBI) - BI for Everyone

Companies like Facebook, Google and Amazon are trying very very hard to accumulate data about you at every touchpoint, with this accumulated data they want to know more about you, so that, in short, they can sell more to you and the circle you influence. Yes, there is nothing wrong in that, it's their business and they want to improve their business by providing better services and better products. These successful and popular companies and many other companies have realized quite some time back that data is the new gold/new oil/new money, i.e. d ata is an asset. In contrast, have you as an individual ever imagined about you consciously accumulating data about yourself? data related to your physical/mental/emotional statuses, your activities, your life experiences and events in your life? Have you considered your own accumulated data as an asset to you and to your children?  Why accumulate data? But why should you consciously accumulate data about yourself and why should y

Popular posts from this blog

ETL developer vs Data engineer

3 years of IBI