With Data Skills, you are assured of learning from highly skilled, experienced trainers who teach practical skills that make a difference in the workplace!
- Excel Courses
- Power BI Courses
- Introduction to Power BI
- Query Editor
- Introduction to DAX
Excel Courses
Introduction to Excel Pivot Tables
Excel pivot tables offer users the ability to rapidly analyse large volumes of data in an easy-to-use format.
If you deal with data in Excel and don’t use Pivot Tables, you definitely need to do this course!
In this course you will learn to:
- Prepare your data for analysis
- Build pivot tables
- Format pivot tables
- Aggregate your data in different ways
- Group your data
- Work with dates
- Filter your data
- Use slicers
- Build a basic dashboard using pivot tables
Duration: 1 day
Cost: £40 plus £200 per delegate (EX VAT) Terms apply
Advanced Excel Pivot Tables
Take your Excel Pivot Tables to the next level! This course is intended to show you advanced features of Pivot Tables and Pivot Charts. In this course, you will learn to:
- Use tables effectively for your data sources
- Perform advanced calculations on your data
- Create new fields
- Build pivot charts
- Apply conditional formatting to your pivot tables
- Build a sophisticated & interactive dashboard
Duration: 1 day
Cost: £40 plus £200 per delegate (EX VAT) Terms apply
Excel Power Query
Have you ever noticed the “Get Data” menu option on the Data tab in Excel? If not, you have missed out on a simply incredible load & transform tool built into Excel called Power Query! With Power Query, you can pull data from various source, split or combine columns, merge datasets, define data types and much more. In this course, you will learn to:
- Benefits of using power query
- How to launch Power Query and the Query Editor
- Loading data into Power Query
- Filtering & modifying data
- Calculating custom fields
- Merging data
- Consolidating data sources with merge
- Appending data
- Creating custom calculations using M Code
- Using the group function
- Loading CSV & Online data into Power Pivot
Duration: 1 day
Cost: £40 plus £200 per delegate (EX VAT) Terms apply
Excel Power Pivot
One of Excel’s newer features is the amazing Power Pivot module. If you are working with data in Excel, Power Pivot could be the most amazing tool you’ve learned about in 10 years! In this course, you will learn to:
- Activate Power Pivot in Excel
- Load data into Power Pivot
- Browse filter and sort data in Power Pivot
- Build measures in Power Pivot
- Create PivotTables from your new Power Pivot data source
- Create hierarchies in Power Pivot
- Use the incredible DAX language to build new fields
- Build relationships between related data sets
- Create named sets
- Create KPIs
Duration: 1 day
Cost: £40 plus £200 per delegate (EX VAT) Terms apply
Power BI Courses
Microsoft’s amazing Power BI tool makes business intelligence a breeze! Build mind-blowing interactive dashboards, bringing together data from various sources with just a few clicks of the mouse!
Introduction to Power BI
Get a solid introduction to this fantastic product with our 2-day introductory course. This is ideal for someone with limited or no knowledge of Power BI. In this course you will learn:
- Signing into Power BI
- Using the Power BI Desktop
- Creating a basic report
- Aggregation methods
- Tables & Cards
- Filtering Data
- Visualisations
- Graph options
- Trend Analysis
- Using Power Query
- Transforming Data
- DAX
- Measures
- Creating a dashboard
- Publishing a report
- Mobile view of your report
- Power BI with Excel
Duration: 2 days
Cost: £100 plus £350 per delegate (EX VAT) Terms apply
Add a testimonial from someone who loves your services. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin id arcu aliquet, elementum nisi quis, condimentum nibh. Donec hendrerit dui ut nisi tempor scelerisque.
— Jane Doe
Add a testimonial from someone who loves your services. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin id arcu aliquet, elementum nisi quis, condimentum nibh. Donec hendrerit dui ut nisi tempor scelerisque.
— Jane Doe