Data Analysis & BI Courses

Most popular
Trending

All Data Analysis & BI Courses

We found 6 courses available for you
Free
Expert

Microsoft Access Course

Access has been around for over two decades and it’s …

Free

Microsoft Access Course

6 hours
34 Lessons
Expert
What you'll learn
We will cover the following topics (please use the contents to learn further details of lessons that will be covered)
Creating a Tables
Creating Queries
Action Queries
Linking Tables
Creating Forms, SubForms & SplitForms
Creating Reports
Importing & Exporting Data
Building VBA/Macros to automate your databases
Free
Expert

SQL Server Course

There is far too much data in your company, and …

Free

SQL Server Course

3.6 hours
23 Lessons
Expert
What you'll learn
THIS COURSE IS FOR THREE TYPES OF PROFESSIONALS
1. You’ve been working with Excel and your companies’ data volumes have grown to the point where you need a more robust solution to handle the higher volume of data
2. You’ve started working in a company or a new project that already has SQL server and you need to get up to scratch to start querying it to create analysis and reports
3. Finally, you are a project manager or business analyst who won’t be building or querying a database but you need to understand databases so you can be a better bridge between IT and the business
WHAT YOU WILL LEARN
As you look to move beyond Excel, we will get you up and running with SQL Server:
· How a SQL server database works and set one up
· Tables: layouts, keys, data types and queries to interrogate a table
· Database structure: the relational model, foreign keys, and cardinality
· Joins: Essentially filter a database and make sure we get only the information we are interested in
· Advanced SQL: Stored procedures, functions and exporting
Free
Intermediate

Power Pivot Course

Data is growing at an alarming rate in many situations …

Free

Power Pivot Course

3.6 hours
51 Lessons
Intermediate
What you'll learn
We will cover all you need to know PowerPivot with the following topics (please use the contents to learn further details of lessons that will be covered):
Introduction to Power Pivot
Loading Data
Pivot Tables And Refresh
What are Measures and why they are so crucial
Hierarchies And Related Columns
Working with DAX beyond the basics
Free
Intermediate

Power BI Course

Power BI is Microsoft’s play into the growing Business Intelligence …

Free

Power BI Course

3.9 hours
36 Lessons
Intermediate
What you'll learn
We will cover the following topics (please use the contents to learn further details of lessons that will be covered)
Introduction:Get familiar with the interface and views in Power BI
Working with Data: Connecting to data, using Power Query and building tables
Data Analysis: understanding relationships, measures and calculations
Power BI Dashboards: Creating outputs with some of the key charts in Power BI.
Sharing and Publishing Power BI: How can we publish and share our work
Free
Expert

Advanced Power BI

Building on from our Introduction Power BI Course, in this …

Free

Advanced Power BI

3.6 hours
22 Lessons
Expert
What you'll learn
We will cover the following topics (please use the contents to learn further details of lessons that will be covered):
Data Preparation: Cleaning data sources, Data types, Date correction
Merge & duplicating queries
Deeper in to DAX: Time Intelligence, Year on Year, Last 30 days, Running totals
Visualisation: Presentation, Formatting, Custom themes, Conditional formatting, Sync filters, Drill through views
And much more
Free
Expert

Power Query Course

If you have been wasting vast amounts of time at …

Free

Power Query Course

5.4 hours
39 Lessons
Expert
What you'll learn
HOW THIS COURSE WILL HELP YOU
This video course is taught by our in-house Data expert Ross Hughes who has over 30 years of experience working with Data in senior technical roles within major companies. In a few short hours of self-paced training, Ross will have you going through the full cycle of ‘Getting, Transforming and Refreshing’ your data, after which it will be ready for quick analysis and report. Ross’ experience is priceless, he shows you how to harness Power Query like few can and having him, teaching you ‘over his shoulder’ is more than worth the price of the course.
WHAT YOU WILL LEARN:
You will learn all you need to know about Power Query to help you deal with difficult data challenges.
Introduction to getting data from various sources and cleaning it up
Rapidly transpose, pivot and un-pivot your data to make it useful
How you can quickly combine multiple data sets by appending and joining
Speed up your data queries with duplication and tweaking parameters
Troubleshoot your queries and set up auto-refreshing of your data