| 1. Solution Architect |
| 2. Power BI /Microsoft BI |
3. Dimensional Modeling
4. Metadata Modeling| 4.1. Dynamic Cube/Transformer | | 4.2. Scorecards |
|
5. BI Reporting
| 5.1. Report Performance Tuning | | 5.2. Multidimensional Reports | | 5.3. Active Reports | | 5.4. Lists/Crosstabs/Charts/Maps |
| | 6. BI Administering |
|
| 7. Planning Analytics / TM1 |
| 8. IBM OpenPages..... |
|
|
|
|
1. Solution Architect
Share a sample implementation for Power BI development and deployment
Power BI Data Model - Unveiling the Essence Beyond "Beautiful Dashboards"
Share a sample Data Flow Architecture to Migrate Cognos to Power BI
Unleash the Power of Power BI RLS
How to improve Power Query performance for big structured data
Unleash the power of Power BI incremental refresh
How to set up a dynamic RLS based on user profile and hierarchy in Power BI?
A pragmatic modern DW/BI solution with structured data
How to achieve the Power BI shared datasets architecture (Thin Report, Golden Dataset)
How to achieve a Power BI excellent performance with a practical project
How to build a data warehouse without ETL and database using Synapse serverless for structured data
Better BI Solution Architect - Avoid idealism, advanced technology, over-architect / overengineering, too much user-focused.
Better ETL design approach - Avoid overusing ETL tool
Using Cognos framework manager parameter maps for data-level security for unbalanced ragged hierarchy
How to improve TM1 perfomance
How to make Cognos analytics self-service same as or better than Power BI or Tableau |
How to strike a balance between filter and deck for Cognos Analytics Active Report
How to validate data integrity using Cognos report |
| How to extract Datawarehouse Bus Matrix from Cognos
Framework Manager Model |
| How to troubleshoot data issue when migrating SAS
reports to Cognos Reports |
| How to Report against OpenPages Business Entities
(hierarchical data modeling) |
| How to make SSRS report configurable based on
individual customer requirement |
| How to achieve a most cost effective BI solution
using SQL server express edition |
| How to design Cognos interactive reports |
| Cognos report authoring techniques |
| How to resolve crosstab performance issue with DMR
model for sparse data |
| How to improve Cognos report performance |
| How to model DMR relative time |
| How to handle DMR relative time |
| How to handle relative time (relational model
focused) - Update 02 |
| Unleash the power of UNION QUERY at report level to
achieve the same functionality of "stitch query" at framework
manager level |
| How to make Cognos reports reusable - Explore the
new idea of authoring Cognos reports – part 5 |
| How to dynamically set up default value, or
initialize parameters in Cognos report |
| How to make Cognos Reports Reusable - Explore the
new idea of authoring Cognos reports – part 4 |
| How to make Cognos Reports Reusable - Explore the
new idea of authoring Cognos reports – part 3 |
| How to make Cognos reports reusable - Explore the
new idea of authoring Cognos reports – part 2 |
| How to handle relative time (relational model
focused) - Update 01 |
| How to improve master detail report performance |
| How to make cognos reports reusable - Explore the
new idea of authoring Cognos reports – Part 1 |
| How to burst complicated reports with multiple
parameters without using SDK |
| How to implement row level security in framework
manager (all options) |
| How to make a single report to be shared for
bursting, scheduling and running interactively |
| How to handle relative time (relational model
focused) |
| How to simplify and centralize date logic in ETL and
Report |
| How to improve Cognos report performance |
| How to turn Cognos BI reports into “Web forms”
without using JavaScript |
| How to achieve a comprehensive BI solution using
Cognos with SQL server |
|
|
|
4. Metadata Modeling
How to model unbalanced/rigged hierarchical data - entirely flattened from bottom node only
How to display unbalanced/ragged hierarchy in Cognos DMR
How to model Cognos Framework Manager to generate most efficient SQL query (Part3)
How to model Cognos Framework Manager to generate most efficient SQL query (Part2)
How to model Cognos Framework Manager to generate most efficient SQL query (Part1) |
Model Relative Time Dimension for Cognos Framework Manager - Applied for Relational and DMR
Cognos Determinant Demystified
How to model Cognos Framework Manager to generate most efficient SQL query |
| How to model Cognos FM to flexibly align Forecast
with Actual data |
| How to model Cognos FM to join two fact tables at
different granularity with not shared dimension(s) |
| How to build a practical planning and forecasting
data model for Cognos reports |
| How to change member caption without changing ETL
and reports in DMR model |
| How to create customized date dimension properties
to speed up report development (DMR) |
| How to develop light weighted ETL using Cognos
Framework Manager |
| how to model dimensions with cognos DMR in real life |
| How to model a effective date dimension in DMR with
alias shortcut |
| how to write a effective SQL query to retrieve most
recent records |
| How to make a dynamic date DMR dimension |
| How does suppression work with DMR on CQM or DQM |
| How to make Cognos connection dynamic based on
selected environment |
| How to Report against OpenPages Business Entities
(hierarchical data modeling) |
| How to “Unpivot” or “pivot” Cognos SQL query |
| How to handle Cognos data security multiple user
groups based on sales alignment |
| How to build a business user friendly framework
manager package for query studio – options |
| How to avoid problems with parameter maps |
| How to handle bridge table in framework manager (for
unbalanced hierarchy and multi-valued dimensions) (re# Cognos release 10.2.2
with Bridge Query Subjects) |
| How to display string measure in crosstab from
report studio and query studio |
| How to build a
business user friendly framework manager package for query studio |
| Cognos report performance tuning - Use parameter
maps based on existing query |
| Cognos report performance tuning - Force Cognos
engine to generate a single query for master detail report |
| Cognos report performance tuning - Model relative
time as measures for relational |
| How to handle “dynamic fact table” using #prompt in
framework manger |
| How to use “Alias Shortcut” for role playing
dimensions in Framework Manager |
| How to implement row level security in framework
manager (all options) |
| How to make prompt optional with default value in
Cognos Framework manager |
| How to deal with mixed granularity in a fact table
(In Framework Manager, Report Studio and Metrics Designer) |
| How to dynamically change schema name in Framework
Manager |
| How to show or hide a block in Active Reports – a
generic approach |
| How is publish - subscribe architecture used to
communicate in Active Reports |
| How to simplify and centralize date logic in ETL and
Report |
| How to improve Cognos report performance |
| 4.1. Dynamic
Cube/Transformer |
| How to take advantage of Cognos Transformer custom
view |
| How to resolve report issue based on metrics package
from version 10.1.0 to version 10.1.1 |
| How to create data for all periods in scorecard
including most recent period, YTD, Quarter and Annual |
| How to determine level keys for a hierarchy in
Cubing services |
| How to determine level keys for a hierarchy in
Cubing services |
| How to define a semi-additive MDX measure in cubing
services (conditional distinct and then average based on date dimension) |
| How to handle degenerate dimension in IBM Cubing
services |
| How to design transformer Cube with Inventory
management |
| How to copy and paste shared dimensions for IBM
cubing services |
| 4.2. Scorecards |
| How to resolve report issue based on metrics package
from version 10.1.0 to version 10.1.1 |
| How to create data for all periods in scorecard
including most recent period, YTD, Quarter and Annual |
| How to prepare fact data for metrics in Cognos
scorecarding (Design approach) |
| How to generate Year to Date (YTD) data for
scorecard using SQL statement – an practical approach |
| How to remove data of invalid qualifiers in metric
studio |
| How to handle different metric types with same name |
|
|
| 7. Planning
Analytics / TM1 |
How to improve TM1 perfomance
How to modify TM1 data using TI script |
| How to create a TM1 view using TI script (Basic) |
| How to handle TM1 cube model with more than one
parent (or alternative hierarchies) |
| How to make use of TM1 dimension default member in
report |
| How to create rollup YTD measures in TM1 using rule
– update 1 |
| How to make Cognos insight work in a distributed
model |
| How to automatically load data into TM1 database
without data warehouse |
| How to create rollup YTD measures in TM1 using rule |
| How to update elements in TM1 |
| How to handle TM1 load errors - No parent hierarchy
and multiple parents’ hierarchy |
| How to generate TM1 report based on data security
for individual login user (10.2) |
| How to create top X count in active form using MDX
expression |
| How to understand multiple parents in TM1 hierarchy |
| How to make TM1 cell security reusable |
| How to create an efficient framework manager package
from TM1 cubes |
| How to unleash the power of dynamic subsets to speed
up budgeting process |
| How to understand the data Tab under TurboIntegrator
advanced scripting |
| How to merge multiple columns into single column in
TI process |
| How to use “TM1 Element Holder” |
| How to avoid problem for Store values and multiple
parents in TI loading process |
| How to provide on-demand updates and forecasting
capabilities using TM1 |
| How to export TM1 data using Turbo Integrator |
| How to create TM1 string measure |
| 8. IBM
OpenPages..... |
| How to create different filters (Home Page Filtered
List, Public Filter, Private filter) |
| How to enable custom report by business users |
| How to avoid problem with currency data load in IBM
OpenPages |
| How to Report against OpenPages Business Entities
(hierarchical data modeling) |
| How to define OpenPages security with AURA |
| How to model OpenPages Reporting Framework with one
single namespace only |
| How to load large fastmap file into OpenPages |
| How to understand an association on report in IBM
OpenPages |
| How to understand object type relationship in
OpenPages |
| How to aggregate loss in case when single loss
associates with two business entities in OpenPages |
| What is RDL (Report Definition Language) in
OpenPages |
| MDX Based Investment Analytics Engine |
End user oriented information system based on open
system architecture using algorithms, rules and fuzzy logic
Utilities
|
No comments:
Post a Comment