480 Courses

Learn about CO2 sequestration and enhanced oil recovery in our EnergyEdge course. Gain valuable insights and practical knowledge. Enroll now.

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

Dive deep into gas treatment and sulphur recovery with EnergyEdge's expert-led course. Enroll today for valuable insights!

Take your knowledge to the next level with EnergyEdge's course focusing on pipeline integrity management incorporating API 1160, 1173, and ASME B31.8S. Enroll now!

Banjo lessons in Stroud: I have 20 years experience teaching guitar in person and online from my home in Brimscombe, Stroud (Gloucestershire)! I love music, and love to find ways to help you grow as a musician too! Whether you want to improve your soloing, play your favourite songs, be able to play in jams, or write songs...

I am able to travel to you to help you develop your partnership with your horse. I specialise in developing confidence in both horse and rider both on the flat and over fences. As a list 5 BD Dressage judge I can help you with test riding for BD Intro, Prelim and Novice tests. I can help with BE 90, 100 & Novice tests. As I am training for list 4 I can also help you with Elementary BD and Intermediate BE The times listed are a general guide of my availability. If you would prefer a time that is not listed please select the time that is closest to you preference, the message me via Email, WhatsApp or Facebook to see if we can arrange a better time for you. Instructions Make sure we have access to an arena, with a poop scoop and poles if you want them.

Mosaic Summer School

The Firth of Forth is a stunning and diverse location for photography. During this full-day session we will travel across both the North and South banks of the River Forth to capture some amazing locations from characterful old jetties to the Forth Bridges; from the smallest port in Scotland to hidden bays. This is designed for people who know the basics of their camera and want to learn how to take stunning landscape and seascapes images whilst discovering the beautiful scenery around the Forth estuary. Attendees on the session will learn how to create stunning images in-camera through the use of filters and more advanced composition techniques. The full-day session commences from first light and will last until sunset so there are many opportunities to practice your skills. During the day we will also spend some time looking at how we can use editing software to enhance your images. The workshop will have a minimum of two and a maximum of six attendees to ensure that everyone receives individual attention from a professional photographer. About Ideal if you understand how to set the exposure of your camera manually and want to learn how to use filters to improve your photographs. We visit several locations along the banks of the Forth River to capture sunrise and sunset, panoramas and change the way we see movement in water. This is a full-day workshop, picking up from Edinburgh a couple of hours before sunrise and returning about an hour after sunset. Lunch is not included Experience level – intermediate and advanced What to Bring A camera that you can set the exposure manually A good sturdy tripod. It is helpful to have a wide-angle lens and a long zoom, although if you only have a kit-lens then that will still be fine for this workshop. You will need a filter system such as Lee, Nisi or Cokin with ND and ND graduated filters Ensure your camera batteries are fully charged and strongly consider having a spare An empty memory card, we’ll take about 150 photographs during the session. Duration 12 hours 

3ds Max and Vray Training 1-2-1

Vectorworks One to One Fast Track Course Master Vectorworks in Just One Day (10 Hours)