QlikView Your Business
Реклама. ООО «ЛитРес», ИНН: 7719571260.
Оглавление
Troyansky Oleg. QlikView Your Business
I. Getting Started
Chapter 1. The Needs and Challenges of Business Intelligence and Analytics
The Case for Business Intelligence
Common Challenges of Business Analytics
How Successful Businesses Use Business Intelligence
The Business Scenario Used in the Book
Chapter 2. Why Use Qlik for Data Discovery and Analytics?
The Evolution of BI
QlikView 11 Overview
Qlik Sense Overview
II. Learning the Core Techniques: Sales Analysis
Chapter 3. Defining a Business Scenario for Sales Analysis
“What Do You Mean When You Say Sales?”
What Data Is Needed
Advanced Sales Analysis Makes the Data Visible and Available
Chapter 4. Visualizing Sales Analysis in QlikView
Preparing the Environment and Getting Ready
List Boxes, Text Objects, and Other Sheet Objects
Developing Simple Charts in QlikView
First Round of Improvements
Chapter 5. Data Modeling for Sales Analysis
Data Modeling Basics
Chapter 6. Developing a Data Load Script for Sales Analysis
Load Script and Script Editor
Resolving Simple Challenges in Data Load
Transforming the Data Model
III. Expanding Your Skill Set: Profitability Analysis
Chapter 7. Defining a Business Scenario for Profitability Analysis
The Profit and Loss Statement
The Direct Variable Profitability (DVP) Model
Deep Dive Example
Use of Business Intelligence Tools Makes the Data Visible and Available
Chapter 8. Visualizing Profitability Analysis in QlikView
Simple Visualizations for Profitability Analysis
Revisiting Simple Visualization Objects
Learning Advanced Visualizations
Chapter 9. Data Modeling for Profitability Analysis
How QlikView Stores Data
Modeling Multiple Transaction Sources
Working With Dimensions
Chapter 10. Developing a Data Load Script for Profitability Analysis
Creating a QVD Data Layer
Building the Data Model for Profitability Analysis
A Round of Improvements
Explaining the Multi-Tier Data Architecture
IV. Mastering Advanced Techniques: Inventory Analysis
Chapter 11. Defining a Business Scenario for Inventory Analysis
What Is Inventory – Asset or Liability?
Factors to Consider When Measuring Inventory
The Definition of Inventory Analysis
The Benefits of Advanced Inventory Analysis
Chapter 12. Visualizing Inventory Analysis in QlikView
Developing the Key Measures for Inventory Analysis
Enhancing Visual Analysis with Advanced Aggregation
Does It Get Any More Advanced with Advanced Aggregation and Advanced Set Analysis?
Comparative Analysis Using Alternate States
Getting Advanced with Straight Tables
Advanced Presentation Features – Buttons, Actions, and Triggers
Chapter 13. Data Modeling for Inventory Analysis
Calculating Running Balances
The Concatenated Fact Table
Advanced Date Handling
Chapter 14. Developing a Data Load Script for Inventory Analysis
Review of the Business Requirements and the Data Sources
Transforming Inventory Data
Building the Concatenated Fact Table
Building the As Of Date Table
Generating Chart Expressions in the Script
A Few Words in Conclusion
V. Qlik Sense
Chapter 15. Loading Data in Qlik Sense
Getting Oriented with Qlik Sense
Using Quick Data Load
Using the Data Load Editor
Using Developer Tools
Chapter 16. Developing Visualizations in Qlik Sense
Exploring the Qlik Sense Visual Environment
Selections in Qlik Sense
Storytelling
Geo-Mapping in Qlik Sense
Integrating Qlik Sense Apps
Appendix. What’s Next?
Copyright
About the Authors
About the Technical Editors
Acknowledgments
Foreword
Introduction
Overview of the Book and Technology
How This Book Is Organized
How to Read This Book
Conventions
Preparing Your Work Environment
WILEY END USER LICENSE AGREEMENT
Отрывок из книги
Every day we are confronted by the challenges of our business, whether we work in the boiler room or the board room. We worry about how to make things work in the best possible way and we worry about avoiding mistakes that can cause things to go wrong. There are a lot of moving parts to any business and it takes a number of people to monitor and manage those moving parts. The fact that there are challenges to managing your enterprise is not a new revelation. Challenges are the main reasons we face some amount of stress in our jobs each time we care enough to “get it right.” The question is not just, “What am I supposed to be doing right now?” but, “Where are the current and potential problem areas that will prevent me and my business from succeeding?”
This chapter begins to address those questions and provides some insight into the ways this book will help you answer them. You will learn what business intelligence (BI) is, and the analytics that drive an understanding of the strengths and opportunities that exist in your business.
.....
Now, let’s step back and admit that this book can’t possibly represent all the complexities of a real-life business environment and a real-life business system. For the purposes of this educational environment, we built a “straw man” of a company, with a simplified straw man of the data set. This is the classroom version of business analytics. Real life is infinitely more complex and demanding.
The methods and techniques described here, however, are very much real. Understanding and applying these techniques to your real-life environment will enable you and your team to develop powerful analytic solutions to your real-life business challenges.
.....