Power BI Tips and Tricks for Fabrication Content
Written By Carol Dunn
eVolve MEP software for mechanical, electrical, and plumbing with Revit.

Studies have shown that fabrication professionals waste up to 30% of their time looking for, protecting or preparing data. Another 20% of their time can be wasted on building information assets that already exist. That can add up to half of their time chasing down information or repeating efforts that could be done automatically by Power BI.

The components of Power BI are:

  • Power Query – On the back end, this is where information is collected, extracted and transformed. Background code identifies the information you want to use.
  • Power Pivot – After your initial import, this is where you build the data relationships. You can also set refresh schedules with security on your datasets. This feature always runs in the background and updates your information.
  • Power View – The most powerful part of the program, this is where you start to bring in visuals and decide what information you want them to represent. With over 250 visuals, Power View is flexible and gives you the ability to look at your information in a clearer way. It can also function with Microsoft Teams, showing each team their individual workspace.
  • Power BI Service – Publish online so people can view a representation of the data. No one has to have the original data file, and they don’t have to have the desktop version of Power BI.

In his MEP Force class on Power BI (August 31 at 12:40 pm), Tyler Phillips, Estimator at Bruner Corporation, gave a step-by-step overview of Microsoft Power BI, business intelligence software, then he talked about four tips for increasing labor productivity using Power BI with your Fabrication content.

  1. Extract .xlsx or .csv from a dashboard – You can extract a .csv from a table once you have drilled down to an item type. Use this to create new content or modify existing content in the product information editor. In the dashboard, select the ellipsis in the top right corner; select “export data”; save. You can edit .csv and .txt files on the fly.
  2. Download VsCode and these extensions – VsCode editor will open .csv files and with the extension can be edited without the formatting applied. This is a time saver when editing or modifying product information.
  1. Save queries from the advanced editor to paste for later use – Save M language scripts from the advanced editor as power query files.
  1. Design mobile layouts for dashboards – Mobile designer is located in the view tab in Power BI desktop under “Phone Layout.”

Power BI originated as a data analysis add-on in Excel. It is now a separate program that brings your information together, as Phillips described, “like a train station for all of your data.” It can pull information from hundreds of different sources and formats into one dashboard so you can share your Fabrication content in a weekly report or some other form of reporting.

To see Tyler’s demonstration of these tips and tricks using Power BI, go to MEP Force 2020 Virtual agenda. Earlier in the on-demand session, he also goes through the steps for creating a live, interactive and sharable dashboard for efficient Fabrication workflows.

Don’t forget to share this post!

Related Articles

Tips to Improve Safety On Site

Tips to Improve Safety On Site

Safety shouldn’t be something that management talks about, but doesn’t enforce. Jobsite safety should take precedence over every other aspect of your company, and if it is not a priority in your company, it needs to be. Making safety the most important thing not only helps to reduce costs, but it can also improve productivity on site. Because accidents lead to additional costs as well as delays in projects, when you make safety a priority, you lessen the chances of accidents occurring on site, and you save money in the process.

360 Sync Error Blog: Index was out of range

360 Sync Error Blog: Index was out of range

Usually, what happens when you see an “Index was out of range” error, it’s because (1) your root folder was deleted or changed names, (2) there is already a folder or a file name in the destination location & there can’t be 2 files or folders with the same name, (3) the file or folder name contains a restricted character (like < > ^ \ / ), or in some rare cases, (4) a folder was inadvertently uploaded as a file.

How To Build A Best In-Class Fab Shop

How To Build A Best In-Class Fab Shop

There are many advantages to improving your fab shop, one being efficiency. A fab shop should be a structured outlet designed to efficiently organize material and easily send it out to contractors on the field. Having a best in-class fab shop will create a more efficient system that helps your company. Another benefit of having a best in-class fab shop is safety. Because the fab shop is operating in an organized and efficient manner, it won’t be necessary to have as many people working in the shop. And as a result, Bauman explained that, “the less people you have on a jobsite, the safer it is.” To go along with this, improving your fab shop leads to more organization, which allows you to complete the same amount of work with less people and save money in the process.