reckon conf2015 (au) business intelligence on the go
TRANSCRIPT
BUSINESS INTELLIGENCE ON THE GO
Shane Ainsworth, John Barber
RUN SHEET
Business Intelligence Practice IQ10 Choice (right tool for the job) Takeaway facts
BUSINESS INTELLIGENCEChanging data into informationInformation leading to actionWhat has happened, Why did it happen, What is happening, What will happen, What do we want to happenRight format, Right delivery, Right timeNot just PIQ
PRACTICE IQ 10OWC Replacement64 bit cross browser website compatibility (mobility)Additional administration optionsConsolidated solutionIncremental updateEnhance data uploadsNew out of the box dashboards
PIQ 10 UXWebsitePivots
SSRS
Data Entry
Console
Website
SSRS
ExcelStandard
PowerPivot
PowerView
MobileWebsite
Other
SharePoint
BPA
Tax
CRM
XPA
External
Workflow
PIQ 10 Solution
PM / Tax / XPA
CoreData Entry
ExcelPerspective
PIQ 10 DEMO
CHOICE (right tool for the job)
Online Pivots Reporting Services (SSRS) Excel PowerPivot
DEMO
TAKEAWAY FACTS TECHNICALPIQ 10 still in developmentPIQ 10 requires SQL2008 R2+IE11 still shipped with Windows10 so PIQ 9.2 continuesPIQ 10 dashboard suite available for PIQ 9.2Workflow 3.0 is available for PIQ 9.2 but requires SQL2008 R2+Incremental update is available for PIQ 9.2No change to OLAP DB structures between PIQ 9.2 and PIQ 10Data uploads available now
TAKEAWAY FACTS GENERALPIQ is not just an intranet site with a pivot tableOnline pivots are perfect for ad-hoc high level analysisReporting Services is great for structured dashboards, lists and printingExcel is better for larger volumes of dataIf you want to work in Excel start in ExcelPowerPivot is worth a lookThere are other tools available outside PIQYou choose the right tool for the job
USEFUL RESOURCESPIQ data dictionaryPIQ dashboards and drill through optionsPIQ user guidehttps://www.youtube.com/watch?v=hDJdkcdG1iAhttp://www.youtube.com – (Search Excel)– (Search PowerPivot)– (Search PowerBI)
http://ExcelCentral.com
reckon.com