Displaying non-additive measures in Power BI visuals
Displaying non-additive measures in Power BI visuals
Blog
Customized dynamic time matrix visual in Power BI
customized dynamic time matrix in Power BI using DAX
Share this:
Hiding and Locking only cells with formulas in Excel
Hiding and locking only those cells/range that have formulas in Microsoft Excel.
Share this:
A smarter multi criteria VLOOKUP in Excel
Performing multi-criteria lookup in Excel. The combination of VLOOKUP and CHOOSE functions does the magic elegantly.
Share this:
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.
Share this:
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.
Share this:
Data Vs Data Points Vs Metrics Vs KPIs
Data Vs Data Points Vs Metrics Vs KPIs. Bringing clarity to chaos.
Share this:
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.
Share this:
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 →
Share this:
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 →
