In this section I will provide an overview of how I go about project management on a daily basis, and how I learnt that it is sometimes a good thing to say No to requests.  I will also touch on development methodologies I've used such as waterfall life-cycle and agile development.  Knowing how to project management, will ensure that you deliver projects on time and meet your customers expectations.

In this section, I review aggregate data. Aggregating data is a means to summarise data, typically in the form of weekly, monthly and quarterly reports. There are many functions, which we can use to summarise our data by, such as Sum, Maximum, Minimum and Mean. In addition I also look at how aggregate data is typically stored in a database or schema.

In this video I describe how to prioritise your requirements using the MoSCoW analogy. I've been using this analogy for many years and customers understand it straight away. Once you've tried it once with your customers, all your requirement priorities fall into place.

In this section I provide a brief history of databases and why databases came about in the first place to address data storage issues.  Today, nearly every company will have their data stored on a database or a datawarehouse, be it social media updates, financial transactions, purchase orders, retail store inventory or genomic sequence data.

In this section I provide an overview of the course I've created on Udemy, Business and Data Analysis with SQL.  I decided to write this course, as I was coming up on 20 years working as an analyst, and wanted to give back to my community some of the insights and techniques I've learnt over the years.  I hope you enjoy the course and please let me know if you have any questions or suggestions for new content you would like to see.

Geoff

In this section, I will talk you though the process of installing and configuring MySQL Server, which we will be using during the course for learning SQL programming. 

 

Links:

Udemy: Business and Data Analysis with SQL

YouTube: WhatData

Web: whatdata.co.uk