As you may have seen in the Twittersphere, today is a special date in the Oracle community, a day where we can express thanks to OTN for wealth of technical content that makes our life easier.For my tiny contribution to the day here is a little note on detecting change using SQL MINUS, maybe not […]
OTN Appreciation Day: Looking for Change Read More »
General, Oracle Technology Network, SQLWell… it looks like Oracle ACE Director and former colleague Michael Rainey beat me to the topic. But as I read his story… I realized I could approach this in a slightly different way, so I decided to press on with my own take on ODI 12c Flexibility for Oracle Technology Network (OTN) Appreciation Day.
OTN Appreciation Day: Oracle Data Integrator 12c Flexibility Read More »
Big Data, Data Integration, Oracle 12c, Oracle Technology NetworkI’ll address the title of this right at the top, in short, it depends. The long answer, which I will discuss as I go through this article, is it depends on how you intend to use it. If you are a small company or team with fairly simple data needs, and you are using it
Should You Have Domo FOMO? Read More »
Data Visualization, ExcelIf 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?
How To Break Into the Conference Speaking Circuit Read More »
Events, TipsI 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.
How to get BI with Excel Read More »
Analytics, BICS, Business Intelligence, Cloud, Coding, Data Visualization, Excel, Oracle, Tips, VBAOne 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).
Modules of Knowledge Read More »
Big Data, ODI, SnowflakeEmployees 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
Kicking with JSON in the Snow Read More »
OBIEE, Snowflake, SQLWhether 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.
Preparing Excel Data For Analysis Read More »
Big Data, Business Intelligence, Excel, Red Pill Analytics Tips, Tips, VBAFull Disclosure: I’ll be the first to tell you I’m not a DBA. I have a working knowledge of databases and “mainstream” SQL statements. I’m usually content to stay in my area of expertise and just query the data, make sure that the data is correct, and build some great content for clients. If you
BI Developer + Snowflake Root Access: A Love Story Read More »
Customer Service, Databases, Snowflake, SQLThis past week, I had the honor of not only attending, but speaking at Oracle Open World 2016. After a decade of working with Oracle technologies in the data integration, BI & analytics, and big data domains, attending and speaking at this event marked a much-anticipated career milestone on my end. With >60,000 attendees and
Oracle Open World: A Newbie’s Retrospective Read More »
Events