Positions are adopted by vote of the association's House of. Delegates or Executive Management Committee. M a s s B a r. Civil Litigation. In a recent opinion, a federal district court judge, ruling on principles of Massachusetts law, granted summary judgment to.
Features: • Team decision tools that allow participation anytime, anywhere in the world • Project management tools to define participant roles and responsibilities • Science-based analytics that translate team knowledge, expertise and intuition into quantitative measures • Insight and survey tools that resolve conflicting priorities, and achieve stakeholder understanding and consensus • Structured, transparent decision making and risk assessment processes • Actionable reporting outputs and improved communications • Easy-to-use what-if scenarios.
As Cognos Analytics continues to receive quarterly releases, the back-end installation also has had numerous changes. We review the latest steps for installing and upgrading your Cognos environment. Our Cognos installation and upgrade expert, Todd Schuman, describes the installation and configuration steps on the server side of Cognos Analytics. Release 11.0.8 focuses on time saving efficiencies and making visualizations easier to understand. Plus, it includes many features in response to user requests for enhancements (RFE). In this webinar recording, Nicolas Leduc from the IBM product team demonstrates and discusses the November 2017 release.
Pro Evolution Soccer 2007 Download Completo Para Pc. In this webinar recording, Nic Leduc, IBM product manager joined us to discuss and demo the new features and some important enhancements in Cognos Analytics Release 7. Poor ol’ OLAP. Like the snazzy flip phone when the iPhone was introduced, OLAP is being passed over for what’s sexy and new.
Next generation visualization tools and fast technologies like columnar and in-memory databases are causing people to question the relevancy of the OLAP cube. But is OLAP really dead? This webinar recording explores various facets of OLAP to answer this question and discusses real-life client scenarios for a pragmatic perspective. Senturus client, Aero Precision, gave a before-and-after look at how the Senturus Analytics Connector radically improved its supply chain OEM performance reporting. Aero Precision account managers no longer spend painful hours scanning static rows and columns of data each month only to deliver incomplete reports. They now automatically generate interactive, at-a-glance Tableau dashboard reports that include critical markers and historical trending they could not previously report on. Watch the demo of how the Connector enabled Aero Precision to tie Tableau into the secure, governed data already existing in its enterprise BI platform.
Aero Precision now benefits from the best of Tableau and the best of Cognos: accurate numbers, self-service visualizations, standardized and interactive reporting, secure data, plus its manual reporting processes have disappeared. TECHNOLOGIES COVERED Cognos, Tableau, Senturus Analytics Connector RECOMMENDED AUDIENCES BI Report Authors, BI Report Consumers, BI Power Users (Developers, Support Staff), BI Managers, IT Managers, IT / BI Executives (CTO), Business Executives (CEO), Tableau users PRESENTERS David Clausen Business Intelligence Architect Aero Precision Industries Dave Clausen is a Business Intelligence Architect for Aero Precision Industries.
With more than four decades as a technologist specializing in application integration and development, Dave has worked with CEOs and executives in developing analytical software solutions designed to meet corporate reporting requirements. With Dave’s 10 years of Cognos design experience, he has implemented a robust BI platform at Aero Precision. Michael Weinhauer Practice Area Director and Solutions Architect Senturus, Inc. Michael Weinhauer heads up the Tableau Practice at Senturus.
Michael comes to us from Oracle, IBM and SAP, where he spent over 20 years in different roles acquiring a wealth of hands-on, practical BI and big data experience. Michael’s team is also responsible for the development of the Senturus Business Analytics Connector for Tableau to Cognos, which lets Tableau use Cognos as a data source. PRESENTATION OUTLINE • Overview of the Senturus Analytics Connector • Huge value in existing BI models • Organizations have invested heavily in existing models that provide governed, secure, business-friendly, performant results • Tableau users circumvent them • Using BI tools as ETL and/or recreating models in Tableau’s data prep pane wastes time and compromises integrity • Why you shouldn’t (re)-create metadata • Time consuming • Compromises data integrity • Compromises data security • Creates data silos • The solution? Cognos Analytics has literally hundreds of configurations and settings options. Knowing their capabilities will ensure your Cognos environment is tuned for best performance and stability. For example, the latest release of CA v11 includes an Interactive Performance Assistant (IPA) to view query and rendered performance on report objects.
In this webinar recording, our in-house Cognos expert and practice lead, Todd Schuman tells you how to use the IPA feature and shares lots of other tips and tricks to improve the performance of your Cognos environment. Topics covered in this high-performance webinar included: • Hardware and server specifics • Failover and high availability • High and low affinity requests • Overview of services • Java heap settings • IIS configurations • Non-Cognos related tuning TECHNOLOGIES COVERED Cognos Analytics v11, Cognos BI RECOMMENDED AUDIENCES BI Report Authors, BI Power Users (Developers, Support Staff), BI Managers, Business Analysts PRESENTER Todd Schuman Cognos Practice Lead Senturus, Inc. Todd has over 15 years of Cognos experience and heads up installations, upgrades and performance tuning for the Cognos practice at Senturus. Do you ever have the feeling that you are right on the edge of a breakthrough, but just can’t crack it? Where you’ve done everything right, but that last hurdle feels like a wall?
That’s the feeling we hear from marketing and sales executives who have invested in Marketo, Salesforce and Tableau. They know Tableau has the power to provide unique insights, that Marketo and Salesforce are teeming with valuable customer behavior data and that the combination should result in breakthrough marketing and accelerated revenue growth, but the promise remains unfulfilled.
In this webinar recording Greg Herrera, Senturus President, guides you through a roadmap of pragmatic, quick-win tips and tricks you can use to achieve the elusive breakthrough. Predictive analytics is no longer a fictional technology best suited for sci-fi movies. What was formerly only potential is now possible. But with the proliferation of technology companies selling space-age, overly complicated solutions, organizations are often challenged about where to sensibly start. It turns out that most (or all) of the data for making meaningful predictions more than likely exists in your organization. And getting to ROI is easier than you might think.
In this webinar recording, you’ll take a journey into the attainable. We walk you through an actual client use case study to show how using predictive modeling saved them over $1million in their first quarter alone. And we talk about different applications for predictive analytics and what’s needed to start your own project. TECHNOLOGIES COVERED Predictive Analytics PRESENTER Arik T. Killion Advanced Analytics Architect Senturus, Inc. Arik has 16-years of experience in advanced and predictive analytics.
Before joining Senturus, Erik was a consultant working at IBM as a data scientist/ technical professional for the North American Analytics Channel Development Team, Prior to IBM, Arik was the director of analytics at a large national marketing agency. Arik has developed deep experience using a variety of methodologies from simple quantitative statistics to predictive modeling techniques and text/sentiment analysis to produce actionable insights, guide strategic management decisions and acquire meaningful business intelligence.
He has created solutions for clients such as Chrysler Group, Kraft Foods, Allergan, Lowe’s, Verizon Wireless, JD Power, Nielsen Ratings Group, Sony Entertainment and many others. PRESENTATION OUTLINE If This Is The Future, Where’s My Jetpack? • The relevancy problem with predictive analytics • Advances in technology seems to have made things more difficult Marketing Case Study – The $1Million BI Column The Company • Major flooring manufacturer in the U.S. If your organization is like most, you have multiple self-service and enterprise BI tools at your disposal. And that’s a good thing because there is no such thing as a one-size-fits-all tool. By design or by nature, certain tools are better at performing certain tasks than others. How do you know which tool is the best suited for the task at hand?
In this recorded webinar, our experts take you through the high-level benefits and drawbacks of these disparate platforms. We’ll share a comparison matrix we developed using our real-life experience working with both types of solutions. With it, you’ll be able to better determine which approach to take. Click to see the original version of this webinar in which we highlight client use cases, looking at real life considerations that drive the choice of tool. [caption id='attachment_7288' align='alignnone' width='480'] Our poll shows most organizations are using numerous BI tools.[/caption] RECOMMENDED AUDIENCES BI Report Authors, BI Report Consumers, BI Power Users (Developers, Support Staff), BI Managers, IT Managers, IT / BI Executives (CTO) PRESENTER Albert Valdez Vice President of Learning Solutions Senturus, Inc. Albert is the Vice President of Learning Solutions at Senturus.
He has more than 17 years of experience in business intelligence education and technical training. In addition to founding and running the Senturus training division, Albert also serves in various roles in the company including senior consultant and solutions architect. Albert has overseen the growth of the Senturus training practice from a few Cognos authoring classes to dozens of courses covering the breadth of Cognos Analytics and Tableau. Scaling Tableau beyond departmental boundaries introduces significant new challenges and risks around performance, data integrity, maintainability, security and training. Relying on Tableau for enterprise-wide reporting and analytics requires a very different approach (and mindset) than using it as a desktop analysis tool. In this webinar recording, the Tableau gurus at Senturus discuss the things they wished they had known before rolling out Tableau to the enterprise.
The presentation included these topics and more: • A demonstration of best practices for designing shared dashboards • Which tasks to keep in Tableau and which to offload • The consequences of data prep vs data blending • The changing role of IT • Avoiding performance issues TECHNOLOGIES COVERED Tableau RECOMMENDED AUDIENCES BI Report Authors, BI Report Consumers, BI Power Users (Developers, Support Staff), BI Managers, IT Managers, IT / BI Executives (CTO) PRESENTERS John Peterson CEO and Co-Founder John is the company's thought leader and visionary. John directs the delivery of all projects with Senturus, providing the bridge of technical and business understanding.
Kyle Biehle Tableau Solutions Architect Kyle has 20 years of experience in data analytics and 10 years working with Tableau. Kyle is focused on helping clients use Tableau in novel and efficient ways by helping them see and interact with their data in ways they hadn’t before. Some organizations running enterprise analytics have hesitated to widely deploy Tableau – with understandable reason. Because Tableau can’t connect to the Cognos and MicroStrategy environments, Tableau users bypass the secure, governed and business friendly data that lives there.
Instead, they work directly with raw source data, going through a labor-intensive process of re-remodeling data. Aside from wasting valuable time, this method compromises data integrity, security and reporting accuracy. View a show-and-tell of the Senturus Analytics Connector, our simple, elegant solution that ties Tableau to Cognos and MicroStrategy as data sources. By increasing data accuracy and eliminating time consuming redundancies in report creation, the Analytics Connector provides significant benefits to both IT and Tableau users. Report authoring in IBM Cognos Analytics v11 delivers a radical new user experience. Authors will be able to master this new interface – and take advantage of some cool new features – with a little training. In this webinar recording, see a series of step-by-step demos of the new reporting interface. We show you how authoring works in Cognos Analytics and how it contrasts to Cognos BI v10.
We go deep on various aspects of report creation including: • New vs. Legacy templates • Adding new report data • Creating calculations • New data discovery features • New OLAP features TECHNOLOGIES COVERED Cognos Analytics v11 RECOMMENDED AUDIENCES BI Report Authors, BI Power Users (Developers, Support Staff), BI Managers, Business Analysts PRESENTER Albert Valdez Vice President of Learning Solutions Albert has spent the last 15 years as a technical trainer focused on business analytics and performance management. Before joining Senturus, he was a Senior Education Specialist at Cognos.
He is an IBM Cognos Certified Trainer and has his lifetime CTT and certification from CompTIA. During his tenure at Senturus, Albert has served in the roles of Senior Consultant, Solutions Architect and Director of Education. PRESENTATION OUTLINE • A brief history of report authoring with Cognos Analytics • Demo #1: Our favorite new features in Cognos Analytics • Demo #2: Authoring and data exploration in Cognos Analytics • The IBM Cognos author – the path forward. Cognos Analytics Release 6 went live on March 17, 2017. This webinar recording walks through the following enhancements: • PORTAL: allows more flexibility to convert C10 portal pages, create report views, shortcuts and more • DASHBOARD: enhanced mapping plus now supports direct access to OLAP packages • REPORTING: allows access to queries from data modules in addition to the many enhancements to the interactive viewer If you’ve been holding out on upgrading, watch this recording to learn how you’ll be able to leverage all the new features and capabilities of Cognos Analytics with your existing content. TECHNOLOGIES COVERED Cognos Analytics v11 RECOMMENDED AUDIENCES BI Report Authors, BI Power Users (Developers, Support Staff), BI Managers, Business Analysts PRESENTER Nic Leduc IBM Cognos Analytics Offering Management Nic is part of the Product Management team for IBM Cognos Analytics.
His main responsibilities are focused around dashboarding and mobile capabilities. PRESENTATION OUTLINE IBM Cognos Analytics: What’s New in R6 • Factors shaping the future • Cognos Analytics releases • Highlights of R6 • Dashboarding • Mapping • Storytelling • Reporting • Core app • Platform • Data access • Useful links. During this webinar, we get beyond the buzzwords and give you a better understanding of the Cloud options for your business intelligence infrastructure. After explaining the Cloud and its pros and cons, we dive deeper into Microsoft Azure and its broad collection of cloud services. View the webinar recording to get insight into: • The Cloud in general and its relationship with business analytics • Types of Cloud offerings including infrastructure, platform and software • Cloud vs on-premise solutions: the pros and cons and total cost of ownership (TCO) between the two • Microsoft's implementation of cloud services offered under the Azure brand • Demonstration of spinning up an Azure instance TECHNOLOGIES COVERED Microsoft Azure PRESENTERS Shawn Alpay BI Architect Senturus Inc.
Shawn is well-versed across the entire Microsoft BI stack and its wide range of offerings, having built ETL, data warehouse, reporting and analysis solutions from the ground up. In his various development and architecture roles, he often serves as the project manager and business analyst, partnering directly with the business to gather requirements and deliver insight.
Jim Pelichowski Senturus, Inc. Jim has over 25 years of experience delivering business analytics solutions for organizations of all sizes and business models. He recently developed an Azure solution for survey analytics for a start-up company in San Francisco using Tableau and Azure SQL Server. PRESENTATION OUTLINE Azure and Business Intelligence, What Does the Pairing Mean? • Before what is Azure?: what is the Cloud?
• Types of cloud offerings • Why bother with the Cloud for BI? • Scalability of on-premises vs the Cloud • Sounds magical, why not use the Cloud? • How can I get my hands on the Cloud?
• Let’s talk Microsoft Azure • Azure SQL database scalability • Cloud vs on-prem vs hybrid example: SQL Server Azure Demo. The goal of good dashboard design is to provide a single actionable insight, not multiple. Achieving good dashboard design requires clarity: about your business audience; about the business function and about how the layout helps bring about insights.
But it’s one thing to read about effective design theory and another to put it into practice. Working directly in Tableau, this webinar recording demonstrates Tableau design principles and best practices. We show you tangible instances of the good, the badand the downright ugly. After viewing this presentation, you will: • Understand how aspects like text, color, font size and page placement can helpor hinderyour audience • Choose better approaches for creating user interfaces • Have solid understanding of what dashboards work best for your goals • Know what things to (almost) never do TECHNOLOGIES COVERED Tableau RECOMMENDED AUDIENCES BI Report Authors, BI Report Consumers, BI Power Users (Developers, Support Staff), BI Managers, IT Managers, IT / BI Executives (CTO) PRESENTER Michael Weinhauer Tableau Practice Area Director and Solutions Architect Senturus, Inc. PRESENTATION OUTLINE 10 Best Practices for Tableau Dashboard Design • How to design a dashboard with a goal in mind • How the overall dashboard layout impacts effectiveness • How to design for best performance • Which chart type work best, for specific goals • How to use the three-color types effectively • How to get the most impact from text • How to minimize dashboard object while maximizing actionable insights • When to use any of the three basic types of navigation • Some things to (almost) never do • The two fundamental, guiding principles, for all dashboards. The Microsoft front end tools for business analytics are rich and varied and have changed over the years, making it difficult to determine which tool is most appropriate for business scenarios.
In this webinar recording we examine each of the Microsoft front end BI tools, from Power BI to Excel, SQL Server 2016, and SSRS to give you a confident grasp of the tools at your disposal. We discuss each tool’s strengths and weaknesses, understand when it’s better to use one tool rather than another, and how they integrate together to form a complete BI framework. The release of IBM Planning Analytics 2.0 brings many new capabilities for TM1 users and Cognos Analytics authors. With this release, IBM adds an on-premise offering to the initial cloud version, allowing users to leverage the latest TM1 capabilities within their local environment.
Planning Analytics Workspace delivers a friendly web-based interface that allows users to organize, analyze and present TM1 content from a variety of sources. Workspace provides self-service interactive dashboards, visualizations and report books for web and mobile. Integration with Cognos Analytics allows authors to leverage their Cognos BI knowledge with TM1 cube data sources. In this webinar recording, we look at new features in Planning Analytics 2.0 and demo key concepts.
Cognos Analytics 11 Release 5 was released in November 2016 and contains great new features - including (finally!) administrator controlled user group customizations that can help you migrate off Cognos BI 8/10 Portal Tabs. In this webinar recording we get hands-on with some of the best features in Release 5 and discuss what to expect in Release 6. Topics covered: • Role customizations – bridge the Portals Tab gap to make the leap from Cognos BI 10 to Cognos Analytics • Geospatial mapping – today and tomorrow • Navigation paths – break free of traditional dimensional modeling TECHNOLOGIES COVERED Cognos Analytics v11, Cognos BI 8, Cognos BI 10, Portal Tabs RECOMMENDED AUDIENCES BI Report Authors, BI Power Users (Developers, Support Staff), BI Managers, Business Analysts PRESENTER Todd Schuman Cognos Architect Senturus, Inc. Todd has over 15 years of Cognos experience and heads up the Senturus install, upgrade and optimization practice. Todd presented alongside IBM product managers at the 2016 World of Watson conference Considerations When Upgrading to IBM Cognos Analytics. His webinar on the same topic.
The value of data-driven decision making has never been greater, and the tools with which to deliver it have never been more powerful. Furthermore, the demand from business users for useful information continues to grow as organizations realize that good analytics enable them to outperform competitors by wide margins. So why is it that study after study shows that 60-90% of the time business intelligence and analytics projects fail? One hint: it is not the tool and technologies that dictate a successful outcome. What can be done to dramatically improve your organization's chances of success when undertaking these high-value – and typically high-profile – projects?
Senturus President, John Peterson, reveals the keys to business analytics success. Drawing on real-life experience with more than 1000 customers and thousands of projects, John distills the top actionable steps to help dramatically improve the outcomes of your BI and analytics initiatives. Among the critical strategies discussed: • How to better scope out and manage projects • Why you shouldn’t trust anyone who says data staging isn’t important • Tips on how to better deliver what users really need • Ways to increase user adoption • How to deliver more value, more quickly while using fewer resources Technologies Covered Business Analytics, Business Intelligence Recommended Audience Senior Executives; Operational and Finance Managers; IT Managers; Business Intelligence Managers; Business Analysts Presenters John Peterson CEO and Co-Founder Senturus, Inc. John is the company's thought leader and visionary. John directs the delivery of all projects with Senturus, providing the bridge of technical and business understanding.
Some organizations running Cognos have hesitated to widely deploy Tableau – with understandable reason. Because Tableau can’t connect to the Cognos environment, Tableau users bypass the secure, governed and business friendly data that lives there. Instead, they work directly with raw source data, going through a labor-intensive process of re-remodeling data. Aside from wasting valuable time, this method compromises data integrity, security and reporting accuracy. View a show-and-tell of the Senturus Analytics Connector, our simple, elegant solution that ties Cognos to Tableau as a data source. You’ll also hear from one of our customers, Ixia, and learn how they are you using the Connector. At Ixia, the Connector has replaced rerunning calculations in Excel for their weekly, monthly and quarterly reports saving many hours of labor per month. The biggest benefit Ixia appreciates is knowing the data is trustworthy and not subject to human errors associated with Excel manipulations.
Designed to help both IT and Tableau users, this demo shows how the Analytics Connector enables: • Faster report building in Tableau • Reduced change management • Improved security with appropriate guardrails around data access • Increased data accuracy • Better overall Tableau performance Learn how your organization can enjoy the self-service visualizations of Tableau while preserving the benefits of your Cognos model. TECHNOLOGIES COVERED Cognos, Tableau, Senturus Analytics Connector RECOMMENDED AUDIENCES BI Report Authors, BI Report Consumers, BI Power Users (Developers, Support Staff), BI Managers, IT Managers, IT / BI Executives (CTO), Business Executives (CEO), Tableau users PRESENTER Michael Weinhauer Practice Area Director and Solutions Architect Senturus, Inc. Michael Weinhauer heads up the Tableau Practice at Senturus. Michael comes to us from Oracle, IBM and SAP, where he spent over 20 years in different roles acquiring a wealth of hands-on, practical BI and Big Data experience. Michael’s team is also responsible for the development of the Senturus Business Analytics Connector for Tableau to Cognos, which lets Tableau use Cognos as a data source.
Rajat Sharma Financial Planning and Business Intelligence Specialist Ixia Rajat has over 10 years of experience as a Financial Planning and Business Intelligence Analyst. He is a motivated self-starter who is committed to looking for ways to improve processes and exceed expectations of customers. Rajat manages multiple priorities and is always adjusting in the fast-paced environment in which he works. He continually strives to understand the data and present analysis in an engaging delivery. Steven Kiser Senior Manager, Financial Systems Ixia Steven has over 25 years of experience in FP&A, Business Intelligence, and Process Improvement. He has implemented numerous Business Intelligence and budgeting systems for financial institutions and High Tech firms. His mantra is “if you can’t find the time to do it right, when will you find the time to do it over?” PRESENTATION OUTLINE • Huge Value in Existing BI Models • Tableau’s Data Prep Pane Wastes Time and Compromises Integrity • Some Challenges with (Re)-Creating Metadata • The Solution?
The Senturus Analytics Connector • Instant Access to Quality Data Sets • Don’t Sacrifice Integrity for Agility • Senturus Analytics Connector Demo • Summary • (Re)-creation of Metadata is Slow, Challenging and Risky • The Senturus Analytics Connector Gives Agility and Integrity • Spend Time Doing Analysis, Not Prepping Data that’s Already Curated Elsewhere. There’s a tug-of-war going on between self-service analytics tools and enterprise BI. With the ensuing confusion – and downright FUD – in the marketplace, organizations struggle to determine which of the two types to use.
The answer is it depends on the task at hand. Each has its drawbacks and benefits. In this recorded webinar, our experts cover real-life client use cases and the factors playing into the choice of tool. You’ll get practical input on guiding considerations when selecting an approach: governance, accessibility, functionality, time to decision (agility). Among the use cases under discussion: • A large health care organization using enterprise BI centralized data • An online e-tailer using self-service analytics • A capital equipment manufacturer using a hybrid solution of Tableau self-service analytics and Cognos enterprise BI Because Senturus works across the spectrum of enterprise BI and self-service tools, we can clear the FUD and shed some much needed light on where each type of tool is best suited. An updated version of this webinar in which we delve deep into the comparison of features matrix.
RECOMMENDED AUDIENCES BI Report Authors, BI Report Consumers, BI Power Users (Developers, Support Staff), BI Managers, IT Mangers, IT / BI Executives (CTO) PRESENTERS John Peterson CEO and Co-Founder John is the company's thought leader and visionary. John directs the delivery of all projects with Senturus, providing the bridge of technical and business understanding. Albert Valdez Vice President of Learning Solutions Senturus, Inc. Albert is the Vice President of Learning Solutions at Senturus. He has more than 17 years of experience in business intelligence education and technical training.
In addition to founding and running the Senturus training division, Albert also serves in various roles in the company including senior consultant and solutions architect. Albert has overseen the growth of the Senturus training practice from a few Cognos authoring classes to dozens of courses covering the breadth of Cognos Analytics and Tableau. Senturus’ Todd Schuman describes installation, configuration and architectural considerations that you need to know when upgrading to Cognos Analytics Release 4. Learn what has changed since the last release. Topics include: • Updated prerequisites • New installation options • Changes to the configuration • Changes to the gateway • Latest news on legacy studios • Odds and ends TECHNOLOGIES COVERED Cognos Analytics v11, IBM Cognos BI, Cognos Workspace Advanced, Cognos Report Studio RECOMMENDED AUDIENCES System Administrators, BI Report Authors, BI Power Users (Developers, Support Staff), BI Managers, IT Managers PRESENTER Todd Schuman Cognos Architect Senturus Todd has over 15 years of Cognos experience and heads up the Senturus install, upgrade and optimization practice. This was Todd's presentation topic at the IBM 2016 World of Watson conference.
You may also be interested in viewing Todd’s webinar recording, in which he explains a fast way to convert Query Studio reports now before you upgrade. You have been creating dashboards and insightful analysis with Tableau Desktop. But now you want to share your work with others and allow them to interact with your worksheets.
How do you do it? What should you avoid? How do you manage your costs? The solution is Tableau Server.
It’s secure, powerful – and equally important – easy-to-use from both the end user and IT perspectives. This recorded webinar reveals the perks of Tableau Server and reviews the top 11 avoidable pitfalls that impact performance, scale and user adoption. Data warehouses. Who needs them anymoreright?
Today’s self-service analytics tools such as Tableau and Cognos Analytics V11 have put tremendous power in the hands of the departmental business user. And gone are the days of 65,000 row limits in Microsoft Excel. Business managers can directly tap large information sources throughout the organization to create insight-rich visualizations and dashboards, often without the need to wait for IT resources to deliver data.
Vendors of new technologies such as Hadoop often tout large cost savings by doing away with traditional ETL tools and data warehouse environments. So why would an organization still want to invest the time and energy (and dollars) to create a centralized repository of data?
And what processing and transformations are still prudent, if not mandatory, to do in a centralized fashion? In this recorded webinar, Senturus CEO John Peterson discusses the modern data warehouse with 29+ reasons why you still need to properly pre-process and stage your data. He touches on topics ranging from security to performance to universal definitions to blending data sources to snap-shots and more. TECHNOLOGIES COVERED Data warehouses PRESENTER John Peterson CEO and Co-Founder John is the company's thought leader and visionary. John directs the delivery of all projects with Senturus, providing the bridge of technical and business understanding. Learn self-service reporting features in Cognos Analytics: data modules, data sets and data servers.
In this demo-packed session, we review the differences – and benefits – of each feature and provide how-to guidance for data acquisition and storytelling with these powerful visualization features. This wall-to-wall Cognos Analytics demo bonanza teaches you how to: • Upload your personal data • Connect to centralized data assets like SQL Server • Link data sources using lightweight modeling tools • Use existing packages to tell stories using dashboards and intuitive visualizations This 45-minute session is 100% demos: no PowerPoint. TECHNOLOGIES COVERED Cognos Analytics v11, Dashboarding, Data Modules, Data Sets, Data Servers RECOMMENDED AUDIENCES BI Report Consumers, BI Power Users (Developers, Support Staff), BI Managers, IT Managers, Financial Analysts, Marketing Analysts, Marketing Managers / Directors, Business Analysts PRESENTER Albert Valdez Vice-President of Learning Solutions Senturus, Inc. Albert has spent the last 15 years as a technical trainer focused on business analytics and performance management. Before joining Senturus, he was a Senior Education Specialist at Cognos. He is an IBM Cognos Certified Trainer and has his lifetime CTT and certification from CompTIA. Albert has served as a Senior Consultant, Solutions Architect and Director of Education for Senturus.
Effective executives rely on leading indicators of sales revenue — such as pipeline growth and win rates — to keep their fingers on the pulse of company performance. Many firms have invested in sales pipeline tracking systems such as Salesforce and visualization tools such as Tableau to surface leading indicators to their executives. However, if you are connecting your visualizations directly to your CRM system, you are missing some of the valuable indicators. The solution is a “staging database”—an intermediary between the two systems that transforms the data and surfaces all the information organizations need for early, high powered performance visibility. Senturus explains how to capture, calculate and track the hard-to-get leading indicators, such as: • The components of pipeline growth: • Growth from new opportunities • Changes to the value of existing opportunities • Changes to the win-probability of existing opportunities • Conversion rates for each stage of the sales cycle • The marketing metrics that lead to new pipeline • Individual lead score trend • Marketing engagement trend This information is most valuable to B2B organizations, those having sales teams entering and tracking multi-stage sales cycles in an opportunity database.
The “how to” examples feature Tableau and Salesforce, but we explain how the techniques are useful even if you use other tools. TECHNOLOGIES COVERED Tableau, Salesforce, CRM RECOMMENDED AUDIENCES • Executives who want to ensure all the sales indicators are being surfaced • Business analysts interested in expanding their data capture and transformation techniques • Members of the business analytics teams who are tasked with providing forward visibility • Technologists who want to increase the business value of their systems PRESENTER Greg Herrera President and Co-Founder Senturus, Inc.
Greg founded Senturus in 2001 and today leads the demand creation side of the company. Under his leadership, the company has been on Inc.
Magazine’s annual list of America’s Fastest Growing Private Companies for three years running. In addition, Senturus was inducted into the San Francisco Business Times 'Fast 100' Hall of Fame.
Greg has 13 years of hands-on experience with Salesforce and the application's underlying tables. PRESENTATION OUTLINE • Leading Indicators • Measure performance that has already happened • Financial statements: revenue, gross margin, profit • Leading Indicators • Indicate the direction of in-course performance • Lounging Indicators • “ will be leaving the company to spend more time with family” • Leading Indicators – What’s Missing? • Leading Indicators of Revenue • 4 Ways Companies can Increase Revenue • Increase the number or value of deals in the pipeline (pipeline growth) • Improve their rate of success (win rate) • Close bigger deals (average deal size) • Increase the velocity of the deals moving through the pipeline, such as shorten the sales cycle (time to close) • Pipeline Growth in 3 Ways • New deals entering the pipeline (new deal) • Existing pipeline deals changing size (value change) • Existing deals changing stage (stage change) • Contextual Attributes – What’s Missing? Cognos Analytics Release 5 was introduced on November 25, 2016, and has some significant new visualization and analysis features. In this webinar recording, our guest IBM Cognos Analytics Product Manager Nic Leduc, demonstrates this new release and answers audience questions. Salesforce and integrated ERP systems collect tons of valuable information, but the challenge is figuring out how to use that data to predict future sales.
Predictive modeling has promised to deliver tomorrow’s numbers, but remains under-used due to complexity or inaccuracy. In this webinar recording, we share effective, pragmatic sales forecasting approaches. We describe best practices for organizing and preparing your Salesforce and ERP systems for predictive modeling, and reveal how to best use Tableau and R to visualize the future.
Up until now, demos of Cognos Analytics have been more about look and feel than its implications to users. Tableau 10 is here!
Working with the Query Model in IBM Cognos Analytics can be a tricky transitional skill, even for advanced report authors. The learning curve is made even more daunting by the shift to the new, significantly different user interface.
However, many fundamental analyses can only be addressed using a multi-query approach. Therefore, designing reports that use query joins and sets, such as unions, is an important skill for all professional authors. In this recorded webinar, we demonstrate Cognos Analytics v11 Query Explorer and teach techniques that help create sophisticated reports that are based on multiple queries. Techniques and takeaways include: • Best practices for interacting with the Query Explorer • Understanding the differences between the versions • Using Query Explorer in the context of common business challenges such as basket analysis TECHNOLOGIES COVERED Cognos Analytics v11, IBM Cognos BI, Cognos Report Studio RECOMMENDED AUDIENCES BI Report Authors, BI Power Users (Developers, Support Staff) PRESENTER Albert Valdez Vice-President of Learning Solutions Senturus, Inc. Albert has spent the last 15 years as a technical trainer focused on business analytics and performance management.
Before joining Senturus, he was a Senior Education Specialist at Cognos. He is an IBM Cognos Certified Trainer and has his lifetime CTT and certification from CompTIA. Albert has served as a Senior Consultant, Solutions Architect, and Director of Education for Senturus. PRESENTATION OUTLINE • What is the Query Model?
• Changes from Cognos BI v10 to Cognos Analytics v11 • Query References • Query Sets • Query Joins • Custom SQL/MDX • Set Operations: Unions, Intersections, Exceptions • Set Operation Rules • Business Scenario • Demonstration of Report Authoring in Cognos. The rapid growth in self-service business analytics has created tremendous value for organizations, but in many cases has created tension between technical and business users. Technical teams have spent years building solid data warehouses filled with trusted data from source systems such as sales, finance and operations. Business teams are gaining insights using new data discovery tools such as Cognos, Business Objects, Tableau and Power BI.
But, the insights create the desire for new data sources – and the data warehouse teams can’t keep up. Informatica Cloud provides a solution that both business and IT users will appreciate. This demonstration shows a best-of-both-worlds solution that combines data integration for both business and IT users.
This recorded webinar helps Cognos developers and system administrators make the transition from v10 to Cognos Analytics (v11). Blending demos and discussions, we explain dashboarding, data modules, and administration in Cognos Analytics.
Some data is more difficult to get at and analyze than others. Data coming from social media, emails and surveys is extremely hard to analyze owing to its complex, irregular structure and often times heavy use of text fields. Adding to the challenge is the high cost of an industrial strength database with the horsepower for these kinds of complex analyses.
There is a cost-effective solution. In this webinar we show you how to: • Prepare complex data such as survey data for use in Tableau • Get the power of an industrial strength database on a budget Stop Meeting Like This (SMLT) share its success maximizing the impact of client survey responses (SurveyMonkey, Zoho, Google Forms) using the Microsoft Azure cloud environment, data preparation and the creation of Tableau visualizations. TECHNOLOGIES COVERED Tableau, Microsoft Azure, Microsoft SQL Server RECOMMENDED AUDIENCES BI Report Authors, BI Power Users (Developers, Support Staff), IT Managers, Financial Analysts, Marketing Analysts, Start-up companies PRESENTERS Jim Pelichowski, Senturus Inc. Alia Santini, Stop Meeting Like This PRESENTATION OUTLINE • Getting Tableau to Work with Challenging Data • Big Data on a Budget • An Introduction to: Stop Meeting Like This • Tableau Visualization – Likert Survey Questions • Getting There: A Closer Look at Survey Data • Challenges Using Unstructured Data • Tableau Works Much Better with Data Like This • What About Unstructured Data? • Solution – Data and Physical Architecture. This handy, straightforward guide from Tableau helps you easily determine the best chart to use for the data you have and the questions you want to answer -- or the story you want to tell. In clear language and with excellent visual examples, Tableau outlines best practices for making effective visualizations.
They also offer tips for combining related charts and filters to really boost the effectiveness of visualizations, and ultimately your business decision making. This paper includes tips and things to consider when using the following types of graphs: • Bar chart • Line chart • Pie chart • Map • Scatter plot • Gantt chart • Bubble chart • Histogram chart • Heat map • Hightlight table • Treemap • Box-and-whisker plot Related resources about effective visualization creation. By now, you have heard about all the new features of Cognos Analytics. And while there are many good things in store, the truth is that its integration with Cognos BI v10 is not seamless.
Learn what you need to know to prepare for Cognos Analytics−before you upgrade. We tell you what technologies you should be investing your resources in, and which ones you should stop using. Learn which reports you should convert now and what you can leave for later. We also demonstrate a new product that allows you to automate report conversions. You have been creating dashboards and insightful analysis with Tableau Desktop. But now you want to share your work with others and allow them to interact with your worksheets. How do you do it? The solution is secure, powerful – and equally important – easy-to-use from both the end user and IT perspectives.
If you’re like many companies, you struggle to connect your sales and marketing systems and are frustrated by the inability to accurately profile and track your customers. Closing the loop to connect the two silo'd systems is easier to achieve than you may realize. Learn to use the right tools and maximize your expertise to easily surface critical marketing metrics to: • Measure return on marketing investment • Know your customer lifetime value • Optimize your marketing and sales funnels based on profit per marketing dollar TECHNOLOGIES COVERED Alteryx RECOMMENDED AUDIENCES BI Report Authors, BI Report Consumers, BI Power Users (Developers, Support Staff), BI Managers, Marketing Analysts, Program or Project Managers PRESENTERS Greg Herrera President and Co-Founder Senturus Adam Smithline CEO Opticity, Inc.
John Policaro Channel Manager West Region Alteryx, Inc. Albert Pardilla Solutions Engineer Alteryx, Inc. PRESENTATION OUTLINE Closed-Loop Marketing Overview • What is Closed-Loop Marketing? Current data warehouses are not architected to meet current analytics requirements including end user self-service, multiple tools, huge data volumes, visualizations, and deeper analysis needs. During this webinar, our special guest Mark Madsen, keynote speaker at the TDWI World Conference, shares his insights into the five major issues facing data warehouses and his solution to increase agility and flexibility. PRESENTER Mark Madsen President, Third Nature Over the past decade, Mark has received awards for his work in data warehousing, business intelligence and data integration from the American Productivity & Quality Center, the Smithsonian Institute and TDWI.
He is co-author of Clickstream Data Warehousing, and lectures and writes about business intelligence, emerging technology and data integration. Mark was the keynote speaker at this year's TDWI World Conference. Mark is the founder of Third Nature, a firm that researches and consults with companies on new and emerging technology and practices in business intelligence, data integration and information management. He is also a former CTO and CIO with experience working in both IT and vendors, including a stint at a company used as a Harvard Business School case study. The great paradox of data analysis is that 80% of the overall analysis process is spent cleaning or preparing data. The reason is the complexity and diversity of data. Complicating matters is that users increasingly expect self-service, yet their organizations struggle to help them effectively work with data in a properly governed and secure environment.
In this webinar recording, Trifacta explains how the emergence of new self-service data prep solutions for Hadoop are benefiting organizations. We discuss how Trifacta’s data wrangling solutions are used to improve the efficiency of existing analytics processes and successfully execute new analytics initiatives. We demo Trifacta Data Wrangler and discuss: • The challenges self-service data prep solutions are designed to solve and why the space has quickly gained in popularity.
• How organizations are implementing self-service data prep to execute new types of analysis or augment existing processes. • The range of user and administrative features of self-service data prep tools like Trifacta. • How companies like PepsiCo and Royal Bank of Scotland use self-service data prep. Get a free trial of. There is confusion about how data science fits into the landscape of businessand IT.
In this intriguing webinar with Bill Schmarzo, CTO of EMC’s Global Services Big Data Practice, we look at what data science is, what it hopes to accomplish, how it is related to business analytics, where it differs, and ultimately how organizations will benefit from using both data science and business analytics. Organizations that use the Microsoft platform to build their business intelligence and data warehouse solutions have a wealth of resources at their disposal. Understanding these assets and how they can work together allows users to build an efficient, integrated BI solution. This webinar peels back the lid on Microsoft’s offering of its BI and DW related products. During this webinar, we: • Review product features and benefits • Discuss use cases • Demonstrate product capabilities In addition, we touch on the core functionalities of these six products: • Power BI • Azure • Office • SQL Server • SharePoint Knowing these functionalities allows users to come away with a solid understanding of the role of each product and how they work together to create an integrated BI solution. TECHNOLOGIES COVERED Microsoft, all database, data warehouse, and business intelligence related products (front and back end) RECOMMENDED AUDIENCE BI Report Authors, BI Report Consumers, BI Power Users (Developers, Support Staff), BI Managers, IT Managers, IT / BI Executives (CTO), Program or Project Managers, anyone involved with the creation or use of a BI or data warehouse system PRESENTER Paul B. Felix Senior BI Architect Senturus, Inc Paul is an agile business intelligence and data warehousing junkie living in Austin, Texas.
He spends his time helping organizations use data to make better decisions by implementing BI/DW solutions. You can do data discovery or rapid BI prototyping on large data sets without becoming a Hadoop expert. Our webinar shows how you can enjoy benefits of big data and the ability to analyze it with standard BI tools, including Cognos.
IBM BigInsights Product Manager Paul Yip demonstrates a cost effective, scalable solution that does not have the barriers to entry common with big data applications. He reviews: • Use cases for Hadoop • Pros and cons of different visualization tools and their integration with Hadoop • Demonstration of BigInsights, IBM’s solution You may also be interested in the following YouTube videos authored by Paul Yip: • • • DEMONSTRATION CLOUD Big SQL Technology Sandbox is a large, shared environment for data science. You can use it to run R, SQL, Spark, and Hadoop jobs. It is a high performance cluster demonstrating the advantages of parallelized processing of big data sets. TECHNOLOGIES COVERED IBM COGNOS BI, Hadoop / Big Data, Tableau RECOMMENDED AUDIENCES BI Report Authors, BI Power Users (Developers, Support Staff), BI Managers, IT Managers, Marketing Analysts, Marketing Managers / Directors, Program or Project Managers, Predictive: Quality Assurance, Risk & Fraud PRESENTER Paul Yip, IBM Analytics BigInsights Product Manager Paul has 15 years of hands-on technical experience with the design, implementation, and performance tuning of information management systems. His career has involved many aspects of information management including distributed transactional systems, data marts and warehousing, information security and governance, Hadoop, and Big Data. Paul is the author of three books and has published dozens of technical articles.
PRESENTATION OUTLINE • What is Hadoop? Learn how to strategically design analytics dashboards to bring actionable insights to light. During this webinar, Senturus Co-Founder John Peterson explores the science behind creating effective dashboards, including the challenges, opportunities, and human factors that come into play. Using this science as the basis, John gives his top 13 tips to optimize dashboard visualizations. PRESENTER John Peterson CEO and Co-Founder Senturus, Inc. John is the company's thought leader and visionary. John directs the delivery of all projects with Senturus, providing the bridge of technical and business understanding.
PRESENTATION OUTLINE Preface: Common Questions • We want to implement Self-Service BI, how? • We need to develop a Dashboard, what should? • Do we really need a Data Warehouse? • What’s the Right tool for the job? Get unique insight into the most common Report Studio questions and obstacles to adoption.
In addition to valuable information about Cognos BI v10.x, we explore several areas of concern regarding changes to Cognos Analytics v11. Our own report authoring expert, Albert Valdez, will help you: • Overcome the uncertainty of working with Report Studio • Learn best practices for creating effective reports • Learn, through demos, the fundamental authoring techniques, such as interactive prompts, simple calculations, complex expressions, visualizations and drill-throughs TECHNOLOGIES COVERED Cognos Workspace, Cognos Workspace Advanced, Cognos Report Studio RECOMMENDED AUDIENCES BI Report Authors, BI Power Users (Developers, Support Staff), BI Managers PRESENTER Albert Valdez Vice President of Learning Solutions Senturus, Inc. Albert has spent the last 15 years as a technical trainer focused on business analytics and performance management. Before joining Senturus, he was a Senior Education Specialist at Cognos.
He is an IBM Cognos Certified Trainer and has his lifetime CTT and certification from CompTIA. Albert has served as a Senior Consultant, Solutions Architect and Director of Education for Senturus. PRESENTATION OUTLINE These questions were answered during the webinar: • Where/how do I get started with report authoring in IBM Cognos BI v10? • Cognos BI v10 has a lot of options for report authoring: Report Studio, Workspace Advanced, Query Studio, and Analysis Studio. Will you describe which tool is best to use for which situation?
• If Report Studio is the most powerful tool, why would I ever use Workspace Advanced or Query Studio? • Using Report Studio, how do I build a new report with sales information or product lines and revenue? • How can I make reports more interactive so I can customize them? For example, I want to create a report that is going to be delivered to all the sales managers around the world, but each manager wants to see only the results for her/his territory. • Will reports migrate from Cognos BI v10 to Cognos Analytics?
• Is it possible to migrate workspaces and other objects that have been built in one of the deprecated studios such as Query Studio or Analysis Studio to Cognos Analytics? • What is the difference between a dashboard and a report? Can I use Report Studio to build dashboards?
• How can I reuse objects in a report? • I’ve re-used the query within reports to add data in a line chart. Can I reuse components on multiple reports? • Is it helpful to know SQL to optimize reports? • Can I execute a stored procedure directly from Report Studio? Free Download Program Antenna Book By Kd Prasad Pdf Editor.
• In creating reports, is there any way to set a default value that is dynamic to make my prompt more intelligent? If you have been resisting cloud-based financial planning, it may be time to give it another look. Web-based solutions have matured considerably in the past few years, and offer significant benefits over traditional on-premise solutions, including lower cost of ownership and the ability to respond quickly and confidently in a volatile business environment. In particular, we have been impressed with a solution that provides the robustness, agility, and data security that are critical to the office of finance while also providing end user self-service financial planning and reporting.
During this recorded webinar, you can view a demo of Adaptive Insights, a cloud-based financial planning solution. Our own enterprise planning expert Ken O’Boyle hosts the event.
A 15 year planning veteran, Ken is deeply familiar with traditional on-premise planning tools, the needs of the office of Finance, and the Adaptive Insights solution. Ken shares frank comparisons between the solutions, and speaks about how Adaptive Insights can complement or replace on-premise solutions. The Adaptive Insights demo covers: • Built-in features that lead to more simple implementations: versioning, time dimension/horizon, pre-defined account structure, sheet templates, etc. • Unique user/planner capabilities (planning method – balance level, line-item detail, formula or breakback – can vary from one department to another for the same account) • Do-it-yourself features including integrated financial reporting • Security measures TECHNOLOGIES COVERED Adaptive Insights PRESENTER Ken O’Boyle Solution Architect Senturus, Inc. Ken has more than 20 years of hands-on experience architecting, implementing, and delivering training for enterprise planning, business intelligence, and data warehousing solutions.
He has both a CPA and MBA. PRESENTATION OUTLINE Financial Planning Solutions Key Considerations • Cloud vs. On-premise • Application vs. Tool • Web-based & Excel-based Options • Centralized vs. Decentralized Planning Adaptive Insights • Cloud vs. On-premise • Application vs.
Tool • Web-based vs. Excel-based (with option for an MS Office add-in for reporting) • Centralized vs. Decentralized Planning Differentiators • Intuitive experience • Customer service • Integrated analytics • Financial processes Support for Your Evolution • Enhance planning = increases efficiency and accuracy • Optimize finance = improves processes and decisions • Transform performance = creates profound strategic value Demonstration. Are you looking to do more reporting than your Banner or PeopleSoft solution provides out of the box? Many colleges and universities are looking for self-service analysis but think it requires expensive new software, the need for more already hard-to-get dollars, or the addition of expert resources. By properly preparing your data and using modules found in your existing Banner or PeopleSoft solution, you can provide integrated insights across your entire organization and dramatically improve report creation time and accuracy. In this webinar learn about the potential that already exists in current reporting system.
Portland State University demonstrates how they were able to quickly obtain ROI by dramatically improving their report performance. Performance Tuning Learn proven practices and industry standards for setting up your Cognos servers to handle anything you can throw at it. In this free webinar, we focus on how to fine-tune the following different aspects of the Cognos environment to maximize the platform’s potential: • Hardware-based Performance: Hardware to procure for servers, virtual vs. Physical servers, and how to structure your environment • Cognos Server Tuning: Settings to adjust, establishing enough resources to handle concurrent user base • 64/32-Bit: Determining which one is right for your organization, leveraging 64-bit advantages • Data Tuning: Determining when a data warehouse is needed, tackling bottlenecks, Dynamic Cubes and PowerCubes Discover how to get the most out of your Cognos investment.
PRESENTER Todd Schuman Cognos Architect Senturus, Inc PRESENTATION OUTLINE Hardware Performance • Sizing Up Servers: Processors, Sockets, and Cores • Processes • An independent program running on a computer. A process has a full stack of memory associated for its own use, and does not depend on another process for execution. • Thread • A thread is essentially a process that does not have a full stack of memory associated for it. The thread is tied to a parent process, and is merely an offshoot of execution. Typically thread processes must run on the same computer, but can execute simultaneously on separate cores of the same node. • Hyper-threading • Hyper-threading is an Intel technology that originally preceded multi-core systems, and was used to make a single core appear logically as multiple cores on the same chip.
Intel abandoned hyper-threading briefly during the advent of multi-core processors but reintroduced the technology in 2008. Since then, Intel has used it extensively to improve the performance of parallel computations in its multi-core processors. Hyper-threading improves performance by sharing the computational workload between multiple cores whenever possible, allowing the operating system to schedule more than one process at a time. • Adjusting RAM • Use the following memory settings as a starting point and adjust them based on the memory usage of your system. Business analysts deal with multiple types of data from a variety of internal and external sources, including behavioral data, census data, sales data, and predictive data.
All too often, they are spending too much time preparing data, or relying on others to get the data in the right format for visualization. These burdens often mean missed opportunities regarding the richness of the information. In this webinar, learn how Alteryx empowers analysts to deliver deeper insights to the organization. With Cognos Analytics v11, IBM has taken self-service analytics head on. In this recorded webinar, our guest from IBM previews the new functionality including the user-friendly interface with great visualizations. Cognos Analytics will be widely available at the end of 2015. IBM Cognos Analytics is the new name for, and the next version of, IBM Cognos Business Intelligence.
You can think of it as version 11. This document, authored by IBM, discusses various aspects of the Cognos Analytics product. Tableau version 9 includes powerful calculation functions that are more complex than the usual functions. This webinar covers the following topics: • Learn how to use REGEX() functions • See examples of Level of Detail calculations • Learn how to solve database issues with these functions Our Tableau expert, Chuck Hooper, shows how these functions are useful for solving database issues (for example: many to one) where custom SQL has been the typical solution. TECHNOLOGIES COVERED Tableau RECOMMENDED AUDIENCES BI Report Authors, BI Power Users (Developers, Support Staff), Financial Analysts, Marketing Analysts, Predictive: Quality Assurance, Risk & Fraud PRESENTER Chuck Hooper's career includes over five decades of business and IT experience. He started Tableau's Professional Services consulting organization and is one of the few individuals officially designated as a Tableau Zen Master 2012-2014.
He conducts training sessions on the use of Tableau Software products, and does speaking engagements on visual analytics, data warehouse design and other business intelligence topics at both the technical and the executive levels. PRESENTATION OUTLINE Regular Expressions in Tableau • REGEXP_REPLACE() • REGEXP_MATCH() • REGEXP_EXTRACT() • REGEXP_EXTRACT_NTH() Level of Detail Expressions • FIXED • INCLUDE • EXCLUDE Regular Expression Assistance Links • • •. Cognos Analysis For Excel (CAFE) has become popular among business and financial analysts as a way to combine enterprise information with local data in an Excel spreadsheet that can be refreshed as server information changes. In this webinar, we take a look at the capabilities of CAFE, compare them when using the tool with TM1 versus Cognos BI as a source, and share a number of useful tips and caveats along the way.
Providing demonstrations of key concepts, we cover the following topics: • Differences between using CAFE with TM1 and Cognos BI • When and why to consider using CAFE • Useful techniques and common pitfalls Technologies Covered IBM Cognos BI, CAFE (Cognos Analysis for Excel), Cognos TM1 Recommended Audience BI Report Authors, BI Report Consumers, BI Power Users (Developers, Support Staff), BI Managers, Financial Planners, Financial Analysts, Finance Managers, Marketing Analysts PRESENTER Ken O’Boyle Solution Architect Senturus, Inc. PRESENTATION OUTLINE What is CAFE? • Excel add-in (IBM Cognos tab/ribbon) • Provides analytical and report authoring capabilities against Cognos BI packages and TM1 cubes • Evolving as the successor to TM1 Perspectives, the legacy add-in for TM1 forms and reports • Productivity tool to streamline report writing tasks Why use CAFE? • Excel is the most widely used reporting tool with estimates of nearly 1 billion users. Many reports will be done in Excel; CAFE can make the task more productive, reliable and accurate. • Leveraging Excel skills can broaden authoring and self-service capabilities within the organization. • Enables IT/BI groups to focus on high priority, high impact projects and delegate some report writing to business users.
• Best of both worlds: Excel ease-of-use, cell-based calculations and formatting, charting, print precision combined with refreshable links to governed, system of record data. Cognos Content As an IBM Cognos licensee, you probably already own IBM Cognos for Office. This means that you can leverage dynamic content developed in Report Studio and Cognos Workspace Advanced inside your PowerPoint, Word and Excel applications, showing trusted data that can be updated with the push of a button! In this eye-opening webinar we teach proven practices for developing reusable report artifacts that can be used in Cognos Workspace dashboards as well as within Microsoft Office applications. In this session, we review fundamental report authoring concepts and showed how to create clean and lightweight report artifacts. With version 10.2.2, is Dynamic Cubes now ready to replace Transformer implementations? In this webinar, the business analytics experts at Senturus take an unbiased look at the pros and cons of switching.
Drawing on our own experience and providing real client anecdotes, we examine: • Types of Transformer implementations that could benefit by switching to Dynamic Cubes • Pre-requisites for replacing a Transformer implementation with Dynamic Cubes • Typical pitfalls you may encounter in the process TECHNOLOGIES COVERED IBM COGNOS BI, Cognos Dynamic Cubes, Cognos Transformer RECOMMENDED AUDIENCE BI Report Authors, BI Report Consumers, BI Power Users (Developers, Support Staff), BI Managers PRESENTER Pedro Ining Senior BI Architect Senturus, Inc. PRESENTATION OUTLINE Cognos Dynamic Cubes: Set to Retire Transformer? • Typical Customer Questions • What are Cognos Dynamic Cubes?
• Is Transformer going away? • Should I replace Transformer with Dynamic Cubes?
• What’s the effort to replace Transformer with Dynamic Cubes? • Will Dynamic Cubes resolve my current Transformer issues? • Can I still use PowerPlay Studio against Dynamic Cubes? For Tableau Beginners Learn fundamental techniques and best practices to turn critical data into meaningful insights in a matter of hours using Tableau. In this webinar, we demonstrate how to use Tableau to take raw data, both from the desktop as well as from a typical enterprise data warehouse, to quickly create engaging, actionable visuals.
Demonstrations highlight the following: • Connecting to various data sources (flat file and database) • Core techniques for visualizing data using the Tableau canvas • Enhancing visualizations with filters, calculations, summaries, and palette selection • Combining visualizations to construct dashboards Learn more about what the Tableau platform and philosophy, and how self-service solutions can complement a traditional, centrally managed BI initiative. PRESENTERS Albert Valdez Vice President of Learning Solutions Senturus, Inc.
Michael Weinhauer Practice Area Director and Solutions Architect Senturus, Inc. PRESENTATION OUTLINE • Making the Case for Data Visualization and Agile, Self-Service Business Analytics: Why It’s Important and How It’s Done • What is Tableau?
• Mission: “Tableau helps people see and understand their data.” • Software for anyone and everyone • Fast access to data, wherever it lives: desktop, database, cloud (liberate data) • Not constrained by IT (empower people) • Easy-to-use user experience (UX) that is designed for optimal visualization from the ground up (design for people) • Why is Data Visualization Such a Big Deal? • When our eyes are open, our vision accounts for two-thirds of the electrical activity of the brain — a full 2 billion of the 3 billion firings per second, and • 50% of our neural tissue is directly or indirectly related to vision (Source: Neuroanatomist R.S. Fixot, 1957) • More of our neurons are dedicated to vision than the other four senses combined, and • Olfactory cortex is losing ground to the visual cortex - about 60 percent of our smell-related genes have been permanently damaged in this neural arbitrage(Source: John Medina, Brain Rules, 2015) • User Experience and Time to Decision • Why is Data Visualization Such a Big Deal? • How do we take raw data and make it visual? • Traditional Business Intelligence (BI) tools provide strong visualization capabilities, why don’t we just use those?
This is always going to be a critical solution, but we have to understand that the world is changing • The variety, volume, and velocity of data are all accelerating • Our time to decision window is shrinking • Agile (or Self-Service) BI complements our traditional BI solution to address this changing requirement • Traditional BI vs. Agile (Self-Service) • The Traditional model is based on highly-governed, centralized data sources and models that are rigid and not designed to be changed in real-time • There always have been, and always will be significant benefits of this model: • Data governance • Crucial business rules and logic are centrally managed, providing a single version of the truth • Enterprise-scale, central administration for security • Strengths in operational (managed) reporting • But what happens when: • You need to analyze data that is not available in the centralized data source? • You need to perform self-service analytics in real-time, without assistance from IT? • Agile BI complements this model with one that delivers information to decision makers much more quickly • Traditional BI vs. Agile (Visual/Interactive) • The Importance of an Analytical Approach • Humans are not good with data • We have dozens of built-in cognitive biases: • The power of Visualization cannot be overstated • Raw data from: • Can be turned into this: • Tips for Tableau Beginners: Demonstration of Dashboard Design with Tableau Desktop. Installing Cognos Learn important tips in order to successfully upgrade to Cognos BI version 10.2.2. During this free webinar, our experts provide attendees with a better overall understanding of the core Cognos architecture, plus discuss common pitfalls and misconceptions.
The traditional data warehouse is under pressure from the growing weight of explosive volumes of data, the expansive variety of data types, and the real-time processing velocity of how data is being used. These changes are so seismic that Gartner reports, “Data warehousing has reached the most significant tipping point since its inception. The biggest, possibly most elaborate data management system in IT is changing.“ This whitepaper provides a discussion of the necessary capabilities needed for DW to evolve to fit modern BI and analytics needs along with a look at the Microsoft modern datawarehouse solution.
Included are case studies, an examination of Hadoop and various deployment options and hybrid scenarios. With technology advances and an increasingly attractive price-performance, in-memory technologies have proliferated from their early days to take center stage on buzzword bingo cards. You may be wondering, what is in-memory, and what can it be used for, particularly for the enterprise? In this webinar, we address these questions and more, as we discuss the origins and history of in-memory technologies with a review of high-level architectures.
We also dive into several primary applications and use cases, including transactional, operational, and analytical, and examine the different ways this technology may benefit the enterprise by providing a competitive advantage. PRESENTER Michael Weinhauer Practice Area Director and Solutions Architect Senturus, Inc. PRESENTATION OUTLINE Current Challenges • Setting the Stage • Can the speed at which your current reports run best be described asglacial?
• Are the number and type of data sources in your organization best being described asexploding? • Current Challenges: Data Explosion • Volume • In 2005, mankind created 150 Exabytes of information. In 2011, 1,200 Exabytes will be created (The Economist) • Velocity • Worldwide digital content will double in 18 months, and every 18 months thereafter (IDC) • Variety • 80% of enterprise data will be unstructured spanning traditional and non traditional sources (Gartner) • Setting the Stage • Is the speed of your business processes best communicated using geologic time? • Do changes and additions to your EDW require superhuman effort? • Are the demands for real-time information in your enterprise skyrocketing?
• Time Value of Information • Varies greatly but time is decreasing and value is potentially unlimited in some cases • Latency occurs between data collection, analysis, and decision points • There are three dimensions of latency on the continuum between when an event occurs and when an informed action is taken: data latency, analysis latency, and decision/action latency • Data latency is the time it takes to collect raw data, prepare it for analysis, and store it where it can be accessed and analyzed. Important functionality here includes data profiling, extraction, validation, cleansing, integration, transformation, delivery, and loading. There are a wide variety of tools and products that address one or more of these aspects of data latency. These tools fall into several categories, including extract, transform, and load (ETL); data replication; enterprise application integration (EAI); enterprise information integration (EII); master data management (MDM); and others. The destination platform of the data is typically a data warehouse or data mart. • Analysis latency is the time it takes to access the data, analyze the data, turn the data into information, apply business/exception rules, and generate alerts if appropriate.
Analysis may be done by a user or an application. • Decision latency is the time it takes to receive an alert, review the analysis, decide what action is required, if any, based on knowledge of the business, and take action. • Setting the Stage • Have you dreamt of brilliant new ideas that would catapult your company light years ahead of the competition, but can’t suggest them because you’ll sound crazy? IBM has recently announced that both Query Studio and Analysis Studio will be deprecated after the Cognos 10.2.2 release.
With this announcement, it is important to plan an eventual migration away from Query and Analysis studio usage, as Cognos Workspace Advanced will serve as the new environment for future ad-hoc queries or analysis type capabilities. This webinar provides an overview of the Cognos Workspace Advanced user interface and capabilities against both relational and dimensional data source.
In addition, we compare and contrast Workspace Advanced against Query and Analysis Studio, including a review of any current functionality gaps. TECHNOLOGIES COVERED IBM COGNOS BI, Cognos Workspace Advanced, Cognos Query Studio, Cognos Analysis Studio RECOMMENDED AUDIENCE BI Report Authors, BI Report Consumers, BI Managers PRESENTER Pedro Ining Senior BI Architect Senturus, Inc. Pedro brings over 20 years of business intelligence experience to his engaging and informative presentations. PRESENTATION OUTLINE Have you migrated from Query Studio and Analysis Studio to Cognos Workspace Advanced?
• We have already migrated • Not yet, but we have a plan in place to migrate • We do not have a migration plan IBM Deprecation of Query Studio & Analysis Studio • 10.2.2 will be the last release to include Analysis & Query Studio • Subsequent releases will NOT INCLUDE Analysis & Query Studio • Query & Analysis Studio will be supported until Oct 2018, you can pay for an additional 3 years of support beyond 2018 • Subsequent Cognos releases will bridge current gaps between Cognos Workspace Advanced and Query/Analysis Studio What about existing QS & AS Reports? Query Studio • Existing Query Studio reports will be able to run from the portal and editable in CWA Analysis Studio • IBM is not intending that users edit existing analysis reports in Cognos Workspace Advanced • Users will be able to run all existing Analysis Studio assets from the portal and create new analyses as required Migration Options Individual Query Studio report migration • Open each QS report in CWA and perform a Save As What if our users have hundreds of QS and AS reports? • Motio is a company that specializes in Cognos Administration tools • Motiowill be adding functionality to its PI product that will allow for batch updates How Cognos Thought It Should Work. Cognos 10 Going Forward Cognos Workspace Advanced Overview • Web-based tool to author reports and perform ad-hoc analysis • Formerly called Business Insight Advanced in 10.0/10.1 • A bridge between the older Cognos 8 Query/Analysis Studios and Report Studio Capabilities • Can be used against either relational or dimensional data source • New to 10.2.1 can be used with external data sources: e.g.
10.2.2 enhances this feature with My Datasets • One place for all reporting (OLAP, Relational) • Presents data as Lists, Crosstabs, or Charts • Integration with Cognos Workspace • Compatibility with Report Studio • Basically a Report Studio light Why Should We Move to Workspace Advanced? Chock full of tip-and-trick demonstrations, this webinar helps boost productivity and makes reports more dynamic. Continuing our Beginning Cognos Report Studio Author webinar series, this session is ideal for users with a grasp of the Cognos platform and report building basics.
Executive managers and analysts are frequently turning to Tableau to get to actionable insights stored in their business intelligence environments. In many companies, Tableau is complementing existing business intelligence tools, such as those from IBM Cognos, SAP Business Objects, Oracle and Microsoft. In this webinar, “Tableau Zen Master” Chuck Hooper highlights the ease of use of this software for interactive data visualization and analysis. We build an actual dashboard, and also demonstrate how this applies across multiple industries, including manufacturing, retail, healthcare, education, and banking.
PRESENTER Chuck Hooper Business Intelligence Consultant Chuck Hooper is the former head of Tableau's consulting organization. He is one of the few individuals officially designated as a “Tableau Zen Master,” and has received this recognition for the past three years, since Tableau first started bestowing this honor.
He conducts training sessions on the use of Tableau Software products and does speaking engagements on visual analytics, data warehouse design, and other business intelligence topics, at both the technical and executive levels. His career includes over five decades of business and IT experience. WEBINAR DEMONSTRATIONS: OUTLINE Ease of Use Demo • Tableau does automatic intelligent analysis of data files brought into the dashboard • Example: Connect to Excel file on desktop and bring data into Tableau • Dimensions are where Tableau categorizes and places things that are used to analyze the data (i.e. The way data is categorized) • Measures are where Tableau puts numeric values associated with the data (i.e. Areas that might require or warrant calculations) • Simply double-click or drag and drop on dimensions and measures to bring into worksheets in dashboard, including the main shelf, side shelf, top shelf options (no need to even touch the keyboard for these purposes) • Change data views including chart type, color coding, values, dates, etc. Exponential growth in data volumes and data velocity is stretching the limits of traditional business intelligence tools and architectures. Furthermore, most organizations are aware of the increasing value of their data, but are having a hard time finding the right (and cost-effective) place to store the dizzying array of new data types.
And amidst all this, business users are growing ever more frustrated at not being able to get at the information they need to run their organizations. Luckily, there are solutions to these challenges. During this presentation, John Peterson gives a brief overview of some of the tools and technologies that are poised to dramatically alter the fabric of business intelligence in the next few years. Particular focus is placed on how and why Hadoop is changing the data warehousing paradigm and the implications on system architectures from a pragmatic point of view. TECHNOLOGIES COVERED Hadoop, Big Data, Data Warehouse PRESENTERS John Peterson.