Online Examples of Work

Over the last couple of years, I’ve created visualizations using R, Python, Power BI, Tableau and Qlik. Here are a couple of places where I’ve put these examples.

RStudio – as best I can remember, I was thinking about using RPubs to host content 4 years ago. https://rpubs.com/ericfrayer

Published MERA Bar plot to RPubs

Power BI – Using the same dataset only loaded from a parquet format (ADSL Gen2) into Power BI the same visualization can be created.

Data Loaded from Parquet file in Data Lake
Transform Data – Power Query – Data Load of Home Owner Parquet File

With the data has been loaded into Power BI a simple bar chart visualization can be created.

Python – Of course, this same dataset can be loaded into Python as a csv and using Visual Studio Code yet another visualization can be created.

Final version – Bar chart showing relationship between Claims History and Local Weather Conditions

It should be noted, GPT-4 helped with the code and also creating a “statistically significant” relationship in the data with the Local Weather Conditions (either normal or severe) adversely impacting Claims History.

Data Warehouse, Data Lakehouse and Data Mesh

Last year, I read a very interesting blog post by Darwin Schweitzer a Microsoft technologist who discusses how to consider emerging technologies in the context of building sustainable enterprises. The blog posts relates the learning patterns organization adopt to newer data technologies replacing existing capability. The approach covers the strategic, organizational, architectural and technological challenges and changes with scaling enterprise analytics.

Three Horizon Model/Framework – strategic
Data Mesh Sociotechnical Paradigm – organizational
Data Lakehouse Architecture – architectural
Azure Cloud Scale Analytics Platform – technological

Read more by following this link:

https://techcommunity.microsoft.com/t5/data-architecture-blog/bring-vision-to-life-with-three-horizons-data-mesh-data/ba-p/3390414