IndividualBI New Templates and Video

IBI Templates

The IndividualBI or IBI Template has been updated recently, I have now included 3 new sheets in the template, the 3 new sheets are "Pivot Table", "Charts" and "Max and Min" sheets. For those who are not familiar with analyzing data, creating pivot tables, creating charts etc these sheets should help to get you started with analyzing and visualizing your data.

Also, additionally I have now made two versions of the template, Google Sheet version and MS Excel version. I hope this helps a lot of people. 

Google Sheet version can be downloaded from here : Individual BI Google Sheet Version

Excel version can be downloaded from here :  IndividualBI Excel Version 

I have tried to ensure that there are no errors in the formula, calculations etc, however as no one else has reviewed it there are chances that there are some mistakes/errors. If you find any errors please bring it to my notice and I will try to correct it ASAP.

IBI Videos

How to easily fill the IBI data capture sheet? Check out below video




For IBI Data Analysis and Visualization, check out below video



Now a playlist has been created for Individual Business Intelligence, all future videos related to IBI will be added to the playlist, IBI Playlist  . 


Comments

  1. Unknown10 April 2018 at 18:13

    So grateful to you dear Anoop for sharing this amazing idea. It will definitely help everyone to discover themselves based on facts. Thanks a Ton.

    ReplyDelete
  2. Anoop10 April 2018 at 23:19

    Thanks for the kind words Dipin. Please share it with your circle too, I think, whether people start using it immediately or not is secondary, they should at least be aware of this possibility.

    ReplyDelete

Post a Comment

Thanks for your comment. It will be posted after checks.

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 cour...
Read more