1724 Analytics courses delivered Online

Duration 2 Days 12 CPD hours This course is intended for This course is intended for intermediate business and requirements analysts who are looking to improve their business case development and presentation skills. This course is also a great fit for project managers and product owners who work closely with business analysts or who perform some form of business case work themselves. Overview Understand the role of the business analyst within the business case process Understand the main professional associations and standards that support business analysts in the industry Discuss the benefits of business case creation Explore how to define the business need Describe the role of the business analyst in supporting the enterprise to determine how to optimally invest in the right project initiatives Explain how to identify stakeholders and the significance to the pre-project activities Discuss the importance of analyzing the enterprise Describe and explore the activities performed to assess the current business environment Explain how a business analyst describes a ?future? state environment including how to identify gaps in enterprise capabilities Present and explore how to define the scope of a solution Describe the activities performed and techniques used to determine viable solution options Explore various techniques for evaluating solution options including feasibility and risk analysis Thoroughly understand the purpose of conducting a feasibility assessment Discuss and practice a number of business analysis techniques that support the business case process Explore the components of a business case Describe how the business case supports decision makers in making go/no-go decisions Demonstrate how to assemble the output from pre-project activities into a well-structured business case Present techniques for presenting business cases to top level managers and obtaining buy-in Discuss methods for preparing for challenges during business case delivery Students learn the steps to effective business case development and support your strategic business recommendations with sound budgeting and financial back-up. The one course you need to make high-impact recommendations and receive full management support for your ideas. Introduction Module Learning Objectives What is Business Analysis Polling Question International Institute of Business Analysis BABOK© Guide Components Project Management Institute Business Analysis for Practitioners: A Practice Guide BABOK© Guide Knowledge Areas Benefits of Business Analysis Polling Question A Business Analyst can Influence Project Success Factors Challenges of Business Analysis Polling Question Purpose of a Business Case Exercise 1a: What Should a Business Case Include Define the Business Case Elements What to Look Out For Who is Involved Exercise 1b: Review Business Case Outline Module Learning Objectives Pre-Project Activities & the Business Analyst Module Learning Objectives The Definition of a Business Analyst The Role of a Business Analyst Responsibilities of a BA BA Role vs. PM Role Business Analysis vs. Systems Analysis Business Analysis Competencies Polling Question Business Analyst Role and Stakeholders Exercise 2a: Review the Case Study What is a Stakeholder? The Importance of Stakeholders Stakeholder Identification Tips for Identifying Stakeholders Other Stakeholder Tips Stakeholder Identification/Analysis Exercise 2b: Identify Roles and Responsibilities Stakeholder Map Stakeholder Matrix & Onion Diagrams A Stakeholder Map Onion Diagram Exercise 2c: Why do we Need to Understand the Enterprise? Why Study the Enterprise? What is Enterprise Architecture? What is Strategy Analysis? About Strategy Analysis Purpose of Strategy Analysis When to Perform Strategy Analysis Strategic Planning Module Summary The Needs Assessment Process Module Learning Objectives Business Need Defined Define Business Need The Needs Assessment Process Problem or Opportunity Exercise 3a: Problem/Opportunity Identification Understanding Why Situation Statements Business Need and Current State Determine the Stakeholders Polling Question Goals and Objectives Polling Question Exercise 3b: Give 3 Examples of Business Goals Define Business Need Techniques Exercise 3c: Identify the Business Need Definition of Strategy Analysis When Business Strategy is not Driving Project Definition Typical Project Profile The Executive Paradox Solution to the Paradox Exercise 3d: Describe 3 Outcomes You Would Expect from the Case Study The Four ?Ares? Understand How to Create a Business Model Business Model Example Exercise 3e: Create a Business Model The Business Case Approach Financial and Strategic Measurement Tools Module Summary Determining the Required Capabilities & Defining Solution Scope Module Learning Objectives Business Need and Current State Purpose of Analyzing the Current State Analyzing Current Capabilities and Process Capabilities Defined Techniques for Analyzing the Current State Define the Future State Techniques for Defining the Future State Assess Capability Gaps Stakeholders Involved when Reviewing Capability Gaps Discussion: Assessing New Capabilities Defining Solution Scope Determining Scope Boundary How to Define Solution Scope Defining Solution Scope Project Scope and Product Scope Scope Modeling Techniques Used to Define Scope Define Scope Boundaries Modeling Scope: Context Diagram Exercise 4a: Create a Context Diagram from the Case Study Communicating Solution Scope to Stakeholders Stakeholders Participating in Scope Activities Exercise 4b: Discuss Managing Expectations Module Summary Assessing Feasibility & Proposing Solution Options Module Learning Objectives Financial Analysis Purpose of Financial Analysis Costs versus Benefits Financial Models Timing for Assessing Financial Benefits Risk Assessing Risks Risk Process Exercise 5a: Identifying Risks Risk Analysis Capturing and Categorizing Risks Risk Strategies Tolerance for Risk Determining Solution Options Solution Option Process Determining and Analyzing Solution Options Brainstorming Conducting an Outcomes Focused Brainstorming Session Stakeholders Involved in Determining Solution Options Exercise 5b: Determining Solution Options Feasibility Analysis Discussion: Ranking Solution Options Discussion: Recommending the Most Viable Option Exercise 5c: Assess the Most Viable Options Solution Approach Definition Exercise 5d: Review the Business Case Templates Module Summary Packaging & Presenting the Business Case Module Learning Objectives Circumventing a Business Case Documenting the Business Case Value of the Business Case Process Business Case Components Business Case Techniques Build a Convincing Business Case Discussion: Identifying Decision Criteria Exercise 6a: Supporting a Go/No Go Decision Packaging the Business Case Planning Business Case Delivery Discussion: Planning Stakeholder Buy-in Information and Communication Needs in the Business Case Process Presenting your Business Case Exercise 6b: Anticipating and Responding to Challenges Module Summary Course Wrap Up Course Summary Questions Additional Resources Thank You Additional course details: Nexus Humans BA03 - Writing Effective Business Cases 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 BA03 - Writing Effective Business Cases 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 2 Days 12 CPD hours This course is intended for The course is designed for individuals who want to gain in-depth knowledge and practice in the discipline of Business Analysis (Business Analysts, Requirements Engineers, Product manager, Product Owner, Chief Product Owner, Service Manager, Service Owner, Project manager, Consultants) Overview Students should be able to demonstrate knowledge and understanding and application of Business Analysis principles and techniques. Key areas are: The breath of the role of a Business Analyst The processes and techniques of strategy analysis Investigation of an organization's business systems Techniques used within stakeholder analysis and the need for analyzing perspectives Conceptual modelling and business activity models Business improvements through gap analysis The Business case within the business change lifecycle The Business Analyst role analyzes, understands and manages the requirements in a customer-supplier relationship and ensures that the right products are delivered.The course provides in-depth knowledge and practice in Business Analysis Course Introduction Let?s Get to Know Each Other Course Overview Course Learning Objectives Course Structure Course Agenda Introduction to Business Analysis Practice Exam Details Business Analysis Certification Scheme Rationale for Business Analysis The role of the BA throughout the stages of the Business change lifecycle The scope of the BA role within the context of the range of analysis activities Three areas of competencies Understanding the Strategic Context Techniques in practice: MOST Resource audit PESTLE Porter's Five Forces SWOT analysis CSF, KPI and Performance target Balanced Business Score Card Understanding the Current Situation Identification of stakeholder categories Identification of relevant investigation techniques The rationale for taking a holistic view Rich pictures, Mind Maps and Fishbone diagrams Stakeholder Analysis and Management Power/interest and level of interest Appropriate stakeholder management strategy Stakeholder perspectives and CATWOE technique Analysing and Modelling Business Activities Conceptual models of a business situation Five types of high level activity Planning activities Enabling activities Doing activities Monitoring and control activities Three types of business events The consensus business activity model Identifying Potential Solutions Different categories of business rules Gap analysis (through conceptual business activity model and as-is business situation) Components of a new business model Building the Business Case Rationale for the development of a business case Contents of a business case Identification of tangible/intangible costs and benefits, risks and impacts Rationale for the financial case and appraisal techniques Business case review in the business change lifecycle Additional course details: Nexus Humans Business Analysis - Practice 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 Business Analysis - Practice 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 intermediate to advanced Business Analysts who are looking to improve their skills for eliciting, analyzing, documenting, validating, and communicating requirements. Overview Obtain a thorough understanding of the core responsibilities of the business analyst Understand the main professional associations and standards supporting business analysts in the industry Discuss and explore the components of each of the domains/knowledge areas that comprise the work of business analysis Recognize the importance of properly defining the business need prior to engaging in requirements activities Formulate a strong understanding of the concepts that comprise strategy analysis Obtain experience with identifying and analyzing stakeholders Decipher between project and product scope and successfully use models to communicate scope Thoroughly understand and identify the various requirements categories and be able to recognize requirements of various types Explore business rules analysis Understand the benefits of process modeling and the common modeling language of BPMN Discuss process models and how the techniques can capture details about the as-is/to-be environment Learn how to properly prepare and conduct interviews Explore the components of use cases Learn what it means to package requirements Obtain hands-on experience with a number of business analysis techniques and gain hands-on experience eliciting, defining, and writing requirements. This course provides students a clear understanding of all the facets of the business analysis role, including a thorough walkthrough of the various domain/knowledge areas that comprise the business analysis profession. Students are provided an opportunity to try their hand at several business analysis techniques to assist with improving their skills in stakeholder identification, scope definition, and analyzing, documenting, and modeling requirements. Introduction to Business Analysis What is business analysis Benefits and challenges of business analysis Project success factors A Closer Look at the Business Analyst Role Definition of a business analyst Responsibilities of a business analyst Importance of communication/collaboration BA role vs. PM role Project roles involved in requirements IIBA/PMI and the goals of a professional association Purpose for having a BA standard IIBA?s BABOK© Guide and PMI?s Practice Guide in Business Analysis Business analysis beyond project work Business analysis core concepts Business analysis perspectives IIBA and PMI certifications for business analysts Workshop: Choose Your Project Supporting the Project Portfolio (Enterprise Analysis) Define Strategy Analysis When to perform Strategy Analysis Components of Strategy Analysis Defining the business need Envisioning the Product and Project Defining business requirements The importance of stakeholders Stakeholder identification Tips for analyzing stakeholders Techniques for managing stakeholder lists Discussion: Who is involved in strategy analysis? Workshops: Define the Business Need, Write Business Requirements, and Identify Stakeholders Understanding and Defining Solution Scope Defining solution scope Techniques for defining solution scope Applying the brainstorming technique Project scope vs. Product scope Finding solution boundaries The Context Diagram Actors and key information Workshop: Draw a Context Diagram Understanding Requirements What is a requirement? Requirement types Business, Stakeholder, Solution, and Transition requirements Assumptions and constraints Business rules Taxonomy of business rules Decision tables How to write simple calculations Requirements vs. business rules Document requirements Workshop ? Document Requirements Elicitation and Process Modeling Why do we model processes? What is Business Process Management? Using a modeling notation ?As Is? vs. ?To Be? modeling Why use BPMN? Basic BPM notation Business Process Modeling ? A case study Business Process Realignment ?As Is? vs. ?To Be? activity diagrams Workshop: Create a Business Process Model Planning & Eliciting Requirements Interviewing ? what and why? Preparing for an effective interview Types of questions to ask Sequencing questions Active listening techniques Planning for elicitation Conducting the interview Establishing rapport Active Listening Feedback techniques Types of elicitation techniques Workshops: Planning for Elicitation and Conducting an Elicitation Session Use Case & User Story Analysis What is an Actor? Types of Actors How to ?find? Use Cases? Diagramming Use Cases Tips on naming Use Cases Explaining scenarios The use case template Components of a use case Scenario examples Best practices for writing Use Cases Scenarios and flows Alternate and exception flows Exercises: Drawing a Use Case Diagram, Writing the Main Success Scenario, and Writing Alternate and Exception Scenarios Analyzing & Documenting Requirements Requirements and Use Cases Non-Functional requirements User Interface Requirements UI Data Table Reporting requirements Data requirements Data accessibility requirements Characteristics of good requirements The business requirements document (BRD) BRD vs. Functional Requirements Specification Preparing the requirements package Requirements traceability Workshops: Develop a User Interface, Analyzing Requirements, and Tracing requirements Additional Resources Useful books and links on writing effective requirements

Data Done Right - The Value of Good Communication Wouldn't it be great if you could see important textual and graphical information quickly and easily? What if it could be updated automatically or by using a simple refresh? What if you could easily change that information as needed, or see it right now with tools you already have, on multiple devices? In this presentation we will show you all of those things. You'll see reports that are produced in MS Project and MS Excel, graphical reports in Visio, and a dashboard that uses all of these tools. And we'll top it off with a discussion about what information to present and not present. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Data Done Right - The Value of Good Communication Wouldn't it be great if you could see important textual and graphical information quickly and easily? What if it could be updated automatically or by using a simple refresh? What if you could easily change that information as needed, or see it right now with tools you already have, on multiple devices? In this presentation we will show you all of those things. You'll see reports that are produced in MS Project and MS Excel, graphical reports in Visio, and a dashboard that uses all of these tools. And we'll top it off with a discussion about what information to present and not present. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Are you ready to embark on an enlightening journey of wisdom with the Organisational Administration bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Organisational Administration & Business Law Diploma. Delve into eight immersive CPD Accredited courses, each a standalone course: Office Administration Legal Secretary and Office Skills Diploma Business Law Leadership and Management Course Business Management Business Plan Fundamentals of Business Analysis Decision-Making in High-Stress Situations Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Organisational Administration & Business Law Diploma bundle illuminate your path to wisdom. The Organisational Administration & Business Law Diploma bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Organisational Administration & Business Law Diploma package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Organisational Administration bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Organisational Administration & Business Law Diploma community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Organisational Administration bundle. Establish robust bases across each course nestled within the Organisational Administration bundle. Decipher intricate concepts through the articulate content of the Organisational Administration bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Organisational Administration bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Organisational Administration bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Organisational Administration bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Organisational Administration bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Organisational Administration bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Organisational Administration journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Organisational Administration bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Organisational Administration bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Course overview Gain the skills to summaries large amounts of data into meaningful information with the Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course. In this course, you will develop a comprehensive understanding of the PivotTable and PivotChart and explore how they work. In this Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course, you will learn the steps to create your Pivot table and Pivot chart. We'll show you how to use Pivot tables to summarize large amounts of data. You'll also learn how to use PivotChart to provide visual representation to your summarized data. We will then take you through adding sorts, filters, timelines and slicers to create dynamic dashboards. You will also learn how to use the slicer to slice and dice your data the way you want. Learning outcomes Learn how to summaries data with Pivot Table Be able to add graphical representation to your summarized data with PivotChart Learn how to update the Pivot Table with new data Deepen your understanding of sorting and filtering Be able to import data from various sources with Power Query Gain an excellent understanding of Power Pivot Who is this course for? Professionals who want to learn how to summaries large sums of data into meaningful information using Excel Pivot and Charts can take this course. The program will provide learners with in-demand knowledge and skills, allowing them to take advantage of outstanding employment opportunities. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst Accountants Financial Analyst Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines Getting started with your Pivot Table 00:04:00 Drill Down 00:01:00 Managing the Field List 00:02:00 Changing the Calculation type with Value Field Settings 00:06:00 Growing your Pivot Table with Multiple Fields 00:04:00 Formatting the Pivot Table 00:05:00 Sorting and Filtering the Pivot Table 00:03:00 Creating a Dashboard with Slicers, Timelines and Pivot Charts 00:09:00 Reporting by day, month, qtr, or year within the Pivot Table 00:04:00 Refreshing the Pivot Data with new data 00:03:00 Adding your own calculations into the Pivot Table 00:03:00 The power of the Filter Section in the Pivot Table 00:04:00 PowerQuery 00:12:00 PowerPivot 00:21:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Microsoft Office 2016 Excel PowerPivot is designed for new PowerPivot users to get up to speed on how it works and its feature set. The course covers different features of the interface, techniques for manipulating PowerPivot data, how to create PowerPivot reports, the structure of DAX functions, and ways to distribute PowerPivot data. You will learn how to enable and navigate Power Pivot, how to manage data relationships, how to visualize Power Pivot data, how to create a Power Pivot report, and more. You will also learn some commonly used DAX functions. Prerequisite Course: Excel Level 3 or equivalent. Course Highlights Microsoft Office 2016 Excel PowerPivot is an award-winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Office 2016 Excel PowerPivot into 19 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 12 hours, 30 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Office 2016 Excel PowerPivot Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Microsoft Office 2016 Excel PowerPivot is CPD Qualification Standards and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Microsoft Office 2016 Excel PowerPivot is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Office 2016 Excel PowerPivot Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Office 2016 Excel PowerPivot 00:00:00

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Overview In this course, you will create complex reports using tools in Crystal Reports 2016. You will: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency. 1 - CREATING RUNNING TOTALS Topic A: Create a Running Total Field Topic B: Modify a Running Total Field Topic C: Create a Manual Running Total 2 - WORKING WITH CROSS-TABS Topic A: Create a Cross-Tab Report Topic B: Format a Cross-Tab Report Topic C: Create Groups in Cross-Tab Reports 3 - ADDING SUBREPORTS Topic A: Insert a Subreport Topic B: Edit a Subreport Topic C: Share Variables 4 - CREATING DRILL-DOWNS IN A REPORT Topic A: Create a Drill-Down Topic B: Create Headings for Drill-Down Data 5 - USING SQL STATEMENTS IN REPORT PROCESSING Topic A: Create a Report Using SQL Queries Topic B: Summarize Report Data Topic C: Create Joins Using SQL Topic D: Create Subqueries Topic E: Create an SQL Expression Field 6 - CREATING COMPLEX FORMULAS Topic A: Work with Loops Topic B: Work with Arrays 7 - ADDING CHARTS TO REPORTS Topic A: Create Charts Topic B: Create a Chart with Drill-Down Topic C: Create a Top N Chart Topic D: Create a Cross-Tab Chart Topic E: Create Charts for Grouped Data Topic F: Format a Chart Topic G: Create a Chart Template 8 - ENHANCING REPORT FUNCTIONALITY Topic A: Organize Data Based on a Hierarchy Topic B: Create a Dynamic Image Topic C: Create a Report Alert Topic D: Create a Geographic Map 9 - APPENDIX Appendix A: Managing Reports Appendix B: Processing Data on the Server Appendix C: Detecting and Fixing Problems

Description: This Microsoft Excel 2016 PowerPivot takes a look at the free PowerPivot add-in for Microsoft Excel 2016. It is a program for all users of PowerPivot to get a good grasp of how its features are set and how it works. It covers interface features, techniques for manipulating PowerPivot data. You will learn how to create PowerPivot reports, the structure of DAX functions, and ways to distribute PowerPivot data. So, if you are interested to develop your skills and knowledge, you shouldn't be late to join this course. Learning Outcomes: Explore PowerPivot applications Importing data from different sources Creating linked tables Organizing and formatting tables Creating calculated columns PowerPivot data filtering and sorting Creating PivotTables and PivotCharts, and filtering data using slicers Presenting Visual data through visual outlets Utilizing DAX functions for manipulating PowerPivot data Extracting data from tables using functions, and working with time dependent data Saving data in different formats and protecting reports Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Excel 2016 PowerPivot is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Excel 2016 PowerPivot is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Microsoft Excel 2016 PowerPivot Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 PowerPivot 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2016 PowerPivot 00:20:00 Final Exam Final Exam- Microsoft Excel 2016 PowerPivot 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00