DAX Data Analysis Expressions using Free Tools for Beginners
DAX Data Analysis Expressions using Free Tools for Beginners
**** 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
Most complete and comprehensive course in DAX with Power BI step-by-step.
Url: View Details
What you will 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
Rating: 4.4
Level: Beginner Level
Duration: 25 hours
Instructor: BizticsCom King
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.
View Sitemap