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 careerStable 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 #DAXSection1: IntroductionThank you and How to get supportSection2: Install Power BI and SQL ServerHow to install Power BI DesktopHow to use the Start and Finish FilesSQL Server InstallationConnecting to Database using SSMSDownload and install sample databasesImport data from SQL ServerSection3: Dax BasicsDax Model ComponentsWhat is DaxDax Data TypesDax Operators and SyntaxM vs DaxCreate a ColumnRules to Create MeasuresCalculated Columns vs Calculated MeasuresSection4: DAX Date and Time FunctionsCALENDAR FunctionCALENDARAUTO FunctionDATE FunctionDATEDIFF FunctionDATEVALUE FunctionDAY FunctionEDATE FunctionEOMONTH FunctionHOUR FunctionMINUTE FunctionSECOND FunctionMONTH FunctionNOW FunctionTIME FunctionTIMEVALUE FunctionTODAY FunctionWEEKDAY FunctionWEEKNUM FunctionYEAR FunctionSection5: DAX Filter FunctionsCALCULATE Function - 0CALCULATE Function - 1ALL FunctionALLSELECTED FunctionAllEXCEPT FunctionCALCULATETABLE FunctionCROSSFILTER FunctionDISTINCT FunctionDISTINCTCOUNT FunctionFILTER FunctionHASONEFILTER FunctionHASONEVALUE FilterISFILTERED FunctionISCROSSFILTERED FunctionKEEPFILTER FunctionRELATED FunctionRELATEDTABLE FunctionREMOVEFILTERS FunctionSELECTEDVALUE FunctionUSERELATIONSHIP FunctionVALUES FunctionSection6: DAX Information FunctionsCONTAINS FunctionIN FunctionCONTAINSROW FunctionBLANK and ISBLANK FunctionISERROR FunctionISEVEN FunctionISINSCOPE FunctionISLOGICAL FunctionISNONTEXT FunctionISNUMBER FunctionISODD FunctionISTEXT FunctionLOOKUPVALUE FunctionUSERNAME FunctionSection7: DAX Logical FunctionsAND FunctionTRUE and FALSE FunctionsIF FunctionIFERROR FunctionIN FunctionNOT FunctionOR FunctionSection8: DAX Text FunctionsBLANK FunctionCOMBINEVALUES FunctionCONCATENATE FunctionCONCATENATEX FunctionEXACT FunctionFIND FunctionFIXED FunctionFORMAT FunctionLEFT RIGHT FunctionsLEN FunctionLOWER FunctionMID FunctionREPLACE FunctionREPT FunctionSEARCH FunctionSUBSITUTE FunctionTRIM FunctionUNICHAR FunctionUPPER FunctionSection9: Dax Path Functions and Row Level SecurityPATH FunctionPATHCONTAINS FunctionPATHITEM FunctionPATHITEMREVERSE FunctionPATHLENGTH FunctionRLS - Static Row Level SecurityRLS - Dynamic Row Level SecurityRLS - Organizational Hierarchy 1RLS - Organizational Hierarchy 2RLS - Organizational Hierarchy 3Section10: Math Trig and Stat FunctionsSome Examples: DIVIDEPerforms division and returns alternate result or BLANK () on division by 0SUMAdds all the numbers in a column. SUMXReturns the sum of an expression evaluated for each row in a table. Function DescriptionAVERAGEReturns the average (arithmetic mean) of all the numbers in a column. AVERAGEXCalculates the average (arithmetic mean) of a set of expressions evaluated over a table. COUNTThe COUNT function counts the number of cells in a column that contain numbers. COUNTROWSThe COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression. MAXReturns the largest numeric value in a column, or between two scalar expressions. MAXXEvaluates an expression for each row of a table and returns the largest numeric value. MINReturns the smallest numeric value in a column, or between two scalar expressions. MINXReturns the smallest numeric value that results from evaluating an expression for each row of a table. RANKXReturns the ranking of a number in a list of numbers for each row in the table argument. Section11: DAX Time-Intelligence FunctionsCLOSINGBALANCEMONTH-QUARTER-YEAR FunctionDATEADD FunctionDATESBETWEEN FunctionDATESINPERIOD FunctionDATEMTD-QTD-YTD FunctionENDOFMONTH-QUARTER-YEAR FunctionFIRSTDATE - LASTDATE FunctionsFIRSTNONBLANK - LASTNONBLANK FunctionNEXTDAY-QUARTER-MONTH-YEAR FunctionOPENINGBALANCEMONTH-QUARTER-YEAR FunctionPREVIOUSDAY-MONTH-QUARTER-MONTH FunctionPARALLELPERIOD FunctionSAMEPERIODLASTYEAR FunctionTOTALMTD-QTD-YTD FunctionSection12: Advanced Time-Intelligence ScenariosCreate Date Table in DAX-0Create Date Table in DAX-1Create Date Table in M (important)How to use PREVIOU FunctionHow to use SAMEPERIODLASTYEAR()How to calculate Cumulative or Running totals TOTALXXX() FunctionsHow to use DATEADD() FunctionHow to add column DateLastPurchase in Customer Table 4.34How to calculate Days to Ship and Delivery StatusHow to calculate Spring-Summer-Autumn-Winter Sales for 2012How to Calculate Customer Age and use it in charts and graphsHow to calculate Days till last purchaseHow to calculate MOM valuesHow to calculate Previous Week SalesHow to calculate Running Total 1How to calculate Running Total 2How to calculate sales for last N daysHow to calculate Weekend - Weekday sales 1How to calculate Weekend - Weekday sales 2How to calculate YOY GrowthHow to calculate YTD with Different Fiscal YearHow to Calculate Thanksgiving-BlackFriday-CyberMonday 2 weeks salesHow to compare Quarter over Quarter 1How to compare Quarter over Quarter 2How to compare YearQuarterMonth better wayHow to create Short Month Name for Fiscal YearHow to do Grouping and Segmenting 1How to do Grouping and Segmenting 2How to use specific relationships if you have more than 1 relationshipSection13: Advanced Business ScenariosCreate new table for Scenarios MeasuresHow to calculate of order per customersHow to add calculated column in Employee tableHow to add calculated column in Resellers tableHow to calculate Customers (using TOPN) for Target MarketingHow to calculate and display Profit MarginsHow to calculate and display sales growthHow to calculate how many items bought by Customers Multiple timesHow to calculate how many Resellers sold specific Item more than 5 timesHow to calculate Moving Average 1How to calculate Moving Average 2How to calculate number of Products - Customers Sales TrendHow to calculate Profit or Margin Variance MOMHow to calculate sales category for CustomersHow to calculate TOP 5 Customers with RANKXHow to calculate Trend on Profit for Internet SalesHow to categorize Employees on SalesHow to categorize ResellersHow to create Product SegmentHow to export measures from Power BI fileHow to see top N Products 01 StaticallyHow to see top N Products 02 DynamicallyHow you calculate and show ProfitsHow you calculate Best Product Sales DayHow you calculate Dynamic TOPN product or CustomersHow you calculate Hot Selling ProductsHow you calculate how many unique Customers bought specific ProductHow you calculate how many unique Products bought by each CustomerHow you calculate product sales growthHow you calculate Reseller 01 Sales Growth YOYHow you calculate Reseller 02 Profit Margins YOYHow you calculate Revenue Forecast 01 using Analytics TabHow you calculate Revenue Forecast 01 using What If ParameterHow you calculate Top EmployeesHow you calculate which Reseller selling what ProductsHow you show Products quantity forecast 01 using Analytics TabHow you show Products quantity forecast 02 using using What If ParameterHow you smooth the trend using Moving AveragesSection13: Bonus - Dashboard-in-a-day (Same as actual Microsoft Class)Dashboard-in-a-day and PBI Best PracticesDIAD - IntroductionDIAD - Accessing DataDIAD - Data Prepration-0DIAD - Data Prepration-1DIAD - Data Modeling and Exploration-0DIAD - Data Modeling and Exploration-1DIAD - Data Modeling and Exploration-2DIAD - Data Modeling and Exploration-3DIAD - Data Modeling and Exploration-4DIAD - Data Visualization-0DIAD - Data Visualization-1DIAD - Publishing ReportDIAD - Creating Dashboard0DIAD - Creating Dashboard1DIAD - Creating DashboardsSection14: Bonus - Power BI Best Practices. Best Practice0Best Practice1Best Practice2Best Practice3Best Practice4Best Practice5
