This course introduces Microsoft Excel's powerful data modelling and business intelligence tools- Power Queries and Power Pivot Tables. Import data from almost anywhere (inc.
This course introduces Microsoft Excel's powerful data modelling and business intelligence tools- Power Queries and Power Pivot Tables. Import data from almost anywhere (inc.
databases, SharePoint, Oracle, SQL, websites, cloud, and many more) and use powerful tools to transform the data (shape, merge, clean, append).
Create powerful reports using Pivot tables and Pivot Charts based on data models merging and live linking many sources of data.
Prerequisites
This course can be undertaken by non-technical existing Microsoft Excel end-users. It is recommended, although not essential, that delegates have a basic understanding of the concepts in our Excel L1 course.
Based in Edinburgh and Glasgow, we provide a wide range of classroom based in-person IT training courses to companies across the whole of Scotland.
Courses can be attended in our city centre Edinburgh training centre, delivered on-site at your premises, or live virtual classrooms.
Our mission is to provide the best possible course for every delegate. This ranges from analysing a client's goals before recommending the most appropriate course to best meet business needs, to providing a full organisational needs analysis and business support.
Our courses are highly recommended by our loyal clients who choose iTrain Scotland as their first choice training provider time and time again.
Power BI is a data visualisation tool that allows us to see and understand data more deeply. In this course, you’ll explore essential types of analysis and data visualisation used to convey insights from data.
The Microsoft Power BI workshop was designed to introduce participants to the Power BI program, its uses, and what this program contributes to facilitating data processing, creation, and transfer from one user to another.
Explore the role of big data in AI, the relationship between data and information, big data frameworks (including Hadoop), applicable solutions and the processes and techniques used.
An full encompassing course of Microsoft Power BI that will cover the power of data visualization and will provide infrastructures for visualization, dashboard and reports using Microsoft BI toolkits.
Power BI brings together an Analytics services which transforms data into visuals formats & the ability to share with colleagues, the power to explore & analyze the data both on premises or the cloud.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy