I have 17 years of experience in Programming and Data Science working for big tech companies like NVIDIA and Bloomberg. I also run a famous YouTube channel called Codebasics where I pursue my passion for teaching. Codebasics is one of the top channels on YouTube when it comes to data science, machine learning, data structures, etc. I firmly believe that “Anyone can code” and I use analogies, simple explanations, and step-by-step storytelling to explain difficult concepts in such a way that even a high school student can understand them easily.
I’m a mechanical engineer who transitioned to a full time Data & Analytics manager in the UK & Germany by teaching myself Power BI, excel & anything else that was required to solve the problem. I have worked with complex data across Supply Chain, Sales, Marketing, Revenue Management, Finance and HR functions over the last 8 years to deliver effective solutions. To me, Analytics is an extra sensory organ that anyone can develop to become a superhuman at work. I have conducted several workshops and internal training to help non-technical people to become superhuman at work and now, really excited for this opportunity to share all that knowledge with you in this course.
Optimize report size by performing instrumentation through a tool called DAX studio.
Q1. Couldn't we just replace all the calculated columns we created previously, like post_invoice_deductions_amount, with DAX measures? Wouldn't that save even more space?
Yes, it could save space but it has other disadvantages.
- Building DAX measures for this case is a bit more complex than the calculated column.
- DAX measures are executed every time you click or change something on a visual which consumes more memory and can impact report performance.
This is the reason we used a combination of both as discussed in the first lecture of this chapter.