31 Row courses in Edinburgh

Duration 3 Days 18 CPD hours This course is intended for The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises. This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Prerequisites Understanding core data concepts. Knowledge of working with relational data in the cloud. Knowledge of working with non-relational data in the cloud. Knowledge of data analysis and visualization concepts. DP-900T00 Microsoft Azure Data Fundamentals is recommended 1 - Discover data analysis Overview of data analysis Roles in data Tasks of a data analyst 2 - Get started building with Power BI Use Power BI Building blocks of Power BI Tour and use the Power BI service 3 - Get data in Power BI Get data from files Get data from relational data sources Create dynamic reports with parameters Get data from a NoSQL database Get data from online services Select a storage mode Get data from Azure Analysis Services Fix performance issues Resolve data import errors 4 - Clean, transform, and load data in Power BI Shape the initial data Simplify the data structure Evaluate and change column data types Combine multiple tables into a single table Profile data in Power BI Use Advanced Editor to modify M code 5 - Design a semantic model in Power BI Work with tables Create a date table Work with dimensions Define data granularity Work with relationships and cardinality Resolve modeling challenges 6 - Add measures to Power BI Desktop models Create simple measures Create compound measures Create quick measures Compare calculated columns with measures 7 - Add calculated tables and columns to Power BI Desktop models Create calculated columns Learn about row context Choose a technique to add a column 8 - Use DAX time intelligence functions in Power BI Desktop models Use DAX time intelligence functions Additional time intelligence calculations 9 - Optimize a model for performance in Power BI Review performance of measures, relationships, and visuals Use variables to improve performance and troubleshooting Reduce cardinality Optimize DirectQuery models with table level storage Create and manage aggregations 10 - Design Power BI reports Design the analytical report layout Design visually appealing reports Report objects Select report visuals Select report visuals to suit the report layout Format and configure visualizations Work with key performance indicators 11 - Configure Power BI report filters Apply filters to the report structure Apply filters with slicers Design reports with advanced filtering techniques Consumption-time filtering Select report filter techniques Case study - Configure report filters based on feedback 12 - Enhance Power BI report designs for the user experience Design reports to show details Design reports to highlight values Design reports that behave like apps Work with bookmarks Design reports for navigation Work with visual headers Design reports with built-in assistance Tune report performance Optimize reports for mobile use 13 - Perform analytics in Power BI Explore statistical summary Identify outliers with Power BI visuals Group and bin data for analysis Apply clustering techniques Conduct time series analysis Use the Analyze feature Create what-if parameters Use specialized visuals 14 - Create and manage workspaces in Power BI Distribute a report or dashboard Monitor usage and performance Recommend a development life cycle strategy Troubleshoot data by viewing its lineage Configure data protection 15 - Manage semantic models in Power BI Use a Power BI gateway to connect to on-premises data sources Configure a semantic model scheduled refresh Configure incremental refresh settings Manage and promote semantic models Troubleshoot service connectivity Boost performance with query caching (Premium) 16 - Create dashboards in Power BI Configure data alerts Explore data by asking questions Review Quick insights Add a dashboard theme Pin a live report page to a dashboard Configure a real-time dashboard Set mobile view 17 - Implement row-level security Configure row-level security with the static method Configure row-level security with the dynamic method Additional course details: Nexus Humans PL-300T00: Microsoft Power BI Data Analyst 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 PL-300T00: Microsoft Power BI Data Analyst 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 Looking for a way to extend your business operations? Look no further than the App in a Day workshop! In this one day course you will learn to build a custom, secure business application that you can share across your organise and will run across multiple platforms including tablets and mobile devices. Power Platform is a secure and scalable platform for building your own applications. In this course, you will learn how to build an application from the ground up by building the required UX, Backend, and frontend. All this without writing any code. Overview Some of the applications of the Power Platform you will learn to build will allow you to potentially: A) Share information with trusted colleagues and associates B) Monitor and manage your business operations C) Monitor and manage your customers D) Share business news on social media E) Share business photos and footage This course will teach you how to build your own application that is completely secure and private. Power Apps Canvas App Connect to data sources and filter results based on specified criteria Work with screens and navigation Use controls, properties, formulas, and actions to customize the user experience Display the logged in user?s name Configure app settings Save and share an app Run an app on a mobile device Microsoft Dataverse Create and customize a custom table Use the Form control Save data into the Microsoft Dataverse using the Form control Microsoft Dataverse Create a standalone Model-driven app. Customize forms for the Model-driven app Use a Business Process Flow to guide users through a process Microsoft Dataverse Create a flow that is triggered when a new Microsoft Dataverse row is created Automate sending approval requests Customize the approval based on the Microsoft Dataverse row Use the Approval centre

Bring Your Data To Life | Designed by Industry Specialist | Level 7 | QLS Endorsed Diploma | Certificate Included

Left-handed crochet is notoriously difficult to master, this workshop is suitable for complete beginners, and will help you master this amaxing craft.

Are you someone wishing to learn the skills to analyze data professionally using Power BI? Do you want to learn to create impressive reports? Then this is the right course for you! Learn the complete workflow in Power BI from A-to-Z and advanced analytics with DAX-calculated columns and measures, forecasting, and advanced analytics.

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

This workshop is suitable for complete beginners, or anyone who has crocheted in the past but has forgotten the basics.

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

Students who complete PV202 will be able to: Define the purpose of the National Electrical Code (NEC®) and NEC® terminology for PV equipment Determine procedures for proper installation of equipment and conductors, including minimum requirements for working space Examine methods for PV wire management and determine where expansion fittings are required Describe and identify electrical services, including split-phase and three-phase Wye (Y) and Delta (∆) Evaluate electrical service details to collect and record during solar site evaluation Identify options for NEC®-compliant PV system interconnection to the utility grid and determine whether a supply side, load side, or additional service connection is appropriate Identify code-compliant methods for connecting an inverter to an existing AC feeder Calculate PV module voltage based on temperature to ensure compatibility with system components and NEC® Section 690.7, and explore other options for maximum PV system DC voltage calculations Identify NEC® requirements and sizing of disconnects and overcurrent protection devices (OCPDs) in grid-direct PV systems Define inverter grounding configurations Evaluate inverter choices and system configurations, including string inverters, central inverters, and module level power electronics (MLPE) Identify requirements for equipment grounding, equipment grounding conductors (EGC), and grounding electrode conductors (GEC), and size the conductors according to the NEC® Identify common causes of ground-faults and arc-faults Describe ground-fault and arc-fault protection devices Describe benefits and appropriate locations of surge protection devices (SPD) Demonstrate the use of sun charts and perform calculations to determine row spacing and minimize inter-row shading Identify how Codes detailing access for first responders impact PV array roof layout Examine fire classifications that affect racking and module selection Detail NEC rapid shutdown requirements and options for implementation Identify load and structural considerations for low- and steep-slope roof-mounted PV systems Calculate wind uplift force and select appropriate lag bolts Review issues related to planning, design, and installation of ground-mount PV arrays Review PV system circuit terminology, definitions, and conductor types Calculate minimum overcurrent protection device (OCPD) size and conductor ampacity using appropriate adjustment and correction factors Calculate voltage drop and verify system operation within acceptable limits Examine requirements for PV system labeling Calculate the maximum and minimum number of modules per PV source circuit, and number of PV source circuits per inverter Determine size of residential grid-direct PV system based on site and customer-specific considerations including the number and wiring layout of modules, conductor and OCPD sizes, and the AC interconnections Determine the size of a large, multiple inverter, grid-direct PV system based on site and customer-specific considerations, including the quantity and layout of modules and inverters and the AC interconnection Define large-scale PV and review associated NEC® allowances and requirements Describe importance of Data Acquisition Systems (DAS) Identify common DAS equipment and hardware Review DAS design, installation, and commissioning processes and common problems associated with DAS Show how reports can be generated and utilized to remotely assess health of system

Students who complete PVOL202 will be able to: Define the purpose of the National Electrical Code (NEC®) and NEC® terminology for PV equipment Determine procedures for proper installation of equipment and conductors, including minimum requirements for working space Examine methods for PV wire management and determine where expansion fittings are required Describe and identify electrical services, including split-phase and three-phase Wye (Y) and Delta (∆) Evaluate electrical service details to collect and record during solar site evaluation Identify options for NEC®-compliant PV system interconnection to the utility grid and determine whether a supply side, load side, or additional service connection is appropriate Identify code-compliant methods for connecting an inverter to an existing AC feeder Calculate PV module voltage based on temperature to ensure compatibility with system components and NEC® Section 690.7, and explore other options for maximum PV system DC voltage calculations Identify NEC® requirements and sizing of disconnects and overcurrent protection devices (OCPDs) in grid-direct PV systems Define inverter grounding configurations Evaluate inverter choices and system configurations, including string inverters, central inverters, and module level power electronics (MLPE) Identify requirements for equipment grounding, equipment grounding conductors (EGC), and grounding electrode conductors (GEC), and size the conductors according to the NEC® Identify common causes of ground-faults and arc-faults Describe ground-fault and arc-fault protection devices Describe benefits and appropriate locations of surge protection devices (SPD) Demonstrate the use of sun charts and perform calculations to determine row spacing and minimize inter-row shading Identify how Codes detailing access for first responders impact PV array roof layout Examine fire classifications that affect racking and module selection Detail NEC rapid shutdown requirements and options for implementation Identify load and structural considerations for low- and steep-slope roof-mounted PV systems Calculate wind uplift force and select appropriate lag bolts Review issues related to planning, design, and installation of ground-mount PV arrays Review PV system circuit terminology, definitions, and conductor types Calculate minimum overcurrent protection device (OCPD) size and conductor ampacity using appropriate adjustment and correction factors Calculate voltage drop and verify system operation within acceptable limits Examine requirements for PV system labeling Calculate the maximum and minimum number of modules per PV source circuit, and number of PV source circuits per inverter Determine size of residential grid-direct PV system based on site and customer-specific considerations including the number and wiring layout of modules, conductor and OCPD sizes, and the AC interconnections Determine the size of a large, multiple inverter, grid-direct PV system based on site and customer-specific considerations, including the quantity and layout of modules and inverters and the AC interconnection Define large-scale PV and review associated NEC® allowances and requirements Describe importance of Data Acquisition Systems (DAS) Identify common DAS equipment and hardware Review DAS design, installation, and commissioning processes and common problems associated with DAS Show how reports can be generated and utilized to remotely assess health of system