Category: Data Literacy
-
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.
-
Calculating product of values in a column in SQL and its business usecase
SQL supports most aggregate functions except one fundamental aggregation to calculate product of values in a column. If you are wondering what could be a scenario where you may have to calculate product of values in a column, here is a business scenario that demands it. Business Scenario: For the…
-
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…
-
Office Scripts: Is it the beginnings of the end of VBA era?
It has been quite some time now a lot of talk around the future of VBA. Here comes the Office Scripts in Microsoft Office web apps like Excel (in its preview) with two important features to seed the beginnings of the end of VBA era: Actions recorder: Mimicking VBA macro…
-
Infographic of Table Merge or Join Operations
Most data analyses start with organizing the data, at least starting with organizing in tabular format. This implies tables are the most fundamental formats to deal when analysing data. Here I crafted an infographic showing the most commonly performed merge or join operations among tables. Hope you will find this…
-
Cascading or dependent drop-down lists using Data Validation tool in Excel
If you are thinking of bringing interactivity to the reports in Excel, you may have come across the need for having a simple drop-down list or a more complex cascading drop-down list (i.e., a drop-down list whose values are dependent on the value already selected in another drop-down). Example Scenario:…
-
Calculating Age (duration or difference between two dates) in years, months and days in Power Query M Script
16-Jul turns out to be the birthday of Microsoft Power BI. Here I post a formula in M Script to calculate the age (i.e., duration or difference between two dates) in years, months and days: As on today, the output of the above formula is: I am now on 5…
-
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…
-
Flash Fill Trick in Excel 2016
Here is a very common exercise that you might have or may come across – You have full names of employees in a column and you are expected to extract last names from these full names into a separate column. In versions prior to Excel 2013, you need to use…