Skip to main content
Skip to main content
Microsoft 365

Take control of data with Excel’s business analytics tools

Today, businesses are required to understand a growing amount of company, market and social data to drive effective business decisions and remain competitive. This trend of analytics everywhere is driving a shift in the roles of business consumers, as the need for direct data access, ad-hoc analyses and in-depth reporting is growing beyond the capacity of their IT departments. Many specialized business intelligence and analytics solutions are entering the market to take advantage of this trend with most requiring installation of new data systems or new training of employees to learn new tools. But if you look closely—Excel—the Office productivity tool you already know and love, may already have the business analytics tools you need to empower you to drive the information analyses and data-driven decisions critical to your business.

Take control of data with Excels business analytics tools 1 v2

Building data models with drag-and-drop ease.

Starting with Office 2013, Excel comes with a suite of self-service analytics features that allow you to find, connect, shape, model and analyze your company data in intuitive ways. While the product has always been a powerful calculation device, today’s Excel comes with in-memory technology that allows it to support hundreds of millions of rows of business data with incredible performance—letting you do the necessary analysis without the need for using a database or waiting for IT to develop the models for you.

But like with most evolutions of a product, it can be hard to believe until you experience it for yourself. That is why we have provided innovative interactive tours that let you get a taste of each self-service analytics feature. In just one-click, these web-based tours put you in the driver’s seat of a demo without the need for installations or trial sign-ups. After taking the tours, the Excel for Business Analytics site provides you with the information you need to help get started using these features, whether you already have Excel 2013 or need to upgrade.

Take control of data with Excels business analytics tools 2 v2

Discovering data insights with 3D geospatial maps.

Check out all the tours available for you and get started taking control of your data!


Get to all your data

Power Query for Excel helps you Take control of data with Excels business analytics tools 3 v2discover and bring all your data together so you can start analyzing in seconds. Connect to data from public data, on-premises data sources, Hadoop datasets, streaming data and cloud services. Use search inside Excel to find data around you. Then freely shape and merge data from multiple sources so you can analyze all within Excel.

Create sophisticated data models

After connecting to your data, Take control of data with Excels business analytics tools 4 v2use Power Pivot for Excel to put it all together in sophisticated data models. This used to be something that only the IT department could do, but now you have the power to create models on your own desktop. Use the visual canvas to identify the relationships between the data tables and simply draw relationships to build your model.

Analyze with stealth and power

With Power Pivot for Excel, you Take control of data with Excels business analytics tools 5 v2can enhance your business data with custom calculated fields, hierarchies and KPIs to analyze in the way that makes most sense to your business needs. Best of all, still take advantage of familiar analysis tools, like Pivot Tables and Pivot Charts, but now with more power. Excel’s in-memory technology allows you to analyze hundreds of millions of rows of data.

Perform analysis across 3-D maps

With Power Map for Excel, Take control of data with Excels business analytics tools 6 v2perform geospatial explorations of your data by taking advantage of any data with location to plot across 3-D maps. Interact and story tell with this captivating map tool to see your data in new perspectives and unlock deeper insights.

You may also like these articles

Image for: Family hanging out at home baking holiday cookies using Lenovo Ideapad Flex 3 to make holiday cards

New apps and features in Microsoft 365 for individuals and families this fall

Since we introduced Microsoft 365 to individuals and families earlier this year, we have continued to deliver new innovations across our apps and services to help you and your family save time and stay connected. See what’s new below. Locate your loved ones and build better driving habits with Microsoft Family Safety Stay connected even…

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…

Image for: Surface Pro X and Surface Arc Mouse inside on desk with Excel and search on screen.

Connect to your own data with more new data types in Excel

The evolution of Excel Excel is the ultimate decision-making tool. We’re amazed every day by the ways in which you, our customers, use Excel to make better decisions, leveraging the flexibility of the 2D grid and formulas to capture, analyze and collaborate on data. Up to this point, Excel has only had a couple base…