668 Business Analytics & Intelligence courses delivered Online

Who can apply for this MBA – Artificial Intelligence program? Anyone with an undergraduate degree with a minimum of 50% marks Minimum of one year of professional experience Professionals looking to grow their career with a Master degree in Management Professionals wishing to make a transition to mid-level and higher positions

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.

Developing the Business Case: In-House Training Business analysts must be able to create business case documents that highlight project benefits, costs, and risks. The business case is based on the real business need to be solved. These become parts of proposals, feasibility studies, and other decision support documents. This course teaches the purpose, structure, and content of a business case. It presents the basic techniques for determining financial ROI, non-tangible benefits, and the probability of meeting expectations. What you will Learn At the end of this program, you will be able to: Perform feasibility studies Justify the business investment to solve the business problem Prepare an effective business case document Plan and implement a business case approval process Foundation Concepts The role of the BA An introduction to the BABOK® Guide The business analyst and the product / project life cycle (PLC) The business case deliverable Introducing the Business Case Process The BA and strategy analysis The BA and the business case process (BCP) The BA during the business case process (BCP) The BA after the business case process (BCP) Importance of defining solution performance metrics Defining the Business Need Overview of defining the business need Business needs: problem / opportunity statement Product vision Objectives and constraints Exploring Business Case Solutions Overview of exploring solutions Solution identification for feasibility Solution definition for analysis Assessing project risks Justifying the Business Case Overview of justifying the business case Qualitative justification Quantitative justification Approving the Business Case Overview of business case approval Developing recommendations Preparing the decision package - documents Preparing the decision package - presentations

Writing and Managing Requirements Documents: In-House Training This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals pass the IIBA™ Certification exam to become a Certified Business Analysis Professional (CBAP™). Learn more at www.iil.com/bacp. Once a business analyst has completed the information gathering and analysis to produce the solution to a business problem, the results must be documented for all stakeholders to see and understand. This course will enhance the skill set needed for writing and managing the complex readership that business analysts interact with on a day-to-day basis. What you will Learn Upon completion, participants will be able to: Write an understood requirements document that is approvable and acceptable Validate a requirements document Manage the changes to requirements documents through the SDLC Foundation Concepts The role of the business analyst An introduction to the BABOK® Guide The business analyst and the product/project life cycle The requirements documentation process Planning for Effective Requirements Documentation Overview of requirements planning Planning for validation Planning for verification: well-formed criteria Planning for verification: understood and usable criteria Writing Effective Requirements Documents Overview of writing requirements documents Using a standard structure / template Applying formatting techniques Meeting the challenge of writing non-functional requirements Baselining Requirements Documents Overview of the requirements baseline process Validation Verification Approval Managing Requirements Change through the Product Life Cycle Overview of requirements change management Establishing a formal change management process Tracing requirements through design and development (build, test, and implementation) Following through to post-implementation (transition and early production)

OVERVIEW Prerequisites—DIAD training and Advanced Data Modeling and Shaping training or equivalent working experience This course has been designed specifically for experienced model developers and gives a more advanced treatment of DAX formulas than either DIAD or the PL-300 course. We recommend that attendees have prior experience working with Power BI Desktop to create data models. During this course you will review: Writing DAX formulas. Defining calculated tables and columns. Defining measures. Using DAX iterator functions. Modifying filter context. Using DAX time intelligence functions. After completing this training, the attendees should be able to work with Data Analysis Expressions (DAX), perform calculations and define common business calculations for use in reports, address performance and functionality concerns. COURSE BENEFITS: Understand Analytic queries in Power BI Create calculated tables, calculated columns and measures Use DAX functions and operators to build DAX formulas Use DAX iterator functions Create formulas that manipulate the filter context Use DAX time intelligence functions WHO IS THE COURSE FOR? Analysts with experience of Power BI wishing to develop more advanced formulas in DAX Power BI developers who wish to deepen their understanding of the process of calculating formulas so as to make development faster and more reliable LAB OUTLINE Lab 1 Setup Connect to data and understand the objectives of the future labs Lab 2 Write DAX Formulas For Power BI Create a measure Use variables in the measure definition Lab 3 Add Calculated Table And Columns Duplicate a table Create a hierarchy Create a date table Add calculated columns Lab 4 Add Measures To Power BI Desktop Models Add an implicit measure to a report Add an explicit measure Add a compound measure Add a quick measure Lab 5 Use DAX Iterator Functions In A Power BI Desktop Model Complex summarization Higher grain summarization Create ranking measure Lab 6 Modify DAX Filter Context In Power BI Desktop Models Apply Boolean expression filter Remove filters: use ALL Remove filters: use AllSelected Preserve filters: use KeepFilters HASONEVALUE ISINSCOPE Context transition Lab 7 Use DAX Time Intelligence Functions In Power BI Desktop Models TOTALYTD SAMEPERIODLASTYEAR Calculate new occurrences Snapshot calculations

OVERVIEW DIAD is a one-day, hands-on workshop for business analysts, covering the breadth of Power BI capabilities. The course focuses on five practical Labs and at the end of the day, attendees will better understand how to: Connect and transform data from a variety of data sources. Define business rules and KPIs. Explore data with powerful interactive visuals. Build stunning reports. Share their dashboards with their team business partners and publish them to the web. The course content is managed by the Power BI engineering team at Microsoft. There is no exam associated with the course. COURSE BENEFITS: Learn how to clean, transform, and load data from various sources 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 and share report assets to the Power BI Service WHO IS THE COURSE FOR? Data Analysts and Management Consultants with little or no experience of Power BI who wish to upgrade their knowledge to include Business Intelligence Analysts looking for a quick introduction to Power BI who don’t have the time for the full three day PL-300 course Marketers in data-intensive organisations who need new tools to build visually appealing, dynamic charts for their stakeholders to use LAB OUTLINE Lab 1 Accessing & Preparing The Data Load data from Excel and CSV sources Manipulate the data to prepare it for reporting Prepare tables in Power Query and load them into the data model Lab 2 Data Modelling And Exploration Create a range of different charts Highlight and cross-filter Create new groups and hierarchies Add new measures to the model Lab 3 Data Visualization Add conditional formatting to a report Add logos to a filter Import a custom visual Apply a custom theme Add bookmarks to the report to tell a story Lab 4 Publishing A Report And Creating A Dashboard Create a Workspace in the Power BI Service Publish a report to the Service Create a Dashboard and pin visuals to it Generate and view insights Lab 5 Collaboration Share a Dashboard Access a Dashboard on a Mobile Device

OVERVIEW Prerequisites—DIAD training or equivalent working experience This one-day course will cover using Power BI Desktop to import and shape data from a variety of sources. It will also walk through Power BI capabilities you can use to enhance the data model for your business users. The course covers key aspects of how to create a great data model to meet your business needs, various features in Power BI used to enhance data models so you can build great reports, and an introduction to DAX to create calculations. After completing this training, the attendees should be able to import data from a variety of data sources into Power BI, shape the data, create the data model, and write DAX functions to the Power BI model. COURSE BENEFITS: Understand the Power BI Desktop data model, its components and most effective schemas Describe concepts of calculated columns and measures Create queries using M Create calculations with DAX Understand the use of functions Create and optimize a data model Understand the consequences of data model design decisions WHO IS THE COURSE FOR? Power BI report developers who wish to improve the structure of their data models Power BI report developers who wish to use advanced features like parameters and M coding in Power Query Power BI practitioners who wish to optimise their models more effectively Attendees wishing to prepare thoroughly for the DAX In A Day course COURSE OUTLINE Module 1 Getting And Shaping The Data Understand what is meant by data model in the context of Power BI Understand the consequences of data model design decisions Understand consequences of Power BI’s data type handling Understand data connection options Module 2 Basic Data Modelling Understand basic data modelling Understand basic data model types Explore dimension tables and fact tables Explore data connections Module 3 Getting Started With M (Power Query Language) Get introduced to M Understand key components and syntax Module 4 Understanding Logic Operators Understand Transformations Understand Join operation Module 5 Introduction To DAX Get introduced to DAX and how can it be used Understand working with parameters and DAX (lab combining the previous module) Module 6 Working With Functions - DAX CALCULATE And More Understand working with functions Understand the basics of the CALCULATE formula Module 7 Modelling With Power BI & DAX Best Practice Gain familiarity with basic data modelling for business scenarios Learn some best practices for working with Power BI

The innovative Process Improvement Level 02 has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector.  This popular Process Improvement Level 02 has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique Process Improvement Level 02 course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business.  The Process Improvement Level 02 is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the Process Improvement Level 02 consists of a range of educational modules that allow study sessions to be organised at any time and any place When the final assessment of the Process Improvement Level 02 has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the Process Improvement Level 02 course can help to make all the difference in a dynamic employment sector and can also be validated on our website. We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the Process Improvement Level 02 has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at. Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.

Course Overview Discover how to ensure that your organisation has the resources and products that it needs to work efficiently with this course on Process Mapping & Supply Chain. Organisations need guaranteed and sustainable access to supplies in order to be able to work effectively. Poor working partnerships can effectively destroy this. By following this training, you will know how to coordinate your inventories and transportation to achieve the best outcome for the customer and the company. This Operations Management tutorial provides you with all the techniques and strategies for creating the perfect working supply chain. You will be shown how to accurate map requirements for your business and your customers, leading to enhanced service delivery and operations. Using these principles, you will become skilled at supply chain management and know how to continually improve it to everyone's benefit. This best selling Process Mapping & Supply Chain has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Process Mapping & Supply Chain is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Process Mapping & Supply Chain is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Process Mapping & Supply Chain is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Process Mapping & Supply Chain, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Process Mapping & Supply Chain will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Process Mapping & Supply Chain to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.