Business Intelligence Archives

Webinar Recap: Drillthrough Functionality in Power BI

June 5, 2020 by Daniel Villarreal

Setting up drillthroughs in Power BI is simple and intuitive. What are drillthroughs and how do you configure them? We’ll walk you through the following topics. What can drillthroughs do? How to configure drillthrough pages. New drillthrough functionality. Conditional formatting for dynamic drill through experiences. Cross report drillthough and “The Ideal Reporting App”. Access […]

Power BI Data Modeling Series: Data Modeling Basics, Part 1

June 2, 2020 by Greg Bounds

One of the toughest hurdles for new Power BI users is data modeling. If you’ve never been exposed to data modeling concepts before, terms like entities, facts, dimensions, keys, and relationships may be puzzling. This two-part article is a simplified introduction to data modeling in Power BI. What is data modeling? For our purposes, we’ll […]

Webinar Recap: Next Level Power BI Visuals- Conditional Formatting and Dynamic Titles

May 15, 2020 by Greg Bounds

This webinar focused on how to improve your Power BI visuals with titles that change as you slice your data and visual formatting based on your company’s KPIs and priorities. We enjoyed sharing this fun topic utilizing the great visual options in Power BI. Please see our resource links and code used below. Here […]

Webinar Recap: How to Slice Data with Time Intelligence in Power BI

April 30, 2020 by Christiaan de Nysschen

This webinar discusses and demonstrates IronEdge’s advanced approach to date slicing in Power BI for improved functionality across report pages. With a clever use of the SWITCH statement, XTD slicing becomes a breeze with literally only the click of a button. You can expect to learn how to set up the data model calendar, this […]

Learning Power BI Series: Beginner to Intermediate Resources

April 29, 2020 by Greg Bounds

One of the most frequent questions asked in IronEdge Group’s training courses is how we learned Microsoft Power BI. Our trainers all took different learning paths, but we assembled a list of beginner resources to share. We hope this series can be helpful for folks hoping to learn Power BI skills. Future posts will focus […]

How to Slice Data with Time Intelligence in Power BI

April 23, 2020 by Christiaan de Nysschen

Time Intelligence in Power BI can be a beast sometimes and this use case is no different. When it comes to slicing and dicing your data using dates and other time intelligence measures, there are many approaches, but this method excels at saving page space while producing dynamic results across multiple metrics with a click […]

Webinar Recap: I Can’t Believe It’s Not SQL- An Introduction to Power Query M

April 17, 2020 by Daniel Villarreal

In Power BI, Power Query M is the tool for data transformation and engineering. In this session, we will dive under the covers of Power Query M structure and syntax to provide a foundation for starting your journey to master Power Query M. Below are resources to help you along the way! Power Query M […]

Webinar Recap: Getting the Most from the Key Influencers Visual in Power BI

April 9, 2020 by George Sturrock

The Key Influencers Visual in Power BI leverages statistical methods to provide insights into the factors which drive key business metrics. However, some basic knowledge of the statistical algorithms powering The Key Influencers Visual can be used to produce superior results. In this session, we discuss how to: Setup The Key Influencers Visual Interpret Key […]

Webinar Recap: Date Dimensions in Power BI

April 6, 2020 by Greg Bounds

This webinar discussed how to create a date dimension in Power BI and the best practices for using them. We enjoyed sharing this webinar with our audience and have included a few presentation resources. Guy in a Cube: Power BI date table: create using DAX SQLBI: Using GENERATE and ROW instead of ADDCOLUMNS in DAX […]

Strategies for Implementing Power BI for Small Team Collaboration

January 14, 2020 by Andrew Moore

Microsoft’s Power BI is a powerful tool for leveraging data to help your business succeed. This is not news to those already familiar with Power BI and the importance of business intelligence and automation. However, this tool’s full potential is only unleashed when you get sufficient adoption. The collaborative nature of Power BI makes it […]