Business intelligence tools for small companies : a guide to free and low-cost solutions /: a guide to free and low-cost solutions. (2017)
- Record Type:
- Book
- Title:
- Business intelligence tools for small companies : a guide to free and low-cost solutions /: a guide to free and low-cost solutions. (2017)
- Main Title:
- Business intelligence tools for small companies : a guide to free and low-cost solutions
- Further Information:
- Note: Albert Nogués, Juan Valladares.
- Other Names:
- Nogués, Albert
Valladares, Juan - Contents:
- At a Glance; Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Business Intelligence for Everybody; What Is Business Intelligence?; BI Evolution; From Strategic to Tactical; Big Data; Internet of Things; BI Characteristics; Hidden Relevant Information; Accuracy; Significant KPIs; On Time; Company Analytics Life Cycle and Continuous Improvement; Benefits of BI; Direct Benefits; Indirect Benefits; Objectives; Who Can Get Benefit from BI?; BI Platform Components; Source ERP; Database; ETL; Front-End Tool; Budgeting Tool. BI Platform LocationBI Concepts; Datawarehouse; DataMart; Logical Model; Relational Model; Normalized Model; Denormalized Model; Star Model; Snowflake Model; Physical Model; BI Main Objects; Project; Tables; Facts; Dimensions; Reports; BI Approaches; Query and Reporting; Information Sharing; Dashboarding; Data Import; Data Discovery; MOLAP; Data Mining; Incoming Approaches; BI Capabilities; Drilling; Pivoting; Visualizations; Map Visualizations; Sorting; Grouping; Filtering; Conditional Expressions; Subtotals; Administration; User Interface; Conclusion. Chapter 2: Agile Methodologies for BI ProjectsIntroduction to Agile Methodologies; Agile Approaches; Our Recommended Mix between Scrum and Kanban; Developing Projects with Scrum; Roles; Product Owner; Scrum Master; Development Team; Stakeholders; Users; Product Owner Assistant; Sprint; Specific Scrum Meetings; Release; Artifacts Used in Scrum; User Story;At a Glance; Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Business Intelligence for Everybody; What Is Business Intelligence?; BI Evolution; From Strategic to Tactical; Big Data; Internet of Things; BI Characteristics; Hidden Relevant Information; Accuracy; Significant KPIs; On Time; Company Analytics Life Cycle and Continuous Improvement; Benefits of BI; Direct Benefits; Indirect Benefits; Objectives; Who Can Get Benefit from BI?; BI Platform Components; Source ERP; Database; ETL; Front-End Tool; Budgeting Tool. BI Platform LocationBI Concepts; Datawarehouse; DataMart; Logical Model; Relational Model; Normalized Model; Denormalized Model; Star Model; Snowflake Model; Physical Model; BI Main Objects; Project; Tables; Facts; Dimensions; Reports; BI Approaches; Query and Reporting; Information Sharing; Dashboarding; Data Import; Data Discovery; MOLAP; Data Mining; Incoming Approaches; BI Capabilities; Drilling; Pivoting; Visualizations; Map Visualizations; Sorting; Grouping; Filtering; Conditional Expressions; Subtotals; Administration; User Interface; Conclusion. Chapter 2: Agile Methodologies for BI ProjectsIntroduction to Agile Methodologies; Agile Approaches; Our Recommended Mix between Scrum and Kanban; Developing Projects with Scrum; Roles; Product Owner; Scrum Master; Development Team; Stakeholders; Users; Product Owner Assistant; Sprint; Specific Scrum Meetings; Release; Artifacts Used in Scrum; User Story; Developer Story; Product Backlog; Definition of Done; When to Start -- Ready Definition; Product Backlog Burndown Chart; Sprint Backlog; Sprint Backlog Burndown Chart; Impediment List; Improvement List; Limiting Spent Time with Timeboxing. SpikeMaintenance with Kanban; Kanban Concepts; Task Workflow; Task Board and Visual Management; Work In Progress; Lead Time; Mix of Both Methodologies, Scrumban; Peculiarities of Scrum for BI; Sprint 0 -- Longer Initial Analysis; BI Project Segmentation; Front-End vs. Back-End Activities; Role Isolation -- Specific Knowledge; Developer Story Types in BI; Data Modeling Developer Stories; ETL Developer Stories; BI Model Developer Stories; Report and Dashboarding Developer Stories; MOLAP Developer Stories; Agile Management Tools; Trello; JIRA Software; Conclusion; Chapter 3: SQL Basics. What Is SQL?The Relational Model; Databases and Database Vendors; ACID Compliance; Types of SQL Statements; SQL Datatypes; Numeric Datatypes; Text Datatypes; Date Datatypes; Other Datatypes; Retrieving Data from a Table; The select * Statement; The select column Statement; The select count (*) or count (column) Statement; The select distinct Clause; Sorting; Filtering; The Where Clause; Operators; Logical Operators; Grouping Data; Using Subqueries; Joining Tables; Types of Joins; Cartesian Join; Inner Join; Outer Join; Left Outer Join (or Left Join); Right Outer Join (or Right Join). … (more)
- Publisher Details:
- Berkeley, CA : Apress
- Publication Date:
- 2017
- Extent:
- 1 online resource
- Subjects:
- 658.4/03
Computer science
Management information systems
Cloud computing
Business -- Data processing
BUSINESS & ECONOMICS -- Industrial Management
BUSINESS & ECONOMICS -- Management
BUSINESS & ECONOMICS -- Management Science
BUSINESS & ECONOMICS -- Organizational Behavior
Business -- Data processing
Cloud computing
Management information systems
Computers -- Database Management -- General
Computers -- System Administration -- Storage & Retrieval
Business & Economics -- Industries -- Computer Industry
Databases
Information retrieval
Business mathematics & systems
Open source software
Computer programming
Database management
Information storage and retrieva
Big data
Computers -- Programming -- Open Source
Computer programming / software development
Electronic books - Languages:
- English
- ISBNs:
- 9781484225684
1484225686 - Related ISBNs:
- 9781484225677
1484225678 - Notes:
- Note: Print version record.
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.359846
- Ingest File:
- 01_322.xml