Earlier this year I commenced Big Data Specialization by the University of California, San Diego, delivered on-line through Coursera. The concepts and application of Big Data is, quite frankly Big! And this area is really growing rapidly, and an area that I need to get up to speed with. While investing my development options in regards to big data, I was skeptical that a short course (3-5 days) would be an appropriate approach, hence the selection of the Big Data Specialization. Rather than cramming all the concepts into a short period of time, it is delivered over a 7 month period, building gradually as it goes.
I commenced the Big Data Specialization in February this year, and to date, I've completed the first two courses.
Course 1: Introduction to Big Data
Course 2: Hadoop Platform and Application Framework
I found the first course to be a little too repetitive and too high level, and wasn't too impressed. The second source started the same too, but once we stated getting into practical application of the concepts, it started to get better. Still not great, but getting better. I haven't yet got the "Ah ha!" moment where I can say this is really useful and I got to try this on our data. I'm really looking forward to the third Course, Introduction to Big Data Analytics. Hopefully this will bring that "Ah ha!" moment I'm looking for.
A little more about the Big Data Specialization
Drive better business decisions with an overview of how big data is organized, analyzed, and interpreted. Apply your insights to real-world problems and questions.
Created by: University of California, San Diego
Duration: 7 months
Structure: 5 Course + Capstone Project
Business Users just love Excel, no matter what great tools are out there (Tableau, Power BI, etc), you just cannot get away from it. Sometimes its because they are used to the Excel workflow and are resisting change, while other times it is because the embedded power of VBA macros allows them to do all sorts of weird and wonderful things to the the data. So Excel is here to stay, no matter what your desires.
A few times I've needed to get data out of a SQL Server database into the Excel Workbook. There are a few ways to do this in Excel, one being using the Get External Data toos on the Data ribbon. This post is going to show you how to do it via an Excel VBA Macro.
Note: The above code uses "Range("B2").CopyFromRecordset rs", which is a super quick and easy way to populate the data within a recordset onto a worksheet. This is a much simpler method than using loops to parse the data in the recordset that many examples online seem to do.
Group Manager -.Data & Insights