Analytics

Many companies are faced with a problem – how to see the data that is most relevant to their business to gather insights. A recent client needed a way to see and show leadership relevant, high-level data that was most important to the business. Enter analytics dashboards! These dashboards, as defined by Google, are “a […]

As times have evolved, so have our data challenges — but we have been trying to solve it for ages. Giving it dedicated resources, robust hardware, etc. we still end up missing SLAs in our traditional On-Premise & Cloud-hosted worlds. Add to the fact the constant dependency on personnel to manage the data loads, data […]

In Cognos Analytics, the visualizations possible through Charts and graphs are quite intuitive. It offers various insights into the data that you have. Through this blog, a select category of Bar-chart and the construction behind it is highlighted. Typically, Bar-charts, as the name suggests, plots Rectangular bars on the Y-axis of varying height for each […]

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 […]

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 […]

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 […]

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 […]

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. […]

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 […]

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 […]

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 […]

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 […]