BI Analytics Overview
BI Analytics Overview
BI Analytics Overview
and
Analytics
A Comprehensive Overview
IT 4713/7123 BI
Jack G. Zheng
Fall 2022 (V10)
http://zheng.kennesaw.edu/teaching/it4713
http://zheng.kennesaw.edu/teaching/it7123
https://www.edocr.com/v/r4dg6mjr/
Overview
This lecture notes provides a high-level overview of business
intelligence and analytics. This overview is comprehensive and covers
as many aspects as possible, but it keeps them at a high level. More
details are provided in more learning modules.
2
Sections
3
What is BI and Analytics?
4
What is Business Intelligence?
Business Intelligence is a set of methods,
processes, 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.
Adapted from Forrester Report
“Topic Overview: Business Intelligence”, 2008
https://www.forrester.com/report/Topic+Overview+Business+Intelligence/-/E-RES39218
More BI from Forrester
https://www.forrester.com/business-intelligence
5
Business
• Does “business” only mean commercial entities and activities?
• Traditionally or narrowly speaking, “business” implies companies,
corporates, and their operations and commercial activities.
• The term “business” has become more general and represents many
types of entities and activities
Think of “business”
– It refers to more like “activity” or “issue” more like the “business”
in “mind your own
business!”
• BI/Analytics can be applied in all “business”
entities (organizations, functional areas or domains)
to drive “business” performance. These entities may include:
– Companies (for profit) and financially related
• Retail, manufacture, real-estate, financial, sports, media, advertising, entertainment,
healthcare, publication, energy, etc.
– Non-profit organizations, institutions, associations, communities, etc.
– Government: citizen service, city planning, crime, immigration, etc.
– Individuals: personal health, exercise, learning, eating, power consumption,
etc.
6
Data
• Data is the source of insights and decision. The analysis is the essential part to transform data to information
and knowledge. Many times, the process is complex, as have to deal with different types of data and all kinds
of data use problems.
7
DIKW and Intelligence
• The DIKW hierarchy depicts relationships between data, information, knowledge (and wisdom).
– 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
– Wisdom: the understanding of interactions and an integrated view, and the understanding of implications
and indirect results beyond a target domain.
• The model can be loosely related to the levels of transactional processing (OLTP) and
analytical processing (OLAP)
Analytical
Processing
Transactional
Processing
Transactional Processing
• Focus on data item
processing (insertion,
modification, deletion), Analytical Processing
transmission, and even some • Focus on queries,
non-analytical query calculation, reporting,
analysis, and decision
support
10
Performance
• A common goal of BI is to drive performance.
• Performance measures or indicators (known as
KPI, key performance indicators) are defined
and tracked using BI approaches and systems.
– https://kpi.org/KPI-Basics
• Different businesses have different kinds of
“performance”
– Financial performance
– Academic performance (institutional effectiveness)
– Public service performance
– Individual work performance
– Sports performance
11
Sample BI/Analytics Applications
BI/Analytics can be applied in many “businesses” (functional areas, activities, or
domains) to drive “business” performance.
• Business management • IT management
– Strategic planning – Web analytics
– Performance management – App analytics
– Process intelligence – Security management
– Competitive intelligence
– Project and program management • Supply chain and logistics
– Supplier and vendor management
• Retail, marketing and sales – Shipping and inventory control
– Customer behavior analysis – Fleet analytics
– Targeted marketing and sales strategies
– Customer profiling • Financial sector
– Campaign management – Portfolio management, stock analysis
– Inventory management – Insurance
12
Evolution of BI/Analytics
• The evolution of BI resides in both “business” and “intelligence”
– Expansion of entities, domains, and users that use BI
– Evolution of processes, techniques, technologies and systems
14
Analytics or BI?
• We tend to call analytics rather than BI in the following scenarios. But their
processes and technologies are very similar.
15
BI/Analytics and Related Terms
• Data analytics = analytics https://www.slideshare.net/Da
taversity/analytics-business-
intelligence-and-data-science-
• Business analytics whats-the-progression
• Big data
– “Big Data is not a system; it is simply a way to say that you have a lot of data. https://www.linkedin.com/pulse/big-data-silver-bullet-tomas-kratky
– Big data covers non-structure and various data formats including text, blob, multimedia, etc.
• Data science
– An interdisciplinary field about processes and systems to extract knowledge or insights from data in various forms
– Focus on advanced analytics and presentation models and methods
– Using autonomous or semi-autonomous techniques and tools, typically beyond traditional BI to discover deeper insights, make predictions, or generate
recommendation.
– A good data scientist = data hacker + programmer+ analyst+ coach+ storyteller+ artist (http://analyticsindiamag.com/data-science-the-most-desirable-
job-in-the-21st-century/)
– “In some ways, data science is an evolution of BI.” https://www.linkedin.com/pulse/data-science-business-intelligence-whats-difference-david-rostcheck/
• Knowledge management
– Broadly speaking, intelligence, or knowledge, also comes from human experience and tacit knowledge, in various format like story, experience,
practices, image, video, etc.
– In this sense, BI is also related to knowledge management (either BI under KM or vice versa)
http://capstone.geoffreyanderson.net/export/19/trunk/proposal/research/Knowledge_management.pdf
• All these new terms try to differentiate them from the (traditional) BI. However, if one considers BI is a dynamic and evolving field, then all these
new terms can be viewed as extensions/expansions of BI; they all still fall under the umbrella of the general BI.
– “In its more comprehensive usage, BI is all of the systems, platforms, software, technology, and techniques that are essential for the collection, storage,
retrieval, and analysis of data assets within a given organization.” – Dataversity 2015 Report on BI vs Data Science
17
Process and Technology
• BI/Analytics can be viewed both from the perspective of
process and technology
• Information and decision process
– BI and analytics share similar process to transform data to
insights
– A process consists of multiple steps (or activities,
corresponding to capabilities), arrange in varied order
– Each process may be different depending on a number of
factors, including data sources, quality, analytical needs, etc.
• Computing and information technology
– The technology directly implements and supports BI
capabilities and activities.
– Technology can be in the form of applications, systems,
architectures, platforms, tools, products, technique, algorithm,
hardware, software, etc.
18
Analytics: A General Process
See details of the process in
one of the core readings at:
https://www.g2.com/articles/
data-analysis-process
Extended reading: a different perspective is presented in this video when talking about
data lake (we will cover data lake in a later module)
https://www.youtube.com/watch?v=zlBZrG8dDMM
19
A Decision Process
Another view from the corporate decision perspective
http://www.slideshare.net/junesungpark/business-process-based-analytics
20
Analytics/BI: A General Process in more Technical Terms
21
BI/Analytics: Systems and Platforms
• A BI system is a computer information system that implements (part or
whole) and streamlines BI capabilities and processes.
• BI or analytics can be done with multiple independent tools and
technologies, but a complete system can greatly facilitate the process.
• The values of a BI/analytics system
– Provides an integrated data (analytical) processing platform
– Enables easy and fast access of data and information at all levels (raw
data, analysis results, metrics, etc.)
– Streamlines a controlled and managed process of data driven decision
making
22
General BI Capabilities Conception
This is consistent with the
general BI or analytics
process but more from an
information behavior angle.
Figure from: Business Intelligence, Rajiv Sabherwal, Irma Becerra-Fernandez, John Wiley & Sons, 2011
http://books.google.com/books?id=T-JvPdEcm0oC – narrated slides https://slideplayer.com/slide/5861482/
23
Critical Capabilities of a BI and Analytics Platform
Gartner Magic Quadrant Report 2021
• Infrastructure
– Manageability: Capabilities that track usage of the ABI platform and manage how information is shared (and by whom).
– Security: Capabilities that enable platform security, administering of users, auditing of platform access and authentication.
– Cloud analytics/BI: The ability to support building, deployment and management of analytics in the cloud, based on data stored both in the cloud and on-
premises (platform-as-a-service and analytic-application-as-a-service).
• Data Management
– Data source connectivity: Capabilities that enable users to connect to, query and ingest data, while optimizing for performance.
– Data preparation: Support for drag-and-drop, user-driven combination of data from different sources, and the creation of analytic models (such as user-
defined measures, sets, groups and hierarchies).
– Dropped or combined compared to previous reports: data storage, data model
Additional resources:
https://www.predictiveanalyticstoday.com/key-capabilities-of-business-intelligence-software/
24 https://www.selecthub.com/business-intelligence/list-bi-capabilities/
BI System Components at a Glance
Applications:
• Performance
management
• Benchmarking
Data • Market research
Management: Analytical Delivery and • CRM
Gathering and Presentation • Strategic
Processing Sharing management
Storage • Web page visits
25
A Practical Example: MSBI System Architecture
26
Data Management/Storage
• Traditional (operational) relational databases facilitate data management and transaction
processing. They have two limitations for data analysis and decision support
– Performance
• They are transaction oriented (data insert, update, move, etc.)
• Not optimized for complex data analysis
• Usually do not hold historical data
– Heterogeneity
• Individual databases usually manage data in very different ways, even in the same organization (not to mention
external data sources which may be dramatically different).
• A special analytical data store is needed for business intelligence and analytics.
• In traditional BI, a special database system called data warehouse or data mart is often used to
store enterprise data
– The purpose of a data warehouse is to organize lots of stable data for ease of analysis and retrieval.
– Many data warehouses are build using the relational database systems.
– The data warehouse approach is a centralized and structured approach for analytical data management.
For more recent personal BI/analytics, data is also kept locally for easy access and manipulation, without
much technical support.
Data storage for analytics will be covered in IT 3703 module 4 and 7123 module 4.
Data warehouse/mart will be covered in IT 4713 module 4.
27
Data Ingestion, Integration and Preparation
• Data may come from multiple different sources of different formats, but need to be combined
and associated
– Operational databases Data is never clean!
– Spreadsheets
– Text, CSV
You will spend most of your time
– PDF, Paper cleaning and preparing data!
• Traditional BI focuses on upfront separate ETL processes that load the data in a centralized
storage. In modern BI and analytics, data cleanse and transformation may happen just-in-time
with analysis.
– Similar or related terms: data integration, acquisition, ingestion, wrangling, blending
28
Four Levels of Analysis Advanced analytics
Screenshot from
29 https://www.youtube.com/watch?v=oNNk9-tmsZY
Examples of Analysis
• Non-analytical query (search results based on certain conditions)
– Get a list of students enrolled in in the IT 6713 class.
• What if analysis
– If inventory levels are reduced by 10%, what is the new cost of inventory storage?
• Fuzzy decision
– What new advertising strategies need to be undertaken to reach our customers who can
afford an expensive product?
– Should we invest more on our e-business?
30
Descriptive Analytics
• Descriptive reporting has been the most common in all kinds of analysis
– Structured and fixed format reports
– Based on simple and direct queries
– Usually involves simple descriptive analysis and transformation of data, such as calculating, sorting,
filtering, grouping, and formatting
– Aggregating results from multiple rows of data on multiple dimensions
– Ad hoc query and reporting
Dimensional queries and analysis will be covered in IT
• Multi-dimensional queries 4713 milestone 4 and in IT 7123 module 8.
– A dimension is a particular way (or an attribute) of describing and categorizing data
– Such queries are usually arithmetic aggregation operations (sum, average, etc.) on records grouped by
multiple dimensions (attributes) at different aggregation levels.
– A pivot table or crosstab is usually used for OLAP result view (aggregated data) Descriptive and
operational report
• Example analysis
– "What is the total sales amount grouped by product line (dimension 1), location (dimension 2), time
(dimension 3) and … (other dimensions)?"
– "Which segment of business provides the most revenue growth?"
More open and
exploratory analysis
• OLAP (Online Analytical Processing)
– OLAP is a technology and system that is optimized to answer queries that are multi-dimensional
– OLAP solutions traditionally heavily rely on backend processing and dedicated IT personnel
31
Advanced Analytics
• Advanced Analytics is the autonomous or semi-autonomous
examination of data or content using sophisticated techniques
and tools, typically beyond those of traditional business
intelligence (BI), to discover deeper insights, make predictions,
or generate recommendations.
– https://www.gartner.com/it-glossary/advanced-analytics/
– Advanced analytics are usually computing intensive
• Advanced analytic techniques include:
– Complex statistical methods
– Machine learning
– Data/text mining: using sophisticated statistical and mathematical
techniques to find patterns and relationships among data. Data
mining techniques are a blend of statistics and mathematics, and
artificial intelligence and machine-learning.
– Pattern matching, forecasting, visualization, semantic analysis,
sentiment analysis, network and cluster analysis, multivariate
statistics, graph analysis, simulation, complex event processing,
genetic algorithm, neural networks, etc.
32
Data Presentation
Data presentation is the method to summarize, organize, and communicate data
(raw or analysis results) using a variety of tools. Data can be presented in one of
the three forms: text, tables, and/or graphs. The selection of the method of
presentation depends on the type of data, method of analysis, and type of
information sought from the data.
This is generally
more aligned with
data visualization.
Textual
Narratives and articles, with Structured
lengthier discussions.
Popular in news and story layout:
modes.
table, grid, charts diagrams maps
flow list,
cards
Hybrid or
Nested
Key reading:
• https://www.toppr.com/guides/economics/presentation-of-data/textual-and-tabular-presentation-of-data/
• https://www.toppr.com/guides/business-economics-cs/descriptive-statistics/diagrammatic-presentation-of-data/
33
Textual and Structure Layout Presentation
• Textual presentation of data • Structure Layout examples
means presenting data in the
form of words, sentences and • Flow list
paragraphs. – A single column/row of items
https://finance.yahoo.com/news/exxon-mobil-rides-again-tech-205233533.html
34
Data Visualization
Data visualization is the visual representation and presentation of data
for the purpose of perception and cognition.
36
Reports Reports and dashboards will be covered in IT 7123
module 10, and IT 7113 Data Visualization.
• Reports
– A report is the presentation of detailed data arranged in defined layouts and formats
– Based on simple and direct queries: usually involves simple analysis and transformation of data (sorting, calculating,
filtering, filtering, grouping, formatting, etc.)
• Traditional reports contain detailed data in a tabular format and typically display numbers and text only.
– It is geared towards people who need data rather than a direct understanding or interpretation of data.
– Its purpose is mainly for printing (with styling) or exporting (raw data).
• Modern reports can be interactive and visual, but the focus is still on detailed data. Sometimes the distinction
is a bit blurred with dashboards in some practical cases.
– A report style “dashboard” (or more like a visual intensive interactive report):
https://www.cityhealthdashboard.com/ga/atlanta/city-overview
– Magic Quadrant report vs. https://www.g2.com/categories/data-visualization?segment=all
– Dashboard or report? http://www.crazybikes.com/mrc/CRAZYBIKES.R00090s
37
Dashboard
A dashboard is a visual-oriented display of the most
important data and information needed to achieve defined
goals and objectives; consolidated and arranged on a
single screen so the information can be viewed at a glance.
Adapted from: Dashboard Confusion, Stephen Few,
http://www.perceptualedge.com/articles/ie/dashboard_confusion.pdf
• Elements of a dashboard
Dashboard = data/information + visual + UI
– Data/information: the most important element
– Visual: data visuals (charts, etc.) provide a high level at-a-glance view
– User interface
• a clean UI that unifies all elements to work together as a whole
• supporting interactions as needed
40
BI Stakeholders
Producers
vs.
Consumers
(at different levels)
41
Users Have Different Needs
Casual users
may not be as
technical as
power users.
Power users
may also be
technology savvy
and capable of
programming.
42
The Fit between Tools and Users
Another view put
into layers
Gartner Report,
Select the Right Business Intelligence and Analytics Tool for the Right User
Published: 23 May 2016 Analyst(s): Cindi Howson
43
Modern BI Trends
44
History and Trends
Traditional enterprise
BI based on data
warehouse and OLAP
http://www.b-eye-
45 network.com/blogs/eckerson/archives/2011/03/bi_market_evolu.php
The Modern/New BI
• A modern BI platform supports IT-enabled analytic content development. It is defined by a self-
contained architecture that enables nontechnical users to autonomously execute full-spectrum
analytic workflows from data access, ingestion and preparation to interactive analysis and the
collaborative sharing of insights. It moves from passive collection and use of data (reporting
driven) to proactive generation of data (business development driven).
• https://www.slideshare.net/Dataversity/analytics-business-intelligence-and-data-science-whats-
the-progression
Technology Insight for Modern Business Intelligence and Analytics Platforms
Gartner Report, October 2015
Insight delivery Distribution and notifications via scheduled Sharing and collaboration, storytelling,
reports or portal; passive collection and use of open APIs
data (reporting driven).
46
Notable Trends/Features of the Modern BI
• Self-service BI/Analytics: Business led, IT enabled
• Cloud BI and analytics: cloud computing is regarded as an ideal platform to provide business intelligence applications as it serves as a repository
for structured and unstructured data.
• Capability specific trends (we will discuss these trends with the modules focusing on each component)
– Data lake
– Advanced analytics (machine learning, deep learning, AI, etc.)
– Collaborative BI
– Mobile BI: https://bi-survey.com/mobile-bi
– Visual BI or visual analytics Visual oriented, - http://www.perceptualedge.com visual-based data discovery capabilities
– In-memory processing (in-memory OLAP): emerging technology for processing of data stored in an in-memory database. http://www.bi-dw.info/in-
memory-olap.htm
– New data gathering techniques and technologies. New data sources and capability to capture more data. From passive collection and use of data
(reporting driven) to proactive generation of data (business development driven)
– Variety of visual medium and UI
• More trends
– https://bi-survey.com/top-business-intelligence-trends
– http://www.zdnet.com/article/is-the-business-intelligence-market-finally-maturing/
– https://www.slideshare.net/TableauSoftware/top-10-business-intelligence-trends-for-2017
– https://www.mrc-productivity.com/blog/2019/01/5-business-intelligence-trends-to-watch-in-2019/
– https://www.gartner.com/smarterwithgartner/gartner-top-10-data-and-analytics-trends-for-2021
47
Self-Service BI
• [A solution for] end users designing and deploying their own reports and analyses within an approved and
supported architecture and tools portfolio.
– http://www.gartner.com/it-glossary/self-service-business-intelligence
• Key features
– Shifting focus from IT back to the user: enables all kinds of users with varied skill levels to autonomously execute full-
spectrum analytic workflows. These users include traditional power users, data professionals or data scientists, managers
and business analysts.
– A more distributed and collaborative environment.
– The process is more flexible and agile, and it responds to user needs quickly. Supporting ad hoc analytic needs, hence more
interactive and explorative.
– Self-service BI tools still have fundamental BI components and provide BI capabilities, but they are more integrated (in one
software package) than separated.
– Independent but very often work with enterprise systems.
– Good for individuals or non-corporate environments.
• Dashboards, reporting, end-user self-service, and advanced visualization are the top four most important
technologies and initiatives strategic to BI in 2018.
– https://www.forbes.com/sites/louiscolumbus/2018/06/08/the-state-of-business-intelligence-2018/#b2fca2878289
48
IT Support in Self-Service BI
• The goal of self-service BI
– NOT to eliminate the need for IT
– Instead, to put data and results in the user’s hands and reduce the
burden on the IT department.
• “Self-service BI does remove much of the reporting burden from
the IT department. The IT department must control the data and
the user access. They’re responsible for keeping the data clean,
and ensuring that users can only access data they’re authorized
to see. The self-service BI tool only acts as a doorway for users
to access the IT-controlled data.”
– https://www.mrc-productivity.com/blog/2015/08/6-common-
misconceptions-of-self-service-bi/
• IT’s role
– Data management and governance, including security, access
control, data quality and accuracy, compliance, etc.
– Technical support for the systems and platforms, especially cloud
based
49
A Self-Service BI Architecture
50
Market, Career, Education, and
Resources
51
BI Market
• Commoditization and consolidation of multiple technologies
– Forrester no longer sees reporting and querying, online analytical processing (OLAP), data
visualization, dashboards, data exploration, and location analytics as separate market
categories within BI. Rather, most enterprise BI platforms now provide these capabilities.
– The same commoditization is happening in the cloud and mobile BI as most leading
vendors now build their platforms on cloud-based multi-tenant architecture or offer a cloud
version in addition to an on-premises one. Similarly mobile BI is now simply a feature of
most BI platforms.
– https://www.zdnet.com/article/is-the-business-intelligence-market-finally-maturing/
Major vendors
https://www.appsruntheworld.com/
top-10-analytics-and-bi-software-
vendors-and-market-forecast/
Vendor Positioning
Gartner Magic Quadrant for Analytics and Business
Intelligence and Platforms 2021 also see
https://www.gartner.com/reviews/market/analytics-business-
intelligence-platforms
BARC https://bi-
survey.com/business-
In 2019 Gartner started to intelligence-software-
put “analytics” before “BI”. comparison
53
Vendors/Products
• Traditional big four: these are mega vendors that provide complete solutions that cover full spectrum of BI processes and related applications.
– Microsoft: SQL Server, Power BI, SharePoint, Excel https://www.microsoft.com/en-us/sql-server/
– SAP: SAP BusinessObjects BI, Lumira https://www.sap.com/products/analytics/business-intelligence-bi.html
– IBM: Cognos, Watson https://www.ibm.com/analytics/business-intelligence/
– Oracle: Oracle BI 12c https://www.oracle.com/solutions/business-analytics/business-intelligence/
54
BI/Analytics Careers
• Typical BI/Analytics positions
– BI analyst
– BI solution architect and integration specialist
– BI application developer and tester
– BI system support specialist
– Data warehouse specialist
– Database analyst, developer and tester
– Report/dashboard developer
• Technical knowledge
– Knowledge of database systems and data warehousing technologies
– Ability to manage database system integration, implementation and testing
– Ability to manage relational databases and create complex reports
– Knowledge and ability to implement data and information policies, security requirements, and state and federal regulations
– Knowledge of client tools used by business users
– Knowledge of data models
– Knowledge of programming tools used in analytics
• https://www.datapine.com/blog/bi-skills-for-business-intelligence-career/
Sample Roles (from real world job ads)
BI jobs in Atlanta
https://www.dice.com/jobs?q=BI&l=Atlanta%2C+Ga+
Business Intelligence Developer
Metro+Area
• Business Intelligence Developer is responsible for
Business Intelligence Specialist designing and developing Business Intelligence
• Maintain or update business intelligence tools, solutions for the enterprise.
databases, dashboards, systems, or methods.
• Key functions include designing, developing, testing,
• Provide technical support for existing reports, debugging, and documenting extract, transform, load
dashboards, or other tools. (ETL) data processes and data analysis reporting for
• Create BItools or systems, including design of enterprise-wide data warehouse implementations.
related databases, spreadsheets, or outputs. • Responsibilities include:
– working closely with business and technical
Business Intelligence Analyst teams to understand, document, design and
code ETL processes;
• Technical skill requirements – working closely with business teams to
– Works with business users to obtain data requirements understand, document and design and code data
for new analytic applications, design conceptual and analysis and reporting needs;
logical models for the data warehouse and/or data mart.
– Develops processes for capturing and maintaining – translating source mapping documents and
metadata from all data warehousing components. reporting requirements into dimensional data
• Business skills requirements models;
– Transform data into analytical insight and desire to – designing, developing, testing, optimizing and
leverage the best technique to arrive at the right answer. deploying server integration packages and
– Generate standard or custom reports summarizing stored procedures to perform all ETL related
business, financial, or economic data for review by functions;
executives, managers, clients, and other stakeholders.
– Analyze competitive market strategies through analysis – develop data cubes, reports, data extracts,
of related product, market, or share trends. dashboards or scorecards based on business
– Collect business intelligence data from available requirements.
industry reports, public information, field reports, or • The Business Intelligence Report Developer is
purchased sources.
responsible for developing, deploying and supporting
– Maintain library of model documents, templates, or other
reusable knowledge assets. reports, report applications, data warehouses and
business intelligence systems.
57
BI/Analytics Local Resources
• BI/Analytics Education at KSU
– MSIT/BSIT - Graduate Certificate in Data Analytics and Intelligent Technology
https://msit.kennesaw.edu/future-students/program-requirements.php, which includes my
• IT 7123 Business Intelligence http://jackzheng.net/teaching/it6713/
• IT 7113 Data Visualization http://jackzheng.net/teaching/it7113/
– BSIT - the new concentration on “data analytics and technology”, including my
• IT 3703 Intro to data analytics and technology
• IT 4713 Business Intelligence http://jackzheng.net/teaching/it4713/
– Other departments
• Data Science Institute Ph.D. in Analytics and Data Science https://datascience.kennesaw.edu
• ACS 8310 Data Warehousing
• IS 8935 Business Intelligence - Traditional and Big Data Analytics
• Certificate in High Performance Cluster Computing http://ccse.kennesaw.edu/cs/programs/cert-
hpcc.php
– Lecture notes on BI and Data Visualization
• https://www.edocr.com/user/jgzheng
58
Core Readings
• What Is Business Intelligence? A Beginner's Guide in 2020
https://learn.g2.com/business-intelligence - this is a very practical but not very
comprehensive view of BI
• Distinguishing Analytics, Business Intelligence, Data Science:
https://www.dataversity.net/distinguishing-analytics-business-intelligence-data-
science/
• Data Analyst vs Data Engineer vs Data Scientist: Skills, Responsibilities, Salary
https://www.edureka.co/blog/data-analyst-vs-data-engineer-vs-data-scientist/ -
from some job and career perspectives.
59
Additional Good General Resources
• A Brief History of Decision Support Systems by D.J. Power: http://dssresources.com/history/dsshistory.html
• An Overview of (traditional) BI Technology from CACM (premium magazine from ACM): http://cacm.acm.org/magazines/2011/8/114953-an-overview-of-business-intelligence-
technology/fulltext
• http://wps.prenhall.com/wps/media/objects/2519/2580469/addit_chmatl/TURBMC04_0131854615App.pdf
• Paid industry reports: you may get some free reprints from some vendors after registration.
– Gartner annual report on “Magic Quadrant for Analytics and Business Intelligence Platforms”
– Gartner report “Technology Insight for Modern Analytics and Business Intelligence Platforms”
– The Forrester Wave™: Enterprise BI Platforms (two versions, one for on-premise and one for cloud)
– Forrester Playbook: https://www.forrester.com/playbook/The+InsightsDriven+Business+Playbook/-/E-PLA940