557 Business Analytics & Intelligence courses

This 3 day Tableau Desktop Advanced Training course is designed for professionals who have been working with Tableau for some time and are looking to dive deeper and learn analytical use cases that utilise Tableaus advanced features. It is also a perfect refresher course if you want to upgrade your skills to the latest features. -------------------------------------------------------------------------------- Public Course Options EXTEND YOUR KNOWLEDGE OF TABLEAU IN THIS HANDS-ON COURSE TRAINING £1,195 per person + VAT 3 Day live virtual course 12 Months access to online course -------------------------------------------------------------------------------- This 3 day Tableau Desktop Advanced Training course is designed for the professional who has been working with Tableau for some time and is looking to dive deeper. You will review all calculation types and apply Table Calculations and Level of Detail Expressions in multiple use cases. You will also learn advanced techniques for analysing time series data, cohorts and survey data. You will learn advanced mapping and dashboard techniques to help improve the insights gained for your target audience. You will be introduced to the latest features together with practical use cases for getting the most benefit from them. Attendees should have a deep understanding of the fundamental concepts of building Tableau worksheets and dashboards and be comfortable with the techniques learnt in the Foundation and Analyst courses. At the end of this course you will be able to apply and combine some of the more complex capabilities and techniques that Tableau has to offer. In addition to our regular 2 day syllabus we have added an additional day so that we can add learning for many new features introduced into Tableau over the last couple of years. -------------------------------------------------------------------------------- LIVE COACHING AND Q&A ACCESS In addition to the 3 day live and interactive course, delegates also receive 6 weeks live access to our Coaching and Q&A calls that take place 3 times each week. Delegates have found these to be highly beneficial to enhance their learning experience as well as assisting with applying the learning from the course to practical working deliverables on their own data. THE COURSE INCLUDES THE FOLLOWING TOPICS: RECAP: CALCULATIONS * Review of Number Functions * Review of String Functions * Review of Date Functions * Review of Type Conversions * Review of Logical Functions * Review of Aggregate Functions * Alternatives to Calculations * 2 Hands-on exercises GETTING THE MOST FROM TABLE CALCULATIONS * What are and when to use Table Calculations * What Table Calculation Types are there? * Defining the Scope and Direction of calculations * Using Table Calculations in Calculated Fields * How do Filters work with Table Calculations? * 7 Hands-on exercises LODS - LEVEL OF DETAIL EXPRESSIONS * Overview * FIXED LOD * How do Filters work with LODs? * INCLUDE LOD * EXCLUDE LOD * Nesting LODs * Comparing the various Calculation Types * 5 Hands-on exercises ADVANCED TECHNIQUES FOR ANALYSING TIME-BASED DATA * Creating Sparklines * Creating Slope Charts * Creating Control Charts * Creating Bump Charts * 4 Hands-on exercises ANALYSING BEHAVIOURS IN DATA * Creating Cohort Analysis * Analysing Survey Data * 2 Hands-on exercises ADVANCED TECHNIQUES FOR MAPPING * Mapping Distance from a point * Normalising map areas with Hexbins * Combining Spatial & Data Files * 3 Hands-on exercises ADVANCED CONSIDERATIONS FOR DASHBOARDS * Identifying your Audience * Using Containers and Layout * Considerations for Dashboard Elements * Sheet swapping * Adding Dashboard Actions to Context * 2 Hands-on exercises -------------------------------------------------------------------------------- IN ADDITION TO THE REGULAR SYLLABUS WE WILL ALSO COVER THE FOLLOWING NEW FEATURES : * Viz in Tooltips * Set Actions * Parameter Actions * Show/Hide Containers * Animations * Dashboard Navigation Button * Replace Worksheet in a Dashboard (DB) * Show/Hide Sort Controls * Vector Maps * Customisable reference line tooltips * Automatic dashboard phone layouts * Export to PowerPoint * Transparent worksheet backgrounds * Density Mark Type (New Heatmap) * Dashboard Extensions * Step and Jump Lines * Dashboard Grids * Nested sorting improvements * Ask Data * Explain Data * Spatial Calculations * Negative values on log axis * Additional clustering functionality * Enhanced cross-database join control -------------------------------------------------------------------------------- This training course includes over 35 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. A comprehensive training manual is provided together with all the data, starter and solution Tableau Workbooks required for the training.  Students must use their own laptop with an active version of Tableau Desktop 2020.1 (or later) pre-installed. -------------------------------------------------------------------------------- WHAT PEOPLE ARE SAYING ABOUT THIS COURSE "Course was fantastic and completely relevant to the work I am doing with Tableau.  I particularly liked Steve's method of teaching and how he applied the course material to 'real-life' use-cases." Richard W., Dashboard Consulting Ltd "This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work." Lauren M., Baillie Gifford "I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I've learned into practice." Aron F., Grove & Dean "Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work." John B., Mporium

Tableau is an intuitive and simple tool to learn. This Tableau training course is a jumpstart to getting report writers and analysts who are self-taught or have no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in three days. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment. At the end of this course, you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. Our Tableau Desktop Fast Track course combines all of our Foundation (Fundamentals) and Analyst (Intermediate) content into a 3 day live online course with added access to online bonus content of 3 additional modules. Gathering Requirements, Bring Your Own Data and Engaging Users. -------------------------------------------------------------------------------- WHAT DO YOU GET? This course is delivered live virtually and has all material provided through our online portal, together with email support and live coaching sessions. The full program includes all of the following elements: * 3 days of live and interactive instructor-led sessions delivered by an expert Tableau Trainer * 6 weeks access to our live coaching program delivered by expert Tableau coaches * 50+ practical exercises to practice what you learn * 12 months access to video’s that walk you through the theory and exercise solutions * Practical advice, tools and resources for using Tableau in the real world * The three additional online modules provide: * Clarity on the approach to gathering dashboard requirements in a way that can be translated into dashboard designs. * An agile and iterative development process that delivers products that meet user needs more quickly and effectively. * An understanding of how end users will interact with dashboards to ensure that designers deliver actionable results. THE SYLLABUS PHASE 1: DESIGN MODULE 1: UNDERSTAND TABLEAU * What is possible * How does Tableau deal with data * Know your way around * Review of Type Conversions * How do we format charts * Dashboard basics – My first Dashboard MODULE 2: TRANSFORM DATA * Connecting to and setting up data in Tableau * Modifying data attributes * How Do I Structure my Data – Groups & Hierarchies, Visual Groups * How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates * How do I create calculated fields and why? – Creating Calculated Fields, Types of calculated fields, Row Level v Aggregations, Aggregating dimensions in calculations, Changing the Level of Detail (LOD) of calculations – What, Why, How MODULE 3: GATHER REQUIREMENTS(ONLINE CONTENT ONLY) * Brainstorm and assess possible priorities * Pitfalls to avoid * Gather requirements PHASE 2: DEVELOP MODULE 4: CREATE CHARTS * Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots * Showing progress over time * Creating Tables – Creating Tables, Highlight Tables, Heat Maps * Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps * Making things dynamic with parameters MODULE 5: COMBINE DATA * Relationships * Joining Tables – Join Types, Joining tables within the same database, cross database joins, join calculations * Blending – How to create a blend with common fields, Custom defined Field relationships and mismatched element names, Calculated fields in blended data sources * Unions – Manual Unions and mismatched columns, Wildcard unions * Data Extracts – Creating & Editing Data extracts MODULE 6: ANALYSE INFORMATION * Table Calculations * Sets, Reference Lines, Trends and Forecasting * Answering spatial questions – Mapping, Creating a choropleth (filled) map, Using your own images for spatial analysis, Mapping with spatial files * Advanced charts * Bar in Bar charts * Bullet graphs * Creating Bins and Histograms * Creating a Box & Whisker plot * Viz in Tooltips PHASE 3: DESIGN MODULE 7: BUILD DASHBOARDS * Using the Dashboard Interface * Device layouts * Dashboard Actions – Set actions, Parameter actions * Viz in Tooltips for Dashboards * Dashboard containers – Horizontal & Vertical containers, Hidden containers * Navigate between dashboards * Telling data driven stories MODULE 8: BRING YOUR OWN DATA * Design * Best Practices & Resources * Wireframe templates * Questions * Process * Start building and testing MODULE 9: EMPOWER STAKEHOLDERS * What is Tableau Server * Publishing & permissions * How can your users engage with content * The Tableau ecosystem * Review your progress * Your next steps -------------------------------------------------------------------------------- HOW MUCH OF YOUR TIME WILL THIS TAKE? Delegates are also provided 6 weeks access to our Tableau Coaching. We run Live Q&A sessions from 4pm-5pm on a Monday (Connecting to Data and Calculated Fields), 2pm-3pm Friday (Creating Charts) & 4pm-5pm Friday (Dashboard Design). The coaching helps delegates to transition from the theory of using Tableau to its practical use. We’d be expecting them to apply the exercises you’ll be doing during the course, onto your own data after the course. In our experience, this is the best way to increase both understanding and long term memory retention. The live coaching also acts as a troubleshooting platform for any practical issues that delegates need to overcome in the real world. Delegates also have 12 months access to all of the training material covered in the course in the form of an online portal (this includes theory videos, exercise solution videos, exercise materials and even quizzes). We have a growing LinkedIn community that delegates are encouraged to join and participate in. We regularly post useful blog posts and additional training that will enhance the Tableau journey and understanding. -------------------------------------------------------------------------------- We help teams using Tableau to transform in the following ways : * From a disjointed understanding of Tableau – To being familiar with Tableau terminology and capability * From ad-hoc data uploads and error prone calculations – To reusable data connections and robust metrics * From disjointed stakeholder questions – To clear and concise requirements that lead to decision making * From being unsure how difficult Tableau will be to learn – To being able to develop standard charts and tables in Tableau with dynamic reporting capabilities * From manually combining data for each analytical task – To dynamically combining data from multiple tables for analysis * From being unsure how to answer analytical questions and what options there are – To being equipped with multiple actionable, dynamic, analytical use cases * From not knowing Why, When and How to create Dashboards or Story’s – To being able to combine analysis to answer complex questions and tell data driven stories * From using demo data theory – To Delivering value [Answering questions] on their own data * From spending lots of time answering colleagues ad-hoc (data) questions – To empowering stakeholders in answering ad-hoc queries and reducing the time to analyse and steer the business

OVERVIEW -------------------------------------------------------------------------------- Data and visual analytics are emerging fields concerned with analysing, modelling, and visualizing complex high-dimensional data. It can be analysed and visualised with many languages like Python, R Programming and more. This course will help to attain the skills and give in-depth knowledge to the participant's enhanced way of modelling, analysing and visualizing techniques.  The course will highlight practical challenges including composite real-world data and will also comprise several practical studies

OVERVIEW Prerequisites—DIAD training or equivalent working experience This one-day course will cover Power BI report layouts and structure the agile process to creating Power BI data visualizations. It will help attendees to understand the art behind visualizations, the implications behind choosing the right charts, the impact of color, shape, and size, and finally the use of Power BI custom visuals. The course includes various design patterns of dashboards and reports, as well as best practices for authoring great reports and dashboards for business users. The course content is managed by the Power BI engineering team at Microsoft. There is no exam associated with the course. COURSE BENEFITS: * Understand the need for storytelling with data * Understand the agile process to creating Power BI data visualizations * Understand the art behind visualizations * Gain familiarity with Power BI report layouts and structure * Understand implications behind choosing the right charts * Gain familiarity with using Power BI custom visuals WHO IS THE COURSE FOR? * Power BI report developers who wish to improve the aesthetic quality of their reports * Power BI and other BI practitioners who would like to understand more about the theory of data visualization * BI practitioners who wish to create reports that communicate the meaning behind the data more clearly * Power BI users who would like to explore the types of chart and visual available that answer different types of business question COURSE OUTLINE Module 1 What Is Storytelling With Data? * Volume, Velocity and Variety * The importance of business questions * What is a story in this context? Module 2 The Science Behind Data Visualization * Basic problems to avoid * Memory and visualization * Ways to spark iconic, short-term and long-term memory Module 3 The Process Behind Data Visualization * Using an agile approach to report development * Data structure and data grain * Converting the story to a data model Module 4 Dashboards And Reports * Terminology and definitions * Dashboard layout and structure * Report layout and structure * Storyboarding * Drill-through, bookmarks, toggles and tooltips Module 5 Chart Selection * Charts for comparison * Time series * Proportions * Constructing effective tables, cards and slicers * Scatterplots Module 6 Accessibility And Custom Visuals * Report accessibility checklists * Custom visuals * Creating a custom R visual * Charticulator Module 7 Publishing And Formatting * Colour schemes * Making a Power BI theme * Use of fonts, icons and symbols * Sizing dashboard and report tiles * Sparklines, hyperlinks and images Module 8 Report Authoring - Best Practices * Design thought process * The audience * Defining the platform environment * The user experience * Visualization * Implementation and testing * Optimization Module 9 Dashboard And Goals Design * Tips and tricks * Best practices for dashboard design * Tracking business metrics with goals

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

OVERVIEW -------------------------------------------------------------------------------- Objective * Understanding the Importance of Business Analysis Model * Determining various techniques of Process Modelling * Understanding the scope of modelling * Efficiently mapping the business landscape * Analysing the enterprise structure * How to avoid project failures. * Learning efficient skills of being a successful business analyst. * Understand and document various techniques for the organization delivers value. * Successful project conversion * Building team, changing the organization and overcoming resistance. * Creating an effective Business Case.

The Business Analyst Program: A Career Launchpad for the Future Business Analysis is the process of identifying business needs, defining solutions, and implementing changes to achieve strategic goals. It involves identifying opportunities for improvement, evaluating alternatives, and recommending solutions. Business analysts play a critical role in ensuring that organisations operate effectively and efficiently. They work closely with stakeholders to identify business needs, and then work to find solutions that meet those needs while also staying within budget and timelines. The Business Analysis course is designed to equip students with the skills and knowledge necessary to become successful business analysts. The course covers a range of topics, including business processes, strategic analysis, solution evaluation, stakeholder management, and process improvement. By the end of the course, students will have a solid understanding of what it takes to be a successful business analyst. If you're looking for a career in IT, the Business Analyst Program is the perfect place to start. This program will provide you with the skills and knowledge you need to become a successful Business Analyst. In addition to the training, you'll also receive career mentoring and support. Our experienced career counsellors will help you develop your resume, write cover letters, and practice your interviewing skills. They'll also connect you with potential employers and help you land your dream job. The Business Analyst Program is the perfect way to launch your career in IT. We will help you until you find a job, so you won't have to worry about anything. Just gain knowledge and learn skills, getting you a job is our duty. With our comprehensive training and career support, you'll be well on your way to a successful and rewarding career in this exciting field. Don't miss your chance to join the Business Analyst Program! Apply today! Our mission is simple: To be your trusted partner and assist you every step of the way until you land the job of your dreams. Why Choose Us Here's what makes our Business Analyst Training stand out from the crowd: * Personalised Job Search Assistance: We're in this together! Our dedicated team will work tirelessly to support your entire job searching process. From crafting a standout resume to submitting it to top companies, we'll ensure you have a compelling application that gets noticed. * Expertly Crafted CV: Your resume is your ticket to the interview room. Our professional resume writers will create a customised CV highlighting your unique skills and experiences. This will maximise your chances of standing out among the competition. * Strategic Placement: We understand the power of casting a wide net. We'll strategically submit your CV to various platforms and networks, expanding your reach and connecting you with valuable opportunities that align with your career goals. * One-On-One Consultation Sessions with Industry Experts: Gain invaluable insights and guidance from seasoned professionals who have thrived in the Business Analysis field. Our consultation sessions provide you with insider tips, tricks, and advice, empowering you to navigate the industry with confidence and expertise. * Comprehensive Skill Development: Our program is designed to equip you with the most sought-after skills in the Business Analysis sector. From mastering cutting-edge tools to honing your skills, we'll ensure you have the knowledge and expertise to excel in any IT-driven environment. * Ongoing Support: We understand that the journey to landing your dream job doesn't end with placement. That's why our commitment to your success extends well beyond your initial training. Our support team will be available to answer your questions, provide guidance, and assist you as you progress in your career. Here are the 6 courses we will provide once you enrol in the program: * Course 01: Business Analysis Strategy and Evaluation * Course 02: The Business Intelligence Analyst Course * Course 03: Business English and Communication Skills * Course 04: Economics * Course 05: Business Law * Course 06: Financial Analysis Methods These courses will help you to develop your knowledge and skills to become a successful Business Analyst. The Program is completed in 5 easy steps: Step 1 - Enrol in the program and start learning from the courses we provide After you enrol in this Business Analyst Program, you will get lifetime access to 6 premium courses related to Business Analysis. These courses will teach you the knowledge and skills required to become a successful Business Analyst. Our customer service team will help you and keep in contact with you every step of the way. Step 2 - Complete your courses and get certifications After learning from the courses, you must obtain certificates for each course. There will be exams for every course, and you have to pass them to get your certificate. To pass successfully, you must get 90% marks for the first course and 80% for the rest of the relevant courses. Once you pass the exams, you will receive hardcopy certificates. These certificates will prove that you're an expert in the subject. Step 3 - Get a consultation session from a professional Business Analyst Take your Business Analysis skills to new heights with a one-on-one consultation session led by a seasoned professional. Gain invaluable insights, expert tips, and tailored advice that will propel your career forward. Step 4 - Complete the CV and attend the interview Once you've successfully obtained the certifications, our team of professionals will build you a compelling CV and LinkedIn profile. With these powerful tools in hand, you'll be fully prepared to tackle job interviews confidently. Kickstart your Business Analysis career with a starting salary ranging from •30,000 to •50,000 annually. Step into the IT industry with the assurance of a promising future. Step 5 - We will not leave you until you get a job Our commitment to your success goes above and beyond. We won't stop until you land that dream job. With personalised support, expert guidance, and unwavering dedication, we'll be by your side until you secure the perfect opportunity. Your job search becomes our mission, ensuring you have the best chance at a successful career in Business Analysis. Don't let your dream career as a Business Analyst remain out of reach. You just have to learn and gain knowledge and skills. Finding a job is our task! We will remove most of your worries and help you focus on only developing your skills. So join our Business Analyst Training Program today, and let us be your trusted partner on your journey to success. CPD 100 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? This Business Analyst Training program is ideal for: * Aspiring IT professionals looking to launch a career in Business Analysis. * Individuals with a passion for technology and problem-solving who lack experience in the IT industry. * Recent graduates or career changers seeking comprehensive mentoring and support in theBusiness Analysis field. * Those who desire personalised guidance and one-on-one counselling to navigate the complexities of the IT job market. * Individuals who want to build a strong foundation in Business Analysis and secure job opportunities with the help of industry experts. REQUIREMENTS No experience required. Just enrol & start learning. CAREER PATH Embark on a rewarding career as an Business Analyst in the UK. Gain valuable experience and certifications while providing essential technical support to organisations. Progress into roles such as Administrative Manager,Program Manager, Business Manager,Business Management Analyst, with opportunities for growth and advancement. CERTIFICATES CPD ACCREDITED E-CERTIFICATE Digital certificate - Included CPD ACCREDITED FRAMED (HARDCOPY) CERTIFICATE Hard copy certificate - Included ENROLMENT LETTER Digital certificate - Included STUDENT ID CARD Digital certificate - Included

BCS International Diploma in Business Analysis provides in-depth knowledge and skills related to business analysis and demonstrates that you have the necessary expertise to be successful in your field.

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.