Analytics

In this blog, I would like to show a SQL example to show the right usage of an aggregate function Have you ever observed the difference in the count of the records when you apply different column conditions? Let us see sample data in a SQL table and understand this. …

Before jumping data first into solving a problem, are you spending enough time in asking the right questions first? A fact is a simple statement that everyone believes. It is innocent, unless found guilty. A hypothesis is a novel suggestion that no one wants to believe. …

Budgeting Made Simple: Save, Simplify, Succeed! Introduction Money in, money out. We have different bank accounts and financial products (such as debit/credit cards) across many banks. Without a consolidated view of all of our transactions, we are unable to gain a holistic view of our spending, much less being able to…

Countries whose populations don’t look anything like the average — Demography is the study of human populations and their characteristics. Age distribution graphs are a common visualization for better understanding a country's population. Today, I’m ranking them by strangeness. The data comes from the World Development Indicators dataset, which you can find on the Worlds Bank website. For reference, here’s…

I had an experience to extract, transform and load big data. I wanted to sync DynamoDB data daily with S3. Then use Athena to query from S3. …

It is always a good idea to learn new in the data landscape — Data is THE word of the decade and organizations are agile to translate data for the business and invest in “data-driven decision making”. With the insights data has to offer, organizations are constantly looking to leverage whatever makes the business grow. At every step, the business wants to trust professionals…

Uncover. Analyze. Succeed ABusiness Analyst is a professional who helps organizations improve their operations and achieve their goals by analyzing their processes, identifying areas for improvement, and recommending solutions. They gather and analyze data, conduct research, and collaborate with stakeholders to understand business needs and requirements. Based on…

Posted by Vladimir Kamchatkin I’m an inDrive product analyst. If you looked at my computer, you’d see over twenty conversations currently open with ChatGPT, where I chat with the AI about work and life. …

MicroStrategy ONE — Update 10 The AI features you saw in MicroStrategy Futures got out of the group chat. What’s hot this summer? Here’s the top 5 product features just released: Leverage the AI chatbot for self-service insights in Library Web [Preview Feature] Say goodbye to complex queries and hello…