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
Emblem
Financial and insurance acumen
Financial planning
Financial statement analysis
Generalized Linear Models (GLMs)
Geospatial modeling
IGLOO/Remetrica/@Risk
Insurance pricing
Location intelligence
Loss reserving
Mapinfo
Neural networks
Portfolio Management
Productivity/Profitability Analysis
Re-Metrica
ResQ
SAS
Static and active report creation and promulgation
Stochastic Modeling

 

Free Conferences:

www.meetup.com

www.eventbrite.com

 

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

MCDBA or MCITP

IGP: Information Governance Professional

CISA: Certified Information Systems Auditor

CGEIT: Certified in the Governance of Enterprise IT

PMP: Project Management Professional.

Oracle Certified Professional

ICCP

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

TechTarget.com

 

BI Courses

 Econometrics
 Data Warehousing
 Watson Analytics
 Big Data Techniques and Concepts
 Big Data Processing & Integration
 Manage Big Data
 No SQL
 Hadoop
 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
  • TOGAF

 

Leave a Reply

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