A sandbox website using Lightsail and AWS
In late 2018-2019, I worked on a Credit Scoring model. As part of the work I wrote a “whitepaper” outlining the process, methodology and results.
A copy of the whitepaper is available for download: https://www.ericfrayer.com/wp-content/uploads/2019/10/Credit_Scoring_Whitepaper_v1.pdf
As part of the project I used R and SPSS for model construction and verification. The output from the model is available here:
https://www.thinkdataanalysis.com/DataAnalysis_R.html
In 2012, I picked up a copy of Teo Lachev’s “Applied Analysis Services.” The book featured how Microsoft was pulling together Excel, Power View, Power Pivot, Tabular Modeling and the new DAX Language (Data Analysis eXpressions). The traditional OLAP SSAS MDX cube wasn’t going away but the new hardware options and increased need for self service meant a new technology was required. DAX uses standard Excel formula syntax. This provided business users with a way to extended Excel logic, formulas and calculations. The power of Excel with the promise of self service BI is pretty compelling.
During my time at Qlik (2012-2017), Microsoft continued to build and expand it’s products. With the Tabular model , Microsoft adopted a “columnstore indexing” strategy using Vertipaq. This allowed for much more data to be available on disk and in-memory.
For more info visit: https://docs.microsoft.com/en-us/analysis-services/
Recently I read a very interesting article on how the “digital world” allows for much more experimentation than previously available. Online marketing and research has changed the discipline. The authors of the article explore some of the “subtleties” of designing experiments and provide guideline.
A copy of the article is available below:
https://www.ericfrayer.com/wp-content/uploads/2019/10/SSRN-id2630209.pdf
This is just a quick post to share I’m using this site mainly as a “technical sandbox”. Someplace to try out different functionality and post working examples. I’m using Google Analytics in a browser and app on my phone to see if I’m getting any traffic. Most of my “users” are friends, colleagues and potential employers who’ve I’ve given the url.
Anyway here is a page from Google Analytics for my site. I guess it shouldn’t be surprising how much Google provides for developers and internet users.
It’s amazing how many free or low cost learning solutions exist online. Currently, I’m using DataCamp, Udemy, and Code Academy. I’m also following specific experts including Nathan Yau, Hadley Wickham and Graham Williams.
This graphic breaks down the a number of key terms and concepts often used interchangeably.
Thanks for stopping by EricFrayer.com. Over the years, I’ve used wiki’s, blogs and other content sharing tools to post thoughts, tips and reference materials. Most of this was internal to the companies I’ve worked for. Either on “SharePoint Intranets” or “Confluence” pages or other web based knowledge management or content sharing sites.
At this point, it makes sense to post “samples of work” to build out my professional online resume. I’m using AWS and Azure to host this content. My interest is in finding insights and making data actionable. Not just buzzwords but actually demonstrating how all the pieces come together to give the end-user meaningful analytics.
I’ve been thinking about this for 10 plus years. Now it’s time to share!
For a number of years I thought Business Intelligence needed people who could “span” both technologies and business understanding. The most valuable BI professionally have both technical knowledge and domain data understanding.
I setup this Sandbox in May 2018. I was researching how much effort is needed to use AWS Lightsale vs WordPress hosted sites.