806 Business Analytics & Intelligence courses

Course overview Financial analysis is a crucial part of a successful business. It helps companies to make informed decisions regarding investing. Learn how to make a practical analysis of financial statements with this Financial Statement Analysis Masterclass program.  This Financial Statement Analysis Masterclass course explains the steps involved in a practical financial statement analysis in detail. It will also educate you on the importance of financial accounting in businesses. Going through the lesson, you will develop a comprehensive understanding of GAAP rules, correct timing, earnings management and financial valuation. In addition, you will understand the importance and purpose of executive compensation and identify its major components. You will also learn how to prepare and analyze a balance sheet and the steps to prepare a cash flow statement.  Learning outcomes Explore the steps to an effective financial analysis Understand the GAAP requirements for creating financial statements Deepen your understanding of earnings management Learn about applying ratios Deepen your understanding of owner's equity Know how to prepare a cash flow statement Who Is This Course For? This Financial Statement Analysis Masterclass course is highly beneficial for anyone interested in learning the steps for an effective financial statement analysis. In addition, the skills gained from this training will provide excellent opportunities for career advancement.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £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 and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Financial Statement Analysis Masterclass 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: Financial Analyst Financial Advisor Financial Planning Analysis Manager Financial and Management Accountant Introduction to the Course Introduction 00:02:00 Module 01: Why Analyse Financial Statements? Why Analyse Financial Statements? 00:10:00 Module 02: GAAP Rules GAAP Rules 00:10:00 Module 03: Correct Timing Correct Timing 00:15:00 Module 04: Earnings Management Earnings Management 00:11:00 Module 05: Balance Sheet Balance Sheet 00:11:00 Module 06: Balance Sheet Part-2 Balance Sheet Part-2 00:11:00 Module 07: Balance Sheet Part-3 Balance Sheet Part-3 00:07:00 Module 08: Statement of Cash Flow Statement of Cash Flow 00:07:00 Module 09: Time Series Time Series 00:11:00 Module 10: Ratios- Introduction Ratios- Introduction 00:16:00 Module 11: Applying Ratios Applying Ratios 00:19:00 Module 12: Valuation Valuation 00:14:00 Module 13: Credits Credits 00:07:00 Module 14: Contracts Contracts 00:10:00 Module 15: Executive Compensation Executive Compensation 00:12:00 Module 16: Lease Lease 00:08:00 Module 17: Owners' Equity Owners' Equity 00:07:00 Module 18: Earnings Per Share Earnings Per Share 00:16:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

This course starts with data transformation strategies, exploring capabilities in the Power Query Editor, and data-cleansing practices. It looks at the Advanced Query Editor to view the M language code. This course focuses on advanced DAX measures that include filtering conditions, with a deep dive into time intelligence measures. Like the M query language, DAX is a rich functional language that supports variables and expression references. This course also looks at the creation of dynamic dashboards and incorporates a range of visualisations available in Power BI Desktop and online in the AppSource. The course finishes with a look at setting up end user level security in tables. 1 The query editor Split by row delimiter AddDays to determine deadlines Advanced query editor 2 Fuzzy matching joins Matching inconsistencies by percentage Matching with transformation table 3 Logical column functions Logical functions IF, AND, OR Using multiple conditions Including FIND in functions 4 Editing DAX measures Make DAX easier to read Add comments to a measure Using quick measures 5 The anatomy of CALCULATE Understanding CALCULATE context filters Adding context to CALCULATE with FILTER Using CALCULATE with a threshold 6 The ALL measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentage 7 DAX iterators Anatomy of iterators A closer look at SUMX Using RELATED in SUMX Create a RANKX RANKX with ALL 8 Date and time functions Overview of functions Create a DATEDIFF function 9 Time intelligent measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 10 Visualisations in-depth Utilising report themes Create a heatmap Comparing proportions View trends with sparklines Group numbers using bins Setting up a histogram 11 Comparing variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint 12 User level security Setting up row level security Testing user security

This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

Data Entry Administrator Diploma with Transcription and Translation Diploma Welcome to the Data Entry Administrator Diploma with Transcription and Translation. This multifaceted course aims to provide you with comprehensive skills in data entry, alongside a specialised focus on Transcription and Translation. The demand for professionals who can provide accurate and fast transcription and translation services is rapidly growing. This course prepares you to meet that demand head-on. Learning Outcomes: Gain foundational knowledge in Transcription basics. Understand the role of context in Transcription. Attain skills to improve Transcription accuracy. Master the tools used in Transcription and Translation. Acquaint yourself with the translation industry's dynamics. Develop strategies for effective translation. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Data Entry Administrator Diploma with Transcription and Translation Diploma: Basics of Transcription: Begin your journey by understanding the fundamentals of Transcription, the cornerstone for developing specialised skills in the field. Context in Transcription: Here, you'll delve into the nuances of context, learning how it influences the accuracy and effectiveness of Transcription. Transcription Accuracy: Accuracy is paramount in Transcription. This module will equip you with techniques to enhance your Transcription accuracy. Tools in Transcription: This module introduces you to the tools integral to Transcription, from software to hardware, to optimise your workflow. Translation Industry in the Realm of Transcription: An essential overview of the translation industry, explaining how Transcription skills can be effectively utilised within it. Translation Strategies Complementing Transcription: Finalize your training by learning the best strategies for translating content in a manner that complements your Transcription skills.

Preparing for Digital Transformation: Virtual In-House Training Organizations today must keep pace with changing technology to stay abreast of the market demand. Keeping pace means a transformation of the entire organization into the digital age. This workshop presents the challenges, benefits, and pitfalls of digital transformation and how it will affect you, and how you can be better prepared and positioned for the upcoming digital transformation. The goal of this course is to enable you to become knowledgeable about the technologies behind a digital transformation in your organization and the driving forces compelling such a transformation. You will learn how to become engaged in the processes of transforming your organization digitally to meet with the growing demands of customers and clients What you will Learn Describe the impact that digital is making on the economy and on customer expectations Examine the nature and drivers of the digital transformation Evaluate new technologies such as Blockchain, Big Data, Artificial Intelligence, and other technologies and see how they work to bring about digital transformation Assess the impact of digital technologies on the current roles and positions in the organization Discuss both the demand that customers have for digital technologies and the impact the digital technologies have on the customer and its relationship with the organization Recognize the new technology trends in the digital transformation and what they mean to the future of the organization Identify how digital transformation will affect all roles and how to be prepared for the upcoming and continuing digital transformation Foundation Concepts Digital transformation versus automation Driving forces behind the digital transformation Learning from digital transformation successes Digital Transformation and Customer Orientation The Digital Customer Customer touch points and the customer journey Omnichannel concept Transform to the customer Digital Technologies and the Organization Relationship Management Big Data: The Basis for it All The Human Factor in Digital Transformations Risks of Digital Transformation Technology Trends Data and Business Analytics Other Major Trends Preview of Coming Attractions Pathway to Digital Transformation

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Register on the Excel PowerQuery and PowerPivot today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Excel PowerQuery and PowerPivot is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Excel PowerQuery and PowerPivot Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Excel PowerQuery and PowerPivot, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Excel PowerQuery and PowerPivot pivot table power query power pivot - 1 00:09:00 pivot table power query power pivot - 2 00:01:00 pivot table power query power pivot - 3 00:02:00 pivot table power query power pivot - 4 00:03:00 pivot table power query power pivot - 5 00:01:00 pivot table power query power pivot - 6 00:04:00 pivot table power query power pivot - 7 00:08:00 pivot table power query power pivot - 8 00:05:00 pivot table power query power pivot - 9 00:03:00 pivot table power query power pivot - 10 00:04:00 pivot table power query power pivot - 11 00:04:00 pivot table power query power pivot - 12 00:02:00 pivot table power query power pivot - 13 00:03:00 pivot table power query power pivot - 14 00:05:00 pivot table power query power pivot - 15 00:02:00 pivot table power query power pivot - 16 00:03:00 pivot table power query power pivot - 17 00:03:00 pivot table power query power pivot - 18 00:08:00 pivot table power query power pivot - 19 00:02:00 pivot table power query power pivot - 20 00:04:00 pivot table power query power pivot - 21 00:05:00 pivot table power query power pivot - 22 00:09:00 pivot table power query power pivot - 23 00:04:00 pivot table power query power pivot - 24 00:03:00 pivot table power query power pivot - 25 00:04:00 pivot table power query power pivot - 26 00:09:00 Resources Resources - Excel PowerQuery And PowerPivot 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Overview This comprehensive course on Business Analystics for Beginners Using SASS will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Business Analystics for Beginners Using SASS comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Business Analystics for Beginners Using SASS. It is available to all students, of all academic backgrounds. Requirements Our Business Analystics for Beginners Using SASS is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 13 sections • 73 lectures • 08:10:00 total length •SAS Introduction: 00:07:00 •Introduction to SAS Program: 00:05:00 •Read SAS Dataset: 00:09:00 •Practice Read Dataset: 00:08:00 •Practical Example on Read Dataset: 00:02:00 •Introduction to SAS Dataset: 00:12:00 •SAS Dataset Practical Example: 00:07:00 •SAS Dataset Practical Program: 00:06:00 •DateValue: 00:03:00 •SAS Formats Part 1: 00:13:00 •SAS Formats Part 2: 00:09:00 •Reading Excel Worksheets: 00:05:00 •Reading Excel Worksheet Example: 00:11:00 •Date Format Example: 00:06:00 •Raw Data File Standard Part 1: 00:09:00 •Raw Data File Standard Part 2: 00:08:00 •Raw Data File Standard Example: 00:06:00 •Raw Data File Non Standard: 00:07:00 •Raw Data File Non Standard Example: 00:06:00 •Length Statement: 00:02:00 •Compilation Execution: 00:04:00 •Heading: 00:01:00 •Dataerrors: 00:05:00 •Data Errorsz Example: 00:03:00 •Validate Data Procfreq: 00:05:00 •Validate Data Procpront: 00:07:00 •Validate Data Peocmeans: 00:05:00 •Dat Constant: 00:07:00 •Assignment Statement: 00:09:00 •If Then Statement: 00:09:00 •If Then Do End Statement: 00:09:00 •Diff Where and If Statement: 00:02:00 •Keep Drop: 00:08:00 •Keep Drop Example: 00:04:00 •Append: 00:09:00 •Append Examples part 1: 00:09:00 •Append Examples part 2: 00:07:00 •Concatenate: 00:12:00 •Merge: 00:06:00 •Merge One to One: 00:07:00 •Merge One to Many: 00:04:00 •Merge Non Match: 00:04:00 •Global Statements: 00:09:00 •Global Statements Examples Part 1: 00:08:00 •Global Statements Examples Part 2: 00:06:00 •Title n Foot Note: 00:05:00 •Title n Foot Note Example: 00:08:00 •By Statement: 00:08:00 •Multiple Where Stament: 00:03:00 •ODS: 00:07:00 •ODS Example: 00:04:00 •Sas Date Function: 00:10:00 •Sas Date Function Example: 00:08:00 •Sas Functions Part 1: 00:10:00 •Sas Functions Part 2: 00:08:00 •Sas Functions: 00:07:00 •Sas Functions Example Part 1: 00:07:00 •Sas Functions Example Part 2: 00:09:00 •Multiple SAS Datasets Part 1: 00:05:00 •Multiple SAS Datasets Part 2: 00:02:00 •Multiple SAS Datasets Example: 00:09:00 •Select Group: 00:09:00 •Select Group Example: 00:08:00 •Do Loop Part 1: 00:07:00 •Do Loop Part 2: 00:06:00 •Do Loop Example: 00:07:00 •Array Part 1: 00:05:00 •Array Part 2: 00:08:00 •Array DoLoop: 00:06:00 •ArrayTemp: 00:05:00 •Array Example: 00:10:00 •Sas Statement Part 1: 00:04:00 •Sas Statement Part 2: 00:05:00