Skip to content (Press Enter)
  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Macrordinary

Macrordinary

  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Home>data model

Tag: data model

Updated on January 25, 2020January 2, 2020/ Brent Allen

Power Query – Clean data for the Data Model

Power Query – Clean data for the Data Model

In previous exercises, we used the FILTER() function in order to remove the totals from our data model. Using Power Query, clean data is provided to the data model. Filtering before the data model improves the performance of the model, …

Read More
Updated on January 1, 2020November 11, 2019/ Brent Allen

Quarterly Report – Using the Data Model

Quarterly Report – Using the Data Model

In this post, along prior two posts, I discussed a hypothetical case where data has been provided and your job (as the analyst) will be to create a quarterly report detailing sales of 2018 new vehicles in Canada. This post …

Read More

Recent Posts

  • Non-Unique List in Excel: Showing Only Duplicates
  • BYROW() in Excel: A Marginal Tax Schedule Example
  • Unique Values from 2 Lists in Excel – Multiple Methods
  • LAMBDA() in Excel – Generating an Amortization Schedule
  • LET Function in Excel: A Name Parsing Example

Categories

  • dashboards
  • excel
  • financial formulas
  • formulas
  • M
  • office script
  • pivot tables
  • power apps
  • power bi
  • power pivot
  • power platform
  • power query
  • scripts
  • VBA
Copyright © 2025 Macrordinary. Software Company | Developed By Rara Theme. Powered by WordPress.