Pyramid
Solutions
Learn
Company
Pyramid Analytics
User Community
How to enable Javascript
Sign Up
Login
Home
BI Office
BI Office Blogs
Posts on advanced techniques in BI Office.
TOPICS
MEMBERS
Filter
Newest
Active
Popular
Most likes
Most replies
Most views
Tags
Clear filter
Search
Join this category to participate in conversations and receive notifications when new posts are added.
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
3 yrs ago
1
reply
2,689
3
Carmelita Resh
2 yrs 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
3 yrs ago
1,255
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
3 yrs ago
2
replies
1,153
John Hormaechea
3 yrs 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
3 yrs ago
851
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
3 yrs ago
1,414
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
3 yrs ago
1
reply
1,108
Tim Andrews
Valued Beta Tester
3 yrs 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
3 yrs ago
703
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
3 yrs ago
533
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
3 yrs ago
1,522
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
3 yrs ago
1,429
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
3 yrs ago
1,175
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
3 yrs ago
794
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
3 yrs ago
8
replies
1,767
1
Nikos Volakakis
2 yrs 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 Picker
staff
Jason_Picker
3 yrs ago
1
reply
1,213
2
Tim Andrews
Valued Beta Tester
3 yrs 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
3 yrs ago
2,091
3
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
3 yrs ago
885
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 Dermid
staff
Forrest_Dermid
3 yrs ago
967
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
3 yrs ago
2
replies
1,944
3
Daniel
staff
2 yrs 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
3 yrs ago
1,762
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
3 yrs ago
629
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
3 yrs ago
805
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
3 yrs ago
897
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
3 yrs ago
6,325
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
3 yrs ago
829
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
3 yrs ago
4
replies
1,303
3
Edward
3 yrs ago
BI Office Blogs
1
2
3
4
Next
Posts on advanced techniques in BI Office.
Members
View members
Categories
Pyramid
Blogs
Product Ideas
Current Product Ideas
Completed Product Ideas
Product Announcements
Tutorial Videos
Technical Solutions
General
Performance
Databases
Security / Web
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Getting Started
Using BI Office
BI Office Installation & Configuration
Troubleshooting
Tags
View all tags
Recent Tweets
Follow @PyramidAnalytic
Home
Pyramid
Blogs
Product Ideas
Current Product Ideas
Completed Product Ideas
Product Announcements
Tutorial Videos
Technical Solutions
General
Performance
Databases
Security / Web
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Getting Started
Using BI Office
BI Office Installation & Configuration
Troubleshooting
Tags
View all tags
Key Resources
Community Tour
Register for Training Webinars
Newsletters, Events, and Webinars
Learning Resources
Pyramid Tutorial Videos
Pyramid Help
Getting Started with Pyramid
BI Office
BI Office Help