QlikView Your Business (häftad)
Häftad (Paperback / softback)
Antal sidor
John Wiley & Sons Inc
Bjork, Lars (foreword)
231 x 188 x 38 mm
1298 g
Antal komponenter

QlikView Your Business

An Expert Guide to Business Discovery with QlikView and Qlik Sense

Häftad,  Engelska, 2015-10-09
Billigast på PriceRunner
  • Skickas från oss inom 5-8 vardagar.
  • Fri frakt över 249 kr för privatkunder i Sverige.
Finns även som
Visa alla 2 format & utgåvor
Unlock the meaning of your data with QlikView The 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 datas 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 scripting If you are a data analyst whose job is to develop actionable and insightful QlikView visualizations to share within your organization If you are a project manager or business person, who wants to get a better understanding of the Qlik Business Intelligence platform and its capabilities What 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 models Building a Star Schema Linking multiple fact tables using Link Tables Combing multiple tables into a single fact able using Concatenated Fact models Managing slowly changing dimensions Advanced date handling, using the As of Date table Calculating running balances Basic and Advanced Scripting: How to use the Data Load Script language for implementing data modeling techniques How to build and use the QVD data layer Building a multi-tier data architectures Using variables, loops, subroutines, and other script control statements Advanced scripting techniques for a variety of ETL solutions Building Insightful Visualizations in QlikView: Introduction into QlikView sheet objects List Boxes, Text Objects, Charts, and more Designing insightful Dashboards in QlikView Using advanced calculation techniques, such as Set Analysis and Advanced Aggregation Using variables for What-If Analysis, as well as using variables for storing calculations, colors, and selection filters Advanced visualization techniques - normalized and non-normalized Mekko charts, Waterfall charts, Whale Tail charts, and more Building Insightful Visualizations in Qlik Sense: Introducing Qlik Sense - how it is different from QlikView and what is similar? Creating Sense sheet objects Building and using the Library of Master Items Exploring Qlik Sense unique features Storytelling, Geo Mapping, and using Extensions Whether 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.
Visa hela texten

Passar bra ihop

  1. QlikView Your Business
  2. +
  3. Never Split the Difference

De som köpt den här boken har ofta också köpt Never Split the Difference av Chris Voss, Tahl Raz (häftad).

Köp båda 2 för 752 kr


Har du läst boken? Sätt ditt betyg »

Fler böcker av författarna

  • Your Best Golf Begins After 50

    Tammy Gibson, Barry Gibson

    Your Best Golf Begins After 50 helps middle aged golfers continue to play their best golf and stay healthy as they age. Your Best Golf Begins After 50 offers a unique approach for golfers who feel their technique is changing, becoming more inconsi...

Övrig information

OLEG TROYANSKY is the President of Natural Synergies, the first North American BI firm that was created with the focus on QlikView solutions, services and education. He is a well-known QlikView educator and advocate, a 2014 QlikView luminary and a speaker at the Masters Summit for QlikView. TAMMY GIBSON is a Senior QlikView Consultant at Natural Synergies. She's been developing QlikView solutions since 2004. She is also the co-founder and CTO of VenueCube, a company providing business intelligence analytics to entertainment venues and convention centers. CHARLES LEICHTWEIS is a Senior Advisor of Phoenix Strategic Advisors and the head of their Sustainable Profitable Growth Practice. Charlie has led companies in a variety of "C" suite roles in a career that spans 30 plus years. He holds an MBA in Operations Management, and is a CPA and CMA.


Foreword xiii Introduction xv PART I Getting Started Chapter 1 The Needs and Challenges of Business Intelligence and Analytics 3 The Case for Business Intelligence 4 Common Challenges of Business Analytics 6 How Successful Businesses Use Business Intelligence 7 Introducing the Six Process Spheres 7 Identifying Business Measures 10 What Companies Gain from Implementing BI 14 The Business Scenario Used in the Book 16 Chapter 2 Why Use Qlik for Data Discovery and Analytics? 17 The Evolution of BI 18 Traditional Business Intelligence (OLAP) 18 Qliks Disruptive Approach to BI 20 Data Discovery Is the New Black 22 QlikView 11 Overview 23 In-Memory Storage Means No Need for Pre-Calculated Cubes 23 An Interactive User Experience 24 Associative Logic Powers Data Discovery 26 Right-Sized Analytics 32 Qlik Sense Overview 32 PART II Learning the Core Techniques: Sales Analysis Chapter 3 Defining a Business Scenario for Sales Analysis 41 What Do You Mean When You Say Sales? 42 What Is the Real Value of the Sale? 43 What Happened? 45 Why Did it Happen? What Does It Mean for My Business? 46 What Data Is Needed 50 Advanced Sales Analysis Makes the Data Visible and Available 51 Chapter 4 Visualizing Sales Analysis in QlikView 53 Preparing the Environment and Getting Ready 54 Opening a Template Document 54 Sheets and Sheet Objects 57 Working with Colors in QlikView 59 List Boxes, Text Objects, and Other Sheet Objects 60 Introducing List Boxes and Multi Boxes 61 Table Box and How It Should (Not) Be Used 65 Using Text Objects for Labels, Images, and Backgrounds 66 Line/Arrow Object 69 Mind Your Selections: Search Object and Current Selections Box 70 Organizing and Arranging Objects on the Screen 73 Developing Simple Charts in QlikView 78 Main Components of QlikView Charts 79 Using Bar Charts to Compare Outcomes Among Brands, Channels, and Salespeople 82 Using Line Charts to Visualize Trends over Time 92 Using Pie Charts to Visualize Distribution of the Whole Between its Parts 97 Using Straight Tables and Pivot Tables to Show Details 100 First Round of Improvements 111 Gathering Feedback at the First Application Review 111 Using Groups to Add Flexibility to Your Charts 113 Comparing YTD to Prior YTD or Other Conditions 118 Building Dashboards 129 Bringing It All Together 140 Chapter 5 Data Modeling for Sales Analysis 145 Data Modeling Basics 146 The Transactional Software Class 147 Using ETL to Populate Dimensional Tables 155 Designing a Data Model for Sales Analysis 159 Tips Before You Start Scripting 168 Chapter 6 Developing a Data Load Script for Sales Analysis 169 Load Script and Script Editor 170 Script Editor Basics in QlikView 170 Anatomy of a QlikView SQL Select Statement 177 Organizing Your Script 179 Using the Table Viewer and Understanding the Data Model 186 Resolving Simple Challenges in Data Load 188 Introducing Synthetic Keys and Circular References 189 Avoiding Synthetic Keys by Renaming Fields 191 Using the QUALIFY and UNQUALIFY Commands 192 A Few Words About Naming Conventions 196 Transforming the Data Model 197 Loading Data from a Spreadsheet 198 Enhancing the Data Model for Online Analytics 204 Joining Two Tables into One 207 Adding Calculated Fields 213 Additional Transformations: Calculating Conditional Flags 222 Adding a Master Calendar Table Using INCLUDE 233 PART III Expanding Your Skill Set: Profitability Analysis Chapter 7 Defining a Business Scenario for Profitability Analysis 241 The Profit and Loss Statement 242 The Direct Variable Profitability (DVP) Model 245 Deep Dive Example 248 Use of Business Intelligence Tools Makes the Data Visible and Available 251 Chapter 8 Visualizing Profitability Analysis in QlikView 253 Simple Visualizations for Profitability Analysis 254 Preparing the Template for Profitability Analysis 254 Preparing