9/19/2014

What is Full Life Cycle Business Intelligence?


·        What is full life cycle Business Intelligence?
o   Source Data --> Scrub Data --> Business Rules --> Report --> QA --> Insight
·        Traditional Reporting
o   Static Reports with Parameters
§  State / Federal Reporting
o   Report Developer
§  SQL
§  Domain Knowledge
o   Reporting Tools
§  Crystal Reports
§  SQL Server Reporting Services
§  Actuate
o   Relational OLTP Databases
§  Oracle
§  Microsoft SQL-Server
§  Sybase
§  MySQL
§  Microsoft Access
·        Data Warehousing
o   Single version of the Truth
§  Join desperate data sources
o   Established Architecture
§  Kimball Methodology
·        Star Schema
·        Snow Flake Schema
§  Data Modeling
·        Dim Tables
·        Fact Tables
·        De-normalize Data
§  Cubes
·        Multi-Dimensional
·        Tabular Model
o   Data Warehouse Developer / Architect
o   Tools
§  SQL Server Data Tools
§  Universe Designer
o   OLAP Databases
§  Cognos
§  SQL Server Analysis Services
§  SAP Universes
o   Costly
§  Build
§  Maintain
§  Enhance
·        Self Service Reporting
o   Teach users to fish
§  Supply Data sets
§  Data Discovery
o   Tools
§  Tableau
§  Qlkview
§  Microsoft Excel / Power BI
·        Projects
o   What questions try to answer?
§  Who
§  What
§  Where
§  When
o   Scope
§  Define requirements
§  Report Specifications
o   Data Sources
§  Leads
§  Salesforce
§  Financial
§  Phone
o   Business Rules
§  Processes
§  Data Flow
§  Exceptions
o   Infrastructure
§  Applications
§  Databases
§  Tools
§  Servers
§  Source Control
o   Staff
§  Domain Experts
·        Company History
·        Product Experts
·        Information Experts
§  Project Sponsors
·        Funding Project
o   Data
§  Sources
§  Staging
§  Raw
§  Data Warehouse
§  OLAP Cube
§  Data Governance
·        Data Quality
o   Standardize Fields (St. Pete, Saint Petersburg, Saint Pete.)
·        Data Cleansing
o   Remove Duplicates
§  Master Data Services
·        Single location specific data
o   Maintained by Business
§  Credentials
·        Access to Databases
·        Servers
·        OLAP
·        Schedule Jobs
·        Services
·        Certificates
§  Security
·        Active Directory
·        Report / Group Level Security
·        Application Security
o   SharePoint
o   Reporting Services
o   Business Objects
§  Backups
·        Data Warehouse
·        OLAP Cubes
§  Source Code Repository
·        Administrator
·        Project Hierarchy
·        Users
·        Permissions
·        Delete vs. Destroy
§  Testing
·        Unit Testing (Developer)
·        User Acceptance Testing (Business)
·        Pass Criteria
§  Additional Requests
·        Out of scope?
·        Add to project
·        Add Developer
·        Remove other Functionality
·        Extend Deadline
·        Move request to next phase
·        Charge for additional time / work?
o   Deployment
§  Who deploys code to production?
§  Off Hours
§  Outage
·        Project
o   Project Manager
§  Spokesperson between Business and Development
·        Provides meetings based on frequency
·        Progress Reports
o   Estimates
§  Hours presented to Sponsor for approval
o   Project Schedule
§  Deliverables
§  Who does what when listed?
·        By Task Item
·        By Priority
·        By Constraints?