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. […]
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 »
EventsIn my last post, I discussed Snowflake’s unique cloud offering, and how to get it connected to OBIEE. In this post, I’ll give a brief overview of what Snowflake’s Time Travel feature is, how to use it from a query perspective, and how to integrate this feature into OBIEE. [pexyoutube pex_attr_src=”https://www.youtube.com/watch?v=fCjsUxbNmIs”][/pexyoutube]Where We’re Going… We Don’t Need
Back to the Future: Time Traveling with Snowflake Read More »
OBIEE, Snowflake
If you’ve followed me for any length of time, you know I’m a fan of the Groovy language. It’s unfettered support for closures has made it a popular choice for writing domain-specific language (DSL) projects such as Gradle and Jenkins, and the healthy dose of syntactic sugar spooned in at runtime means that developers spend less time boiler-plating and more
Groovy, Web Services and OBIEE 12c Read More »
OBIEE, Oracle 12cThis is a topic that I was teaching about last night in my Digital Analytics class at the University of Utah and instead of only sharing what I found with my students, I thought I’d share here in the blogosphere. What I’ve found was yes it’s easy to pull Twitter posts into R for analysis!
Accessing & Analyzing Twitter Posts with R Read More »
Code, Data Science, R, TwitterIf you’re reading this post, you’ve probably seen my other post on connecting OBIEE to Amazon Web Services’ Redshift database offering. If not, thanks for joining in for this part of the adventure. To summarize the last post, cloud applications are becoming increasingly more common, and because of this fact, more of the data that is produced
Forecast: Partly Cloudy (Part 2) Read More »
OBIEE