Power BI For Data Science

Expand all | Collapse all

Six ways Excel users save time with Power BI

  • 1.  Six ways Excel users save time with Power BI

    Top Contributor
    Posted 02-12-2018 07:57 PM

    Excel is a powerful and flexible tool for every analytics activity. When Excel is combined with Power BI, the result is a broad set of business analytics and data visualization capabilities. Use Excel and Power BI together to easily gather, shape, analyze, and explore key business data in new ways-all in less time.

    Common foundation means you're ahead

    All the queries, data models, and reports you create in Excel can transfer to a stunning interactive dashboard in Power BI - and you don't need to learn a new application or language saving you time

    Automate your data refresh with one click

    When using Schedule Data Refresh, your data sources configured in Power Pivot will be refreshed in the background. When you open your dashboard, the right data will be there-without requiring any action.

    Consume and share multiple workbooks in a single view

    By connecting your Excel workbooks to Power BI, you can display ranges of data, charts, tables, and more on a Power BI dashboard combined with data from other sources.

    Rely on self-service data visualization

    With rich, interactive visualizations, and the ability to ask natural language questions, Power BI can extend the power of your Excel data models to your reports. Colleagues of varying ability and experience-even if they're not Excel experts-will understand and benefit from your analysis, even finding insights of their own.

    Bring advanced analytics to your models

    With the ability to run R scripts and use R-powered custom visuals, Power BI has incorporated advanced custom visualization, modeling, and predictive capabilities for advanced analytics workflows.

    Keep the flexibility of the grid

    Easily bring data in Power BI back to Excel for ad-hoc analysis. With a single click, connect to your data models directly from Excel to create powerful PivotTables and charts.

    Pablo Moreno
    Business Analyst Snr Advisor

  • 2.  RE: Six ways Excel users save time with Power BI

    Posted 02-13-2018 07:17 AM
    Thanks Pablo

    Mehdi HAMMADI