Get deeper insights from your sales data

Get deeper insights from your sales data

Assessing trends and forecasting consumer buying behavior requires gaining deep insights from your purchasing and customer data. You need to pull information from multiple sources to get the full picture and visualize it in an interactive way that’s easy for stakeholders to access and understand.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.


Connect to industry-wide data sources from the web and import the data into your Excel workbook. Once the data’s in Excel, you can visualize it for richer insights and a quick understanding of otherwise complex data sets. Use Excel Power Query to see how competitive sales data measures in comparison to your own. And, forecast future sales and trends based on historical information.

Bring your data from Excel into Power BI to mine even deeper insights. Power BI is a collection of software services, apps, and connectors that work together to turn multiple sources of data into coherent, interactive insights that are easy to understand. Share your Power BI dashboard with stakeholders and decision-makers to get buy-in and sign-off.


  • Pull sales data from a central database.

  • Compare industry sales figures with internal data.

  • Shape and share sales insights.

Learn More

Add a query to an Excel worksheet (Power Query)

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.