Best Dax Courses

Find the best online Dax Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Dax Courses.

Microsoft Excel: Business Intelligence w/ Power Query & DAX

Learn advanced Excel for data analysis & business intelligence (Power Query, Power Pivot & DAX language. Excel 2013+)

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 69153, Price: $89.99

Students: 69153, Price:  Paid

Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Power Query + Excel Power Pivot course:

"I am a self-taught Excel Power Query user and it took me a while to understand what each tool does and how it interacts with others. Thanks to your introduction I finally nailed it in a very clear, unambiguous way. You helped me build a method that I can confidently apply to my data in Excel. Thank you so much!"

-Francesca C.

"I'm less of an expert at breathing than Chris is at Excel. This course is thorough and well-planned, and he presents in a manner that simplifies the complicated. Well worth your time if you want to master Excel power query and power pivot!"

-Tim B.

"I'm geeking out, this is so cool. Where has this been all my life???"

-Karen P.

__________

COURSE DESCRIPTION:

This course introduces Microsoft Excel's powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you're looking to become a power Excel user and absolutely supercharge your Excel analytics game, this course is the A-Z guide that you're looking for.

I'll introduce the "Power Excel" landscape, and explore what these Excel tools are all about and why they are changing the world of self-service business intelligence. Together, we'll walk through the Excel BI workflow, and build an entire Excel data model from scratch:

  • First we'll get hands-on with Power Query; a tool to extract, transform, and load data into Excel from flat files, folders, databases, API services and more. We'll practice shaping, blending and exploring our project files in Excel's query editor, and create completely automated loading procedures inside of Excel with only a few clicks.

  • From there we'll dive into Data Modeling 101, and cover the fundamentals of database design and normalization (including table relationships, cardinality, hierarchies and more). We'll take a tour through the Excel data model interface, introduce some best practices and pro tips, and then create our own relational database to analyze throughout the course.

  • Finally, we'll use Power Pivot and DAX to explore and analyze our Excel data model. Unlike traditional Excel Pivot Tables, Power Pivot allows you to analyze hundreds of millions of rows across multiple data tables (inside of Excel!), and create supercharged calculated fields using a formula language called Data Analysis Expressions (or "DAX" for short). We'll cover basic DAX syntax, then introduce some of the most powerful and commonly-used functions -- CALCULATE, FILTER, SUMX and more.

If you're ready to take your Excel game to new heights and join the leading edge of analytics & business intelligence, this course is for you. It's time to stop fighting with tedious, manual tasks and struggling with "old-school" Excel; join me on this journey and emerge a certified excel analytics NINJA.

See you in there!

-Chris (Founder, Excel Maven Maven Analytics)

__________

IMPORTANT: Power Query and Power Pivot are currently NOT available in Excel for Mac. You'll need a PC version of Excel that is compatible with Power Pivot (Excel 2010 with plug-in, Excel 2013, Excel 2016, or Excel 2019 Standalone, Office 365 Pro Plus, Enterprise E3/E5, Office Professional 2016, etc.)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

*** This course includes Excel project files, quizzes & homework exercises, 1-on-1 instructor support, LIFETIME access and a 100% money-back guarantee! ***

Microsoft Power BI DAX from Scratch

Hands-on guide to Microsoft Power BI DAX

Created by Learnsector LLP - Learn to Win

"]

Students: 39246, Price: $99.99

Students: 39246, Price:  Paid

If you are someone dealing with reporting, with the help of DAX functions you can unlock the advanced power of reporting in Power BI. These functions will help you get better data insights.

DAX or Data Analysis Expression is a library of functions and operators, using which you can create formulas and expressions. This will help you with creating powerful formulas to ease your data analysis and reporting process.

This course is designed in a Problem Statement - Solution format where we start with the problem to which a solution is sought with the help of DAX functions where each component of the expression is clearly explained in easy-to-understand terms,

What is in store for you?

In this course, you will

1. Understand the concept of DAX and how to create calculate column, measure, tables, and quick measures

2. From the exhaustive list of DAX functions, we will be looking into the most frequently used functions from the family of

  • Date and Time function - WEEKDAY,  EDATE, EOMONTH,  DATEDIFF, TODAY, NOW

  • Text function - FORMAT, COMBINEVALUES, LEFT, RIGHT, FIND, UPPER, LOWER, UNICHAR, REPT

  • Logical function - IF, Nested IF, AND, OR, SWITCH

  • Relationship function - RELATED, CROSSFILTER, RELATEDTABLE

  • X-function - SUMX, RANKX

  • Filter function - CALCULATE, ALL, EARLIER, FILTER, LOOKUPVALUE

  • Statistical function - DISTINCTCOUNT

  • Time intelligence function- DATESYTD, DATEADD, SAMEPERIODLASTYEAR

  • Information function- CONTAINS

  • Table manipulation function- SUMMARIZECOLUMNS

DA-100 certification: Analyzing Data with Microsoft Power BI

Learn skills for Microsoft DA-100 certification using the free Power BI Desktop. Learn Power Query, DAX, M and more.

Created by Phillip Burton - Best Selling Instructor - over 350,000 students so far

"]

Students: 25532, Price: $89.99

Students: 25532, Price:  Paid

This course covers the content required for the DA-100 certification exam, current as per the DA-100 exam update of 24 September 2021.

----------------

What do students like you say about this course?

Girma says: "This is another great course taught by the instructor – well-paced, every important aspects of Power BI are discussed in detail. I gained the real power of Power BI in this course."

Mohan says: "Another Excellent course by Mr Burton. This course can be used as a refresher , manual reference to review, understand and use Power BI tools efficiently. Explanations are very clear and crisp. Can help from Beginner to Intermediate level learning."

Andrew says: "I took a similar Power BI course through my work and I think this one is better. Highly recommend this training. I am a Lead ERP Financial Systems Analyst who worked mostly with Oracle BI tools. Company wants to go in a different direction so I am learning Power BI."

----------------

Do you already use reporting software such as Access, SSRS, Tableau or WebI? Or is this your first reporting software tool? Either way, welcome.

In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft Power BI certification.

Power BI is one of the most requested reporting tools that are requested in the job market, and the ability to being able to use it now could be very useful for your current work, and your next job hunt.

This course comes in three parts:

Part 1 - Creating Visualizations (also known as Visualize the Data, and Analyze the Data)

We'll download and install for free Power BI Desktop. We'll start by creating our first visualizations (vizzes) and investigate the Power BI interface.

We'll look at the various visualisations available, and go through their common properties. We'll create maps, hierarchies, KPIs, guages, and all sorts of chart types.

Part 2 - Get and Transform Data (also known as Prepare the Data)

We see how data can be transformed, saving you time in analysing the data. We'll look at sorting and filtering, split columns, and other transform activities. We'll merge, append and combine queries together. We'll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the M language.

Part 3 - Refining the model (also known as Model the Data)

We'll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language.

Part 4 - Power BI Service

We'll then publish our visualisations onto the Power BI Service (which you can sign up for free), and then from your reports create dashboards. With the Power BI Pro (for which you can get a free trial), you can also create workspaces and apps.

The course will take around 24 hours to complete, but completing this will enable you to create vizzes, dashboards and stories of your own, and know how to overcome common problems.

The course increases in difficulty slowly, so you'll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step.

The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I'll introduce every component as we go on.

At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves. And if you are an American college student, you might even get college credit for passing that exam.

Advanced DAX for Microsoft Power BI Desktop

Master the DAX language and build advanced Power BI & data analysis skills with a top business intelligence instructor

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 17173, Price: $109.99

Students: 17173, Price:  Paid

Hear why our Power BI courses are the TOP-RATED on Udemy:

"I totally loved this Power BI course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much and had fun doing it. In fact, at the end of the day, I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

-Ann S.

"Amazing! 5+ stars if you ask me! Concise, superbly organized and prepared. I have learned a ton about Power BI and DAX and enjoyed the course from start to finish."

-Nikola H.

"Hands-down the best Power BI courses on Udemy. Courses are well prepared and very hands-on, and the instructor makes the whole experience easy and fun. I recommend it 100%!"

-Jorge M.

"Where can I leave a 6 star rating?"

-Carlos B.

__________

COURSE DESCRIPTION:

For users looking to take their Power BI skills to the next level, mastering Data Analysis Expressions (DAX) is a MUST. In this hands-on, project-based course, you'll put your DAX skills to the test and apply what you learn to some of the toughest real-world business intelligence use cases.

You'll be playing the role of Business Intelligence Analyst for Maven Roasters, a small-batch coffee chain based in New York City. Your goal? Use Power BI and DAX to answer key questions and deliver data-driven insights for the business, by analyzing product inventory, repeat customers, store-level performance, and everything in between.

We'll start by quickly reviewing prerequisite topics (evaluation context, filter flow, basic measures, etc.), then dive behind the scenes to explore how the DAX formula and storage engines actually work, including query evaluation, columnar structures, and VertiPaq compression and encoding.

From there we'll cover helpful tips and best practices for DAX power users, including variables, comments, query formatting and error handling, then dive deep into scalar functions, iterators, advanced time intelligence, calculated table joins, relationship functions, and much, much more. Last but not least, we'll share a sneak peek into performance tuning and DAX query optimization using DAX Studio and Power BI's Performance Analyzer tool.

If you're looking to build expert-level data analysis skills using DAX and Power BI, this is the course for you!

__________

FULL COURSE OUTLINE:

  • Prerequisite Skills Review

    • Review the core DAX concepts you should already know, including evaluation context, filter flow, measures, etc.

  • Course Project Intro

    • Introduce the Maven Roasters course project, and build the data model that we’ll analyze in Power BI Desktop

  • The DAX Engines

    • Understand the DAX formula and storage engines, data types, VertiPaq encoding & compression methods, etc.

  • DAX Tips & Best Practices

    • Review helpful tips for formatting DAX queries, adding comments, handling errors, and using DAX variables

  • Scalar Functions

    • Explore common DAX scalar functions, including rounding, information, conversion, and logical functions

  • Advanced CALCULATE

    • Review CALCULATE modifiers, context transition, interactions with tables, etc.

  • Table & Filter Functions

    • Create calculated tables, review common DAX filter functions, generate new data, etc.

  • Calculated Table Joins

    • Create calculated joins between physical and virtual tables in Power BI (UNION, EXCEPT, INTERSECT, etc.)

  • Relationship Functions

    • Explore expanded tables, physical & virtual relationships, common relationship functions, etc.

  • Iterator ("X") Functions

    • Explore iterator cardinality, nested iterators, context transition, RANKX, DAX calculation granularity, etc.

  • Advanced Time Intelligence

    • Build date tables with DAX, compare custom time periods, manage fiscal calendars, etc.

  • SNEAK PEEK: Performance Tuning

    • Introduce DAX Studio, the Power BI performance analyzer, and common DAX optimization techniques

__________

Join today and get immediate, lifetime access to the following:

  • 150+ page Power BI & DAX ebook

  • Downloadable datasets and Power BI project files

  • Homework assignments & quizzes

  • 1-on-1 expert support

  • Course Q&A forum

  • 30-day money-back guarantee

See you in there!

-Aaron (Power BI & DAX Instructor, Maven Analytics)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Data Analyst: PowerBI,PowerPivot,PowerQuery,PivotChart,DAX

Practical Hands-On Real World Data Analysis

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 16682, Price: $99.99

Students: 16682, Price:  Paid

As a data analyst, you are on a journey. Think about all the data that is being generated each day and that is available in an organization, from transactional data in a traditional database, telemetry data from services that you use, to signals that you get from different areas like social media.

For example, today's retail businesses collect and store massive amounts of data that track the items you browsed and purchased, the pages you've visited on their site, the aisles you purchase products from, your spending habits, and much more.

With data and information as the most strategic asset of a business, the underlying challenge that organizations have today is understanding and using their data to positively effect change within the business. Businesses continue to struggle to use their data in a meaningful and productive way, which impacts their ability to act.

The key to unlocking this data is being able to tell a story with it. In today's highly competitive and fast-paced business world, crafting reports that tell that story is what helps business leaders take action on the data. Business decision makers depend on an accurate story to drive better business decisions. The faster a business can make precise decisions, the more competitive they will be and the better advantage they will have. Without the story, it is difficult to understand what the data is trying to tell you.

However, having data alone is not enough. You need to be able to act on the data to effect change within the business. That action could involve reallocating resources within the business to accommodate a need, or it could be identifying a failing campaign and knowing when to change course. These situations are where telling a story with your data is important.

The underlying challenge that businesses face today is understanding and using their data in such a way that impacts their business and ultimately their bottom line. You need to be able to look at the data and facilitate trusted business decisions. Then, you need the ability to look at metrics and clearly understand the meaning behind those metrics.

Data analysis exists to help overcome these challenges and pain points, ultimately assisting businesses in finding insights and uncovering hidden value in troves of data through storytelling. As you read on, you will learn how to use and apply analytical skills to go beyond a single report and help impact and influence your organization by telling stories with data and driving that data culture.

Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. Connect to hundreds of data sources and bring your data to life with live dashboards and reports.

Discover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools—which includes the Power BI service, Power BI Desktop, and Power BI Mobile—can help you more effectively create and share impactful visualizations with others in your organization.

The Power Query and Power Pivot features in Microsoft Excel can make a powerful combination. Power Query enables you to discover, connect to, and import data, and Power Pivot lets you quickly model that data.  You will learn how to use the DAX formula language to provide lookup abilities.

I will walk you through step-by-step how to use Power Query to select data, prepare a query, cleanse data, and prepare data for Power Pivot. Also i will walks you through the Power Pivot workflow, showing how to create a data model, import additional data if needed, build relationships between data, and create calculations and measures.

You will learn hands on real-world scenarios for working together with Power Query and Power Pivot.

Learning objectives

  • Preparing queries

  • Cleansing data with Power Query

  • Enhancing queries

  • Creating a data model in Power Pivot

  • Building relationships

  • Creating Pivot Tables and Pivot Charts

  • Creating Lookups

  • Using DAX to link data

  • Creating data model

  • Creating relationship between data sources

  • Analyzing data with PivotTables and PivotCharts

  • Using Power Query with PowerPivot

  • Connecting  to a variety of data sources with Power BI

  • Create and publish reports to Power BI Service

  • Refreshing Data Source

  • Updating Queries

  • Using Conditional statements

  • Using quick and dynamic measures

  • Transforming data on connected datasets

Power BI Master Class-Data Models and DAX Formulas 2021

Learn how to create data models, relationships and use DAX formulas in Microsoft Power BI

Created by Ian Littlejohn - Excel Power Tools, Power BI and Google Data Studio Trainer

"]

Students: 15670, Price: $99.99

Students: 15670, Price:  Paid

Don't sit through days of boring training to understand how Power BI works! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming a Power BI expert

Great reports are built on great data models.  In this course, learn how to create relationships, create measures, use DAX and all the other skills you need to build a data model that ensures your reports are top-notch!  This course has been updated (JUNE 2020) to the latest Power BI interface so you will be using the latest version available. 

This course has been updated for 2021 in full HD video quality, so you will learn on the latest Power BI interface. Students who have taken this course have this to say:

WHAT STUDENTS ARE SAYING:

"Thanks..this is exactly what I was looking for.  So many questions are clarified now. This is really helpful for my day to day work!!"

"Very well organized. I like that it is "master" class, but you provide the instruction in such a way that it does not overwhelm you with new or complex information, BUT at the same time does not bore you with basic information that a somewhat experienced user should already know. A nice balance."

"Ian is a good instructor. I have completed 2 modules (Query Editor and DAX). Looking forward to completing the 3rd (Dashboards and Power BI Service)."

"Great course, great professor, I'm a beginner user and the course is really great as a first approach, it teaches you about the most important general aspects and functions, it is the perfect first step you should take if you want to dominate powerbi."

WHAT YOU CAN EXPECT:

  1. Introduction and Course Content

  2. Creating Calculated Columns - Basic calculations, using date fields and date tables

  3. Creating Measures - Aggregation measures, the =Calculate formula, the All and AllExcept formula, Time Intelligence, Customer Segmentation and many more

  4. Creating Relationships between tables and using relationship calculations

  5. Creating Virtual Tables and Calculations between Tables

  6. Creating and using hierarchies and data groups

  7. Case Studies on DirectQuery, Star Schemas and Quick Measures

ABOUT THE TRAINER

Ian Littlejohn has been a top-rated trainer on the Udemy platform for over 5 years and has more than 10 years' experience in training & management consulting. He specializes in Data Analysis, covering Excel, Power BI, Google Data Studio and Amazon Quicksight.

Ian has over 100,000 students and 50,000 reviews and an average course rating of over 4.5 out of 5. He has a reputation for delivering excellent, logically structured courses that are easy to follow and get the point across without wasting learners' time.

WHY YOU SHOULD SIGN UP:

Learners buying this course get:

  • Full access to almost 5 hours of HD quality video

  • 4 downloadable resources and 11 articles

  • Lifetime access

  • Money-back guarantee (see Udemy terms and Conditions)

  • Certificate of completion upon course conclusion

We look forward to having you on the course!

***************************************************************************************************************************************

DATA ANALYSIS COURSES ROADMAP:

This course is part of our Power BI Master Class series.  This series goes into a bit more depth about Power BI.    My other courses on Udemy are:

  • Power BI

    • Complete Introduction to Microsoft Power BI [2020 Edition]

    • Power BI Master Class - Query Editor [2020 Edition]

    • Power BI Master Class-Data Models and DAX Formulas 2020

    • Power BI Master Class - Dashboards and Power BI Service 2020

    • Introduction to Data Analysis with Microsoft Power BI

  • Excel

    • Complete Introduction to Excel Pivot Tables and Pivot Charts

    • Complete Introduction to Excel Power Pivot

    • Complete Introduction to Excel Power Query

    • Excel Interactive Dashboards and Data Analysis

    • Complete Introduction to Business Data Analysis

    • Tables and Formulas with Excel [2020 Edition]

  • Google Data Studio

    • Complete Introduction to Google Sheets Pivot Tables

    • Complete Introduction to Google Data Studio 2020 Edition

    • Google Analytics Reports and Dashboards with Data Studio

Power BI Dashboard Step by Step

Business Intelligence, Data Connectiion, Power Query Basic, Creating Visuals, DAX, Dashboards.

Created by Asif Hafeez - Microsoft Certified Trainer | MCSA (BI Reporting)

"]

Students: 9199, Price: Free

Students: 9199, Price:  Free

Try not to become a man of success, but rather try to become a man of value. – Albert Einstein

Data analysis is an exciting field to get into and the career prospects are amazing. You don’t need to be a math/computer science/coding whiz to land a job in data analysis.

Data Analysis in demand and we normally use Excel to create beautiful Charts and Graphs to show the results. But Power BI is the ultimate choice to prepare quick Reports and Dashboards and easy to understand that is the reason it has become the first choice of a Data Analysis.

In this Course I will teach you to create some beautiful Dashboards/Reports by simple techniques in few minutes. Power BI was generally made available in 2015 and by the time it is has become the Leader in the market for Business Intelligence (source: Gartner Report).

WHAT YOU WILL LEARN

  • Simple methods to prepare Power BI Dashboards

  • Quick way to create Reports and Dashboards

PREREQUISITES

  • Basic Excel Knowledge

WHO THIS COURSE IS FOR?

  • Power BI beginners

  • Data Analyst

  • Dashboards lovers

  • Business Intelligence professionals

Excel Power Query, Power Pivot, Power Map & DAX Masterclass

Learn Excel Power Query, PowerPivot, DAX, Power View & Power BI Tools. Build Excel Data Analyst Models with Excel 2019

Created by Andreas Exadaktylos - Best Selling Teacher | Msc Computer Scientist

"]

Students: 8320, Price: $99.99

Students: 8320, Price:  Paid

COMPLETELY REDONE ON FEB 2021 WITH NEW VIDEOS!

Learn Power Query, Power Pivot, DAX, Power View, Power Map (3D Maps) and Power BI Desktop Business Intelligence Tools that are rarely found on Excel users, and transform to an Excel Star!

These days almost any job requires data analysis & presentation of results. While anyone can put a list of values in Excel & sum them up, not everyone can do advanced analysis, create interactive charts, summarize data intelligently using Power Pivot and Power BI tools, and finally present output in stunning Dashboards.

IMPORTANT NOTE: To make sure that your version is compatible before you go on with that course, please check the Microsoft Excel compatibility page. You can watch the 3rd lecture of the course: Versions, Compatibility and Install Power Pivot, Power Map & Power View. (it has a free preview)

Power Pivot is currently not available for Mac and is only available in specific Excel versions for windows.

Content and Overview
This course is a guide with simple step by step instructions to walk you through creating business intelligence reports and dashboards in Excel, quickly and efficiently. The course has been created with the version of Microsoft Excel 2019 and Microsoft 365, but it's compatible with older versions of Excel.

This course aims to introduce the Excel user to the brave new world of self-service BI using the Excel BI Toolkit.

We'll use Microsoft Excel Power Query, Power Pivot, Power View, Power 3D Maps tools and DAX Formula Language to analyze huge amounts of business data fast and transform data into bottom-line results – no programming required!

Finally, we’re going to explain the Power BI Desktop application, that lets you share interactive dashboards based on your Excel data.

At the end of the course, we will create a beautiful dashboard, combining all the excel BI tools together.

You'll have lifetime access to watch the videos whenever you like. If you're not 100% satisfied there is a 30 day money back guarantee!

Plus you will get fast and responsive support within 48 hours.

Free downloadable Excel working files are included to allow you to follow along using the same material I use throughout the lectures. You can download all of them.

What are you waiting for? Enroll now and take your business intelligence analysis to a whole new level!

What you'll learn:

  • Understand and install the Excel Power Query, Power Pivot, Power Map, Power View and Power BI Desktop add-ins

  • Import data from spreadsheets, Access, SQL, text files and other sources

  • Add calculated fields, columns and Measures with Data Analysis Expressions (DAX) formula language

  • Create complex reporting systems

  • How to use the Power View presentation and analysis tool.

  • Learn from start to finish the powerful features of Excel Power Map

  • Explain the Power BI Desktop application, that lets you share interactive dashboards based on your Excel data.

  • Design your Excel Dashboard with link buttons

  • What are KPI's and add key metrics

  • Create mind blowing Excel Pivot Charts from Power Pivot

  • Create powerful reports using Slicers and Timeline

  • Make an amazing interactive sales map using Excel Power View powerful add-in

  • Summarize data with Matrices, Cards and Tiles

  • Perform simple-to-sophisticated calculations like Month to date and Year to date

  • Analyze multiple tables together without the need to ever write VLOOKUP formulas again

Enroll now and master the creation of interactive Excel Dashboards!

100% risk free – 30 day money back guarantee! - Lifetime access

Who is this course for?

This course assumes that you have a basic knowledge of Excel . You don't need to be a master of Excel. Only basic prior experience in Excel or Spreadsheets is required to get the most out of this Excel course.

This course is also ideal for data analysts, MIS professionals, business analysts, managers, dashboard makers, business intelligence professionals and students.

At the end of this Excel class you will be given a Certificate of Completion.

STUDENT REVIEWS:

"I highly recommend this course. It was exactly what I needed to jump start my career. I learned far more than I expected. The instructor is excellent !!!!!!!!" - Troy Newman

===================================================================

"A thorough tutorial on using all the Excel BI Toolkit,  to create dashboard reporting. Very well presented and explain complex issues in a simple way. It is clear and easy to understand and has helped me develop reporting dashboards. Excellent!" - Albert Loomer

===================================================================

"Andreas helps the viewer use Excel skills to produce truly useful dashboards. Highly recommend for those looking to learn data presentation." - David Anderson

===================================================================

Enrol now and enjoy!

Microsoft Power BI – The Complete Masterclass [2021 EDITION]

Master Power BI Desktop, Cloud & Mobile and advanced analytics with DAX (also Data Science)!

Created by Nikolai Schuler - Professional Data Scientist und BI Consultant

"]

Students: 5746, Price: $119.99

Students: 5746, Price:  Paid

Do you want to learn the skills to professionally analyze data?

Do you want to learn all the steps to create impressive reports?

Then Microsoft Power BI is the right tool for you!

In this course you will learn – step by step – everything that is important in Power BI to become an advanced Power BI report creator.

That’s what you’ll learn:

Power BI Desktop, Power BI Cloud & Power BI Mobile!

✓ Understand everything from scratch – step by step, very structured and practice-oriented

Learn all the important tools – know when and how to use them properly

✓ Connect different data sources – from basics to advanced

Create your data model – and understand it

Master DAX – to do more advanced analysis on your data

Get to know all the different visualizations – and how to use them

Storytelling with data – learn how to visualize your data effectively

Create interactive visualizations – with drill throughs and drill downs

Advanced analysis – learn how to use R Script in Power BI (Data Science)

Forecasting – Advanced analytics which can be helpful in Data Science

Row-Level Security – Implement the security concept to control access to the data

This course is right for you if...

... you have never worked with Power BI and want to learn everything hands-on in one course.

... OR you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Power BI.

This is the course that covers everything in Power BI to become an advanced report devolopper! 

Enroll now to get life long access!

Top Tips for DAX users – Power BI and Excels Power Pivot

Tips for DAX users to help improve efficiency, modelling and much more in Power BI or Power Pivot

Created by Paula Guilfoyle CPA & MVP - Microsoft MVP, CPA Accountant, & Life Long Learner

"]

Students: 5430, Price: Free

Students: 5430, Price:  Free

Are you looking to improve your efficiency, your modeling skills, and your general DAX usage skills for Power BI or Power Pivot?  IF so then this course is for you.

This course is a general tips course for those working with DAX in Power BI or Power Pivot.  You will learn tips and tricks that will both save you time and make you more efficient.  DAX is becoming a more sought after skill and this course has been designed to help you become on top of the game.

You will be given tips on the following topic and more

- Data Modelling

- Working with Date tables

- Keyboard shortcuts

- Model optimization

- Data transformation steps

- Using Power Query

- Much much more

This is a hands-on course, so you will find workbooks to download so that you can practice along

So if you are a DAX user and are looking to improve your general skills and efficiency then when don't you hope into the course and find out more.

DAX – Mastering DAX Foundations for Power BI

Demystifying DAX for Advanced Power BI Reporting

Created by Ahmed Oyelowo - Microsoft Data Platform MVP | Certified Trainer (MCT)

"]

Students: 4300, Price: $19.99

Students: 4300, Price:  Paid

Background

DAX is the formula language of Power BI, Excel Power Pivot and SSAS Tabular. The formula language simply unlocks advanced capabilities for reporting in Power BI.

However, DAX is not an easy language to learn. Mastering it requires a proper understanding of the rudiments and a lot of constant practice.

In this course, I have used a very explanatory approach to ensure that you will understand, learn and master DAX faster than most courses where formulas ae being copied from a text editor without proper explanation of what is happening behind it.

As a Microsoft Most Valuable Professional for the Data Platform and a Microsoft Certified Trainer, I will be able to answer your DAX questions as you continue to develop your skills after this course.

What you will learn.

This course is suitable for all levels of Power BI users. You will learn from the introductory concepts to build a solid background. By the time you complete the course, you should have a better understanding of:

1. DAX usage in Power BI (Calculated Columns, Calculated Tables, Measures and Row Level Security)

2. The most important and used DAX functions

3. How the DAX Engine works behind the scenes

4. The CALCULATE function in DAX

5. Row Context, Filter Context and Context Transition

6. Time Intelligence functions and calculations

7. Other important DAX functions like RANKX and TOPN

Assignments.

Because DAX is about doing , and beyond looking, I am sorry to say that I included assignments for you. Don't worry if you stumble here and there while completing the assignments, it's completely normal. You will just have to watch the parts of the videos again till you are able to complete them. It's all for good.

The more DAX you write, the better you get....over time. So this is a good opportunity to write a lot of them.

Master DAX fundamentals : Power BI, Power Pivot & SSAS

The Fundamentals of Data Analysis and Modelling with DAX for Power BI, Power Pivot and Analysis Services

Created by Paula Guilfoyle CPA & MVP - Microsoft MVP, CPA Accountant, & Life Long Learner

"]

Students: 4086, Price: $99.99

Students: 4086, Price:  Paid

Data Analysis and data modelling made easy with Data Analysis eXpressions. DAX can be used in Power BI, Power Pivot and Analysis Services.

Analyse and Model your data with in Power BI, Excels Power Pivot and Analysis Services with Data Analysis eXpressions.

This is a hands on course

Course Overview

In the first section of this course you will be introduced to the use of the most common DAX expressions, such as SUM and SUMX, COUNT, ROUND, DIVIDE, MIN, MAX, IF Statements, TEXT expressions, Variables and More

In the next section of this course you will learn the fundamentals of how DAX works.  This section will include both theory and examples and it is of utmost importance that you understand how DAX works. We will discuss Row context and Filter context, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships and much more.

In the third section of this course you will learn about Time Intelligence and Date Tables. We will look at expressions such as TOTALYTD, SAMEPERIODLASTYEAR, DATESADD, DATESBETWEEN, CALENDERAUTO, and we will explore how many of these functions work using CALCULATE

Each section of this course contains Activities to complete. These Activities are of utmost importance.  When it comes to learning DAX, practice is a must.

DAX Power Pivot – 10 Easy Steps for Beginners

Learn how to build DAX functions in PowerPivot with Excel 2016. Reinforce and embed with practice exercises/solutions

Created by Gilly Dow - IT Training Consultant

"]

Students: 3687, Price: $109.99

Students: 3687, Price:  Paid

If your goal is to enter the world of BI, Data Mining and or Data
Analysis you have to take this course.
All of these environments and roles demand the skills you are about to learn

Microsoft PowerPivot is an add on for Excel that provides Business
Intelligence functionality and reporting within the familiar environment of
Excel.

This capability enables manipulation of hundreds of millions of rows of
data with the capacity to provide business insights and shorter decision making
cycles laughing in the face of the million row threshold of regular Excel

Here's what others had to say about the course:

"This instructor is unbelievable. Not only were the course materials plentiful, but her instruction was full of enthusiasm and encouragement. The format was perfect for me. I never felt like I was being left behind. I'll take any course by Gilly Dow, if it's not completely relevant to something I'm working with at the moment. This course was really amazing."

- Mickey Thorpe

"I purchased your two courses as a review to brush up on my skills Dax Power Pivot 10 Easy Steps for beginners Dax Power Pivot Time intelligence 10 easy steps Both wonderfully explained with very good demonstrated examples. Great refresher courses. You really have a gift for teaching. I took PowerPivot Pro a couple of years back and I find your walk through and demonstrations of the Dax measures so much clearer and to the point. It has been a fun enjoyable refresher for me. This is great course for everyone getting started in PowerPivot Thanks well done."

- Stephen Davanzo

"Thank you so much for making DAX so simple and efficient. This is perfect for everyone would like to start their journey in DAX."

- Ravi Vijay

"she is too good . I would  like to do other courses  even if they are not available on Udemy. Request Udemy to get all her works small or big on the site. Every slide I see my learning and understanding increases by leaps and bounds. I simply love this instructor and my highest regards for her way of explaining the things."

- Vinay Kumra

"Great course, good testing, good exercises, easy to follow lessons. I'm about 60% complete and the further I go the better it gets. Love the practice exercises and how the instructor goes through the answers in video detail about how the solution was arrived at...great teaching techniques all around. And then, there is the 70+ page guide that is integrated into the lesson plan, makes following the videos and working independently on the practice sessions easy as everything is organized to just follow along and learn by doing. So, watch, listen read do, test, feedback, move to next lesson. Right pace, right tone, right encouragement. Excellent course! Looking forward to the advanced. Marty"

- Martin Rini

"I really loved this course because it gave a nice (IMHO) overview for a beginning DAX / Power Pivot course. The Instructor was very very good. She took time to walk-through each step. If she keeps that approach in the upcoming Intermediate and Advanced courses, they will be winners. (She even gave some "top-tips" for regular Excel which jogged my memory banks anyway.) I am eagerly looking forward to the release dates her subsequent courses."

- Walt Lierman

What You'll Learn

To start with the course focuses on importing data into Power Pivot to
create the Data Model. You will learn about calculated columns and other DAX
related concepts that will show you how to “shape”
the data.

Next, you will create relationships between tables of data negating the
need for VLOOKUP. Reducing the time it takes to “shape” your data -  is one of the major benefits of this
awesome tool.

With the data model in place, next you delve into the world of DAX
measures. These are Data Analysis EXpressions functions that build the formulas to provide the
business insights that decision makers and stakeholders dream of.

There is no programming involved with DAX - your Excel
formulas experience has set you up nicely for the next step in your Excel
journey.

Throughout the course we work together building the data model and measures.
At the end of each step you have an opportunity to practice creating your own
measures to help you consolidate, embed and reinforce everything you have
learned. I provide a solutions video lecture before moving on to ensure you’re
on track and ready to move on.

I provide all the files you need to follow along and a fully supporting,
screen-shot enriched 78 pg. user guide pdf packed with all the steps and practice
exercises with solutions.

Power Pivot is the perfect tool for those working in finance,
statistics, project, business and market analysis or any data reporting role
who have a need to create and produce Business Intelligence style dashboard
reports.

Thanks for taking the time to check out my course. I can't wait to help
you take the next step in developing your Excel skills. I have used Excel
2016
to demonstrate this fantastic tool but you can follow along in
Excel 2010 & 2013 - I'll do my best to point out the differences. If you
have any questions about the course, feel free to message me here or check out
the FREE preview lectures to learn more.

Take the first steps to a new and rewarding future by clicking on the TAKE
THIS COURSE
button, located on the top right corner of the page. 

Power BI DAX Masterclass – Measures & Calculated Columns

Master advanced analysis with DAX - Learn Measures & Calculated Columns in Power BI (Advanced)!

Created by Nikolai Schuler - Professional Data Scientist und BI Consultant

"]

Students: 3471, Price: $99.99

Students: 3471, Price:  Paid

From beginner to profesional in DAX – Master advanced analysis in Power BI with Measures & Calculated Columns

DAX is a really powerful language if you want to get all the advanced insights from your data. Wether you want to create custom columns or use more advanced calculations with Measures and realize the full potential of Power BI - DAX is the key to that.

Yet I know that many people feel discourage because they don't know where to start and without help it can be a bit frustrating and difficult.

That's why I have created this course!

In this course you will finally be able to learn DAX for your advance analysis in Power BI - and that in an easy and well structured way.

Get a fundamental understanding right from the beginning

In this course I will teach you everything clearly by looking at actual examples. Therefore we will be looking together at some sales data that you will also be able to download - so you can work and practise as much as you want.

Step by step you will then learn everything you need to know regarding DAX, Measures and Calculated Columns in Power BI.

At the end of this course you will be able to do your own analysis in DAX. At this point it will be easy for you to do and learn more in DAX because you have gained a fundamental understanding in DAX, Measures and Calculated Columns.

What you will learn in this course?

· DAX fundamentals:

· fundamental understanding of Measures & Calculated Columns

· Measures vs. Calculated Columns

· Filter context vs. row context

· DAX in the data model

· Aggregation functions

· Logical Operators and IF-Statements

· Automatically create comprehensive data tables with date features

· Advanced topics:

· Row based functions such as SUMX & AVERAGEX

· Running Totals, Moving Average

· Variables

· RANKX

· Custom Top-N-filtering

· CALCULATE

· All you need to know about CALCULATE

· Filter functions

· ALL, ALLSELECTED, ALLEXCEPT

· FILTER, VALUES

· How to use them the right way

· Quick Measures

· All you need to know about Quick Measures & how to use them properly

· Time Intelligence

· Year-to-Date, Date-To-Month etc.

· The most important time intelligence functions and the right way to work with them

· And much more!

DAX Power Pivot – 10 Easy Steps for Intermediates

Build Power Pivot Data Models with Excel 2016 Power Query – take your DAX Business Intelligence to the next level

Created by Gilly Dow - IT Training Consultant

"]

Students: 2833, Price: $119.99

Students: 2833, Price:  Paid

This course builds upon the skills learned in the first
course in this series DAX Power Pivot –
10 Easy Steps for Beginners.

You have already gotten your hands dirty with Power Pivot and seen how awesome it is.
Now you are ready to take your skills to the next level by delving deeper and acquiring
a more thorough understanding of how “Disconnected
or “Parameter” tables can be utilised
to gain additional insights in your data models.

The first part of the course addresses Microsoft’s change to
the DAX engine that now makes
editing queries a challenge if you
aren’t an expert in SQL. Therefore, you learn to use Get & Transform to import data and in doing so, reduce the size
of your data model file size considerably.

You will draw upon your beginner DAX skills to delve deeper into the real meaning behind “Initial Filter Context”, “Filter Context” and “Context Transition” with explanations,
diagrams, examples and practice exercises.

To leverage the capabilities of “Disconnected” tables, I introduce you to the concept of thresholds, cut-offs and banding.
This really does open the door to a wealth of possibilities and you’ll learn
some useful techniques to gain some powerful new insights along the way.

Throughout the course, you are building your skills and understanding
– taking you to the next level at each Step
1-10.

I’ll have a couple of surprises
for you along the way – not only to boost your brownie-points at work but for
your own piece of mind around administration of your data models!

Here's what others said about the course:

Gilly. Did it again with the Addition of
Dax PowerPivot-10 easy steps for intermediate course. This intermediate Course
adds more formulas and Dax functions and even disconnected slicers and cube
formulas to add your learning base and continues to build off the previous two
courses. Gilly is a brilliant teacher who clearly has an in-depth understanding
of how power pivot works. She can break it down and simplify Dax so you know
how functions works and understand how to use it in your day-to-day excel work.
If you follow along and do the exercises when you’re done with a lesson you
fully understand how to complete and use the Dax formulas in your data work. If
you want to understand and learn Dax, Gilly courses are what you want to start
with. I recommend Gilly courses, you will be pleased with your results
afterwards. Well done Gilly. Thanks

- SD

"OUTSTANDING COURSE Love the exercises, really enforces the instruction Learning so much, will go over the course again reinforce learning Everything is explained in easy to understand terms"   

- JM

“A lovely paced course with the different
elements nicely segmented and of a good length. Certainly liked the extra
surprise of Cubes. Will aid in displaying data that does not fit well with the
confines of a pivot table. Cheers Gilly
!”

- GB

“Do Love the way you teach. Hope to learn
more from you for advanced DAX course with real world case studies. Bravo!

- HA

“Trainer explains concepts really well
without using too much tech talk. The many examples support the good
understanding of the subjects. The speed is ok for advanced users but too fast
if you did not follow the basic course. Course is complete and every important
subject is explained.”

- R

“Gilly does a great job of explaining
complex concepts and makes her points using thought-provoking analogies.
Excellent instructor!

- SA

“The course continued to build on the 10
Easy steps for Beginners. Detailed Instructions and real-world examples. Deep
dive into advanced Power Pivot Formulas.

- CJ

What you will learn
in this course:

  • Get & Transform – building the Data Model

  • DAX Iterators & Aggregator Functions

  • Initial Filter Context

  • Filter Context

  • Context Transition

  • VALUES()

  • ALL(), ALLSELECTED() & ALLEXCEPT()

  • IF() & HASONEVALUE()

Disconnected/Parameter Tables

  • Creating/Adding Disconnected tables

  • Harvester” Measures

  • Conversion Measures

  • Thresholds/Cut-offs

  • Banding

  • KPI’s

I provide examples
that we work through together. Then it’s over to you with practice exercises for you
to help embed and consolidate your skills. I always provide video solutions – so,
you’re never on your own.

Power Pivot is the perfect tool for those working in finance,
statistics, project, business and market analysis or any data reporting role
who have a need to create and produce Business Intelligence style dashboard and Insight reports.

I have used Excel
2016
to demonstrate this fantastic tool but you can follow along in
Excel 2010 & 2013 - I'll do my best to point out the differences. If you
have any questions about the course, feel free to message me here or check out
the FREE preview lectures to learn more.

Thanks for taking the time to check out my course. I can't wait to help you take the next step in developing your DAX skills. 

Take the first steps to a new and rewarding future by clicking on the TAKE
THIS COURSE
button, located on the top right corner of the page.

Mastering Intermediate DAX – Power BI, Power Pivot & SSAS

Take your Data Analysis Expression Skills to the Next Level with DAX for Power BI, Power Pivot and Analysis Services

Created by Paula Guilfoyle CPA & MVP - Microsoft MVP, CPA Accountant, & Life Long Learner

"]

Students: 2318, Price: $89.99

Students: 2318, Price:  Paid

Data Analysis and data modelling made easy with Data Analysis eXpressions. DAX can be used in Power BI, Power Pivot and Analysis Services.

Analyse and Model your data with in Power BI, Excels Power Pivot and Analysis Services with Data Analysis eXpressions.

This is a hands on course

Course Overview

In the First section of this course you will refresh the fundamentals of how DAX works.  as this section is a refresher section we will work through example rather fast.. We will discuss Row context and Filter context, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships and much more.

The aim of section 2 is to introduce you to some DAX functions that we will be working with in more detail later in this course.  Many of the functions and expressions we will use in this section allow you alter or amend how totals and subtotals are shown. Functions covered will include ISFILTERED, ISCROSSFILTERED, ALLSELECTED, HASONEVALUE and SELECTEDVALUES

In Section 3 we will look in dept at CALCULATE and Contest Transition.  You will learn when to use FILTER inside CALCULATE and also when it is useful to combine CALCULATE and VALUES.

Section 4 is packed with Case Studies.  We will look at different problems and the solutions.  The first case study will focus on parent-child-hierarchy and include functions such as PATH and PATHLENGHT.  The second case study will look at different Moving Averages using EARLIER, FILTER, VALUES and AVERAGE.  In the third case study we will look at the use of Iterator functions over different granularities.

Finally you will learn about about advanced relationships.  We will look at BI Directional Filters and the use of USERELATIONSHIP

Each section of this course contains a folder to download. The folder contains the examples shown in the course and also activities for you to complete. These Activities are of utmost importance.  When it comes to learning DAX, practice is a must.

Mastering DAX Calculations in Power BI

Create advanced analytical models by learning how to harness the power of DAX calculations for use within Power BI

Created by Enterprise DNA - Empowering Power BI Users to Change Their World

"]

Students: 1976, Price: $89.99

Students: 1976, Price:  Paid

This training will take you from a beginner to advanced user of Power BI by utilizing the powerful DAX language to the fullest. Covered in the course material are all the beginner theory that you must understand very well to harness the analytical power of DAX. Through real-world scenarios you will be taken through how to use DAX in practice to discover the insights you want to find in your data. Covered are every major DAX function and how to use these when completing calculations and in combination with each other. DAX is the most difficult part of Power BI to learn and put into practice well. This course covers all major tips and techniques that if practiced will have any Power BI user creating compelling Power BI reports and solutions.


Details of what you will learn during this course

  • Learn - what DAX is and the journey required to master it

  • Understand - what you can achieve with DAX if learnt well

  • Review - DAX basics, including calculated columns vs measures, context & aggregation vs iteration formulas

  • Understand - why a quality data model is so important

  • Complete - a deep dive into simple aggregation and iterating functions

  • Review - the concept of 'context' comprehensively

  • Learn - the most important function in DAX, CALCULATE

  • Learn - all the major table and filtering functions

  • Review - how to use DAX in common analytical scenarios

  • Gain - a detailed overview of time intelligence functions and how to use within your models

  • Learn - advanced table functions and how to use them

  • Master - some of the most complex topics around how DAX actually works

What you get with the course

  • 11 hours of training

  • 1x demo data sets to follow along when practicing all DAX formula

Here are the specifics for the course

Learn how to:

  • Use DAX and also what you can achieve with DAX if utilised well

  • Structure and format DAX formula

  • Use DAX variables in your formulas effectively

  • Use calculated columns and measures in your models

  • Write aggregation, iteration and table DAX functions

  • Implement DAX functions in combination with each other

  • Visualise how the DAX calculation engine works via the concept of 'context'

  • Audit your formulas by understand filter and row context

  • Use the CALCULATE function in your analysis

  • Add additional virtual filters to your calculations by using table functions

  • Use DAX to solve common analytical scenarios you will face everyday in the real world

  • Use time intelligence table along with a quality date table

  • Use advanced table functions in unique calculation requirements

Testimonials:
"I've found DAX really hard, but it makes far more sense now. The explanations are clear and more simplified than I've read and watched elsewhere which is what I needed. The examples are great too." - Scott T. - Michigan

"I've been looking for resources like this everywhere but couldn't find any. So good to have these all in one place, with detailed explanations on how to build this myself. Seriously awesome stuff." - Renee M. - Melbourne

"I just started learning Power BI with the courses on this page and they are awesome and easy to follow and understand, even if English is not your original language.." - Álvaro, Chile

Other Details:
Number of Recommended CPE credits:
13.5

Mastering DAX Calculations - is a QAS self study (Traditional) course. It can also be accessed through a purchase of an Enterprise DNA Membership or Center of Excellence License.

This course was last updated on January 2020.

Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX

Microsoft Excel Pivot Tables, Get and Transform (Power Query) and Power Pivot (DAX) for advanced data analysis. 70-779.

Created by Phillip Burton - Best Selling Instructor - over 350,000 students so far

"]

Students: 1869, Price: $129.99

Students: 1869, Price:  Paid

This course covers the visualizations and analysing content required for Microsoft's 70-779 certification exam. (Note: this exam is no longer available, but the topics are well worth learning!)

Reviews

Nora: "I liked that it went through really fast through the process, as expected if you consider yourself an advanced Excel user. Really enjoyable"

Dilbag: "Phillip's presentation of content is amazing. He has in-depth knowledge of the subject. I would highly recommend this course."

Amy: "I want to add how this course is by far the best one I have found on the subject. It really delves deeply into each piece of material. While many courses focus on getting you ready for the exam, this one makes sure you know how to use it in the real world as well. I would suggest this course to anyone who not only wants to pass the 70-779 test, but utilize it in their job."

Khalid: "Great great teacher. knowledgable in the tech and its usages, Speed, info delivery, and his voice is friendly. I'm lucky to choose this course over another one ;). Thank you all"

----------------

Do you already use the PC version of Excel to create data analysis, but find that you need to create more advanced analyses? Do you want to combine various sets of data, and or manipulate existing data sets? Do you want to save time, and have your analysis be automatically refreshed with new data?

In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft certification.

Excel is one of the most requested analysis tools that are requested in the job market, and the ability to being able to use it at an advanced level could be very useful for your current work, and your next job hunt.

This course comes in three parts:

Part 1 - Creating Pivot Tables and Pivot Charts

This part of the course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.

It sounds difficult, but in fact can be done in just a few clicks. We'll do our first one in a couple of minutes - that's all it takes. We'll also add a chart as well in that time.

After only these first few minutes, you will be streets ahead of anyone who doesn't know anything about Pivot Tables - it is really that important.

After this introduction, we'll go into some detail into how to set up your Pivot Table - the initial data, and the various options that are available to you. We will go into advanced options that most people don't even know about, but which are very useful.

By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you'll be able to help others with their data analysis.

Part 2 - Get and Transform Data (also known as Prepare the Data)

We see how data can be transformed, saving you time in analysing the data. We'll look at sorting and filtering, split columns, and other transform activities. We'll merge, append and combine queries together. We'll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the M language.

Part 3 - Refining the model (also known as Model the Data)

We'll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language.

The course will take around 16 hours to complete, but completing this will enable you to create vizzes, dashboards and stories of your own, and know how to overcome common problems.

The course increases in difficulty slowly, so you'll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step.

The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I'll introduce every component as we go on.

At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves.

Please note: Microsoft will retire the 70-779 exam on 31 January 2021. No replacement has yet been given by Microsoft.

DAX Power Pivot Time Intelligence – 10 Easy Steps

Support the Needs of Business Intelligence Using Custom Calendars and Time Period Functions in DAX.

Created by Gilly Dow - IT Training Consultant

"]

Students: 1818, Price: $109.99

Students: 1818, Price:  Paid

This course builds upon the skills learned in the first
course in this series DAX Power Pivot –
10 Easy Steps for Beginners.

You have already gotten your hands dirty with DAX & Power Pivot
and seen how awesome it is. Now you are ready to take your skills to the next
level by delving deeper and acquiring a more thorough understanding of how
Power Pivot handles Time data.

Data Analysis
Expressions
(DAX) includes Time Intelligence functions to support
the needs of Business Intelligence analysis by enabling you to manipulate data
using time periods, including days, months, quarters, and years, and then build
and compare calculations over those periods.

Here's what others had to say about the course:

"So far it's been easy to follow. The instructor is doing a great job of explaining what she is doing. Looking forward to more advanced topics. UPDATE: I've completed the course. It's a great course and I'm glad I took this one, as well as DAX Power Pivot 10 Easy Steps for Beginners. I'll be referencing the material often, there's a lot on information that's new to me. I really want to dive more into custom calendars and DAX patterns. I've already been showing my managers at work how powerful DAX functions can be. Gilly Dow did a fantastic job with both of her courses I took on Udemy. She's very knowledgeable on Excel and Power Pivot topics and her enthusiasm and encouragement always shows in her lectures. She is very responsive to queries from her students; my questions were answered very quickly. I've taken other online courses where you never heard back if you were having problems; that's definitely not an issue here."

- John Pertell

"Outstanding. It’s explained clear concise wonderful examples that are broken down and clearly explained fantastic course great teacher and teaching style. Highly recommend"

- Stephen Davanzo

"Highly recommended course! For every single function mentioned in the course there are an example and practice exercise. Great!"

- Elbina Rizakhanova

What You'll Learn:

The first part of the course concentrates on DAX time-ready functions ideal for a
standard calendar – the kind you hang on your wall. So, if that’s how you roll
at work – this is perfect for you.

The second half raises the stakes and you will learn how to
manipulate DAX to generate your own custom functions to work with 4-4-5 calendars used in many different
industries including retail.

In order to do this, I’ll introduce you to some new DAX functions that will elevate your
skills enabling you to build custom functions for those pesky non-standard calendars.

Even if this doesn’t fit your remit – DO IT ANYWAY! Your level of understanding will increase leaps and
bounds and your confidence will soarrrrr!!! Plus, it’s GREAT fun and you’ll
learn heaps along the way!

What you will learn
in this course:

Performing Date Calculations in DAX with a Standard Calendar

  • Building a standard Calendar table
  • Running Totals with: Month-to-Date (MTD), Quarter-to-Date (QTD) and Year-to-Date (YTD)
  • Computing the moving annual total for Fiscal Year Ends
  • Aggregating and Comparing Growth %’s over time
  • Time intelligence with CALCULATE()
  • Computing periods from the Prior Year
  • Closing Balance, First Date, Last Date, End of Month and Start of Year
  • Computing values Between Dates

Performing Date Calculations in DAX with a 4-4-5 Calendar

  • Building a custom Calendar table
  • Working with multiple Calendar tables
  • Manipulating DAX Patterns
  • Custom Time intelligence with CALCULATE()
  • Custom Time intelligence with CALCULATE(), FILTER() and ALL()
  • Aggregating and Comparing Growth %’s over time

Will it be easy?
Yes and no – the first half of the course – the DAXtime-ready
functions are intuitive and straightforward.

The custom Time Intelligence functions you create can be challenging but with my guidance and your growing understanding it will be really, really satisfying - trust me!

Thanks for taking the time to check out my course. I can't wait to help you take the next step in developing your DAX & Power Pivot skills. I have used Excel 2016 to demonstrate this fantastic tool but you can follow along in Excel 2010 & 2013 - I'll do my best to point out the differences. If you have any questions about the course, feel free to message me here or check out the FREE preview lectures to learn more.

Take the first steps to a new and rewarding future by clicking on the TAKE THIS COURSE button, located on the top right corner of the page.

I look forward to seeing you on the inside!

Power BI Masterclass 8 – Python, Finance, and advanced DAX

How to become a data analyst and learn Power BI fast. Power BI data scientist python Power BI Data Science

Created by Dan We - Coach

"]

Students: 1327, Price: $139.99

Students: 1327, Price:  Paid

MS Power BI is an andvanced 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 immensly improve your career opportunities but also your job satisfaction!

Power BI is also a great tool for datascience 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 datascience jobs.

Power BI has a very strong active community and with Microsoft pushing this solution to it's enterprise customers, Power BI has a bright future ahead. And you can be part of this future!

To help you getting into this highly rewarding and interesting career path the Power BI Masterclass Series has been created.

 

Data science, python Power BI? Yes those can be used together! 

In this 8th Masterclass you will

·         learn and apply additional advanded DAX expressions and calculations and dive deep into a business dataset

·         dive into Python and leverage it's strength in Power BI (3 different ways)

apply data science libraries from python in Power BI 

·         learn to create a balance sheet structure and how to evaluate the balance with a sanity check DAX measure

·         apply custom visuals

·         create your final dashboard

What we learn in this course might also help you later with your Power BI certification exam as well as your data analytics or data science career

You can follow along with the provided learning material in Power BI on your own computer at your own pace. Exited? You should be. So let's answer the question on how to master Power BI Desktop. Buckle up and meet me in the first lecture starting today!

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

4.Power BI Masterclass - DAX, Excel And More

5. The Power BI Masterclass - Additional Tips and Tricks

6. Power BI Desktop - Data Prep Challenges

7. Power BI Masterclass - DAX, R and Gateways

8. Power BI Masterclass - Python Finance and Advanced DAX

9. Power BI Masterclass - the next level

  Each Microsoft Power BI Masterclass course will add to your knowledge base and enhance your skills further. After attending the complete series you will have honed your skills to an very advanced level and be able to successfully dive into your Microsoft Power BI data analytics career.

Mastering Data Modeling Fundamentals in Power BI

Learn how to create relationships, calculated columns measures and use DAX formulas in Power BI Data Modeling

Created by Ameen Khan - Online Instructor | Power BI Developer | Web Developer

"]

Students: 1284, Price: Free

Students: 1284, Price:  Free

Connect Power BI to multiple data sources to create reports. Define the relationship between your data sources.

Learning objectives

In this module, you will:

  • Create relationships between your data sources

  • Create a new field with calculated columns

  • Optimize data by hiding fields and sorting visualization data

  • Create a measure to perform calculations on your data

  • Use a calculated table to create a relationship between two tables

  • Format time-based data so that you can drill down for more details

This module is part of these learning paths

  • Create and use analytics reports with Power BI

  • Introduction to modeling your data

  • How to manage your data relationships

  • Create calculated columns

  • Optimize data models

  • Create measures

  • Create calculated tables

  • Explore time-based data

  • Check your knowledge

  • Summary

One of Power BI's strengths is that you don't need to flatten your data into a single table. Instead, you can use multiple tables from multiple sources and define the relationship between them.

How to manage your data relationships

The Model view in Power BI Desktop allows you to visually set the relationship between tables or elements. A relationship is where two or more tables are linked together because they contain related data. This enables users to run queries for related data across multiple tables. Use the Model view to see a diagrammatic view of your data.

Writing DAX Queries

DAX is much more than a language for writing measures. It's also a powerful and full-featured query language

Created by Randy Minder - Data Engineer / Business Intelligence / Power BI / Snowflake

"]

Students: 1147, Price: $24.99

Students: 1147, Price:  Paid

As a DAX developer you've probably written many measures, expressions and code for calculated columns. But, DAX is also a full featured and powerful query language for retrieving data in a table format, much like SQL. There is much more to being a professional DAX developer than just writing measures.

The goal of this course is to teach the student what a complete DAX query is and how to read and write one. You'll learn how a query is constructed, the tools available to execute your queries, exporting data and all the various DAX table functions available to help you create and manipulate data. We'll then help make the transition from being a T-SQL developer to a DAX developer a bit easier by comparing common query scenarios.

Finally you'll have a change to test your knowledge with 15 questions and exercises.

DAX Power Pivot 10 Easy Steps for Advanced Users

Learn advanced Data Modeling techniques, Variables and Budget Patterns

Created by Gilly Dow - IT Training Consultant

"]

Students: 1132, Price: $99.99

Students: 1132, Price:  Paid

Are you ready to take your DAX skills to the next level? My new DAX Power Pivot – 10 Easy Steps for Advanced Users follows on from the my previous "10 Easy Steps" series to enable you to increase the complexity of your data models and progress to creating and understanding more complex calculations.

I have created this course specifically for those students who have taken my Beginners and Intermediates courses where you have learned the fundamentals necessary to transition into more advanced concepts enabling you to build bigger data models and create more complex calculations.

By helping you to understand evaluation context will help you "think" like DAX. When you have this understanding you’ll be in a better position to troubleshoot when things don’t go according to plan.

Course Contents

  • Warm Up

  • Variables

  • Row & Filter Context

  • Static Segmentation

  • Multiple Data Tables

  • RANKX() & TOPN()

  • Different Granularities

  • Budget vs Actuals

  • Budget Patterns (Single Year)

  • Budget Patterns (Multiple Years)

  • Budgets (Monthly)

I provide examples that we work through together. Then it’s over to you with practice exercises to help you embed and consolidate your skills. You receive all the group work and exercise files and a fully supporting, diagram rich user guide pdf. I always provide video solutions – so, you’re never on your own.

Still not sure? Here's what others have had to say about my "10 Easy Steps" series of courses:

DAX Power Pivot - 10 Easy Step for Advanced Users

"Once again, a masterpiece from Gilly to guide through the journey of advanced DAX. Step by Step diving deeper into DAX logic without loosing the line thanks to the outstanding effort of a well structured course which come along with a clear guideline, recaps and exercises to be able to adapt to own projects soon. Thanks so much Gilly!"

Doris.

DAX Power Pivot - 10 Easy Step for Advanced Users

"Another excellent course by Gilly. Covers a range of topics clearly and thoughtfully with challenging and interesting practice exercises."

Gary F.

DAX Power Pivot – 10 Easy Steps for Beginners

I thought that I was intermediate on this topic, so didn't bother buying the beginner course. However, getting stuck part way through the intermediate course, I decided to complete the beginner course. Boy am I glad I did - it has really consolidated things for me, and was well worth the money. If you haven't taken any of Gilly's courses before I can highly recommend them - she is super enthusiastic, keen, knowledgeable, and very responsive. If you only take one DAX course as a beginner, make it this one”.

Ian W.

DAX Power Pivot Time Intelligence – 10 Easy Steps

Great Course from Gilly. Her courses are a masterpiece and this subject was a tough one but she does a good job in explaining it Step By Step. Going by her own words you need practice to master it but at least I am happy the foundation is being laid with strong understanding to move forward. Thanks so much Gilly

Guna R.

DAX Power Pivot – 10 Easy Steps for Intermediates

It is obvious that Gilly has spent a lot of time with her study guide and organization of this class. This is one of the best illustrated courses I've found on Udemy. Explanations of the DAX formulas are very clear and flow logically throughout the course. The concepts discussed are easily at the Intermediate level as advertised. Truly an exceptional effort by Gilly Dow.”

Jimmy F.

Power Pivot is the perfect tool for those working in finance, statistics, project, business and market analysis or any data reporting role who have a need to create and produce Business Intelligence style Dashboard and Insight reports.

I have used Excel 2016 to demonstrate this fantastic tool but you can follow along in Excel 2010 & 2013 - I'll do my best to point out the differences. If you have any questions about the course, feel free to message me here or check out the FREE preview lectures to learn more.

Thanks for taking the time to check out my course. I can't wait to help you take the next step in developing your DAX skills.

Take the first steps to a new and rewarding future by clicking on the TAKE THIS COURSE button, located on the top right corner of the page.

Microsoft Power BI Masterclass 7 Learn DAX, R, and Gateways

How to become a data analyst fast. Microsoft Power BI online training. How to use R in Power BI Power BI Data Science

Created by Dan We - Coach

"]

Students: 1011, Price: $89.99

Students: 1011, Price:  Paid

Master Microsoft Power BI and create  your succesful business analyst / data analyst career

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

Because of that companies are constantly searching for skilled employees and freelancers with the necessary capabilities to help with analyzing data and creating valuable highly profitable insights. This will be the key advantage to succeed in business.

MS Power BI is an andvanced 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 immensly improve your career opportunities but also your job satisfaction!

Power BI is also a great tool for datascience 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 datascience jobs.

Power BI has a very strong active community and with Microsoft pushing this solution to it's enterprise customers, Power BI has a bright future ahead. And you can be part of this future!

There is no coding required! Power BI allows you to do that but it's not necessary.

To help you getting into this highly rewarding and interesting career path the Power BI Masterclass Series has been created.

It's an exclusive series currently consisting of these courses on udemy.

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

4.Power BI Masterclass - DAX, Excel And More

5. The Power BI Masterclass - Additional Tips and Tricks

6. Power BI Desktop - Data Prep Challenges

7. Power BI Masterclass - DAX, R and Gateways

8. Power BI Masterclass - Python Finance and Advanced DAX

9. Power BI Masterclass - the next level

 Each Microsoft Power BI Masterclass course will add to your knowledge base and enhance your skills further. After attending the complete series you will have honed your skills to an very advanced level and be able to succesfully dive into your Microsoft Power BI data analytics career.

In this 7th Masterclass you will

  • learn and apply additional advanded DAX expressions and calculations and dive deep into a business dataset

  • getting an introduction on how to use R in Power BI

  • learn how to set up your personal data gateway to refresh your on premise data in the Power BI service

  • apply new custom visuals

  • create your own Sales dashboards

What we learn in this course might also help you later with your Power BI certification exam.

You can follow along with the provided learning material in Power BI on your own computer at your own pace. Exited? You should be. So let's answer the question on how to master Power BI Desktop. Buckle up and meet me in the first lecture starting today!

DAX Dashboard Design – 10 Easy Steps

How to Create Interactive Business Intelligence Dashboard Reports with DAX Power Pivot

Created by Gilly Dow - IT Training Consultant

"]

Students: 866, Price: $89.99

Students: 866, Price:  Paid

DAX Dashboard Design – 10 Easy Steps will guide you through the entire process of Dashboard creation covering every part of the process - in depth. From creating an element grid system to automating Sparklines with VBA - start to finish

 By learning advanced techniques, you will impress the decision-makers in your organisation, making you an irreplaceable asset in the process

Demand for Data Visualization alone is projected to grow by 44% and Pivot Table skills by 34%

 That's great news for us DAX Power Pivot and MS Excel users because IBM are projecting that the number of jobs for all data professionals in the United States will increase by 15% by 2020*

"The skills projected to grow the fastest include advanced analytical competencies—such as Data Science and Machine Learning—as well as Data Visualization–related skills and basic analytical tools, such as Pivot Tables in Excel, that are increasingly required across job categories."

* Source: IBM: The Quant Crunch, how the demand for data science skills is disrupting the job market

To propel you on your way to "DAX Data Dominance", my latest course in the 10 Easy Steps series will teach you how to create data visualisations in the form of interactive Dashboard Reports that uses DAX Power Pivot and Pivot Charts.

 Description & What You Will Learn

  • The course begins with creating the Power Pivot Data Model

  • You will draw on your experience of DAX Power Pivot by creating relationships, calculated columns, measures and KPI's

  • Throughout your studies, I share Top-Tips I use to acquire the real KPI’s stakeholders expect - leaving the guess work out and limiting the chances of Dashboard rejection

  • With a clear view and plan of action, you enter the next phase and begin building each element of the Dashboard with Pivot Charts and Reference Tables displaying key metrics and revealing hidden trends

  • Slicers, Timelines and Sparklines enhance the user experience presenting the data in an automated, dynamic format and Text Cells provide added value that all stakeholders and end users have come to expect

  • Having the skills to adapt to stakeholder demands will be handled with ease and confidence as you learn how to create “negative” Column and Bar Charts and “Scrollable Tables” for when Dashboard space is limited or when the brief changes

  • Take advantage of MS Excel's pre-formatted Themes to maintain consistency and standards

  • You will learn how to Lock Down the Dashboard ready for publication

  • Code simple VBA to tie the Named Ranges and Macro to automate Sparkline update

You will create and build the Dashboard as you progress. To help consolidate, reinforce and embed your learning you will complete practice exercises throughout the course and complete quizzes to test your understanding of key concepts.

With your new skills nailed and your confidence levels soaring, the course ends with a fun Dashboard Challenge assignment and an opportunity to test your Dashboarding skills

Who is the target audience?

  • Whether you are an employee, contractor, consultant or you just want to learn an in-demand skill that can help propel your career prospects, this is the perfect course to get you noticed. Trust me on this – it happened to me in a job role that had nothing to do with Dashboard Reporting – it opens doors!

  • If you want to maximise the likelihood of increased pay, promotions or better contracts then DAX Dashboard Design is an extremely worthwhile and marketable skill to have

  • This course is designed to take your intermediate-level DAX Power Pivot and MS Excel skills to the next level and beyond

Here's what others have said about the course:

"Good course - well thought out and presented. I like the fact that Gilly provides a work along manual with which to follow. That's the biggest plus. She's taken the time to create this material - use it as you follow along with her - its a great reference.  The mini quiz at the end of each chapter helps to reinforce the concepts which were covered. The practice exercises at the end of each chapter along with her review of those exercises further help reinforce what is being taught.  Her work is well thought out, presented in an easy and enjoyable format and at the end - you feel confident with what you have learned"

BW

"Enjoyable and useful content, geared for real world application by an engaging tutor. Highly recommended to those seeking to build effective dashboards in Excel"

ST

"Gilly’s, Latest Addition, DAX Dashboard Design  in her 10 Easy Steps Series courses continues to build off of the previous courses bringing your skill levels up to become extremely efficient in excel. If you already know some PowerPivot and PowerQuery you can start right off with this course DAX Dashboard Design to learn dashboard techniques and procedures to tie it all together.   Gilly is a brilliant teacher who clearly has a in-depth understanding of how power pivot, and power Query works and is able to break it down and simplifies it so you know how it works and understand how to use it in your day-to-day data analytics  If you will follow along and do the exercises when you’re done with a lesson you fully understand how to implement and use the power pivot and PowerQuery and Dax function for all your data work and dashboards to the fullest creating amazing reports. I highly recommend Gilly courses. Well done, thanks"

SD

"This was my second class from Gilly. Absolutely excellent! I really like the format. She has an excellent written guide and first-rate examples. I like to watch the video first, then work from the guide off-line.   I am going to sign up for a third class"

MB

Thanks for taking the time to check out my course. I can't wait to help you take the next step in developing your Dashboard Reporting skills. I have used Excel 2016 to demonstrate this fantastic tool but you can follow along in Excel 2010 & 2013 - I'll do my best to point out the differences.

If you have any questions about the course, feel free to message me here or check out the FREE preview lectures to learn more.

Take the first steps to a new and rewarding future by clicking on the TAKE THIS COURSE button, located on the top right corner of the page. 

Mastering DAX Studio

DAX Studio is the productivity tool every DAX, Power BI and Power Pivot developer should be using

Created by Randy Minder - Data Engineer / Business Intelligence / Power BI / Snowflake

"]

Students: 835, Price: $24.99

Students: 835, Price:  Paid

If you are a DAX developer, DAX Studio is a must have tool. This course allows you to get the most of DAX Studio. You'll learn how to execute queries, export data to CSV and SQL Studio, troubleshoot queries, capture all queries coming from Power BI, perform performance monitoring, dynamic management views and more...

Power BI Masterclass – DAX, Excel And More

Understanding DAX table calculations, Power BI Desktop and Excel. How to master DAX in Power BI. How to learn DAX fast

Created by Dan We - Coach

"]

Students: 819, Price: $109.99

Students: 819, Price:  Paid

Business Intelligence with Microsoft Power BI - How to?

Why Power BI? In a world of data Business Intelligence / Business Analytics is in high demand. We are living in a data driven society. This trend will continue to accelerate. Companies are constantly searching for ways to make better and faster and smarter decisions. This heavily involves getting insights from their 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 looking out for skilled employees and freelancers with the necessary capabilities to help them analyze and understand their data, 

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

So back to the question. Why Power BI? Well, because...

MS Power BI is an andvanced 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 and offer job opportunities if you manage to master Power BI.

Power BI is also a great tool for datascience 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 datascience jobs.

What we learn in this course might also help you later with your Power BI certification exam.

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

4.Power BI Masterclass - DAX, Excel And More

5. The Power BI Masterclass - Additional Tips and Tricks

6. Power BI Desktop - Data Prep Challenges

7. Power BI Masterclass - DAX, R and Gateways

8. Power BI Masterclass - Python Finance and Advanced DAX

9. Power BI Masterclass - the next level

All we do here is accomplished with a provided dataset but you can of course use your own dataset and explore it in detail. Additional course materials can be downloaded at no extra costs.

The introduction video contains a preview of a report you will built during the course so check it out.

Exited? You should be! Buckle up and meet me in the first lecture starting today!

Let's get into it and master Power BI in no time!


Power BI Masterclass – How to use CALCULATE in DAX

How to use CALCULATE function in DAX , understanding the CALCULATE function in POWER BI for beginners , Learn DAX fast

Created by Dan We - Coach

"]

Students: 751, Price: $89.99

Students: 751, Price:  Paid

Microsoft Power BI Masterclass - How to use CALCULATE in DAX

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 is inspired by students and extends my Power BI Masterclass series on udemy. This course is not a visual course like the other parts of the series. This time it's all about the most powerful as well as most difficult to understand function in Power BI - CALCULATE.

Understanding this function will drastically help us to improve our DAX knowledge and our overall Power BI DAX calculation skills!

Update: The complete Power BI Masterclass Series on udemy

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

4.Power BI Masterclass - DAX, Excel And More

5. The Power BI Masterclass - Additional Tips and Tricks

6. Power BI Desktop - Data Prep Challenges

7. Power BI Masterclass - DAX, R and Gateways

8. Power BI Masterclass - Python Finance and Advanced DAX

9. Power BI Masterclass - the next level

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

The DAX Workshop – Part 1

Learn DAX by working through real-world business scenarios via 45 exercises and tutorials

Created by Randy Minder - Data Engineer / Business Intelligence / Power BI / Snowflake

"]

Students: 747, Price: $24.99

Students: 747, Price:  Paid

The DAX Workshop is a course that allows the student to get proficient in the DAX language by practicing on all sorts of common business scenarios. Approximately 45 practice exercises, and a half-dozen tutorials, exist covering most of the important parts of the DAX language. The focus of this course is not so much on teaching the language, although there is a lot of that. The main focus is working through exercises to clearly show how the DAX language can be used to solve common business reporting requirements.

DAX Data Analysis Expressions using Free Tools for Beginners

Learn DAX with Power BI step-by-step and use it with Excel Power Query, Excel PowerPivot or SSAS .

Created by BizticsCom King - Passionate data expert in Business Intelligence field.

"]

Students: 704, Price: $129.99

Students: 704, Price:  Paid

**** Life time access to course materials. 100% money back guarantee ****

Companies are gathering more and more data every day. Skills in data analysis, Business Intelligence / Business Analytics are highly in demand in today's job market. In this course, you will learn how to use DAX to Analyze, find Patterns and Trend in your Data using Power BI. Once learned can also be used in Excel and SQL Server Analysis Services.

In this course together, we will go over business scenarios where you will learn, how to use advanced / complex DAX calculations further to derive more insights from data. We are using SQL Server Adventure Works Data warehouse as a sample database. We will hold your hand and walk you thru each scenario Step-by-step.

Not only you will learn Power BI Best Practices, Tip, Tricks and Case Studies that you will not find in ANY other course but also learn Microsoft's Popular Course DASHBOARD-IN-A-DAY at your own pace at home or at your office AS A BONUS. All of the exercises are designed by keeping the practical aspects of DAX in mind. All exercises are 100% handson.

24+ hours of HD videos of building Business Scenarios using DAX from scratch to finish. Files for Start and Finished projects also included to challenge you so you can learn by immediately applying what you are learning. You will have gained the knowledge and confidence to apply these same concepts to real-word to solve the Business problems or Business requirements.

By the time you complete this course, you will be a highly proficient in DAX. You will be fully prepared to collect, clean, model and present data for any purpose. You will be using your skills as a Business Intelligence Professional to extract knowledge from data so you can analyze and visualize complex Business Problems/Requirements with ease.

Why should you consider a career as a Business Data Analyst?

  • Salary. A Business Data Analyst is a well-paid career

  • Stable Career. As most corporations gathering more and more data. There will never be shortage of Jobs for Business Data Analyst.

  • Advancement in Career: Since you will be building different reports for different departments. You will never be bored and always be valued. Which will bring you more opportunities in your career. Business Data Analyst get very visibility in corporations. Whole management depends on them.

#microsoft #powerbi #data #business #intelligence #analysis #DAX

Section1 : Introduction

  • Thank you and How to get support

Section2 : Install Power BI and SQL Server

  • How to install Power BI Desktop

  • How to use the Start and Finish Files

  • SQL Server Installation

  • Connecting to Database using SSMS

  • Download and install sample databases

  • Import data from SQL Server

Section3 : Dax Basics

  • Dax Model Components

  • What is Dax

  • Dax Data Types

  • Dax Operators and Syntax

  • M vs Dax

  • Create a Column

  • Rules to Create Measures

  • Calculated Columns vs Calculated Measures

Section4 : DAX Date and Time Functions

  • CALENDAR Function

  • CALENDARAUTO Function

  • DATE Function

  • DATEDIFF Function

  • DATEVALUE Function

  • DAY Function

  • EDATE Function

  • EOMONTH Function

  • HOUR Function

  • MINUTE Function

  • SECOND Function

  • MONTH Function

  • NOW Function

  • TIME Function

  • TIMEVALUE Function

  • TODAY Function

  • WEEKDAY Function

  • WEEKNUM Function

  • YEAR Function

Section5 : DAX Filter Functions

  • CALCULATE Function - 0

  • CALCULATE Function - 1

  • ALL Function

  • ALLSELECTED Function

  • AllEXCEPT Function

  • CALCULATETABLE Function

  • CROSSFILTER Function

  • DISTINCT Function

  • DISTINCTCOUNT Function

  • FILTER Function

  • HASONEFILTER Function

  • HASONEVALUE Filter

  • ISFILTERED Function

  • ISCROSSFILTERED Function

  • KEEPFILTER Function

  • RELATED Function

  • RELATEDTABLE Function

  • REMOVEFILTERS Function

  • SELECTEDVALUE Function

  • USERELATIONSHIP Function

  • VALUES Function

Section6 : DAX Information Functions

  • CONTAINS Function

  • IN Function

  • CONTAINSROW Function

  • BLANK and ISBLANK Function

  • ISERROR Function

  • ISEVEN Function

  • ISINSCOPE Function

  • ISLOGICAL Function

  • ISNONTEXT Function

  • ISNUMBER Function

  • ISODD Function

  • ISTEXT Function

  • LOOKUPVALUE Function

  • USERNAME Function

Section7: DAX Logical Functions

  • AND Function

  • TRUE and FALSE Functions

  • IF Function

  • IFERROR Function

  • IN Function

  • NOT Function

  • OR Function

Section8 : DAX Text Functions

  • BLANK Function

  • COMBINEVALUES Function

  • CONCATENATE Function

  • CONCATENATEX Function

  • EXACT Function

  • FIND Function

  • FIXED Function

  • FORMAT Function

  • LEFT RIGHT Functions

  • LEN Function

  • LOWER Function

  • MID Function

  • REPLACE Function

  • REPT Function

  • SEARCH Function

  • SUBSITUTE Function

  • TRIM Function

  • UNICHAR Function

  • UPPER Function

Section9 : Dax Path Functions and Row Level Security

  • PATH Function

  • PATHCONTAINS Function

  • PATHITEM Function

  • PATHITEMREVERSE Function

  • PATHLENGTH Function

  • RLS - Static Row Level Security

  • RLS - Dynamic Row Level Security

  • RLS - Organizational Hierarchy 1

  • RLS - Organizational Hierarchy 2

  • RLS - Organizational Hierarchy 3

Section10 : Math Trig and Stat Functions

Some Examples:

DIVIDE

Performs division and returns alternate result or BLANK () on division by 0

SUM

Adds all the numbers in a column.

SUMX

Returns the sum of an expression evaluated for each row in a table.

Function Description

AVERAGE

Returns the average (arithmetic mean) of all the numbers in a column.

AVERAGEX

Calculates the average (arithmetic mean) of a set of expressions evaluated over a table.

COUNT

The COUNT function counts the number of cells in a column that contain numbers.

COUNTROWS

The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.

MAX

Returns the largest numeric value in a column, or between two scalar expressions.

MAXX

Evaluates an expression for each row of a table and returns the largest numeric value.

MIN

Returns the smallest numeric value in a column, or between two scalar expressions.

MINX

Returns the smallest numeric value that results from evaluating an expression for each row of a table.

RANKX

Returns the ranking of a number in a list of numbers for each row in the table argument.

Section11 : DAX Time-Intelligence Functions

  • CLOSINGBALANCEMONTH-QUARTER-YEAR Function

  • DATEADD Function

  • DATESBETWEEN Function

  • DATESINPERIOD Function

  • DATEMTD-QTD-YTD Function

  • ENDOFMONTH-QUARTER-YEAR Function

  • FIRSTDATE - LASTDATE Functions

  • FIRSTNONBLANK - LASTNONBLANK Function

  • NEXTDAY-QUARTER-MONTH-YEAR Function

  • OPENINGBALANCEMONTH-QUARTER-YEAR Function

  • PREVIOUSDAY-MONTH-QUARTER-MONTH Function

  • PARALLELPERIOD Function

  • SAMEPERIODLASTYEAR Function

  • TOTALMTD-QTD-YTD Function

Section12 : Advanced Time-Intelligence Scenarios

  • Create Date Table in DAX-0

  • Create Date Table in DAX-1

  • Create Date Table in M (important)

  • How to use PREVIOU Function

  • How to use SAMEPERIODLASTYEAR()

  • How to calculate Cumulative or Running totals TOTALXXX() Functions

  • How to use DATEADD() Function

  • How to add column DateLastPurchase in Customer Table 4.34

  • How to calculate Days to Ship and Delivery Status

  • How to calculate Spring-Summer-Autumn-Winter Sales for 2012

  • How to Calculate Customer Age and use it in charts and graphs

  • How to calculate Days till last purchase

  • How to calculate MOM values

  • How to calculate Previous Week Sales

  • How to calculate Running Total 1

  • How to calculate Running Total 2

  • How to calculate sales for last N days

  • How to calculate Weekend - Weekday sales 1

  • How to calculate Weekend - Weekday sales 2

  • How to calculate YOY Growth

  • How to calculate YTD with Different Fiscal Year

  • How to Calculate Thanksgiving-BlackFriday-CyberMonday 2 weeks sales

  • How to compare Quarter over Quarter 1

  • How to compare Quarter over Quarter 2

  • How to compare YearQuarterMonth better way

  • How to create Short Month Name for Fiscal Year

  • How to do Grouping and Segmenting 1

  • How to do Grouping and Segmenting 2

  • How to use specific relationships if you have more than 1 relationship

Section13 : Advanced Business Scenarios

  • Create new table for Scenarios Measures

  • How to calculate of order per customers

  • How to add calculated column in Employee table

  • How to add calculated column in Resellers table

  • How to calculate  Customers (using TOPN) for Target Marketing

  • How to calculate and display Profit Margins

  • How to calculate and display sales growth

  • How to calculate how many items bought by Customers Multiple times

  • How to calculate how many Resellers sold specific Item more than 5 times

  • How to calculate Moving Average 1

  • How to calculate Moving Average 2

  • How to calculate number of Products - Customers Sales Trend

  • How to calculate Profit or Margin Variance MOM

  • How to calculate sales category for Customers

  • How to calculate TOP 5 Customers with RANKX

  • How to calculate Trend on Profit for Internet Sales

  • How to categorize Employees on Sales

  • How to categorize Resellers

  • How to create Product Segment

  • How to export measures from Power BI file

  • How to see top N Products 01 Statically

  • How to see top N Products 02  Dynamically

  • How you calculate and show Profits

  • How you calculate Best Product Sales Day

  • How you calculate Dynamic TOPN product or Customers

  • How you calculate Hot Selling Products

  • How you calculate how many unique Customers bought specific Product

  • How you calculate how many unique Products bought by each Customer

  • How you calculate product sales growth

  • How you calculate Reseller 01 Sales Growth YOY

  • How you calculate Reseller 02 Profit Margins YOY

  • How you calculate Revenue Forecast 01 using Analytics Tab

  • How you calculate Revenue Forecast 01 using What If Parameter

  • How you calculate Top Employees

  • How you calculate which Reseller selling what Products

  • How you show Products quantity forecast 01 using Analytics Tab

  • How you show Products quantity forecast 02 using using What If Parameter

  • How you smooth the trend using Moving Averages

Section13 : Bonus – Dashboard-in-a-day (Same as actual Microsoft Class)

  • Dashboard-in-a-day and PBI Best Practices

  • DIAD - Introduction

  • DIAD - Accessing Data

  • DIAD - Data Prepration-0

  • DIAD - Data Prepration-1

  • DIAD - Data Modeling and Exploration-0

  • DIAD - Data Modeling and Exploration-1

  • DIAD - Data Modeling and Exploration-2

  • DIAD - Data Modeling and Exploration-3

  • DIAD - Data Modeling and Exploration-4

  • DIAD - Data Visualization-0

  • DIAD - Data Visualization-1

  • DIAD - Publishing Report

  • DIAD - Creating Dashboard0

  • DIAD - Creating Dashboard1

  • DIAD - Creating Dashboards

Section14 : Bonus – Power BI Best Practices.

  • Best Practice0

  • Best Practice1

  • Best Practice2

  • Best Practice3

  • Best Practice4

  • Best Practice5