Tag Archives: data warehouse

Dear Analyst 132

Dear Analyst #132: How the semantic layer translates your physical data into user-centric business data with Frances O’Rafferty

When you think of your data warehouse, the “semantic layer” may not be the first thing that pops in your mind. Prior to reading Frances O’Rafferty‘s blog post on this topic, I didn’t even know this was a concept that mattered in the data stack. To be honest, the concept is still a bit confusing […]

Dear Analyst #57: Automating weekly reports, working with stakeholders, and data definitions with Nadja Jury of Education Perfect

One of the best feelings is knowing you’ve streamlined and automated a report such that your colleague doesn’t have to spend hours creating the report every week. Whether you automate the report through a bunch of Excel formulas or setting up some sort of data pipeline, analysts are always thinking about driving internal efficiencies. This […]