|
Data Visualization and Analytics with NGS-IQ and Microsoft Power BI
Microsoft Power BI is a great data visualization and analytics solution, but your operational dashboards and insights are only as good as the data your analysts can draw from your IBM i datbase.
Watch this presentation and learn how NGS-IQ can simplify and automate the cleansing, transformation, and delivery of accurate, timely data to Power BI. 50 minutes. |
 |
NGS-IQ: Modernize IBM i Data Access (Without Programming)
During this presentation, you'll get an overview of NGS-IQ and see how it connects Microsoft Excel, SharePoint, and Web users to Db2 on i. You'll also learn about low-cost licensing options that make NGS-IQ affordable for any IBM i customer. 50 minutes. |
 |
A Better Way to Connect IBM i Data and Microsoft 365 Users
Microsoft 365 is used widely to see, analyze, visualize, and share data. Microsoft's Power Query can enable Excel users to query a variety of data sources, including Db2 on i. But what if your Db2 on i database is too complex and sensitive to simply open up to Excel users and ODBC? We encourage you to watch this video and learn how NGS-IQ enables IBM i shops to satisfy Microsoft Excel, SharePoint, and OneDrive users but centrally manage query security and performance from IBM i. One hour. |
 |
NGS-IQ: The Who, What, When, Where, and Why Tool for Your Data
Hear two IT Managers, one in distribution and one in manufacturing, describe how NGS-IQ enables them to make reports and files available to senior executives and staff members - without programming, modifying their business application software, or paying consultants. You'll also see a very brief demonstration on the product. 30 minutes. |
 |
NGS-IQ + Db2 + IBM i: More Value Than Ever
We hear about big data, data science, and advanced analytics every day, but most of us work for companies where there is still room for improvement in the way we use our real-time, operational data for business advantage. See how NGS-IQ, working with Db2 and IBM i, answers the questions operational managers frequently ask. 50 minutes. |
 |
Accessing Remote Data from IBM i
IBM® Db2® on i is your primary enterprise database, but you may be running customer relationship management, tax compliance, payroll, and other applications in separate LPAR’s, on other platforms, or in the cloud.
You can’t make data-driven decisions with incomplete information. With NGS-IQ's IQ Connexion module or ProData's RDB Connect, you can access, transfer, query, analyze, present, and share data wherever it’s stored—all from the IBM i. In this video, NGS and ProData show you how. 54 minutes. |
 |
IBM Query for i (Query/400) Modernization: Creating and Updating Excel Sheets and Pivot Tables
If you have Query for i (Query/400) queries that return useful data, but not in the format your managers and users need, watch this video. With NGS-IQ, your users can run their old queries – as is – from Windows. In one simple click, they can create and update Microsoft Excel sheets and pivot tables. (NOTE: This is a playback of a session NGS presented at the COMMON PowerUp 2020 conference.) 25 minutes. |
 |
IBM Query for i (Query/400) Modernization: Creating Real-Time, Drillable Web Reports
You probably have Query for i (Query/400) queries that return useful data, but not in the format your managers and users need to visualize and analyze real-time operational data. With NGS-IQ, your users can quickly run these old queries – as is – from their favorite Web browser to generate formatted, graphical Web reports with charts and dynamic drill down links. (NOTE: This is a playback of a session NGS presented at the COMMON PowerUp 2020 conference.) 25 minutes. |
 |
Using Qport Office
Learn about Qport Office, NGS' entry-level reporting tool for Query/400 users. Output to MS Excel, Word, Access, and the Windows display as well as initiate queries to run from desktop icons and the Windows Task Scheduler. Approximately 30 minutes. |
 |
|