Tag: Data Literacy
-
Types of data in analytics
Most analytics learnings start with understanding the types of data. This article gives a holistic view on types of data in self-service BI reporting, analytics, and citizen data science while also embracing the new data types resulted with the advent of big data technologies.
-
Data Vs Data Points Vs Metrics Vs KPIs
Data Vs Data Points Vs Metrics Vs KPIs. Bringing clarity to chaos.
-
Data Connection, Data Source, Data Set, blah blah blah in the context of Self-Service Analytics & BI – Bringing clarity to chaos.
Few important terms used in the context of self-service analytics and BI tools.
-
Why is SQL one of the most powerful tools in the arsenal of an Analyst?
Out of information analysis, comes wisdom. It’s this information analysis that is one of the important reasons that created the need for storage of data. The world of databases was sprouted to address this need of data storage and many languages were born to interact and deal with the data…
-
A magical Excel trick for flattening data copied from a PivotTable report in tabular layout into usable format
Here is a scenario that I come across sometime ago when I received an Excel file with some apparently messy data for further processing to generate another report. The data in the file appear similar to below screenshot. This data is self-explanatory. It’s the sales in units and dollars of…
-
Generating Date Dimension data in Microsoft Excel
Generating data for populating Date Dimension table using familiar Microsoft Excel
-
A White Paper – Solving Relational Division problem in SQL – The Analyst Way
Hi readers..!! Here I go posting a white paper on one of the classical and intellectually challenging problems that an analyst might come across. The paper is titled – “Understanding and Solving Relational Division problems in SQL – The Analyst way”. Hope you enjoy reading this paper. Please leave your comments…