Course description
Microsoft Excel Level 5: Business Intelligence
Level Up Your Data Analysis: Microsoft Excel Level 5: Business Intelligence (2 Half Days)
Are you an advanced Excel user ready to unlock the full potential of your data? This exclusive Microsoft Excel Level 5: Business Intelligence course equips you with the power of Power Query and Power Pivot, transforming you into a data analysis powerhouse.
This two-half-day program delves into:
- Power Query Mastery: Learn to conquer data cleaning, manipulation, and refreshing for even the most complex datasets. Master the art of transforming raw data into a usable format for insightful analysis.
- Power Pivot Deep Dive: Unlock the secrets of Power Pivot in Microsoft Excel Level 5. Explore its capabilities for creating powerful data models, allowing you to analyse large datasets with ease.
- Data Visualisation for Impact: Harness the power of data visualisation within Microsoft Excel Level 5. Craft compelling dashboards and reports that transform complex data into clear, actionable insights for management teams.
- Business Intelligence with Microsoft Excel: Learn how to leverage the combined power of Power Query, Power Pivot, and data visualisation tools within Microsoft Excel Level 5. This synergy empowers you to extract valuable business intelligence from your data and confidently make data-driven decisions.
Take your Microsoft Excel skills to the next level! This Microsoft Excel Level 5 Business Intelligence course is your gateway to becoming a data analysis expert. Enroll today and unlock the secrets of data-driven decision-making!
Upcoming start dates
Suitability - Who should attend?
Who is this for?
This course is specifically designed for office users, managers, accountants and data analysts. Delegates on this course should have existing advanced knowledge of Excel, and we will turn you into an Excel expert. Pre-requisite knowledge: Windows, Excel Secrets, Excel Ninjas and Excel Gurus or equivalent knowledge/skills.
Training Course Content
Power Query allows data crunchers to get and transform data from many sources and combine with others using clear visualizations.
- Combine data from files in a folder add data and refresh
- Combine sheets from a workbook, add data and refresh
- Manipulate large amounts of data within Power Query
- Produce a refreshable table / Pivot Table / Pivot Charts of your combined data
- Combining data from different sources – Excel, .csv, .txt or .pdf files
- Creating PowerPivot Tables by creating relationships between files
Power Pivot
Pivot Tables are a terrific tool in Excel allowing large amounts of information to be compressed and filtered, even shown using a PivotChart. The latest tool is PowerPivot, which allows the joining of data from several tables and on our course delegates will learn in a workshop session how to create and edit relationships between files and tables within Excel.
- Manipulating large amounts of data
- Joining data from several tables
- Creating & Editing Relationships between files and Tables
- Power PivotTables and PivotCharts
Introduction to Power BI Desktop gives Excel users the ability to create dashboards to view many types of Charts and Tables and see them change over time using simple controls. The data analyst would create the Visualisations for management to see and manipulate their data in a very interactive way.
- Creating a new Dashboard
- Using data from multiple sources
- Types of Charts
- Types of Tables
- Using Filters
- Deleting & Editing Dashboard elements
- Refreshing Data
Reviews
Average rating 4.8
Really enjoyed learning about power pivots, will definitely be using it in my day to day work
Request info
Imagine Training
Welcome to Imagine Training, empowering businesses through comprehensive Microsoft 365 training with a particular emphasis on Excel Training. As we navigate through the rapidly evolving digital age, our mission is to ensure your organisation not only keeps pace but excels....
The training is very useful to increase the efficiency .