For the November 2018 month, I have read or watch no less than 105 blog posts, announcements or videos all reported bellow.
Access Analytic
- Power Query Skills: Dynamic header row reference when its position is unknown, plus other tips
Imagine the millions of unproductive hours that would be saved around the world if more people knew what Excel is now capable of. --> More details
BI Elite
- Power BI - Explore My Youtube Data!
Explore Parker (BI Elite) report on his YouTube channel analytics. --> More details - Power BI - Time Since Last Refresh
Learn with Parker how to create a measure to display how long it's been since last refresh! --> More details - Power BI - Last 12 Months from Selected Date (Trailing 12 Months TTM)
n this Power BI tutorial I will show you how to show the previous 12 months of data when the user clicks on a single date selection. --> More details - Power BI - Highlighting Positive and Negative Values in a Bar Chart
A quick Power BI tutorial on how to show positive bars as green and negative bars as red in a bar chart using the conditional formatting functionality. --> More details
BI Polar
- Power BI Dataflows – Reuse without Premium
The goal of this post is to dispel two common misconceptions that I see related to Power BI dataflows and Power BI Premium. --> More details - Power BI Dafalows FAQ
An unofficial FAQ on Power BI Dataflows published by Matthew where he answers 17 questions about the subject. --> More details
Bonjour Joël
- Power BI Videos published during last 30 days on YouTube
A Power BI report refreshed every day that lists the latest video publisher on the web during the last 30 days --> More details - Où trouver la roadmap Power BI ?
Retrouvez une liste des fonctionnalités planifiés (en preview ou en disponiubilité générale) jusqu'à mars 2019 --> More details
Chris Webb's BI Blog
- Nested Display Folders In Power BI
Discover with Chris the nested display folders in Power BI --> More details - Complex Filter Conditions In Power BI Reports Using Visual-Level Filters And Measures
In this blog post Chris is going to show you how you can use visual-level filters and measures in combination --> More details
"
Club Power BI
- [PARIS] - News & Power Query
- Mise à jour Novembre 2018 Power BI - Power Query & Data Flows --> More details
"
Curbal
- Curbal Tech News: News on custom and certified connectors
Updates on Power Query --> More details - Power Query Online Training for Beginners
In this course, Ruth will explain how Power Query Works, go through Power Query’s user interface and learn a little bit about M. --> More details - Fill down not working | Sample lesson from Power Query online course
A sample lesson of Ruth online Power Query course about using the Fill feature --> More details - News on export to PowerPoint in Power BI Service | Curbal Tech News - Nov 2018
All is in the title --> More details - Expand and collapse rows in a matrix | Power Week 11.18 - Power BI Desktop Update Nov
Discover with Ruth the new Expand and collapse row in a matrix feature on Power BI Desktop --> More details - New filter pane in Power BI | Power Week 11.18 - Power BI Desktop Update November 2018
Discover with Ruth the revisited Filter Pane --> More details - DAX Fridays! #105: ISINSCOPE + 2 cool DAX editor tips
The IsInScope new DAX function explained by Ruth. --> More details - Copy and paste visuals in Power BI | Power Week 11.18 - Power BI Desktop Update November 2018
Ruth demonstrate the new Copy and Past feature in the November 2018 Power BI desktop Update --> More details - Conditional formatting for more visuals in Power BI | Power Week 11.18 - Power BI Desktop Nov 2018
Ruth is presenting the improvement made to the conditional formating in the November 2018 PBI Desktop Updates --> More details - New modeling view in Power BI + address DAX Horrors comment | Power week 11.18
In today's video we are going to review the new modeling tab that was introduced in the Power BI Desktop update November 2018 and I will also explain myself regarding my statement on the DAX Horrors video. --> More details - DAX Fridays! #106: Power Query or DAX?
Ruth opinion on what to learn first DAX or Power Query --> More details - Testing dataflows in Power BI Pro and Premium accounts
Ruth explores for us the new "Dataflows" feature just added in Power BI Pro and Premium. --> More details - DAX Fridays! #107: Create memory efficient models for Excel or Power BI
Discover, with Ruth, 5 tips to build a tightly constructed model that’s easier to work with and uses less memory. --> More details
DataVeld
- 5 Performance Tips for R and Python Scripts in Power BI
Understand a bit about the process of how Power BI runs R and Python scripts–especially relating to local disk input/output in order to minimize performance problems and optimize your code, --> More details - SVG Measures of Any Size in Power BI
Discover how to use the "Image" by CloudScope custom visual to overcomes the limitation of the HTML Viewer to allow a lager size for you dynamic SVG measure --> More details - Tableau to Power BI: Highlighting with Set Actions
Set Actions, a new features in Tableau 2018.3 which allows users to build interactivity between sheets on a dashboard --> More details - Create a Dynamic Diverging Stacked Bar Chart in Power BI (or Don’t)
Discover with David how to create a Dynamic Diverging Stacked Bar Charts in Power BI --> More details
Datachant
- Preserving Context from CSV – Bonus Exercise – Chapter 5 – #PowerQuery Book
A bonus exercice from Gil book --> More details - Text Analytics Power BI Template – All In One
Gil describs how to build a Power BI Templete that takes you through the analysis of multi-lingual text feeds from the detection of languages, translation of unsupported languages, and the implementation of sentiment analysis and key phrase extraction. --> More details
Enterprise DNA
- What Is Cohort Analysis? - Advanced Power BI Analysis Introduction
Discover with Sam what is Cohor Analysis and how to do it in Power BI --> More details - How To Setup Application Like Reports - Power BI Reporting Techniques
Discover this reporting technique that let you create a report navigation view --> More details - Analyzing Scenario Events In Power BI - Unique Analysis Technique
All is in the title --> More details - Enterprise DNA Learning Summit - November 2018, Session 1
In this 1rst session Sam is exploring DAX Fundamentals --> More details - Enterprise DNA Learning Summit - November 2018, Session 2
In this 2nd session, Sam will demonstrate the latest Visualization Tips & Tricks --> More details - Enterprise DNA Learning Summit - November 2018, Session 3
In this 3rd session, Sam will introduce the Cohort Analysis --> More details
"
- Enterprise DNA Learning Summit - November 2018, Session 4
Discover with Sam in this 4th session more about. • Unique, never before seen, analysis ideas • Review discrete events with scenarios applied • Save event scenarios for future referencing • Allocate degree of probability to outcomes --> More details
"
- Enterprise DNA Learning Summit - November 2018, Session 5
In this 5th session, Sam will explore Cross Selling Deep Dive --> More details
Excel On Fire
- Power Query: Keep all Capital Letters with Text.Select in M-Code
Oz explains how to use Text.Select() PQ function to keep only capitol letters. --> More details
ExcelIsFun
- MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions
According to Mike, this video teaches everything you need to know about Power Pivot, Data Modeling and building DAX Formulas, including all the gotchas that most Introductory videos do not teach you!!! --> More details
Excelerator BI
- Power BI is an Enigma, so What to Do?
Explore with Matt what you need to learn if you need to be competent using Power BI --> More details - Power BI Dataflows, and Why You Should Care
Discover with Matt what is Dataflow and why you should care --> More details - Create a Planning View of Your Outlook Diary in Power BI
Learn how to create a report that show you your Outlook events --> More details - Moving Queries from Power BI Desktop to Dataflows
In tihs post, Matt explain how and why you may want to move your queries to dataflows. --> More details - Importing XLSB into Power BI
Matt is discussing the way to import XLSB file into Power BI --> More details
Guy in a Cube
- Power BI Updates - Dataflows, Paginated reports, Metrics app and more... (November 12, 2018)
Roundup of intersting posts catched by Adam --> More details - Power BI visuals, Dataflows, AS Birthday and more... (November 19, 2018)
Roundup of intersting posts catched by Adam --> More details - Slicer Restatement in Power BI
In this video, Patrick looks at a small feature called slicer restatement in Power BI. This feature will help you to determine what was selected in a slicer. While this feature was added back in April 2018, we are betting that most folks don't know slicer restatement --> More details
Havens Consulting
- Naming Objects in the Power BI Selection Pane
Discover with Reid how to name object in the selection pane a best practice to apply any time --> More details - Three Essential Transformations for Power Query
Reid is presenting three essential techniques that can be applied to any query and explain why these techniques are important for data modeling, and demonstrate how they're applied in the query editor --> More details - Using the Power Query Reference Feature to Reduce Query Dependencies
Learn about an important feature in the Power BI query editor. Referencing other queries. Using this feature will help reduce query dependencies and allow for easier updates if the data source changes for the report --> More details
How To Excel
- Create A Parameter Table For Your Power Queries
Learn how to create a parameter in power query either using the native parameter functionality or by creating a table of parameters in your worksheet --> More details
Kasper On BI
- Use IsInScope to get the right hierarchy level in DAX
Discover with Kasper how you can use IsInScope to get the right hierarchy level in DAX. --> More details
Le CFO Masqué
- Power BI Dashboard Makeover : Présentation et vidéo
Consulter l’enregistrement et de télécharger la présentation d’accompagnement du webinaire du 7 novembre 2018 intitulé "Power BI Dashboard Makeover" --> More details - Power BI: Enrayez vos erreurs au fur et à mesure
Découvrez avec Sophie quelques approches pour vous aider à préparer des données intègres pour vos analyses. --> More details
Microsoft Power BI Blog
- Export to PowerPoint is now generally available and looking ahead at what’s coming next
Announcement the general vailability of Export to PowerPoint --> More details - Paginated report metrics and dataflow metrics now available in Premium Capacity Metrics app
All is in the title --> More details - Power BI Paginated Reports also available in Power BI Mobile Apps (preview)
--> More details - Introducing: Power BI data prep with dataflows
--> More details - Power BI delivers dataflows, enterprise reporting, and major updates to Power BI Desktop
--> More details - Public Preview of Paginated Reports in Power BI Premium Now Available
--> More details - Power BI Desktop November 2018 Feature Summary
Discover with Amanda the November 2018 Power BI Desktop --> More details - Announcing new AI Capabilities for Power BI to make AI Accessible for Everyone
All is in the title --> More details - Dataset size and count now available in Power BI Premium Capacity Metrics App
All is in the title --> More details - Analysis Services is 20 years old!
A webinar to celebrate 20 years old of Analysis Services. It includes a timeline of the history, community tools, and interviews from some of the influencers of Analysis Services over the years --> More details - On-premises data gateway November update is now available
Discover what is new to On-premises data gateway (version 3000.0.155.1) --> More details - Modeling View in Power BI Desktop
A snapshot on the new Modeling View feature by Christian --> More details
Microsoft Power BI Youtube
- Introducing: Power BI data prep with dataflows
Discover with Matthew the power of Power BI Dataflows. --> More details - Introducing Paginated reports in Power BI
In this video, Patrick LeBlanc shows how you can use paginated reports within Power BI. These are the reports you have been able to use with SQL Server Reporting Services and Power BI Report Server, but now are available within Power BI using Power BI Premium --> More details - Advanced data prep with Power BI dataflows—for unified data and powerful insights
Power BI dataflows’ public preview is just around the corner, in this session the product team will introduce you the new and advanced capabilities for data-prep in Power BI. --> More details - Power BI Desktop November 2018 Feature Summary
Discover with Amanda the November 2018 Power BI Desktop --> More details - Meet and ask the Microsoft Report Server team anything
In this webinar the Report Server team is answering questions. --> More details
MyOnlineTraining
- Excel Power Query Pivot Chart
Mynda is presenting a work aroud to create a Pivot Chart in Excel using a regular chart so you can get more charts types --> More details
PASS Summit 2018
- PASS Summit 2018 - Do Your Data Visualizations Need A Makeover?
In her session Meagan explained how we often set ourselves up for failure when conducting explanatory data visualization before we ever place a visual on the page by not preparing appropriately, and she provided tips to improve. She also gave examples of visual design mistakes she see often --> More details
Paul Turley Youtube Channel
- Power BI Licensing
Paul explain how to asign Power BI Pro Licences to users in your organization --> More details
Power BI Tips and Tricks
- Power BI Dataflows: Change is Coming
All is in the title --> More details
PowerBIPro
- How to Create Power BI TOP N Report (Variable N, Show Top 10/50/100…)
Avi shows us how we can create a Power BI TOP N Report , using a Variable N, that means we can show Top 10, Top 50, Top 100 or really any Top or Bottom Number we like --> More details - Power BI November 2018 Update (Monthly Update Highlights!)
Avi presenting his Top 5 new features for the Power BI November 2018 --> More details - 5 Ways to Use TOP N in Power BI (Talk Power BI LIVE)
In this live tolk, Avi shows us 05 ways to us TOP N in Power BI --> More details
PowerPivot(pro)
- Automated Testing With Power Query
Discover a quick tip on Automated Testing with Power Query So Query Fails when Needed --> More details - Techniques With COUNTROWS
Kriss is presenting his MOST important Power BI data model development technique which he call the KAT. --> More details - Dynamically Embedding Web Pages in Power BI
All is in the title --> More details - Reducing DSO using Power Pivot
Sakiko show us how to reduce the days sales outstanding using power pivot to check accounts --> More details - A different use for Power BI: Self-service refreshes and extracts to Excel while managing security in Power BI
Hele explain how to use Power BI to extract data from an SQL Batadase to export it to Excel --> More details - Hijacking the R Visual
Another post on how to extend your visuals collection by using R scripts --> More details
Powered Solutions
- Extracting Header and Footer Values from Documents, Files using Power BI + Using PDF Connector
Learn with Miguel how to extract data from the header or the footer of a PDF file. --> More details
Pragmatic Works
- Power BI Monthly Digest - November 2018
A digest of what is new in Power BI for November 2018 --> More details
RADACAD
- Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 1
Leila shows us how to create a Power APP for taking a photo, then the process of how to create a Microsoft Flow to apply the cognitive service, convert image to text service (OCR), then post back data to Power APP and also to Power BI --> More details - Image Processing- Invoice recording using Power App, Microsoft Flow and Cognitive Service- Part 2
In this post, Leila is going to show how to connect the Power APP, that you created in Part One for the aim of taking a photo from your receipt, send it to the Microsoft Flow and cognitive service to convert the image to text. --> More details - Find the Most Expensive Columns for Performance Tuning, Bookmarks, and more with Power BI Helper Version November 2018
Discover with Reza what is new in Power BI Helper --> More details - Overview On Microsoft Machine Learning Tools
All is in the title --> More details - UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI
In this post, Reza will explain to you everything you need to know about a dashed relationship, or as it called Inactive relationship. He also will explain two different methods that you can deal with this kind of relationship. --> More details - SUM vs SUMX; What is the Difference of the two DAX Functions in Power BI?
Learn more about SUM and SUMX DAX functions --> More details - Quick Measures in Power BI: You don’t have to write DAX!?
Discover with Reza what are quick measures and what you can achieve with them --> More details - Fun with DAX – A-Maze-ing DAX
All is in the title --> More details
SQL BI
- Showing actuals and forecasts in the same chart with Power BI
In budgeting reports, a common requirement is to show future sales forecast and actual sales volume on the same line chart. This article describes how to achieve this goal using DAX. --> More details - VetiPaq Analyzer v1.91
The version 1.91 of VaertiPaq Analzer hab just been released. --> More details - Improving temporal line charts in Power BI with DAX
This article shows how to improve line charts with a date-based axis in Power BI using DAX and making correct choices in data modeling and visualization properties. --> More details
The BICCOUNTANT
- Why Power BI isn’t suitable for Financial Statements (… currently … hopefully …)
A clickbait post from Imke to get us vote for some missing features in Power BI --> More details - Improved Text.SplitAny – function for Power BI and Power Query
Imke explains how you can modify the native Text.SplitAny function to improve it. --> More details
The White Pages
- Get the most out of Power Query in Power BI Dataflows
Discover with John "Power BI Dataflows", the new Power Query web based interface and what is important to know about it. --> More details
Tristan Malherbe Youtube
- Introduction to Power BI
Tristan introducing Power BI to the Power Community in Dubai --> More details
Will Thompson's Power BI Blog
- Project timeline reporting in Power BI
Will responding to a challenge where he have to build a Gantt-chart-like using Power BI --> More details
XXL BI
- New DAX function: ISINSCOPE
In this blog post, Daniil is going to show where ISINSCOPE new DAX function can be useful. --> More details
Aucun commentaire:
Enregistrer un commentaire