DAX Data Analysis Expressions using Free Tools for Beginners
4.4 (55 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
445 students enrolled

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 .
Bestseller
4.4 (55 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
445 students enrolled
Created by BizticsCom King
Last updated 4/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 25 hours on-demand video
  • 17 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn fundamentals and basics to Intermediate level DAX analysis
  • Learn how Relationships and DAX work together
  • Learn Create calculated FIELDS and MEASURES using DAX in Power BI
  • Perform SOPHISTICATED calculations such as Time Intelligence, Filtered Data and Creating Calculated Tables
  • Create RELATIONSHIPS between tables of data
  • Learn how to use DAX to create a DATE table
  • Learn how to calculate Moving totals and Rolling Totals
  • Learn how to use "Disconnected" tables to maximize Insights
  • Learn how to install SQL server and download Microsoft Data Warehouse and restore it on SQL Server
  • Learn Data and time functions to find yearly, quarterly and monthly trends in your data
  • Learn Dax Filter Functions to analyse data for specific products, customer and regions
  • Learn Dax Information functions to convert data types and find specific errors in your data
  • Learn Logical functions to combine data for specific conditions
  • Learn Path functions to build HIERARCHIES and get to specific level of HIERARCHIES
  • Learn Static and Dynamic Row Level Security to have anyone look at their specific data (Managers can see their own regions sales or Manager can you see their own employees data)
  • Learn to install PBI Desktop and get data from SQL Server
  • Get the total understanding of the basic DAX Aggregator and Iterator Functions
  • Gain confidence building measures with multiple functions - advancing your DAX KNOWLEDGE
  • Learn how to catalogue your data model functions in Power BI
  • Learn how to create powerful calculations and comparisons across multiples tables of data.
  • Learn how to create advanced DAX measures and calculated columns for complex calculations.
  • This hands on course will prepare you to start your data analytics career.
  • Learn to use the easiest Business Intelligence tool to create reports and dashboards.
  • Learn Dashboard-in-a-day at your own pace at home or at your office.
  • Learn Power BI Best Practices, Tip and Tricks
Requirements
  • This course is designed for PC users (PowerBI is not available for Mac)
  • You should be familiar with either Power Pivot, Power BI or Analysis Services
  • Willingness to learn DAX (Data Analysis Expressions)
Description

**** 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

Who this course is for:
  • Anyone looking to get a job and prepare to start data analytics career.
  • Entrepreneurs/CEO/Founders looking to master the Data Analysis process.
  • If you want to impress your boss and STANDING OUT from your colleagues and peers
  • Students learning in the field of Data.
  • You want to extend your knowledge in advanced DAX calculations .
  • Data scientists.
  • Business Analyst and aspiring Business Analyst.
  • You want your reports stand out and "WOW" your audience.
  • Business Analyst in charge of automation efforts.
  • Enthusiastic quality professionals who are NEW to the Business.
  • Analysis and want to take their skills to the next level.
  • Business Analyst who want to advance their skill set.
  • Anyone wanting to transition into Business Analyst.
Course content
Expand all 209 lectures 25:02:11
+ DAX Basics
8 lectures 58:34
DAX Model Components
05:03
What is DAX
05:01
DAX Data Types
04:13
DAX Operators and Syntax
08:21
M vs DAX
08:32
Create a Column
05:39
7 Rules to create Measures
06:37
Calculated Columns vs Calculated Measures
15:08
+ DAX Date and Time Functions
19 lectures 59:55
CALENDAR Function
11:45
CALENDARAUTO Function
02:54
DATE Function
03:22
DATEDIFF Function
06:24
DATEVALUE Function
01:43
DAY Function
02:53
EDATE Function
02:08
EOMONTH Function
02:48
HOUR Function
02:15
MINUTE Function
01:24
SECOND Function
03:21
MONTH Function
01:36
NOW Function
01:47
TIME Function
03:26
TIMEVALUE Function
02:22
TODAY Function
01:40
WEEKDAY Function
02:31
WEEKNUM Function
01:46
YEAR Function
03:50
+ DAX Filter Functions
21 lectures 02:19:02
CALCULATE Function - 0
08:24
CALCULATE Function - 1
05:46
ALL Function
09:27
ALLSELECTED Function
07:48
AllEXCEPT Function
08:53
CALCULATETABLE Function
09:19
CROSSFILTER Function
07:07
DISTINCT Function
06:07
DISTINCTCOUNT Function
02:56
FILTER Function
09:16
HASONEFILTER Function
07:56
HASONEVALUE Filter
07:09
ISFILTERED Function
03:44
ISCROSSFILTERED Function
03:59
KEEPFILTER Function
07:45
RELATED Function
06:30
RELATEDTABLE Function
04:23
REMOVEFILTERS Function
05:07
SELECTEDVALUE Function
03:07
USERELATIONSHIP Function
10:15
VALUES Function
04:04
+ DAX Information Functions
14 lectures 01:10:39
CONTAINS Function
03:29
IN Function
05:58
CONTAINSROW Function
03:15
BLANK and ISBLANK Function
13:11
ISERROR Function
03:14
ISEVEN Function
04:16
ISINSCOPE Function
10:38
ISLOGICAL Function
04:40
ISNONTEXT Function
02:02
ISNUMBER Function
02:22
ISODD Function
02:38
ISTEXT Function
02:36
LOOKUPVALUE Function
09:41
USERNAME Function
02:39
+ DAX Logical Functions
7 lectures 37:44
AND Function
04:31
TRUE and FALSE Functions
05:48
IF Function
06:12
IFERROR Function
03:07
IN Function
11:15
NOT Function
02:32
OR Function
04:19
+ DAX Text Functions
19 lectures 01:42:51
BLANK Function
05:08
COMBINEVALUES Function
04:34
CONCATENATE Function
02:30
CONCATENATEX Function
03:32
EXACT Function
05:14
FIND Function
06:54
FIXED Function
04:04
FORMAT Function
15:39
LEFT RIGHT Functions
09:39
LEN Function
02:37
LOWER Function
03:37
MID Function
05:01
REPLACE Function
04:57
REPT Function
05:07
SEARCH Function
05:33
SUBSITUTE Function
05:15
TRIM Function
02:32
UNICHAR Function
08:37
UPPER Function
02:21
+ Math - Trig and Stats Functions
2 lectures 33:15
Math and Trig Functions
14:34
Statistics Functions
18:41
+ DAX Path Functions and Row Level Secutiry in Power BI
10 lectures 01:13:18
PATH Function
09:34
PATHCONTAINS Function
04:12
PATHITEM Function
03:36
PATHITEMREVERSE Function
03:47
PATHLENGTH Function
02:45
RLS - Static Row Level Security
11:06
RLS - Dynamic Row Level Security
11:20
RLS - Organizational Hierarchy 1
11:40
RLS - Organizational Hierarchy 2
11:14
RLS - Organizational Hierarchy 3
04:04