Categories
Ebooks
-
Business and economy
- Bitcoin
- Businesswoman
- Coaching
- Controlling
- E-business
- Economy
- Finances
- Stocks and investments
- Personal competence
- Computer in the office
- Communication and negotiation
- Small company
- Marketing
- Motivation
- Multimedia trainings
- Real estate
- Persuasion and NLP
- Taxes
- Social policy
- Guides
- Presentations
- Leadership
- Public Relation
- Reports, analyses
- Secret
- Social Media
- Sales
- Start-up
- Your career
- Management
- Project management
- Human Resources
-
For children
-
For youth
-
Education
-
Encyclopedias, dictionaries
-
E-press
- Architektura i wnętrza
- Biznes i Ekonomia
- Home and garden
- E-business
- Finances
- Personal finance
- Business
- Photography
- Computer science
- HR & Payroll
- Computers, Excel
- Accounts
- Culture and literature
- Scientific and academic
- Environmental protection
- Opinion-forming
- Education
- Taxes
- Travelling
- Psychology
- Religion
- Agriculture
- Book and press market
- Transport and Spedition
- Healthand beauty
-
History
-
Computer science
- Office applications
- Data bases
- Bioinformatics
- IT business
- CAD/CAM
- Digital Lifestyle
- DTP
- Electronics
- Digital photography
- Computer graphics
- Games
- Hacking
- Hardware
- IT w ekonomii
- Scientific software package
- School textbooks
- Computer basics
- Programming
- Mobile programming
- Internet servers
- Computer networks
- Start-up
- Operational systems
- Artificial intelligence
- Technology for children
- Webmastering
-
Other
-
Foreign languages
-
Culture and art
-
School reading books
-
Literature
- Antology
- Ballade
- Biographies and autobiographies
- For adults
- Dramas
- Diaries, memoirs, letters
- Epic, epopee
- Essay
- Fantasy and science fiction
- Feuilletons
- Work of fiction
- Humour and satire
- Other
- Classical
- Crime fiction
- Non-fiction
- Fiction
- Mity i legendy
- Nobelists
- Novellas
- Moral
- Okultyzm i magia
- Short stories
- Memoirs
- Travelling
- Narrative poetry
- Poetry
- Politics
- Popular science
- Novel
- Historical novel
- Prose
- Adventure
- Journalism, publicism
- Reportage novels
- Romans i literatura obyczajowa
- Sensational
- Thriller, Horror
- Interviews and memoirs
-
Natural sciences
-
Social sciences
-
School textbooks
-
Popular science and academic
- Archeology
- Bibliotekoznawstwo
- Cinema studies
- Philology
- Polish philology
- Philosophy
- Finanse i bankowość
- Geography
- Economy
- Trade. World economy
- History and archeology
- History of art and architecture
- Cultural studies
- Linguistics
- Literary studies
- Logistics
- Maths
- Medicine
- Humanities
- Pedagogy
- Educational aids
- Popular science
- Other
- Psychology
- Sociology
- Theatre studies
- Theology
- Economic theories and teachings
- Transport i spedycja
- Physical education
- Zarządzanie i marketing
-
Guides
-
Game guides
-
Professional and specialist guides
-
Law
- Health and Safety
- History
- Road Code. Driving license
- Law studies
- Healthcare
- General. Compendium of knowledge
- Academic textbooks
- Other
- Construction and local law
- Civil law
- Financial law
- Economic law
- Economic and trade law
- Criminal law
- Criminal law. Criminal offenses. Criminology
- International law
- International law
- Health care law
- Educational law
- Tax law
- Labor and social security law
- Public, constitutional and administrative law
- Family and Guardianship Code
- agricultural law
- Social law, labour law
- European Union law
- Industry
- Agricultural and environmental
- Dictionaries and encyclopedia
- Public procurement
- Management
-
Tourist guides and travel
- Africa
- Albums
- Southern America
- North and Central America
- Australia, New Zealand, Oceania
- Austria
- Asia
- Balkans
- Middle East
- Bulgary
- China
- Croatia
- The Czech Republic
- Denmark
- Egipt
- Estonia
- Europe
- France
- Mountains
- Greece
- Spain
- Holand
- Iceland
- Lithuania
- Latvia
- Mapy, Plany miast, Atlasy
- Mini travel guides
- Germany
- Norway
- Active travelling
- Poland
- Portugal
- Other
- Russia
- Romania
- Slovakia
- Slovenia
- Switzerland
- Sweden
- World
- Turkey
- Ukraine
- Hungary
- Great Britain
- Italy
-
Psychology
- Philosophy of life
- Kompetencje psychospołeczne
- Interpersonal communication
- Mindfulness
- General
- Persuasion and NLP
- Academic psychology
- Psychology of soul and mind
- Work psychology
- Relacje i związki
- Parenting and children psychology
- Problem solving
- Intellectual growth
- Secret
- Sexapeal
- Seduction
- Appearance and image
- Philosophy of life
-
Religion
-
Sport, fitness, diets
-
Technology and mechanics
Audiobooks
-
Business and economy
- Bitcoin
- Businesswoman
- Coaching
- Controlling
- E-business
- Economy
- Finances
- Stocks and investments
- Personal competence
- Communication and negotiation
- Small company
- Marketing
- Motivation
- Real estate
- Persuasion and NLP
- Taxes
- Guides
- Presentations
- Leadership
- Public Relation
- Secret
- Social Media
- Sales
- Start-up
- Your career
- Management
- Project management
- Human Resources
-
For children
-
For youth
-
Education
-
Encyclopedias, dictionaries
-
History
-
Computer science
-
Other
-
Foreign languages
-
Culture and art
-
School reading books
-
Literature
- Antology
- Ballade
- Biographies and autobiographies
- For adults
- Dramas
- Diaries, memoirs, letters
- Epic, epopee
- Essay
- Fantasy and science fiction
- Feuilletons
- Work of fiction
- Humour and satire
- Other
- Classical
- Crime fiction
- Non-fiction
- Fiction
- Mity i legendy
- Nobelists
- Novellas
- Moral
- Okultyzm i magia
- Short stories
- Memoirs
- Travelling
- Poetry
- Politics
- Popular science
- Novel
- Historical novel
- Prose
- Adventure
- Journalism, publicism
- Reportage novels
- Romans i literatura obyczajowa
- Sensational
- Thriller, Horror
- Interviews and memoirs
-
Natural sciences
-
Social sciences
-
Popular science and academic
-
Guides
-
Professional and specialist guides
-
Law
-
Tourist guides and travel
-
Psychology
- Philosophy of life
- Interpersonal communication
- Mindfulness
- General
- Persuasion and NLP
- Academic psychology
- Psychology of soul and mind
- Work psychology
- Relacje i związki
- Parenting and children psychology
- Problem solving
- Intellectual growth
- Secret
- Sexapeal
- Seduction
- Appearance and image
- Philosophy of life
-
Religion
-
Sport, fitness, diets
-
Technology and mechanics
Videocourses
-
Data bases
-
Big Data
-
Biznes, ekonomia i marketing
-
Cybersecurity
-
Data Science
-
DevOps
-
For children
-
Electronics
-
Graphics/Video/CAX
-
Games
-
Microsoft Office
-
Development tools
-
Programming
-
Personal growth
-
Computer networks
-
Operational systems
-
Software testing
-
Mobile devices
-
UX/UI
-
Web development
-
Management
Podcasts
- Ebooks
- Big data
- Data analysis
- Business Intelligence with MicroStrategy Cookbook. Over 90 practical, hands-on recipes to help you build your MicroStrategy business intelligence project, including more than a 100 screencasts with this book and
E-book details
Log in, If you're interested in the contents of the item.
Business Intelligence with MicroStrategy Cookbook. Over 90 practical, hands-on recipes to help you build your MicroStrategy business intelligence project, including more than a 100 screencasts with this book and
Ebook
Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. MicroStrategy Reporting Suite is a complete business intelligence platform that covers all the data analysis needs of an enterprise. Scorecards, dashboards, and reports can be explored and delivered on desktop, the Web, mobile devices, and the Cloud. With the latest Visual Insight tool, MicroStrategy brings the power of BI to the business users, allowing them to discover information without the help of IT personnel.
Business Intelligence with MicroStrategy Cookbook covers the full cycle of a BI project with the MicroStrategy platform, from setting up the software to using dashboards in the cloud and on mobile devices. This book uses step-by-step instructions to teach you everything from the very basics to the more advanced topics. We will start by downloading and installing the software and a well-known sample SQL Server database. Then, one brick at a time, we will construct a fully-featured BI solution with a web interface, mobile reporting, and agile analytics.
The chapters are ordered by increasing difficulty, and each one builds on top of the preceding chapter so that the learning process is progressive. The examples given in this book are practical, and you will be able to see the immediate result of your efforts. We will first cover setting up the platform, including the creation of the metadata and the different objects that are part of a BI project: tables, attributes, and metrics. Then, we take a look at how to create and analyze reports, charts, documents, and dashboards, as well as how to manipulate data with the desktop application, the web Interface, and an iPad device.
The last part of the book is dedicated to advanced topics like the new agile analytics technology from MicroStrategy, where we cover both Visual Insight and MicroStrategy Cloud Express. Whether you are a database developer, data analyst, or a business user, Business Intelligence with MicroStrategy Cookbook will get you up to speed with one of the most powerful BI platforms on the market with the smallest possible investment of time and money.
Business Intelligence with MicroStrategy Cookbook covers the full cycle of a BI project with the MicroStrategy platform, from setting up the software to using dashboards in the cloud and on mobile devices. This book uses step-by-step instructions to teach you everything from the very basics to the more advanced topics. We will start by downloading and installing the software and a well-known sample SQL Server database. Then, one brick at a time, we will construct a fully-featured BI solution with a web interface, mobile reporting, and agile analytics.
The chapters are ordered by increasing difficulty, and each one builds on top of the preceding chapter so that the learning process is progressive. The examples given in this book are practical, and you will be able to see the immediate result of your efforts. We will first cover setting up the platform, including the creation of the metadata and the different objects that are part of a BI project: tables, attributes, and metrics. Then, we take a look at how to create and analyze reports, charts, documents, and dashboards, as well as how to manipulate data with the desktop application, the web Interface, and an iPad device.
The last part of the book is dedicated to advanced topics like the new agile analytics technology from MicroStrategy, where we cover both Visual Insight and MicroStrategy Cloud Express. Whether you are a database developer, data analyst, or a business user, Business Intelligence with MicroStrategy Cookbook will get you up to speed with one of the most powerful BI platforms on the market with the smallest possible investment of time and money.
- Business Intelligence with MicroStrategy Cookbook
- Table of Contents
- Business Intelligence with MicroStrategy Cookbook
- Credits
- Foreword
- About the Author
- About the Reviewers
- www.PacktPub.com
- Support files, eBooks, discount offers and more
- Why Subscribe?
- Free Access for Packt account holders
- Instant Updates on New Packt Books
- Support files, eBooks, discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Downloading the example code
- Errata
- Piracy
- Questions
- 1. Getting Started with MicroStrategy
- Introduction
- Installing SQL Server 2012 Express LocalDB
- Getting ready
- How to do it...
- How it works...
- Theres more...
- Installing SQL Server Native Client 11.0
- Getting ready
- How to do it...
- How it works...
- There's more...
- Installing SQL Server 2012 Command Line Utilities
- Getting ready
- How to do it...
- There's more...
- Setting up the AdventureWorks DW sample database
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 1
- Installing the .NET Framework 4.0 and the 4.0.2 update
- How to do it...
- How it works...
- Checking whether IIS is enabled and working
- Getting ready
- How to do it...
- How it works...
- There's more...
- Installing MicroStrategy Suite
- Getting ready
- How to do it...
- There's more...
- Registering the MicroStrategy License
- Getting ready
- How to do it...
- There's more....
- Metadata and data warehouse
- Getting ready
- How to do it...
- How it works...
- There's more...
- Creating ODBC DSN for metadata and data warehouse
- Getting ready
- How to do it...
- How it works...
- There's more...
- Modifying the logon account for the Intelligence Server
- Getting ready
- How to do it...
- How it works...
- There's more...
- Creating the metadata and configuring the Intelligence Server
- Getting ready
- How to do it...
- How it works...
- There's more...
- Opening the MicroStrategy Desktop application
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 2. The First Steps in a MicroStrategy Project
- Introduction
- Creating an empty project
- Getting ready
- How to do it...
- How it works...
- There's more...
- Setting up a data warehouse connection and selecting tables
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 2
- Exercise 3
- Modifying a table structure
- Getting ready
- How to do it...
- How it works...
- Using logical tables to create custom views
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 4
- Generating constants with SELECT statements
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 3. Schema Objects Attributes
- Introduction
- Attribute forms ID and DESC
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using functions in an attribute form
- Getting ready
- How to do it...
- How it works...
- There's more...
- Parent-child relationship I
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 5
- Parent-child relationship II
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 6
- Other attribute forms
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 7
- Selecting which forms are displayed
- Getting ready
- How to do it...
- How it works...
- There's more...
- Building Data Explorer Hierarchies
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 8
- Exercise 9
- Exercise 10
- Creating an attribute-only report
- Getting ready
- How to do it...
- How it works...
- There's more...
- Parent-child relationship in a report
- Getting ready
- How to do it...
- How it works...
- There's more...
- Filters on attributes
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 11
- See also
- 4. Objects Facts and Metrics
- Introduction
- Creating a simple counter fact and metric
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 12
- Exercise 13
- Using SQL View to inspect SELECT statements
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 14
- Understanding the GROUP BY clause
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 15
- Adding more facts
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 16
- Exercise 17
- Exercise 18
- Filters on metrics
- Getting ready
- How to do it...
- How it works...
- There's more...
- Creating ranking metrics
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 19
- Grouping at a different level (level metrics)
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 20
- Embedding filters inside metrics
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 21
- Using Metric Join Type in reports
- Getting ready
- How to do it...
- How it works...
- There's more...
- More Info
- Creating a previous month metric (transformation)
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 22
- See also
- 5. Data Display and Manipulation Reports
- Introduction
- Going deeper into data with drill down
- Getting ready
- How to do it...
- How it works...
- There's more...
- More Info
- Manipulating grids Pivot and page-by
- Getting ready
- How to do it...
- How it works...
- There's more...
- Dynamically adding and removing objects in reports
- Getting ready
- How to do it...
- How it works...
- There's more...
- More Info
- The bottom line customizing subtotals
- Getting ready
- How to do it...
- How it works...
- There's more...
- More Info
- Avoiding missteps NULL values in facts
- Getting ready
- How to do it...
- How it works...
- There's more...
- How to sort data in grids
- Getting ready
- How to do it...
- How it works...
- There's more...
- Sorting NULLs
- Emphasizing numbers with conditional formatting
- Getting ready
- How to do it...
- How it works...
- There's more...
- Printing and exporting reports
- Getting ready
- How to do it...
- How it works...
- There's more...
- Restricting results with view filters
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 23
- See also
- 6. Data Analysis and Visualization Graphs
- Introduction
- Displaying both grid and graph in the same view
- Getting ready
- How to do it...
- How it works...
- There's more...
- More Info
- Drag-and-drop objects using drop zones
- Getting ready
- How to do it...
- How it works...
- There's more...
- Beautify your chart
- Getting ready
- How to do it...
- How it works...
- There's more...
- Display multiple metrics with dual axis charts
- Getting ready
- How to do it...
- How it works...
- There's more...
- Conditional formatting with thresholds
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 24
- See also
- 7. Analysis on the Web Documents and Dashboards
- Introduction
- Setting up MicroStrategy Web
- Getting ready
- How to do it...
- How it works...
- There's more...
- More Info
- Creating your first "Hello World" document
- Getting ready
- How to do it...
- How it works...
- There's more...
- Adding data to a document the dataset
- Getting ready
- How to do it...
- How it works...
- There's more...
- Modifying the grouping in a document
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 25
- Stepping up to dashboards
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using the editable mode to fine-tune the design
- Getting ready
- How to do it...
- How it works...
- There's more...
- Adding interactivity with panels and selectors
- Getting ready
- How to do it...
- How it works...
- There's more...
- Embedding images, HTML, and links
- Getting ready
- How to do it...
- How it works...
- There's more...
- Switching to Adobe Flash mode
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 8. Dynamic Selection with Filters and Prompts
- Introduction
- Restricting rows compare an attribute to another attribute
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 26
- Restricting rows evaluate on moving dates
- Getting ready
- How to do it...
- How it works...
- There's more...
- More Info
- Exercise 27
- Changing the level of a metric filter
- Getting ready
- How to do it...
- How it works...
- There's more...
- Adding interactivity to filters using prompts
- Getting ready
- How to do it...
- How it works...
- There's more...
- More Info
- Using prompts as object selectors
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 9. Mobile BI for Developers
- Introduction
- Setting up the Mobile Server
- Getting ready
- How to do it...
- How it works...
- There's more...
- Setting up a mobile connection
- Getting ready
- How to do it...
- How it works...
- There's more...
- Installing and configuring the mobile client
- Getting ready
- How to do it...
- How it works...
- There's more...
- More Info
- Adapting content to the iPad screen
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 28
- Using mobile views in documents
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 29
- Adding panels to mobile documents
- Getting ready
- How to do it...
- How it works...
- There's more...
- Creating panel selectors
- Getting ready
- How to do it...
- How it works...
- There's more...
- Adding details with pop-up windows
- Getting ready
- How to do it...
- How it works...
- There's more...
- Linking from one document to another
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 10. Mobile BI for Users
- Introduction
- Answering prompts in reports or documents
- Getting ready
- How to do it...
- How it works...
- There's more...
- Sorting, drilling, and paging
- Getting ready
- How to do it...
- How it works...
- There's more...
- Adding notes and sharing
- Getting ready
- How to do it...
- How it works...
- There's more...
- When things go wrong
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 11. Consolidations, Custom Groups, and Transformations
- Introduction
- Creating virtual attributes with consolidations
- Getting ready
- How to do it...
- How it works...
- There's more...
- More Info
- Exercise 30
- Aggregating results with custom groups
- Getting ready
- How to do it...
- How it works...
- There's more...
- More Info
- Exercise 31
- Creating bands on metrics (custom groups banding)
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 32
- Month-to-date and year-to-date transformations
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 32
- See also
- 12. In-Memory Cubes and Visual Insight
- Introduction
- Creating a cube from an existing report
- Getting ready
- How to do it...
- How it works...
- There's more...
- Building a new cube
- Getting ready
- How to do it...
- How it works...
- There's more...
- Scheduling data refresh
- Getting ready
- How to do it...
- How it works...
- There's more...
- Creating reports and documents based on a cube
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exploring data with Visual Insight
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using the network visualization
- Getting ready
- How to do it...
- How it works...
- There's more...
- Exercise 34
- See also
- 13. MicroStrategy Express
- Introduction
- Creating an Express account
- Getting ready
- How to do it
- How it works
- There's more
- Importing Excel data
- Getting ready
- How to do it
- How it works
- There's more
- Using filters
- Getting ready
- How to do it
- How it works
- There's more
- Importing cross-tabbed data
- Getting ready
- How to do it
- How it works
- There's more
- Connecting to a RDBMS
- Getting ready
- How to do it
- How it works
- There's more
- Exercise 35
- Refreshing dashboard data
- Getting ready
- How to do it
- How it works
- There's more
- Sharing a dashboard by e-mail
- Getting ready
- How to do it
- How it works
- There's more
- Sharing from the free account
- See also
- A. Solution to Exercises
- Exercise 1
- Exercise 2
- Exercise 3
- Exercise 4
- Exercise 5
- Exercise 6
- Exercise 7
- Exercise 8
- Exercise 9
- Exercise 10
- Exercise 11
- Exercise 12
- Exercise 13
- Exercise 14
- Exercise 15
- Exercise 16
- Exercise 17
- Exercise 18
- Exercise 19
- Exercise 20
- Exercise 21
- Exercise 22
- Exercise 23
- Exercise 24
- Exercise 25
- Exercise 26
- Exercise 27
- Exercise 28
- Exercise 29
- Exercise 30
- Exercise 31
- Exercise 32
- Exercise 33
- Exercise 34
- Exercise 35
- B. Where to Look for Information
- Online resources
- Blogs
- Books
- C. Cloudera Hadoop
- Introduction
- Connecting to a Hadoop database
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- D. HP Vertica
- Introduction
- Connecting to a Vertica database
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Index
- Title: Business Intelligence with MicroStrategy Cookbook. Over 90 practical, hands-on recipes to help you build your MicroStrategy business intelligence project, including more than a 100 screencasts with this book and
- Author: Davide Moraschi
- Original title: Business Intelligence with MicroStrategy Cookbook. Over 90 practical, hands-on recipes to help you build your MicroStrategy business intelligence project, including more than a 100 screencasts with this book and ebook
- ISBN: 9781782179764, 9781782179764
- Date of issue: 2013-10-26
- Format: Ebook
- Item ID: e_3cij
- Publisher: Packt Publishing