PowerBI.tips

Author: mike carlo

  • Monkey Tools are AWESOME

    Monkey Tools are AWESOME

    The Monkey Tools add-in for excel is really amazing. As a developer for Power BI for many years I’ve learn a ton of tips and tricks while working with Power Query. Watching Ken demo the high level of automation that Monkey Tools really blew my mind. How did I not know about this tool earlier?! My development patterns have now forever changed.

    This presentation for Monkey Tools is presented by it’s developer MVP Ken Puls. Ken is a staple and expert in the Excel community. Not to mention, he is an incredible presenter. You will enjoy this session from Ken.

    What are Monkey Tools?

    Monkey tools in short is a simple way to automate data modeling within Excel. There are some incredibly helpful portions such as making date calendars, changing how data is handled during Power Query loading process and many more.

    Ken gives us a great overview and starts digging into the amazing features of this tool in this two part series about this tool.

    Download Monkey Tools Here

    Intro to Monkey Tools – Part 1

    Intro to Monkey Tools – Part 2

    Follow Ken

    Blog: https://xlguru.ca/blog
    Facebook: https://facebook.com/xlguru
    Twitter: https://twitter.com/kpuls
    Linkedin: https://linkedin.com/in/kenpuls

    Training

    Online Training: https://Skillwave.training

    Book by Ken

    Master Your Data with Excel and Power BI: https://amzn.to/2PyheVm
    M is for (Data) Monkey: https://amzn.to/30BElov
    RibbonX: Customizing the Office 2007 Ribbon: https://amzn.to/3fzPDh1

    Download Monkey Tools

    https://xlguru.ca/monkeytools

    If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

    Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:

    Check out the new Merch!

    Hasta La Vista Data
    Go Ahead Make My Data
    PBIX Hat


  • Milwaukee Brew City PUG – July 2020

    Milwaukee Brew City PUG – July 2020

    Welcome to July! This month we have Tommy Puglia from the Chicago Power BI User Group joining us to discuss and talk about driving organizational success with Power BI.

    Tommy is an expert and has spent years deploying Power BI within various organizations. Check out the video below from the July 2020 Milwaukee Brew City Power BI user group.

    If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

    Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:

    Check out the new Merch!

    Hasta La Vista Data
    Go Ahead Make My Data
    PBIX Hat


  • MVPs React July 2020

    MVPs React July 2020

    This month we are trying something brand new. We are introducing a new series called MVPs react. As you may already know Power BI has monthly desktop releases. If you are as excited about these releases as I am I love talking about all the new features. So, why not get a fun group of MVPs together to discuss everything.

    These events are similar to a fire side chat about Power BI among the best experts within the community. We hope you enjoy the conversation, and learn a couple new things as well.

    Here is our session for the Power BI desktop release for July 2020.

    If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

    Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:

    Check out the new Merch!

    Hasta La Vista Data
    Go Ahead Make My Data
    PBIX Hat


  • DAX Studio 2.11 Released

    DAX Studio 2.11 Released

    If you haven’t heard about DAX Studio, well now you have. DAX studio is an essential tool for Power BI developers. It enables you to explore and tune your tabular model with ease. This month we are pleased to have the creator of this tool Darren Gosbell present to us the latest updates for DAX Studio.

    DAX Studio has just released it’s latest version 2.11.1.  With this release comes a number of great improvements. 

    New features include

    • Query Builder
    • Query Benchmark
    • More Quick access buttons
    • Exporting button for  trace outputs
    • Tooltips for tabs
    • And many more….

    Watch the Webinar

    Recent Releases

    DAX Studio 2.11.0 Released
    DAX Studio 2.11.1 Release

    Follow Darren
    Website: http://geekswithblogs.net/darrengosbell/Default.aspx
    MVP: https://mvp.microsoft.com/en-us/PublicProfile/35889?fullName=Darren%20Gosbell
    Twitter Handle: @darrengosbell
    Linkedin: https://www.linkedin.com/in/darrengosbell

    If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

    Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:

    Check out the new Merch!

    Hasta La Vista Data
    Go Ahead Make My Data
    PBIX Hat


  • Milwaukee Brew City PUG – June 2020

    Milwaukee Brew City PUG – June 2020

    This month’s Milwaukee Power BI User group we have Reza Rad from Radacad.com. Reza has a long history within the Power BI MVP community. His presentation this month is about how to use dataflows and shared datasets.

    Check out the recorded session below.

    Discounts on Training

    Like Reza’s training, visit the additional learning materials from Reza.
    Use the discount code  “PowerBITips”  to receive a $30 discount on your first month of training.
    Get the training: https://learn.radacad.com/product/academy-membership/

    Download Presentation Slides: https://bit.ly/2YNmBW3

    Follow Reza

    Catch Reza on LinkedIn: https://nz.linkedin.com/in/rezarad
    Visit the website: https://radacad.com/
    Books from Reza: https://radacad.com/ourbooks

    Learn more about dataflows:
    https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-overview
    https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-create-use#creating-a-dataflow

    If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

    Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:

    Check out the new Merch!

    Hasta La Vista Data
    Go Ahead Make My Data
    PBIX Hat


  • Using Lasso with New Shortcuts

    Using Lasso with New Shortcuts

    The April 2020 Power BI desktop release is an amazing release. This month the Power BI team has released a new lasso feature to enable users to select multiple visuals at a time. For me working in reports with lots of strategically placed visuals, this is HUGE!! How many times have I struggled to select a visual. Or, better yet needed to open up the visualization pane to select visuals from a list. The Lasso feature is a very welcome addition to the Power BI toolkit.

    New Shortcuts

    Another interesting feature that I found this month is the ability for Grouping visuals using key commands.

    You can Group Visuals using CTRL + G

    Then you can Un-Group them using SHIFT + CTRL + G

    Like all visual editing programs and even in power point these commands are very common. Thus, seeing these commands in Desktop is amazing. Power BI Team, thanks so much for your wonderful work!!!

    Video Tutorial

    Download PowerBI Desktop

    Want to use these features. Head on over to the PowerBI.com site and download the latest release. Download Here

    If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

    Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:

    Check out the new Merch!

    Hasta La Vista Data
    Go Ahead Make My Data
    PBIX Hat


  • Get to know ALM Toolkit

    Get to know ALM Toolkit

    The ALM Toolkit is an excellent tool for aiding users with Tabular Model management. Christian Wade has been generous enough to provide us with a detailed tutorial on the ALM ToolKit.

    In this webinar Christian Wade takes us on a guided tour of the key features and use cases for ALM ToolKit.

    ALM Toolkit Feature Set

    • Database Compare
    • Code Merging
    • Making Deployment Easy
    • Source-control Integration
    • Reuse of common Definitions

    YouTube Video of Webinar

    If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

    Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:

    Check out the new Merch!

    Hasta La Vista Data
    Go Ahead Make My Data
    PBIX Hat


  • Tabular Editor Rocks!

    Tabular Editor Rocks!

    Tabular Editor is an incredible Tool that enables users to manipulate a Tabular model at lighting speeds.  Daniel Otykier is the creator of the Tabular Editor program. We are producing a video series to enable users of Power BI and data modelers for Analysis Services to learn more about this program.

    Trust me this will be the best 4 hours of learning you will do this year. Learn about Tabular Editor and how it can save you HOURS of time. It will be worth it.

    In this Series

    This series will be broken down in to four topics.

    • Introduction
    • Using Scripting to remove repetitive tasks
    • Best Practice Analyzer to ensure your model is top notch
    • Incorporating DevOps with Tabular Models

    Introduction

    Daniel walks us through the basics of the program. We get a little bit of history on how the tool was developed and why you need to know about it.

    Using Scripting

    This by far is where the tool shines. Scripting allows users to automate common tasks for, creating measures, adding descriptions, building common calculations, hiding measure and more.

    Best Practice Analyzer

    Model running slow? This feature of Tabular Editor will allow you to quickly review your entire model and find areas for improvement.

    DevOps

    Once you have a data model how do you control versions? Or, can multiple people work on the same data model? Yes, to both of these questions. This video discusses manage data models with a DevOps pipeline.

    All Videos

    What all the videos in the series from Start to finish.

    More about Daniel

    Slides for Tutorials

    Click this link to download all the power point slides for this tutorial series.

    If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

    Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:

    Check out the new Merch!

    Hasta La Vista Data
    Go Ahead Make My Data
    PBIX Hat


  • Milwaukee Brew City PUG – Feb 2020

    Milwaukee Brew City PUG – Feb 2020

    The Milwaukee Brew City PUG for February had tons of rich demo content. Steve Campbell delivered quite a session for an hour and a half. We were able to record this session and are happy to announce all the videos are now up on YouTube.

    See all the Tutorials for February Pug

    View the YouTube Videos

    If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

    Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:

    Check out the new Merch!

    Hasta La Vista Data
    Go Ahead Make My Data
    PBIX Hat


  • Mind Blown

    Mind Blown

    This report is just over the top amazing cool! Check out the work done by the Microsoft team to make this incredible report. It is called the Microsoft Sales & Returns report. We love this one so much we have produced over 48 HIGH RESOLUTION scrims based on this report design. Download all of them for free.

    Download Scrims

    Here is the link to the Scrims for this report: https://powerbi.tips/product/scrims-msft-skateboard-report-free/

    Download a copy of this report to play with it: https://github.com/MikeCarlo/Msft-Skateboard-Report

    Sample Report

    Scrims

    Not sure what a scrim is. Check out the following page to learn about a scrim and how to use them for your reports.

    Learn about Scrims

    Instructions on how to use a Scrim

    If you like the content from PowerBI.Tips please follow us on all the social outlets. Stay up to date on all the latest features and free tutorials.  Subscribe to our YouTube Channel.  Or follow us on the social channels, Twitter and LinkedIn where we will post all the announcements for new tutorials and content.

    Introducing our PowerBI.tips SWAG store. Check out all the fun PowerBI.tips clothing and products:

    Check out the new Merch!

    Hasta La Vista Data
    Go Ahead Make My Data
    PBIX Hat