Bringing data to life using Power BI
Hi folks, Last weekend in London, I had the pleasure to present a session at SPS Events London "Bringing data to life using Power BI" - hopefully you will find the slides for your benefit! http://www.slideshare.net/techChirag/bringing-your-data-to-life-using-power-bi-sps-london-2016New feature: Create Power BI reports from tables in Excel files and CSV files
We are excited to announce a new feature that will make it very easy to start visualizing data in Excel tables and CSV files using Power BI. When you go to your OneDrive for Business, or any SharePoint document library, you will be able to select an Excel file that contains tables, or a CSV file, and click on "Open in Power BI" in the command bar. Clicking this command will open a new tab in your browser and take you to Power BI. A Power BI dataset will be automatically created based on your Excel or CSV file and you can start creating a report to visualize your data. Note that this requires that your data is formatted as tables in Excel. The dataset created in Power BI will be automatically refreshed when you make changes to the original Excel or CSV file. This means you can continue to make changes to the file in OneDrive or SharePoint, and any associated dataset, reports and dashboards will be automatically updated with the latest data. Refresh happens every hour, but if you want to see changes right away you can start a refresh in Power BI by clicking the ellipses beside the dataset, then clicking the refresh now icon. The dataset will be added to your group's workspace if the SharePoint site you started from has a group association (like a modern team site). Otherwise, it will be added to your personal workspace. Any user can create a report based on an Excel or CSV file in Power BI for free, but to share the report with others you will need a Power BI Pro license. If the user creating the dataset already has a Power BI Pro license, they will be able to take full advantage of it. If you are a first time Power BI user, you may find this page helpful for an introduction. We will be gradually rolling this feature out to customers over the coming weeks and months, and as always listen to your feedback. We will make updates to this post as the feature rollout expands through our release process.DP-900: Microsoft Azure Data Fundamentals Study Guide
Microsoft Azure provides an array of services that enable businesses and organizations to undergo digital transformation by making quick and informed decisions. The DP-900 Microsoft Azure Data Fundamentals exam evaluates learners' understanding of data concepts such as relational, non-relational, big data, and analytics. The exam requires learners to demonstrate their knowledge of core data concepts, relational and non-relational data, and Azure data services. Microsoft offers resources such as Microsoft Learn self-paced curriculum, an instructor-led course, and related documentation to help students prepare for the exam. Understanding Azure data principles is vital for more advanced Azure certifications like Azure Database Administrator Associate and Azure Data Engineer Associate.A new Project Online Content Pack for Power BI
We are pleased to announce the release of a new Project Online Content Pack for Power BI. Starting October 26 2017, Project Online users will be able to download the new content pack directly from AppSource: https://app.powerbi.com/groups/me/getdata/services/project-online Comprising of 13 visually rich report pages, the new content pack is designed to support the management needs of project managers, portfolio managers and resource managers, by retrieving planning and execution data from Project Online and arranging the data to support timely decision making. The new content pack report includes reports in three key perspectives: Individual Projects, Portfolio of projects and the organization’s resources. Each perspective encompasses the following detailed report pages.
Create custom reports using Microsoft Defender ATP APIs and Power BI
Typical enterprise security operation teams often rely on dependable reporting visualisations to make critical security decisions. While Microsoft Defender ATP provides extensive visibility on the security posture of your organization through built-in dashboards, custom reporting can help you turn security data from multiple sources into insights to meet your analytical needs.
