Lead Training Services

Excel Power Business Intelligence


In-depth practical official courseware will be used and provided to delegates; Hands-On exercises; extra practice exercises handed to delegates.

Duration: 6 contact hours
Price includes: Courseware, two Coffee Breaks, light lunch and Certificate of Attendance)
Venue: Holistic Institute, Fgura (Click here to view location)
Certification: A Certificate of Achievement will be awarded to delegates.

Programme description

The business intelligence training programme for Excel users who are interested in using PowerPivot to produce Business Intelligence reports by themselves. A good understanding of Excel is required. Business Intelligence (BI) skills are not required. During the course insights and descriptions of what is useful if you are just entering the world of self-service BI are covered.

  • Introduction to Business Intelligence (BI) – The definition of BI, Why is BI important, Preview a BI stack
  • Choosing the Right BI Tools – Differentiate between business groups that consume BI, Understand the typical progression of BI, Determine the best BI tools for your needs
  • First Steps with PowerPivot – Working with Classic Excel PivotTables, Working with PivotTables in PowerPivot, Importing and Querying Data
  • PowerPivot at Work – Using the PivotTable to Produce Reports, Adding Calculated Columns, Adding Measures , Working with Dates, Using Slicers
  • Introduction to DAX – Understanding Calculation in DAX , DAX Syntax, DAX Data Types, DAX Operators & DAX Values, Understanding Calculated Columns and Measures, Arithmetical Operations, Common DAX Functions, Statistical Functions, Logical, Information, Mathematical, Text, Date and Time Functions


  • Many thanks once again for an extremely well run course.I and the rest of the group were hugely impressed with the trainer’s ability to couple complete professionalism with the creation of a fun learning atmosphere.The course was run at a perfect pace. It allowed everyone to reach a similar level quite quickly, and then drove us to soak-up as much information as possible for the duration.As an ex trainer myself, I found the level of prior preparation for the course exemplary. All of the data/tables created prior to the course for our use showed the level of thought and commitment that has gone into wireframing the course, and importantly, allowed us to get the most benefit possible from the time available.

    I will absolutely be recommending this course to all of my customers and colleagues.

    I’m excited for the rest of my guys who will be attending next week!

    Shane Cotter
    Head of Product Management, Malta
    NetEnt | Better Gaming™

Who We Are

We are a team of specialists passionate about our work and with a common ambition to share learning experiences with people in the business community and civil society.

Under the brand name LEAD Training Services, our team has attracted an impressive pool of professional trainers from different areas of business and different geographical locations.

This makes us the only professional training organisation in Malta that can offer cutting edge training programmes across a broad spectrum of topics. We do not believe in one-size-fits-all training programmes and in line with our belief we customise our programmes to our individual customer’s needs.

Let's Keep In Touch

Stay adjourned with our latest courses, news and events by subscribing to our newsletter. We will send you an email newsletter from time to time, and we promise to never sell your details to any third parties!

Our LatestNews

Posted on: Monday, June 26th, 2017

Lead Training Services is pleased to announce the Autumn 2017 Intake for its exclusive accredited CPD Award Courses by the National Commission for Further and Higher Education (NCFHE).

Following is the list of courses for which Registrations are now open. …read more »