General
The definitive list of data analytics tools
- Website
- 20 Jun 2019
- Springboard
A list of useful software to use in data analytics, from initial data collection and mining to programming languages like R and Python.
Power BI
Curbal
- Website
- 21 Nov 2019
- YouTube
A channel of weekly instruction videos on Microsoft Power Query, Power BI and DAX (Data Analysis Expressions) - the formula language used throughout Power BI.
Guy in a cube
- Website
- 21 Nov 2019
- YouTube
YouTube channel with weekly technical videos on on the Microsoft Business Intelligence stack (including Power BI, Reporting Services and Analysis Services).
Learn Power BI
- Website
- 04 Nov 2019
- Microsoft
Official Microsoft Power Bi site with guided learning, samples, documentation and blogs.
Microsoft Power BI YouTube channel
- Website
- 21 Nov 2019
- YouTube
Official Microsoft Power BI channel including regular BI updates and instructional videos. Includes playlists such as 'Getting started with power BI' and 'Analyze & visualize data with Power BI'.
Power BI how to videos
- Website
- 21 Nov 2019
- YouTube
Play list of instructional videos for using Microsoft Power BI.
Python
Beginners guide to Python
- Website
- 26 Sep 2019
- Python Software Foundation
Official information on how to get started with Python, with links to tutorials.
Introduction to Python for Econometrics, Statistics and Numerical Analysis
- Website
- 03 Jan 2017
- Kevin Sheppard
An eBook introductory guide to the Python programming language, which is suited to econometrics, data analysis and other more general numeric problems. It is aimed at beginner programmers, but is a useful reference for all levels.
Python
- Website
- 10 Oct 2019
- Python Software Foundation
Official Python programming language website which includes tutorials and guides.
Python Data Analysis Library
- Website
- 10 Oct 2019
- pandas
PANDAS is an open source library providing high-performance, easy-to-use data structures and data analysis tools for the Python programming language.
Python programming
- Website
- 10 Oct 2019
- PythonProgramming
Tutorials including videos on introductory and intermediate Python programming and data analysis using Python.
Python v R for data science
- Website
- 31 Jan 2018
- Data-Driven Science
Overview and comparison of the benefits of R and Python - two popular programming tools for data science work.
Step by step approach to performing data analysis using Python
- Website
- 08 Mar 2018
- Crayon Data
This article answers some of the common questions a beginner has while getting started with Python for data centric applications.
R
Rstudio resources
- Website
- 10 Oct 2019
- RStudio
RStudio is an integrated development environment (IDE) for R, a programming language for statistical computing and graphics. Resources include tutorials and videos.
SQL
Business intelligence analyst
- Website
- 21 Oct 2019
This course comprises several modules: introduction to data and data science; statistics and Excel; database theory; SQL; Tableau; SQL + Tableau.
Complete SQL bootcamp
- Website
- 18 Oct 2019
You will learn how to read and write complex queries to a database using one of the most in-demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle and much more.
Introduction to Structured Query Language (SQL)
- Website
- 09 Oct 2019
In this course, you will walk through steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql database. You will learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys and the JOIN operation. Lastly, you will learn to model many-to-many relationships like those needed to represent users, roles and courses.
Learn: SQL
- Website
- 17 Oct 2019
Acquire new skills fast in courses that combine short expert videos with immediate hands-on-keyboard exercises. A collection of 21 SQL courses, from an introduction, to analysing business data in SQL and data-driven decision-making in SQL.
SQL - MySQL for data analytics and business intelligence
- Website
- 18 Oct 2019
SQL for business analysis, marketing and data management. When you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business.
SQL for data science
- Website
- 09 Oct 2019
This course is designed to give you a primer in the fundamentals of SQL and working with data so that you can begin analysing it for data science purposes. The course starts with the basics and assumes you do not have any knowledge or skills in SQL. It will build on that foundation and gradually have you write both simple and complex queries to help you select data from tables. You will start to work with different types of data like strings and numbers and discuss methods to filter and pare down your results.
Hyperlinks
ICAEW accepts no responsibility for the content on any site to which a hypertext link from this site exists. The links are provided ‘as is’ with no warranty, express or implied, for the information provided within them. Please see the full copyright and disclaimer notice.