1077 Courses delivered Online

OVERVIEW This official Microsoft Power BI training course will teach you how to connect to data from many sources, clean and transform it using Power Query, create a data model consisting of multiple tables connected with relationships and build visualisations and reports to show the patterns in the data. The course will explore formulas created using the DAX language, including the use of advanced date intelligence calculations. Additional visualisation features including interactivity between the elements of a report page are covered as well as parameters and row-level security, which allows a report to be tailored according to who is viewing it. The course will also show how to publish reports and dashboards to a workspace on the Power BI Service. COURSE BENEFITS: Learn how to clean, transform, and load data from many sources Use database queries in Power Query to combine tables using append and merge Create and manage a data model in Power BI consisting of multiple tables connected with relationships Build Measures and other calculations in the DAX language to plot in reports Manage advanced time calculations using date tables Optimise report calculations using the Performance Analyzer Manage and share report assets to the Power BI Service Prepare for the official Microsoft PL-300 exam using Microsoft Official Courseware WHO IS THE COURSE FOR? Data Analysts with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Management Consultants who need to conduct rapid analysis of their clients’ data to answer specific business questions Analysts who need to upgrade their organisation from a simple Excel or SQL-based management reporting system to a dynamic BI system Data Analysts who wish to develop organisation-wide reporting in the form of web reports or phone apps Marketers in data-intensive organisations who wish to build visually appealing, dynamic charts for their stakeholders to use COURSE OUTLINE Module 1 Getting Started With Microsoft Data Analytics Data analytics and Microsoft Getting Started with Power BI Module 2 Get Data In Power BI Get data from various data sources Optimize performance Resolve data errors Lab: Prepare Data in Power BI Desktop Module 3 Clean, Transform And Load Data In Power BI Data shaping Data profiling Enhance the data structure Lab: Load Data in Power BI Desktop Module 4 Design A Data Model In Power BI Introduction to data modelling Working with Tables Dimensions and Hierarchies Lab: Model Data in Power BI Desktop Module 5 Create Model Calculations Using DAX In Power BI Introduction to DAX Real-time Dashboards Advanced DAX Lab 1: Create DAX Calculations in Power BI Desktop, Part 1 Lab 2: Create DAX Calculations in Power BI Desktop, Part 2 Module 6 Optimize Model Performance Optimize the data model for performance Optimize DirectQuery models Module 7 Create Reports Design a Report Enhance the Report Lab 1: Design a Report in Power BI Desktop, Part 1 Lab 2: Design a Report in Power BI Desktop, Part 2 Module 8 Create Dashboards Create a Dashboard Real-time Dashboards Enhance a Dashboard Lab: Create a Power BI Dashboard Module 9 Perform Advanced Analytics Advanced analytics Data Insights through AI Visuals Lab: Perform Data Analysis in Power BI Desktop Module 10 Create And Manage Workspaces Creating Workspaces Sharing and managing assets Module 11 Manage Datasets In Power BI Parameters Datasets Module 12 Row-Level Security Security in Power BI Lab: Enforce Row-Level Security

Duration 2 Days 12 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients. Overview In this course, you will analyze data with Microsoft Power BI. You will: Analyze data with self-service BI. Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Enhance data analysis by adding and customizing visual elements. Model data with calculations. Create interactive visualizations. As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of 'big data' is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Microsoft© Power BI© software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. Analyzing Data with Self-Service BI Topic A: Data Analysis and Visualization for Business Intelligence Topic B: Self-Service BI with Microsoft Power BI Connecting to Data Sources Topic A: Create Data Connections Topic B: Configure and Manage Data Relationships Topic C: Save Files in Power BI Performing Data Cleaning, Profiling, and Shaping Topic A: Clean, Transform, and Load Data with the Query Editor Topic B: Profile Data with the Query Editor Topic C: Shape Data with the Query Editor Topic D: Combine and Manage Data Rows Visualizing Data with Power BI Topic A: Create Visualizations in Power BI Topic B: Chart Data in Power BI Enhancing Data Analysis Topic A: Customize Visuals and Pages Topic B: Incorporate Tooltips Modeling Data with Calculations Topic A: Create Calculations with Data Analysis Expressions (DAX) Topic B: Create Calculated Measures and Conditional Columns Creating Interactive Visualizations Topic A: Create and Manage Data Hierarchies Topic B: Filter and Slice Reports Topic C: Create Dashboards Additional course details: Nexus Humans Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.3) 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 Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.3) 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.

This course teaches the fundamental concepts of DAX in Power BI. If you have the questions: How do I learn DAX? What is the best way to learn DAX fast?-then this is the best course for you. This course teaches fundamental concepts and does not cover visualization or various advanced DAX patterns for specific questions.

Course Overview: According to the World Economic Forum, data analysts will be among the most in-demand professions by 2025. This Basic Google Data Studio course takes you on an enlightening journey, illuminating the intricate world of Google Data Studio from the ground up.The Basic Google Data Studio course is your stepping stone into data visualisation, geo-visualization, and in-depth socio-economic analysis. With four comprehensive modules, this curriculum is crafted to impart the foundational principles and techniques of Google Data Studio, ensuring learners possess the proficiency to translate raw data into meaningful insights.Enrol Today and Start Learning! Key Features of the Course: The Basic Google Data Studio course boasts an array of appealing features, including a CPD certificate upon completion, marking your journey into mastering Google Data Studio. 24/7 Learning Assistance ensures you can absorb the course material at your own pace, whenever it suits you best. Expect exciting learning materials that make mastering data visualisation a stimulating and enjoyable endeavour. Who is This Course For? This Basic Google Data Studio course is designed for anyone inclined towards data and interested in visual storytelling. Whether you're a business owner looking to make informed decisions, a student eyeing a future in data analysis, or a data enthusiast, this course could be the perfect fit. What You Will Learn: Introduction to Google Data Studio and its features. Navigation and interface overview of Google Data Studio. Creating reports using different data sources. Converting data into visually appealing graphs and charts. Exploring geographic data visualisation techniques. Uncovering hidden geographic trends through data visualisation. Applying the learned skills to real-world socio-economic case studies. Why Enrol in This Course: This Basic Google Data Studio course consistently receives top reviews from its participants. Recently updated with the latest trends and practices in data visualisation, this course ensures you stay on top of industry shifts. By enrolling in this course, you will develop indispensable skills in data analysis and visual storytelling. Requirements: This course requires a fundamental understanding of data analysis concepts. Internet access is required to practise Google Data Studio and access course materials. Career Path: Upon completing this Basic Google Data Studio course, you can look forward to opportunities in various data-focused professions. Such as Data Analyst Business Intelligence Developer Marketing Analyst SEO Specialist Data Scientist Data Visualisation Specialist Report Analyst In the UK, these roles offer attractive salary packages ranging from £25,000 for entry-level positions to over £60,000+ for more advanced roles. Certification: Upon successful completion of the Basic Google Data Studio course, you will be awarded a CPD certificate as proof of your proficiency in Google Data Studio. Course Curriculum 1 sections • 4 lectures • 02:41:00 total length •Module 01: Introduction to GDS: 00:36:00 •Module 02: Data Visualization: 01:29:00 •Module 03: Geo-visualization: 00:16:00 •Module 04: A Socio-Economic Case Study: 00:20:00

Thinking about learning more understanding the role of data within an organisation? As data becomes an important currency in the world and an enabler for the future, it is imperative that all organisations have a firm understanding of the data available to them and the power it can hold. The BCS Foundation Award in Understanding Data in your Organisation teaches the the terminology, principles, concepts and approaches used within data management, and the overall value of data to an organisation.

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

The course is crafted to help you understand not only the role and impact of recommender systems in real-world applications but also provide hands-on experience in developing complete recommender systems engines for your customized dataset using projects. This learning-by-doing course will help you master the concepts and methodology of Python.

Welcome to the data manipulation in Python course. Our goal in this course is to provide you with all the tools and skills necessary to master Python, NumPy, and Pandas for data science. No previous skills or expertise are required. Only a drive to succeed!

This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.

Excel Data Analysis Course Overview The Excel Data Analysis course is designed to equip learners with the essential skills needed to analyse and interpret data using Microsoft Excel. This course covers a range of tools and techniques that are vital for processing, summarising, and visualising data. Learners will explore functions, pivot tables, charts, and data manipulation strategies that will enable them to work efficiently with data sets. By the end of the course, learners will be able to transform raw data into meaningful insights, making it an invaluable skill for professionals across various industries. Whether you're looking to improve your data skills or progress in your career, this course offers the foundational knowledge required for data analysis in Excel. Course Description This course delves into the core aspects of Excel Data Analysis, starting with basic functions and advancing to complex data manipulation techniques. Learners will explore how to create and manage pivot tables, perform data filtering, and apply functions such as VLOOKUP and INDEX MATCH. Visualisation tools like charts and graphs will be covered, enabling learners to present their findings in a clear and impactful way. Additionally, learners will be introduced to data modelling, conditional formatting, and advanced formula techniques that will enhance their data analysis capabilities. The course is structured to provide a comprehensive understanding of Excel’s data analysis features, building competency for a wide range of practical applications in both personal and professional settings. Excel Data Analysis Curriculum Module 01: Introduction to Excel for Data Analysis Module 02: Using Excel Functions for Data Manipulation Module 03: Working with Pivot Tables and Pivot Charts Module 04: Data Visualisation: Creating Charts and Graphs Module 05: Advanced Excel Functions for Complex Data Analysis Module 06: Data Filtering and Sorting Techniques Module 07: Conditional Formatting for Data Insights Module 08: Introduction to Data Modelling and Forecasting Module 09: Data Analysis Best Practices and Case Studies (See full curriculum) Who is this course for? Individuals seeking to enhance their data analysis skills. Professionals aiming to advance in data-centric roles. Beginners with an interest in data analysis and Excel. Anyone looking to improve their Excel knowledge for career development. Career Path Data Analyst Business Analyst Financial Analyst Marketing Analyst Operations Manager Administrative Assistant Project Manager Research and Development Analyst