Related topics
Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!