Training
Ensuring you and your team have the proper skills to do your jobs is an essential aspect of any organisation and something which any manager should be regularly assessing. My courses will enable your team to get up to speed with the essential skills that they require.
The training takes place at a training venue in Central London. Alternatively, I can conduct training on your own site, for an extra charge. Please get in touch for more information.
All courses are three days in length and are charged at a rate of £499 per trainee per course.
We currently offer the following courses:
-
Power BI Training
-
SQL Server Training Basic Training
-
SQL Server Intermediate / Advanced
PBI01 – Mastering Power BI.
This is a three-day (9.30am-3.30pm UK time) intermediate level course. During this course, we’ll build an amazing sales dashboard (see image below)
The next date for this course is 24-26 February (Tue-Thu) at our Central London training room. £899 inc VAT. 
Day One
- Deep dive into the Power BI Interface
- Connecting to Data Sources
- Data Transformation and Cleaning with Power Query
- Creating Tabbed Navigation
Day Two
- Advanced DAX (Data Analysis Expressions)
- Working with Measures and Calculated Columns
- Time Intelligence
Day Three
- Drill-through Reports
- Data Refresh and Scheduling
- Row-Level Security in Power BI
- Best Practices for Report Design and Performance
Pre-requisites : You’ll need a good basic knowledge of Power BI. You’ll also be working on your own laptop, so bring it along (with Power BI installed – check it’s all working please!), and you’re good to go.
SQL01 – Introduction to SQL Server and Basic SQL.
The next date for this course is 24-26 February (Tue-Thu) at our Central London training room. £899 inc VAT.
This is a three-day course, and covers the following topics:
Day One
- Overview of SQL Server
- Software Tools
- Basic SQL Querying
- Scripts
- The Power of Collaborative Development
- Coding Standards
Day Two
- Creating and Modifying Objects and Data
- Views
- Stored Procedures
- Other Objects you may see
Day Three
- Introduction to SQL Server Security
- Query Optimisation
- Tools within SQL Server
SQL02 – Intermediate / Advanced SQL.
The next date for this course is 24-26 February (Tue-Thu) at our Central London training room. £899 inc VAT.
This is a three day course, and covers the following topics:
Day One
- Advanced SQL Querying Techniques
- Data Import and Export
- Performance Tuning and Optimization
- Transactions and Concurrency Control
- Advanced Stored Procedures and Functions
Day Two
- SQL Server Security
- Data Warehousing and Business Intelligence
- Advanced Indexing and Partitioning
Day Three
- Monitoring and Maintenance
- Advanced Features in SQL Server
- Advanced Data Migration Strategies
Hands-On Learning with Real-World Scenarios
Our training courses are much more than theory. I believe in being hands-on with plenty of real-world exercises and scenarios to challenge and stretch the trainees.
SQL Server Training and Power BI Courses – Please get in Touch for More Information
