Sunday, August 25, 2013

Cognos 10 Course Details

Cognos 10 Course Detailed Description

Whats new Cognos 10 BI
Overview of Business Intelligence

• What is Business Intelligence
• Why is BI Important and where can we use it
• Components of BI
• Business Intelligence Roadmap

Overview of Data Warehousing
• What is Data Warehouse, Why do we need it
• Data Warehouse Architecture and its components
• Define Star Schema - Fact and Dimensions
• Understand OLTP and OLAP Systems

Overview of Cognos 10 BI and Architecture
• Introduce Cognos 10 BI
• Whats new Cognos 10 BI
• Examine the different studios in Cognos 8 BI
• Identify the different data sources within the studios
• Highlight key cap abilities of Cognos 8 BI
• Understand Cognos Multi Layered architecture

Cognos 10 Installations and Configuration
• Installing Cognos 10
• Install Framework Manager
• Install Cognos BI Application
• Setting up the Environment
• Configuring Cognos 10
• Setting up Samples in Cognos 10
• Uninstalling Cognos 10

Cognos 10 BI Administration
• Create and Modify a Data Source
• Create Database backups
• Understand Roles, Users and Groups
• Specify Permission Settings

Cognos 10 Connection Administration
• What is Cognos Connection
• Examine Cognos Connection UI elements , Create a URL, Login, Logoff
• Entry Properties: General Properties, Permissions, Report, Query, Analysis, Job, Agent and Page Properties
• Navigation- Public and Private Folder
• Open reports with Report Name, Go to Links, Run Reports from a View
• Run Reports- Prompt Pages, Printing a report and Open in Excel
• View the run history of a report and Historical Reports
• Closing and Creating Quick links to Reports , My Folder Shortcut and Browser Bookmark
• Personalize Cognos Connection
• Backups- Export of Cognos, Content Store or select items for Backups
• Restore an exported Backup
• Create and Customize a Page and share a single page with Multiple Users

Cognos 10 Query Studio
• Introduction to Query Studio
• Create Reports (List, Grouped List, Crosstab, Charts)
• Changing the Appearance of Reports (Format)
• Sorting and Grouping
• Filters and Prompts
• Subtotals and Calculations
• Run and Manage Reports
• Drill Through reports

Cognos 10 Analysis Studio
• Introduction to Analysis Studio
• Creating a Basic Analysis
• Working with data in Crosstab
• Exploring Data
• Limiting Data
• Calculating Data
• Sharing Data

Cognos 10 Report Studio
• Introduction to Report Studio
• Report Studio User Interface
• Creating, Save and Run Reports
• Report Templates
• Managing Reports
• Types of Reports
• Active Reports
• List Reports
• Crosstab Reports
• Charts
• Formatting a Report
• Report Layout Guidelines
• Fonts, Styles, Header, Footer and Borders
• Insert objects
• Swap Columns and Rows
• Working with Data
• Filters, Parameters and Prompts
• Sorting and Grouping
• Subtotals and Calculations
• Working with Queries
• Working with Reports
• Managing changes in the Package
• Conditional Formatting
• Drill-through Reports
• Drill-up/Drill-down Reports
• Master-Detail Reports
• Scheduling Reports

Cognos 10 Framework Manager
• Introduction to Framework Manager
• Framework Manager Basics
• User Interface, Navigation, Objects
• Planning the project and data model. Framework Manager Workflow
• Naming Conventions for objects in a project
• Designing Project
• Create project
• Importing Metadata from one and more sources
• Exporting Metadata
• Data Sources
• Working with Data Source Connections
• Create and Modify Data Sources
• Improve Performance by setting Query Processing Type
• Preparing Relational Meta data for use in Reports
• Verifying Relationships
• Working with Dimensions
• Working with Query Subjects- Data, Model and Stored Procedure Query Subject
• Working with Query Items- Set Usage and Aggregate Property
• Making Metadata Available to Report Authors
• Verify Model
• Set Governors
• Improving Performance
• Create or Modify Package
• Controlling access to Metadata
• Explore Package
• Publish Package
• Guideline for Modeling Metadata
• Best Practices , Presentation and Database layers
• Merge Metadata
• Perform Calculations and Filters
IBM Cognos 10 Business Insight Advanced:
Highlight Report Data
  • understand query item properties
  • use formatting to improve the visual effectiveness of a report
  • use conditional styles to highlight query items on a report
Integrate External Data
  • use external data in reports
  • map query subjects from an enterprise report to external data
Analyze Your Data
  • name four data analysis processes
  • implement a report for each process
Use Report Development Processes to Design Effective Reports
  • discuss phases of report development for business authors
  • discuss elements of effective reports
Extend Business Insight Advanced Reports with Report Studio
  • identify Business Insight Advanced reports that can benefit from Report Studio capabilities
  • create a report in Report Studio and open it in Business Insight Advanced
  • create a report in Business Insight Advanced and extend it in Report Studio
Cognos 10 Business Insight:
  • Introduction.
  • Getting your bearings in Cognos 10.
  • Create your first dashboard page.
  • Meet all the new visualization objects.
  • Understand the difference between Business Insight and Connection.
  • Assemble your own interactive dashboards.
  • Reuse Cognos standard reports and lift them to a higher level of usability with Business Insight.
  • Be familiar with all the new visualization techniques that Cognos
·         Build a dynamic dashboard and make it reusable for other users

Thursday, August 15, 2013

Qlikview Online Training | Qlikview Training in Mumbai

Qlikview LIVE Project Implementation.

Experience Counts!!!

Qlikview Online Training / Qlikview Training Institute in Mumbai.
Please contact.
New batches starting on 16th August 2013.

Thanks and Regards,
Bharati DW Consultancy
cell: +1-562-646-6746 / +91-8082112148 


Tuesday, August 13, 2013

Qlikview Tutorial - Star Schema Model Part-2-of-40

Qlikview Tutorial - Star Schema Model Part-2-of-40

In this video, we will create Star Schema in Qlikview

1- We have a Star Schema, with a Fact table and 3 Dimension Tables.
The goal to get the Star Schema model, create joins & make it available to crate reports.
Let's take a look at the model in SalesDatabase.
Customer Dimension, Product Dimension, Calendar Dimension & Sales Fact

2- Open Qlikview
3- Click on Edit Script Icon
3- On the lower left side, an option to select multiple data sources is provided.
4- Connect to the database using an ODBC connection. Use OLEDB for MDB.
5- Once the connection is set, the qlikview puts the connection string in the script.
6- Click on the "Select" button to pull the required tables.
7- Click on Reload.
8- Click on the Table viewer (Ctrl + T). 
Please note that Qlikview uses the column names to JOIN / identify relationships.

9- For joining two tables with different columns uses aliases. 
You can specify alias name "as [<column_name>]" e.g: "as [Time]"
Modify the script to add aliases.

10- Press reload & click on OK.
Go back to table viewer & you can see the joins getting created.

11- Add a List Object and display data by Product Category, Country, Year, Sales Amount & Quantity.


Qlikview Training 
Bharati DW Consultancy 
cell: +1-562-646-6746 / +91-8082112148

Monday, August 5, 2013

Qlikview Online Training - Create Basic Dashboard Part-1-of-40

Qlikview Online Training
Bharati DW Consultancy
cell: +1-562-646-6746 / +91-8082112148

Qlikview Training - Create Basic Dashboard Part-1-of-40

In this video, we will create a basic dashboard in Qlikview

1- Open Qlikview
2- Click on Edit Script Icon
3- Load the SalesData.csv File
4- Please note the LOAD scrupt to get the data.
5- Click on Reload.
6- Right click the white space in the sheet.
7- Add a new list object.
8- Display Country wise Sales.
9- Again Add a Chart Object and display data by Product Category.
10 - Right click on the List Object --> Properties --> General Tab
11- On the right side set the Fast Change option.
12- You can add multiple objects and create a dashboard.