1433 Analytics courses

This FREE in-person event is structured to introduce SMEs to a variety of AI tools that are useful for improving business processes.

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - INTRODUCTION TO TRANSACT-SQL * Work with schemas * Explore the structure of SQL statements * Examine the SELECT statement * Work with data types * Handle NULLs 2 - SORT AND FILTER RESULTS IN T-SQL * Sort your results * Limit the sorted results * Page results * Remove duplicates * Filter data with predicates 3 - COMBINE MULTIPLE TABLES WITH JOINS IN T-SQL * Understand joins concepts and syntax * Use inner joins * Use outer joins * Use cross joins * Use self joins 4 - WRITE SUBQUERIES IN T-SQL * Understand subqueries * Use scalar or multi-valued subqueries * Use self-contained or correlated subqueries 5 - USE BUILT-IN FUNCTIONS AND GROUP BY IN TRANSACT-SQL * Categorize built-in functions * Use scalar functions * Use ranking and rowset functions * Use aggregate functions * Summarize data with GROUP BY * Filter groups with HAVING 6 - MODIFY DATA WITH T-SQL * Insert data * Generate automatic values * Update data * Delete data * Merge data based on multiple tables ADDITIONAL COURSE DETAILS: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for Sales Legal Marketing Business analysts Project managers AWS Academy students Other IT-related professionals Overview Summarize the working definition of AWS Differentiate between on-premises, hybrid-cloud, and all-in cloud Describe the basic global infrastructure of the AWS Cloud Explain the six benefits of the AWS Cloud Describe and provide an example of the core AWS services, including compute, network, databases, and storage Identify an appropriate solution using AWS Cloud services with various use cases Describe the AWS Well-Architected Framework Explain the shared responsibility model Describe the core security services within the AWS Cloud Describe the basics of AWS Cloud migration Articulate the financial benefits of the AWS Cloud for an organization?s cost management Define the core billing, account management, and pricing models Explain how to use pricing tools to make cost-effective choices for AWS services This course is for individuals who seek an overall understanding of the Amazon Web Services (AWS) Cloud, independent of specific technical roles. You will learn about AWS Cloud concepts, AWS services, security, architecture, pricing, and support to build your AWS Cloud knowledge. This course also helps you prepare for the AWS Certified Cloud Practitioner exam. Prerequisites General IT technical knowledge, General IT business knowledge 1 - INTRODUCTION TO AMAZON WEB SERVICES * Summarize the benefits of AWS * Describe differences between on-demand delivery and cloud deployments * Summarize the pay-as-you-go pricing model 2 - COMPUTE IN THE CLOUD * Describe the benefits of Amazon Elastic Compute Cloud (Amazon EC2) at a basic level * Identify the different Amazon EC2 instance types * Differentiate between the various billing options for Amazon EC2 * Describe the benefits of Amazon EC2 Auto Scaling * Summarize the benefits of Elastic Load Balancing * Give an example of the uses for Elastic Load Balancing * Summarize the differences between Amazon Simple Notification Service (Amazon SNS) and Amazon Simple Queue Services (Amazon SQS) * Summarize additional AWS compute options 3 - GLOBAL INFRASTRUCTURE AND RELIABILITY * Summarize the benefits of the AWS Global Infrastructure * Describe the basic concept of Availability Zones * Describe the benefits of Amazon CloudFront and Edge locations * Compare different methods for provisioning AWS services 4 - NETWORKING * Describe the basic concepts of networking * Describe the difference between public and private networking resources * Explain a virtual private gateway using a real life scenario * Explain a virtual private network (VPN) using a real life scenario * Describe the benefit of AWS Direct Connect * Describe the benefit of hybrid deployments * Describe the layers of security used in an IT strategy * Describe which services are used to interact with the AWS global network 5 - STORAGE AND DATABASES * Summarize the basic concept of storage and databases * Describe benefits of Amazon Elastic Block Store (Amazon EBS) * Describe benefits of Amazon Simple Storage Service (Amazon S3) * Describe the benefits of Amazon Elastic File System (Amazon EFS) * Summarize various storage solutions * Describe the benefits of Amazon Relational Database Service (Amazon RDS) * Describe the benefits of Amazon DynamoDB * Summarize various database services 6 - SECURITY * Explain the benefits of the shared responsibility model * Describe multi-factor authentication (MFA) * Differentiate between the AWS Identity and Access Management (IAM) security levels * Describe security policies at a basic level * Explain the benefits of AWS Organizations * Summarize the benefits of compliance with AWS * Explain primary AWS security services at a basic level 7 - MONITORING AND ANALYTICS * Summarize approaches to monitoring your AWS environment * Describe the benefits of Amazon CloudWatch * Describe the benefits of AWS CloudTrail * Describe the benefits of AWS Trusted Advisor 8 - PRICING AND SUPPORT * Understand AWS pricing and support models * Describe the AWS Free Tier * Describe key benefits of AWS Organizations and consolidated billing * Explain the benefits of AWS Budgets * Explain the benefits of AWS Cost Explorer * Explain the primary benefits of the AWS Pricing Calculator * Distinguish between the various AWS Support Plans * Describe the benefits of AWS Marketplace 9 - MIGRATION AND INNOVATION * Understand migration and innovation in the AWS Cloud * Summarize the AWS Cloud Adoption Framework (AWS CAF) * Summarize six key factors of a cloud migration strategy * Describe the benefits of various AWS data migration solutions, such as AWS Snowcone, AWS Snowball, and AWS Snowmobile * Summarize the broad scope of innovative solutions that AWS offers * Summarize the five pillars of the AWS Well-Architected Framewor 10 - AWS CERTIFIED CLOUD PRACTITIONER BASICS * Determine resources for preparing for the AWS Certified Cloud Practitioner examination * Describe benefits of becoming AWS Certified

This FREE in-person event is structured to introduce SMEs to a variety of AI tools that are useful for improving business processes.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE * Topic A: Explore Crystal Reports * Topic B: Use Crystal Reports Help * Topic C: Customize Report Settings 2 - WORKING WITH REPORTS * Topic A: Create a Report * Topic B: Modify a Report * Topic C: Display Specific Report Data * Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS * Topic A: Create a Formula * Topic B: Edit a Formula * Topic C: Filter Data by Using a Formula * Topic D: Work with Advanced Formulas and Functions * Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS * Topic A: Create a Parameter Field * Topic B: Use a Range Parameter in a Report * Topic C: Create a Prompt 5 - GROUPING REPORT DATA * Topic A: Group Report Data * Topic B: Modify a Group Report * Topic C: Group by Using Parameters * Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT * Topic A: Format a Report * Topic B: Insert Objects in a Report * Topic C: Suppress Report Sections * Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA * Topic A: Create a Report Based on Excel Data * Topic B: Modify a Report Generated from Excel Data * Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA * Topic A: Export Data * Topic B: Create Mailing Labels 9 - APPENDIX * Appendix A: Setting Up and Configuring Data Sources * Appendix B: Using Report Processing Techniques * Appendix C: Using Functions in Formulas

This Python BootCamp is Instructor-led, Practical. In the12-week Python course, learn start to in-depth, leading to a good Python career. -------------------------------------------------------------------------------- PYTHON BOOTCAMP: This 12-week Python Boot Camp is a practical, instructor-lead program, covering Python from start to in-depth. You will be fully fluent and confident as a Python programmer. If you have more questions goto https://pcworkshopslondon.co.uk/contact.html  [http://pcworkshopslondon.co.uk/contact.html], Or contact us on training@pcworkshopslondon.co.uk [https://pcworkshopslondon.co.uk/] Customise dates, course outline, arrange installments [https://pcworkshopslondon.co.uk/contact.htm] This course will give you enough practical experience and practical projects to code, to give you full confidence to enter into the coding profession.    Duration: 3 months: * 1 Python class per week, * Plus pratical work, * Plus personal trainer-mentor for 1-1 training, * Plus e-learning materials. Final project : Practical to upload to GitHub and show-case Date and times, choose: * Fridays in London or Online , 10am - 5pm, * or Saturdays in London or Online , 12noon-6pm, * or negotiate your date Study level: Start from beginners level to in-depth, ready to work professionally. Virtual attendance:  online instructor-led  Download: Anaconda.com Pre-requisites: General computer literacy. Oracle Qualification: PCWorkshops Python Programmer Certificate Payments:  You may apply to pay in installments for this Python Training course COURSE OUTLINE Week 1 - 4: Essentials 1. Python Coding Basics 2. Object Oriented programming: Python Object Orientated programming (OOP) 3. UX Principles: UX Principles and applying it on Front-ends with TKinter 4. Specialised topics: Dates, Localization, Strings, Maths Operation , Random Number, Lambdas Week 5 - 10 : All about data 1. Python Data Structures: Lists, Tuples, Sets, Exceptions, I/O Fundamentals , Reading and Writing file 2. Database: Database principles and SQL. Database Project: Python database connections and creating a database driven project 3. Data Analytics: Numpy. Pandas for data analytics and data queries. 4. Data Analytics: Pandas data cleaning and restructuring, interacticting with Excel, Csv, Json,etc. 5. Data visualisation: MatPlotLib 6. Prediction: Machine Learning Basics Week 11 and 12: The final touch 1. Python Concurrency and Multi-threading: Threads vs. Processes, Threading Module, Threading Event, Stop a Thread, Daemon Threads, Thread-safe Queue, Thread Pools, Locks 2. Python Unit Testing 3. Optional : Replace Week 11 or 12 with Scraping using Python, ot Tkinter Front-ends INCLUDED: * PCWorkshops Python Course Certificate on completion. * Python Course notes. * Practical Course exercises, Code Examples, Online Materials. * After the course, continuous assistance with practical and preparation for exams * Max group size on this is 4. * Portfolio: Post your Python project online. * Exam preparation and interview questions MORE ABOUT THE ONLINE CLASSROOM *  Attend from your internet connection *  Instructor-led, get instant answers to your questions *  Fully interactive *  Work clearly explained with demonstrations and examples *  Practical exercises to be tried out by delegate WHAT YOU WILL GAIN: * Skills & knowledge: Python coding knowledge and understanding with good practical application   * Certification: Internal PCWorkshops Python certificate * Portfolio: You will have an online portfolio of Python projects  * Experience: Our comprehensive practical makes you job ready -------------------------------------------------------------------------------- REFUND POLICY No Refunds

Learn how to create and manage a successful YouTube channel for your business. This workshop will cover everything you need to know when setting up and using YouTube in your business. You will also learn how to use YouTube analytics to track your channel's performance to help you make improvements.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE * Two Approaches to SQL Programming * TSQL Data Retrieval in an Analytics / Business Intelligence Environment * The Database Engine * SQL Server Management Studio and the CarDeal Sample Database * Identifying Variables in Tables * SQL is a Declarative Language * Introduction to the SELECT Query * Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY * Turning Columns into Variables for Analysis * Column Expressions, Data Types, and Built-in Functions * Column aliases * Data type conversions * Built-in Scalar Functions * Table Aliases * The WHERE clause * ORDER BY * Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS * Primary Keys, Foreign Keys, and Joins * Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product * Understanding Joins, Part 2: The INNER JOIN * Understanding Joins, Part 3: The OUTER JOINS * Understanding Joins, Part 4: Joining more than two tables * Understanding Joins, Part 5: Combining INNER and OUTER JOINs * Combining JOIN Operations with WHERE and ORDER BY * Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY * Identifying required aggregation level and granularity * Aggregate Functions * GROUP BY * HAVING * Order of operations in SELECT queries * Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS * Non-correlated and correlated subqueries * Derived tables * Common table expressions * Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC * Views * Table-valued functions * Stored procedures * Creating objects for read-access users * Creating database accounts for analytical client tools * Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT * Connecting to SQL Server and Submitting Queries from Client Tools * Connecting and running SELECT queries from: * Excel * PowerBI * RStudio * Exporting datasets to files using * Results pane from SSMS * The bcp utility * The Import/Export Wizard * Lab 1: Getting Your Dataset to the Client ADDITIONAL COURSE DETAILS: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55232 Writing Analytical Queries for Business Intelligence course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 4 Days 24 CPD hours This course is intended for This course is for Azure Administrators. The Azure Administrator implements, manages, and monitors identity, governance, storage, compute, and virtual networks in a cloud environment. The Azure Administrator will provision, size, monitor, and adjust resources as appropriate. This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution. Prerequisites Successful Azure Administrators start this role with experience in virtualization, networking, identity, and storage. Understanding of on-premises virtualization technologies, including: VMs, virtual networking, and virtual hard disks. Understanding of network configurations, including TCP/IP, Domain Name System (DNS), virtual private networks (VPNs), firewalls, and encryption technologies. Understanding of Active Directory concepts, including users, groups, and role-based access control. Understanding of resilience and disaster recovery, including backup and restore operations. 1 - CONFIGURE MICROSOFT ENTRA ID * Describe Microsoft Entra ID benefits and features * Describe Microsoft Entra concepts * Compare Active Directory Domain Services to Microsoft Entra ID * Select Microsoft Entra editions * Implement Microsoft Entra join * Implement Microsoft Entra self-service password reset 2 - CONFIGURE USER AND GROUP ACCOUNTS * Create user accounts * Manage user accounts * Create bulk user accounts * Create group accounts * Create administrative units 3 - CONFIGURE SUBSCRIPTIONS * Identify Azure regions * Implement Azure subscriptions * Obtain an Azure subscription * Identify Azure subscription usage * Implement Microsoft Cost Management * Apply resource tagging * Apply cost savings 4 - CONFIGURE AZURE POLICY * Create management groups * Implement Azure policies * Create Azure policies * Create policy definitions * Create an initiative definition * Scope the initiative definition * Determine compliance 5 - CONFIGURE ROLE-BASED ACCESS CONTROL * Implement role-based access control * Create a role definition * Create a role assignment * Compare Azure roles to Microsoft Entra roles * Apply role-based access control * Review fundamental Azure RBAC roles 6 - CONFIGURE AZURE RESOURCES WITH TOOLS * Use the Azure portal * Use Azure Cloud Shell * Use Azure PowerShell * Use Azure CLI 7 - USE AZURE RESOURCE MANAGER * Review Azure Resource Manager benefits * Review Azure resource terminology * Create resource groups * Create Azure Resource Manager locks * Reorganize Azure resources * Remove resources and resource groups * Determine resource limits 8 - CONFIGURE RESOURCES WITH AZURE RESOURCE MANAGER TEMPLATES * Review Azure Resource Manager template advantages * Explore the Azure Resource Manager template schema * Explore the Azure Resource Manager template parameters * Consider Bicep templates * Review QuickStart templates 9 - CONFIGURE VIRTUAL NETWORKS * Plan virtual networks * Create subnets * Create virtual networks * Plan IP addressing * Create public IP addressing * Associate public IP addresses * Allocate or assign private IP addresses 10 - CONFIGURE NETWORK SECURITY GROUPS * Implement network security groups * Determine network security group rules * Determine network security group effective rules * Create network security group rules * Implement application security groups 11 - CONFIGURE AZURE DNS * Identify domains and custom domains * Verify custom domain names * Create Azure DNS zones * Delegate DNS domains * Add DNS record sets * Plan for Azure Private DNS zones * Review Azure Private DNS zone scenarios 12 - CONFIGURE AZURE VIRTUAL NETWORK PEERING * Determine Azure Virtual Network peering uses * Determine gateway transit and connectivity * Create virtual network peering * Extend peering with user-defined routes and service chaining 13 - CONFIGURE NETWORK ROUTING AND ENDPOINTS * Review system routes * Identify user-defined routes * Determine service endpoint uses * Determine service endpoint services * Identify private link uses 14 - CONFIGURE AZURE LOAD BALANCER * Determine Azure Load Balancer uses * Implement a public load balancer * Implement an internal load balancer * Determine load balancer SKUs * Create back-end pools * Create health probes * Create load balancer rules 15 - CONFIGURE AZURE APPLICATION GATEWAY * Implement Azure Application Gateway * Determine Azure Application Gateway routing * Configure Azure Application Gateway components 16 - CONFIGURE STORAGE ACCOUNTS * Implement Azure Storage * Explore Azure Storage services * Determine storage account types * Determine replication strategies * Access storage * Secure storage endpoints 17 - CONFIGURE AZURE BLOB STORAGE * Implement Azure Blob Storage * Create blob containers * Assign blob access tiers * Add blob lifecycle management rules * Determine blob object replication * Upload blobs * Determine Blob Storage pricing 18 - CONFIGURE AZURE STORAGE SECURITY * Review Azure Storage security strategies * Create shared access signatures * Identify URI and SAS parameters * Determine Azure Storage encryption * Create customer-managed keys * Apply Azure Storage security best practices 19 - CONFIGURE AZURE FILES AND AZURE FILE SYNC * Compare storage for file shares and blob data * Manage Azure file shares * Create file share snapshots * Implement Azure File Sync * Identify Azure File Sync components * Deploy Azure File Sync 20 - CONFIGURE AZURE STORAGE WITH TOOLS * Use Azure Storage Explorer * Use the Azure Import/Export service * Use the WAImportExport tool * Use the AzCopy tool 21 - CONFIGURE VIRTUAL MACHINES * Review cloud services responsibilities * Plan virtual machines * Determine virtual machine sizing * Determine virtual machine storage * Create virtual machines in the Azure portal * Connect to virtual machines 22 - CONFIGURE VIRTUAL MACHINE AVAILABILITY * Plan for maintenance and downtime * Create availability sets * Review update domains and fault domains * Review availability zones * Compare vertical and horizontal scaling * Implement Azure Virtual Machine Scale Sets * Create Virtual Machine Scale Sets * Implement autoscale * Configure autoscale 23 - CONFIGURE AZURE APP SERVICE PLANS * Implement Azure App Service plans * Determine Azure App Service plan pricing * Scale up and scale out Azure App Service * Configure Azure App Service autoscale 24 - CONFIGURE AZURE APP SERVICE * Implement Azure App Service * Create an app with App Service * Explore continuous integration and deployment * Create deployment slots * Add deployment slots * Secure your App Service app * Create custom domain names * Back up and restore your App Service app * Use Azure Application Insights 25 - CONFIGURE AZURE CONTAINER INSTANCES * Compare containers to virtual machines * Review Azure Container Instances * Implement container groups * Review the Docker platform 26 - CONFIGURE FILE AND FOLDER BACKUPS * Describe Azure Backup benefits * Implement Backup Center for Azure Backup * Configure Azure Recovery Services vault backup options * Use the Microsoft Azure Recovery Services (MARS) agent * Configure on-premises file and folder backups 27 - CONFIGURE VIRTUAL MACHINE BACKUPS * Explore options to protect virtual machine data * Create virtual machine snapshots in Azure Backup * Set up Azure Recovery Services vault backup options * Back up your virtual machines * Restore your virtual machines * Implement System Center DPM and Azure Backup Server * Compare the MARS agent and Azure Backup Server * Implement soft delete for your virtual machines * Implement Azure Site Recovery 28 - CONFIGURE AZURE MONITOR * Describe Azure Monitor key capabilities * Describe Azure Monitor components * Define metrics and logs * Identify monitoring data and tiers * Describe activity log events * Query the activity log 29 - CONFIGURE AZURE ALERTS * Describe Azure Monitor alerts * Manage Azure Monitor alerts * Create alert rules * Create action groups 30 - CONFIGURE LOG ANALYTICS * Determine Log Analytics uses * Create a Log Analytics workspace * Create Kusto (KQL) queries * Structure Log Analytics queries 31 - CONFIGURE NETWORK WATCHER * Describe Azure Network Watcher features * Review IP flow verify diagnostics * Review next hop diagnostics * Visualize the network topology

Duration 2 Days 12 CPD hours This course is intended for This course is intended for business users who have been using Power BI to build analytic solutions and are ready to take advantage of the power and flexibility that DAX provides. Learning DAX is a very common 'next step' for experienced Power BI users. Overview At course completion, you should be able to describe DAX syntax, data types, and errors use DAX to create calculated columns, measures, and tables explain how DAX calculations are evaluated, along with the differences between row context and filter context configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc. create calculated columns and measures that use data from multiple tables in the data model write measures that handle error conditions gracefully use DAX to enhance the Power BI user experience use DAX Studio to connect to a Power BI data model and execute simple queries Welcome to Introduction to DAX for Power BI. This two-day instructor-led course is intended for business users who have been using Power BI and want to use DAX to create custom calculations in their data models. In this class, you will be introduced to using Data Analysis Expressions (DAX), which is the expression language that is used to create custom calculations in the Power BI Data model. The course covers some of the theoretical underpinnings of the data model and the DAX language, but the emphasis is on using DAX to solve common business problems. You will learn how to write your own calculated columns, measures, and tables, how to visualize the way Power BI computes DAX calculations, and how to troubleshoot custom code. MODULE 1: GETTING STARTED WITH DAX * INTRODUCTION TODAX * CREATING OBJECTS WITHDAX * CONTEXT AND RULES OF EVALUATION * VARIABLES,COMMENTS,AND TESTING MODULE 2: PERFORMING BASIC CALCULATIONS * GETTING STARTED * IMPLICIT MEASURES * ADDING QUICK MEASURES * WORKING WITH DAX DATA TYPES . * DOING BASIC MATH * USING LOGIC IN YOUR CALCULATIONS * USING THE IF() FUNCTION * NESTED IF() * USING THE SWITCH() FUNCTION * ADVANCED SWITCH() * LOGICAL OPERATORS & FUNCTIONS: ||, OR(), &&, AND(), NOT() * AGGREGATING AND SUMMARIZING DATA * THE SUM() FUNCTION MODULE 3: WORKING WITH CONTEXT IN THE DATA MODEL * CONTEXT DEFINED * DATA MODELING BASICS * INTRODUCTION TO DIMENSIONAL MODELING * RELATIONSHIPS AND THEIR EFFECT ON THE EVALUATION CONTEXT * GETTING DATA FROM OTHER TABLES USING RELATED() AND RELATEDTABLE * LOOKING UP DATA WITHOUT USING RELATIONSHIPS * MODIFYING THE CONTEXT USING CALCULATE() MODULE 4: PERFORMING MORE ADVANCED CALCULATIONS * THE DAX ITERATOR FUNCTIONS * USING TABLE MANIPULATION FUNCTIONS MODULE 5: WORKING WITH TIME * PERFORMING DATE CALCULATIONS * WORKING WITH DATE TABLES * GENERATING A DATE TABLE WITH THE CALENDAR() FUNCTION * DEFINING CUSTOM OPERATING PERIODS * YTD, QTD, AND MTD CALCULATIONS * CUSTOM TO-DATE CALCULATIONS * FINDING YEAR-OVER-YEAR CHANGE * FINDING MOVING AVERAGES MODULE 6: ENHANCING THE USER EXPERIENCE * CONTROLLING VISIBILITYOF YOUR MEASURES * USING WHAT-IF PARAMETERS * ADDING BANDING * USING DAX TO PROVIDE ROW-LEVEL SECURITY