- #Ibm cognos analysis for microsoft excel 10.2 2 how to#
- #Ibm cognos analysis for microsoft excel 10.2 2 windows#
Developed TI Processes to load and retrieve data from database tables and other data sources and leveraged the processes to create dimensions, hierarchies, and cubes.Design, develop, and implement Cognos TM1 Applications for Financial Planning and Budgeting models with complex rules.Carried out prototyping (creating dashboards) of Cognos Workspace, Cognos Workspace Advanced & Active reports and their new features.Coordinate and ETL and DB team and recommend changes in Database Table ( especially data aggregation), Views or Materialized views required for solution implementation.Conducted UAT Demo and got reports validation.Tested and validated data against the Oracle DB Views compared to the requirement given.Conducted peer review for Cognos FM Model and Reports.Designed and Developed the Framework Manager models (both Relational and Multi-Dimensional) and Published into the Cognos Connection.Performance tuning to ensure reports function within acceptable parameters.Analyse requirements and architect appropriate solutions, with detailed design documents and provide proof of concept.Collaborate with cross functional teams to gather and document BI requirements.Responsible for the design, development, and implementation of Cognos BI/TM1 Solutions.Lead Cognos BI/TM1 and Analytics Consultant
#Ibm cognos analysis for microsoft excel 10.2 2 windows#
Operating Systems: Windows 2003 Enterprise Server, NT, XP, 2000, UNIX, Linux Red Hatĭatabases: SQL Server 2008 R2/2012, 2016, MS Access, Oracle 9i/11g, DB2, Netezza and Teradata.ĭatabase Tools: Teradata SQL Assistant, Oracle SQL Developer, TOAD, SSMS.īI Tools: Cognos Analytics, 10.2.2, and 8.4, Cognos TM 1 9.5- 10.2.2, SQL Server 2008/2012/2016 and Tableau 9.5, 10.2 and 10.4, MS Access, Microsoft Excel Well experienced in Incident Management, Problem Solving Management, Release Management, and Change Management Services.Strong knowledge of SDLC in its methodologies (especially Agile).Excellent team player at all levels with ability to perform independently. Excellent communication and interpersonal skills.Strong understanding in extraction, transformation and loading (ETL) of data flows using SSIS, Informatica and Datastage.Strong knowledge in SQL Server BI suite - using reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes.In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
![ibm cognos analysis for microsoft excel 10.2 2 ibm cognos analysis for microsoft excel 10.2 2](https://exploringtm1.com/wp-content/uploads/2013/09/Screen-Shot-2013-09-10-at-1.32.41-PM-3-1024x595.png)
![ibm cognos analysis for microsoft excel 10.2 2 ibm cognos analysis for microsoft excel 10.2 2](https://s3.manualzz.com/store/data/023333339_1-2628f8e2330c1f409bbbde8ae6d919f8.png)
![ibm cognos analysis for microsoft excel 10.2 2 ibm cognos analysis for microsoft excel 10.2 2](https://neciag.files.wordpress.com/2015/02/setup.jpg)
Advanced level experience in BI solutions with IBM Cognos Analytics, 10.2.2, 8.4 and TM1 10.2.2 (Architect, Contributor, Perspectives, Turbo Integrator in development, testing & production environment.This intermediate course is for Administrators.
#Ibm cognos analysis for microsoft excel 10.2 2 how to#
Students will explore a scorecarding solution, identify new features in TM1 applications and Performance Modeler, look at enhancements to the Operations Console utility, learn how to examine data and build complex reports using the new IBM Cognos Analysis for Microsoft Excel client, identify improvements to IBM Cognos Insight, and examine additional new features in TM1. The course outlines basic usage of the new features for analysis, modeling, and administration. IBM Cognos TM1: What’s New (V10.2) is a one-day, instructor-led course that combines lecture material and hands-on practice in using new features in TM1 version 10.2. SCHEDULED DATES: TBD – Contact Us for more Information