Ideas for BI Projects

Just a list of ideas for BI projects irrespective of the domain (Industry)

  • SLA KPI reporting - Find out which SLA’s are in place and see if there is a need to automate KPI reporting (Some companies spend weeks of manual effort).
  • Fraud prevention - Detect fraud patterns based on data and create rules to identify fraud transactions/behavior etc.
  • Regulatory compliance/Market compliance - Identify regulatory requirements and again see if there is a need to automate regulatory reporting.
  • Competitor data analysis - Nielsen data, etc.
  • Campaign/promotions analytics - What is the impact of a campaign?
  • Revenue assurance - Ensure there is no revenue leakage by collecting data and reconciling data from end to end of the business processes.
  • 360 degree view of Customer ( Customer Analytics)


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

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

Context of data should be clear before data analysis

Image
Before data analysis is carried out, it is important to understand the context of the available data. For example, if we analyze hotel reviews data and draw conclusions without understanding the context of the hotel reviews, then we could be drawing totally wrong conclusions.  Let's assume that we have hotel reviews data. Firstly, we should ask several questions about the hotel reviews data before we try to find answers about business from hotel reviews data. Questions such as: Who is the provider of the reviews?  How are the reviews provided? When are the reviews provided?  What are the limitations involved in the review collection process? In how many languages can guests provide reviews in the reviews system? What % of the hotel guests provide reviews? What % of the hotel guests were able to read at least one of the languages in which reviews collection system works? Which channels are there for guests to provide reviews? When did review collection start? What is the s...
Read more