Cognos Analytics

Expand all | Collapse all

AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham

  • 1.  AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham

    Posted Thu May 14, 2020 10:46 AM
    IBM Community's Virtual User Group Day is right around the corner!
    I'm Rachel Su, Offering Manager, Cognos Analytics, IBM. My fellow OM and colleague, Matthew Denham and I will be leading a technical session, on May 19, from 2-3pm ET: 
    ______________________
    Interactive dashboards, reports and storytelling with Cognos Analytics 
    All organizations use dashboards and reports to present data, and business users shouldn't require specialized database or graphics design skills to create compelling visualizations. We've done that hard work for you so content creators don't need to.
    ______________________
    Please share any thoughts or questions here in the thread, and we'll make sure this is available to you after the event so you can watch the replay and share your questions directly with us. In the meantime, would love to hear a little bit about yourself and what you'd like to get out of our User Group event. Drop a line in the thread below!
    Register for Virtual User Group Day | May 19-20: https://ibm-usergroups.bemyapp.com
    Get more information about the Planning Analytics and Cognos track: ​IBM Planning Analytics and Cognos Community Day
    You can find all of the AMA threads here


    ------------------------------
    Rachel Su
    Senior Offering Manager
    Data and AI
    IBM
    ------------------------------


  • 2.  RE: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham

    Posted Tue May 19, 2020 03:17 PM

    Thank you Matt and Rachel for your session. 


    I promised to provide an example to a participants on how to automate Excel update using Jupyter Notebook integration within Cognos Analytics. 

    1. Create Notebooks that loads data from Excel to Cognos Analytics. 

    Here is very simple Python example that loads Excel file from Website. 

    # We use pandas dataframes to store Excel data before uploading to data set.
    import pandas as pd

    # Loading Excel data from website to a Panda dataframe
    df = pd.read_excel('http://biostat.mc.vanderbilt.edu/wiki/pub/Main/DataSets/titanic3.xls')

    # Write data from Panda data frame to Cognos Data Set mode 'w' is for replace, mode 'a' is to append.
    CADataConnector.write_data(df, path=".my_folders/Titanic Data Set", mode='w')


    2. Now Schedule Jupyter Notebook with desired interval to update the data set. If the Excel is changed between the schedules the Data Set reflects these changes.

    I hope this helpful. 


    ------------------------------
    JANNE LIND
    ------------------------------



  • 3.  RE: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham

    Posted Tue May 19, 2020 06:41 PM
    Janne, 
    Thank you for this example, it's exactly what I asked for.  I wondering if its possible to read the file from a local drive.  I know I've looked at the 'Current Working Directory' in the notebook, which comes back as '/home/ca_user' but I can't seem to find that location. So being able to point at a local drive doesn't seem possible or else I'm missing something.
    Again, thanks for the example. Much appreciated.

    ------------------------------
    Scott
    Cognos Administrator
    Wenatchee WA
    ------------------------------



  • 4.  RE: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham

    Posted Mon May 25, 2020 03:51 AM
    Hi Scott

    The Jupyter Notebooks runs as Linux inside a Docker container, so it can't see your local windows drive.... you would need to use a network drive or an url... I guess the simple thing here would be to create a subfolder under the Webcontent folder on your CA installation where you can upload files to.... then it's readable from CA and Notebooks as an url...

    Torben

    ------------------------------
    Torben Noer
    ------------------------------



  • 5.  RE: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham

    Posted Tue May 26, 2020 11:55 AM

    Thanks Torben.  I thought about that but wasn't sure I wanted to open up a folder on the server side for these files.  I was really hoping that Jupyter could access the windows file system and make the spreadsheet update process easier.  In this new world, nothing is really easier just different.

    Great idea, I'll give it a try.

     

    Scott

     

    Bar chart

    Scott Taylor

    Cognos Administrator | Senior BI Analyst

     






  • 6.  RE: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham

    Posted Wed May 20, 2020 09:13 AM

    Hi Rachel, 

    Was the session recorded, and if so could you post it or direct me to where I can view it? 

    Thanks,
    Dave



    ------------------------------
    Dave Chirayath
    ------------------------------



  • 7.  RE: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham

    Posted Wed May 20, 2020 09:22 AM
    Edited by JANNE LIND Wed May 20, 2020 09:23 AM

    Hi Dave, 

    All IBM User Group Day sessions replays are available via following site.  Just access the past sessions via schedule. You need to first register to see the replays. 
    https://ibm-usergroups.bemyapp.com/

    Direct link to Matthew Denham's (speaker) and Rachel Su's s (chat curator) session is here (again you need to sign-in). 
    https://ibm-ugd-platform.bemyapp.com/#/conference/5eb1dd7efe3f0f001be7e5c7


    I hope you enjoy the sessions!

    ------------------------------
    JANNE LIND
    Business Analytics Technical Sales
    Data & AI
    IBM Finland
    ------------------------------



  • 8.  RE: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham

    Posted Wed May 20, 2020 09:26 AM

    Hi Dave,

    All sessions have replay available for 90 days. You can simply go back to the same website and find yesterday's agenda to locate the same session.

    When I go to the session, here is the URL its given me. See if it works for you.

    https://ibm-ugd-platform.bemyapp.com/#/conference/5eb1dd7efe3f0f001be7e5c7



    ------------------------------
    RACHEL SU
    ------------------------------



  • 9.  RE: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham

    Posted Tue May 26, 2020 11:01 AM
    Are there any samples to use for embedding Cognos dashboard in Sharepoint and set up requirement? Thanks!

    ------------------------------
    Buddhi Gupta
    ------------------------------



  • 10.  RE: AMA: Interactive dashboards, reports and storytelling with Cognos Analytics with Rachel Su and Matthew Denham

    Posted Wed June 03, 2020 03:02 PM
    Do you use Teams, on Teams ​we just added a tab that is based on a website and then include the url link to the Cognos report. 


    I think you should be able to within SharePoint add a new Link and include the url


    ------------------------------
    Jo Marie Sellner
    ------------------------------