{"course":{"productid":21059,"modality":6,"active":true,"language":"de","title":"IBM Planning Analytics: Analyze Data and Create Reports (V2.0.x)","productcode":"P8357G","vendorcode":"IB","vendorname":"IBM","fullproductcode":"IB-P8357G","courseware":{"has_ekit":true,"has_printkit":false,"language":"en"},"url":"https:\/\/portal.flane.ch\/course\/ibm-p8357g","essentials":"<ul>\n<li>Knowledge of your business requirements<\/li><li>Basic knowledge of Microsoft Excel<\/li><\/ul>","audience":"<p>Analysts<\/p>","contents":"<p>This course is designed to teach analysts how to use IBM Planning Analytics to analyze data to discover trends and exceptions, create and customize reports and templates, and contribute data to plans. Through a series of lectures and hands-on activities, you will learn how use Planning Analytics Workspace and Planning Analytics for Microsoft Excel to create analyses, enter data, create custom views and dashboards, and build formatted reports and forms.<\/p>","outline":"<p>Understanding IBM Planning Analytics data&bull; Understanding models&bull; Understanding cubes&bull; Understanding dimensions&bull; Understanding views&bull; Understanding sets<\/p>\n<p>&nbsp;<\/p>\n<p>Creating books&bull; Creating books&bull; Adding content&bull; Creating new sheets&bull; Saving, closing, and opening views<\/p>\n<p>&nbsp;<\/p>\n<p>Creating and saving views&bull; Compare two views of the same cube&bull; Create new views&bull; Save a view<\/p>\n<p>&nbsp;<\/p>\n<p>Changing the way data is displayed&bull; Move and filter dimensions&bull; Show different levels of detail&bull; Create an asymmetric view&bull; Display cells as percentages&bull; Add top or bottom filters&bull; Show attributes for dimension members<\/p>\n<p>&nbsp;<\/p>\n<p>Displaying specific members by using sets&bull; Display existing sets&bull; Add, remove, and reorganize members in a set&bull; Find members by using searches and filters&bull; View attributes&bull; Save sets&bull; Edit a set<\/p>\n<p>&nbsp;<\/p>\n<p>Adding calculations to views&bull; Add summary calculations&bull; Add member calculations&bull; Remove and rename calculations<\/p>\n<p>&nbsp;<\/p>\n<p>Highlighting exceptions by using conditional formatting&bull; Apply conditional formatting&bull; Add an additional condition<\/p>\n<p>&nbsp;<\/p>\n<p>Entering data&bull; Distribute data to multiple cells by using data spreading&bull; Enter and hold data using quick commands&bull; Copy and paste and use calculations&bull; Add a comment to a cell<\/p>\n<p>&nbsp;<\/p>\n<p>Experimenting with data by using sandboxes&bull; Creating sandboxes&bull; Comparing sandboxes&bull; Committing data and deleting sandboxes<\/p>\n<p>&nbsp;<\/p>\n<p>Working with spreadsheets online by using websheets&bull; Find and add websheets to your book&bull; Explore websheets<\/p>\n<p>&nbsp;<\/p>\n<p>Formatting for reporting&bull; Creating a new view&bull; Formatting the view for reporting<\/p>\n<p>&nbsp;<\/p>\n<p>Exploring data by using visualizations&bull; Examine different visualizations&bull; Customize a visualization<\/p>\n<p>&nbsp;<\/p>\n<p>Creating dashboards&bull; Adding and reusing objects&bull; Synchronizing objects&bull; Navigating the book and perform tasks by using buttons&bull; Changing the appearance of a view&bull; Hiding information&bull; Proven Practices for Dashboards<\/p>\n<p>&nbsp;<\/p>\n<p>Examining performance by using scorecards&bull; Reading scorecards&bull; Adding scorecards to a book<\/p>\n<p>&nbsp;<\/p>\n<p>Exporting data&bull; Exporting a view to Microsoft Excel<\/p>\n<p>&nbsp;<\/p>\n<p>Introduction to IBM Planning Analytics for Microsoft Excel&bull; Examining report types<\/p>\n<p>&nbsp;<\/p>\n<p>Exploring data in Planning Analytics for Microsoft Excel&bull; Connect to a system, and add an Exploration&bull; Display different dimension members&bull; Modify and save the view<\/p>\n<p>&nbsp;<\/p>\n<p>Create reports easily by using Quick Reports&bull; Convert an Exploration to a Quick Report&bull; Drag a view to add a Quick Report&bull; Synchronize reports by using cell referencing&bull; Change members on rows or columns&bull; Add columns or rows and apply styles&bull; Apply custom formatting<\/p>\n<p>&nbsp;<\/p>\n<p>Expanding and formatting members by using Dynamic Reports&bull; Create and explore a Dynamic Report&bull; Formatting the Dynamic Report&bull; Rebuild the Dynamic Report<\/p>\n<p>&nbsp;<\/p>\n<p>Exploring TM1 functions&bull; Examine the TM1 functions in a Dynamic Report&bull; Derive rows based on saved sets&bull; Derive rows based on MDX&bull; Create custom format definitions&bull; Create custom columns&bull; Add new sections and multiple Dynamic Reports to a single sheet<\/p>\n<p>&nbsp;<\/p>\n<p>Creating Custom Reports&bull; Create two custom reports&bull; Combine the two reports<\/p>\n<p>&nbsp;<\/p>\n<p>Entering Data in Planning Analytics for Microsoft Excel&bull; Entering data in cube viewer&bull; Entering data in Dynamic Reports&bull; Entering data in Explorations and Quick Reports&bull; Using Sandboxes to experiment with data<\/p>\n<p>&nbsp;<\/p>\n<p>Simplify tasks by using action buttons&bull; Enable action buttons&bull; Add an action button to navigate to another worksheet&bull; Edit an action button&bull; Create an action button that rebuilds a worksheet<\/p>\n<p>&nbsp;<\/p>\n<p>Creating websheets&bull; Publish a websheet&bull; Manage websheets&bull; Add the websheet to a Planning Analytics Workspace book<\/p>\n<p>&nbsp;<\/p>","essentials_plain":"- Knowledge of your business requirements\n- Basic knowledge of Microsoft Excel","audience_plain":"Analysts","contents_plain":"This course is designed to teach analysts how to use IBM Planning Analytics to analyze data to discover trends and exceptions, create and customize reports and templates, and contribute data to plans. Through a series of lectures and hands-on activities, you will learn how use Planning Analytics Workspace and Planning Analytics for Microsoft Excel to create analyses, enter data, create custom views and dashboards, and build formatted reports and forms.","outline_plain":"Understanding IBM Planning Analytics data\u2022 Understanding models\u2022 Understanding cubes\u2022 Understanding dimensions\u2022 Understanding views\u2022 Understanding sets\n\n\u00a0\n\nCreating books\u2022 Creating books\u2022 Adding content\u2022 Creating new sheets\u2022 Saving, closing, and opening views\n\n\u00a0\n\nCreating and saving views\u2022 Compare two views of the same cube\u2022 Create new views\u2022 Save a view\n\n\u00a0\n\nChanging the way data is displayed\u2022 Move and filter dimensions\u2022 Show different levels of detail\u2022 Create an asymmetric view\u2022 Display cells as percentages\u2022 Add top or bottom filters\u2022 Show attributes for dimension members\n\n\u00a0\n\nDisplaying specific members by using sets\u2022 Display existing sets\u2022 Add, remove, and reorganize members in a set\u2022 Find members by using searches and filters\u2022 View attributes\u2022 Save sets\u2022 Edit a set\n\n\u00a0\n\nAdding calculations to views\u2022 Add summary calculations\u2022 Add member calculations\u2022 Remove and rename calculations\n\n\u00a0\n\nHighlighting exceptions by using conditional formatting\u2022 Apply conditional formatting\u2022 Add an additional condition\n\n\u00a0\n\nEntering data\u2022 Distribute data to multiple cells by using data spreading\u2022 Enter and hold data using quick commands\u2022 Copy and paste and use calculations\u2022 Add a comment to a cell\n\n\u00a0\n\nExperimenting with data by using sandboxes\u2022 Creating sandboxes\u2022 Comparing sandboxes\u2022 Committing data and deleting sandboxes\n\n\u00a0\n\nWorking with spreadsheets online by using websheets\u2022 Find and add websheets to your book\u2022 Explore websheets\n\n\u00a0\n\nFormatting for reporting\u2022 Creating a new view\u2022 Formatting the view for reporting\n\n\u00a0\n\nExploring data by using visualizations\u2022 Examine different visualizations\u2022 Customize a visualization\n\n\u00a0\n\nCreating dashboards\u2022 Adding and reusing objects\u2022 Synchronizing objects\u2022 Navigating the book and perform tasks by using buttons\u2022 Changing the appearance of a view\u2022 Hiding information\u2022 Proven Practices for Dashboards\n\n\u00a0\n\nExamining performance by using scorecards\u2022 Reading scorecards\u2022 Adding scorecards to a book\n\n\u00a0\n\nExporting data\u2022 Exporting a view to Microsoft Excel\n\n\u00a0\n\nIntroduction to IBM Planning Analytics for Microsoft Excel\u2022 Examining report types\n\n\u00a0\n\nExploring data in Planning Analytics for Microsoft Excel\u2022 Connect to a system, and add an Exploration\u2022 Display different dimension members\u2022 Modify and save the view\n\n\u00a0\n\nCreate reports easily by using Quick Reports\u2022 Convert an Exploration to a Quick Report\u2022 Drag a view to add a Quick Report\u2022 Synchronize reports by using cell referencing\u2022 Change members on rows or columns\u2022 Add columns or rows and apply styles\u2022 Apply custom formatting\n\n\u00a0\n\nExpanding and formatting members by using Dynamic Reports\u2022 Create and explore a Dynamic Report\u2022 Formatting the Dynamic Report\u2022 Rebuild the Dynamic Report\n\n\u00a0\n\nExploring TM1 functions\u2022 Examine the TM1 functions in a Dynamic Report\u2022 Derive rows based on saved sets\u2022 Derive rows based on MDX\u2022 Create custom format definitions\u2022 Create custom columns\u2022 Add new sections and multiple Dynamic Reports to a single sheet\n\n\u00a0\n\nCreating Custom Reports\u2022 Create two custom reports\u2022 Combine the two reports\n\n\u00a0\n\nEntering Data in Planning Analytics for Microsoft Excel\u2022 Entering data in cube viewer\u2022 Entering data in Dynamic Reports\u2022 Entering data in Explorations and Quick Reports\u2022 Using Sandboxes to experiment with data\n\n\u00a0\n\nSimplify tasks by using action buttons\u2022 Enable action buttons\u2022 Add an action button to navigate to another worksheet\u2022 Edit an action button\u2022 Create an action button that rebuilds a worksheet\n\n\u00a0\n\nCreating websheets\u2022 Publish a websheet\u2022 Manage websheets\u2022 Add the websheet to a Planning Analytics Workspace book\n\n\u00a0","version":"1","duration":{"unit":"d","value":2,"formatted":"2 Tage"},"lastchanged":"2025-01-28T11:47:22+01:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/json-course-schedule\/21059","source_lang":"de","source":"https:\/\/portal.flane.ch\/swisscom\/json-course\/ibm-p8357g"}}