Home | Prices | Contact Us | Courses: Power BI - Excel - Python - SQL - Generative AI - Visualising Data - Analysing Data
This is for anybody who would like to be able to better interpret and analyse datasets.
The course teaches students how to explore, analyse data and to ask the right questions that lead to better insights, and introduces the tools and techniques to help them do that analysis.
1 day
No prior experience in data analysis is required, but good expertise with Excel is assumed. This is not an Excel course per-se, but we will use Excel in many of the hands-on lab exercises.
The course is mainly instructor-led guided lab exercises and discussion. For one or two exercises attendees work in small groups of 4 to 5 people in guided discussions and exercises for much of the course. A spokesperson for the team then reports back to the entire class on the team’s results or conclusions.
Attendees practice using the some of the popular tools for data analysis, including Excel, Power BI Desktop, Python, and the the data analysis capabilities of generative AI tools such as ChatGPT.
This may includes a brief look at some of the advanced data analysis capabilities within Excel. These include:
The course covers why we must clean and shape our data into a tabular (and tidy) format before we can analyse it successfully. It dcovers characteristics of tabular data such as:
The instructor will demo a set of techniques for cleaning, shaping and analysis data these and attendees will practice in lab exercises.
We will summarise the lessons learned during the day and suggest a few resources for attendees who would like to learn more about data analysis.
The course has several optional modules that we may cover depending on attendee interest