The book will discuss the significance of Visualization in Business Intelligence and Data Science Using Tableau. It will explore the power of statistics and data mining to help with the understanding of data and make compelling dashboards to enable quicker decision making. The book will encourage self-service BI by placing power directly in the hands of business users. It will be intuitive enough to help pull together good visualization quickly yet leave room for deeper exploration.
The book will cover the connectivity to varied data sources such as spreadsheets (Excel), text files (.txt), MS access databases (.accdb), RDBMSs (MS SQL Server, Oracle, MySQL), NoSQL (MongoDB, Cassandra), Big Data (Cloudera Hadoop), R Scripts (.rdata), etc. The book will have detailed steps on connecting to single and multiple (similar and disparate) data sources. The book will discuss several types of charts (bar, stacked bar, combination charts, dual axis charts, area charts, bubble charts, heat maps, tree maps, highlight tables, pie charts, histogram, box and whisker plot, etc). The book will have a complete section dedicated to data mining. This will be covered by bringing together R analytics with Tableau.
The power of visual analytics to tell a compelling story will be discussed with a couple of good use cases.
What you will learn:
-How to connect various data sources such as structured RDBMS (SQL Server, Oracle), non-relational databases (NoSQL such as MongoDB, Cassandra), multi-dimensional data structure (cube in SSAS), and also write your own custom SQL, etc. -How to Perform logistics regression and statistical analysis in tableau using R -How to Integrate Tableau with R -Telling a meaningful story with data by creating highly interactive dashboards
Who this book is for: The audience for this book includes all levels of IT professionals, from executives responsible for determining IT strategies to systems administrators, to data analysts, to decision makers responsible for driving strategic initiatives, etc. It will help to chart your journey from a novice to a professional visualization expert.
