Power BI

Power BI is a business analytics software designed by Microsoft. Power BI generates graphics from data stored in various formats such as SQL, Azure, and CSV. Power BI offers competitive advantage over Excel and PowerPoint presentations in that datasets can be updated and modified automatically without extensive knowledge of VBA or other programming languages. 

The viewer experience of Power BI also blows PowerPoint out of the water. Power BI reports are stored in centralized locations where the URL links can be rapidly distributed to stakeholders. Viewers will always be looking at the latest data as it's available, rather than tediously crafted presentations with week-old data. Security and permissions for each presentation can be customized on the Power BI reporting server. 

Switching from Excel and PowerPoint presentations to Power BI cut my weekly reporting time from 2 hours to less than 30 minutes. Dataset operations on thousands of rows and minor updates of Pivot Tables no longer required precise VBA code to function autonomously. The accrued time savings would then be used to further craft business cases stemming from the data.

The following projects demonstrate my knowledge and implementation of Power BI:

Comments

Post a Comment

Popular posts from this blog

Automated ECN Submission - Pseudocode

 Automate redline function(BU_####### string) //Retrieve Redlines open http://elstr.stadlerrail.ch/change#number=BU_####### Navigate page and select attachment.pdf Download attachment.pdf to /workfolder //Fill out Change Management Form using url class <change details> store class."alpha main-title" as string Title store class."cd-assignment" as string Zuordnung store class."cd-type" as string Typ store "Technik" as string Abteilung Open Antrag.docx from /systemfolder Write variables as text Save Antrag.docx as Antrag.pdf in /workfolder //Update Antrag Open AE_Antraege_CalTrain.xlsm Row_count(sheet) as lngRow Select Cell(lngRow+1,1) Fill(Title,Zuordnung,Typ,Abteilung) store lngRow+1 as int lfdno //Combine into single PDF EITHER Open Adobe X Pro function combine pdf For each *.pdf in /workfolder select .pdf ok combine OR Open Antrag.docx insert pagebreak insert object -> attachment.pdf Save product as ...
Read more

Bear Lake Observatory

Image
Objective The purpose of this project was to design and implement an improved system to open and close the USU Bear Lake Observatory (BLO) dome and provide alerts to the user on the status of the dome as well as the weather conditions at the dome. The previous system that was used was functional, but did not have exceptional functionality. The following problems arose during use of the previous observatory dome system: The previous system ran through a mac mini that was connected to a PLC. This means that when the Wi-Fi was down, the dome was inaccessible unless the dome user partially disassembled the dome.  Previously, the dome did not contain any sensors to detect rain or other weather conditions that could damage the telescope. The only way of knowing if it was raining at the dome was by checking the weather conditions and looking at the cameras at the dome. When the bump guard was triggered, power was cut from the dome and could only be reestablished when the bump guard was re...
Read more

Engineering Capacity Planning

Image
1       Introduction Stadler relies primarily on experience and intuition when making capacity decisions. Although this strategy has proved historically successful for the company, there isn’t a concise feedback loop to validate and improve the predictions. It is difficult to communicate expectations across the project phases with regard to predetermined budgets. Managers with limited understanding of the overall workflow are at risk of understaffing their departments at critical phases. This in turn leads to missed payment milestones, and management is pressured to add emergency personnel to make up for lost time. Although coined for a separate industry, Brooks’ Law takes shape, and that is “adding manpower to a late software project makes it later”. Brooks’ Law describes a scenario where total productivity declines due to resources being diverted to onboard potential contributors. Broadly speaking, strained capacity increases the total cost by means of d...
Read more