Data, Digital & Financial Literacy
If you have ever dealt with decimal numbers with too many decimal places and expose such data in Power BI, you might see them getting automatically formatted in scientific notation. For example, see the below sample data from a csv file: Targets for different teams in a company When you load this data into Power... Continue Reading →
Displaying non-additive measures in Power BI visuals
customized dynamic time matrix in Power BI using DAX
Hiding and locking only those cells/range that have formulas in Microsoft Excel.
Performing multi-criteria lookup in Excel. The combination of VLOOKUP and CHOOSE functions does the magic elegantly.
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.
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. Bringing clarity to chaos.
Few important terms used in the context of self-service analytics and BI tools.
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 →
