Free Webinar – Accelerate your Data Journey with Excel and Power BI. Power BI training delivered by our BI Developer, Jake Carville in partnership with Trigraph Intelligent Learning.

When: Thursday the 9th of July from 10 a.m. to 11.15 a.m.

Webinar Content

Questions:

  • Are you importing large data lists to Excel? Does that data need to be cleaned up? Do you need to summarise that data using Excel reports and dashboards?
  • Do you want to standardise reports and ensure all business users are looking at the same data? Do you want to automate manual data collation processes so you can spend more time unlocking insights to make informed decisions? Do you want to modernise business intelligence within your organisation? See how Power BI can help to answer these questions.
  • Excel or Power BI – Which one to use?

This webinar will give you a good insight into how data can be utilised for business intelligence and will help you understand the range of capabilities that exist today between Excel and Power BI.

 

Overview

 

Topics

Excel

  • Importing External Data to Excel / Creating Excel Data Lists
  • Tips for Cleaning, Manipulating and Looking Up data using Excel TEXT & LOOKUP functions
  • How to use Slicers and Timelines on Data Lists
  • Summarising the Data using Pivot Tables and Pivot Charts
  • Create Dynamic Excel Dashboards

Power BI

  • Connecting to different data sources and then linking them together
  • Data transformations using Power Query
  • Visualising data
  • Enabling collaboration through comments
  • Certified datasets
  • AI and Q&A visuals

Q&A

About Trigraph 

Trigraph is Ireland’s premier training services provider. Specialists in:
  • Continuous Improvement / Lean Six Sigma
  • Project Management
  • Programme Management
  • Risk Management
  • Business Performance Improvement
  • ICT Management
  • Management & Personal Skills Development
They offer a variety of programmes many leading to internationally recognised formal certifications. We work with most of Ireland’s larger domestic & international employers.

About the Author

Claire Carson

Claire Carson

Claire has been with Allsop since 2015. Working in the team as the Marketing Manager, responsible for the marketing of the Allsop brand and our wide range of solutions.

Outside of work, Claire likes to keep active and rewards this with plenty of trips to her favourite restaurants.

GET IN TOUCH
Got a Project in Mind?
Enter your details below and we will get in touch to see how we can assist with your next software project.
GET STARTED TODAY

Get in Touch!

Privacy

You have Successfully Subscribed!