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

Bristol Business College Logo

Excel Power BI Tools

This course covers the newly introduced range of Excel Power BI tools (Power Business Intelligence). Learn how to use all of these latest features introduced in Excel which will help in business processing, data analysis, financial reporting, and with day-to-day decision making.

by Bristol Business College [Claim Listing ]
Babington Logo

Database Fundamentals

The Power BI course provides you with the knowledge and skills required to analyse data with self-service BI, connect to data sources, perform advanced data modelling and shaping, perform advanced analysis, publish and share reports and dashboards, extend access to Power BI, and more.

by Babington [Claim Listing ]
  • Price
  • Start Date
  • Duration
Framework Training Logo

Data Visualisation With R Training Course

You’ll learn about basic graph types such as bar charts, scatter and box-whisker plots, as well as more “exploratory” types such as scatter plot matrices and conditioning plots. You will also learn how to alter basic graphical parameters, and thus customise your graphics to best effect

by Framework Training [Claim Listing ]
PCWorkshops Logo

Big Data Hadoop (Intro)

The Apache™ Hadoop® project is an open-source software project that develops reliable, scalable, distributed computing. The Apache Hadoop software library is a framework. It provides fast and secure storage and retrieval of large data sets.

by PCWorkshops
Elliott Training UK Logo

Microsoft Power BI – Advanced

This 2-day course is aimed at experienced Power BI users. It delves into the use of Azure, as well as the use of advanced DAX formulas and data modelling.  Its focus is on using Power Query, Workflows and Custom Advanced Visuals

by Elliott Training UK [Claim Listing ]

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