Category: Consulting
-
Review: Targus CitySmart Advanced Checkpoint-Friendly Backpack for 15.6-Inch Laptop Bag
I purchased my Targus CitySmart Advanced Checkpoint-Friendly Backpack friendly laptop bag nearly 8 years ago before the hay day of TSA PreCheck but post the nightmare of what airport security has now become. If I had to rate awful lines to wait in, it would now be DMV, Airport, Bank, Boogie club with overpriced drinks.…
-
An Introduction to Consulting Book!
A few years ago, as I reflected on my career, I decided to begin documenting some of my stories and lessons learned to share on a blog. This exercise quickly turned into pages of An Introduction to Consulting Book. After fourteen years in Consulting which landed me on over twenty projects, across several different industries…
-
Setting up tools to work with HDInsights and run Hive Queries – Azure Data Lake Tools and Azure Storage Browser
Two tools that are going to make life a bit simpler if you are going to be working with HDInsights and Azure blog storage are “Azure Data Lake and Stream Analytic Tools for Visual Studio” and Azure Storage Browser. Azure Data Lake and Stream Analytic Tools for Visual Studio To run Hive Queries, you’re going…
-
Big Data for The Rest of Us. Affordable and Modern Business Intelligence Architecture – Adding Lifecycles to your S3 buckets to save cost and retain data forever!
I wanted to keep this post short since as I mentioned in the previous post about cloud storage, our use case is already an affordable one, but it still makes sense to touch on some of the file movement strategy to other tiers of storage to make sure we are maximizing our cost saving vs.…
-
Big Data for The Rest of Us. Affordable and Modern Business Intelligence Architecture – Auto uploading and syncing your data using AWS S3
The first process in any data warehouse project is obtaining the data into a staging environment. In the traditional data warehouse, this required an ETL process to pick up data files from a local folder or FTP, and in some cases, a direct SQL connection to source systems to then load into a dedicated staging…
-
Big Data for The Rest of Us. Affordable and Modern Business Intelligence Architecture – An Introduction using AWS
If you google the use cases for Big Data, you will usually find references to scenarios such as web click analytics, streaming data or even IOT sensor data, but most organizations data needs and data sources never fall into any of these categories. However, that does not mean they are not great candidates for a…
-
The Modern Data warehouse; The low-cost solution using Big Data with HDInsight and PowerShell
Organizations have been reluctant to transition their current business intelligence solutions from the traditional data warehouse infrastructure to big data for many reasons, but there are two reasons that are false barrier to entries, cost and complexity of provisioning environments. In the post below, we will cover how to use PowerShell to commission and decommission…
-
Accelerating the Staging Process for your Data Warehouse
Real Estate Data Warehouse – Accelerating the Staging Process The script below can be used to build a staging environment for any sort of industry and not just real estate related databases. The specifics of a RE Data warehouse will be covered in future blog post. It will allow you to Accelerating the Staging Process for…
-
Creating Embedded Yardi SSRS Reports Tutorial
In previous posts we covered topics such as getting your data out of Yardi using the FTP method and the Log shipping method to facilitate building your own custom reports outside of the tool and being able to combine the data with other operational data sources. The tool comes with a comprehensive set of reports…
-
Automate your Real Estate Software – Yardi ETL and Automation
Interesting in learning how to Automate your Real Estate Software – Yardi ETL and Automation. This blog post will help you drive your CRE business forward. When running your Real Estate business, it helps to not have to think about the small things. This is where process automation can help free up time for your…