How To Break Into the Conference Speaking Circuit

If you read my Oracle Open World: A Newbie’s Retrospective post, I’ve hopefully convinced you that conferences are must-attend events. The knowledge-gain and networking opportunities offered across a few days simply can’t be matched elsewhere. To maximize your conference experiences, you should not only attend, but also speak. How does one get started on the conference speaking circuit? […]

Read More

How to get BI with Excel

I know it sounds like I am writing about 1980s technology, and I am, but the fact remains that Excel is still a widely used tool in the business world. Besides, what else would you put your data dumps into? Often Excel reports get used for management reporting, which comes with a number of issues. […]

Read More

Modules of Knowledge

One of the features of Oracle Data Integrator that sets it apart from other data integration tools is the use of Knowledge Modules to define how parts of the data integration process occur. The developer creates a data load mapping from sources, joins, filters and targets (and in ODI 12 even more components are available). […]

Read More

Kicking with JSON in the Snow

Employees at the Minneapolis Red Pill Analytics office recently had the luxury of sitting with Snowflake’s Steve Herskovitz for some on-site education. Among other things, one of my key takeaways from the exercise was how simple it is to query JSON data in the Snowflake Data Warehouse. The syntax is straightforward and makes the process […]

Read More

Preparing Excel Data For Analysis

Whether you are using Excel as a data source for your Business Intelligence (BI) platform, or you are doing the actual analysis within Excel, your data will need to be in a format that is queryable. Often though, the data is formatted to be read visually, whether an export from a system, or manually entered. […]

Read More
Page 10 of 23« First...89101112...20...Last »