Business Intelligence

ABOUT THIS BOOK
* A practical hands-on guide to improving your business with the power of BI and Quicksight
* Immerse yourself with an end-to-end journey for effective analytics using QuickSight and related services
* Packed with real-world examples with Solution Architectures needed for a cloud-poweredmore » Business Intelligence service
WHO THIS BOOK IS FOR
This book is for Business Intelligence architects, BI developers, Big Data architects, and IT executives who are looking to modernize their business intelligence architecture and deliver a fast, easy-to-use, cloud powered business intelligence service.
WHAT YOU WILL LEARN
* Steps to test drive QuickSight and see how it fits in AWS big data eco system
* Load data from various sources such as S3, RDS, Redshift, Athena, and SalesForce and visualize using QuickSight
* Understand how to prepare data using QuickSight without the need of an IT developer
* Build interactive charts, reports, dashboards, and storyboards using QuickSight
* Access QuickSight using the mobile application
* Architect and design for AWS Data Lake Solution, leveraging AWS hosted services
* Build a big data project with step-by-step instructions for data collection, cataloguing, and analysis
* Secure your data used for QuickSight from S3, RedShift, and RDS instances
* Manage users, access controls, and SPICE capacity
IN DETAIL
Amazon QuickSight is the next-generation Business Intelligence (BI) cloud service that can help you build « less

KEY FEATURES
* This book will enable and empower you to break free of the shackles of spreadsheets
* Learn to make informed decisions using the data at hand with this highly practical, comprehensive guide
* This book includes real-world use cases that teach you how analytics can be put to work tomore » optimize your business
* Using a fictional transactional dataset in raw form, you'll work your way up to ultimately creating a fully-functional warehouse and a fleshed-out BI platform
BOOK DESCRIPTION
Business Intelligence (BI) is at the crux of revolutionizing enterprise. Everyone wants to minimize losses and maximize profits. Thanks to Big Data and improved methodologies to analyze data, Data Analysts and Data Scientists are increasingly using data to make informed decisions. Just knowing how to analyze data is not enough, you need to start thinking how to use data as a business asset and then perform the right analysis to build an insightful BI solution. Efficient BI strives to achieve the automation of data for ease of reporting and analysis.
Through this book, you will develop the ability to think along the right lines and use more than one tool to perform analysis depending on the needs of your business. We start off by preparing you for data analytics. We then move on to teach you a range of techniques to fetch important information from various databases, which can be used to optimize your business.
The book aims to provide a full end-to-end solution for an environment setup that can help you make informed business decisions and deliver efficient and automated BI solutions to any company.
It is a complete guide for implementing Business intelligence with the help of the most powerful tools like D3.js, R, Tableau, Qlikview and Python that are available on the market.
WHAT YOU WILL LEARN
* Create a BI environment that enables self-service reporting
* Understand SQL and the aggregation of data
* Develop a data model suitable for analytical reporting
* Connect a data warehouse to the analytic reporting tools
* Understand the specific benefits behind visualizations with D3.js, R, Tableau, QlikView, and Python
* Get to know the best practices to develop various reports and applications when using BI tools
* Explore the field of data analysis with all the data we will use for reporting « less

KEY FEATURES
* Cook your favorite Tableau 10 business intelligence recipe with the help of this easy-to-follow book
* Build beautiful, interactive dashboards and visualizations in Tableau 10 that help you make informed decisions
* This rich collection of independent recipes cover everything neededmore » to become an advanced Tableau user and get an edge over other Tableau users
BOOK DESCRIPTION
Tableau is a software tool that can speed up data analysis through its rich visualization capabilities, and help uncover insights for better and smarter decision making. This book is for the business, technology, data and analytics professionals who use and analyze data and data-driven approaches to support business operations and strategic initiatives in their organizations.
This book provides easy-to-follow recipes to get the reader up and running with Tableau 10, and covers basic to advanced use cases and scenarios. The book starts with building basic charts in Tableau and moves on to building more complex charts by incorporating different Tableau features and interactivity components. There is an entire chapter dedicated to dashboard techniques and best practices. A number of recipes specifically for geospatial visualization, analytics, and data preparation are also covered.
By the end of this book, you’ll have gained confidence and competence to analyze and communicate data and insights more efficiently and effectively by creating compelling interactive charts, dashboards, and stories in Tableau.
WHAT YOU WILL LEARN
* Become familiar with the Tableau interface
* Build basic to more advanced charts with step-by-step recipes
* Use filters, calculated fields, parameters, and actions to add interactivity to charts and dashboards
* Prepare and transform data for analysis using Tableau’s built-in tools and functions
* Create effective and compelling dashboards and story points
* Leverage Tableau’s mapping capabilities to visualize location and shape data
* Integrate analytics and forecasting to enhance data analysis
* Get to know tips and tricks to work more quickly and effectively in Tableau
* Increase your confidence and competence in creating rich, interactive visualizations in Tableau
ABOUT THE AUTHOR
Donabel Santos is a self-confessed data geek. She loves working with data, writing queries and developing reports on her SQL Server databases, and exploring and visualizing data with Tableau.
She is the principal and senior Business Intelligence Architect at QueryWorks Solutions, a Tableau Learning and Alliance partner in Vancouver, BC, Canada providing consulting and training services. She has spent years in consulting and has developed a variety of solutions for clients in different verticals—finance, manufacturing, healthcare, legal, higher education, and local government.
Donabel is a multi-year Microsoft Data Platform MVP (previously known as SQL Server MVP) and has extensive experience in SQL Server in different areas, such as development, administration, data warehouse, reporting (SSRS), tuning, troubleshooting, XML, CLR, integration with ERPs and CRMs using PowerShell, C#, SSIS, and Power BI.
One of Donabel's passions is teaching and sharing her love for data. She is a Tableau Certified Professional and a Tableau Accredited Trainer, delivering Tableau public and on-site client training. She is also the lead instructor for a number of courses at British Columbia Institute of Technology (BCIT), including Applied Database Administration and Design (ADAD) and Applied Data Analytics (ADA) programs. She teaches SQL Server Administration, Development, Integration (SSIS), Data Warehouse Foundations, and Visual Analytics with Tableau.
Donabel has also authored three other books with Packt Publishing: SQL Server 2012 with PowerShell V3 Cookbook, PowerShell for SQL Server Essentials, and SQL Server 2014 with PowerShell V5 Cookbook. She also contributed a chapter in Manning Publications' PowerShell Deep Dives. Her blog is located at www.sqlbelle.com and her Twitter handle is @sqlbelle.
TABLE OF CONTENTS
1. Basic Charts
2. Advanced Charts
3. Interactivity
4. Dashboards and Story Points
5. Maps and Geospatial Visualization
6. Analytics
7. Data Preparation
8. Calculated Fields Primer
9. Resources « less

This book provides a thorough overview of the Wisdom Web of Things (W2T), a holistic framework for computing and intelligence in an emerging hyper-world with a social-cyber¬physical space. Fast-evolving Web intelligence research and development initiatives are now moving toward understanding the multifacetedmore » nature of intelligence and incorporating it at the Web scale in a ubiquitous environment with data, connection and service explosion.
The book focuses on the framework and methodology of W2T, as well as its applications in different problem domains, such as intelligent businesses, urban computing, social computing, brain informatics and healthcare.From the researcher and developer perspectives, the book takes a systematic, structured view of various W2T facets and their overall contribution to the development of W2T as a whole. Written by leading international researchers, this book is an essential reference for researchers, educators, professionals, and tertiary HDR students working on the World Wide Web, ubiquitous computing, knowledge management, and business intelligence. « less

Business Intelligence with SQL Server Reporting Services helps you deliver business intelligence with panache. Harness the power of the Reporting Services toolkit to combine charts, gauges, sparklines, indicators, and maps into compelling dashboards and scorecards. Create compelling visualizations thatmore » seize your audience’s attention and help business users identify and react swiftly to changing business conditions. Best of all, you'll do all these things by creating new value from software that is already installed and paid for – SQL Server and the included SQL Server Reporting Services.
Businesses run on numbers, and good business intelligence systems make the critical numbers immediately and conveniently accessible. Business users want access to key performance indicators in the office, at the beach, and while riding the subway home after a day's work. Business Intelligence with SQL Server Reporting Services helps you meet these need for anywhere/anytime access by including chapters specifically showing how to deliver on modern devices such as smart phones and tablets. You'll learn to deliver the same information, with similar look-and-feel, across the entire range of devices used in business today. « less

Business Intelligence with SQL Server Reporting Services helps you deliver business intelligence with panache. Harness the power of the Reporting Services toolkit to combine charts, gauges, sparklines, indicators, and maps into compelling dashboards and scorecards. Create compelling visualizations thatmore » seize your audience’s attention and help business users identify and react swiftly to changing business conditions. Best of all, you'll do all these things by creating new value from software that is already installed and paid for – SQL Server and the included SQL Server Reporting Services.
Businesses run on numbers, and good business intelligence systems make the critical numbers immediately and conveniently accessible. Business users want access to key performance indicators in the office, at the beach, and while riding the subway home after a day's work. Business Intelligence with SQL Server Reporting Services helps you meet these need for anywhere/anytime access by including chapters specifically showing how to deliver on modern devices such as smart phones and tablets. You'll learn to deliver the same information, with similar look-and-feel, across the entire range of devices used in business today.
* Key performance indicators give fast notification of business unit performance
* Polished dashboards deliver essential metrics and strategic comparisons
* Visually arresting output on multiple devices focuses attention
**** What you’ll learn ****
* Produce designer dashboards which will wow your audience.
* Mix and match relational, cube, and tabular data to drive BI.
* Integrate gauges, maps, charts, and text to deliver targeted information.
* Enhance SSRS interactivity to provide a more intuitive interface.
* Adapt delivery to mobile devices such as phones and tablets.
* Standardize presentation across the entire portal.
**** Who this book is for ****
Business Intelligence with SQL Server Reporting Services is written for Business Intelligence developers wanting to implement portals providing key performance indicators across the range of desktop and mobile devices used in business today. The book is ideal for readers having a basic knowledge of SQL Server Reporting Services, who want to step up and increase the value their business receives from it's investment in Microsoft's SQL Server ecosystem. « less

After a brief presentation of the state of the art of process-mining techniques, Andrea Burratin proposes different scenarios for the deployment of process-mining projects, and in particular a characterization of companies in terms of their process awareness. The approaches proposed in this book belongmore » to two different computational paradigms: first to classic "batch process mining," and second to more recent "online process mining."
The book encompasses a revised version of the author's PhD thesis, which won the "Best Process Mining Dissertation Award" in 2014, awarded by the IEEE Task Force on Process Mining. « less

Data is taking over in a powerful way, and it's revolutionizing the healthcare industry. You have more data available than ever before, and applying the right analytics can spur growth. Benefits extend to patients, providers, and board members, and the technology can make centralized patient managementmore » a reality. Despite the potential for growth, many in the industry and government are questioning the value of data in health care, wondering if it's worth the investment.
Data-Driven Healthcare: How Analytics and BI are Transforming the Industry tackles the issue and proves why BI is not only worth it, but necessary for industry advancement. Healthcare BI guru Laura Madsen challenges the notion that data have little value in healthcare, and shows how BI can ease regulatory reporting pressures and streamline the entire system as it evolves. Madsen illustrates how a data-driven organization is created, and how it can transform the industry. « less

QlikView is the most flexible enterprise Business Intelligence platform for transforming information into knowledge. Users can effectively consolidate relevant data from multiple sources into a single application, create reports, and visualize content for unprecedented business insight using QlikView.more » QlikView Server allows the nesting of multiple servers for data load balancing and enables users to access data using their PC and mobile devices. QlikView Publisher ensures that the right information reaches the right user at the right time, and gives further centralized administration and management. « less

IBM Cognos 10 Framework Manager is a complete practical guide to using and getting the best out of this essential tool for modeling your data for use with IBM Cognos Business Intelligence Reporting. With its step-by-step approach, this book is suitable for anyone from a beginner to an expert, completemore » with tips and tricks for better data modeling.
IBM Cognos 10 Framework Manager is a step by step tutorial-based guide; from importing your data to designing and improving your model, and creating your packages while working with other modelers, every step is presented in a logical process. « less