Power BI  Query Editor and Dax Calculations. 2-Day Course. In-Classroom

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.More about us:training@pcworkshopslondon.co.ukOur classes are instructor led, in our Live Virtual ClassroomCourses well developed by registered, qualified instructors with a wealth of experience in software development and training.The maximum groups size that can access our Virtual Classroom, is 4.Every one gets personalised attention.Why learn with us at PCWorkshops:Excellent, up-to-date courses, following latest trends and technologies.Excellent trainers with professional experience.Award Winning Trainer21 Years In BusinessExcellent Client ReferencesPCWorkshops CertificateWeekdays, Evenings and WeekendsAt PCWorkshops, we love out job!We offer Training Courses in Software Packages:Java ProgrammingPython Programming, Python data analytics, Python Machine LearningDatabase design and Data NormalisationSQL CoursesData Analysis andMS Excel, data analyses with Excel. Excel VBAAccess Database Courses.MS Project TrainingMS Office TrainingOur Style:Relaxed, Practical, UsefulMethods of instruction:Classroom training with max class-size 4 peopleVirtual classrooms via online video links1-1 mentoringCustomised trainingCertification:Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.Our clients are:Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualificationCustomisation:We can tailor all our courses. Email to customise location, times, content.Terms and Conditions:B﻿y booking a course with us, you agree to the terms and conditions specified on our website:https://pcworkshopslondon.co.uk/termsandconditions.html

PCWorkshops

Power BI in depth for intermediate users. Calculations, Query Editor and Advanced DAX Calculations

London

Excellent course to learn presenting data visually with Microsoft Power BI. In Classroom. Practical. Instructor-led.Y ou can request to attend at our officed in Manchester, Birmingham, Portsmouth, Southend-On-Sea, Milton Keynes, and London.Power BI in depth for intermediate users. Calculations, Query Editor and Advanced DAX Calculations The Power BI Query Editor<ul><li>Overview and Introduction to The Query Editor</li><li>Perform Data Transformations</li><li>Introduction to Transformations</li></ul><ul><li>Data Transformations</li><li>Conditional IF</li></ul>Advanced Transformations<ul><li>Introduction to Advanced Transformations</li><li>Merge Function</li><li>Append Data</li><li>Custom Calculations</li><li>Group By Function</li></ul>Cleanse Data and Parameters<ul><li>Introduction to Cleanse Data</li><li>Query Editor Diagnostics</li><li>Cleansing Data Files</li><li>Parameters</li></ul>Connect to Power BI Connections and Data Sources<ul><li>Introduction to Power BI Data Connections and Sources</li><li>Loading Data from SQL Server</li><li>Loading Data from CSV and TXT</li><li>Practical Activity - Load Data from a CSV file</li><li>Loading Data from the Web</li><li>Practical Activity - Connect to Data on the Web</li><li>Loading Excel Data from One Drive for Business</li><li>Loading Data from XML files</li><li>Loading Data from JSON</li><li>Loading Data from the Power BI Service</li></ul>Build a Relational Data Model<ul><li>Intro to Database Normalization</li><li>Data ("Fact") Tables vs. Lookup ("Dimension") Tables</li><li>Creating Power BI Table Relationships</li><li>"Star" vs. "Snowflake" Schemas</li><li>Active vs. Inactive Relationships</li><li>Relationship Cardinality</li><li>Connecting Multiple Data Tables</li><li>Filtering &amp; Cross-Filtering</li><li>Hiding Fields from the Power BI Report View</li><li>Data Modeling &amp; Power BI best Practices</li></ul>Add Calculated Fields with DAX<ul><li>Introduction</li><li>Meet Data Analysis Expressions (DAX)</li><li>Intro to DAX Calculated Columns</li><li>Intro to DAX Measures</li><li>Adding Columns &amp; DAX Measures in Power BI Desktop</li><li>Implicit vs. Explicit DAX Measures</li></ul><ul><li>Filter Context Examples in Power BI</li><li>Step-by-Step DAX Measure Calculation</li></ul><ul><li>Understanding DAX Syntax &amp; Operators</li></ul>Functions<ul><li>Common DAX Function Categories</li><li>Basic Date &amp; Time Functions</li><li>Conditional &amp; Logical Functions (IF/AND/OR)</li><li>Common Text Functions</li></ul><ul><li>Joining Data with RELATED</li><li>Basic Math &amp; Stats Functions</li></ul><ul><li>COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)</li></ul>Calculate<ul><li>CALCULATE</li><li>CALCULATE &amp; ALL</li><li>CALCULATE &amp; FILTER</li><li>Iterator Functions (SUMX, RANKX)</li></ul> <ul><li>Time Intelligence Formulas</li></ul> <ul><li>DAX Best Practices in Power BI Desktop</li></ul>

Power BI Query Editor and Dax Calculations. 2-Day Course. In-Classroom

More events from PCWorkshops

Discover more events from PCWorkshops, from Business to other experiences you might love.

Still looking for the right event?

Explore all events in London and filter by date, category, and more to find the perfect fit.

Power BI Query Editor and Dax Calculations. 2-Day Course. In-Classroom

More events from PCWorkshops

Discover more events from PCWorkshops, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in London and filter by date, category, and more to find the perfect fit.