In typical Migration Projects, data housed in Database Server A (provided by Vendor A) is extracted, transformed, and loaded into Database Server B (produced by Vendor B). Each of these servers offers a wide array of functions to query data. Though the function names and syntaxes may vary, all the DB servers in the market […]
Analytics
Using Cloud to Solve Healthcare Pain Points
This is the second post in a series on Google healthcare capabilities. To read the first post, click here. With the healthcare industry having to quickly jump on the cloud bandwagon with telehealth recently, it is becoming apparent that a new norm is (in my millennial opinion, finally) emerging. This begs the question – how […]
Take advantage of windows in your Spark data science pipeline
Windows can perform calculations across a certain time frame around the current record in your Spark data science pipeline. Windows are SQL functions that allow you to access data before and after the current record to perform calculations. They can be broken down into ranking and analytic functions and, like aggregate functions. Spark provides the […]
Rising Above at the Microsoft 365 Virtual Conference Marathon
Our worldwide pandemic has hit everyone differently. Even within the same circles, people are handling and responding to these changes in different ways. I have found such strength and inspiration from the IT industry and our clients. Everyone has approached this challenge head-on. My professional community has provided such a grounding force by facing this […]
Scale your data science practice formally
Frequently, the “crawl, walk, run, fly” metaphor is used when describing the path to implementing a scalable data science practice. There are a lot of problems with this concept, not the least of which is the fact there is already motion involved. People are already doing BI work, often complex work enabling high value results. […]
Tune the dials to optimize your Spark machine learning pipeline
Tuning Spark for your machine learning pipeline can be a complex and time consuming process. Store and compute play a different role for your Spark cluster in different stages of your machine learning pipeline. Spark defaults are never the right way to go. It makes more sense to know what settings are most effective at […]
Daily Sales Tracking for Financial Analytics
Financial analysts are often looking for a daily tracker of their organization’s sales. Daily sales tracking requires bench-marking against budgets and forecasts. However, it is often the case that plans are defined at a higher level compared to actuals. In addition, while actuals are available from ERP, plans are maintained in a separate application for […]
Become an Adobe Digital Marketing Expert this April
In my previous post, Locked Down? Learn AEM in April, I talked about how PluralSight’s #FreeApril program gives you access to great training on Adobe Experience Manager. For those of us also working with more than Content Management, #FreeApril provides some great training for you too! PluralSight has great courses on Adobe Analytics and Target […]
Stop Guessing, Get Insights Now to Drive Better Decisions, No Budget Required
With the world in chaos, you need to do what you can to navigate the rough economic seas. You may have 0 servers, 0 BI staff, 0 dedicated resources available to spin up a BI solution. Worst of all you have a $0 budget. So what can you do in 45 days to help your […]
Agile BI & Analytics is the Need of the Hour – Drive insights during Pandemic Uncertainty
In uncertain times like these its essential that we consider the disruption that is happening and take a nimble approach to help Organizations including my own by driving analytics and insights across the various Lines of Business. How can we take all the Public data that is available from John Hopkins, CDC, WHO and various […]
My Themes and Recommended Sessions for Adobe Summit 2020
Monday evening I was notified by Outlook that it was time for Perficient’s annual pre-Summit dinner, the first time I’ve not been to Las Vegas in March since Summit moved from Salt Lake City. While I am glad that Adobe has taken measures for the safety of our community, colleagues and family, I will miss […]
Combining Online & Offline Data in Automotive – Part Three
In the past two posts I explored the topic of automotive companies merging online and offline data to build better customer profiles and better understand their consumer base. In the first post, I discussed the data landscape in automotive and the overall need to combine online and offline data. In the second post, I focused […]