Oleg Troyansky - Böcker

Unlock the meaning of your data with QlikViewThe Qlik platform was designed to provide a fast and easy data analytics tool, and QlikView Your Business is your detailed, full-color, step-by-step guide to understanding Qlikview's powerful features and techniques so you can quickly start unlocking your data’s potential. This expert author team brings real-world insight together with practical business analytics, so you can approach, explore, and solve business intelligence problems using the robust Qlik toolset and clearly communicate your results to stakeholders using powerful visualization features in QlikView and Qlik Sense.This book starts at the basic level and dives deep into the most advanced QlikView techniques, delivering tangible value and knowledge to new users and experienced developers alike. As an added benefit, every topic presented is enhanced with tips, tricks, and insightful recommendations that the authors accumulated through years of developing QlikView analytics. This is the book for you: If you are a developer whose job is to load transactional data into Qlik BI environment, and who needs to understand both the basics and the most advanced techniques of Qlik data modelling and scriptingIf you are a data analyst whose job is to develop actionable and insightful QlikView visualizations to share within your organizationIf you are a project manager or business person, who wants to get a better understanding of the Qlik Business Intelligence platform and its capabilitiesWhat You Will Learn:The book covers three common business scenarios - Sales, Profitability, and Inventory Analysis. Each scenario contains four chapters, covering the four main disciplines of business analytics: Business Case, Data Modeling, Scripting, and Visualizations. The material is organized by increasing levels of complexity. Following our comprehensive tutorial, you will learn simple and advanced QlikView and Qlik Sense concepts, including the following:Data Modeling: Transforming Transactional data into Dimensional modelsBuilding a Star SchemaLinking multiple fact tables using Link TablesCombing multiple tables into a single fact able using Concatenated Fact modelsManaging slowly changing dimensionsAdvanced date handling, using the As of Date tableCalculating running balancesBasic and Advanced Scripting: How to use the Data Load Script language for implementing data modeling techniquesHow to build and use the QVD data layerBuilding a multi-tier data architecturesUsing variables, loops, subroutines, and other script control statementsAdvanced scripting techniques for a variety of ETL solutionsBuilding Insightful Visualizations in QlikView: Introduction into QlikView sheet objects — List Boxes, Text Objects, Charts, and moreDesigning insightful Dashboards in QlikViewUsing advanced calculation techniques, such as Set Analysis and Advanced AggregationUsing variables for What-If Analysis, as well as using variables for storing calculations, colors, and selection filtersAdvanced visualization techniques - normalized and non-normalized Mekko charts, Waterfall charts, Whale Tail charts, and moreBuilding Insightful Visualizations in Qlik Sense: Introducing Qlik Sense - how it is different from QlikView and what is similar?Creating Sense sheet objectsBuilding and using the Library of Master ItemsExploring Qlik Sense unique features — Storytelling, Geo Mapping, and using ExtensionsWhether you are just starting out with QlikView or are ready to dive deeper, QlikView Your Business is your comprehensive guide to sharpening your QlikView skills and unleashing the power of QlikView in your organization.