Data Analysis using Excel
The course guides you through the basic and advanced features of Excel to help you discover the gems hidden inside. From data analysis, to visualization, the course walks you through the steps required to become a superior data analyst.
Description
Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. Having a deep practical knowledge of Excel will greatly increase your productivity. You will be seen as a very skilled business data analyst in the organization. And will lead to a much greater opportunities for you.
Excel is the number-one spreadsheet application, with a plethora of capabilities. If you're only using the basic features, you're missing out on a host of features that can benefit your business by uncovering important information hidden within raw data. This Excel Data Analysis course allows you to harness the full power of Excel to do all the heavy lifting for you.
The course guides you through the basic and advanced features of Excel to help you discover the gems hidden inside. From data analysis, to visualization, the course walks you through the steps required to become a superior data analyst.
Course Objectives
By attending this ICL training course, delegates will be able to:
-
Understand and Identify the principles of data analysis
-
Build presentation ready dashboards in Excel
-
Apply analysis techniques to datasets in Excel
-
Become adept at using Excel functions and techniques for analysis
-
Learn how to use Pivot Tables and Pivot Charts to streamline your workflow in Excel
-
Use effective design principles when creating and presenting data
-
Learn about Excel's Ubiquity And Strategic Importance as a BI Tool
-
Learn about the Excel Data Model
-
GeoFLow
-
Working with External Databases
-
Integration with Sharepoint
How will this Training Course be Presented?
-
Presenter-taught training in a computer lab
-
Online training via the platform Zoom or MS Teams
Who is this Training Course for?
-
Anyone who wants to learn to apply data analysis techniques using Excel
-
Anyone who wants to become good at using Excel for data analysis
-
Anyone who wants to learn the core concepts of data analysis in Excel
-
Anyone who wants to learn about PowerPivot, Pivot Charts etc..
Additional information
Please bring a USB flash drive to class if you would like to make a copy of your work or any relevant class materials. Alternatively, you can save these to a cloud storage space or email them to your personal email address.
Software
-
Recommended operating system: Windows or Mac
-
Recommended software for PC: MS Excel 2013, 2016, 2019, 365
-
Recommended software for Mac OS: MS Excel 2016, 2019, 365
-
Recommended browser: Chrome
The Course Content
Excel as a BI Tool
-
Excel's Ubiquity And Strategic Importance
-
Excel Analytics Facilities
Data Management and Modelling: Core Excel and the Excel Data Model
-
Core Excel BI
-
DEMO: Web Queries and the Data Connection Wizard
-
Office Data Connections
-
DEMO: Managing Office Data Connections
-
Analysis Services Support
-
DEMO: Querying an OLAP Cube
-
The Excel Data Model
-
The BI Semantic Model
Data Management and Modelling: PowerPivot
-
Features Overview
-
Obtaining the Add-In, Data Import
-
DEMO: Data Import and Setting Relationships
-
Advanced Modeling
-
DEMO: Advanced Modeling, Querying In Excel
Data Discovery and Visualization: Power View
-
Overview
-
Creating Reports
-
Demo: Power View Basics
-
Maximize, Filters and Bubble Charts
-
DEMO: Filters, Bubble Charts and the Play Axis
-
Advanced Properties
Data Acquisition: Data Explorer
-
Overview, Data Sources and Tie-Ins with Excel Data Model
-
Data Shaping, Data Manipulation and Integrating Child Data
-
Demo: Importing, Shaping and Visualizing HDInsight (Hadoop) Data
-
Data Formulas, Scripts and the 'M' langauge
-
Demo: Working with Data Steps and Scripts
Mapping: GeoFlow
-
Overview and First Steps
-
Demo: Mapping the Hadoop Data
-
Chart Types, Controls and Visual Elements
-
Demo: Bubble Charts, Heat Maps, Panning, Zooming, and Themes
-
Layers, Scenes and Tours
-
Demo: Working with Layers, Building Scenes and Tours
How SharePoint Ties In
-
Overview and Excel Services/Excel Web App
-
Demo: Excel Analytics in the Excel Web App on Office 365
-
PowerPivot and Power View
-
PerformancePoint/Reporting Services, Analysis Services Clients
Wrap-Up
-
Review and Wrap Up