Business Intelligence

The Institution's Innovation Council (Ministry of HRD initiative) and the Institution of Electronics and Telecommunication Engineers (IETE) invited me to grace "World Telecommunication & Information Society Day" on 18 May 2020.

1. Business Intelligence (BI) Dr Mithileysh Sathiyanarayanan MIT Square, London City, University of London Web: www.mitsquare.com Email: [email protected]

2. RAJ SQUARE CHARITY FOUNDATION www.rajsquare.com RAJ CORONA WARRIORS Thanks to the Volunteers from Tamilnadu .

3. AGENDA 3

4. 4 1. What is Business Intelligence (BI)?

5. Business Intelligence (BI) is about using the right data to get the right information, to the right decision makers, at the right time. BI is an enterprise-wide platform that supports reporting, analysis and decision making. BI as an information system BI as a data analytic processor BI as a decision management Business intelligence (BI)

6. fact-based decision making. “single version of the truth”. useful, actionable insight from stored data. effective business decisions can be made. allows t he act of using historical data to gain new information. quick decisions can be made. BI leads to: Improving organizations by providing business insights to all employees leading to better, faster, more relevant decisions.

7. How can we define BI? 7 Business Intelligence is a set of methods, processes, frameworks, architectures, applications, and technologies that gather and transform raw data into meaningful and useful information used to enable more effective strategic, tactical, and operational insights and decision- making (to drive business performance).

8. Techniques include: statistical analysis visualisations visual analytics ad-hoc queries reporting dashboards BI Techniques Traditionally BI has been also understood as Decision Support System (DSS) – data directly contributes to decision without intensive and advanced analytical techniques.

9. Basic Techniques in Business Analytics 9 Correlation Regression Forecasting Cluster analysis Factor analysis

10. Types of Information Processing 10 Transactional Processing Focus on individual data item processing: data insertion, modification, deletion, and transmission Analytical Processing Focus on reporting, analysis, transformation, and decision support

11. “DIK" to achieve Business Success Data: raw value elements or facts Information: the result of collecting and organizing data that provides context and meaning Knowledge: the concept of understanding information that provides insight to information, thus useful and actionable 11 Analytical Processing T r ansacti o nal Processing

12. BI: A General Process 12

13. Questions BI is Designed to Answer What happened? What is happening? Why did it happen? What will happen? What do I want to happen? P a st Prese n t F u ture

14. A Levels of Analytical Processing 14 Advanced Analytics and Business Intelligence h t t p s : // w w w . y o u t ube. c om/ w a t c h?v = oNNk 9 - t m s ZY

15. Data PresentationS 29

16. Data Visualization - Charts

17. Examples of Analysis 17 Should we invest more on our e-business? (fuzzy question  need high level analysis for decision making) How do advertising activities affect sales of different products bought by different type of customers, in different regions? (synthesizing) Figure from Database Processing, 13th Edition, by David Kroenke and David Auer What is the reason for a decrease of total sales this year? (reasoning)

18. 18 2. BI Evolution & Trend

19. The Evolution of BI Semantics 19 http://www.b-eye-network.com/blogs/eckerson/archives/2011/02/whats_in_a_word.php Analytics can be viewed as the evolved or improved BI 2020

20. The Evolution of BI Semantics 20

21. 8 Business Intelligence Vision Is Artificial Intelligence ( A I) and Business Intelligence (BI) same? Strategic: focused on high level organizational strategies and directions Tactic: focused on goals of a organization unit Operational: focused on streamlining day-to-day operations. Institutional Intelligence (II)

22. 24 3. BI Users & Application Areas

23. Business Intelligence Users

24. BI Users Have Different Needs 26

25. BI producers & consumers 32 Technical vs. Business users

26. Questions BI is Designed to Answer Sales and marketing Which customers should I target? What has caused the change in my pipeline? Which are my most profitable campaigns per region? Did store sales spike when we advertised in the local paper or launched an email campaign? What is the most profitable source of sales leads and how has that changed over time?

27. Questions BI is Designed to Answer Operational Which vendors are best at delivering on time and on budget ? Financial What is the expected annual profit/loss based on current marketing and sales forecasts? Overall business performance What are the most important risk factors impacting the company’s ability to meet annual profit goals?

28. BI Application Areas 30 BI can be applied in all “businesses” (industries, functional areas, or domains) to drive “business” performance in both private and public sector Private Retail, manufacture, real-estate, financial, sports, media, entertainment, publication, etc. Public (non-profit) Education, government, healthcare, association, etc.

29. Sample BI Applications 31 Marketing and sales Financial management Human resource/capital Project and program management Power and energy management Business management IT management Supply chain & logistics Healthcare management Insurance City planning E d uc a tion Internet and web Sports and games analytics

30. 32 4. BI TOOLS

31. Google data studio

32. TABLEAU

33. MICROSOFT POWER BI

34. IBM WATSON

35. QLIKVIEW

36. ACTIV TRAK

37. CLUVIO

38. DATABOX

39. CAN I BUILD MY OWN BI TOOL?

40. Data driven documents (D3) You need to use the following three to build your own BI Tool HTML CSS JavaScript https://www.d3js.org/

41. 43 5. BI CAREER

42. BI Careers BI solution architects and integration specialists Business and BI analysts BI application developers and testers Data warehouse specialists Database analysts, developers and testers Database support specialists

43. What are Employers Looking For? 48

44. Critical Knowledge and Skills Three competencies Technical, Business, Analytical Five skills in your kit Free Open Source BI Tools R, Python & SQL Socio-emotional Skills Reporting Skills Business Analysis

45. INDIA - ₹ 20,000 pm to ₹ 1,00,000 pm UK - £2,000 pm to £5,000 pm USA - $4,000 pm to $10,000 pm Salary expectations

46. SUMMARY 48

47. Opportunities Incubation Support Product Development Patent Filing Internship & Training Joint Funding PhD & Post Doc Opportunities in India & UK International Collaboration

48. THANK YOU You can reach me any time LinkedIn: Mithileysh Sathiyanarayanan Personal Email: [email protected]