Microsoft Excel Level 4- Data Analysis And Reporting With Power Query

by ITrain Scotland Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

ITrain Scotland Logo

img Duration

1 Day

Course Details

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.

  • Edinburgh Branch

    24 Canning Street,, Edinburgh

Check out more Big Data Analytics courses in UK

UWE Bristol Logo

Big Data

This course can count towards one of our postgraduate qualifications within our Information Management and Information Technology Awards A key first step into the world of Big Data is to understand what it is, why it is different and how it is best managed.

by UWE Bristol [Claim Listing ]
Computer Training Wales Logo

Microsoft PowerBI (Business Intelligence) Beginner Course

This course is specifically designed to provide you with a solid foundation in using PowerBI, a powerful business intelligence tool that enables you to transform raw data into meaningful insights and compelling visualisations.

by Computer Training Wales [Claim Listing ]
M Training Logo

Power BI Training Course

This one to two-day course will provide you with the skills you need to create useful, dynamic, interactive reports that visualise your data using Power BI dashboards. These visualisations can be used to provide insights that will help your business improve its performance.

by M Training [Claim Listing ]
ZOE Talent Solutions Logo

Big Data Analytics with Spark Training Course

The analysis of large datasets involves using an equally large set of computers. Successfully using so many computers entails the use of distributed files systems, such as the Hadoop Distributed File System (HDFS) and parallel computational models, such as Hadoop, MapReduce and Spark.

by ZOE Talent Solutions [Claim Listing ]
Acuity Training Logo

Power BI: 2 Day Advanced Course

Master Power BI’s most powerful functions on this 2 day Advanced Power BI training course.

by Acuity Training

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy