Harpenden

<p>This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations.</p>The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth.<section>
                    <h3>1 The Query Editor</h3><ul><li>Grouping rows in a table</li><li>Split row by delimiter</li><li>Add days to determine deadlines</li><li>The query editor</li></ul> <h3>2 Fuzzy Matching Joins</h3><ul><li>Matching inconsistencies by percentage</li><li>Matching with transformation table</li></ul> <h3>3 The Query Editor M Functions</h3><ul><li>Adding custom columns</li><li>Creating an IF function</li><li>Nested AND logics in an IF function</li></ul> <h3>4 DAX New Columns Functions</h3><ul><li>Including TRUE with SWITCH</li><li>Using multiple conditions</li><li>The FIND DAX function</li><li>The IF DAX function</li><li>Logical functions IF, AND, OR</li></ul> <h3>5 Editing DAX Measures</h3><ul><li>Making DAX easier to read</li><li>Add comments to a measure</li><li>Using quick measures</li></ul> <h3>6 The Anatomy of CALCULATE</h3><ul><li>Understanding CALCULATE filters</li><li>Add context to CALCULATE with FILTER</li><li>Using CALCULATE with a threshold</li></ul> <h3>7 The ALL Measure</h3><ul><li>Anatomy of ALL</li><li>Create an ALL measure</li><li>Using ALL as a filter</li><li>Use ALL for percentages</li></ul> <h3>8 DAX Iterators</h3><ul><li>Anatomy of iterators</li><li>A closer look at SUMX</li><li>Using RELATED with SUMX</li><li>Create a RANKX</li><li>RANKX with ALL</li></ul> <h3>9 Date and Time Functions</h3><ul><li>Overview of functions</li><li>Create a DATEDIFF function</li></ul> <h3>10 Time Intelligent Measures</h3><ul><li>Compare historical monthly data</li><li>Create a DATEADD measure</li><li>Creating cumulative totals</li><li>Creating cumulative measures</li><li>Visualising cumulative totals</li></ul> <h3>11 Visualisations In-Depth</h3><ul><li>Utilising report themes</li><li>Applying static filters</li><li>Group data using lists</li><li>Group numbers using bins</li><li>Creating heatmaps</li><li>Comparing proportions</li><li>View trends with sparklines</li></ul> <h3>12 Comparing Variables</h3><ul><li>Visualising trendlines as KPI</li><li>Forecasting with trendlines</li><li>Creating a scatter plot</li><li>Creating dynamic labels</li><li>Customised visualisation tooltips</li><li>Export reports to SharePoint</li></ul> 


                </section>

The In House Training Company

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Microsoft Power Platform

Microsoft BI

Power BI - intermediate (2 day) (In-House)

Medway

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Overview</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is an 8-hour course aimed to help you learn what is meant by Data Science, what it involves and how it is often done, then to complete a small practical project to use some of the techniques and to get an idea of whether this is something that you might want to take further.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">How you will learn</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You will be coached and mentored to complete the<em fr-original-style="" style="box-sizing: border-box;"> CISCO Skills for All </em>online course<em fr-original-style="" style="box-sizing: border-box;"> "Introduction to Data Science"</em> over a series of 3 two-hour, one per week. sessions with an opportunity to continue the learning in between sessions.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Each week there will be an hour long workshop introducing a data tool (spreadsheet, visualisation, story-telling) and giving you practical exercises to do.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You will choose a data set that interests you and, in an final 2 hour session, you will complete a small practical project with your chosen dataset and one or more of the tools introduced in previous weeks.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Topics</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You will find a list of topics covered in the online course here</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Achievements</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You will earn CISCO badges</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Introduction to Data Science</li><li fr-original-style="" style="box-sizing: border-box;">Basics of Analytics</li><li fr-original-style="" style="box-sizing: border-box;">Data Collection</li><li fr-original-style="" style="box-sizing: border-box;">Artificial Intelligence and Machine Learning Concepts</li><li fr-original-style="" style="box-sizing: border-box;">Data Careers</li></ul><div fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">and a statement of achievement from futureCodersSE CIC, with a shared link to your project to add to your CV or LinkedIn profile.</span></div><div fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></div>

futureCoders SE

Data Storytelling

Learn the basics of Data Science, combining a supported #CISCO Skills for All online course with practical learning and a project to help consolidate the learning.

Introduction to Data Science - free for Medway residents

General admission

<p>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.</p><p>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.</p><p>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.</p><section>
                    <h3>1 Getting started</h3><ul><li>The Power BI process</li><li>Launching Power BI Desktop</li><li>The four views of Power BI</li><li>Dashboard visuals</li></ul> <h3>2 Connecting to files</h3><ul><li>Connect to data sources</li><li>Connect to an Excel file</li><li>Connect to a CSV file</li><li>Connect to a database</li><li>Import vs. DirectQuery</li><li>Connect to a web source</li><li>Create a data table</li></ul> <h3>3 Transforming data</h3><ul><li>The process of cleaning data</li><li>Column data types</li><li>Remove rows with filters</li><li>Add a custom column</li><li>Append data to a table</li><li>Fix error issues</li><li>Basic maths operations</li></ul> <h3>4 Build a data model</h3><ul><li>Table relationships</li><li>Manage table relationships</li></ul> <h3>5 Merge queries</h3><ul><li>Table join kinds</li><li>Merging tables</li></ul> <h3>6 Create report visualisations</h3><ul><li>Creating map visuals</li><li>Formatting maps</li><li>Creating chart visuals</li><li>Formatting chart</li><li>Tables, matrixes, and cards</li><li>Control formatting with themes</li><li>Filter reports with slicers</li><li>Reports for mobile devices</li><li>Custom online visuals</li><li>Export report data to Excel</li></ul> <h3>7 The power query editor</h3><ul><li>Fill data up and down</li><li>Split columns by delimiter</li><li>Add conditional columns</li><li>Merging columns</li></ul> <h3>8 The M formula</h3><ul><li>Creating M functions</li><li>Create an IF function</li><li>Create a query group</li></ul> <h3>9 Pivot and unpivot tables</h3><ul><li>Pivot tables in the query editor</li><li>Pivot and append tables</li><li>Pivot but don't summarise</li><li>Unpivot tables</li><li>Append mismatched headers</li></ul> <h3>10 Data modelling revisited</h3><ul><li>Data model relationships</li><li>Mark a calendar as a date table</li></ul> <h3>11 Introduction to calculated columns</h3><ul><li>New columns vs. measures</li><li>Creating a new column calculation</li><li>The SWITCH function</li></ul> <h3>12 Introduction to DAX measures</h3><ul><li>Common measure categories</li><li>The SUM measure</li><li>Adding measures to visuals</li><li>COUNTROWS and DISINCTCOUNT functions</li><li>DAX rules</li></ul> <h3>13 The CALCULATE measure</h3><ul><li>The syntax of CALCULATE</li><li>Things of note about CALCULATE</li></ul> <h3>14 The SUMX measure</h3><ul><li>The SUMX measure</li><li>X iterator functions</li><li>Anatomy of SUMX</li></ul> <h3>15 Introduction to time intelligence</h3><ul><li>Importance of a calendar table</li><li>A special lookup table</li><li>The TOTALYTD measure</li><li>Change year end in TOTALYTD</li></ul> <h3>16 Hierarchy, groups and formatting</h3><ul><li>Create a hierarchy to drill data</li><li>Compare data in groups</li><li>Add conditional formatting</li></ul> <h3>17 Share reports on the web</h3><ul><li>Publish to the BI online service</li><li>Get quick insights</li><li>Upload reports from BI service</li><li>Exporting report data</li><li>What is Q&amp;A?</li><li>Sharing your reports</li></ul> <h3>18 Apply your learning</h3><ul><li>Post training recap lesson</li></ul> 


                </section>

Business Intelligence (BI)

Power BI - introduction to intermediate (2 days) (In-House)

Birmingham

Erdington

Queensway

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For Private options, online or in-person, please send us details of your requirements:</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment of time and money.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. This course is aimed at someone who has not used Tableau in earnest and may be in a functional role, eg. in sales, marketing, finance, operations, business intelligence etc.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="28546e3a" data-element_type="section" style="color: rgb(98, 98, 98); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(98, 98, 98);"><div data-id="530ff072" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="7ae5fe7" data-element_type="section" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="461193e7" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="8fd671b" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">The course is split into 3 phases and 9 modules:</h2></div><div data-id="58a6c8fc" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">PHASE 1: GET READY</h2></div><div data-id="5f8c8664" data-element_type="widget" data-widget_type="accordion.default" fr-original-style="" style="box-sizing: border-box;"><h5 data-tab="1" tabindex="0" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 1: LAUNCH TABLEAU</h5><div data-tab="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Check Install &amp; Setup</li><li fr-original-style="" style="box-sizing: border-box;">Why is Visual Analytics Important</li></ul></div><h5 data-tab="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 2: GET FAMILIAR</h5><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">What is possible</li><li fr-original-style="" style="box-sizing: border-box;">How does Tableau deal with data</li><li fr-original-style="" style="box-sizing: border-box;">Know your way around</li><li fr-original-style="" style="box-sizing: border-box;">How do we format charts</li><li fr-original-style="" style="box-sizing: border-box;">Dashboard Basics &ndash; My First Dashboard</li></ul><h5 data-tab="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 3: DATA DISCOVERY</h5><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Connecting to and setting up data in Tableau</li><li fr-original-style="" style="box-sizing: border-box;">How Do I Explore my Data &ndash; Filters &amp; Sorting</li><li fr-original-style="" style="box-sizing: border-box;">How Do I Structure my Data &ndash; Groups &amp; Hierarchies, Visual Groups</li><li fr-original-style="" style="box-sizing: border-box;">How Tableau Deals with Dates &ndash; Using Discrete and Continuous Dates, Custom Dates</li></ul></div></div></section><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="2696f5d3" data-element_type="section" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="ec4f006" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="4520c476" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);"><br fr-original-style="" style="box-sizing: border-box;"></h2><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Phase 2: GET SET</h2></div><div data-id="16ebe443" data-element_type="widget" data-widget_type="accordion.default" fr-original-style="" style="box-sizing: border-box;"><h5 data-tab="1" tabindex="0" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 4: MAKE CALCULATIONS</h5><div data-tab="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">How Do I Create Calculated Fields &amp; Why</li></ul></div><h5 data-tab="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 5: MAKE CHARTS</h5><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Charts that Compare Multiple Measures &ndash; Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots</li><li fr-original-style="" style="box-sizing: border-box;">Showing Relational &amp; Proportional Data &ndash; Pie Charts, Donut Charts, Tree Maps</li></ul><h5 data-tab="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 6: MAKE TABLES</h5><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Creating Tables &ndash; Creating Tables, Highlight Tables, Heat Maps</li></ul></div></div></section><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="5e5df3ea" data-element_type="section" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="491b064f" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="357bfc09" data-element_type="widget" data-widget_type="heading.default" fr-original-style="" style="box-sizing: border-box;"><h2 style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Phase 3: GO</h2></div><div data-id="4dd84eb2" data-element_type="widget" data-widget_type="accordion.default" fr-original-style="" style="box-sizing: border-box;"><h5 data-tab="1" tabindex="0" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 7: ADD CONTEXT</h5><div data-tab="1" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Reference Lines and Bands</p></li></ul></div><h5 data-tab="2" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 8: MAKE MAPS</h5><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><div fr-original-style="" style="box-sizing: border-box;">Answering Spatial Questions &ndash; Mapping, Creating a Choropleth (Filled) Map</div></li></ul><h5 data-tab="3" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">MODULE 9: MAKE DASHBOARDS</h5><ul fr-original-style="" style="box-sizing: border-box;"><li id="isPasted" fr-original-style="" style="box-sizing: border-box;">Using the Dashboard Interface</li><li fr-original-style="" style="box-sizing: border-box;">Dashboard Actions</li></ul></div></div></section></div></section><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="5b9fdc59" data-element_type="section" data-settings='{"background_background":"classic"}' style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style=" color: rgb(98, 98, 98);"><div data-id="649bcdb4" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="315826bb" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This training course includes over&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">25</strong>&nbsp;hands-on exercises and quizzes to help participants&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&ldquo;learn by doing&rdquo;</strong>&nbsp;and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format.</p></div><div data-id="6243dea8" data-element_type="widget" data-widget_type="text-editor.default" style="color: rgb(255, 255, 255); box-sizing: border-box;" fr-original-style=" color: rgb(255, 255, 255);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Students must use their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed.</p></div></div></section><section data-particle_enable="false" data-particle-mobile-disabled="false" data-id="649f95d" data-element_type="section" data-settings='{"background_background":"classic"}' fr-original-style="" style="box-sizing: border-box;"><div data-id="1c207d92" data-element_type="column" fr-original-style="" style="box-sizing: border-box;"><div data-id="1bce9646" data-element_type="widget" data-widget_type="heading.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><h2 style="color: rgb(17, 41, 74); box-sizing: border-box;" fr-original-style=" color: rgb(17, 41, 74);">What People Are Saying About This Course</h2></div><div data-id="780525c2" data-element_type="widget" data-settings='{"slides_per_view":"2","slides_to_scroll":"1","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><img src="https://cdn.vizdj.com/wp-content/uploads/2021/11/quote-icon.png" alt="Richard L., Intelliflo" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&ldquo;Excellent Trainer &ndash; knows his stuff, has done it all in the real world, not just the class room.&rdquo;</div><cite fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Richard L., Intelliflo</span></cite></div><div data-id="780525c2" data-element_type="widget" data-settings='{"slides_per_view":"2","slides_to_scroll":"1","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" fr-original-style="" style="box-sizing: border-box;"><font color="#07294d" fr-original-style="" style="box-sizing: border-box;"><i fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></i></font><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);"><img src="https://cdn.vizdj.com/wp-content/uploads/2021/11/quote-icon.png" alt="Chelsey H., QVC" style="color: rgb(98, 98, 98); cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(98, 98, 98);" fr-original-class="fr-draggable"></div><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color: rgb(0, 0, 0);">&ldquo;Tableau is a complicated and powerful tool. After taking this course, I am confident in what I can do, and how it can help improve my work.&rdquo;</div><cite style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><span style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Trevor B., Morrison Utility Services</span></cite></div><div data-id="780525c2" data-element_type="widget" data-settings='{"slides_per_view":"2","slides_to_scroll":"1","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" fr-original-style="" style="box-sizing: border-box;"><font color="#626262" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></font></div><div data-id="780525c2" data-element_type="widget" data-settings='{"slides_per_view":"2","slides_to_scroll":"1","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" fr-original-style="" style="box-sizing: border-box;"><font color="#626262" fr-original-style="" style="box-sizing: border-box;"><img src="https://cdn.vizdj.com/wp-content/uploads/2021/11/quote-icon.png" alt="Trevor B., Morrison Utility Services" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"></font></div><div data-id="2de0482d" data-element_type="widget" data-settings='{"slides_per_view":"2","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&ldquo;I would highly recommend this course for Tableau beginners, really easy to follow and keep up with as you are hands on during the course. Trainer really helpful too.&rdquo;</div><cite fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Chelsey H., QVC</span></cite></div><div data-id="2de0482d" data-element_type="widget" data-settings='{"slides_per_view":"2","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><br fr-original-style="" style="box-sizing: border-box;"></div><div data-id="2de0482d" data-element_type="widget" data-settings='{"slides_per_view":"2","space_between":{"unit":"px","size":0,"sizes":[]},"slides_per_view_tablet":"2","speed":500,"space_between_tablet":{"unit":"px","size":10,"sizes":[]},"space_between_mobile":{"unit":"px","size":10,"sizes":[]}}' data-widget_type="testimonial-carousel.default" style="color: rgb(98, 98, 98); box-sizing: border-box;" fr-original-style="color: rgb(98, 98, 98);"><img src="https://cdn.vizdj.com/wp-content/uploads/2021/11/quote-icon.png" alt="Chelsey H., QVC" fr-original-style="" style="cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" fr-original-class="fr-draggable"><div style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&ldquo;He is a natural trainer, patient and very good at explaining in simple terms. He has an excellent knowledge base of the system and an obvious enthusiasm for Tableau, data analysis and the best way to convey results. We had been having difficulties in the business in building financial reports from a data cube and he had solutions for these which have proved to be very useful.&rdquo;</div><cite fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(7, 41, 77); box-sizing: border-box;" fr-original-style=" color: rgb(7, 41, 77);">Matthew H., ISS Group</span></cite></div></div></section>

Tableau Training Uk

Tableau Desktop Training - Foundation

<p>There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a 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 utilise the online Power BI service.</p><p>It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way.</p><p>It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level.</p><p>The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away.</p><section>
                    <h3>1 Getting Started</h3><ul><li>The Power BI ecosystem</li><li>Opening Power BI Desktop</li><li>Power BI's four views</li><li>Introduction to Dashboards</li></ul> <h3>2 Importing Files</h3><ul><li>Importing data sources</li><li>Importing an Excel file</li><li>Importing a CSV file</li><li>Importing a database</li><li>Connect to an SQL Server Database</li><li>Import vs. Direct Query</li><li>Importing from the web</li><li>Importing a folder of files</li><li>Managing file connections</li></ul> <h3>3 Shape Data in the Query Editor</h3><ul><li>The process of shaping data</li><li>Managing data types</li><li>Keeping and removing rows</li><li>Add a custom column</li><li>Appending tables together</li><li>Hiding queries in reports</li><li>Fixing error issues</li><li>Basic maths operations</li></ul> <h3>4 The Data Model</h3><ul><li>Table relationships</li><li>Relationship properties</li></ul> <h3>5 Merge Queries</h3><ul><li>Table join kinds</li><li>Merging tables</li></ul> <h3>6 Inserting Dashboard Visuals</h3><ul><li>Things to keep in mind</li><li>Inserting maps</li><li>Formatting Maps</li><li>Inserting charts</li><li>Formatting Charts</li><li>Inserting a tree map</li><li>Inserting a table, matrix, and card</li><li>Controlling number formats</li><li>About report themes</li><li>Highlighting key points</li><li>Filter reports with slicers</li><li>Sync slicers across dashboards</li><li>Custom web visuals</li></ul> <h3>7 Publish and share Reports</h3><ul><li>Publishing to Power BI service</li><li>Editing online reports</li><li>Pinning visuals to a dashboard</li><li>What is Q&amp;A?</li><li>Sharing dashboards</li><li>Exporting reports to PowerPoint</li><li>Exporting reports as PDF files</li></ul> <h3>8 The Power Query Editor</h3><ul><li>Fill data up and down</li><li>Split column by delimiter</li><li>Add a conditional column</li><li>More custom columns</li><li>Merging columns</li></ul> <h3>9 The M Functions</h3><ul><li>Inserting text functions</li><li>Insert an IF function</li><li>Create a query group</li></ul> <h3>10 Pivoting Tables</h3><ul><li>Pivot a table</li><li>Pivot and append tables</li><li>Pivot but don't aggregate</li><li>Unpivot tables</li><li>Append mismatched headers</li></ul> <h3>11 Data Modelling Expanded</h3><ul><li>Understanding relationships</li><li>Mark a date table</li></ul> <h3>12 DAX New Columns</h3><ul><li>New columns and measures</li><li>New column calculations</li><li>Insert a SWITCH function</li></ul> <h3>13 Introduction to DAX Measures</h3><ul><li>Common measure functions</li><li>Insert a SUM function</li><li>Insert a COUNTROWS function</li><li>Insert a DISTINCTCOUNT function</li><li>Insert a DIVIDE function</li><li>DAX rules</li></ul> <h3>14 The CALCULATE Measure</h3><ul><li>The syntax of CALCULATE</li><li>Insert a CALCULATE function</li><li>Control field summarisation</li><li>Things of note</li></ul> <h3>15 The SUMX measure</h3><ul><li>X iterator functions</li><li>Anatomy of SUMX</li><li>Insert a SUMX function</li><li>When to use X functions</li></ul> <h3>16 Time Intelligence Measures</h3><ul><li>Importance of a calendar table</li><li>Insert a TOTALYTD function</li><li>Change financial year end date</li><li>Comparing historical data</li><li>Insert a DATEADD function</li></ul> <h3>17 Hierarchies and Groups</h3><ul><li>Mine data using hierarchies</li><li>Compare data in groups</li></ul> 


                </section>

Power BI - introduction (2 day) (In-House)

<p><strong>***24 Hour Limited Time Flash Sale***</strong></p><p><strong> </strong><strong>Data Visualisation Professional - CPD Certified </strong><strong>Admission Gifts </strong></p><p><strong> FREE PDF &amp; Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter</strong></p><p>Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Data Visualisation Professional - CPD Certified Bundle provides unique insights and tools that can help you achieve your goals.</p><p>Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Data Visualisation Professional - CPD Certified bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level.</p><p><strong>But that's not all. When you enrol in Data Visualisation Professional - CPD Certified Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free.</strong></p><p><strong>Courses Are Included In this Data Visualisation Professional - CPD Certified Career Bundle:</strong></p><ul><li> Course 01: Master JavaScript with Data Visualization</li><li> Course 02: SQL for Data Science, Data Analytics and Data Visualization</li><li> Course 03: Spatial Data Visualization and Machine Learning in Python</li><li> Course 04: Data Analysis</li><li> Course 05: Excel Data Analysis</li><li> Course 06: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines</li><li> Course 07: Python Programming Bible</li><li> Course 08: Python Data Science with Numpy, Pandas and Matplotlib</li><li> Course 09: Data Science &amp; Machine Learning with Python</li><li> Course 10: Statistics &amp; Probability for Data Science &amp; Machine Learning</li><li> Course 11: R Programming for Data Science</li><li> Course 12: Quick Data Science Approach from Scratch</li><li> Course 13: Mastering SQL Programming</li><li> Course 14: Learn Python, JavaScript, and Microsoft SQL for Data science</li><li> Course 15: Web Scraping and Mapping Dam Levels in Python and Leaflet</li><li> Course 16: Business Data Analysis</li><li> Course 17: Business Intelligence and Data Mining Diploma</li><li> Course 18: Google Data Studio: Data Analytics</li><li> Course 19: Google Analytics for Everyone</li><li> Course 20: Big Data Analytics with PySpark Tableau Desktop and MongoDB</li><li> Course 21: Big Data Analytics with PySpark Power BI and MongoDB</li><li> Course 22: Introduction to Data Analytics with Tableau</li><li> Course 23: Microsoft Power BI - Master Power BI in 90 Minutes!</li><li> Course 24: PowerBI Formulas</li><li> Course 25: Develop Big Data Pipelines with R &amp; Sparklyr &amp; Tableau</li><li> Course 26: Develop Big Data Pipelines with R, Sparklyr &amp; Power BI</li><li> Course 27: Microsoft Access Tables and Queries</li><li> Course 28: Statistical Analysis</li><li> Course 29: Research Methods in Business</li><li> Course 30: Customer Analytics Training</li></ul><p>With Data Visualisation Professional - CPD Certified, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner.</p><p>Don't let this opportunity pass you by. Enrol in Data Visualisation Professional - CPD Certified today and take the first step towards achieving your goals and dreams.</p><p><strong>Why buy this Data Visualisation Professional - CPD Certified?</strong></p><ul><li><strong>Free CPD Accredited Certificate</strong> upon completion of Data Visualisation Professional - CPD Certified</li><li>Get <strong>a free student ID card</strong> with Data Visualisation Professional - CPD Certified</li><li><strong>Lifetime access</strong> to the Data Visualisation Professional - CPD Certified course materials</li><li>Get instant access to this Data Visualisation Professional - CPD Certified course</li><li>Learn Data Visualisation Professional - CPD Certified from anywhere in the world</li><li>24/7 tutor support with the Data Visualisation Professional - CPD Certified course.</li></ul> <p><strong>Start your learning journey straightaway with our Data Visualisation Professional - CPD Certified Training!</strong></p><p>Data Visualisation Professional - CPD Certified premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the Data Visualisation Professional - CPD Certified is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience.</p><p><strong>Certification</strong></p><p>You have to complete the assignment given at the end of the Data Visualisation Professional - CPD Certified course. After passing the Data Visualisation Professional - CPD Certified exam You will be entitled to claim a PDF &amp; Hardcopy certificate accredited by CPD Quality standards completely free.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        300 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p><strong>This Data Visualisation Professional - CPD Certified course is ideal for:</strong></p><ul><li>Students seeking mastery in Data Visualisation Professional - CPD Certified</li><li>Professionals seeking to enhance Data Visualisation Professional - CPD Certified skills</li><li>Individuals looking for a Data Visualisation Professional - CPD Certified-related career.</li><li>Anyone passionate about Data Visualisation Professional - CPD Certified</li></ul>
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This <strong>Data Visualisation Professional - CPD Certified </strong>doesn't require prior experience and is suitable for diverse learners.</p>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>After the assessment, you will be ready for countless job opportunities. Some of them are-</p><ul><li>Business Analyst</li><li>Business Intelligence Analyst</li><li>Analytics Manager</li><li>Data Analyst</li><li>Data Scientist</li></ul><p>However, in the growing market of the UK, these professionals are expected to earn between <strong>£25k to £80k</strong> yearly on average.</p>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPD Accredited Digital Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>CPD Accredited Hard Copy Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>If you are an <strong>international student</strong>, then you have to pay an additional <strong>10 GBP</strong> for each certificate as an international delivery charge.</p></div>

                        </div>

Academy for Health and Fitness

Data Visualisation Professional - CPD Certified

General Admission

Duco Digital Training

Machine Learning (ML)

IT Certifications

IT Skills

Data Visualization

Computing & IT

Data Analysis

Data Analyst

IT Literacy

Business Data Analysis

Thinking about learning more about the data you are using in your job and how to present this?
The BCS Foundation Award in Data Visualisation teaches how data is used to make decisions in an organisation and the importance of presenting accurate data in a way that enables decision making to happen.

Data Visualisation - BCS Foundation Award

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>Discover how self-awareness and mental imagery can forge a path to better outcomes by taking </span><b>A Beginners Guide to Visualisation. </b><span>As human beings, our frailties and lack of conviction can often prevent us from reaching goals and objectives. With the help of this introductory training, you will be able to literally imagine your future and work towards attaining it with new levels of vigour and purpose.          </span></p><p><span>This </span><b>Visualisation </b><span>course focuses on the most effective ways to use the power of the mind to provide the impetus for actions and success. From the basic concepts of visualisation and its uses, you will be given a demonstration of how it has been used in the past and why it is still a valuable process that experts use time and time again. Taking you on a complete learning curve, even if you have had no previous experience, you will soon be capable of building pictures in your head that you will be able to make come true in the physical world.  </span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This best selling <strong>A Beginners Guide to Visualisation </strong>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth <strong>A Beginners Guide to Visualisation </strong>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p>
<p>The <strong>A Beginners Guide to Visualisation </strong>is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The <strong>A Beginners Guide to Visualisation </strong>is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p>
<p>After successfully completing the<strong> A Beginners Guide to Visualisation</strong>, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the <strong>A Beginners Guide to Visualisation </strong>will help you stand out from the crowd. You can also validate your certification on our website.</p>
<p>We know that you are busy and that time is precious, so we have designed the <strong>A Beginners Guide to Visualisation </strong>to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p>
<p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email. </p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

Course Cloud

A Beginners Guide to Visualisation

<h2>Professional Arduino Data Visualisation using Python Course Overview</h2> <p>Are you looking to begin your Arduino data visualisation career or want to develop more advanced skills in Arduino data visualisation? Then this professional Arduino data visualisation using Python course will set you up with a solid foundation to become a confident Python progammer or electronic and electrical engineer and help you to develop your expertise in Arduino data visualisation.</p> <p>This professional Arduino data visualisation using Python course is <strong>accredited</strong> by the <strong>CPD UK </strong>&amp;<strong> IPHM</strong>. CPD is <strong>globally recognised</strong> by <strong>employers</strong>, <strong>professional organisations</strong> and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. <strong>CPD certified certificates</strong> are <strong>accepted</strong> by thousands of <strong>professional bodies</strong> and <strong>government regulators</strong> here in the <strong>UK</strong> and <strong>around the world</strong>.</p> <p>Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this professional Arduino data visualisation using Python course will set you up with a solid foundation to become a confident Python progammer or electronic and electrical engineer and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a Python progammer or electronic and electrical engineer.</p> <p>The professional Arduino data visualisation using Python course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a Python progammer or electronic and electrical engineer.</p> <p>This comprehensive professional Arduino data visualisation using Python course is the perfect way to kickstart your career in the field of Arduino data visualisation. This professional Arduino data visualisation using Python course will give you a competitive advantage in your career, making you stand out from all other applicants and employees.</p> <p>If you're interested in working as a Python progammer or electronic and electrical engineer or want to learn more skills on Arduino data visualisation but unsure of where to start, then this professional Arduino data visualisation using Python course will set you up with a solid foundation to become a confident Python progammer or electronic and electrical engineer and develop more advanced skills.</p> <p>As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This professional Arduino data visualisation using Python course is crafted by industry experts, to enable you to learn quickly and efficiently, and at your own pace and convenience.</p> <h3>Who should take this course?</h3> <p>This comprehensive professional Arduino data visualisation using Python<strong> </strong>course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Arduino data visualisation.</p> <h3>Entry Requirements</h3> <ul> <li>There are no academic entry requirements for this professional Arduino data visualisation using Python<strong> </strong>course, and it is open to students of all academic backgrounds.</li> <li>As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol.</li> </ul> <h3>Career path</h3> <p>This professional Arduino data visualisation using Python<strong> </strong>course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry.</p><h2><b>Course Curriculum</b></h2> <div id="la-course-curriculum"> <div> <div>  Introduction <span></span>  <div> <div> <p>Introduction</p> <span></span> </div> <div> <p>Who We Are</p> <span></span> </div> <div> <p>Hardware and Software Requirements</p> <span></span> </div> </div> </div> <div>  Download and Install Software Section <span></span>  <div> <div> <p>Download and Install Arduino Pro IDE</p> <span></span> </div> <div> <p>Download and Install Python Editor</p> <span></span> </div> <div> <p>Download and Install Required Libraries</p> <span></span> </div> </div> </div> <div>  Python Coding to Control Arduino Pins <span></span>  <div> <div> <p>Python Coding to Control Pin Via Serial</p> <span></span> </div> <div> <p>Arduino Coding to Control Pin Via Serial</p> <span></span> </div> <div> <p>Running Python Script to Control the Pin</p> <span></span> </div> </div> </div> <div>  Python Coding to Control Arduino Pins <span></span>  <div> <div> <p>Python GUI with Button to Control Arduino Pins</p> <span></span> </div> </div> </div> <div>  Arduino Real-Time Plotting with Python <span></span>  <div> <div> <p>Arduino Real-Time Plotting with Python</p> <span></span> </div> </div> </div> <div>  Arduino Input/Output Control Via Python <span></span>  <div> <div> <p>Blink Simple Led Example with Python</p> <span></span> </div> <div> <p>Reading Digital Input and Sending Digital Output with Python</p> <span></span> </div> </div> </div> <div>  Extra <span></span>  <div> <div> <p>Installing Python and PIP</p> <span></span> </div> </div> </div> </div> </div><h2><b>Recognised Accreditation</b></h2> <div> <h3>CPD Certification Service</h3> <p>This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.</p> </div><h2><b>Certificate of Achievement</b></h2> <h3>Certificate of Achievement from Lead Academy</h3> <p>After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of Â£12, and there is an additional fee to obtain a printed copy certificate which is Â£35.</p> <p> </p><h2><b>FAQs</b></h2> <div id="accordionPanelsStayOpenExample"> <div> <h3 id="panelsStayOpen-heading21">  Is CPD a recognised qualification in the UK?  </h3> <div id="panelsStayOpen-collapse21"> <div> <p>CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading23">  Are QLS courses recognised?  </h3> <div id="panelsStayOpen-collapse23"> <div> <p>Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading25">  When will I receive my certificate?  </h3> <div id="panelsStayOpen-collapse25"> <div> <p>For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading27">  Can I pay by invoice?  </h3> <div id="panelsStayOpen-collapse27"> <div> <p>Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading29">  Can I pay via instalment?  </h3> <div id="panelsStayOpen-collapse29"> <div> <p>Yes, you can pay via instalments at checkout. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading31">  How to take online classes from home?  </h3> <div id="panelsStayOpen-collapse31"> <div> <p>Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading33">  Does age matter in online learning?  </h3> <div id="panelsStayOpen-collapse33"> <div> <p>No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons.</p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading35">  When I will get the login details for my course?  </h3> <div id="panelsStayOpen-collapse35"> <div> <p>After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org</p> </div> </div> </div> </div>

Lead Academy

Professional Arduino Data Visualisation using Python

Edinburgh

Leicester

<p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">P600 provides delegates with the necessary skills and knowledge to improve their understanding of Performance Measurements in LEV.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">For many this will act as a starting point in their progression towards a career in LEV. &nbsp;P600 can be taken by newcomers to the field of LEV or by less experienced LEV personnel as part of their progression towards a Level 4 qualification, eg&nbsp;<a href="https://www.oxyl8.com/product/p601-thorough-examination-and-testing-of-local-exhaust-ventilation-lev-systems/" target="_blank" rel="noopener" style="color: rgb(10, 78, 112); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(10, 78, 112);">P601</a>&nbsp;&ndash;&nbsp;<a href="https://www.oxyl8.com/product/p604-performance-evaluation-and-management-of-local-exhaust-ventilation-systems/" target="_blank" rel="noopener" style="color: rgb(10, 78, 112); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(10, 78, 112);">P604</a>&nbsp;series). P600 is a Level 3 course.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">It does not confer &lsquo;competency&rsquo; on the delegate to allow them to undertake stutory examinations and tests under CoSHH Reg 9.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">In general terms &ndash; by attending this P600 delegates will gain knowledge and understanding of the:-</p><ul style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li fr-original-style="" style="box-sizing: border-box;">Basic components of local exhaust ventilation systems.</li><li fr-original-style="" style="box-sizing: border-box;">Methodologies for undertaking the performance testing of LEV equipment</li><li fr-original-style="" style="box-sizing: border-box;">Qualitative visualisation techniques (smoke release/&rsquo;dust lamp&rsquo; etc).</li><li fr-original-style="" style="box-sizing: border-box;">Quantitative measurement techniques (anemometers, Pitot tubes etc).</li></ul>

OXYL8 Ltd

Energy Performance Certificate

Professional Skills Course (PSC)

Local Exhaust Ventilation (LEV)

FA Level 1

P600 is an introductory one-day LEV course

P600 LEV Methods for Testing Performance

P600 LEV 1 Day Course

<p>Are your reports and presentations <strong>boring</strong>? Do you wish to <strong> "animate"</strong> your data?</p><p>Tableau, a prominent <strong>visualisation program,</strong> will help your data problems to have an answer. You will acquire the knowledge necessary to master <strong>data visualisation</strong> in this Tableau introduction course.</p><p>This Tableau course gives you the <strong>confidence</strong> to discover the true value of your data by laying a foundation in data visualisation through a series of practical exercises. This Tableau course is designed for people who have never used Tableau before and are new to data visualisation. It makes use of Tableau's assortment of features to show best practices for <strong>data narrative and visualisation</strong>. You will learn how to connect datasets to Tableau, navigate the user interface, build interactive visualisations, and save and share your work in this course. You will learn how to employ each sort of visualisation in this course by going step by step through each one. By incorporating practical built-in functions, you will also learn how to create some fundamental formulas in the Tableau Calculation Language.</p><p><strong>Enrol real quickly</strong> to learn all there is to know about the Tableau - Crash Course, develop your talents in this area and feel secure in your knowledge base.</p><p><strong>Learning Outcome</strong></p><p>After completing this course successfully, you will be able to</p><ul><li>Learn how to create powerful dashboards and visualisations.</li><li>Ensure that Tableau is discovering the answers to your queries rather than creating new issues, prepare and clean your data</li><li>Understand how to create sophisticated visuals that convey complexity in a clear, appealing manner</li><li>Explore your data more thoroughly with clustering and distribution models that let you identify trends and make predictions</li><li>Discover how to utilise data storytelling to inform strategy and decision-making</li><li>Share dashboards and visualisations to foster an environment where data is accessible and appreciated</li></ul><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p><strong>Course Curriculum:</strong></p><ul><li>Section 1: Introduction to Tableau</li><li>Section 2: Connecting and Preparing Data</li><li>Section 3: Creating Charts and Calculations</li><li>Section 4: Building and Publishing Dashboards</li><li>Section 5: Build a Dashboard Analyzing Trumps Tweets about COVID-19</li></ul><p><strong>Course Assessment</strong></p><p>To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.</p><p>When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.</p><p><strong>Exam &amp; Retakes:</strong></p><p>It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.</p><p><strong>Certification</strong></p><p>Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).</p><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Anyone interested in starting a career in data science or a database is encouraged to apply. This course is really easy to understand, even if you are a total newbie with no prior knowledge. Additionally, if you already work in a related field, this course will be an excellent source of knowledge for you to develop your current skills.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Tableau - Crash course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Learners will be able to attain numerous valuable skills and the chance to gain after completing the Tableau - Crash course. With more help, you could advance in the following career:</p><ul><li>Tableau Developer</li><li>Data Analyst</li><li>Data Visualisation Developer</li><li>Tableau Developer - Data Analytics</li><li>Business Intelligence/Data Validation Analyst</li></ul>
                        </div>

One Education

Data Visualisation with Tableau Course

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This course is aimed at anyone currently working with data who is interested in using data visualisation to more effectively communicate their results.</p>Overview<p>At completion, delegates will understand how data visualisations can be best used to communicate actionable insights from data and be competent with the tools required to do it.</p><p>Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data.</p></div><div id="course-pills-2"><h4>Course Outline</h4><ul><li>The use of analytics, statistics and data science in business has grown massively in recent years. Harnessing the power of data is opening actionable insights in diverse industries from banking to horse breeding. The companies doing this most successfully understand that using sophisticated analytics approaches to unlock insights from data is only half the job. Communicating these insights to all of the different parts of an organisation is just as important as doing the actual analysis. Visualising data, and analytics results, is one of the most effective ways to achieve this. This course will cover the theory of data visualisation along with practical skills for creating compelling visualisations from data. To attend this course delegates should be competent in the use of data analysis tools such as reporting tools, spreadsheet software or business intelligence tools. The course will explore the following topics through a series of interactive workshop sessions:</li><li>Fundamentals of data visualisation</li><li>Data characteristics &amp; dimensions</li><li>Mapping visual encodings to data dimensions</li><li>Colour theory</li><li>Graphical perception &amp; communication</li><li>Interaction design</li><li>Visualisation different characteristics of data: trends, comparisons, correlations, maps, networks, hierarchies, text</li><li>Designing effective dashboards</li></ul></div>

Nexus Human

Big Data Analytics

Data Science

Data Skills

Effective Data Visualisation

<p><strong>Turn Your Dreams into Reality with the Excel Analyst - Excel Data Analysis and Visualisation Course Training course.</strong></p><p>This comprehensive <strong>Excel Analyst - Excel Data Analysis and Visualisation Course</strong> online course will equip you with the knowledge and skills you need to succeed in your chosen field. Whether you're a beginner or looking to take your career to the next level, this course has covered you.</p><p><strong>Key Learning Outcomes:</strong></p><ul><li>Understanding the core concepts and theories in your field</li><li>Building your knowledge and skills through practical, hands-on learning</li><li>Developing the ability to think critically and solve problems effectively</li><li>Enhancing your communication skills and the ability to work effectively with others</li><li>Gaining a competitive edge in your career and reaching your full potential</li></ul><p>With a flexible online format that allows you to learn at your own pace, <strong> Excel Analyst - Excel Data Analysis and Visualisation Course</strong> training course offers a convenient and accessible way to boost your career prospects.</p><p>So why wait? Enrol today and take the first step towards success!</p><p><strong>Vital Component of the </strong><strong>Excel Analyst - Excel Data Analysis and Visualisation Course </strong><strong>course:</strong></p><ul><li>CPD Accredited Course</li><li>Unlimited Retake Exam &amp; Tutor Support</li><li>Easy Accessibility to the Course Materials</li><li>100% Learning Satisfaction Guarantee</li><li>Lifetime Access &amp; 24/7 Support</li><li>Self-paced online course Modules</li><li>Covers to Explore Multiple Job Positions</li></ul><p>Transform your career with the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle! Perfect your skills and stand out in the employment market with our comprehensive training program. Impress potential employers and add valuable expertise to your resume. Don't wait-enrol in the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle now and take the first step towards a successful and fulfilling career!</p><p><strong>Course Outline:</strong></p><ul><li>Modifying a Worksheet</li><li>Working with Lists</li><li>Analyzing Data</li><li>Visualizing Data with Charts</li><li>Using PivotTables and PivotCharts</li><li>Working with Multiple Worksheets and Workbooks</li><li>Using Lookup Functions and Formula Auditing</li><li>Automating Workbook Functionality</li><li>Creating Sparklines and Mapping Data</li><li>Forecasting Data</li></ul><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        10 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is the perfect fit for anyone seeking to start or advance in the Excel Analyst - Excel Data Analysis and Visualisation Course industry. Whether you're a beginner or looking to expand your knowledge, this comprehensive training will provide you with the essential skills and expertise to succeed.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Join the Excitement-With this Excel Analyst - Excel Data Analysis and Visualisation Course course, there's no limit to what you can achieve. From day one, you'll be on your way to building a fulfilling career in this thriving field. No prior experience is required to enrol in this course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon completion, you'll have the opportunity to pursue a variety of in-demand Excel Analyst - Excel Data Analysis and Visualisation Course jobs, with endless possibilities for growth and success.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPD Accredited PDF Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
            <div><p><strong>CPD Accredited PDF Certificate</strong></p></div>
        <h4>CPD Accredited Hard Copy Certificate</h4>
        <p>
            Hard copy certificate -
            £10.79
        </p>
            <div><p><strong>CPD Accredited Hard Copy Certificate</strong></p><p><strong>Delivery Charge:</strong></p><p>Inside the UK: Free</p><p>Outside of the UK: £9.99 each</p></div>

                        </div>

Compliance Central

Excel Analyst - Excel Data Analysis and Visualisation Course

<p><span>Dive deep into the world of spreadsheet mastery with our '<strong>Data Analysis, Automating and Visualisation in Excel</strong>' course. This comprehensive programme takes you on a transformative journey from the rudiments of worksheet modifications to the advanced arts of data forecasting. Within each module, you'll unveil the secrets behind efficient list management, compelling visualisations, and the magic of PivotTables, among many other features. Moreover, automation isn't left behind; it's the heart and soul, making your workbook a living entity that breathes efficiency. By the end, you'll not only be fluent in Excel's vast toolkit but also possess the flair to present data in engaging, insightful ways.</span></p>
<p><strong><span>Learning Outcomes:</span></strong></p>
<ol>
<li><span>Master the art of efficient worksheet modification and effective list management.</span></li>
<li><span>Harness the power of data analysis tools to make informed decisions.</span></li>
<li><span>Craft compelling visuals using charts, Sparklines, and data mapping techniques.</span></li>
<li><span>Implement PivotTables and PivotCharts to dissect complex data sets effortlessly.</span></li>
<li><span>Automate workbook functionalities for optimised and streamlined processes.</span></li>
</ol>
<p> </p>
<div>
<span>Video Player</span><div id="mep_0"><div><div>https://studyhub.org.uk/wp-content/uploads/2021/03/Data-Analysis-Automating-and-Visualisation-in-Excel.mp4</div><div><div></div><div><div><span></span></div></div><div><div></div></div><div><div></div></div></div><div><div></div><div><span>00:00</span></div><div><span><span></span><span></span><span></span><span></span><span><span></span></span><span><span>00:00</span><span></span></span></span></div><div><span>00:00</span></div><div><span>Use Up/Down Arrow keys to increase or decrease volume.</span><div><div></div><div></div></div></div><div></div></div></div></div></div>
<h3></h3>
<h3><strong>Why buy this Data Analysis, Automating and Visualisation in Excel?</strong></h3>
<ol>
<li>Unlimited access to the course for a lifetime.</li>
<li>Opportunity to earn a certificate accredited by the <b>CPD Quality Standards</b><b> </b>after completing this course.</li>
<li>Structured lesson planning in line with industry standards.</li>
<li>Immerse yourself in innovative and captivating course materials and activities.</li>
<li>Assessments are designed to evaluate advanced cognitive abilities and skill proficiency.</li>
<li>Flexibility to complete the <b>Data Analysis, Automating and Visualisation in Excel</b> Course at your own pace, on your own schedule.</li>
<li>Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience</li>
</ol>
<h3><b>Who is this Data Analysis, Automating and Visualisation in Excel course for?</b></h3>
<ul>
<li><span>Individuals looking to enhance their data visualisation and analysis prowess.</span></li>
<li><span>Managers wanting a streamlined approach to handling large datasets.</span></li>
<li><span>Academic researchers aiming to present their data in a more compelling format.</span></li>
<li><span>Finance professionals seeking efficient ways to dissect and forecast financial data.</span></li>
<li><span>Marketing strategists aiming to leverage data for improved decision-making.</span></li>
</ul>
<h3><b>Career path</b></h3>
<ul>
<li><strong><span>Data Analyst:</span></strong><span> £30,000 - £50,000 per annum</span></li>
<li><strong><span>Financial Analyst:</span></strong><span> £35,000 - £55,000 per annum</span></li>
<li><strong><span>Market Research Analyst:</span></strong><span> £28,000 - £45,000 per annum</span></li>
<li><strong><span>Business Intelligence Analyst:</span></strong><span> £32,000 - £56,000 per annum</span></li>
<li><strong><span>Operations Analyst:</span></strong><span> £30,000 - £52,000 per annum</span></li>
<li><strong><span>Research Scientist (Data-oriented):</span></strong><span> £35,000 - £60,000 per annum</span></li>
</ul>
<h3><b>Prerequisites</b></h3>
<p><span>This </span><b>Data Analysis, Automating and Visualisation in Excel</b><span> does not require you to have any prior qualifications or experience. You can just enrol and start learning.This </span><b>Data Analysis, Automating and Visualisation in Excel</b><span> was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</span></p>
<h3><b>Certification</b></h3>
<p><span>After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.</span></p><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Modifying a Worksheet</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Insert, Delete, and Adjust Cells, Columns, and Rows</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Search for and Replace Data</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Proofing and Research Tools</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Lists</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Sort Data</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Filter Data</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Query Data with Database Functions</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Outline and Subtotal Data</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Analyzing Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Intermediate Conditional Formatting</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Advanced Conditional Formatting</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Visualizing Data with Charts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Charts</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Modify and Format Charts</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Advanced Chart Features</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Using PivotTables and PivotCharts</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create a PivotTable</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Analyze PivotTable Data</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Present Data with PivotCharts</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Filter Data by Using Timelines and Slicers</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Multiple Worksheets and Workbooks</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Links and External References</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use 3-D References</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Consolidate Data</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Using Lookup Functions and Formula Auditing</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use Lookup Functions</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Trace Cells</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Watch and Evaluate Formulas</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Automating Workbook Functionality</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Apply Data Validation</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Search for Invalid Data and Formulas with Errors</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Macros</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Creating Sparklines and Mapping Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Create Sparklines</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>MapData</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Forecasting Data</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Determine Potential Outcomes Using Data Tables</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Determine Potential Outcomes Using Scenarios</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Use the Goal Seek Feature</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Forecasting Data Trends</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Assignment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assignment - Data Analysis, Automating and Visualisation in Excel</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Studyhub UK

Microsoft Excel

Data Analysis, Automating and Visualisation in Excel

<p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Webinar - Full Recording</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);">This webinar will provide an interactive overview on the use of experiential imagery and visualisation techniques in the treatment of anxiety, depression, trauma and suicide management.</p><ol style="color: rgb(57, 54, 79); box-sizing: border-box;" fr-original-style=" color: rgb(57, 54, 79);"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">OVERVIEW</strong></li><li fr-original-style="" style="box-sizing: border-box;">Imagery and Thinking</li><li fr-original-style="" style="box-sizing: border-box;">Activation and Consolidation</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">TREATMENT</strong></li><li fr-original-style="" style="box-sizing: border-box;">Basic imagery techniques for all clients</li><li fr-original-style="" style="box-sizing: border-box;">Imagery Techniques for anxiety, depression and anger</li><li fr-original-style="" style="box-sizing: border-box;">Imagery Techniques for PTSD</li><li fr-original-style="" style="box-sizing: border-box;">Imagery techniques for Compassion Focused Therapy</li><li fr-original-style="" style="box-sizing: border-box;">Imagery Techniques in Suicide prevention</li><li fr-original-style="" style="box-sizing: border-box;">Implementation for your practice.</li><li fr-original-style="" style="box-sizing: border-box;">Imagery techniques applied to ourselves as therapists</li><li fr-original-style="" style="box-sizing: border-box;">Summary</li></ol><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What is the workshop about?</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This workshop will cover the the role of imagery in maintaining psychological distress and the use of visualisation-based techniques in therapeutic practice. There will be practical demonstrations and the opportunity to apply key techniques to therapists ourselves.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who should attend?</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">This workshop is aimed at therapists, counsellors, advisers, educationalists, health care workers, social workers and students in these areas. It is particularly useful for counsellors who do not normally work within a cognitive or behavioural model but want to explore tried and tested techniques. Similarly, counsellors and therapists working within this tradition are likely to find this workshop a useful refresher in the latest approaches. It is also suitable for anyone with an interest in contemporary practice in this area.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What have previous delegates said about this workshop?</strong></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Particularly interesting to apply visualisation techniques to ourselves as therapists.</li><li fr-original-style="" style="box-sizing: border-box;">Excellent . Very interesting .Thank you .</li><li fr-original-style="" style="box-sizing: border-box;">I am newly qualified and though I have used imagery before, my experience is not that broad, so this was very helpful to understand how useful it can be across different disorders and also for me as a therapist.</li><li fr-original-style="" style="box-sizing: border-box;">Excellent pacing, very resourceful and easy to understand. Lots of practical ideas to use for practice. Thank you!</li><li fr-original-style="" style="box-sizing: border-box;">I loved this workshop, it was informative and give me more ideas as to how to use imagery. I feel more confident about using imagery in my role</li><li fr-original-style="" style="box-sizing: border-box;">Informative, good ideas</li><li fr-original-style="" style="box-sizing: border-box;">Engaging, well paced and informative. I&#39;m a qualified CBT therapist and found this really increased my knowledge giving particular skills and ways of delivering.</li><li fr-original-style="" style="box-sizing: border-box;">Very enjoyable and informative. I got new ideas for use of visualisation work with clients and also for my own self reflection. Thank you!</li><li fr-original-style="" style="box-sizing: border-box;">This was a very informative workshop. I will use it in my practice</li><li fr-original-style="" style="box-sizing: border-box;">I found it great, and I have used visualisation in a small way but feel I can approach with more confidence.</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Resources</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">A full set of slides with extensive clickable links to online resources, is sent free to all delegates after the event. This also includes references to key sources.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who is leading this webinar?</strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Professor Patrick McGhee is a CBT therapist, psychologist and UK National Teaching Fellow. Educated at the universities of Glasgow and Oxford, he has completed CPD programmes at Harvard Business School and Ashridge. In 2017 he was a Visiting Fellow/Scholar at the universities of Cornell, Yale and MIT in the USA. He has taught, researched or practised in psychology and therapy for 30 years. His first post was a Research Fellow in Psychiatry and Psychology at St George&#39;s Hospital Medical School, University of London. He is the author of Thinking Psychologically (Palgrave) and co-editor of Accounting for Relationships (Methuen). He is an occasional columnist for the Guardian, the BBC and the Times Higher. He currently works in private practice in Greater Manchester. He has full accreditation from the British Association for Behavioural and Cognitive Psychotherapists.</p><p fr-original-style="" style="font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p>

15 Courses in Bradford

Power BI - intermediate (2 day) (In-House)

By The In House Training Company

Introduction to Data Science - free for Medway residents

By futureCoders SE

Power BI - introduction to intermediate (2 days) (In-House)

By The In House Training Company

Tableau Desktop Training - Foundation

By Tableau Training Uk

Power BI - introduction (2 day) (In-House)

By The In House Training Company

Search By Location