Microsoft Power Bi - Introduction

Microsoft Power BI is a data analytics and visualization tool that allows you to easily build reports and dashboards with interactive visualizations. Connect to and visualize any data using the unified, scalable platform for self-service and enterprise business intelligence (BI) that’s easy to use and helps you gain deeper data insight.

Description

Attending this workshop will help you to:

  • Get to know the Microsoft Power BI interface.
  • Understand the purpose of Microsoft Power BI for data analytics.
  • Understand the basics regarding capacities, workspaces, datasets, shared datasets, reports, and dashboards.
  • Get to know data modelling and visualizations using different kinds of visuals like charts and tables.
  • Learn how to filter, clean, and transform data with services like Power Query.
  • Understand aggregates and when to use them.
  • Learn how to secure your data.
  • Perform exercises to secure your knowledge and understanding.
  • Create and share your first Power BI report.

Entry Requirements

A basic understanding of Microsoft Office 365 is recommended.

Microsoft Power BI requires a separate license in addition to Microsoft Office. Learners will require this additional license to perform the exercises on their own computers.

A stable Internet connection is required.

Having a second display is beneficial but not required.

Similar courses

This advanced-level Excel workshop is designed for individuals who are already proficient in the basics of Microsoft Excel and want to take their skills to the next level. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information

This 1-Day course is designed to help attendees understand and use Microsoft Power BI in a practical and hands-on way, performing learning exercises to help prepare them to develop and style their own Power BI dashboards.

More Information

Microsoft Power BI is a powerful data visualization tool that allows users to connect to, visualize and share any data, gaining deeper insights. This 2-day advanced course is designed to help attendees become expert users in Power BI.

More Information

This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information

In this course, participants will be introduced to Excel macros and then develop a deeper understanding of advanced and custom macros including an introduction to VB coding for macros. Excel macros allow you to automate repetitive tasks and streamline your work processes.

More Information

This course enables delegates to identify signs of stress in their team members; discuss the employee’s stress triggers with them; and agree individual strategies to be reviewed at a later date. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information

This course introduces the essential principles and practices of effective project management. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information

The goal of this course is to teach participants how to build advanced charts in Microsoft Excel that are easy to read, interactive, and dynamic. The focus will be on creating charts that effectively tell a story about the data and provide additional insights to the reader. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information

Microsoft Excel is a spreadsheet application developed by Microsoft that is widely used for data analysis, calculation, and visual representation. This introductory course will cover the basics of Microsoft Excel and help you to get started with the programme. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information

In this course, participants will delve into the powerful features of Microsoft Excel pivot tables. From the basics of pivot tables to advanced features such as custom groupings and calculated fields, participants will learn how to effectively analyse and visualize their data. The course will also introduce Microsoft Power Pivot, offering even more options for data analysis. Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.

More Information

Microsoft Excel is a powerful tool for data analysis that is widely used in many industries. In this course, you will learn how to use Excel to organize and analyse data, create reports, design charts, and make data-driven decisions. You will also learn how to use Excel's built-in features to manipulate data in Power Query. Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.

More Information

This intermediate-level workshop is designed to help participants take their Excel skills to the next level. The course will focus on shortcuts for navigation, selection, and commands, as well as the application of exciting formulas to save time and improve efficiency. Participants will also learn how to protect their worksheets and workbooks, apply data validation techniques, manipulate text data through formula, and link cells, worksheets, and workbooks for dynamic automatic reporting.

More Information

Mental health is a vital part of overall wellbeing and plays a central role in how we live and work. This one-day workshop provides practical knowledge and tools to help you better understand mental health, recognise the signs of common issues, and respond appropriately in the workplace. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information

This course is for whole teams to learn together what is needed to collectively build their resilience. There is no one blueprint… teams are as individual as…well individuals! In a relaxed, fun and informal environment participants will hear the latest research on this topic. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information

With Power Query and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Whether it's small data sets or large ones with up to millions of rows, in this course you will learn how you can connect, clean, analyse, and share your data faster using Power Query and Power Pivot. Note: This course is regularly updated to include the latest relevant AI releases and best practice.

More Information

Conflict is a natural part of working life, but when left unresolved it can damage relationships, lower morale, and impact performance. This one-day workshop equips you with the insight and practical tools to better understand the roots of conflict, recognise your own response style, and apply effective strategies to manage and resolve disagreements constructively. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information

This course provides an in-depth exploration of the principles and practices involved in managing supply chains effectively. Students will learn about the end-to-end process of sourcing, production, logistics, and distribution of goods and services. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information

This course explores the principles and practices of innovation and entrepreneurship, equipping students with the tools to identify opportunities, develop innovative solutions, and launch successful ventures. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information

This practical one-day workshop helps managers develop the skills and confidence to balance their dual roles as both leaders and mentors. Participants will learn how to listen and question effectively, set meaningful goals, and apply proven coaching and mentoring techniques to support team members’ growth. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information

This one-day workshop equips participants with the skills and confidence to effectively manage challenging people, situations, and conversations in the workplace. You will explore why difficult interactions arise, how to understand both what is being said and what is left unsaid, and how to approach these moments with clarity and professionalism. This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information

Get an overview of popular social media tools – and how best to capitalise on their reach

More Information

It's the most important job for any leader: managing your people and helping them develop and thrive. But how do you create a positive culture that encourages growth and positive behaviour? And what do you do if - despite all your best efforts - an employee just isn't performing well or whose behaviour is not in alignment to company policy? This course can also be offered as a cohort (group) booking, if interested in a cohort booking to contact training@forthvalley.ac.uk

More Information