
Compare Power BI Desktop for building dashboards and reports with Power BI Service for sharing and collaboration, and explain Power BI Pro and Premium licensing for teams and scalable deployment.
Explore why Power BI for Mac isn’t available and learn free and paid workarounds, including Parallels, Turbo Net, and a 12-month remote desktop solution via AWS.
Filter a currency table in Power BI by keeping six currencies using text filters with equals and advanced options, then apply the same approach to currency keys with numeric filters.
Calculate a person’s age from birth date using date functions and duration to total years, then round down for whole years. Preserve updated ages by removing the birth date.
Unpivot currency columns in Power Query to turn six currency fields into two: currency key and sales amount, after promoting the first row as headers.
Learn how parameters in Power BI enable scalable, data-source driven reports by centralizing file locations and updating a single value to refresh multiple tables.
Define role level security in Power BI to restrict data by country, create roles for United States, Canada, and France, and test visible data with geo data from Excel.
Explore DAX, a Microsoft formula language for Power BI, Power Pivot, and SSAS tabular models that enables calculated measures, calculated columns, related tables, time intelligence, and row-level security.
Create calculated columns in Power BI to extend a table and store results in the in-memory data model. Use DAX to flag late shipments and label premium purchases.
Power BI's calculate function changes the filter context to update results. The lecture shows creating a measure with calculate and using color filters, with a note on filter inside calculate.
Discover how sumx, a Power BI iterator, processes every row of a table by applying an expression and aggregating the results, shown with sales amount in euros.
Learn how variables simplify complex expressions and improve readability and performance of measures in Power BI, using a year-over-year growth calculation with current year sales, latest year, and parallel periods.
Explore using the treatas function to perform currency conversion between unconnected tables in Power BI, leveraging isfiltered, calculate, max, and dynamic exchange rates to convert totals to euros.
Learn to use text functions in duck language to display selected filters (customer, country, product) as a single line, and build a dynamic year-over-year growth indicator with arrows.
Learn to use concatenatex in Power BI to join multiple values into a text string, as both a measure and a calculated column, with related table, delimiter, and order by.
Learn to build expression based titles in Power BI that dynamically display the selected year and the previous year comparison using DAX measures, slicers, and dynamic titles.
Regular course updates!
Do you want to learn how to work with Microsoft Power BI?
Are you a beginner looking to become а proficient Power BI user?
If so, congratulations, as you have come to the right place!
This is a complete course that consists of four parts building on each other:
1. Power Query
2. Data modeling
3. DAX expressions
4. Building visually-pleasing and practical reports in Power BI
5. Utilize the power of ChatGPT to make your reports even better
6. Use Python to handle API feeds and perform out of the box data transformations
7. Hands-on exposure to Microsoft Fabric Lakehouse, PySpark Notebooks, Pipelines and more
In the process, you will learn how to apply a number of best practices the course author has learned on the job while working for some of the largest companies in the world.
Everyone wants to create a beautiful dashboard. But only few people are able to do so because it isn't an easy task.
By taking this course, you will learn how to:
Manipulate data with Power Query
Translate complex business logic into DAX expressions
Create data models inside Power BI
Understand the fundamentals of dashboard design
Build beautiful and interactive dashboards that can be presented to clients
Implement Python inside Power BI to unlock features outside the box
Work with Microsoft Fabric-based semantic models
All of this is shown step-by-step in a beginner-friendly manner.
This course is designed for students who like to learn by doing.
It contains over 20 hours of content, packed with real-life business scenarios along with quizzes and projects that allow you to apply what you have learned in practice. By completing the course you will acquire a solid understanding and will be able to jumpstart your career as Power BI developer.
We will not only teach you how to create stunning dashboards, but we will also introduce you to data modelling, data transformations, teach you how to write DAX, set up calculated columns and measures, generate roles, and of course share your dashboards with your team or clients.
This course goes offers out of the box Power BI features such as working with Python scripts, Data Science, handling API-requests, leveraging the power of ChatGPT to speed up your report development process and give you a walkthrough Microsoft Fabric.
Power BI allows you to connect to hundreds of data sources and quickly analyze your data for free. And, although Power BI desktop may not be available for Mac, this course will show you an easy solution that allows you to use Power BI desktop on your Mac for free for the next 12 months!
This course is suitable for complete beginners, intermediate and advanced users, as we’ll guide you every step of your journey with easy to understand explanations.
So, what are you waiting for?
Click 'Buy now' and start your Power BI journey today!