Harlow

Hoddesdon

Microsoft Power BI training courses at Introduction and Intermediate levels.
Click on the link below to view full details:
Power BI courses

Enliten IT

Microsoft Power BI

Power Query

Data Visualization

Business Intelligence (BI)

Powerpivot

Merseyside, 

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our regionally-based associate Power BI trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.<br id="isPasted" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">One of our trainers will speak to you about the scope of your requirement and course lengths may vary depending upon your needs.</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;">Course Outlines</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/power-bi-beginners-course.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Power BI Beginners (Online Service Version) - 1 day course</a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/power-bi-intermediate-course.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Power BI Beginners / Intermediate (Desktop version) - 2 day course</a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/power-bi-advanced-course.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Power BI Advanced (Desktop Version) - 3 day course</a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/power_platform_master_class_training.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Power Platform Masterclass (Power BI, Power Automate and Power Apps) - 5 day course</a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></li></ul><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;">Pricing</strong><br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">&pound;800.00 plus VAT per day for up to 6 learners and &pound;125.00 plus VAT per day to cover travel and accommodation within mainland UK. Just add &pound;50.00 plus VAT per additional learner up to the 10 delegate maximum.</p>

FourSquare Innovations Ltd

FourSquare Training specialise in private, corporate Power BI courses delivered at your premises and tailored to your needs.

Power BI Training

London

<p>This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and  data Modelling, to create Visualizations, and publish Reports to different platforms<br />.</p> <p><strong>Course Objectives</strong></p> <p>At the end of this course you will be able to:</p> <ul> <li>Connect to data from different sources.</li><li>Use the Query Editor</li><li>Perform Power BI desktop data Shaping and Transformation.</li><li>Create Power BI desktop Modelling.</li><li>Create Power BI desktop Visualizations and Reports.</li></ul> <p>' 1 year email support service</p> <p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p> <p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level and Business Intelligence.</p> <p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p> <ul> <li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul> <p><strong><strong>Tailored training courses:</strong></strong></p> <p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p> <p>Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in.</p><p><strong>Introduction to Power BI</strong></p> <ul> <li>Power BI Jargon explained</li><li>A quick look at Power BI Desktop</li><li>A quick look at the Power BI service</li><li>Helpful resources</li></ul> <p><strong>Power BI and Excel</strong></p> <ul> <li>Introduction to using Excel data in Power BI</li><li>Upload Excel data to Power BI</li><li>Import Power View and Power Pivot to Power BI</li></ul> <p><strong>Getting started with Power BI Desktop</strong></p> <ul> <li>Overview of Power BI Desktop</li><li>Accessing Help and Helpful resources</li><li>Connect to data sources in Power BI Desktop</li></ul> <p><strong>Shaping and Transforming Data with Query Editor</strong></p> <ul> <li>Introduction to the Query Editor</li><li>Data Sources Power BI Desktop can Connect to</li><li>Introduction to Steps and M code</li><li>Combining Data Using Merge and Append Queries</li><li>Data Type Properties</li><li>Working with Delimiters</li><li>Clean and transform your data with the Query Editor</li><li>Text Specific Transformation Tools</li><li>Number Specific Transformation Tools</li><li>Date Specific Transformation Tools</li><li>Split and Merge columns</li><li>Creating an Index Column</li><li>Adding Conditional Columns</li><li>Columns From Examples</li><li>Grouping and Aggregating data</li><li>Pivoting and Unpivoting</li><li>Using filters</li></ul> <p><strong>Modeling the data</strong></p> <ul> <li>Introduction to modeling your data</li><li>How to manage your data relationships</li><li>Create calculated columns</li><li>Optimizing data models</li><li>Create calculated measures</li><li>Show Values As and Quick Measures</li><li>Create calculated tables</li><li>Explore your time-based data</li><li>Introduction to DAX</li><li>DAX calculation types</li><li>DAX functions</li></ul> <p><strong>Visualizations</strong></p> <ul> <li>Introduction to visuals in Power BI</li><li>Create and customize simple visualizations</li><li>Modify colors in charts and visuals</li><li>Shapes, text boxes, and images</li><li>Page layout and formatting</li><li>Group interactions among visualizations</li><li>Visual hierarchies and drill-down</li><li>Using custom visualizations</li><li>Create a KPI Visualization</li><li>Geo-Data and Maps</li></ul> <p><strong>Reports, Publishing and Sharing</strong></p> <ul> <li>Introduction to the Power BI service</li><li>Quick insights in Power BI</li><li>Create and configure a dashboard</li><li>Ask questions of your data with natural language</li><li>Create custom Q&amp;A suggestions</li><li>Share dashboards with your organization</li><li>Introduction to content packs, security, and groups</li><li>Publish Power BI Desktop reports</li><li>Print and export dashboards and reports</li><li>Create groups in Power BI</li><li>Use content packs</li><li>Update content packs</li><li>Publish to web</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create  Visualizations, and publish Reports to different platforms.</p> 
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Before attending this course, delegates should have:<br />- A general knowledge of database concepts (fields, records and relationships)<br />- Familiarity with Excel.</p> 
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Business Intelligence<br /><br />Data Analysis<br /><br />ETL &amp; Data Warehousing</p> 
                        </div>

Microsoft Office Training

Microsoft Power BI Desktop In-company (now with live online classes)

General Admission

<div fr-original-style="" style="box-sizing: border-box;">
</div>
<section fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<h2 fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">About this Training Course</strong><em fr-original-style="" style="box-sizing: border-box;">&nbsp;</em></h2>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This 3 full-day training course will introduce participants to the Microsoft Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;software solution for extracting, manipulating, visualising and analysing data. This is a very practical, hands-on course that takes participants through a series of exercises which help users understand the Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;environment, how to use the key areas of functionality, and how to apply the tools it contains to design and produce analyses of their own data.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The first two days focus on learning the key concepts and practising these using clean, simple datasets.&nbsp;The third day provides participants with the opportunity to apply what they&#39;ve learned to their own data. This makes the course far more relevant and meaningful for them, it allows our facilitator to help them structure their data models, queries and DAX formulas correctly, and it allows our facilitator to help them solve any additional problems that may arise but which were not covered as part of the standard the course. In addition, at the end of the day, each participant walks away with something of real, practical use for their job role. Many previous participants have remarked that they obtained the most value from the course during the third day because otherwise, they wouldn&#39;t be able to do what they need to do.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is an introductory course and although it does not assume any prior experience with Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>, participants will gain much more from the course if they have at least used Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;a little prior to attending. Participants who have taught themselves Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included.</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;"><em fr-original-style="" style="box-sizing: border-box;">Microsoft&reg;&nbsp;PowerBI&reg; is a&nbsp;trademark&nbsp;of Microsoft Corporation in the United States and/or other countries.</em></strong></p>
</div>
</section>
<section fr-original-style="" style="box-sizing: border-box;">
<div id="accordion" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Training Objectives 

</div>
<div id="collapseOne" fr-original-style="" style="box-sizing: border-box;">
<div 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;">Upon completion of this training course, participants will be able to:</p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Confidently use the Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;solution, including Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;Desktop, PowerBI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>.com and the Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;Gateway</li>
<li fr-original-style="" style="box-sizing: border-box;">Extract data from a variety of data sources and manipulate the data extracted so it is ready for analysis</li>
<li fr-original-style="" style="box-sizing: border-box;">Combine data sources together and gain an introductory understanding of the M language</li>
<li fr-original-style="" style="box-sizing: border-box;">Write formulas using the DAX language for generating custom columns, measures and tables</li>
<li fr-original-style="" style="box-sizing: border-box;">Design reports and dashboards using a wide range of both built-in and custom visuals</li>
<li fr-original-style="" style="box-sizing: border-box;">Publish reports and dashboards to PowerBI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>.com</li>
<li fr-original-style="" style="box-sizing: border-box;">Share reports and dashboards with others using PowerBI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>.com</li>
<li fr-original-style="" style="box-sizing: border-box;">Customize reports and dashboards so that different user groups automatically see their own personalized views</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Target Audience 

</div>
<div id="collapseTwo" fr-original-style="" style="box-sizing: border-box;">
<div 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;">This training course is intended for:</p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Financial Analysts</li>
<li fr-original-style="" style="box-sizing: border-box;">Accountants</li>
<li fr-original-style="" style="box-sizing: border-box;">Budgeting and planning specialists</li>
<li fr-original-style="" style="box-sizing: border-box;">Treasury</li>
<li fr-original-style="" style="box-sizing: border-box;">Risk Managers</li>
<li fr-original-style="" style="box-sizing: border-box;">Strategic Planners</li>
</ul>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This is an introductory course and although it does not assume any prior experience with Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>, participants will gain much more from the course if they have at least used Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;a little prior to attending. Participants who have taught themselves Power BI<sup fr-original-style="" style="box-sizing: border-box;">&reg;</sup>&nbsp;will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included.</p>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Course Level 

</div>
<div id="collapsecl" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Basic or Foundation</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Trainer

</div>
<div id="collapseFive" fr-original-style="" style="box-sizing: border-box;">
<div 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;">Your expert course leader has a Masters (Applied Finance &amp; Investment), B.Comm (Accounting &amp; Information Systems), CISA, FAIM, F Fin and is a Microsoft Certified Excel Expert. He has over 20 years&#39; experience in financial modelling, forecasting, valuation, model auditing, and management reporting for clients throughout the world. He is skilled in the development and maintenance of analytical tools and financial models for middle-market companies to large corporates, at all levels of complexity, in both domestic and international settings.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">He has trained delegates from a wide variety of Oil &amp; Gas companies including Chevron, Woodside, BHP Billiton, Petronas, Carigali, Shell, Nippon, Eni, Pertamina, Inpex, and many more. He provides training in financial modelling for companies throughout the Asia, Oceania, Middle East and African regions.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Before his current role, he spent 6 years working in the Corporate and IT Consulting divisions of a large, multinational Chartered Accounting firm.</p>
<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">He is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing.</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;">Highlights from his oil and gas experience include:</strong></p>
<ul fr-original-style="" style="box-sizing: border-box;">
<li fr-original-style="" style="box-sizing: border-box;">Development of economic models to assist Decision Analysts modelling for a wide range of scenarios for multinational oil &amp; gas assets.</li>
<li fr-original-style="" style="box-sizing: border-box;">Auditing and further development of life of project models for Chevron&#39;s Strategic Planning Division analysing their North West Shelf assets.</li>
<li fr-original-style="" style="box-sizing: border-box;">Development of business plan and budgeting models for multinational oil &amp; gas assets.</li>
<li fr-original-style="" style="box-sizing: border-box;">Development of cash flow and taxation models for a variety of oil gas companies.</li>
<li fr-original-style="" style="box-sizing: border-box;">Consulting on Sarbanes Oxley spreadsheet remediation and risk assessment.</li>
</ul>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

POST TRAINING COACHING SUPPORT (OPTIONAL)

</div>
<div id="collapseCS" fr-original-style="" style="box-sizing: border-box;">
<div 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;">To further optimise your learning experience from our courses, we also offer individualized &#39;One to One&#39; coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.<br fr-original-style="" style="box-sizing: border-box;">
Request for further information post training support and fees applicable</p>
</div>
</div>
</div>
<div fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">

Accreditions And Affliations

</div>
<div id="collapseSeven" fr-original-style="" style="box-sizing: border-box;">
<div fr-original-style="" style="box-sizing: border-box;">
               </div>
</div>
</div>
</div>
</section>

EnergyEdge - Training for a Sustainable Energy Future

Renewable Energy

Oil & Gas

Power BI® - Business Data Analytics

Team of 10, pp

Normal Fee, pp

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

Excel Analytics

Microsoft Power Platform

Microsoft BI

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

<p>Power BI is a powerful data visualisation program that allows businesses to monitor data, analyse trends, and make decisions. This course is designed to provide a solid understanding of the reporting side of Power BI, the dashboards, where administrators, and end users can interact with dynamic visuals that communicates information.</p><p>This course focuses entirely on the creation and design of visualisations in dashboards, including a range of chart types, engaging maps, and different types of tables. Designing dashboards with KPI's (key performance indicators), heatmaps, flowcharts, sparklines, and compare multiple variables with trendlines.</p>This one-day programme focuses entirely on creating dashboards, by using the many visualisation tools available in Power BI.<p>You will learn to build dynamic, user-friendly interfaces in both Power BI Desktop and Power BI Service.</p><section>
                    <h3>1 Introduction</h3><ul><li>Power BI ecosystem</li><li>Things to keep in mind</li><li>Selecting dashboard colours</li><li>Importing visuals into Power BI</li><li>Data sources for your analysis</li><li>Joining tables in Power BI</li></ul> <h3>2 Working with data</h3><ul><li>Utilising a report theme</li><li>Table visuals</li><li>Matrix visuals</li><li>Drilling into hierarchies</li><li>Applying static filters</li><li>Group numbers with lists</li><li>Group numbers with bins</li></ul> <h3>3 Creating visuals</h3><ul><li>Heatmaps in Power BI</li><li>Visualising time-intelligence trends</li><li>Ranking categorical totals</li><li>Comparing proportions</li><li>View trends with sparklines</li></ul> <h3>4 Comparing variables</h3><ul><li>Insert key performance indicators (KPI)</li><li>Visualising trendlines as KPI</li><li>Forecasting with trendlines</li><li>Visualising flows with Sankey diagrams</li><li>Creating a scatter plot</li></ul> <h3>5 Mapping options</h3><ul><li>Map visuals</li><li>Using a filled map</li><li>Mapping with latitude and longitude</li><li>Mapping with ArcGIS or ESRI</li></ul> <h3>6 Creating dashboards</h3><ul><li>High-level dashboard</li><li>Migration analysis dashboard</li><li>Adding slicers for filtering</li><li>Promote interaction with nudge prompts</li><li>Searching the dashboard with a slicer</li><li>Creating dynamic labels</li><li>Highlighting key points on the dashboard</li><li>Customised visualisation tooltips</li><li>Syncing slicers across pages</li></ul> <h3>7 Sharing dashboards</h3><ul><li>Setting up and formatting phone views</li><li>Exporting data</li><li>Creating PDF files</li><li>Uploading to the cloud</li><li>Share dashboards in SharePoint online</li></ul> 


                </section>

Tableau Desktop Specialist

Microsoft Power Apps

Power BI - dashboards (1 day) (In-House)

<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>

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

<p>This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code.</p><p>This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references.</p>This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables.<section>
                    <h3>1 The query editor</h3><ul><li>Split by row delimiter</li><li>AddDays to determine deadlines</li><li>Advanced 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 Logical column functions</h3><ul><li>Logical functions IF, AND, OR</li><li>Using multiple conditions</li><li>Including FIND in functions</li></ul> <h3>4 Editing DAX measures</h3><ul><li>Make DAX easier to read</li><li>Add comments to a measure</li><li>Using quick measures</li></ul> <h3>5 The anatomy of CALCULATE</h3><ul><li>Understanding CALCULATE context filters</li><li>Adding context to CALCULATE with FILTER</li><li>Using CALCULATE with a threshold</li></ul> <h3>6 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 percentage</li></ul> <h3>7 DAX iterators</h3><ul><li>Anatomy of iterators</li><li>A closer look at SUMX</li><li>Using RELATED in SUMX</li><li>Create a RANKX</li><li>RANKX with ALL</li></ul> <h3>8 Date and time functions</h3><ul><li>Overview of functions</li><li>Create a DATEDIFF function</li></ul> <h3>9 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>10 Visualisations in-depth</h3><ul><li>Utilising report themes</li><li>Create a heatmap</li><li>Comparing proportions</li><li>View trends with sparklines</li><li>Group numbers using bins</li><li>Setting up a histogram</li></ul> <h3>11 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> <h3>12 User level security</h3><ul><li>Setting up row level security</li><li>Testing user security</li></ul> 


                </section>

Power BI - advanced (1 day) (In-House)

<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)

Bicester

Birmingham

Bolton

Bradford

Bristol

Cambridge

Coalville

Coventry

Derby

Gloucester

Huddersfield

Kettering

Leeds

Leicester

Liverpool

Luton

Lutterworth

Manchester

Middlesbrough

Milton Keynes

Newbury

Northampton

Norwich

Nottingham

Oxford

Peterborough

Reading

Runcorn

Sheffield

Slough

Solihull

Stoke-on-Trent

Swindon

Telford

Trowbridge

Warrington

Watford

Wolverhampton

York

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our regionally-based associate Microsoft PowerPoint trainers come to your organisation to deliver the training when you need and at the level you require. Or, opt for live virtual classroom courses delivered via Microsoft Teams.</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;">Course Outlines</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/powerpoint_training_course_in_leeds.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Microsoft PowerPoint Beginners - 1 day course</a></li><li fr-original-style="" style="box-sizing: border-box;"><a href="https://www.foursquaretraining.co.uk/training_course_pages/powerpoint_training_manchester_liverpool.html#topics" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Microsoft PowerPoint Advanced - 1 day course</a><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></li></ul><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;">Pricing</strong><br fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">&pound;450.00 plus VAT and mileage for up to 3 learners. Just add &pound;50.00 plus VAT per additional learner up to the 10 delegate maximum.</p>

Office Skills & Productivity

Office Skills

Content Design

Microsoft Powerpoint

FourSquare Training specialise in private, corporate Microsoft PowerPoint courses delivered at your premises and tailored to your needs.

Microsoft PowerPoint Training

Training 4 Microsoft Crm

1 Educators providing Microsoft Power BI courses in Bristol

training 4 microsoft crm

Bath

Courses matching "Microsoft Power BI"

Microsoft Power BI

By Enliten IT

Power BI Training

By FourSquare Innovations Ltd

Microsoft Power BI Desktop In-company (now with live online classes)

By Microsoft Office Training

Power BI® - Business Data Analytics

By EnergyEdge - Training for a Sustainable Energy Future

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

By The In House Training Company

Power BI - dashboards (1 day) (In-House)

By The In House Training Company

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

By The In House Training Company

Power BI - advanced (1 day) (In-House)

By The In House Training Company

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

By The In House Training Company

Microsoft PowerPoint Training

By FourSquare Innovations Ltd

Search By Location