Week 7 Data Analytics & Business
Week
Intelligence
7 Data Analytics
– Key Concepts
& Business
Week
& Study
Intelligence
7 Data
GuideAnalytics
–
PDF.pdf
Key Concepts
& Business
& Study
Intelligence
Guide–
PDF.pdf
Key Concepts & Study Guide PDF.pdf
Week 7 Data Analytics & Business
Intelligence – Key Concepts & Study
Guide PDF
Guidehttps://www.stuvia.com/dashboard!@_)#*)(@$)($@*($@)($@*_
Week 7 Data Analytics & Business
Week
Intelligence
7 Data Analytics
– Key Concepts
& Business
Week
& Study
Intelligence
7 Data
GuideAnalytics
–
PDFKey Concepts
& Business
& Study
Intelligence
Guide–
PDF.pdf
Key Concepts & Study Guide PDF.pdf
, week 7 content - data analytics and business intelligence.pdf week 7 content - data analytics and business intelligence.pdf week 7 content - data analytics and business intelligence.pdf
data analytics the process of collecting,cleaning, inspecting,transforming, storing,modelling, and
querying data
business intelligence An umbrella term that combines architectures,tools, databases,analytical
tools,applications, andmethodologies that that convert unprocessed datainto
valuable insights
how does business intelligence lead to a competitive 1. improved decision making
advantage? 2. personalisation and customer experience
3. operational efficiency
4. fraud detection and risk management
database an organised collection of data, stored electronically for easy retrieval
2 types of databases - relational database SQL
- non relational database NOSQL
relational database a structured way of storing data in tables where relationships exist between data
points. It follows the Relational Model (proposed by Codd in 1970)
key characteristics of relational databases -Data is stored in tables (relations)
-Each row is a record (tuple), and each column is anattribute (field)
-Uses primary keys & foreign keys to establish relationships
non relational databse a flexible data storagesystem that does not use structured tables and fixed
schemas like relational databases
week 7 content - data analytics and business intelligence week 7 content - data analytics and business intelligence.pdf week 7 content - data analytics and business intelligence.pdf
Week
Intelligence
7 Data Analytics
– Key Concepts
& Business
Week
& Study
Intelligence
7 Data
GuideAnalytics
–
PDF.pdf
Key Concepts
& Business
& Study
Intelligence
Guide–
PDF.pdf
Key Concepts & Study Guide PDF.pdf
Week 7 Data Analytics & Business
Intelligence – Key Concepts & Study
Guide PDF
Guidehttps://www.stuvia.com/dashboard!@_)#*)(@$)($@*($@)($@*_
Week 7 Data Analytics & Business
Week
Intelligence
7 Data Analytics
– Key Concepts
& Business
Week
& Study
Intelligence
7 Data
GuideAnalytics
–
PDFKey Concepts
& Business
& Study
Intelligence
Guide–
PDF.pdf
Key Concepts & Study Guide PDF.pdf
, week 7 content - data analytics and business intelligence.pdf week 7 content - data analytics and business intelligence.pdf week 7 content - data analytics and business intelligence.pdf
data analytics the process of collecting,cleaning, inspecting,transforming, storing,modelling, and
querying data
business intelligence An umbrella term that combines architectures,tools, databases,analytical
tools,applications, andmethodologies that that convert unprocessed datainto
valuable insights
how does business intelligence lead to a competitive 1. improved decision making
advantage? 2. personalisation and customer experience
3. operational efficiency
4. fraud detection and risk management
database an organised collection of data, stored electronically for easy retrieval
2 types of databases - relational database SQL
- non relational database NOSQL
relational database a structured way of storing data in tables where relationships exist between data
points. It follows the Relational Model (proposed by Codd in 1970)
key characteristics of relational databases -Data is stored in tables (relations)
-Each row is a record (tuple), and each column is anattribute (field)
-Uses primary keys & foreign keys to establish relationships
non relational databse a flexible data storagesystem that does not use structured tables and fixed
schemas like relational databases
week 7 content - data analytics and business intelligence week 7 content - data analytics and business intelligence.pdf week 7 content - data analytics and business intelligence.pdf
