October 2018 roundup, a list of 84, posts and videos about Power BI.
C# Corner
- Create Event Calendar In Power BI (by : C# Corner)
In this article, Dhruvin teachs us how we can create Event Calendar within Power BI
https://www.c-sharpcorner.com/article/create-event-calendar-in-power-bi/
Chris Webb's BI Blog
- A Function To Generate The M Code For A Table Type (by : Chris Webb's BI Blog)
M function that takes a table and returns the text for the M code that is needed to define a table type
https://blog.crossjoin.co.uk/2018/10/03/function-m-table-type/
- [Hors-série] Modern Workplace Conference Paris (by : Club Power BI)
Découvrez les 10 questions Power BI posées par des néophytes
https://www.youtube.com/watch?v=CTdk_r1Gadk - [Aix-en-Provence] Power BI et la cartographie (by : Club Power BI)
Nouveautés du mois d'octobre, la cartographie et retour d'expérience Power BI embarqué dans une application web
https://www.youtube.com/watch?v=-svqQwFOL4M
- Aggregations in Power BI - Power week 918 Power Bi Desktop update (by : Curbal)
Ruth discuss the new aggregation feature released by the Power BI team in the Power BI Desktop update of September 2018
https://www.youtube.com/watch?v=7KKcbcXFNgM - DAX Fridays! #100: One click download and sponsor me! (by : Curbal)
Ruth is celebrating the 100th DAX Fridays by sharing a link with you to all DAX Fridays and a link to sponsor the channel and help her keep going.
https://www.youtube.com/watch?v=Y645BM2WyQs - 6 productivity tips for Power Query (by : Curbal)
Discover 06 productivity tips for Power Query
https://www.youtube.com/watch?v=fPzX6WuUlHw - Data Profiling and Fuzzy Matching in Power Query | Power Week 10.18 Power BI Desktop October update (by : Curbal)
Ruth is presenting two Power Query new features, Data profiling and Fuzzy Matching.
https://www.youtube.com/watch?v=rYidpz545bU - Filter, connectors, and more | Power Week 10.18 - Power BI Desktop Update October. (by : Curbal)
Breief presentation of October 2018 Power BI Updates
https://www.youtube.com/watch?v=vx36jOOhHTE - Download Center for all Power Bi files, finally! (by : Curbal)
Here you can now download all the pbix files that I have made for you: https://curbal.com/donwload-center
https://www.youtube.com/watch?v=NzmZcuyjWB4&feature=youtu.be - DAX Fridays! #102: The DAX Editor | Power BI October 2018 Update (by : Curbal)
Ruth show us some shortcuts that the Power BI team released with the new DAX Editor
https://www.youtube.com/watch?v=z0Kj_oVmNUA - Make your Direct Queries run faster! (by : Curbal)
Discover how you could make your Direct Queries run faster!
https://www.youtube.com/watch?v=513vtuMw5bY - DAX Fridays! #103: UNICODE, UNICHAR, LEN (by : Curbal)
Follow Ruth to understand what are the UNICODE, UNICHAR en LEN DAX functions
https://www.youtube.com/watch?v=LjnWymCh_zE - Auto deploy M connectors | Power Query (by : Curbal)
In tyis viedo Ruth shows us how to auto deploy M connectors.
https://www.youtube.com/watch?v=e7ryCNalLos - #curbaldidyouknow | Sharing your Power Bi tips and tricks (by : Curbal)
Ruth invite us to use this the #curbaldidyoukonw hash tag to let her know when you want to share with her and the community a tips ot tricks on PBI, PQ and DAX
https://www.youtube.com/watch?v=MgdglM1vVww - Version control for Power BI files (by : Curbal)
In this video Ruth shows us how to do version control with Power BI files, or at least, one way to do it
https://www.youtube.com/watch?v=i3s9isKKdDs
- Finding mismatched headers and creating a conversion table – Bonus Exercise – Chapter 4 – #PowerQuery Book (by : Datachant)
Discover a bonus exercice from Gil new Power Query Book
https://datachant.com/2018/10/26/finding-mismatched-headers-and-creating-a-conversion-table-bonus-exercise-chapter-4-powerquery-book/?mc_cid=1761211327&mc_eid=0b1f0f9849
- Key Elements to Advanced Power BI Solutions - Free Training Workshop (by : Enterprise DNA)
Sam will be reviewing a number of techniques specifically around developing high quality reporting solutions in Power BI
https://www.youtube.com/watch?v=nH5CnjZjLMA - Automated & Dynamic Financial Reporting w/Power BI (by : Enterprise DNA)
Make your financial reports automated and dynamics
https://www.youtube.com/watch?v=kPhGxoL59BM - Reporting Templates Expanded - Power BI Visualization Concepts (by : Enterprise DNA)
Find how to create Financial Reports Templates
https://www.youtube.com/watch?v=wSgJXGAJaz4 - Different Ways You Can Use The TOPN Function - DAX In Power BI (by : Enterprise DNA)
In this tutorial Sam dives into a number of ways you can use the TOPN function inside Power BI
https://www.youtube.com/watch?v=hEUbzIcCp5w - When And How To Use The EARLIER Function In Power BI - DAX Concepts (by : Enterprise DNA)
In this tutorial Sam dives into one of the more advanced functions in the entire DAX language. EARLIER is a relatively difficult function to grasp
https://www.youtube.com/watch?v=62_H3Bxu9ZM - Predicting Future Results in Power BI - Enterprise DNA Webinar Series (by : Enterprise DNA)
Enterprise DNA Webinar
https://www.youtube.com/watch?v=8a8khhZ3l7E
Excelerator BI
- Visually Appealing Power BI Reports (by : Excelerator BI)
Matt presents 3 ways you can improve the visual appeal of your reports
https://exceleratorbi.com.au/visually-appealing-power-bi-reports/ - Data Profiling in Power BI (by : Excelerator BI)
Discover with Matt this new Power Query feature that comes with the October 2018 Power BI updates
https://exceleratorbi.com.au/data-profiling-in-power-bi/ - Create a Power BI Slicer Panel (by : Excelerator BI)
Discover with Matt how you can create a collapsible slicer pane that you can show and hide on demand
https://exceleratorbi.com.au/create-a-power-bi-slicer-panel/ - When to Use SUM() vs SUMX() (by : Excelerator BI)
This is an update of a three yers old article and on of the most read on Matt blog
https://exceleratorbi.com.au/use-sum-vs-sumx/
Excelguru
- Nuthin’ ain’t nuthin’ in Power Query (by : Excelguru)
Discover the difference between 'Null' and 'Blank' and why this is important in Power Query
https://www.excelguru.ca/blog/2018/10/04/nuthin-aint-nuthin-in-power-query/ - Analyzing text with Power Query and Excel (by : Excelguru)
Discover some ideas how Power Query can be used for analyzing text that is unstructured.
https://www.excelguru.ca/blog/2018/10/17/analyzing-text-with-power-query-and-excel/
Guy in a Cube
- Power BI Cheat Sheet, Power Query in MS Flow, Home and more... (October 1, 2018) (by : Guy in a Cube)
Comments on posts and articles published during the month of september 2018
https://www.youtube.com/watch?v=j13k3Somi2Y - Power BI Minesweeper, Visual reference, World tour and more... (October 8, 2018) (by : Guy in a Cube)
Comments on posts and articles published during the 1rst week of october 2018
https://www.youtube.com/watch?v=8OUvsyUJPsM - Mashup Engine Query Monitor for Power BI Refresh (by : Guy in a Cube)
Patrick introduces the Mashup Engine Query Monitor for Power BI Refresh. This is the MEQM! A report that can be useful to see SQL Server queries that Power BI issues during refresh.
https://www.youtube.com/watch?v=1_0B_ZN2sig - Design Power BI reports, Data Warehouse updates and more... (October 15, 2018) (by : Guy in a Cube)
Preview week Roundup
https://www.youtube.com/watch?v=yUZkqlfmI-Y - How to use the Power BI Aggregations Feature (by : Guy in a Cube)
In this video, Christian Wade will show you the clicks to get to the clicky clicky draggy droppy awesomeness when working with big data, or even massive data
https://www.youtube.com/watch?v=RdHSo43LkQg - Case of the Broken Power BI Incremental Refresh (by : Guy in a Cube)
In this video, Patrick looks at a scenario where Power BI incremental refresh was broken. He then looks at a way to get Power BI incremental refresh working properly.
https://www.youtube.com/watch?v=RnrCKn5ykCc - Microsoft R, Data Science and Power BI (by : Guy in a Cube)
Microsoft R, Data Science and Power BI
https://www.youtube.com/watch?v=yj3rZTwJZaA - Fuzzy match / merging in Power BI Desktop (October 2018) (by : Guy in a Cube)
Take a look with Patrick at the new fuzzy match / merging option within the October 2018 version of Power BI Desktop an incredibly powerful feature when it comes to data matching that can be adjusted to meet your needs
https://www.youtube.com/watch?v=I65YCrJWliw - #BIPowerHour, Tips, Slicer pane, Power BI Desktop and Gateway updates, more... (October 29, 2018) (by : Guy in a Cube)
Roundup of intersting posts catched by Adam
https://www.youtube.com/watch?v=HAhksUFmhWE - Power BI Tutorial: How to Sign up (by : Guy in a Cube)
In this video, Adam shows us how to get started using Power BI
https://www.youtube.com/watch?v=WyRO5hTxEUU
How To Excel
- Importing and Exporting Data from SharePoint and Excel (by : How To Excel)
How to import Data from a SharePoint List to an Excel Table using Power Query
https://www.howtoexcel.org/tutorials/sharepoint-and-excel/
Microsoft Ignite
- Microsoft Power BI Premium: Building enterprise-grade BI models for big data - BRK3107 (by : Microsoft Ignite)
Learn how to use Power BI Premium to create semantic models that are reused throughout large, enterprise organizations
https://www.youtube.com/watch?v=FIlKTItGpDo
Microsoft Power BI Blog and YouTube Channel
- Power BI Developer community September update (by : Microsoft Power BI Blog)
This blog post covers the latest updates for Power BI Developers community
https://powerbi.microsoft.com/fr-fr/blog/power-bi-developer-community-september-update-2018/ - Power BI Desktop October 2018 Feature Summary (by : Microsoft Power BI Blog)
Discover new features and improvement for the October 2018
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-2018-feature-summary/ - On-premises data gateway October update is now available (by : Microsoft Power BI Blog)
October updates for On-premises data gateway
https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-october-update-is-now-available-2/ - Announcing General Availability of Custom and Certified Connectors for Power BI (by : Microsoft Power BI Blog)
Announcement that Custom and Certified Connectors in Power BI are now generally available
https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-custom-and-certified-connectors-for-power-bi/ - Creative DAX solutions by Philip Seamark (by : Microsoft Power BI Youtube)
The webinar will explore some unusual and creative scenarios that you may not have thought of as feasible
https://www.youtube.com/watch?v=UzUMxy9GtAE - A look the Difinity conference with Leila Etaati (by : Microsoft Power BI Youtube)
Leila speeking about the "Difinity conference"
https://www.youtube.com/watch?v=e4Jw51hR8V8 - How to use Power Query and M to Create a Calendar Tables with Tristan Malherbe (by : Microsoft Power BI Youtube)
Tristan will deliver a webinar on how to build from the scratch a proper calendar table using Power Query and M language
https://www.youtube.com/watch?v=Ifi07EpRY4g - October 2018 Power BI Desktop Updates (by : Microsoft Power BI Youtube)
This month Amanda splited the hall video in individual ones (one bu section) and created a playlist
https://www.youtube.com/playlist?list=PL1N57mwBHtN1QB88J7UC5zQ-yIpjrcuW7 - Build Impactful Financial Dashboards Using Microsoft Power BI with Avi Singh (by : Microsoft Power BI Youtube)
In this video, Avi Singh, will show you how to build a impactful financial Dashboard
https://www.youtube.com/watch?v=1WQ2cayxjTo - Q&A and best practices managing Power BI Premium capacities with the Power BI Team (by : Microsoft Power BI Youtube)
Join Josh Caplan Group Program Manager on the Power BI team, as he discusses his plans for Power BI Premium
https://www.youtube.com/watch?v=YLhvGQ7C2m0
PhantomDB
- Keeping Big Data Big with Aggregations (by : PhantomDB)
Discover how to use aggregations approch to keep Big Data big.
https://phantomdb.com/2018/10/21/keeping-big-data-big-with-aggregations/
PowerBIPro
- Power BI Rank Within a Group Using the RANKX Function #Q&A (by : PowerBIPro)
Create a ranking chart, using the RANKX Function to make it super-easy to show Ranking within a Group in Power BI
https://www.youtube.com/watch?v=3u0WJFKxGJk - Traditional BI vs. Agile Power BI Talk (by : PowerBIPro)
A talk about dowinf Agile BI using Power BI with three guests
https://www.youtube.com/watch?v=LyVgpBW5Rcw - From Just an Accountant to Leading the Power BI Revolution on a Global Scale (by : PowerBIPro)
How do you go from being just another accountant in a company to someone who is leading Power BI transformation on a global scale?
https://www.youtube.com/watch?v=wASbVfhaEN8 - Power BI Data Modeling Challenge: Rolling Over Weekend Sales to Weekday (by : PowerBIPro)
In this video we tackle a Power BI Data Modeling Challenge to rollover weekend sales to Weekday.
https://www.youtube.com/watch?v=IwxwLlArFyY - Real Power BI with Lisa Randall (by : PowerBIPro)
Talk about Power BI with Lisa Randall
https://www.youtube.com/watch?v=rxRpXEwASdM - How a Power BI Side-Project Can Lead to Big Success! Feat. Barry Kresch (by : PowerBIPro)
Watch this video and learn how Barry Kresch, a Marketing and Media Research Consultant by profession, took his passion for electric vehicles and created a Power BI Side Project that may help shape its future
https://www.youtube.com/watch?v=2hLGKsVKpM0 - Power BI October 2018 Update (Monthly Update Highlights!) (by : PowerBIPro)
Avi's top 5 new features of the Power BI Desktop October 2018.
https://www.youtube.com/watch?v=PQgJs_SLYVo - From Lotus 1-2-3 to Mega Power BI Projects (feat. Michael Stanton) (by : PowerBIPro)
This powerful interview will push all your doubts in learning Power BI aside.
https://www.youtube.com/watch?v=6lvXC58zSDU - How to Create Power BI TOP N Report (Power BI Top 10 / Top N Filter) (by : PowerBIPro)
Avi shows us how we can create a Power BI TOP N Report, using a Top 10 or Top N Filter. As a bonus he also compares this with another approach using the DAX TOPN Function.
https://www.youtube.com/watch?v=4N-KocuYyNU
PowerPivot(pro)
- Comparing Rows in Power Query Part 1 (by : PowerPivot(pro))
Use Power Query to calculate the difference between one row and the previous row in a robust and refreshable way
https://powerpivotpro.com/2018/10/comparing-rows-in-power-query-part-1/ - So, You’re Getting a Data Warehouse for Power BI… (by : PowerPivot(pro))
Discover suggestion for aligning a data warehouse with Power BI
https://powerpivotpro.com/2018/10/so-youre-getting-a-data-warehouse-for-power-bi/ - Comparing Rows in Power Query Part 2 (by : PowerPivot(pro))
Follow the second part on using Power Query to calculate the difference between one row and previous row in a robust and refreshable way
https://powerpivotpro.com/2018/10/comparing-rows-in-power-query-part-2/ - Sourcing candidates and training a team on the Microsoft Data Platform (by : PowerPivot(pro))
General discusion
https://powerpivotpro.com/2018/10/sourcing-candidates-and-training-a-team-on-the-microsoft-data-platform/ - Connect Power Query to Amazon Web Services (Redshift Database) (by : PowerPivot(pro))
Learn with Doug how to connect Power Query to Amazone Web Services
https://powerpivotpro.com/2018/10/connect-power-query-to-amazon-web-services-redshift-database/
RADACAD
- Christian Wade Interview at Ignite 2018 Power BI Enterprise XMLA EndPoint Aggregations Incremental L (by : RADACAD)
Interview about all the new exciting features of Power BI for enterprises, such as XMLA Endpoint, Aggregations, Composite Model, Incremental Load and many more.
https://www.youtube.com/watch?v=CL8FM2SmEks - Bhavik Merchant Interview at Ignite 2018 Power BI and Reporting Services (by : RADACAD)
The talk is about Reporting Services and paginated reports in Power BI and the new plan of Power BI team for performance tuning
https://www.youtube.com/watch?v=oBkImFR-k7k - Justyna Lucznik Interview at Ignite 2018 Power BI and AI (by : RADACAD)
The interview is about AI features announced in Microsoft Ignite 2018 in Power BI Desktop, Power BI Service, and Power Query
https://www.youtube.com/watch?v=jW_kTwgIJRA - Ken Puls Interview at Ignite 2018 Thoughts on Power Query Announcements at Ignite (by : RADACAD)
Ken Puls talking about his thoughts on Power Query and Power BI announcements at Ignite 2018
https://www.youtube.com/watch?v=YykH8Z5KYFc - Mark Ginnebaugh Interview at Ignite 2018 on Microsoft Regional Director and MVP programs (by : RADACAD)
The interview is about these two programs and some of his experience at Ignite 2018
https://www.youtube.com/watch?v=Lr2hmqhG8fA - Fun with DAX – Minesweeper (by : RADACAD)
Lear how to create the Minesweeper game using DAX in Power BI
http://radacad.com/fun-with-dax-minesweeper - Quick DAX : Word count (by : RADACAD)
Discover how to use the MID function to split text down to individual words in DAX.
http://radacad.com/quick-dax-word-count - Power BI and Azure ML make them work with Power Query (by : RADACAD)
Leila show us how to use the Azure ML web service in Power BI (Power Query)
http://radacad.com/power-bi-and-azure-ml-make-them-work-with-power-query - Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold (by : RADACAD)
Explore in details, with Reza, how the fuzzy matching works in Power BI
http://radacad.com/fuzzy-matching-in-power-bi-and-power-query-match-based-on-similarity-threshold - Find Lost Customers Using Power BI and DAX (by : RADACAD)
Learn how to use Power BI and DAX to find lost customers and new customers easily with a video at the and of the post (https://www.youtube.com/watch?v=m1uupRDWzQw)
http://radacad.com/lost-customers-dax-calculation-for-power-bi
SQL BI
- Power BI Visuals Reference V2.0 (by : SQL BI)
Release of the V2.0 of the The ultimate reference for Power BI charts and visuals.
https://www.sqlbi.com/ref/power-bi-visuals-reference/ - Displaying the Nth element in DAX (by : SQL BI)
This article describes how to create a measure displaying the name or value of an element that has a specific ranking, with different option for managing ties.
https://www.sqlbi.com/articles/displaying-nth-element-in-dax/ - Optimizing IF and SWITCH expressions using variables (by : SQL BI)
This article describes how variables should be used in DAX expressions involving IF and SWITCH statements in order to improve performance
https://www.sqlbi.com/articles/optimizing-if-and-switch-expressions-using-variables/
The BICCOUNTANT
- Find and index duplicate figures in Power BI and Power Query (by : The BICCOUNTANT)
How to find duplicate rows in a table and add a nested index to each duplicate row.
https://www.youtube.com/watch?v=cXb308NPU2M - Return all occurrences of text between delimiters in Power BI and Power Query (by : The BICCOUNTANT)
How to retrieve all occurrences of strings between in a text field
https://www.thebiccountant.com/2018/10/26/return-all-occurrences-of-text-between-delimiters-in-power-bi-and-power-query/ - Create list of accounts from NAV account schedules or COA totaling syntax (by : The BICCOUNTANT)
Imke shows us how to create a list of account numbers from the totalling syntax that you find in Dynamics NAV account schedules or chart of accounts
https://www.thebiccountant.com/2018/10/27/create-list-of-accounts-from-nav-account-schedules-totalling-power-bi-power-query/
biDezine
- 2018 October Update - Power Bi Desktop (by : biDezine)
Power BI Desktop updates for October 2018
https://www.youtube.com/watch?v=WnlO0XLdPjM
Fourmoo
- Quick Tips for Aggregations & Composite Models in Power BI (by : fourmoo)
Gilbert present some tips that he found few useful to assist you with getting up and running on the implementation of Aggregations with Composite Models in Power BI
https://www.fourmoo.com/2018/10/23/quick-tips-for-aggregations-composite-models-in-power-bi/
Aucun commentaire:
Enregistrer un commentaire