Analytics

The past two years have proven that telehealth and virtual care are here to stay and will gain strength going forward for patients, providers, and payers.  With the ability to provide healthcare to a vast array of patients, the next question is “now what?”  How can we improve and customize a better experience for patients, […]

Microsoft’s Power BI is a data and analytics reporting tool that lets you connect to multiple data sources. Once connected to a data source, raw data sets can be converted to dashboards and presented to the team, customer, anyone at any time. In this blog, we will get introduced to the custom function feature available […]

Among the frequent requests when building a Financial Data Warehouse based on Oracle EBS is the desire to drill from a General Ledger period balance through the related Journal Entry lines to the underlying transaction in the source application through the Subledger Accounting linkages.  Complicating this challenge is the fact that some of the EBS […]

Data is the lifeblood of modern businesses, and we’re generating more of it than ever. For making well-informed business decisions, it is crucial to fetch relevant information from the data and present it in a lucid manner. Microsoft’s Power BI suite is designed to quickly turn your data into useful information. Microsoft Power BI is […]

I’ve decided to write some of my own documentation for common use cases of the Excel functions LOOKUP, VLOOKUP, HLOOKUP and XLOOKUP because the official documentation is pretty confusing. It uses “lookup value” as a synonym for “key”, when one would conventionally expect a “lookup value” to be a synonym for “value”! (After all, in […]

Power BI Desktop is a free Analytics and Business Intelligence application you install on your local computer that lets you connect to, transform, and visualize your data. With Power BI Desktop, you can connect to multiple different sources of data. Power BI transforms your  Data into appealing and insightful visuals.  Firstly You can absorb in […]

TD Bank Group recently announced its Q4 2021 earnings were up 31% from Q4 2020, despite the challenges brought on by the COVID-19 pandemic. On its earnings call, the company elaborated that this in part was due to its dedicated, people-oriented approach to business. TD emphasized that this elevated focus on the customer experience has […]

According to Worldwide Big Data and Analytics Spending Guide, organizations will have spent $215.7 billion on big data and business analytics (BDA) solutions in 2021, an increase of 10.1% over 2020. Statista’s data suggests big data market volume is set to top $100 billion over the next five years. Companies are willing to invest their […]

In Tableau Prep, usually, there are two approaches to refresh a data flow namely full refresh and incremental refresh. Refreshing the data set means either the original data would append new rows or alter the data. Full refresh will replace the existing data with new data. However, Incremental Refresh uses only the additional records to […]

New Year, New You… continued! Last week, I asked you to take a moment and think about your Marketo instance. When was the last time you focused purely on data hygiene for marketing automation? It’s a fresh new year, and now is the perfect time to refresh your data! As such, I posted a list […]

New Year, New You! It’s 2022! Take a moment and think about your Marketo instance. When was the last time you focused purely on data hygiene for marketing automation? If you’re like most Marketo Admins, it’s tough to find the time – but you know how important it is. Never fear, I’m not judging you! […]

Background In 21st century era, data is the most valuable and critical asset of any business. To convert this data into knowledge, analytical processes are required to be applied on data. Every level of management requires analysis of data, but its context is different for all. Previously data analytics was primarily done by business ERP […]