Search This Blog

Business Intelligence

Improving lives with Business Intelligence

Home
BI
Reportpedia
IBI
KABI
Anoop

More…

IBI webinar video

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

September 09, 2017

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

IBI

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

ETL developer vs Data engineer

May 16, 2020

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’

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

September 25, 2016

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

7th year of IBI starts today

February 19, 2023

Completed 6 years of IBI and started 7th year of IBI, hopefully continuing it forever.

All views/opinions expressed represent my own and not of my previous or current employers, clients or partners.

Powered by Blogger

Theme images by Dizzo

The views/opinions expressed represent my own and not of my previous or current employers/clients

Business Intelligence Demystified is available now

ETL developer vs Data engineer

May 16, 2020

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’

Best ETL Tool Survey Nov 2016 Results

December 18, 2016

Please find below the results of the best ETL tool from a developer's perspective survey carried out between 1st Nov 2016 till 16th Dec 2016. Survey link was shared on LinkedIn and on this site. Thanks to all those DWH/BI developers who took part in this survey. Also thanks to all the members in LinkedIn groups like Data Warehousing (Business Intelligence, ETL) Professional's Group who provided their inputs via comments. Results from the Survey Results based on comments in LinkedIn, as of 18th Dec 2016 is given below Survey Result Analysis 425 responses were collected through the survey between 1st Nov 2016 and 16th Dec 2016. Informatica is the most popular and the best ETL Tool from a developer's perspective based on the survey results. Out of those respondents who have experience in multiple tools including both DataStage and Informatica, 20% consider DataStage as the best and 46% consider Informatica as the best ETL tool. Out of tho

BI Architect course and BI Tool question

April 25, 2020

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

Corona Virus Analytics

March 19, 2020

This is an interactive dashboard that can be used to find trends, patterns and eventually insights related to COVID-19 (Corona Virus) from a reliable data source. Additional notes provided below the dashboard. Direct link to the Google Data Studio Dashboard is here - https://datastudio.google.com/u/0/reporting/2e4f9914-8905-4cc9-b36a-75dc3f220438/page/7JbY Best viewed on desktop/laptop Notes : This is an interactive dashboard that can be used to find trends, patterns and eventually insights related to COVID-19 (Corona Virus) You can use the filters on the top or click on the charts to filter. Feel free to embed the dashboard in your websites (of course for non commercial use). Currently dashboard doesn’t have real-time information. There is a delay of about 24 hours as the data is mainly sourced from https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data ( 2019 Novel Coronavirus COVID-19 (2019-nCoV) Data Repository by Johns Hopkins CSSE). For some o

RAG Viz added to covid-stats.de

April 28, 2020

The RAG (Red, Amber, Green) visualization (image 1) is now also added to the covid-stats.de dashboard (page 2). It provides some more interesting information. It provides a quick overview of cities/towns that are coming out of COVID-19 and those that are nearing the end of COVID-19 situation within Germany. By clicking and selecting the bundesland it filters out (image 2) to display the cities/towns of that particular bundesland. Using the optional metrics (icon on the top right of the map) one can also get information about last 5 days total cases (image 3), last 5 days average % change, etc.