How to enable Javascript

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

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,319
- BI Office Blogs
Tableau – An Incomplete Choice for Microsoft Analysis Services
By Michael Raam , Principal Data Analytics, Pyramid Analytics Tableau connects to many data sources, including Analysis Services (SSAS). What isn’t widely known though,…
- John Hormaechea
- Director, Product Marketing
- John_Hormaechea
- 3 yrs ago
- 4,225
- 2
- BI Office Blogs
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 Resh2 yrs ago
- BI Office Blogs
Passing Multiple-Select Parameters from BI Office to SQL Server Reporting Services
by Jason Picker , Sales Engineer Pyramid Analytics There are two primary ways to pass multi-select parameters to SQL Server Reporting Services (SSRS): using standard BI Office parameters or using…
- Jason Pickerstaff
- Jason_Picker
- 3 yrs ago
- 2 replies
- 2,257
- 3
- Yakov Shaul3 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,089
- 3
- 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,941
- 3
- Danielstaff2 yrs ago
- BI Office Blogs
Time Intelligence Wizard – Part 1 (Attribute Hierarchies)
By David Novick - Technical Writer, Pyramid Analytics If you haven’t yet worked with the Time Intelligence (TI) Wizard, this blog series is meant for you. First introduced in BI Office 6.…
- David Novick
- Technical Writer
- David_Novick
- 3 yrs ago
- 1,921
- 2
- BI Office Blogs
GIS engine change following discontinued Bing Maps Silverlight Control
Geospatial upgrades BI Office Versions 5.6 and 6.3 On November 30, 2016, Microsoft is deprecating key Bing mapping functionality, the primary source of geospatial data found in BI Office.…
- John Hormaechea
- Director, Product Marketing
- John_Hormaechea
- 3 yrs ago
- 2 replies
- 1,884
- John Hormaechea4 yrs ago
- BI Office Blogs
Cluster Charts
by @Michael Raam , Principal Data Analytics - Pyramid Analytics As machine learning is becoming more and more widespread within the BI community there is a greater need to allow easy / non-technical…
- Michael Raam
- Michael_Raam
- 3 yrs ago
- 5 replies
- 1,827
- 4
- Tim AndrewsValued Beta Tester4 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
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,761
- 1
- Nikos Volakakis2 yrs ago
- BI Office Blogs
Best Practices When Upgrading BI Office
BI Office upgrades are a very straight forward process. But there are checks that should be done after any software upgrade to ensure a smooth transition for your users.…
- John Hormaechea
- Director, Product Marketing
- John_Hormaechea
- 3 yrs ago
- 5 replies
- 1,738
- 2
- Jason Pickerstaff4 yrs ago
- BI Office Blogs
Applying R to Text Analytics
by @Michael Raam , Principal Data Analytics - Pyramid Analytics and @Bar Amit Data Scientist - Pyramid Analytics As machine learning becomes more popular we are asked how Pyramid Analytics can…
- Michael Raam
- Michael_Raam
- 3 yrs ago
- 3 replies
- 1,732
- 3
- Avi PerezAdmin2 yrs ago
- BI Office Blogs
Creating Custom Waterfall Charts in BI Office
@Ian Macdonald , Principal Technologist, Pyramid Analytics A waterfall chart is a special type of column chart which is normally used to demonstrate how the starting position either increases or…
- Karen Owens
- Karen_Owens
- 3 yrs ago
- 1,577
- 2
- 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,520
- BI Office Blogs
Clustering with Mixed Data Types
by David Novick, Technical Writer, Pyramid Analytics and Bar Amit, Data Scientist, Pyramid Analytics Clustering algorithms typically create groups based on homogeneous data which can be either…
- David Novick
- Technical Writer
- David_Novick
- 3 yrs ago
- 1 reply
- 1,451
- 4
- samuel alma4 yrs ago
- 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,428
- BI Office Blogs
Time Intelligence Wizard – Part 3 (Parameterization)
by David Novick, Pyramid Analytics Technical Writer Parameters are one of those smart BI Office features that help you deliver powerful business graphics with just a few clicks of your mouse.…
- David Novick
- Technical Writer
- David_Novick
- 3 yrs ago
- 1,421
- 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
Conditional Formatting on Charts
by @Michael Raam , Principal Data Analytics - Pyramid Analytics Quite often there is a need to present a chart then cannot be found simply in the point-and-click menus within BI Office.…
- Michael Raam
- Michael_Raam
- 3 yrs ago
- 1,386
- 1
- BI Office Blogs
Custom Visuals in Pyramid Analytics
by @Michael Raam , Principal Data Analytics and Mark Khoroshansky, Development Pyramid Analytics provides a wide range of data-driven visualizations. However,…
- Michael Raam
- Michael_Raam
- 3 yrs ago
- 1,371
- 1
- BI Office Blogs
Working with DirectQuery in SQL Server Analysis Services and Pyramid Analytics' BI Office
by Matt Burr , Senior Solutions Engineer at Pyramid Analytics Someone asked recently, “Does Pyramid Analytics support DirectQuery in SQL Server Analysis Services?” The short answer is, “Yes!…
- Matt Burrstaff
- Matt_Burr
- 3 yrs ago
- 1 reply
- 1,364
- 1
- Peter Sprague4 yrs ago
- BI Office Blogs
Best Practices for BI Office from Tim Andrews
@Tim Andrews is one of our most active users in the community. We asked him to share some tips with you to help you make the most of BI Office. As a daily user of BI Office for the past two years,…
- Tim AndrewsValued Beta Tester
- Business Intelligence Manager
- Tim_Andrews
- 3 yrs ago
- 4 replies
- 1,310
- 4
- Tim AndrewsValued Beta Tester3 yrs ago
- 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
- Edward3 yrs ago
- BI Office Blogs
Using Interactions to Open a New Web Page
by Ian Macdonald , Principal Technologist - Pyramid Analytics Background One of my customers recently asked if they could open a BI Office storyboard from an interaction on a row or column heading…
- Ian MacdonaldAdmin
- Principal Technologist
- Ian_Macdonald
- 3 yrs ago
- 1,286
- 2
- 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

Creating a Shapefile Using Latitude and Longitude Coordinates

Tableau – An Incomplete Choice for Microsoft Analysis Services

Formatting Time Duration

Passing Multiple-Select Parameters from BI Office to SQL Server Reporting Services

Custom KPIs in BI Office

Editing of KPI Gauges

Time Intelligence Wizard – Part 1 (Attribute Hierarchies)

GIS engine change following discontinued Bing Maps Silverlight Control

Cluster Charts

SSAS KPIs in BI Office

Cascading Prompts: Making your reports more dynamic

Best Practices When Upgrading BI Office

Applying R to Text Analytics

Creating Custom Waterfall Charts in BI Office

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

Clustering with Mixed Data Types

Dynamic Banding in Custom KPIs - Part 1 (Intro)

Time Intelligence Wizard – Part 3 (Parameterization)

Dynamic Banding in Custom KPIs - Part 3 (Variables)

Conditional Formatting on Charts

Custom Visuals in Pyramid Analytics

Working with DirectQuery in SQL Server Analysis Services and Pyramid Analytics' BI Office

Best Practices for BI Office from Tim Andrews

MDX-Driven Paging Mechanism

Using Interactions to Open a New Web Page

Members

Categories

Tags

Recent Tweets

Home

Tags

Key Resources