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
• 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; 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).
• 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.