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’

3 years of IBI

February 23, 2020

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

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.