Webcast Friday: Analyzing Apache Web Traffic in Tableau
I have the honor – and pleasure? – of kicking off our first ever Webcast Friday. I show a couple of ways I use Tableau to analyze web traffic from Apache. The real benefit of using Tableau here is that I can easily spot trends or track issues that may be affecting our hosted sites. This has been an […]
InterWorks Blog Roundup – April 2017
April showers have come, quite loudly and gone. With all that rain we have seen a substantial growth in content. What dominated our blog cycle for April was definitely Tableau. Everything from our Questions from Tableau Training series to our consultants showing us their personal vizzes. Culturally speaking, the annual InterWorks BBQ took place with many […]
Access Data from EXASOL Using ODBC
Unlike JDBC, ODBC is language-independent. ODBC is an open interface that can be used to communicate with databases. All you should do is create an ODBC connection to EXASOL database in your system. For windows, follow these steps to add ODBC creation. Here is an example of using EXASOL data for predictive analysis in R tool. […]
Access Data from EXASOL Using JDBC
Wondering about how to use data from EXASOL in analytical tools? EXASOL integrates with most analytical tools. Below is an example of how to connect to EXASOL from R and create a beautiful cluster plot. In this example, I used JDBC which is an interface used by Java applications to access databases. You are required to install the […]
How Does Tahoe’s 2016-2017 Season Snowfall Compare?
Some of my best memories have been had on the ski slopes! My brother, Matt, and I are unique in loving the kind of terrain most people loathe – moguls. We both love the feeling of hitting our rhythm in and out of densely packed bumps. Although we love to ski moguls, what might be […]
InterWorks Mentors the Next Generation of Analysts at Alteryx for Good
Last week, Alteryx folks from all over the world donated their time in a concerted effort on behalf of Alteryx for Good. I had the pleasure of joining Alex Cordero of Lasso Data Partners and David Allam of Capital One at Maggie L. Walker Governor’s School in Richmond, VA. Introducing Students to Alteryx We presented to […]
Magellan & Me: Circumnavigating the World for Data, Democracy and BBQ
In 1519, Ferdinand Magellan attempted to be the first person to circumnavigate the world. I say attempted because…he didn’t make it. Good old Magellan died in the Philippines before completing his quest, meaning the first person to circumnavigate the world was most likely the surviving crew of his expedition. Where am I going with this? […]
Intro to EXASOL: In-Memory Analytics
EXASOL offers the world’s fastest in-memory analytic database. It is built from scratch to offer the highest performance and scalability for in-memory analytics. You can now build in-memory data analytics in less than 15 minutes. Forget about maintaining and investing on expensive analytical tools used for obtaining actionable insights. Creating R Scripts in EXASOL Many organizations […]
Open Data Viz: NYC Restaurant Grades
My first time to New York City, I noticed something on just about every restaurant I walked by. There was one of these signs displayed at the front window showing off the inspection grade. Obviously, I avoided every one of the C restaurants I came across, but it got me curious. Just how sanitary are […]
Visualizing Math in Tableau: Multiplication Circles
It’s no secret that I’m a math nerd. Or that I’m raising a math nerd. For his birthday, my son Judah got a Curiosity Box that contained a cool looking t-shirt. I spent some time explaining what was going on in this magical circle, but realized it would be easier to make something interactive for […]