Business Intelligence challenges

These are the list of challenges faced by BI teams. Not a comprehensive list, but just the points that are right off the top of my head
  • Data quality issues.
  • Lack of source applications/systems knowledge.
  • Lack of executive sponsorship and continuous support.
  • People at the top not having longer term vision.
  • BI tools selection.
  • Source system changes without/late communication to BI Teams
  • Lack of funding to BI teams compared to core development teams.
  • Silos of BI teams
  • First deliverable (ex - report) takes time as the foundation (data warehouse) is built.
  • Inter department politics
  • Lack of skilled team members
  • Data governance/ownership issues/master data management issues
  • Lack of business understanding
  • Not giving importance to Datainformability

Comments

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

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

RAG Viz added to covid-stats.de

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