74 Business Intelligence (BI) courses in Cardiff delivered Live Online

OVERVIEW Prerequisites—this is a day of supervised revision for anyone who wishes to take the PL-300 exam so we expect you to have attended a PL-300 course, either taught or on your own, before attending this day of revision. We are happy for attendees to join the course if you have taken the PL-300 with us or with another provider. In the morning we look at questions from the PL-300 exam, grouped by subject area. For each question we show you the correct answer and then explain why that is the correct answer. After lunch everyone tries a practice exam under exam conditions and we finish the day with clarification on the subjects or specific questions that the class is finding hard. The cost of the course includes a free voucher to take the exam, so please don’t buy your own separately. If you do so we cannot reimburse you with the cost of the exam. COURSE BENEFITS: Discover the parts of the course on which to focus most attention Become familiar with the styles and formats of the exam questions Alert yourself to some of the particularly tricky questions Familiarise yourself with the style of the 'case study' question Practice an exam under real exam conditions Get a feel for the time you need to devote to the normal questions and to the case study WHO IS THE COURSE FOR? Power BI report developers who need PL-300 Certification to apply for a job Business Intelligence specialists who wish to enhance their career prospects with a PL-300 Certification Anyone who wishes to maximise their chances of passing the PL-300 Power BI Data Analyst exam COURSE OUTLINE Module 1 Structure Of The Exam Registration for the exam and setup of your workspace The percentage of marks devoted to each subject area Types of questions used in the exam Advised timing for the normal questions and for the case study question Module 2 Individual Exam Question Practice The exam questions are divided into subject areas and for each question… We consider the question and try to answer it We view the answer Where necessary, we look at an in-depth explanation of why that is the correct answer Examine case study questions and how to treat these differently from the normal questions Module 3 Practice Exam Under Exam Conditions Attendees take a practice exam Attendees receive a mark, broken down into subject areas Module 4 Exam Question Practice Focussed On Tricky Areas Together, based on the results of attendees’ exam results we decide which areas on which to focus More practice on individual exam questions using the same style as in Module 2

SQL Queries Course, 1-Day. Basic SQL syntax. This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. Private individuals are also very welcome.

Duration 1 Days 6 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who receive Power BI data visualizations and reports from data analysts or from data visualization engineers. These data report recipients want to use the features and capabilities of Power BI to fully explore the visualizations and initial analyses provided to them in reports, perform additional analysis to ask next-level questions of the data, and to customize and create new visualizations and dashboards in order to share new insights and create compelling reports. Overview Explore Power BI reports. Analyze data to get answers and insights. Sort and group data for analysis and reporting. Filter visualizations. Prepare reports. Troubleshoot, collaborate, and share reports. As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Microsoft Power BI software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed to business data decision makers. These decision makers can use Power BI's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings. Prerequisites To ensure your success in this course, you have experience managing data with Microsoft Excel or Google Sheets 1. Exploring Power BI Reports Topic A: Data Analysis Workflow with Power BI Topic B: Explore Reports in the Power BI Service Topic C: Edit Reports 2. Analyzing Data to Get Answers and Insights Topic A: Configure Data Visualizations Topic B: Ask New Questions by Changing Aggregation Topic C: Find Answers with Calculations 3. Sorting and Grouping Data for Analysis and Reporting Topic A: Sort Data Topic B: Group Data 4. Filtering Visualizations Topic A: Filter Data to Refine Analysis Topic B: Create Slicers for Reports 5. Preparing Reports Topic A: Format and Annotate Reports Topic B: Emphasize Data in Reports 6. Troubleshooting, Sharing, and Collaborating Topic A: Troubleshoot Data Issues Topic B: Collaborate in Power BI Topic C: Collaborate with Non-Power BI Users

Course Overview The DeepSeek Masterclass: A Complete DeepSeek Zero to Hero! provides a comprehensive exploration of the DeepSeek AI ecosystem, designed to guide learners from fundamental understanding to advanced applications. This course equips individuals with the knowledge to navigate the capabilities of DeepSeek across various domains such as software development, business analysis, and education. Whether you're looking to stay current in a rapidly evolving technological landscape or explore how AI transforms diverse sectors, this course offers a structured pathway. By the end of the programme, learners will be able to understand DeepSeek’s architecture, apply its tools across multiple contexts, and critically evaluate its potential within both technical and professional settings. Course Description This course delves into the foundational principles and progressive applications of DeepSeek, starting from basic concepts in artificial intelligence through to its tailored use in education, business, and software environments. Learners will explore how to configure and interpret DeepSeek outputs, understand the structure of AI decision-making, and evaluate its integration across various workflows. Key modules address the needs of developers, educators, students, and professionals seeking efficient AI-driven solutions. Throughout the course, learners will be introduced to scenario-based uses of DeepSeek, helping them build a contextual understanding of its functions. The curriculum is designed to support strategic thinking, digital literacy, and informed adoption of AI tools in both academic and professional environments. Course Modules Module 01: Getting Started Module 02: Foundations of Artificial Intelligence (AI) Module 03: Setting up DeepSeek AI for Beginners Module 04: DeepSeek for Software Developers Module 05: DeepSeek for Business Professionals Module 06: DeepSeek Smart Solutions for Students Module 07: The Power of DeepSeek Module 08: DeepSeek for Teaching Professionals (See full curriculum) Who is this course for? Individuals seeking to build an informed understanding of DeepSeek and AI. Professionals aiming to implement AI solutions within their field. Beginners with an interest in artificial intelligence and its uses. Educators, students, and technologists exploring innovative learning and working tools. Career Path AI Integration Analyst Business Intelligence Associate Education Technology Consultant Software Solution Strategist Digital Transformation Specialist AI Literacy Educator

Course Overview This comprehensive Data Analytics course provides an in-depth exploration of data analysis, covering the essential principles and techniques used to extract valuable insights from data. Learners will engage with core concepts, such as data mining, statistical analysis, and visualisation, enabling them to make informed decisions and drive business outcomes. By the end of the course, participants will have the skills to analyse and interpret data, apply analytical tools effectively, and present their findings clearly. This course equips learners with the necessary tools to understand and leverage data in various professional settings, adding significant value to their career prospects. Course Description The Data Analytics course covers a wide range of topics, including the fundamentals of data analysis, statistical methods, and various data visualisation techniques. Learners will explore essential tools such as Excel and specialised software, while gaining a deep understanding of how to collect, store, and process data effectively. Emphasis is placed on developing the analytical mindset required to interpret data accurately and draw actionable insights. This course is designed to ensure learners can confidently navigate the world of data analytics and apply their knowledge in diverse industries, enhancing their problem-solving and decision-making abilities. Course Modules Module 01: Introduction to the World of Data Module 02: Basics of Data Analytics Module 03: Statistics for Data Analytics Module 04: Actions Taken in the Data Analysis Process Module 05: Gathering the Right Information Module 06: Storing Data Module 07: Data Mining Module 08: Excel for Data Analytics Module 09: Tools for Data Analytics Module 10: Data-Analytic Thinking Module 11: Data Visualisation That Clearly Describes Insights Module 12: Data Visualisation Tools (See full curriculum) Who is this course for? Individuals seeking to enhance their analytical skills for data-driven decision-making. Professionals aiming to transition into data analytics or enhance their data-related roles. Beginners with an interest in understanding data and its applications across industries. Business professionals seeking to leverage data for strategic growth. Career Path Data Analyst Business Intelligence Analyst Data Scientist Market Research Analyst Operations Analyst Financial Analyst Business Analyst Data Visualisation Specialist

Course Overview This "Microsoft Power BI - Master Power BI in 90 Minutes!" course offers a concise yet comprehensive introduction to Power BI, empowering learners to quickly create and manage data dashboards. The course is designed for both newcomers and those looking to enhance their skills, covering essential topics to help users understand and utilise Power BI for data analysis and reporting. Upon completion, learners will gain the ability to design dynamic dashboards, manipulate data, and visualise trends, providing valuable insights for decision-making in various business environments. Course Description This course takes learners through Power BI’s core functionalities, starting with an introduction to the platform before advancing to building basic and sophisticated dashboards. Learners will explore key aspects such as data import, filtering, and the creation of interactive visuals. By working with live data, participants will develop an understanding of how to generate real-time reports, enhancing their ability to analyse data and derive insights. The course offers both beginner and advanced concepts, ensuring that all participants can apply what they’ve learned to real-world data scenarios. Upon completing the course, learners will feel confident in their ability to utilise Power BI to its full potential in any business context. Course Modules Module 01: Power BI - Introduction Module 02: Your First Power BI Dashboard Module 03: Your Advanced Power BI Dashboard with Real Live Data Module 04: Course Bonuses (See full curriculum) Who is this course for? Individuals seeking to enhance their data analysis skills. Professionals aiming to improve data visualisation and reporting capabilities. Beginners with an interest in business intelligence or data management. Anyone looking to gain insights into data-driven decision-making. Career Path Business Intelligence Analyst Data Analyst Data Visualisation Specialist Marketing Data Analyst Financial Analyst

Microsoft Power BI Training Course Overview: The Microsoft Power BI Training course is designed to equip learners with the knowledge and skills to use Power BI effectively for data analysis and reporting. This course covers the core features of Power BI, from data import and transformation to the creation of reports and visualizations. Learners will explore how to analyse data, generate insights, and create dynamic dashboards for reporting purposes. Whether you are looking to improve your analytical skills or advance your career, this course provides the foundation needed to become proficient in using Power BI for various data analysis tasks. By the end of the course, learners will be able to handle large data sets, create compelling visual reports, and make data-driven decisions. Course Description: This comprehensive Microsoft Power BI course delves into the essential components of the Power BI platform. Learners will start by exploring how to import and work with data, before progressing to designing reports and visualizations. The course includes an in-depth look at the various types of visualizations available, enabling learners to display data in an intuitive, easy-to-understand format. Additionally, learners will explore the Power BI Web App to access and share their reports online. As they move through the course, participants will gain valuable skills in data transformation, reporting, and visualization, all of which are applicable to industries requiring data-driven decision-making. By completing this course, learners will have a solid understanding of Power BI and the ability to create impactful reports and dashboards for business or personal use. Microsoft Power BI Training Curriculum: Module 01: Getting Started Module 02: Working with Data Module 03: Working with Reports and Visualizations Module 04: A Closer Look at Visualizations Module 05: Introduction to the Power BI Web App (See full curriculum) Who is this course for? Individuals seeking to understand Power BI and data analysis. Professionals aiming to enhance their data reporting skills. Beginners with an interest in business intelligence and data analytics. Anyone looking to improve their ability to visualise data for better decision-making. Career Path: Data Analyst Business Intelligence Analyst Reporting Specialist Data Visualisation Specialist Business Analyst

Excel Vlookup, Xlookup, Match and Index Course Overview: This comprehensive course covers essential Excel functions such as VLOOKUP, XLOOKUP, MATCH, and INDEX, which are integral for efficient data management and analysis. Learners will gain a clear understanding of how to use these functions to simplify complex data tasks, enhance productivity, and improve decision-making. Throughout the course, students will master how to search, match, and retrieve data from large datasets, preparing them for real-world scenarios in finance, marketing, HR, and more. The course is designed to equip learners with the necessary skills to perform advanced Excel functions with confidence, contributing to their professional growth and data analysis expertise. Course Description: In this course, learners will explore the powerful functions of Excel, including VLOOKUP, XLOOKUP, MATCH, and INDEX, enabling them to perform efficient data searches, cross-referencing, and information retrieval. The course includes step-by-step lessons on how to apply these functions to real-world datasets, making it highly relevant for anyone working with large volumes of data. Learners will become proficient in building dynamic spreadsheets that streamline decision-making processes and improve data accuracy. Additionally, this course emphasises problem-solving techniques, empowering individuals to handle complex data-related tasks with ease. By the end of the course, learners will have a strong command of these Excel functions, boosting their data management and analytical capabilities. Excel Vlookup, Xlookup, Match and Index Curriculum: Module 01: Excel VLOOKUP Module 02: Excel XLOOKUP Module 03: Excel MATCH Module 04: Excel INDEX Module 05: Advanced VLOOKUP Techniques Module 06: Combining VLOOKUP, MATCH, and INDEX Module 07: Practical Applications of XLOOKUP (See full curriculum) Who is this course for? Individuals seeking to enhance their Excel skills for data analysis. Professionals aiming to improve their data management capabilities. Beginners with an interest in learning advanced Excel functions. Anyone looking to improve their problem-solving abilities in data-heavy tasks. Career Path: Data Analyst Financial Analyst Marketing Analyst HR Specialist Business Intelligence Specialist Excel Expert for Administrative or Management Roles

Financial Analysis Course Overview The "Financial Analysis" course provides a comprehensive introduction to financial analysis, equipping learners with the knowledge and skills needed to interpret and evaluate financial statements. Covering key areas such as balance sheets, income statements, and cash flow analysis, this course enables learners to assess financial performance and make informed decisions. Whether you are starting your career in finance or aiming to enhance your existing knowledge, this course offers essential tools for financial analysis. Upon completion, learners will be able to analyse financial data effectively, understand the key financial indicators of businesses, and contribute to strategic financial decision-making. Course Description This course covers the fundamentals of financial analysis, providing in-depth insights into financial statements, including balance sheets, income statements, and cash flow statements. Learners will explore various financial reporting techniques, evaluate profitability, and develop the ability to conduct ratio and equity analysis. The course also delves into the applications and limitations of EBITDA and teaches learners to assess credit risks. By the end of the course, participants will have gained valuable skills in financial data interpretation, enabling them to assess financial health and contribute to strategic financial decisions in organisations. The learning experience combines theoretical knowledge with practical analytical skills to prepare learners for roles in finance and accounting. Financial Analysis Curriculum: Module 01: Introduction to Financial Analysis Module 02: The Balance Sheet Module 03: The Income Statement Module 04: The Cash Flow Statement Module 05: Financial Reporting Module 06: Analysing Profitability Module 07: The Applications and Limitations of EBITDA Module 08: Credit Analysis Module 09: Equity Analysis Module 10: Ratio Analysis (See full curriculum) Who is this course for? Individuals seeking to understand financial analysis Professionals aiming to enhance their financial reporting and decision-making skills Beginners with an interest in finance or accounting Business owners looking to improve their financial literacy Career Path Financial Analyst Accountant Credit Analyst Financial Consultant Corporate Finance Manager Business Intelligence Analyst Investment Analyst

Develop Big Data Pipelines with R, Sparklyr & Power BI Course Overview: This course offers a comprehensive exploration of building and managing big data pipelines using R, Sparklyr, and Power BI. Learners will gain valuable insight into the entire process, from setting up and installing the necessary tools to creating effective ETL pipelines, implementing machine learning techniques, and visualising data with Power BI. The course is designed to provide a strong foundation in data engineering, enabling learners to handle large datasets, optimise data workflows, and communicate insights clearly using visual tools. By the end of this course, learners will have the expertise to work with big data, manage ETL pipelines, and use Sparklyr and Power BI to drive data-driven decisions in various professional settings. Course Description: This course delves into the core concepts and techniques for managing big data using R, Sparklyr, and Power BI. It covers a range of topics including the setup and installation of necessary tools, building ETL pipelines with Sparklyr, applying machine learning models to big data, and using Power BI for creating powerful visualisations. Learners will explore how to extract, transform, and load large datasets, and will develop a strong understanding of big data architecture. They will also gain proficiency in visualising complex data and presenting findings effectively. The course is structured to enhance learners' problem-solving abilities and their competence in big data environments, equipping them with the skills needed to manage and interpret vast amounts of information. Develop Big Data Pipelines with R, Sparklyr & Power BI Curriculum: Module 01: Introduction Module 02: Setup and Installations Module 03: Building the Big Data ETL Pipeline with Sparklyr Module 04: Big Data Machine Learning with Sparklyr Module 05: Data Visualisation with Power BI (See full curriculum) Who is this course for? Individuals seeking to understand big data pipelines. Professionals aiming to expand their data engineering skills. Beginners with an interest in data analytics and big data tools. Anyone looking to enhance their ability to analyse and visualise data. Career Path: Data Engineer Data Analyst Data Scientist Business Intelligence Analyst Machine Learning Engineer Big Data Consultant