Anoop


Anoop Kumar V K, Business Intelligence

I am Anoop Kumar V K, author of this BI blog. I am a freelance data and BI consultant and also an entrepreneur with PublicBI initiative. I like to use my experience and efforts to help improve businesses by building cost-effective solutions.  15+ years of experience in implementing & leading several end-to-end business intelligence, data warehousing, analytics and data solutions successfully across various sectors for organizations based in Australia, Germany, UK and US in multiple roles.

As a freelancer data/BI consultant, I work on building cost-effective data/BI solutions that improve businesses. Work includes problem specification, envisioning solutions, research, process optimizations, data quality auditing and data improvement, designing and creating solution architectures, development, testing and recommending the best fit set of tools and technologies

Expertise: Data/BI solution development, business analysis, product management/ownership, project management, data analysis, process improvements, agile coaching, mentoring, leading teams and departments. Hands-on on multiple frontend & backend BI tools.

Domains: Fintech (Card Issuing and Payments), EU Public Procurement (Open data), Energy Trading, Fleet Management, Retail, CPG & Gas Upstream

As an entrepreneur I am building (although slowly) solutions that will derive more value out of public data and help both general public and organizations.

More:
  • Author of the published book Business Intelligence Demystified
  • Creator of IBI, Agile KABI, PublicBI BIKON , reportpedia.com and JobsBI.com among others.
  • 2nd prize winner at EUDatathon2018 for the PublicBI EUProc solution.
  • Speaker at EU DataViz 2019.
  • Recipient of several awards for excellence at work.
  • Recognized for setting up effective processes.
  • Proven track record of recruiting and building high-performance BI/Analytics teams.
  • 5+ years at Wirecard, Munich and 8+ years at Infosys at various locations.
  • Highly passionate about data, BI and solutions.
  • Ability to grasp big picture quickly and be in the details when required.
  • Business improvement, positive change & result-oriented with sound technical knowledge.
  • Highly solution-focused, prefer building cost-effective and timely solutions over hyped-solutions.
  • Have an eye for useful & important topics, and a mind that gets highly creative from time to time.
  • Innovative, highly proactive & organized.
  • Continuous learner, I like challenging the status quo & working on continuous self-improvement.
  • BI blogger at akvkbi.com. Non-BI blogging at akclarity.com
  • Invited to present PublicBI EUProc solution at ESWG meeting, European Commission at Brussels. 
  • Invited to present PublicBI EUProc solution at Publication Office of the European Union, Luxembourg.
  • In the past I was actively answering BI questions on Quora, see Anoop Kumar V K in Quora.
  • Leading and managing both co-located and offshore based BI teams. Lead by example. 

BI Expertise
  • Building, leading and managing BI teams/departments
  • Business analysis and product ownership
  • Envisaging dashboards, KPIs and metrics
  • Solution design and architecture
  • Working in in-house team and as an external
  • Data warehousing 
  • BI tools research
  • Data modeling (especially dimensional modeling)
  • Data profiling
  • Data cleansing
  • Data visualization
  • ETL jobs development (both with ETL tools and scripting)
  • Project management
  • Both on-premises and cloud-based solutions
Some of the BI tools I have hands-on experience are listed

ETL Tools : 
  • Datastage
  • Ab Initio 
  • BODS
Data Visualization, Reporting and Analytics platforms : 
  • Business Objects (BO)
  • Microstrategy (both EE and Desktop)
  • Google Data Studio 
  • MS Excel
  • Google Sheets
  • Tableau
  • Power BI
  • IBM Watson Analytics
Databases
  • Google Big Query
  • PostgreSQL
  • Oracle
  • SQL Server
  • My SQL
  • DB2
Others
  • Oracle SQL Data modeler
  • Toad Data modeler
  • Cloud services
Languages
  • Python
  • SQL
Connect with me on Linkedin. 
I will try my best to answer your BI questions through the blog.

Note : All views expressed by me in this blog are my own and not associated with any of my employers, clients, etc. 

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

Corona Virus Analytics

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
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