Courses

    Pages & Posts

      • IT Training
        • Amazon Cloud (AWS)
        • Analytics and Big Data
        • Cisco
        • Citrix
        • Cloud Computing
        • CompTIA Certification
        • Cybersecurity
        • Deep Learning and AI
        • Development Tools
        • DevOps
        • F5
        • FlexPod
        • IBM
        • IT Security
        • Java
        • Juniper Networks
        • Linux
        • Microsoft
        • Mobile Computing
        • NetApp
        • Oracle
        • Salesforce
        • VMware
        • Web Development, HTML, and JavaScript
        • WebSphere
      • Business Training
        • Business Analysis
        • Enterprise Architecture
        • HIPAA Certification & Training
        • IT Governance
        • ITIL® Certification
        • Project Management
        • Salesforce
        • Scrum & Agile
        • Seminars
      • Services
        • APM Practice
        • Authorized Cisco Training
        • BPM Practice
        • Cloudera Training
        • Distance Learning
        • ITIL® Certification
        • Linux Certification Training
        • Media Security Solutions
        • Microsoft 365
        • Microsoft Official Courses On Demand
        • NetApp Training
        • Salesforce Training
        • Training Facilities
        • Visual Studio TFS Training
        • Enterprise Training Solutions
        • Room Rentals
        • State & Local Government
      • Student Resources
        • Ohio Workforce Training Voucher Program
        • Student Guide / Daily Schedule
        • College Credits / Tuition Reimbursement
        • Career Programs (WIA)
        • Student Policies
        • Testing & Certifications
        • Promotions
        • Local Hotels
        • Local Restaurants
      • Power BI for the Cloud - Level 3 - Advanced Languages

      Course Details

      Download PDF
      PBI-CAL
      2 Days
      06/07/2018 $1,395.00
      Sign Up for This Class

      Power BI for the Cloud - Level 3 - Advanced Languages

      Share this course

      Tweet Share
      babsimLIVE Delivery

      This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. This course will also introduce students to the M-Language and how it can be used to make querying more effective. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations, creating advanced DAX dashboards and report elements using Slicers, and understand the importance of the M Language and its uses.

      • Course Outline
      • Audience
      • Available Dates

      Course Outline

      Lesson 1 : Power BI Functions – M Language

      • M Language vs DAX Functions
      • Basic M Language Syntax
      • Working with Columns
      • IF Expression in M Language
      • Query Cleanup

      Lesson 2 : Basic DAX Functionality

      • Review of Calculated Columns
      • Review of Measures
      • Rules of Evaluation
      • Evaluation Context
      • Formatting DAX Code

      Lesson 3 : Controlling Content & Values

      • Controlling Values - DAX
      • M Custom Functions
      • Error Handling

      Lesson 4 : Context Control Functions

      • Iterative Functions
      • FILTER Function
      • ALL Function
      • CALCULATE Function
      • Additional Uses Of The ALL Function

      Lesson 5 : Contexts In Relationships

      • Working With Many Tables
      • Row Context & Relationships
      • Elevated Calculated Columns
      • Filter Context & Relationships
      • Cross Filtering Issues

      Lesson 6 : Advanced Concepts

      • Controlling Totals
      • Parameter Tables
      • Banding

      Lesson 7 : Time Intelligence Calculations

      • Working With Date Tables
      • Calculating Operating Periods
      • Working With Missing Periods
      • To-Date Functions
      • Advanced Date Functions
      • Prior Year Functions

      Audience

      Available Course Dates

      06/07/2018 11:00 am - 06/08/2018 7:00 pm babsimLive Delivery
      Click here to sign up for this class

      Related Courses

      College Credit, CEUs, PDUs and CDUs
      When you take courses with the Babbage Simmel, be sure you get the credit you deserve. Curriculum offered by Babbage Simmel can earn you college credit, CEUs, PDUs or CDUs.

      College Credit
      Select curriculum offered by Babbage Simmel is part of the accredited University of Findlay's undergraduate course catalogs. For questions please E-Mail: info@babsim.com or call 614-481-4345.

      Continuing Education Units (CEUs)
      Continuing Education Units (CEUs) are nationally recognized standard units of measurement earned for satisfactory completion of qualified programs of continuing education. If you need more information about CEUs, please E-Mail: info@babsim.com or call 614-481-4345.

      Professional Development Units (PDUs)
      Professional Development Units (PDUs) can be issued by PMI® for formal learning activities related to project management. Project Management Professionals (PMPs®) are required to earn a minimum of 60 PDUs every 3 years to maintain certification. For more information about this program go to the PMI® web site or call 1-855 746 4849.

      Continuing Development Units (CDUs)
      CDUs may be earned by attending professional development (e.g. courses, seminars) offered by organizations endorsed by IIBA® and designated as an EEP vendor. As an IIBA Endorsed Education Provider (EEP) Babbage Simmel's IIBA® endorsed courses qualify for CDU credit. For more information about CDUs go the IIBA® web site or call 1-647-426-3735.

      Our babsimLIVE distance learning brings the classroom learning experience to you by seating you virtually into a real-life instructor-led classroom taught by award winning world-class instructors with other IT professionals like yourself. From the comfort of your home, workplace, or at the Babbage Simmel Columbus Campus, you acquire the training you need, when you want it, in the environment that is most comfortable for you to be successful.

      About Us Contact Us Blog Find A Course

      © Copyright 2018 • Babbage Simmel. All Rights Reserved. Columbus Web Design by Jetpack | Privacy Policy