1265 Courses

Our 6 week pole dance courses available from Beginners/Stage 1, right up to Stage 10! 

Our 6 week pole dance courses available from Beginners/Stage 1, right up to Stage 10! 

Our 6 week pole dance courses available from Beginners/Stage 1, right up to Stage 10! 

Our masterclass series goes behind the studio door and explores the processes of globally respected designers.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55232 Writing Analytical Queries for Business Intelligence course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

This workshop gives you the unique opportunity to experience the basics of two crafts in 1 day in your own personal pairs workshop with one to one tuition. The studios are located in the cottage garden of our home on the Cambridgeshire/Norfolk border. Your experience is private to you and there will be no other students in the studios. The "2 crafts in 1 day" workshop is aimed at those who want to have a go at both of these fun crafts, and come away having learnt some basic techniques for both disciplines. As this is basically a private tuition experience, the course is focused but fun, so would make a fantastic gift. The day can also be experienced by just 1 person (to book this, please refer to our other workshop ""2 Crafts in 1 Day!" 1-2-1 woodturning & pottery experience in 1 day for 1 person" where each person could experience the crafts singularly or together.  This makes for a wonderful Valentine's or anniversary experience, and can also be enjoyed by a parent and child. The morning is spent learning the ropes of woodturning - how to cut and shape wood on the lathe, understanding a little about the different tools required, and making a few pieces to take home. After a light farmhouse-style lunch (which we provide and which we tailor to your dietary requirements), the afternoon then continues with a pottery session. Students can have fun with clay, focusing on some basic hand building methods to get them used to handling the material using the techniques of pinching, coiling, slab building and also throwing on the wheel.  A total of 3 pieces can then be chosen for us to glaze and fire once they have dried sufficiently. When ready, they can either be collected by the student (if they live locally) or I can post them on (I have to charge postage & packaging). Refreshments are provided during both workshops, and a light, rustic farmhouse-style lunch is also included - catering to all dietary requirements. Depending on the weather/time of year, lunch can be taken either out in the cottage garden or in our country kitchen. The sessions are hands-on with expert 1-2-1 tuition - and the student will be able to use all the studio facilities. Each student will also be provided with a certificate of participation for both crafts. About a week before your workshop date, we'll e-mail you again with more details about parking etc. We also offer accommodation in the form of our Crafter's Retreat cabin (www.craftersretreat.co.uk) or we can advise of other local B&Bs.

Are you a design or art student? Do you want to make sure your portfolio is up to the standard of the best? Join us for our portfolio workshop! We'll walk you through the process of developing an effective and eye-catching portfolio, and give you some insider tips on how to get noticed in the industry. You'll leave with a well-presented portfolio, an action plan that will help you get into the program of your choice, and interview practice so you can nail that all-important interview. We've got over 20 years of experience teaching design and art students, so we know exactly what it takes to produce work that stands out from the crowd. Our workshops are designed for people who want to know how to prepare for interviews, how to use their portfolio as a marketing tool for their own products, and how to present their work in the best possible light. Our company founder has interviewed for both jobs and degree level courses. She knows what questions they're going ask—and she knows exactly how to answer them!

The perfect Mother's Day gift! On the very cusp of British Summertime starting we’ll be spending an appropriately colourful afternoon steeped in drawing/painting Spring Flowers. The studio will be full of plants such as mini iris, grape hyacinths, tulips, primroses and daffodils. There will be cut flowers in still-life arrangements and a wealth of beautiful photo references to work from too. We’ll take inspiration from Scottish Colourist Samuel John Peploe’s tulip paintings amid an immersive, fun afternoon of Spring botanicals. All levels of artistic abilities are embraced in this workshop so it’s a great opportunity to try out a class with plant-lady tutor Suzanne Gibson. All materials and refreshments will be provided - including cake and a complimentary glass of fizz. Minimum class numbers apply.

Our 6 week pole dance courses available from Beginners/Stage 1, right up to Stage 10! 

BRIT Creative Coaching is structured for Performing Arts Students to reach their goals. Discover and build new skills that you need outside the studio.