We may earn an affiliate commission when you visit our partners.

Excel 2013

An Analytics Superhub

A look at the analytics capabilities in the core Excel product and its add-ins, including PowerPivot, Power View, "Data Explorer" and "GeoFlow," as well as an investigation into how to use these tools together.

This course goes through how to use Excel as an analytics client for BI and Big Data. With coverage applicable to several versions of Excel, but with emphasis on the new capabilities of Excel 2013, the content includes details on, and numerous demos of, the analytics capabilities in the core Excel product and its add-ins, including PowerPivot, Power View, and preview add-ins code-named "Data Explorer" and "GeoFlow." This course provides great detail on each tool and shows how they can be used in combination, as well as, with data from HDInsight/Hadoop; Microsoft's Big Data Platform. Tie-ins to SharePoint are discussed and integration with Office 365 is demoed.

Enroll now

Or start your subscription today

And complete this course over a free trial

Here's a deal for you

We found an offer that may be relevant to this course.

Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

Valid for a limited time only

Future-proof your career

Access O'Reilly books, live events, courses, and more. Save with an annual subscription.

Take

15%

off

What's inside

Syllabus

Introduction

Excel as a BI Tool

Data Management and Modeling: Core Excel and the Excel Data Model

Data Management and Modeling: PowerPivot

Data Discovery and Visualization: Power View

Data Acquisition: "Data Explorer"

Mapping: "GeoFlow"

How SharePoint Ties In

Wrap-Up

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Deeply explores Excel's analytics capabilities including PowerPivot, Power View, and 'Data Explorer.'

Taught by Andrew Brust, an experienced data analyst

Covers a wide range of topics essential for data analysis in Excel, including data management, modeling, visualization, and acquisition

Provides numerous demos and hands-on exercises to reinforce learning

Suitable for learners with some prior knowledge of Excel and data analysis concepts

Focuses on Excel 2013, which may not align with the latest version of Excel

Save this course

Save Excel 2013: An Analytics Superhub to your list so you can find it easily later:

Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Excel 2013: An Analytics Superhub with these activities:

Read 'Excel Power Pivot for Data Analysis, 2nd Edition'

Show steps

Introduces key Excel Power Pivot concepts such as data modeling, data analysis, and data visualization providing a foundation for the course and its related tools.

View DAX Patterns: Second Edition on Amazon

Show steps

Read the preface and introduction
Read Chapter 1: Power Pivot Fundamentals
Read Chapter 2: Power Pivot Data Modeling

Gather resources on Excel integration with SharePoint and Office 365

Show steps

Expands understanding of Excel's integration with SharePoint and Office 365, providing a resource for future reference and knowledge reinforcement.

Show steps

Search for articles and documentation on Excel integration with SharePoint and Office 365
Organize the resources in a folder or digital notebook

Follow tutorials on using 'Data Explorer' to acquire data

Show steps

Provides additional guidance and practice in using 'Data Explorer' to acquire data, expanding knowledge beyond the course coverage.

Show steps

Find tutorials on using 'Data Explorer'
Follow the steps in the tutorials
Try out different data sources

Four other activities

Expand to see all activities and additional details

Show all seven activities

Practice using Power View to create interactive visualizations

Show steps

Develops proficiency in using Power View to create interactive visualizations, enhancing the ability to communicate insights effectively.

Browse courses on Power View

Show steps

Create a Power View report
Add charts and graphs to the report
Apply filters and slicers to the report
Use drill-down and cross-filtering functionality

Create a 'GeoFlow' map visualization

Show steps

Applies knowledge of 'GeoFlow' to create a map visualization, demonstrating the ability to present data geographically.

Show steps

Create a new 'GeoFlow' map
Add data to the map
Customize the map's appearance
Export the map as an image or interactive web page

Attend a workshop on advanced Excel analytics techniques

Show steps

Provides an opportunity to learn from experts, network with peers, and apply advanced Excel analytics techniques to real-world scenarios.

Show steps

Find a workshop on advanced Excel analytics
Register for the workshop
Attend the workshop

Volunteer to mentor students in Excel analytics

Show steps

Strengthens understanding of Excel analytics by explaining concepts and techniques to others, while also developing leadership and communication skills.

Browse courses on Mentoring

Show steps

Find opportunities to mentor students in Excel analytics
Prepare materials and lesson plans
Meet with students and provide guidance

Career center

Learners who complete Excel 2013: An Analytics Superhub will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts use their technical expertise in organizing, analyzing, and interpreting data to help businesses make informed decisions. This course helps build a foundation in data analysis by teaching students how to use Excel as a BI tool, manage and model data using core Excel and the Excel Data Model, and visualize data using Power View. These skills are essential for Data Analysts who need to be able to work with large datasets and communicate their findings effectively.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts use data to help businesses improve their operations. They may work with data to identify trends, develop strategies, or make recommendations. This course can be helpful for Business Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Business Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Business Analyst

Financial Analyst

Financial Analysts use data to make investment decisions. They may work with data to value companies, analyze financial statements, or develop investment strategies. This course can be helpful for Financial Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Financial Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Financial Analyst

Market Researcher

Market Researchers use data to understand consumer behavior and trends. They may work with data to identify target markets, develop marketing campaigns, or evaluate the effectiveness of marketing efforts. This course can be helpful for Market Researchers who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Market Researchers who need to communicate their findings to stakeholders.

See salaries and explore the career path for Market Researcher

Operations Research Analyst

Operations Research Analysts use data to improve the efficiency of business operations. They may work with data to identify bottlenecks, develop scheduling systems, or design new products. This course can be helpful for Operations Research Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Operations Research Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Operations Research Analyst

Data Scientist

Data Scientists use data to build predictive models and solve business problems. They may work with data to identify trends, develop algorithms, or create data visualizations. This course can be helpful for Data Scientists who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Data Scientists who need to communicate their findings to stakeholders.

See salaries and explore the career path for Data Scientist

Statistician

Statisticians use data to collect, analyze, and interpret data. They may work with data to design experiments, develop statistical models, or make predictions. This course can be helpful for Statisticians who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Statisticians who need to communicate their findings to stakeholders.

See salaries and explore the career path for Statistician

Quantitative Analyst

Quantitative Analysts use data to develop and implement financial models. They may work with data to value companies, analyze financial statements, or develop investment strategies. This course can be helpful for Quantitative Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Quantitative Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Quantitative Analyst

Actuary

Actuaries use data to assess risk and uncertainty. They may work with data to develop insurance policies, pension plans, or investment strategies. This course can be helpful for Actuaries who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Actuaries who need to communicate their findings to stakeholders.

See salaries and explore the career path for Actuary

Risk Analyst

Risk Analysts use data to identify, assess, and manage risk. They may work with data to develop risk management plans, conduct risk assessments, or implement risk mitigation strategies. This course can be helpful for Risk Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Risk Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Risk Analyst

Fraud Analyst

Fraud Analysts use data to detect and investigate fraud. They may work with data to identify fraudulent transactions, develop fraud detection systems, or implement fraud prevention strategies. This course can be helpful for Fraud Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Fraud Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Fraud Analyst

Data Engineer

Data Engineers use data to design, build, and maintain data systems. They may work with data to develop data pipelines, create data warehouses, or implement data governance strategies. This course can be helpful for Data Engineers who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Data Engineers who need to communicate their findings to stakeholders.

See salaries and explore the career path for Data Engineer

Database Administrator

Database Administrators use data to design, build, and maintain databases. They may work with data to create database schemas, optimize database performance, or implement database security measures. This course can be helpful for Database Administrators who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Database Administrators who need to communicate their findings to stakeholders.

See salaries and explore the career path for Database Administrator

Information Security Analyst

Information Security Analysts use data to protect information systems from unauthorized access, use, disclosure, disruption, modification, or destruction. They may work with data to identify security vulnerabilities, develop security plans, or implement security measures. This course can be helpful for Information Security Analysts who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Information Security Analysts who need to communicate their findings to stakeholders.

See salaries and explore the career path for Information Security Analyst

Software Engineer

Software Engineers use data to design, build, and maintain software systems. They may work with data to develop software requirements, create software designs, or implement software code. This course may be helpful for Software Engineers who want to learn how to use Excel to manage and analyze data. The course also covers how to use Power View to visualize data, which can be helpful for Software Engineers who need to communicate their findings to stakeholders.

See salaries and explore the career path for Software Engineer

Reading list

We've selected 12 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Excel 2013: An Analytics Superhub.

Power Pivot and Power BI

Save

Provides a practical guide to using PowerPivot and Power BI, two powerful Excel add-ins for data modeling and visualization. It valuable resource for anyone who wants to use Excel for business intelligence.

Excel 2013

An Analytics Superhub

Here's a deal for you

What's inside

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses