6565 Finance courses in Polegate delivered Online

Embark on a comprehensive journey into the world of property development with this course. Delve into key modules that cover the entire property development process, from understanding the economic context to making informed decisions, managing finances, and successfully promoting and selling properties. Gain a deep understanding of land acquisition, business establishment, and market research. This course provides essential insights into every stage of property development. Learning Outcomes: Comprehend the property development process from conception to sale. Recognize the roles of main actors and economic factors shaping development. Acquire knowledge about land acquisition and its implications. Develop decision-making skills crucial for successful property projects. Gain insights into sorting out financial aspects of property development. Understand the process of establishing and managing a property development business. Master market research techniques to identify trends and demand. Learn effective strategies for property promotion and sales. Why buy this Property Development?  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 Property Development you will be able to take the MCQ test that will assess your knowledge. 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 Property Development course is ideal for Aspiring property developers aiming to build a strong foundation. Real estate enthusiasts exploring property development as a career. Investors seeking to understand the property development landscape. Professionals in related fields such as architecture and construction. Prerequisites This Property Development 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 Junior Property Developer - Average Salary: £25,000 - £35,000 per year. Property Development Manager - Average Salary: £40,000 - £60,000 per year. Senior Property Development Consultant - Average Salary: £60,000 - £80,000 per year. Property Investment Analyst - Average Salary: £30,000 - £50,000 per year. Self-Employed Property Developer - Earnings can vary significantly based on project success. Course Curriculum Module 1: Property Development and the Process Property Development and the Process 00:35:00 Module 2: Main Actors and Economic Context Main Actors and Economic Context 01:20:00 Module 3: Land for Development Land for Development 02:00:00 Module 4: Making Decisions Making Decisions 00:20:00 Module 5: Sorting Out Your Finances Sorting Out Your Finances 00:30:00 Module 6: Establishing Your Business Establishing Your Business 00:20:00 Module 7: Market Research Market Research 01:15:00 Module 8: Promotion and Selling Promotion and Selling 01:00:00 Mock Exam Mock Exam - Property Development 00:20:00 Final Exam Final Exam - Property Development 00:20:00

The 'Kid's / Children's Party Planner Diploma Course' equips aspiring party planners with essential skills and knowledge to organize successful and memorable kids' parties. The course covers various aspects of party planning, including budgeting, theme selection, entertainment, catering, and ensuring a memorable experience for children. Learning Outcomes: Understand the fundamentals of planning kids' parties and the key elements involved. Develop the necessary skills to become an effective and successful party planner for children's events. Identify different types of kids' parties and tailor them to suit the interests and preferences of young guests. Learn how to manage finances effectively while planning and organizing kids' parties. Explore the process of choosing suitable themes that appeal to children and create a vibrant atmosphere. Plan and arrange entertainment options that engage and entertain young attendees. Focus on catering considerations, including kid-friendly menus and special dietary requirements. Discover strategies to make the party day memorable for children and their families. Learn how to coordinate and manage various aspects of the party to ensure a smooth and enjoyable experience. Gain valuable insights into creating a safe, fun, and engaging environment for kids' parties. Develop the ability to customize parties based on age groups, interests, and preferences. Acquire marketing and business skills to establish a successful career as a children's party planner. Why buy this Kid's / Children's Party Planner Diploma 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 Kid's / Children's Party Planner Diploma 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 Kid's / Children's Party Planner Diploma Course course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Kid's / Children's Party Planner Diploma Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Kid's / Children's Party Planner Diploma 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Kid's / Children's Party Planner Diploma Course is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 01: Planning a Kids' Party Planning a Kids' Party 00:15:00 Module 02: Skills You Need to Be a Party Planner Skills You Need to Be a Party Planner 00:15:00 Module 03: Types of Kids' Parties Types of Kids' Parties 00:15:00 Module 04: The Finances The Finances 00:17:00 Module 05: Choosing a Theme Choosing a Theme 00:22:00 Module 06: Planning the Entertainment Planning the Entertainment 00:26:00 Module 07: Focusing on Catering Focusing on Catering 00:27:00 Module 08: Making the Day Memorable Making the Day Memorable 00:22:00 Assignment Assignment - Kid's / Children's Party Planner Diploma Course 00:00:00

Overview Immerse yourself in the dynamic world of real estate with this comprehensive course. Navigate through key modules, including estate agent introductions, property valuation, negotiation, investment property, regulations, and property development. Delve into the intricacies of fees, contracts, and client management. Equip yourself with the skills and knowledge needed to thrive as a property manager and real estate agent. Learning Outcomes: Understand the role and responsibilities of an estate agent. Differentiate between types of estate agents and their functions. Grasp the concepts of property valuation and effective negotiation. Explore the intricacies of property buying, selling, and letting. Gain insights into investment property management. Familiarize yourself with regulations governing real estate agencies. Acquire skills for setting up and managing a successful agency. Gain expertise in property development decision-making and finances. Why buy this Property Manager & Real Estate Agent Complete 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 Property Manager & Real Estate Agent Complete Course you will be able to take the MCQ test that will assess your knowledge. 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 Property Manager & Real Estate Agent Complete Course course is ideal for Aspiring real estate agents looking to kickstart their careers. Property managers aiming to enhance their skills and knowledge. Individuals interested in investment property management. Those considering starting their own real estate agency. Prerequisites This Property Manager & Real Estate Agent Complete 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 Junior Real Estate Agent - Average Salary: £20,000 - £30,000 per year. Property Manager - Average Salary: £25,000 - £35,000 per year. Senior Real Estate Agent - Average Salary: £30,000 - £50,000 per year. Property Investment Consultant - Average Salary: £40,000 - £60,000 per year. Real Estate Agency Owner - Earnings can vary significantly based on agency success. Course Curriculum Module 01: Estate Agent: An Introduction What is Estate Agent 00:15:00 Requirements for the Job 00:20:00 History of the Estate Agent 00:20:00 The Real Estate Industry 00:15:00 Module 02: Types of Estate Agent Different Types of Estate Agents 00:15:00 Online Estate Agents 00:20:00 Module 03: Fees and Contracts Estate agent Fees and Contracts 00:30:00 Pros and Cons of Hiring an Estate Agent 00:20:00 Module 04: Know the Clients Getting to Know Your Clients 00:20:00 A Day in the Life of an Estate Agent 00:15:00 Module 05: Property Selling Property with an Estate Agent 00:15:00 Property Marketing 00:15:00 The Regulations for Estate Agent Boards and Why It is Important 00:15:00 Module 06: Valuation and Negotiation Valuation 00:20:00 Performing Viewings 00:15:00 Negotiating 00:30:00 Module 07: Buying and Selling with an Estate Agent Buying with an Estate Agent 00:20:00 Sales Progression 00:30:00 Technology 00:25:00 Module 08: Investment Property and Letting Agents Investment Property 00:40:00 About Letting Agents 00:25:00 Property Management 00:15:00 Module 09: Regulations and Setting up an Agency Laws and Regulations 00:30:00 How to Set Up an Estate Agency 00:15:00 Module 10: Property Development Property Development and the Process 00:35:00 Main Actors and Economic Context 01:20:00 Land for Development 02:00:00 Module 11: Decision Making and Finances Making Decisions 00:20:00 Sorting Out Your Finances 00:30:00 Module 12: Establishing Business Establishing Your Business 00:20:00 Market Research 01:15:00 Promotion and Selling 01:00:00 Mock Exam Mock Exam - Property Manager & Real Estate Agent Complete Course 00:20:00 Final Exam Final Exam - Property Manager & Real Estate Agent Complete Course 00:20:00

Taster session. Passive income from Property. Professional Investor secrets to build a Property Portfolio, even if you're starting with little capital

Overview of UK Self Assessment Tax Return Understanding the UK Self Assessment Tax Return process is becoming an important skill for anyone who wants to take charge of their own finances. Every year, more than 12 million people in the UK complete a UK Self Assessment Tax Return, helping HMRC collect over £34 billion. This course is designed to help you learn how to manage your taxes clearly and confidently, even if you're not a tax expert. You’ll learn the basics of how the tax system works, how to report your income correctly, and how to claim expenses you’re allowed to. The course also covers capital gains tax, tax reliefs, and other important areas that many people miss. By understanding the full UK Self Assessment Tax Return process, you can make sure you don’t pay more tax than necessary, and you avoid penalties for late or incorrect submissions. This UK Self Assessment Tax Return course is perfect for self-employed people, those with different sources of income, or anyone who wants to feel more confident about doing their own tax return. With clear guidance and practical tips, you’ll be able to complete your UK Self Assessment Tax Return correctly and on time. Take control of your tax responsibilities today with this simple and easy-to-follow UK Self Assessment Tax Return course. This UK Self Assessment Tax Return course will help you to learn: Understand how the UK tax system works and what rules apply Know who needs to send a self-assessment tax return and when Keep and organise the right financial records for HMRC Work out how much income tax you need to pay from different income types Use tax credits and reliefs you are allowed to claim Plan to stay within the rules and avoid problems with HMRC Who is this course for? Self-employed people who need to do their own tax returns Small business owners who want to handle taxes without always using an accountant Anyone with more than one income (like jobs, property, or investments) People who want to understand tax better for their own or clients' finances Those who earn money from abroad or have a more complicated tax situation Process of Evaluation After studying the UK Self Assessment Tax Return Course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the UK Self Assessment Tax Return Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. (Each) Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Requirements There is no prerequisite to enrol in this course. Career Path This UK Self Assessment Tax Return Course will help learners to pursue a variety of careers. Such as: Tax Adviser – £25,000 to £45,000 a year Bookkeeper – £20,000 to £35,000 a year Accountant – £28,000 to £50,000 a year Financial Consultant – £30,000 to £60,000 a year Tax Return Specialist – £22,000 to £40,000 a year Course Curriculum Module 01: Tax System in the UK Tax System in the UK 00:15:00 Module 02: Submit a Self-Assessment Tax Return Submit a Self-Assessment Tax Return 00:06:00 Module 03: Gathering and Organizing Documents Gathering and Organising Documents 00:15:00 Module 04: Income Tax Income Tax 00:18:00 Module 05: Advanced Income Tax Advanced Income Tax 00:22:00 Module 06: Expenses and Deductions Expenses and Deductions 00:16:00 Module 07: Capital Gain Tax Capital Gain Tax 00:15:00 Module 08: Tax Credits and Reliefs Tax Credits and Reliefs 00:15:00 Module 09: Completing the Self-Assessment Tax Return Completing the Self-Assessment Tax Return 00:17:00 Module 10: Tax Planning and Compliance Tax Planning and Compliance 00:18:00

Property administrators are responsible for managing the administrative side of running a property. The job includes property maintenance, showing prospective tenants around a property, collecting rent and paying contractors. This Property Administrator Training course explores the skills and knowledge required for this role, with an introduction to the real estate industry. Throughout this course, you will learn about the day in the life of a property administrator, with step-by-step training on how to perform viewings, negotiate property prices and carry out a valuation. You will also develop the skills to build excellent relationships with tenants, including handling their complaints in a professional manner. Your Learning Goals: Learn about the role of a property administrator and the key responsibilities Understand the laws and regulations surrounding property management Develop crucial multi-tasking, negotiating, problem-solving & customer service skills Be able to deal with all types of tenants in a professional and neutral manner Familiarise with the different types of lettings agents and estate agents Build solid relationships with project managers and contractors Explore the sales progression process from start to completion Discover marketing strategies for promoting your company's services Who is This Course for? This course is suitable for those who are considering a career in the administrative sector of the real estate industry. This Property Administrator Training course is a beginners training course, ideal for those who are not yet in a property administrator role. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99 Career Path On successful completion, learners will be equipped with the skills and knowledge to kickstart a career in real estate. Related roles in this field include: Property Administrator Property/Lettings Negotiator Assistant Lettings Manager Estate Agent Course Curriculum Property Administrator Training - Updated Version Module 1 - Estate Agent: An Introduction 00:21:00 Module 2 - Different Types of Estate Agents 00:16:00 Module 3 - Getting Started on the Job 00:16:00 Module 4 - Listing Property: Finding the Sellers 00:24:00 Module 5 - Valuation Process 00:21:00 Module 6 - Negotiating As an Estate Agent 00:13:00 Module 7 - Selling Property: Finding the Buyers 00:23:00 Module 8 - Letting Property 00:31:00 Module 9 - Technology for Estate Agents 00:22:00 Module 10 - Regulation of Estate Agents 00:14:00 Mock Exam Mock Exam- Property Administrator Training 00:20:00 Final Exam Final Exam- Property Administrator Training 00:20:00 Property Administrator Training - Old Version Estate Agent Module 1: What is Estate Agent 00:15:00 Module 2: Requirements for the Job 00:20:00 Module 3: History of the Estate Agent 00:20:00 Module 4: The Real Estate Industry 00:15:00 Module 5: Different Types of Estate Agents 00:15:00 Module 6: Online Estate Agents 00:20:00 Module 7: Estate agent Fees and Contracts 00:30:00 Module 8: Pros and Cons of Hiring an Estate Agent 00:20:00 Module 9: Getting to Know Your Clients 00:20:00 Module 10: A Day in the Life of an Estate Agent 00:15:00 Module 11: Selling Property with an Estate Agent 00:15:00 Module 12: Property Marketing 00:15:00 Module 13: The Regulations for Estate Agent Boards and Why It is Important 00:15:00 Module 14: Valuation 00:20:00 Module 15: Performing Viewings 00:15:00 Module 16: Negotiating 00:30:00 Module 17: Buying with an Estate Agent 00:20:00 Module 18: Sales Progression 00:30:00 Module 19: Technology 00:25:00 Module 20: Investment Property 00:40:00 Module 21: About Letting Agents 00:25:00 Module 22: Property Management 00:15:00 Module 23: Laws and Regulations 00:30:00 Module 24: How to Set Up an Estate Agency 00:15:00 Property Manager Module 25: Property Development and the Process 00:45:00 Module 26: Main Actors and Economic Context 01:00:00 Module 27: Land for Development 01:00:00 Module 28: Making Decisions 00:45:00 Module 29: Sorting Out Your Finances 00:30:00 Module 30: Establishing Your Business 00:30:00 Module 31: Market Research 01:00:00 Module 32: Promotion and Selling 01:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Duration 2 Days 12 CPD hours Overview What's New in This Guide? The behind-the-scenes journal entry for transactions is now included. This course is a continuation of topics following ?Get Started with QuickBooks 2020 for Windows?. First-time QuickBooks users will learn the basic features of the software. Experienced QuickBooks users will quickly learn the new features and functionality of QuickBooks 2020. This course covers features that are in QuickBooks Pro and Premier 2020. Memorizing Transactions Entering a New Memorized Transaction Editing a Memorized Transaction Deleting a Memorized Transaction Grouping Memorized Transactions Using a Memorized Transaction Printing the Memorized Transaction List Customizing Forms Creating a Custom Template Modifying a Template Printing Forms Using Other QuickBooks Accounts Other QuickBooks Account Types Working with Credit Card Transactions Working with Fixed Assets Working with Long-Term Liability Accounts Using the Loan Manager Creating Reports Working with Quick Reports Working with Preset Reports Sharing Reports Exporting Reports to Microsoft Excel Printing Reports Creating Graphs Creating QuickInsight Graphs Using QuickZoom with Graphs Working with the Sales Graph Customizing Graphs Printing Graphs Tracking and Paying Sales Tax Using Sales Tax in QuickBooks Setting Up Tax Rates and Agencies Indicating Who and What Gets Taxed Applying Tax to Each Sale Determining What You Owe Paying Your Tax Agencies Preparing Payroll with QuickBooks Using Payroll Tracking Setting Up for Payroll Setting Up Employee Payroll Information Setting Up a Payroll Schedule Writing a Payroll Check Printing Paycheck Stubs Tracking Your Tax Liabilities Paying Payroll Taxes Preparing Payroll Tax Forms Using Online Banking Setting Up an Internet Connection Setting Up Bank Feeds for Accounts Viewing, Downloading, and Adding Online Transactions Creating Online Payments Transferring Funds Online Canceling Online Payments Managing Company Files Using QuickBooks in Multi-user Mode Setting Up Users and Passwords Setting a Closing Date Sharing Files with an Accountant Updating QuickBooks Backing Up and Restoring a Company File Condensing a Company File Estimating, Time Tracking, and Job Costing Creating Job Estimates Creating an Invoice from an Estimate Displaying Reports for Estimates Updating the Job Status Tracking Time Displaying Reports for Time Tracking Tracking Vehicle Mileage Displaying Vehicle Mileage Reports Displaying Other Job Reports Writing Letters Using the Letters and Envelopes Wizard Customizing Letter Templates

Duration 2 Days 12 CPD hours This course is intended for Authors Overview Please refer to course overview This course teaches experienced authors advanced report building techniques to enhance, customize, manage, and distribute reports. Additionally, the student will learn how to create highly interactive and engaging reports that can be run offline by creating Active Reports. Create query models Build a query and connect it to a report Answer a business question by referencing data in a separate query Create reports based on query relationships Create join relationships between queries Combine data containers based on relationships from different queries Create a report comparing the percentage of change Introduction to dimensional reporting concepts Examine data sources and model types Describe the dimensional approach to queries Apply report authoring styles Introduction to dimensional data in reports Use members to create reports Identify sets and tuples in reports Use query calculations and set definitions Dimensional report context Examine dimensional report members Examine dimensional report measures Use the default measure to create a summarized column in a report Focus your dimensional data Focus your report by excluding members of a defined set Compare the use of the filter() function to a detail filter Filter dimensional data using slicers Calculations and dimensional functions Examine dimensional functions Show totals and exclude members Create a percent of base calculation Create advanced dynamic reports Use query macros Control report output using a query macro Create a dynamic growth report Create a report that displays summary data before detailed data and uses singletons to summarize information Design effective prompts Create a prompt that allows users to select conditional formatting values Create a prompt that provides users a choice between different filters Create a prompt to let users choose a column sort order Create a prompt to let users select a display type Examine the report specification Examine report specification flow Identify considerations when modifying report specifications Customize reporting objects Distribute reports Burst a report to email recipients by using a data item Burst a list report to the IBM Cognos Analytics portal by using a burst table Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship Enhance user interaction with HTML Create interactive reports using HTML Include additional information with tooltips Send emails using links in a report Introduction to IBM Cognos Active Reports Examine Active Report controls and variables Create a simple Active Report using Static and Data-driven controls Change filtering and selection behavior in a report Create interaction between multiple controls and variables Active Report charts and decks Create an Active Report with a Deck Create an Active Report with 11.0 visualizations

Duration 3 Days 18 CPD hours This course is intended for Authors Overview Please refer to course overview This course provides authors with an introduction to build reports using Cognos Analytics. Techniques to enhance, customize, and manage reports will be explored. Activities will illustrate and reinforce key concepts during this learning opportunity. What is IBM Cognos Analytics - Reporting The Welcome page Consume report content Interactive filtering Working with reports Dimensionally modeled relational dataUse personal data sources and data modules Upload personal data Upload custom images Using navigation paths in a data module Examine list reports Group data Format columns Include headers and footers Aggregate fact data Identify differences in aggregation Multiple facts and repeated information Use shared dimensions to create multi-fact queries Present repeated information Add repeated information to reports Create a mailing list report Create crosstab reports Add measures to a crosstab Data sources for a crosstab Create complex crosstab reports Add items as peers Create crosstab nodes and crosstab members Work with crosstab data Format, sort, and aggregate a crosstab Create discontinuous crosstab reportsCreate visualization reports Visualization categories Customize visualizations Client side visualizations Enhanced map visualizations Focus reports using filters Create filters to narrow the focus Use advanced detail filters Apply a filter with aggregation Use summary filters Focus reports using prompts Examine parameters and prompts Create a parameter for a report item Add a prompt page Add a prompt item to a report Identify a prompt type Create a cascading prompt Use calculations What are calculations Add Date and Time functions Add string functions Display prompt selections in report titles Customize reports with conditional formatting Three steps for conditional formatting Create a variable Assign the variable to a report object Format based on the conditional value Conditionally render report objects Drill-through definitions Navigate to related data Enhance report layout View the structure of a report Use Guided report layout Force page breaks Create horizontal pagination Modify the report structure Format objects across reports Use additional report-building techniques Enhance a report design Add objects to reports Convert a list to a crosstab Explore reuse Additional course details: Nexus Humans B6258 IBM Cognos Analytics - Author Reports Fundamentals V11.1.x 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 B6258 IBM Cognos Analytics - Author Reports Fundamentals V11.1.x 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 Report Authors Overview Create query models Create reports based on query relationships Introduction to dimensional data Introduction to dimensional data in reports Dimensional report context Focus your dimensional data Calculations and dimensional functions Create advanced dynamic reports This offering teaches Professional Report Authors about advanced report building techniques using relational data models, dimensional data, and ways of enhancing, customizing, managing, and distributing professional reports. The course builds on topics presented in the Fundamentals course. Activities will illustrate and reinforce key concepts during this learning activity. Create query models Build a query and connect it to a report Answer a business question by referencing data in a separate query Create reports based on query relationships Create join relationships between queries Combine data containers based on relationships from different queries Create a report comparing the percentage of change Introduction to dimensional reporting concepts Examine data sources and model types Describe the dimensional approach to queries Apply report authoring styles Introduction to dimensional data in reports Use members to create reports Identify sets and tuples in reports Use query calculations and set definitions Dimensional report context Examine dimensional report members Examine dimensional report measures Use the default measure to create a summarized column in a report Focus your dimensional data Focus your report by excluding members of a defined set Compare the use of the filter() function to a detail filter Filter dimensional data using slicers Calculations and dimensional functions Examine dimensional functions Show totals and exclude members Create a percent of base calculation Create advanced dynamic reports Use query macros Control report output using a query macro Create a dynamic growth report Create a report that displays summary data before detailed data and uses singletons to summarize information Design effective prompts Create a prompt that allows users to select conditional formatting values Create a prompt that provides users a choice between different filters Create a prompt to let users choose a column sort order Create a prompt to let users select a display type Examine the report specification Examine report specification flow Identify considerations when modifying report specifications Customize reporting objects Distribute reports Burst a report to email recipients by using a data item Burst a list report to the IBM Cognos Analytics portal by using a burst table Burst a crosstab report to the IBM Cognos Analytics portal by using a burst table and a master detail relationship Enhance user interaction with HTML Create interactive reports using HTML Include additional information with tooltips Send emails using links in a report Introduction to IBM Cognos Active Reports Examine Active Report controls and variables Create a simple Active Report using Static and Data-driven controls Change filtering and selection behavior in a report Create interaction between multiple controls and variables Active Report charts and decks Create an Active Report with a Data deck Use Master detail relationships with Decks Optimize Active Reports Create an Active Report with new visualizations