In The Trenches
With SSAS, SSIS, SSRS, DAX, MDX, Power BI and MDS
Follow @gilra Last week Microsoft released a preview of the Template Apps – A new experience that was designed for partners and ISVs to deliver streamlined analytics to their clients. By now, you should be able to install or create template apps. You can learn about my early experience here, and read about the official […]
This post first appeared at https://datachant.com/2019/02/20/template-apps-in-power-bi-2/. The author is Gil RavivWe were recently building a data model with on-prem Dynamics data mostly using the OData feed (v8.2). This article only scratches the surface of what is possible with OData (including update/write functions and much more complex queries than those shown… This post first appeared at https://powerpivotpro.com/2019/02/some-odata-tips/. The author is Patrick MahoneyRead More
This post first appeared at https://powerpivotpro.com/2019/02/some-odata-tips/. The author is Patrick MahoneyData is most valuable when it leads to informed action. Making it easier for people to get actionable insights is what Power BI is all about. Now, with Power BI Template Apps, users can immediately begin exploring, learning, and taking action on key data with off-the-shelf apps. Template Apps are integrated packages of pre-built Power […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/insights-made-easy-with-power-bi-template-apps/. The author isUpdated Feb 2019. This is an edited version of my original article which first appeared on my site in Feb 2016. The rate of change in the tools available to a Business Analyst has never been faster than it is today. The market is changing so quickly that many Business Analysts (BAs) are only just […]
This post first appeared at https://exceleratorbi.com.au/the-best-training-for-business-analysts/. The author is Matt AllingtonSince I started focusing primarily on Microsoft BI/DW/analytics around 2005, I’ve always been happy being a generalist within that space. Fast forward to around 2017 when I started focusing predominantly on Azure. Being a generalist (still within BI/DW/analytics) in Azure is really tough — as I’m sure you well know. Not only is the variety […]
This post first appeared at http://feedproxy.google.com/~r/SqlChick-MelissaCoates/~3/D8AwdHjLT8I/keeping-up-with-azure-changes. The author is Melissa CoatesYet more evidence that Power Query is taking over the world: there’s a new Power Query data source for SQL Server Integration Services in the latest version of SSDT. Here’s the blog post announcing it (the actual announcement is halfway through): Deeper integration and new connector for SSIS in ADF This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/gEMOe6lOnKM/. […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/gEMOe6lOnKM/. The author is Chris WebbToday Gartner released the 2019 magic quadrant for Business Intelligence. As expected (by me at least), Microsoft is continuing its trail blazing and now has a clear lead over Tableau in both ability to execute and completeness of vision. I thought it would be interesting to see a trend over time for the last 5 […]
This post first appeared at https://exceleratorbi.com.au/extract-numerical-data-points-from-an-image/. The author is Matt AllingtonFor the third straight week, we’re delivering on the item I’ve heard more end-user feedback around than any other we’d promised to deliver in the October blogpost. At long last, you and your users will be able to export their Power BI reports to either PDF or PowerPoint and have their selections on the screen […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/end-user-filtered-export-capabilities-now-available/. The author isAs part of our strategy to converge enterprise and self-service BI on Power BI as a single platform, we announced the public preview of incremental refresh last summer. While there is still more work to be done to get it to general availability, we have seen strong uptake of incremental refresh. Incremental refresh is a […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/. The author isWe’re very grateful to our customers, our community members, and our partners for making Power BI what it is today. Thank you. The Power BI Team Get the 2019 Gartner’s Magic Quadrant for Analytics and Business Intelligence Platforms report* to learn more. *This graphic […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/microsoft-a-leader-in-gartners-magic-quadrant-for-analytics-and-bi-platforms-for-12-consecutive-years/. The author isJanuary was a feature-filled month for the Power BI team! We kicked off this new year by announcing some of the highly requested features by our community and couldn’t have wished for a better start. We hope you’re just as excited for what’s to come for the rest of 2019! To recap, here’s a list […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-service-and-mobile-january-feature-summary/. The author isWith the Power BI craze that kicked into high gear in 2017, it’s less common to be working in PowerPivot in Excel. However, during one of my recent remote consulting calls, one of our many clients needed some help with… This post first appeared at https://powerpivotpro.com/2019/02/an-oldie-but-goodie-powerpivot-in-excel-existing-data-connections/. The author is Krissy DyessRead More
This post first appeared at https://powerpivotpro.com/2019/02/an-oldie-but-goodie-powerpivot-in-excel-existing-data-connections/. The author is Krissy DyessThe February 2019 release of Power BI Desktop includes some new functionality not mentioned in the summary blog post, functionality that is already in the latest Excel 365 builds (thanks Ed Hansberry for pointing this out) and will be extremely useful. It takes the form of four new options under the Split Column button in […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/mwP52400jMg/. The author is Chris WebbMatt here. The blog article this week was written by Neville de Sousa. Neville shared with me a Power BI report that shows all the Power BI features released since July 2015. Neville will explain the background and his report. Neville: Keeping track of Power BI Desktop’s amazing features since it went GA is difficult, […]
This post first appeared at https://exceleratorbi.com.au/power-bi-features-reporting/. The author is Neville de SousaThe February update for Power BI Desktop has a preview of our new Key Influencers visual, which lets you perform key drivers analysis over your data with just a few clicks. We also have some major updates for Q&A with the addition of auto-generated questions and the ability to ask Insights related questions. Our partners […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2019-feature-summary/. The author isTake a look at the new version of Power BI Premium Capacity Metrics app. In addition to comprehensive refresh , query and eviction metrics for past 7 days, the latest version now offers system metrics by workloads, and total active dataset size in memory metrics. In addition to demoing this latest version, Power BI program […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/webinar-2-12-tour-of-the-new-power-bi-premium-capacity-metrics-app-by-swati-gupta/. The author isWorking out how long a Power Query M query takes to run – the first step to troubleshooting refresh performance problems in Power BI or Excel – is something I have blogged about several times (see here, here and here for example). However, there are problems with all of these methods such as the need […]
This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/K2L4qBXmRgY/. The author is Chris WebbFollow @gilra Today Microsoft released a preview of the Template Apps – A new experience that was designed for partners and ISVs to deliver streamlined analytics to their clients (If you still don’t see this new experience, don’t worry – I was told by Microsoft that it will take couple of days to be fully […]
This post first appeared at https://datachant.com/2019/02/08/template-apps-in-power-bi/. The author is Gil RavivAs the volume and complexity of the data continue to grow exponentially, organizations need an analytics solution that is fast, secure, and easy-to-use, so they can extract critical insights from their data and take timely actions to maintain a competitive advantage. Power BI and Azure provide customers an unmatched combination for petabyte-scale analytics – we […]
This post first appeared at https://powerbi.microsoft.com/en-us/blog/petabyte-scale-analytics-with-power-bi-and-azure/. The author isRecently, I was helping someone on Power BI community forum on the issue of calendar over run while comparing values with last year’s data. I thought it would make a good article to share with others. The Problem I will illustrate the issue using the AdventureWorks database (I need to make some tweaks to do this). […]
This post first appeared at https://exceleratorbi.com.au/calendar-over-run-while-comparing-last-years-data/. The author is Matt Allington