Our Blog

Read about latest technologies, our team's experience, and thoughts, best practices, and real world solutions, from our frequently updated blog.

Multiple Layers of Aggregations in Power BI; Model Responds Even Faster

Multiple Layers of Aggregations in Power BI; Model Responds Even Faster

Aggregations are speeding up the model. However, the aggregated table is not just one table, It can be multiple layers of aggregations. Aggregation by Date, aggregation by Date and Product, aggregation by Date and Product and Customer. Having multiple layers ensures that you always have the best performance result possible, and you only query the ...

Read More

Power BI Aggregations Step 3: Configure Aggregation Functions and Test Aggregations in Action

Power BI Aggregations Step 3: Configure Aggregation Functions and Test Aggregations in Action

Aggregation can speed up the performance of DirectQuery sourced tables significantly. To use it, firstly you need to create an aggregation table, secondly, you need to set up proper storage modes for tables in the model. Finally, you have to configure the aggregation functions, which is what I’m going to explain in this post. You ...

Read More

Dual Storage Mode; The Most Important Configuration for Aggregations! Step 2 Power BI Aggregations

Dual Storage Mode; The Most Important Configuration for Aggregations! Step 2 Power BI Aggregations

An aggregated table can be a layer on top of the source DirectQuery table. This table needs to have a proper relationship set up with other tables, and also the proper storage mode configuration. Storage Mode configuration of the composite model, in fact, is an important configuration and critical part of setting up the aggregation. ...

Read More

Our Clients Love Us

What our clients say about our service and solutions

  • “Easily the finest quality course I’ve ever attended in my life. Reza  knows PowerBI inside out and it really showed in the extent of topics covered. He was also willing to show me an example on real life data application, and offered further help via email enquiries in the future. Well worth the money and time invested, as PowerBI is definitely the future of Business reporting.”

    Daniel Kastelic – Otago Regional Council
  • I have been using Power BI for around 1 year and I was in love with it the very first day. It was very easy to visualize and bring our data stories to the client’s presentations. During my initial days, I had to use web search or use the Microsoft Power BI forums to find answers to my questions and to explore the tool. On many such occasions, I found Reza’s blog and articles to my rescue. I finally decided to attend the 5 day Power BI : Rookie to Rockstar Course.

    Right from the Day 1 through Day 5, Reza was a professional and a pleasant instructor. He is very approachable and very much flexible even though I was attending the Online Course from United States. The classroom was LIVE from New Zealand. Very thorough in covering all the details mentioned in the curriculum and there was no Question that he could not answer. His expertise and knowledge are second to none. I have learnt a lot with the sessions especially data modeling and DAX functions which I would definitely put to use in the near future at my current job. I would like to thank Reza and his team for the flawless and wonderful sessions. It was very informative.

    Abhi Guruprasad
  • I attended RADACADs “Power BI from Rookie to Rock – Star” course in Auckland from 19-12 Nov 2018. I had a beginner’s knowledge of Power BI, and found the course extremely helpful in understanding what could be done within Power BI. Reza was an excellent instructor, and explained concepts and methods in a clear and concise manner. There were lots of practical examples and exercises provided as part of the course, and Reza was also very helpful and willing to answer any questions we had about improving our existing Power BI reports and dashboards. A very enjoyable course – I highly recommended it.

    Jamie Yim – Senior Business Analyst Enterprise Process
  • Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools

    “I spent probably about two weeks looking for a good Microsoft Power BI class that would cover all of the aspects of the program. I wanted to walk away from the class being able to apply what I learned immediately. Most training companies that I looked into were in a state of flux with Power BI mostly due to the transitions that Power BI itself was going through. Then I stumbled on the RADACAD web site. Reza Rad touted a course that he taught named “Power BI, From Rookie to Rock star.” If the class was indeed an A to Z course, then it was exactly what I was looking for. The class outline seemed to include every topic on my checkoff list plus much more. I decided to give Reza a try.

    Reza completely lived up to his hype. He took us through a natural progression of the software, using example after example of how to complete a task. We went through real world scenarios, a bare minimum of two scenarios for each minor topic. I was completely impressed with his Power BI knowledge, understanding and abilities. Any question we came to Reza with was answered completely and with even more examples.

    After the class, my goal of immediately applying what I learned was attained. Right away I was able to successfully pull and massage data, create useful reports and post them to dashboards.

    I would recommend Radacad Power BI Training without hesitation.”

    Daniel R Tuma, Senior Systems Analyst at Cleveland Metro Schools
  • Dan Cheshire, Senior Project Manager Air New Zealand

    “Reza does not just know Power BI like the back of his hand, he is the most commercially aware BI person I know.  He understands that companies work in the real world and that data isn’t always clean and needs manipulation for it to work and be useful.  When Reza worked on our project, nothing phased or flustered him, he always came up with solutions for problems that seemed to me as insurmountable.  Can’t recommend him enough, invest in Reza as he will not only save you a whole heap of time, but he comes up with long lasting and very powerful Power BI solutions for your business.”

    Dan Cheshire, Senior Project Manager Air New Zealand
  • Sonia Buckley, Data Analyst at Zoom2u

    “We have started to use Microsoft Power BI and whilst Microsoft tutorials are helpful, if you are not used to DAX then it is very difficult to get your head around and there is little other resources that don’t cost an arm and a leg.  I had a call with Reza who made my life so much easier in just under an hour!  Any time spent speaking to Reza will be well worth it – I have saved hours of trying to get my head around our dashboards by getting some very useful tips and explanations on why things are done the DAX way!  Not only that but he is very patient and straight forward.  Highly recommended!”

    Sonia Buckley, Data Analyst at Zoom2u

Don’t hesitate, should you have any inquiries

Contact Us