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.
Blog
Displaying hyperlinked data in table or matrix visual in Microsoft Power BI
Step by step instructions to hyperlink field values in table or matrix visual Microsoft Power BI Desktop.
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 sake of brevity, let's say... Continue Reading →
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 stored in these databases. But... Continue Reading →
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 recorder functionality Automation scripting: Mimicking... Continue Reading →
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 useful. Feel free to share... Continue Reading →
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: For example, say, you have... Continue Reading →
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: let Source= [ PowerBIBDay = #date(2014, 7, 16), Today = Date.From(DateTime.LocalNow()), BirthdayFactor = if Date.DayOfYear(PowerBIBDay)<Date.DayOfYear(Today) then 0 else 1, DayFactor... Continue Reading →