312 Business Intelligence (BI) courses

OVERVIEW Prerequisites—this is a day of supervised revision for anyone who wishes to take the PL-300 exam so we expect you to have attended a PL-300 course, either taught or on your own, before attending this day of revision. We are happy for attendees to join the course if you have taken the PL-300 with us or with another provider. In the morning we look at questions from the PL-300 exam, grouped by subject area. For each question we show you the correct answer and then explain why that is the correct answer. After lunch everyone tries a practice exam under exam conditions and we finish the day with clarification on the subjects or specific questions that the class is finding hard. The cost of the course includes a free voucher to take the exam, so please don’t buy your own separately. If you do so we cannot reimburse you with the cost of the exam. COURSE BENEFITS: * Discover the parts of the course on which to focus most attention * Become familiar with the styles and formats of the exam questions * Alert yourself to some of the particularly tricky questions * Familiarise yourself with the style of the 'case study' question * Practice an exam under real exam conditions * Get a feel for the time you need to devote to the normal questions and to the case study WHO IS THE COURSE FOR? * Power BI report developers who need PL-300 Certification to apply for a job * Business Intelligence specialists who wish to enhance their career prospects with a PL-300 Certification * Anyone who wishes to maximise their chances of passing the PL-300 Power BI Data Analyst exam COURSE OUTLINE Module 1 Structure Of The Exam * Registration for the exam and setup of your workspace * The percentage of marks devoted to each subject area * Types of questions used in the exam * Advised timing for the normal questions and for the case study question Module 2 Individual Exam Question Practice * The exam questions are divided into subject areas and for each question… * We consider the question and try to answer it * We view the answer * Where necessary, we look at an in-depth explanation of why that is the correct answer * Examine case study questions and how to treat these differently from the normal questions Module 3 Practice Exam Under Exam Conditions * Attendees take a practice exam * Attendees receive a mark, broken down into subject areas Module 4 Exam Question Practice Focussed On Tricky Areas * Together, based on the results of attendees’ exam results we decide which areas on which to focus * More practice on individual exam questions using the same style as in Module 2

WHAT YOU WILL LEARN FROM THIS COURSE? * Gain comprehensive knowledge about business intelligence * Understand the core competencies and principles of business intelligence * Explore the various areas of business intelligence * Know how to apply the skills you acquired from this course in a real-life context * Become a confident and expert business intelligence analyst COURSE HIGHLIGHTS * Course Type: Self-paced online course * Duration: 1 to 2 hours * Tutor Support: Full tutor support is included * Customer Support: 24/7 customer support is available INTRODUCTION TO BUSINESS INTELLIGENCE (BI) COURSE Master the skills you need to propel your career forward in business intelligence. This course will equip you with the essential knowledge and skillset that will make you a confident business intelligence analyst and take your career to the next level. This comprehensive business intelligence (BI) course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this business intelligence (BI) course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective business intelligence practice and equip you with the essential skills, confidence and competence to assist you in the business intelligence industry. You'll gain a solid understanding of the core competencies required to drive a successful career in business intelligence. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for business intelligence analyst or for people who are aspiring to specialise in business intelligence. Enrol in this business intelligence (BI) course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. WHO IS THIS COURSE FOR? This comprehensive business intelligence (BI) course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this business intelligence can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. ENTRY REQUIREMENTS This business intelligence (BI) course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. ASSESSMENT This business intelligence (BI) course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. ADVANCE YOUR CAREER This business intelligence (BI) course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. STUDY PLEX SUBSCRIPTION Study plex also provides a subscription option that allows you unlimited access to more than 700+ CPD courses for learning. You only need to spend £79 to take advantage of this fantastic offer, and you'll get an unlimited subscription for a full year. Additionally, you can cancel your membership from your account at any time by getting in touch with our friendly and devoted customer care team. Visit our subscriptions page for more details if you're interested. WHY YOU SHOULD TRAIN WITH STUDY PLEX? At Study Plex, you will have the chance to build social, technical and personal skills through a combination of extensive subjects tailored according to your interest. Along with receiving comprehensive knowledge and transferable skills, there are even more reasons o be involved with us, which include: * Incredible Customer Support: We offer active customer service in the form of live chat, which you can access 24/7 * Expert Tutor Support: You'll have access to our devoted and dedicated tutor support with all of our courses whenever you need it. * Price Justified by Quality: We ensure that you will have the best experience possible for the price you are paying for the course. * Money-back Guarantee: We provide a money-back guarantee if you are not satisfied with the course's quality. There is a 14-day time limit on this option (according to the terms and conditions). * Instalment Facility: If your course costs more than £50, you can pay in three instalments using the instalment option. * Satisfaction Guarantee: Our courses are designed to meet your demands and expectations by all means. RECOGNISED ACCREDITATION This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. WHAT IS CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. BENEFITS OF CPD * Improve your employment prospects * Boost your job satisfaction * Promotes career advancement * Enhances your CV * Provides you with a competitive edge in the job market * Demonstrate your dedication * Showcases your professional capabilities WHAT IS IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. BENEFITS OF IPHM * It will help you establish a positive reputation in your chosen field * You can join a network and community of successful therapists that are dedicated to providing excellent care to their client * You can flaunt this accreditation in your CV * It is a worldwide recognised accreditation WHAT IS QUALITY LICENCE SCHEME? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. BENEFITS OF QUALITY LICENSE SCHEME * Certificate is valuable * Provides a competitive edge in your career * It will make your CV stand out COURSE CURRICULUM Introduction Introduction to Business Intelligence (BI) 00:16:00 Business Intelligence (BI) and Analytics 00:05:00 Business Reporting 00:16:00 Business Reporting Cont'd 00:16:00 Business Intelligence (BI) and Analytics 00:05:00 Process Mining 00:13:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Supplementary Resources Supplementary Resources - Introduction to Business Intelligence (BI) 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Duration 2 Days 12 CPD hours This course is intended for System administrators Overview Prepare you to perform key administrative tasks in SAP BusinessObjects Business Intelligence platform to manage users, groups, and objects, and to distribute contents to users. In this course, students perform key administrative tasks in SAP BusinessObjects Business Intelligence platform to manage users, groups, and objects, and to distribute contents to users. SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE (BI) PLATFORM * Identifying the Components of the SAP BusinessObjects Business Intelligence BI Platform CONTENT AND OBJECTS IN THE SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE (BI) PLATFORM * Viewing and Modifying Objects in the BI Platform * Organizing Objects in the BI Platform * Searching for Content in the BI Platform USER AND USER GROUP SECURITY IN THE SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE (BI) PLATFORM * Setting Up Users and Groups * Administering Rights APPLICATION SECURITY IN THE SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE (BI) PLATFORM * Managing Access to Applications * Securing Applications CONTENT DISTRIBUTION USING SCHEDULING AND ALERTING * Scheduling Objects * Managing Instances * Managing Calendars * Managing Events * Configuring Alerts and Alerting PUBLICATIONS AND PUBLISHING * Designing Publications ADDITIONAL COURSE DETAILS: Nexus Humans BOE310 SAP BusinessObjects Business Intelligence Platform - Administration and Security 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 BOE310 SAP BusinessObjects Business Intelligence Platform - Administration and Security 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 This course is designed for professionals in a variety of job roles who receive Power BI data visualizations and reports from data analysts or from data visualization engineers. These data report recipients want to use the features and capabilities of Power BI to fully explore the visualizations and initial analyses provided to them in reports, perform additional analysis to ask next-level questions of the data, and to customize and create new visualizations and dashboards in order to share new insights and create compelling reports. Overview Explore Power BI reports. Analyze data to get answers and insights. Sort and group data for analysis and reporting. Filter visualizations. Prepare reports. Troubleshoot, collaborate, and share reports. As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Microsoft Power BI software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed to business data decision makers. These decision makers can use Power BI's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings. Prerequisites To ensure your success in this course, you have experience managing data with Microsoft Excel or Google Sheets 1. EXPLORING POWER BI REPORTS * Topic A: Data Analysis Workflow with Power BI * Topic B: Explore Reports in the Power BI Service * Topic C: Edit Reports 2. ANALYZING DATA TO GET ANSWERS AND INSIGHTS * Topic A: Configure Data Visualizations * Topic B: Ask New Questions by Changing Aggregation * Topic C: Find Answers with Calculations 3. SORTING AND GROUPING DATA FOR ANALYSIS AND REPORTING * Topic A: Sort Data * Topic B: Group Data 4. FILTERING VISUALIZATIONS * Topic A: Filter Data to Refine Analysis * Topic B: Create Slicers for Reports 5. PREPARING REPORTS * Topic A: Format and Annotate Reports * Topic B: Emphasize Data in Reports 6. TROUBLESHOOTING, SHARING, AND COLLABORATING * Topic A: Troubleshoot Data Issues * Topic B: Collaborate in Power BI * Topic C: Collaborate with Non-Power BI Users

Embark on a journey to become a proficient Business Intelligence Analyst with the comprehensive course 'The Business Intelligence Analyst.' Delve into the world of data-driven decision-making, exploring the core concepts of Business Intelligence (BI), dashboard presentation systems, data mining techniques, and the vital role of data warehouses. Equip yourself with the skills to develop effective KPIs and design impactful dashboards for informed business insights. Learning Outcomes: * Grasp the fundamental concepts of Business Intelligence and its significance in modern enterprises. * Comprehend the decision-making process and the need for IT systems in supporting business choices. * Explore the architecture and components of data warehouses, vital for data organization. * Understand the intricacies of dashboard presentation systems and their varied applications. * Identify different types of charts used in dashboards and their role in data visualization. * Evaluate good dashboard design principles and implement Balanced Scorecard (BSC) strategies. * Learn the basics of data mining, including classification, clustering, and association rules. * Gain insights into real-world data mining applications across industries, such as banking and CRM. WHY BUY THIS THE BUSINESS INTELLIGENCE ANALYST COURSE? * Unlimited access to the course for forever * Digital Certificate, Transcript, student ID all included in the price * Absolutely no hidden fees * Directly receive CPD accredited qualifications after course completion * Receive one to one assistance on every weekday from professionals * Immediately receive the PDF certificate after passing * Receive the original copies of your certificate and transcript on the next working day * Easily learn the skills and knowledge from the comfort of your home CERTIFICATION After studying the course materials of the The Business Intelligence Analyst Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. WHO IS THIS COURSE FOR? This The Business Intelligence Analyst Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.  * Aspiring Business Intelligence Analysts and Data Professionals. * Individuals interested in leveraging data for strategic decision-making. * Managers and Executives seeking to enhance business insights and performance. * IT and Software Professionals exploring the field of Business Intelligence. PREREQUISITES This The Business Intelligence Analyst Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. CAREER PATH * Business Intelligence Analyst - $65,000 to $95,000/year. * Data Analyst - $60,000 to $90,000/year. * Data Scientist - $80,000 to $120,000/year. * BI Consultant - $70,000 to $110,000/year. * Analytics Manager - $90,000 to $130,000/year COURSE CURRICULUM The Business Intelligence Analyst Course Module 01: What is Business Intelligence? 00:05:00 Module 02: Starting Case in understanding BI needs in diff phase of business 00:07:00 Module 03: Decision Making Process and Need of IT systems 00:20:00 Module 04: Problem Structure and Decision Support System 00:11:00 Module 05: Introduction to BI Applications 00:18:00 Module 06: Dashboard presentation systems 00:07:00 Module 07: Different Types of Charts used in 131 Dashboards 00:30:00 Module 08: Good Dashboard and BSC 00:13:00 Module 09: Examples of Bad Dashboards 1 00:07:00 Module 10: Examples of Bad Dashboards 2 00:01:00 Module 11: Process of KPI Development 00:26:00 Module 12: Overview of Data warehouse 00:08:00 Module 13: More explaining of data warehouse and steps in processing 00:09:00 Module 14: Data Warehouse Architecture -Tiers 00:18:00 Module 15: Data Warehouse - components 00:15:00 Module 16: Approach to develop data structure and Models of database 00:16:00 Module 17: Basics of Data Mining - Meaning 00:35:00 Module 18: Basics of Data Mining - Stages of DM 00:25:00 Module 19: Data Mining Technique - Classification 00:07:00 Module 20: Data mining - Clustering 00:02:00 Module 21: Data Mining - Association Rules 00:05:00 Module 22: Data Mining Applications - Banking 00:03:00 Module 23: Data Mining Applications - CRM 00:04:00 Module 24: Data Mining Applications - other industries 00:04:00 Assignment Assignment - The Business Intelligence Analyst Course 00:00:00

Unlock the power of data with our Business Intelligence and Data Mining course. Dive into the world of Business Intelligence (BI) and learn how data-driven decisions can revolutionize every aspect of a business. This course takes you through the decision-making process and the essential role of IT systems in today's business landscape. Discover the art of creating effective dashboards and master various chart types that bring data to life. Whether you're a budding entrepreneur, a business professional, or an aspiring data analyst, this course equips you with the knowledge and skills needed to harness the potential of data for strategic decision-making. Learning Outcomes * Understand the fundamentals of Business Intelligence and its critical role in modern business. * Explore the decision-making process and the need for robust IT systems to support it. * Master the art of creating impactful dashboards and understand the principles of Balanced Scorecards (BSC). * Gain expertise in data warehousing and database models. * Delve into the world of Data Mining, from its stages to techniques like classification, clustering, and association rules. WHY CHOOSE THIS BUSINESS INTELLIGENCE AND DATA MINING COURSE? 1. Unlimited access to the course for a lifetime. 2. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. 3. Structured lesson planning in line with industry standards. 4. Immerse yourself in innovative and captivating course materials and activities. 5. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. 6. Flexibility to complete the Course at your own pace, on your own schedule. 7. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. 8. Unlock career resources for CV improvement, interview readiness, and job success. WHO IS THIS BUSINESS INTELLIGENCE AND DATA MINING COURSE FOR? * Aspiring entrepreneurs looking to make data-driven decisions. * Business professionals seeking to enhance their strategic decision-making skills. * Data enthusiasts interested in diving into the world of Business Intelligence. * Students and graduates looking to specialize in data analytics. * Professionals aiming to broaden their understanding of BI and Data Mining. CAREER PATH * Data Analyst: £24,000 - £45,000 * Business Intelligence Analyst: £26,000 - £54,000 * Data Scientist: £29,000 - £70,000 * Database Administrator: £25,000 - £52,000 * Business Analyst: £27,000 - £55,000 * IT Manager: £32,000 - £82,000 * PREREQUISITES This Business Intelligence and Data Mining does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Business Intelligence and Data Mining was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. CERTIFICATION After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. COURSE CURRICULUM Business Intelligence and Data Mining Module 01: What is Business Intelligence? 00:05:00 Module 02: Starting Case in understanding BI needs in diff phase of business 00:07:00 Module 03: Decision Making Process and Need of IT systems 00:20:00 Module 04: Problem Structure and Decision Support System 00:11:00 Module 05: Introduction to BI Applications 00:18:00 Module 06: Dashboard presentation systems 00:07:00 Module 07: Different Types of Charts used in 131 Dashboards 00:30:00 Module 08: Good Dashboard and BSC 00:13:00 Module 09: Examples of Bad Dashboards 1 00:07:00 Module 10: Examples of Bad Dashboards 2 00:01:00 Module 11: Process of KPI Development 00:26:00 Module 12: Overview of Data warehouse 00:08:00 Module 13: More explaining of data warehouse and steps in processing 00:09:00 Module 14: Data Warehouse Architecture -Tiers 00:18:00 Module 15: Data Warehouse - components 00:15:00 Module 16: Approach to develop data structure and Models of database 00:16:00 Module 17: Basics of Data Mining - Meaning 00:35:00 Module 18: Basics of Data Mining - Stages of DM 00:25:00 Module 19: Data Mining Technique - Classification 00:07:00 Module 20: Data mining - Clustering 00:02:00 Module 21: Data Mining - Association Rules 00:05:00 Module 22: Data Mining Applications - Banking 00:03:00 Module 23: Data Mining Applications - CRM 00:04:00 Module 24: Data Mining Applications - other industries 00:04:00 Assignment Assignment - Business Intelligence and Data Mining 00:00:00

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites * Basic understanding of relational databases. * Basic Windows knowledge. MODULE 1: INTRODUCTION TO TRANSACT-SQL * What is Transact-SQL * The SELECT statement * The WHERE clause * Sorting results * Calculations * CASE expressions MODULE 2: JOINING TABLES WITH TRANSACT-SQL * The JOIN clause * Inner joins * Outer joins * Self joins and cross joins MODULE 3: FILTERING AND SORTING RESULTS * Implement the ORDER BY clause * Filter data with the WHERE clause * Limit the number of rows returned by a query * Implement NULL logic MODULE 4: SQL SERVER DATA TYPES * Understand data types * Implement string data types * Implement temporal data types MODULE 5: INSERTING, UPDATING AND DELETING DATA * Insert new records * Update existing records * Delete data MODULE 6: USING SQL SERVER FUNCTIONS WITH TRANSACT-SQL * Understand function types in SQL Server * Convert data using functions * Implement logical functions * Work with NULL data using functions MODULE 7: AGGREGATING DATA WITH TRANSACT-SQL * Implement aggregation in SQL Server * Group records in SQL Server * Filter aggregated data MODULE 8: IMPLEMENT SUBQUERIES WITH TRANSACT-SQL * Implement scalar and multi-valued sub-queries * Implement correlated subqueries * Implement existence checks with subqueries MODULE 9: CREATE QUERIES THAT USE TABLE EXPRESSIONS * Create views * Create table-valued functions * Implement derived tables * Implement common table expressions MODULE 10: USE UNION, INTERSECT, EXCEPT AND APPLY ON MULTIPLE SETS OF DATA * Write queries with the UNION operator * Write queries with the INTERSECT and EXCEPT operators * Write queries with the APPLY operator MODULE 11: IMPLEMENT WINDOW FUNCTIONS IN QUERIES * Understand window functions * Impement window functions MODULE 12: USE PIVOT AND GROUPING SETS IN QUERIES * Implement PIVOT in queries * Implement grouping sets in queries MODULE 13: USE STORED PROCEDURES IN QUERIES * Query data with stored procedures * Interact with stored procedures using input and output parameters * Write simple stored procedures * Pass dynamic SQL to SQL Server MODULE 14: IMPLEMENT PROGRAMMING FEATURES IN TRANSACT-SQL * Understand T-SQL programming elements * Implement loops and conditions in T-SQL queries MODULE 15: ADD ERROR HANDLING TO QUERIES * Understand SQL Server error handling * Implemet structured exception handling MODULE 16: USE TRANSACTIONS IN QUERIES * Understand database transactions * Implement transactions in T-SQL

Duration 4 Days 24 CPD hours This course is intended for The primary audience for this course is data professionals, data architects, and business intelligence professionals who want to learn about data engineering and building analytical solutions using data platform technologies that exist on Microsoft Azure. The secondary audience for this course includes data analysts and data scientists who work with analytical solutions built on Microsoft Azure. In this course, the student will learn how to implement and manage data engineering workloads on Microsoft Azure, using Azure services such as Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure Databricks, and others. The course focuses on common data engineering tasks such as orchestrating data transfer and transformation pipelines, working with data files in a data lake, creating and loading relational data warehouses, capturing and aggregating streams of real-time data, and tracking data assets and lineage. Prerequisites Successful students start this course with knowledge of cloud computing and core data concepts and professional experience with data solutions. AZ-900T00 Microsoft Azure Fundamentals DP-900T00 Microsoft Azure Data Fundamentals 1 - INTRODUCTION TO DATA ENGINEERING ON AZURE * What is data engineering * Important data engineering concepts * Data engineering in Microsoft Azure 2 - INTRODUCTION TO AZURE DATA LAKE STORAGE GEN2 * Understand Azure Data Lake Storage Gen2 * Enable Azure Data Lake Storage Gen2 in Azure Storage * Compare Azure Data Lake Store to Azure Blob storage * Understand the stages for processing big data * Use Azure Data Lake Storage Gen2 in data analytics workloads 3 - INTRODUCTION TO AZURE SYNAPSE ANALYTICS * What is Azure Synapse Analytics * How Azure Synapse Analytics works * When to use Azure Synapse Analytics 4 - USE AZURE SYNAPSE SERVERLESS SQL POOL TO QUERY FILES IN A DATA LAKE * Understand Azure Synapse serverless SQL pool capabilities and use cases * Query files using a serverless SQL pool * Create external database objects 5 - USE AZURE SYNAPSE SERVERLESS SQL POOLS TO TRANSFORM DATA IN A DATA LAKE * Transform data files with the CREATE EXTERNAL TABLE AS SELECT statement * Encapsulate data transformations in a stored procedure * Include a data transformation stored procedure in a pipeline 6 - CREATE A LAKE DATABASE IN AZURE SYNAPSE ANALYTICS * Understand lake database concepts * Explore database templates * Create a lake database * Use a lake database 7 - ANALYZE DATA WITH APACHE SPARK IN AZURE SYNAPSE ANALYTICS * Get to know Apache Spark * Use Spark in Azure Synapse Analytics * Analyze data with Spark * Visualize data with Spark 8 - TRANSFORM DATA WITH SPARK IN AZURE SYNAPSE ANALYTICS * Modify and save dataframes * Partition data files * Transform data with SQL 9 - USE DELTA LAKE IN AZURE SYNAPSE ANALYTICS * Understand Delta Lake * Create Delta Lake tables * Create catalog tables * Use Delta Lake with streaming data * Use Delta Lake in a SQL pool 10 - ANALYZE DATA IN A RELATIONAL DATA WAREHOUSE * Design a data warehouse schema * Create data warehouse tables * Load data warehouse tables * Query a data warehouse 11 - LOAD DATA INTO A RELATIONAL DATA WAREHOUSE * Load staging tables * Load dimension tables * Load time dimension tables * Load slowly changing dimensions * Load fact tables * Perform post load optimization 12 - BUILD A DATA PIPELINE IN AZURE SYNAPSE ANALYTICS * Understand pipelines in Azure Synapse Analytics * Create a pipeline in Azure Synapse Studio * Define data flows * Run a pipeline 13 - USE SPARK NOTEBOOKS IN AN AZURE SYNAPSE PIPELINE * Understand Synapse Notebooks and Pipelines * Use a Synapse notebook activity in a pipeline * Use parameters in a notebook 14 - PLAN HYBRID TRANSACTIONAL AND ANALYTICAL PROCESSING USING AZURE SYNAPSE ANALYTICS * Understand hybrid transactional and analytical processing patterns * Describe Azure Synapse Link 15 - IMPLEMENT AZURE SYNAPSE LINK WITH AZURE COSMOS DB * Enable Cosmos DB account to use Azure Synapse Link * Create an analytical store enabled container * Create a linked service for Cosmos DB * Query Cosmos DB data with Spark * Query Cosmos DB with Synapse SQL 16 - IMPLEMENT AZURE SYNAPSE LINK FOR SQL * What is Azure Synapse Link for SQL? * Configure Azure Synapse Link for Azure SQL Database * Configure Azure Synapse Link for SQL Server 2022 17 - GET STARTED WITH AZURE STREAM ANALYTICS * Understand data streams * Understand event processing * Understand window functions 18 - INGEST STREAMING DATA USING AZURE STREAM ANALYTICS AND AZURE SYNAPSE ANALYTICS * Stream ingestion scenarios * Configure inputs and outputs * Define a query to select, filter, and aggregate data * Run a job to ingest data 19 - VISUALIZE REAL-TIME DATA WITH AZURE STREAM ANALYTICS AND POWER BI * Use a Power BI output in Azure Stream Analytics * Create a query for real-time visualization * Create real-time data visualizations in Power BI 20 - INTRODUCTION TO MICROSOFT PURVIEW * What is Microsoft Purview? * How Microsoft Purview works * When to use Microsoft Purview 21 - INTEGRATE MICROSOFT PURVIEW AND AZURE SYNAPSE ANALYTICS * Catalog Azure Synapse Analytics data assets in Microsoft Purview * Connect Microsoft Purview to an Azure Synapse Analytics workspace * Search a Purview catalog in Synapse Studio * Track data lineage in pipelines 22 - EXPLORE AZURE DATABRICKS * Get started with Azure Databricks * Identify Azure Databricks workloads * Understand key concepts 23 - USE APACHE SPARK IN AZURE DATABRICKS * Get to know Spark * Create a Spark cluster * Use Spark in notebooks * Use Spark to work with data files * Visualize data 24 - RUN AZURE DATABRICKS NOTEBOOKS WITH AZURE DATA FACTORY * Understand Azure Databricks notebooks and pipelines * Create a linked service for Azure Databricks * Use a Notebook activity in a pipeline * Use parameters in a notebook ADDITIONAL COURSE DETAILS: Nexus Humans DP-203T00 Data Engineering on Microsoft Azure 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-203T00 Data Engineering on Microsoft Azure 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 3 Days 18 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, Business Process Owners/Team Leads/Power Users, Solution Architects, and System Architects. Overview Describe the SAP BusinessObjects Business Intelligence tools.Learn about the use cases and get an overview of basic functions of the most important BusinessObjects reporting tools. In this course, students describe the SAP BusinessObjects Business Intelligence tools and learn about the use cases by getting an overview of basic functions of the most important BusinessObjects reporting tools. OVERVIEW OF SAP BUSINESSOBJECTS BUSINESS INTELLIGENCE (BI) 4.1 * Describing SAP Analytics Solutions * Identifying the Components of SAP BusinessObjects 4.1 SEMANTIC LAYER IN SAP BUSINESSOBJECTS BI 4.1 * Describing Semantic Layer Technology * Creating a Universe in the Information Design Tool SAP CRYSTAL REPORTS * Creating a Report in SAP Crystal Reports for Enterprise * Creating a Report in SAP Crystal Reports 2013 * Differentiating SAP Crystal Reports 2013 and SAP Crystal Reports for Enterprise SAP BUSINESSOBJECTS WEB INTELLIGENCE * Creating Web Intelligence Documents in SAP BusinessObjects Web Intelligence SAP BUSINESSOBJECTS ANALYSIS, EDITION FOR MICROSOFT OFFICE * Creating a Workbook in SAP BusinessObjects Analysis, Edition for Microsoft Office SAP BUSINESSOBJECTS ANALYSIS, EDITION FOR OLAP * Creating a Workspace with SAP BusinessObjects Analysis, Edition for OLAP SAP BUSINESSOBJECTS DESIGN STUDIO 1.2 * Creating an Analytical Application in SAP BusinessObjects Design Studio 1.2 SAP BUSINESSOBJECTS DASHBOARDS * Creating a Dashboard with SAP BusinessObjects Dashboards SAP BUSINESSOBJECTS EXPLORER * Creating an SAP BusinessObjects Explorer Information Space SAP LUMIRA AND SAP PREDICTIVE ANALYSIS * Visualizing Data in SAP Lumira * Forecasting in SAP Predictive Analysis ADDITIONAL COURSE DETAILS: Nexus Humans SAPBI Introduction to SAP BusinessObjects BI Solutions 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 SAPBI Introduction to SAP BusinessObjects BI Solutions 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 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.