Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI - Tips for your next Data Analytics Project
Rating: 4.5 out of 5(23 ratings)
193 students

Power BI - Tips for your next Data Analytics Project

Tips in Power BI step by step, How to learn Power BI fast and how to apply DAX in Power BI with Power BI project tips
Created byDan We
Last updated 5/2023
English
English [Auto],

What you'll learn

  • You learn Microsoft Power BI tips and tricks from project experience and research
  • You have additional knowledge you can apply in your next projects
  • You improve your skills which you have acquired so far
  • You are or want to become a data analyst

Course content

1 section • 18 lectures • 2h 7m total length

  • 1 Best Power BI tips and tricks Intro1:02
  • One important thing before you start0:24
  • Download latest course files0:03
  • Setting up the datamodel and basic DAX calculations17:33

    Set up the Power BI data model by importing Excel data, cleaning it, creating a date table, and building DAX measures for total sales, last year, and cumulative sales.

  • 2 Power BI How to filter only one Measure in our visualization Trick7:52

    Learn to filter only a single measure in a Power BI chart with a dedicated date slicer and a DAX sliced cumulative measure, keeping other measures unaffected.

  • 3 Power BI How to create a dynamic reference line in our visualizations7:11

    Create a dynamic reference line in Power BI visuals by using a date slicer from the dates table, build a conditional measure, and switch to a line-and-column chart.

  • 4 Power BI Project Management - How to create a burndown chart13:08

    Create a burndown chart in Power BI to track sprint progress with a line chart, calendar table, and custom calculations.

  • 5 Power BI How to extract the age of a person using PowerQuery Editor4:59

    Extract the age of a person from birth dates using Power Query Editor in Power BI, by importing a table from Excel and calculating total years, rounding down.

  • 6 Power BI DAX How to filter unrelated tables single and multiple values19:35

    Learn how to filter data between unrelated Power BI tables using DAX, covering single-value filtering with selected value and multi-value filtering with in, using the concatenate function to display selections.

  • 7 Power BI How to visualize KPIs in Tables10:37

    Learn to visualize KPIs in a Power BI table by calculating total sales versus last year, format currency, and use a switch expression with up arrows for clear KPI insights.

  • 8 Power BI Update - Using Images for visualizing KPIs in Tables2:01

    Explore visualizing KPIs in Power BI tables by using internet images via image URLs, replacing symbols, and setting field type and data category to show up or down indicators.

  • 9 Power BI Dynamic previous sales based on the Datehierarchy9:37

    Create a dynamic previous sales measure in Power BI. Show prior periods across year, quarter, month, or day using is in scope and date at functions with a dates table.

  • 10 Power BI dynamic color coding for Gaugechart11:33

    Create a Power BI gauge chart with dynamic color coding based on total sales against budget and goal, using a color coding measure with hex codes and conditional formatting.

  • 11 Dynamic Webscraping in Power BI using custom functions and parameters in the18:54

    Learn to scrape the web dynamically in power bi by using parameters and custom functions to build a reusable data query for multiple years.

  • DAX Motivation Never give up keep going1:02

    Stay motivated while learning DAX in Power BI, start small, dissect your code, embrace repetition, and keep going through common early challenges of building visualizations and interactive reports.

  • NEW - A free resource for bonus videos tips and tricks0:04
  • 13 Final words - Congratulations to you0:38

    Words of congratulations as you finish the course, apply Power BI tips to your data analytics projects, amaze your audience, and boost your policy skills for a career in politics.

  • More learning together1:00

Requirements

  • Download Microsoft Power BI Desktop (free)
  • If you have no experience I would encourage you to start with my Power BI Masterclass - beginners to advanced course first.
  • You should have worked with Microsoft Power BI before

Description

Microsoft Power BI Masterclass - Additional Tips and Tricks 

Business Intelligence / Business Analytics is in high demand. Companies are constantly searching for ways to make better and faster and smarter decisions. Therefore they rely heavily on data. Small company or Multinational -  data driven decision making is the key to success for any business in the world of tomorrow.

Because of that companies are drastically increasing to step up their efforts to find skilled employees and freelancers with the necessary capabilities to help with analyzing data and creating valuable highly profitable insights. 

Since there is way more demand than supply it is a "War for talent". And the competition will increase further. This environment is a bless for anyone who acquires the necessary capabilities and positions herself/himself


MS Power BI is an advanced yet easy to get started self service business analytics / business intelligence solution provided by Microsoft which is currently in very hot demand. From my personal experience I can tell you that companies will actively searching for you if you master Power BI. Diving into data & analytics can not only immensely improve your career opportunities but also your job satisfaction!

Power BI is also a great tool for data science too. A lot of data scientists like to use it for visualizing and presenting the findings. Therefore learning to use this tool can also be a valuable skill for data science jobs.


This course extends my Power BI Masterclass series on udemy. This course is not topic specific like other ones. I wanted to share tips and tricks I learned from personal Microsoft Power BI projects and from personal research on this topic. My goal is to help all aspiring students with additional tips and tricks you can use to succeed in your next business intelligence projects.

Update: The complete Power BI Masterclass Series on udemy (I have aggregated some classes together to provide more content value per class for you. I really hope that serves you better!


1. Power BI Masterclass - beginners to advanced

2. Microsoft Power BI Masterclass - Expand Excellence

3.Power BI Masterclass - DAX, Excel And More

4. The Power BI Masterclass - Additional Tips and Tricks

5. Power BI Desktop - Data Prep Challenges

6. Power BI Masterclass - DAX, R and Gateways

7. Power BI Masterclass - Python Finance and Advanced DAX

8. Power BI Masterclass - the next level

9. Power BI DAX Fundamentals Mastering the Key Concepts

10. Power BI Masterclass Calculation Groups with Tabular Editor

11. The Power BI Service Masterclass

12. How to build a profit and loss statement in Power BI Desktop


We got a lot to do so let's get into it!

Who this course is for:

  • You are or want to become a data analyst
  • Data analysts and everyone who strives for a (new) career in data analytics
  • students who want to master self service bi with Microsoft Power BI
  • students who have taken my Power BI Masterclass series on udemy
  • students who search additional skills in Microsoft Power BI Desktop
  • students who want to apply tips in Microsoft Power BI Desktop
  • You want to master self service BI with MS Power BI Desktop
  • You want additional resources for your next Power BI Project solutions

Report abuse