Power BI Archives - JC VanBrunt

Power BI: Analyzing Construction Sales and Opportunities for a Portfolio

Power BI, Power BI Dashboard / JC VanBrunt

The COVID-19 pandemic has certainly made it more challenging for construction companies to plan and adjust to. Since the beginning of the year, construction starts are down 15% compared to the same 7 months from 2019. Looking at construction sectors, the declines were: Total starts down 15% through July compared to last year Nonresidential construction […]

Power BI: Analyzing Construction Sales and Opportunities for a Portfolio Read More »

Power BI: Visualizing A Construction Schedule Report

P6, Power BI, Power BI Dashboard / JC VanBrunt

One thing that many people agree with is that the construction industry needs technology. A messy and often chaotic industry, being organized and data-oriented can pay dividends. From working with owner’s reps, to suppliers and city inspectors, there is a lot of data and tracking all of it can be simple enough. I created an

Power BI: Visualizing A Construction Schedule Report Read More »

Power BI: Exploring PPP Loan Data From The Small Business Administration

Power BI, Power BI Dashboard / JC VanBrunt

CARES Act Signed Into Law March 27, 2020 As a part of the Coronavirus Aid, Relief, and Economic Security Act (CARES Act), the $669 billion loan program known as the Paycheck Protection Program (PPP) was established to help businesses keep jobs. The Small Business Administration (SBA) released loan data about the Paycheck Protection Program on

Power BI: Exploring PPP Loan Data From The Small Business Administration Read More »

Power BI: Measuring Construction Portfolio Health

P6, Power BI, Power BI Dashboard / JC VanBrunt

Construction & Data: A Messy Relationship Construction is a great industry to be in, but it’s also extremely messy in terms of data collection. Getting status updates, tracking deliveries, time-phased costs that tie to a schedule – these are just some of the metrics that are tracked for each project. Tracking these metrics at the

Power BI: Measuring Construction Portfolio Health Read More »

Power BI: Looking at COVID-19 Through American Politics

Power BI, Power BI Dashboard / JC VanBrunt

I wanted to take a look at COVID-19 data because of the increased coverage in the media over the past month. Many states began reopening (restaurants, bars, retail) around the middle of May. Below is trend data for “COVID” that shows an increasing trend in searches starting around the first and second weeks of June.

Power BI: Looking at COVID-19 Through American Politics Read More »

Power BI: Project Schedule Gantt Chart Dashboard

P6, Power BI, Power BI Dashboard / JC VanBrunt

Check out the original blog post that has all of the steps used to create the dashboard. >>> Click here to view dashboard in a new tab <<<

Power BI: Project Schedule Gantt Chart Dashboard Read More »

10 Tips Starting Out in Power BI

Power BI / JC VanBrunt

How I started using Power BI at work Starting out in Power BI can be difficult – I remember it took me a few weeks to really dive into it and learn some of the basics. I was getting pretty good with Excel and kept running into problems with Pivot Tables. I knew there had

10 Tips Starting Out in Power BI Read More »

How to Make a Gantt Chart in Power BI using P6 Schedule Data

P6, Power BI / JC VanBrunt

What is the most common way of looking at a construction schedule? For most, it usually involves going into P6 and adjusting groupings and applying filters (sometimes very lengthy and complex filters that become hard to follow). Once the set of activities are selected, a single view (layout) is generated and the schedule is printed

How to Make a Gantt Chart in Power BI using P6 Schedule Data Read More »