Book Image

Mastering Qlik Sense

By : Juan Ignacio Vitantonio
Book Image

Mastering Qlik Sense

By: Juan Ignacio Vitantonio

Overview of this book

Qlik Sense is a powerful, self-servicing Business Intelligence tool for data discovery, analytics and visualization. It allows you to create personalized Business Intelligence solutions from raw data and get actionable insights from it. This book is your one-stop guide to mastering Qlik Sense, catering to all your organizational BI needs. You'll see how you can seamlessly navigate through tons of data from multiple sources and take advantage of the various APIs available in Qlik and its components for guided analytics. You'll also learn how to embed visualizations into your existing BI solutions and extend the capabilities of Qlik Sense to create new visualizations and dashboards that work across all platforms. We also cover other advanced concepts such as porting your Qlik View applications to Qlik Sense,and working with Qlik Cloud. Finally, you'll implement enterprise-wide security and access control for resources and data sources through practical examples. With the knowledge gained from this book, you'll have become the go-to expert in your organization when it comes to designing BI solutions using Qlik Sense.
Table of Contents (16 chapters)

Star schema fact and dimension tables

Understanding the data and business you are in is essential to building a good data model. You cannot have a working and performing model unless you know in detail not only what your data means, but how you can connect it so it makes sense.

Grab a piece of paper and start writing down what you know about your data. What are you trying to communicate? What are the most relevant fields in your data source based on your requirements? How do they relate to each other? These are pointers for you to step back and think about what you want to achieve before you actually get your hands on the data.

You can even load files or tables into an application and sense the different fields and formats, and start thinking about how to reduce your data and fields.

A star schema is a logical representation of your business into facts tables and dimensions....