[vc_row][vc_column][vc_column_text] In this series I have been exploring various cloud Buisness Intelligence product offerings from companies like Domo and Tableau. Now it is time to review Oracle’s newish offering Business Intelligence Cloud Service (BICS). First of all, if you are going to combine data sources for your analysis, versus having, say, a single spreadsheet to load, the […]
Is Oracle BICS For You? Read More »
BICS, Cloud, Oracle, SQLAs a business professional with little prior technical experience who moved over to the technical side of an Oracle-centric organization, the Oracle Technology Network (OTN) was an invaluable resource for me to quickly make the transition from newbie to full fledged Oracle developer. Thanks to OTN resources like product documentation, technical articles, discussion forums, tutorials,
OTN Appreciation Day: A Journey From Newbie to Veteran Read More »
General, Oracle Technology NetworkAs 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, VBA