View Post

How to integrate Power BI reports to your website or SharePoint site

In Business Intelligence, Power BI, SharePoint, SharePoint On Premises, SharePoint Online by Bryant Avey0 Comments

The data in the report was integrated using the internuntius inCollatio™ business analytics architecture. The information is a combination of US Census data and NFL team data.  The data was combined based on the city where each NFL team is located. All the Power BI chart elements are linked together, so clicking on any element will dynamically filter the information displaying on the other related elements in the report.  Give it a try. Click on a city from the map and all the data in the other charts is filtered to represent the data and percent of total for that …

View Post

How to convert JD Edwards EnterpriseOne (JDE) Julian Dates

In Custom Development, Enterprise Systems, JD Edwards by Bryant Avey0 Comments

If you’ve ever worked with Oracle/PeopleSoft’s EnterpriseOne ERP system (also known as JD Edwards or simply JDE) you’ll quickly find that dealing with dates from the database is a bit challenging.  EnterpriseOne stores all dates in the system in Julian Date format.  EnterpriseOne has a lot of dates in every table. The Julian Date in EnterpriseOne goes back to the days before EnterpriseOne was called EnterpriseOne; back when it was just JD Edwards and it ran on an AS/400 (now called an iSeries or Series i).  Back then, disk space (DASD) was a premium.  By storing all the dates in …

View Post

How to access the JDE Data Dictionary in SQL

In Custom Development, Data Architecture, Enterprise Architecture, Enterprise Systems, JD Edwards by Bryant Avey0 Comments

The JD Edwards EnterpriseOne database layer has been abstracted, by design, from the business and application layers.  The impact of how JDE has chosen to implement this data abstraction is that the database does not contain any table or field name aliases with meaningful, English descriptions.  When applications developers and software developers are interfacing with the JD Edwards EnterpriseOne ERP system, there is often a need to have access to the Table File Definitions and Field Descriptions contained in the JDE Data Dictionary.  Without access to the table descriptions and the field descriptions, developers are not able to easily navigate …

View Post

The Death of Traditional Reporting – Stratalytica™

In Analytics Age, Stratalytica™ by Stratalytigist0 Comments

In the midst of a data revolution, it’s easy to get caught up in discussions on the size of data, or the structure of data, or data as a tangible asset.  Such discussions are important, but they can cause us to lose sight of the fact that, while data is indeed an asset, most organizations don’t experience their data in that manner. Most companies experience data as a process that they call reporting. While few would argue against the value of reporting, it’s safe to say that of all the technological disruptions present in the Analytics Age, the transformation of …

View Post

Netflixed: 3 Analytics Age Principles That Could Save Your Business – Stratalytica™

In Analytics Age, Stratalytica™ by Stratalytigist0 Comments

When Netflix set up shop in 1997, with 8 employees and a $2.7 million investment from entrepreneur Reed Hastings – who would later become the CEO – the small company faced daunting odds in an extremely competitive and fragmented marketplace. Blockbuster was the undisputed leader in the movie rental market with approximately 20 million active users. At the height of the company’s popularity in 1989, a new Blockbuster opened every 17 hours.  No one, possibly not even Netflix, believed that the Scotts Valley, California company would do much more than provide an alternative business model to the Blockbuster brand.  No …

View Post

The 5 Imperatives of the Analytics Age Executive – Stratalytica™

In Analytics Age, Stratalytica™ by Stratalytigist0 Comments

In any organizational transformation, the first step is to establish a global set of values. In the Analytics Age, there are 5 key imperatives that will help you set values for your insight-driven initiatives.Imperative 1In the Analytics Age, data is no longer passive. It becomes a highly valuable asset. Broadened beyond the confines of the reporting realm, data serves multiple functions on multiple levels and throughout the organization, from HR to marketing. In the Analytics Age, data is no longer passive. It becomes a highly valuable asset. Broadened beyond the confines of the reporting realm, data serves multiple functions on …

View Post

A World Transformed – Stratalytica™

In Analytics Age, Stratalytica™ by Stratalytigist0 Comments

In the first issue of Stratalytica, we noted that, in 2012, 2.5 quintillion bytes of data were created every single day. Viawest, a privately held data storage company, puts this number into perspective.  Numerically, 2.5 quintillion bytes of data looks like this 1,000,000,000,000,000.000, or (2.5 x 1018).  As a visual equivalent, imagine 57 billion iPads stacked atop each other (each with 32 GB storage space). These “bytes” are big data numbers Big data numbers will continue to grow as data-enabled devices become ubiquitous, collecting data on everything and everyone. The October 2013 Harvard Review article, Big Data: The Management Revolution, …

View Post

The Visible Executive – Stratalytica™

In Analytics Age, Stratalytica™ by Stratalytigist0 Comments

We’ve all heard the shocking statistic—Last year, 2.5 quintillion bytes of data were created . . . every.  single. day. That’s more than a lot of data. It’s a tsunami of data. This rise in data was not a result of a sudden miraculous ability to create electronic information; instead, it is a result of technology that allows for improved methods of the recording of data. Of course, this means that the tsunami is only just beginning.  The vast amounts of data will only grow.  We at Internuntius would like to welcome you to a genuine, can’t-run-can’t-hide business revolution.  You …