Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js Typescript HTML5 PHP
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Data Analysis Data Warehouse Business Intelligence Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin SwiftUI Mobile App Development
Graphic Design Photoshop Adobe Illustrator Drawing Canva Digital Painting InDesign Design Theory Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Emotional Intelligence Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Online Business Startup Business Plan Blogging Amazon Kindle Direct Publishing (KDP)
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Copywriting Email Marketing Google Analytics Startup Advertising Strategy

BusinessBusiness Analytics & IntelligenceMicrosoft Power BI

Power BI DAX transition from SQL

Power BI DAX step by step approach parallel with SQL. A practical approach to learn DAX in Power BI.
Rating: 4.3 out of 54.3 (85 ratings)
16,061 students
Created by Data Chunks
Last updated 4/2020
English
English [Auto]

What you'll learn

  • You will learn how to write Power BI DAX expressions against SQL queries.
  • How to import raw data into SQL server for comparisons
  • Data Validation
  • How to write complex filters
  • Use of Select & Evaluate to fetch the Data
  • Selectcolumns function in DAX and SQL
  • How to sort results in DAX and SQL
  • How to create calculated column in DAX and SQL
  • Distinct records in DAX and SQL
  • How to fetch unique records using Summarize function
  • Power BI Coalesce function in DAX and SQL
  • Custom column using Summarize and Selectcolumns function
  • Countrows with Summarize for grouping
  • Naturalinnerjoin and Inner join in DAX and SQL
  • Having clause in DAX and SQL
  • Cross join in dax and SQL
  • Summarizecolumns in DAX and SQL
  • IN operator in DAX and SQL
  • Search string in DAX and SQL
  • TopN results in DAX and SQL
  • Generate with TopN in DAX and SQL

Requirements

  • Prerequisites are not mandatory but it is helpful to know little bit about SQL queries and Power BI

Description

During my more than 10 years of experience in the area of Data Analysis & Business Intelligence, I see people feel not comfortable when they move from SQL track to Power BI DAX. Anyone can take this course who want to learn Power BI DAX in a practical way. People who have experience with SSRS reporting services and if they want to learn what will be the equivalent of SQL in DAX, this course will help you understand Power BI DAX in a very easy step by step approach.

This course is purely based on DAX studio and SQL. First, we write SQL query and then we try to achieve the same results in DAX studio. I updated all of the courses available on Udemy regularly with the latest updates from Microsoft.

This is one of the unique courses available on Udemy that takes SQL and DAX Power BI together.


This course includes the following topics.

- How to import data into SQL from Excel?

-Data Validation

-Use of Select & Evaluate to fetch the Data

-Selectcolumns function in DAX and SQL

-How to sort results in DAX and SQL

-How to create calculated column in DAX and SQL

-Distinct records in DAX and SQL

-How to fetch unique records using Summarize function

-Power BI Coalesce function in DAX and SQL

-Custom column using Summarize and Selectcolumns function

-Filtering record set in DAX and SQL

-Multiple logical conditions with Filter and Selectcolumn

-Countrows with Summarize for grouping

-Use of Addcolumns to achieve aggregation

-Addcolumn with Selectcolumn

-Addcolumns with Summarize function

-Calculatetable to filter recordset

-Calculatetable vs Filter function

-When to use calculatetable and filter function

-Naturalinnerjoin and Inner join in DAX and SQL

-Naturalinnerjoin and no physical relationship

-Alternatives of Natural Inner join in DAX

-Having clause in DAX and SQL

-Left outer join in dax and sql

-Cross join in dax and SQL

-Summarizecolumns in DAX and SQL

-Summarizecolumns with measure

-IN operator in DAX and SQL

-Search string in DAX and SQL

-Search string from left or right in DAX and SQL

-TopN results in DAX and SQL

-Generate with TopN in DAX and SQL


About me

I am your instructor Muhammad Asif Microsoft certified solutions expert in data management & Analytics. I have more than 10 years of experience in Microsoft BI stack with world-leading financial Firm. You will learn what exactly is used in the industry.


Who this course is for:

  • SQL Developers
  • BI Developers
  • Business Intelligence consultants
  • Data Scientists
  • Data Analyst
  • Power BI users

Instructor

Data Chunks
Senior Data Analyst
Data Chunks
  • 4.1 Instructor Rating
  • 662 Reviews
  • 54,288 Students
  • 6 Courses

I am Muhammad Asif Microsoft® Certified Solutions Expert- Data management and analytics with more than 10 years of experience in the field of business intelligence & Data analytics.

My expertise lies in assessing complex business requirements, compiling market and trend data, designing and testing software to accelerate efficiency and revenue growth. I have expertise in Microsoft Business Intelligence stack, visualization & analytical tools like SSRS and Power BI to analyse massive dataset. Analyses datasets with the help of python and DAX programming to extract actionable insights that will help drive business decisions.

I have completed a Master degree in Computer Science from Linköping University, Sweden in order to augment my qualifications. With a proven track record of successfully aggregating business data and developing solutions to improve business processes, I am confident to teach my students and can deliver ground level industry knowledge & expertise.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Terms
  • Privacy policy
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.