Online BI Learning Resources and Technologies

Actuarial Expertise:

Advanced statistics
Analytical concepts leveraging emerging data sources
Business Continuity and Crisis Management
Capital estimation/capital management
Corporate Data Warehouse
Data structure, aggregation and reconciliation
Decision Trees
Demand and elasticity modeling
Eagle Eye
Financial and insurance acumen
Financial planning
Financial statement analysis
Generalized Linear Models (GLMs)
Geospatial modeling
Insurance pricing
Location intelligence
Loss reserving
Neural networks
Portfolio Management
Productivity/Profitability Analysis
Static and active report creation and promulgation
Stochastic Modeling


Free Conferences:


BI Certificates:

Business Intelligence: CBIP

Data Architecture: CDMP

Business Analysis: BCAPCCBA® of l’IIBA

Solution Architecture: TOGAF

MCSE: Data Management and Analytics

MCSE : Business Intelligence

MCSA: SQL Server 2012

MCITP: Database Administrator

MCITP: Business Intelligence Developer

MCTS: Business Intelligence Development and Maintenance


IGP: Information Governance Professional

CISA: Certified Information Systems Auditor

CGEIT: Certified in the Governance of Enterprise IT

PMP: Project Management Professional.

Oracle Certified Professional


IBM Information Management Certificate

SAP Certificate

Security (Data Governance): CISSP, SANS (GCIA or similar).

BI & Big Data Gurus:
Andrew Brust
bill baker
Tony Baer

Lestor Meadows

Wayne Eckerson


BI News Channels:
Big On Data

Analytics On Fire


BI Courses

 Data Warehousing
 Watson Analytics
 Big Data Techniques and Concepts
 Big Data Processing & Integration
 Manage Big Data
 Data Science


Software to Learn and/or use:

  • RDBMS: Sybase, MySql, Oracle, MSSQL, DB2.
  • Data warehousing – ETL: SSIS, Business Objects, TeraData [5]. Informatica (4). Netezza (4). Talend. TOAD, PUTTY, AUTOSYS, SQL LOADER. SAS Data Integration Studio. OBIEE (Oracle) [2]. Data Stage [6]. PostGres SQL. BizTalk. Informatica, OWB (Oracle Warehouse Builder), ODI (Oracle Data Integrator)Cognos Data Manager. Microstrategy (5)MapForce. IBM Infosphere suite of products including DataStage, Information Analyzer, Business Glossary, and IBM Information Governance Console.
  • Data Architecture: Visio, LucidChart, Erwin, Sparx. Rational Rose.
  • Data Quality: MS DQS. Informatica IDQ.
  • Visualization: Power BI, Power View, SSRS, Qlik Sense, Qlik View, Pentaho, Tibco Spotfire, Shiny, ggplot, matplotlib, D3.js, Tableau, Charts.js. Google charts.
  • Machine Learning: SSAS Data Mining, SAS, R, Rapid Miner, Excel. Spark, Scala (2), TensorFlow. S-Plus, MATLAB, Octave, Python: Pandas[SciPy/NumPy, sckikit-learn]. SPSS, KXEN, TensorFlow.
  • Natural Language Programming (NLP) Libraries: NLTK, scikits-learn, numpy, gensim.
  • Profiling: SSIS, Toad.
  • Hadoop platform: Ambari, Yarn, Oozie, Zeppelin, Solr. ES, Zookeeper, logstash, MapR
    • Streaming: Yarn.
    • Storage: Spark. HDFS, Hbase, HPD.
    • Processing: Spark. MapReduce.elastic search.
    • Big Data SQL’ing: Hive.
    • Visualization – Analytics: Zeppelin, Scala, Securonix.
    • Machine Learning: Spark. Sqoop, Webhdfs, Kafka, Flume, HDFS, Spark, HBase, Parquet, Sentry.
    • Distributions: Hortonworks or Cloudera.
  • OLTPs: order management and ticketing systems – for Communication Companies: OrderMax, BCRIS, Tapestry/SIMPLe, CSG/MultiVu, ACUT, TIMNG.’
  • Version Control: TFS, Mercurial, Git Hub (3).
  • Maximo, Asset Management architecture and key vendor environments (SAP, Oracle, Microsoft etc.)
  • security information and event management (SIEM) technologies: Splunk, ArcSight, QRadar
  • Financial: Murex.
  • order management and ticketing systems: OrderMax, BCRIS, Tapestry/SIMPLe, CSG/MultiVu, ACUT, TIMNG
  • Non-Profit/Charitable: Raise Edge.


Business Analysis (model as-is) BI Architecture (model to-be) Business transformation Skills

  • Business Process Mapping
  • UML
  • SOA
  • Data Hub
  • Master Data Management
  • Data Warehousing


Leave a Reply

Your email address will not be published. Required fields are marked *