Power Pivot – Time Intelligence and Financial Year

Watch the video demonstration of how to create Power Pivot model that helps you create report not just on calendar month and year but also on financial month and year. Introducing Date Table (Date Dimension) In BI technology it is a common practice to have a separate role playing...

Create a Date Table in Oracle

Occasionally you may be working with non Microsoft data sources such as Oracle over front end tools like Power Pivot or Reporting Services. Some options for a date table include creating a linked table in Power Pivot or generating a table in the data source. Generate a date table...
Send