The Department of Communities WA

Power BI Developer and SQL Programmer including Staff Development

(Technology Used: Power BI, Power BI Report Builder, SQL Azure Database, SSMS, Azure, SharePoint, Xml)

Charged Wtih:

Power BI development

• Engaged with stakeholders to gather information and define reporting requirements

• Developed required data models from SQL Azure Enterprise Data Warehouse

• Developed, tested and deployed Power BI and Paginated reports

Development of automatic messaging from SQL Azure Database

• communicated with stakeholders to devise the best approach

• Proposed the approach and designed the architecture

• SQL programming and Xml configuration

SQL Azure Database and SharePoint Online Interface

• Engaged with stakeholders to gather requirements  

• Devised a list of viable options for two-way communication between the two