Please enable JavaScript to continue!

BI Office Blogs

Posts on advanced techniques in BI Office.

TOPICS MEMBERS

Join this category to participate in conversations and receive notifications when new posts are added.

JOIN

Join

Formatting Time Duration
by @Ian Macdonald, Principal Technologist, Pyramid Analytics In many analytic applications, we may want to analyse and display the duration of activities.…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 1 reply
- 2631
- 3
- Carmelita Resh10 mths ago
- BI Office Blogs
Creating Big Lists Quickly
by @John Hormaechea , Director, Product Marketing at Pyramid Analytics When I was a presales engineer I’d come across a number of customer requests. One common one was how do I quickly create a set…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 1233
- 1
- BI Office Blogs
Simple Modeling for Everyone Using Cell Overlay
by @John Hormaechea , Director of Product Marketing at Pyramid Analytics Customers often ask “can you change that value for cost allocations” or “I want to set up custom calculation that performs an…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 2 replies
- 1128
- John Hormaechea1 yr ago
- BI Office Blogs
Axis of Awesome
by @Jason Picker, Senior Sales Engineer In your high school history class, you may have learned about the Axis of Evil, but have you heard about the Axis of Awesome?…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 796
- BI Office Blogs
Dynamic Banding in Custom KPIs - Part 3 (Variables)
by David Novick, Pyramid Analytics Technical Writer Part 3 in this blog series presents an example involving the use of variables for the definition of Custom KPI band endpoints.…
- David Novick
- Technical Writer
- David_Novick
- 1 yr ago
- 1393
- 1
- BI Office Blogs
How to Create a Date Calculation Column in Tabular Models
by @Jason Picker , Senior Sales Engineer, Pyramid Analytics This video shows how to use BI Office to add a Date Calculations attribute to a Tabular model in order to provide flexible time-dynamic…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 1 reply
- 1051
- Tim AndrewsValued Beta Tester1 yr ago
- BI Office Blogs
Advanced What-If Analysis
Today's tech blog revisits one of my personal favorites: What-If Analysis. Dan is a great presenter and teaches you how to take your analysis to the next level with advanced what-if analysis.…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 679
- 1
- BI Office Blogs
What Visualization Do I Use When?
We're revisiting this webinar which will explore various data visualizations, such as, grids, charts, gauges and advanced visualizations, and discuss how users can select the appropriate…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 518
- BI Office Blogs
Dynamic Banding in Custom KPIs - Part 2 (Evaluation Sets)
By David Novick, Pyramid Analytics Technical Writer When designing Custom KPIs in BI Office, an innovative feature called dynamic banding helps you optimize runtime gauge display.…
- David Novick
- Technical Writer
- David_Novick
- 1 yr ago
- 1483
- BI Office Blogs
Dynamic Banding in Custom KPIs - Part 1 (Intro)
By David Novick, Pyramid Analytics Technical Writer What is Dynamic Banding? When designing Custom KPIs in BI Office, a powerful feature called "dynamic banding" allows you to pre-configure KPI…
- David Novick
- Technical Writer
- David_Novick
- 1 yr ago
- 1384
- BI Office Blogs
Configuring Pyramid Analytics BI Office for Disaster Recovery
by @Joey Pruett , Presales Engineer and IT, Pyramid Analytics Introduction Pyramid Analytics BI Office is a highly available, enterprise-level BI suite that offers best-in-class performance and…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 1139
- 1
- BI Office Blogs
Creating Jittered Scatterplots in BI Office 6
by @Tim Andrews , Power User of BI Office When tasked with visualizing a relationship between a continuous and more discrete variable, a jittered scatterplot can be a necessary evil.…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 782
- 1
- BI Office Blogs
Cascading Prompts: Making your reports more dynamic
by @Kenny Rencher , Technical Product Marketing Slicers are a great way to make everything in your report dynamic. Parameterizing your members and creating sets is another great way to make your…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 8 replies
- 1644
- 1
- Nikos Volakakis1 yr ago
- BI Office Blogs
How to Personalize User Preferences on Storyboard Slicers
A common request form customers is the ability to personalize a dashboard for each user. This is similar to dynamic security but different in that instead of limiting the slicer values to those a…
- Jason Pickerstaff
- Jason_Picker
- 1 yr ago
- 1 reply
- 1191
- 2
- Tim AndrewsValued Beta Tester1 yr ago
- BI Office Blogs
Custom KPIs in BI Office
By David Novick, Pyramid Analytics Technical Writer In today’s performance driven world, the use of Key Performance Indicators (KPIs) is becoming increasingly popular throughout all business sectors.…
- David Novick
- Technical Writer
- David_Novick
- 1 yr ago
- 2004
- 2
- BI Office Blogs
Integrating Pyramid Analytics with Other Content
by @John Hormaechea , Director of Product Marketing, Pyramid Analytics Customers often have questions on how to integrate BI Office within other containers.…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 800
- BI Office Blogs
BubbleUp Exceptions
by @Forrest Dermid , Sr. Solutions Engineer, Pyramid Analytics Objective of Document: Explore one approach using a calculation to identify at the lowest level in the Microsoft SQL Server Analysis…
- Forrest Dermidstaff
- Forrest_Dermid
- 1 yr ago
- 926
- 2
- BI Office Blogs
Editing of KPI Gauges
By David Novick, Pyramid Analytics Technical Writer This blog describes how to edit KPI gauges within BI Office. These instructions apply to both SSAS KPIs in BI Office and Custom KPIs in BI Office .…
- David Novick
- Technical Writer
- David_Novick
- 1 yr ago
- 2 replies
- 1856
- 3
- Danielstaff7 mths ago
- BI Office Blogs
SSAS KPIs in BI Office
By David Novick, Pyramid Analytics Technical Writer This blog provides a quick introduction to the usage of SQL Server Analysis Services (SSAS) KPIs within BI Office.…
- David Novick
- Technical Writer
- David_Novick
- 1 yr ago
- 1738
- 1
- BI Office Blogs
Effective Dashboards Vlog - Part 3
BI Office Story Board makes presenting your business insights easy. However, designing a dashboard can be difficult as there are many levels to making it effective.…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 613
- BI Office Blogs
Effective Dashboard Design Vlog - Part 2
BI Office Story Board makes presenting your business insights easy. However, designing a dashboard can be difficult as there are many levels to making it effective.…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 799
- 1
- BI Office Blogs
Effective Dashboard Design Vlog - Part 1
BI Office Story Board makes presenting your business insights easy. However, designing a dashboard can be difficult as there are many levels to making it effective.…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 881
- 2
- BI Office Blogs
Creating a Shapefile Using Latitude and Longitude Coordinates
by @Forrest Dermid , Senior Solutions Engineer Let’s walk through how to create a shapefile using latitude and longitude coordinates. We’ll use QGis for the shapefile and Pyramid Analytics’ BI…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 5709
- BI Office Blogs
Clustering and Plotting All Observations in BI Office 6
@Tim Andrews , timandrews1@gmail.com I recently watched John Hormaechea’s webinar where he taught us how to use R functionality within BI Office. I had not found the time to fully explore the BI…
- Karen Owens
- Karen_Owens
- 1 yr ago
- 819
- 2
- BI Office Blogs
MDX-Driven Paging Mechanism
By @Michael Raam , Principal, Data Analytics This short blog provides how to create a MDX-driven paging mechanism for easy navigation through long tables.…
- Michael Raam
- Michael_Raam
- 1 yr ago
- 4 replies
- 1275
- 3
- Edward1 yr ago
- BI Office Blogs

1 2 3 4 Next

Posts on advanced techniques in BI Office.

Members

View members

Recent Tweets

Follow @PyramidAnalytic

BI Office Blogs

Formatting Time Duration

Creating Big Lists Quickly

Simple Modeling for Everyone Using Cell Overlay

Axis of Awesome

Dynamic Banding in Custom KPIs - Part 3 (Variables)

How to Create a Date Calculation Column in Tabular Models

Advanced What-If Analysis

What Visualization Do I Use When?

Dynamic Banding in Custom KPIs - Part 2 (Evaluation Sets)

Dynamic Banding in Custom KPIs - Part 1 (Intro)

Configuring Pyramid Analytics BI Office for Disaster Recovery

Creating Jittered Scatterplots in BI Office 6

Cascading Prompts: Making your reports more dynamic

How to Personalize User Preferences on Storyboard Slicers

Custom KPIs in BI Office

Integrating Pyramid Analytics with Other Content

BubbleUp Exceptions

Editing of KPI Gauges

SSAS KPIs in BI Office

Effective Dashboards Vlog - Part 3

Effective Dashboard Design Vlog - Part 2

Effective Dashboard Design Vlog - Part 1

Creating a Shapefile Using Latitude and Longitude Coordinates

Clustering and Plotting All Observations in BI Office 6

MDX-Driven Paging Mechanism

Members

Categories

Tags

Recent Tweets

Home

Tags

Key Resources