Microsoft SQL Server 2014 Business Intelligence DevelopmentTake advantage of the real power behind the BI components of SQL Server 2014, Excel 2013, and SharePoint 2013 with this hands-on book. This book will give you a competitive advantage by helping you to quickly learn how to design and build BI system with Microsoft BI tools.
This book starts with designing a data warehouse with dimensional modeling, and then looks at creating data models based on SSAS multidimensional and Tabular technologies. It will illustrate how to use SSIS for ETL, and MDS and DQS for data governance and data quality. The book is packed with real-world examples that will give you a good understanding of the BI and DW components of SQL Server 2014, Excel 2013, and SharePoint 2013. ...
Getting Started with Amazon RedshiftAmazon Redshift is a fast, fully managed, petabyte-scale data warehouse service. It provides an excellent approach to analyzing all your data using your existing business intelligence tools.
Getting Started with Amazon Redshift is an easy-to-read, descriptive guide that breaks down the complex topics of data warehousing and Amazon Redshift. You will learn the fundamentals of Redshift technology and how to implement your own Redshift cluster, through practical, real-world examples. This exciting new technology is a powerful tool in your arsenal of data management and this book is a must-have to implement and manage your next enterprise Data Warehouse. ...
Getting Started with Open Source TechnologiesUsing real life examples, learn how open source projects are consumed and explore the nuances within different industries in adopting open source technologies.
After gaining a basic understanding of open source and open standards, understand how licensing helps turn community code into an enterprise worthy component. It also helps you understand future governance of the open source software. Once in effect, continuous security becomes a challenge for open source components so we'll examine its ongoing security aspects.
This book will also cover different open source domains and industries and discuss how an enterprise can transform itself by applying key open source principles. In the end Getting Started with Open Source Technologies will provide a 360-degree view of open source and show you how to apply it. ...
Data Science for BusinessWritten by renowned data science experts Foster Provost and Tom Fawcett, Data Science for Business introduces the fundamental principles of data science, and walks you through the "data-analytic thinking" necessary for extracting useful knowledge and business value from the data you collect. This guide also helps you understand the many data-mining techniques in use today.
Based on an MBA course Provost has taught at New York University over the past ten years, Data Science for Business provides examples of real-world business problems to illustrate these principles. You'll not only learn how to improve communication between business stakeholders and data scientists, but also how participate intelligently in your company's data science projects. ...
Next-Generation Big DataUtilize this practical and easy-to-follow guide to modernize traditional enterprise data warehouse and business intelligence environments with next-generation big data technologies.
Next-Generation Big Data takes a holistic approach, covering the most important aspects of modern enterprise big data. The book covers not only the main technology stack but also the next-generation tools and applications used for big data warehousing, data warehouse optimization, real-time and batch data ingestion and processing, real-time data visualization, big data governance, data wrangling, big data cloud deployments, and distributed in-memory big data computing. Finally, the book has an extensive and detailed coverage of big data case studies from Navistar, Cerner, British Telecom, Shopzilla, Thomson Reuters, and Mastercard.
Install Apache Kudu, Impala, and Spark to modernize enterprise data warehouse and business intelligence environments, complete with real-world, easy-to-follow examples, and ...
Microsoft Excel Data Analysis and Business Modeling, 7th EditionMaster business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winstons hands-on, scenario-focused guide helps you use todays Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts.
Solve real problems with Microsoft Exceland build your competitive advantage.
Quickly transition from Excel basics to sophisticated analytics; Use recent Power Query enhancements to connect, combine, and transform data sources more effectively; Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA; Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movi ...
Program Management for Open Source ProjectsEvery organization develops a bureaucracy, and open source projects are no exception. When your structure is intentional and serves the project, it can lead to a successful and predictable conclusion. But project management alone won't get you there. Take the next step to full program management. Become an expert at facilitating communication between teams, managing schedules and project lifecycle, coordinating a process for changes, and keeping meetings productive. Make decisions that get buy-in from all concerned. Learn how to guide your community-driven open source project with just the right amount of structure.
Bureaucratic processes naturally develop in large organizations, and open source projects are no different. The trick is to keep the processes intentional and in service of the project. That's program management and you have probably been doing it even if you don't have that title. Make your open source projects successful, predictable, and enjoyable by applying the pri ...
Migrating to MariaDBMitigate the risks involved in migrating away from a proprietary database platform toward MariaDB's open source database engine. This book will help you assess the risks and the work involved, and ensure a successful migration.
Migrating to MariaDB describes the process and lessons learned during a migration from a proprietary database management engine to the MariaDB open source solution. The book discusses the drivers for making the decision and change, walking you through all aspects of the process from evaluating the licensing, navigating the pitfalls and hurdles of a migration, through to final implementation on the new platform. The book highlights the cost-effectiveness of MariaDB and how the licensing worries are simplified in comparison to running on a proprietary platform.
You'll learn to do your own risk assessment, to identify database and application code that may need to be modified or re-implemented, and to identify MariaDB features to provide the security and fail ...
JavaScript Data Structures and AlgorithmsExplore data structures and algorithm concepts and their relation to everyday JavaScript development. A basic understanding of these ideas is essential to any JavaScript developer wishing to analyze and build great software solutions.
You'll discover how to implement data structures such as hash tables, linked lists, stacks, queues, trees, and graphs. You'll also learn how a URL shortener, such as bit.ly, is developed and what is happening to the data as a PDF is uploaded to a webpage. This book covers the practical applications of data structures and algorithms to encryption, searching, sorting, and pattern matching.
It is crucial for JavaScript developers to understand how data structures work and how to design algorithms. This book and the accompanying code provide that essential foundation for doing so. With JavaScript Data Structures and Algorithms you can start developing your knowledge and applying it to your JavaScript projects today.
Review core data structure funda ...
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th EditionMaster business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query/Get & Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts.
Solve real business problems with Excel - and build your competitive advantage: Quickly transition from Excel basics to sophisticated analytics; Use PowerQuery or Get & Transform to connect, combine, and refine data sources; Leverage Office 365's new Geography and Stock data types and six new functions; Illuminate insights from geographic and temporal data with 3D Maps; Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts; Use Excel trend curves, multipl ...