Published 1/2023MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 751.32 MB | Duration: 1h 53m

How to for Excel Files in Power BI Templates in Power BI, How to solve circular dependecy errors in Power BI Desktop

What you'll learn

You learn how to solve various problems when using excel files and Power BI Data source

You learn Power BI best practises

You learn how to solve circular dependencies in Power BI

You learn about the M Language

You learn DAX

Requirements

You should have basic Power BI knowledge

Having attended my Power BI Masterclass bners to advanced first is an advantage

This course has strong focus on excel data sources and solving data issues

The course does not cover visualizations in Power BI Desktop

Description

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. This is why Power BI as the leading BI Tool from Microsoft is in very high demand. And it provides an interesting an rewarding career path.When it comes to Data there are always challenges. Particular with flat files like excel. This is a topic I like to cover with you together in this courseIn particular we learn aboutHow to deal with chag excel sheet namesHow to handle file location changesTemplate filesDifferent file structure issuesCircular Dependency Errors and how to fixMultiple Folder Data ExtractionThe new DAX functions (Offset, Index and Window)Does this sound interesting to you? Great!Then no more waiting! Let's get into it and see how to solve these topics right away!See you in the first lecturebest regards and take care

Overview

Section 1: Einfuhrung

Lecture 1 1 Power BI Best project tips and tricks Intro

Lecture 2 all the course resources here

Lecture 3 2 No issues with chag sheet excel names any more

Lecture 4 3 How to handle excel sheet renaming issues in bulk

Lecture 5 4 Dealing with Filie Location changes in Power BI

Lecture 6 5 Best practise Tip use Power BI Template files

Lecture 7 6 Power BI Trouble with combining Excel Files with different structure

Lecture 8 7 Power BI Multiple Excel Files with different file structure and modification

Lecture 9 8 Circular Dependency Errors and how to fix them

Lecture 10 9 Circular Dep error another way to fix it

Lecture 11 10 Circular Dependency Errors imn Relationships between tables and how to fix th

Lecture 12 11 Efficiently extract Data Multiple Folders in Power BI mitte Raus

Lecture 13 12 Deep Dive into the the new DAX Functions

You want to become a better Power BI developper,You want to solve data issues with excel files in Power BI,Data Analysts and those who want to follow this career path,Business users who work with Power Bi and need to create DAX calculations

HomePage: