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.
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.
Oracle SQL script to generate Date Dimension data for use in Microsoft Excel Data Models
Date dimension is that one dimension or business perspective without which an Excel Data Model cannot ever exist. Here is an Oracle SQL script to generate the data for a Date Dimension. All that you have to do is change the start date and end date values in the in the last line of the... Continue Reading →