{"product_id":"business-intelligence-tools-for-small-albert-noguzss-9781484225677","title":"Business Intelligence Tools for Small Companies: A Guide to Free and Low-Cost Solutions","description":"\u003cp\u003eLearn how to transition from Excel-based business intelligence (BI) analysis to enterprise stacks of open-source BI tools. Select and implement the best free and freemium open-source BI tools for your company's needs and design, implement, and integrate BI automation across the full stack using agile methodologies.\u003c\/p\u003e\u003cp\u003e\u003ci\u003eBusiness Intelligence Tools for Small Companies\u003c\/i\u003e\u003cem\u003e \u003c\/em\u003eprovides hands-on demonstrations of open-source tools suitable for the BI requirements of small businesses. The authors draw on their deep experience as BI consultants, developers, and administrators to guide you through the extract-transform-load\/data warehousing (ETL\/DWH) sequence of extracting data from an enterprise resource planning (ERP) database freely available on the Internet, transforming the data, manipulating them, and loading them into a relational database.\u003c\/p\u003e\u003cp\u003eThe authors demonstrate how to extract, report, and dashboard key performance indicators (KPIs) in a visually appealing format from the relational database management system (RDBMS). They model the selection and implementation of free and freemium tools such as Pentaho Data Integrator and Talend for ELT, Oracle XE and MySQL\/MariaDB for RDBMS, and Qliksense, Power BI, and MicroStrategy Desktop for reporting. This richly illustrated guide models the deployment of a small company BI stack on an inexpensive cloud platform such as AWS. \u003c\/p\u003e\u003cp\u003e\u003cb\u003eWhat You'll Learn\u003c\/b\u003e\u003c\/p\u003eYou will learn how to manage, integrate, and automate the processes of BI by selecting and implementing tools to: \u003cbr\u003e\u003cp\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eImplement and manage the business intelligence\/data warehousing (BI\/DWH) infrastructure\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eExtract data from any enterprise resource planning (ERP) tool\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eProcess and integrate BI data using open-source extract-transform-load (ETL) tools\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eQuery, report, and analyze BI data using open-source visualization and dashboard tools\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eUse a MOLAP tool to define next year's budget, integrating real data with target scenarios\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eDeploy BI solutions and big data experiments inexpensively on cloud platforms\u003cbr\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\u003cbr\u003e\u003cb\u003eWho This Book Is For\u003c\/b\u003e\u003cbr\u003eEngineers, DBAs, analysts, consultants, and managers at small companies with limited resources but whose BI requirements have outgrown the limitations of Excel spreadsheets; personnel in mid-sized companies with established BI systems who are exploring technological updates and more cost-efficient solutions\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Albert Nogués,Juan Valladares\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1484225678\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781484225677\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Apress\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 05\/31\/2017\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 326\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 1.35lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 10.00h x 7.00w x 0.73d","brand":"Albert Nogués","offers":[{"title":"Paperback","offer_id":48088385159423,"sku":"9781484225677","price":64.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_a4fb653a-8b3f-4edc-a8c0-32b3bf39cdd5.jpg?v=1769104537","url":"https:\/\/www.whiterainbookhouse.com\/products\/business-intelligence-tools-for-small-albert-noguzss-9781484225677","provider":"WR Book House","version":"1.0","type":"link"}