150 Courses delivered Online

Dive into JavaScript with a focus on data visualization. Master JavaScript fundamentals, control flow, error handling, and client-side validations. Create engaging visual representations using Google Chart. Perfect for anyone looking to combine coding skills with visual analytics.

Level-7 QLS Endorsed | 22-in-1 Diploma Bundle| Free CPD PDF+ Transcript Certificate| Lifetime Access| Learner Support

Learning Outcomes After completing this course, learners will be able to: Learn Python for data analysis using NumPy and Pandas Acquire a clear understanding of data visualisation using Matplotlib, Seaborn and Pandas Deepen your knowledge of Python for interactive and geographical potting using Plotly and Cufflinks Understand Python for data science and machine learning Get acquainted with Recommender Systems with Python Enhance your understanding of Python for Natural Language Processing (NLP) Description Whether you are from an engineering background or not you still can efficiently work in the field of data science and the machine learning sector, if you have proficient knowledge of Python. Since Python is the easiest and most used programming language, you can start learning this language now to advance your career with the Data Science And Machine Learning Using Python : A Bootcamp course. This course will give you a thorough understanding of the Python programming language. Moreover, it will show how can you use Python for data analysis and machine learning. Alongside that, from this course, you will get to learn data visualisation, and interactive and geographical plotting by using Python. The course will also provide detailed information on Python for data analysis, Natural Language Processing (NLP) and much more. Upon successful completion of this course, get a CPD- certificate of achievement which will enhance your resume and career. Certificate of Achievement 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.  Method of Assessment After completing this course, you will be provided with some assessment questions. To pass that assessment, you need to score at least 60%. Our experts will check your assessment and give you feedback accordingly. Career Path After completing this course, you can explore various career options such as Web Developer Software Engineer Data Scientist Machine Learning Engineer Data Analyst In the UK professionals usually get a salary of £25,000 - £30,000 per annum for these positions. Course Content Welcome, Course Introduction & overview, and Environment set-up Welcome & Course Overview 00:07:00 Set-up the Environment for the Course (lecture 1) 00:09:00 Set-up the Environment for the Course (lecture 2) 00:25:00 Two other options to setup environment 00:04:00 Python Essentials Python data types Part 1 00:21:00 Python Data Types Part 2 00:15:00 Loops, List Comprehension, Functions, Lambda Expression, Map and Filter (Part 1) 00:16:00 Loops, List Comprehension, Functions, Lambda Expression, Map and Filter (Part 2) 00:20:00 Python Essentials Exercises Overview 00:02:00 Python Essentials Exercises Solutions 00:22:00 Python for Data Analysis using NumPy What is Numpy? A brief introduction and installation instructions. 00:03:00 NumPy Essentials - NumPy arrays, built-in methods, array methods and attributes. 00:28:00 NumPy Essentials - Indexing, slicing, broadcasting & boolean masking 00:26:00 NumPy Essentials - Arithmetic Operations & Universal Functions 00:07:00 NumPy Essentials Exercises Overview 00:02:00 NumPy Essentials Exercises Solutions 00:25:00 Python for Data Analysis using Pandas What is pandas? A brief introduction and installation instructions. 00:02:00 Pandas Introduction 00:02:00 Pandas Essentials - Pandas Data Structures - Series 00:20:00 Pandas Essentials - Pandas Data Structures - DataFrame 00:30:00 Pandas Essentials - Handling Missing Data 00:12:00 Pandas Essentials - Data Wrangling - Combining, merging, joining 00:20:00 Pandas Essentials - Groupby 00:10:00 Pandas Essentials - Useful Methods and Operations 00:26:00 Pandas Essentials - Project 1 (Overview) Customer Purchases Data 00:08:00 Pandas Essentials - Project 1 (Solutions) Customer Purchases Data 00:31:00 Pandas Essentials - Project 2 (Overview) Chicago Payroll Data 00:04:00 Pandas Essentials - Project 2 (Solutions Part 1) Chicago Payroll Data 00:18:00 Python for Data Visualization using matplotlib Matplotlib Essentials (Part 1) - Basic Plotting & Object Oriented Approach 00:13:00 Matplotlib Essentials (Part 2) - Basic Plotting & Object Oriented Approach 00:22:00 Matplotlib Essentials (Part 3) - Basic Plotting & Object Oriented Approach 00:22:00 Matplotlib Essentials - Exercises Overview 00:06:00 Matplotlib Essentials - Exercises Solutions 00:21:00 Python for Data Visualization using Seaborn Seaborn - Introduction & Installation 00:04:00 Seaborn - Distribution Plots 00:25:00 Seaborn - Categorical Plots (Part 1) 00:21:00 Seaborn - Categorical Plots (Part 2) 00:16:00 Seborn-Axis Grids 00:25:00 Seaborn - Matrix Plots 00:13:00 Seaborn - Regression Plots 00:11:00 Seaborn - Controlling Figure Aesthetics 00:10:00 Seaborn - Exercises Overview 00:04:00 Seaborn - Exercise Solutions 00:19:00 Python for Data Visualization using pandas Pandas Built-in Data Visualization 00:34:00 Pandas Data Visualization Exercises Overview 00:03:00 Panda Data Visualization Exercises Solutions 00:13:00 Python for interactive & geographical plotting using Plotly and Cufflinks Plotly & Cufflinks - Interactive & Geographical Plotting (Part 1) 00:19:00 Plotly & Cufflinks - Interactive & Geographical Plotting (Part 2) 00:14:00 Plotly & Cufflinks - Interactive & Geographical Plotting Exercises (Overview) 00:11:00 Plotly & Cufflinks - Interactive & Geographical Plotting Exercises (Solutions) 00:37:00 Capstone Project - Python for Data Analysis & Visualization Project 1 - Oil vs Banks Stock Price during recession (Overview) 00:15:00 Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 1) 00:18:00 Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 2) 00:18:00 Project 1 - Oil vs Banks Stock Price during recession (Solutions Part 3) 00:17:00 Project 2 (Optional) - Emergency Calls from Montgomery County, PA (Overview) 00:03:00 Python for Machine Learning (ML) - scikit-learn - Linear Regression Model Introduction to ML - What, Why and Types.. 00:15:00 Theory Lecture on Linear Regression Model, No Free Lunch, Bias Variance Tradeoff 00:15:00 scikit-learn - Linear Regression Model - Hands-on (Part 1) 00:17:00 scikit-learn - Linear Regression Model Hands-on (Part 2) 00:19:00 Good to know! How to save and load your trained Machine Learning Model! 00:01:00 scikit-learn - Linear Regression Model (Insurance Data Project Overview) 00:08:00 scikit-learn - Linear Regression Model (Insurance Data Project Solutions) 00:30:00 Python for Machine Learning - scikit-learn - Logistic Regression Model Theory: Logistic Regression, conf. mat., TP, TN, Accuracy, Specificityetc. 00:10:00 scikit-learn - Logistic Regression Model - Hands-on (Part 1) 00:17:00 scikit-learn - Logistic Regression Model - Hands-on (Part 2) 00:20:00 scikit-learn - Logistic Regression Model - Hands-on (Part 3) 00:11:00 scikit-learn - Logistic Regression Model - Hands-on (Project Overview) 00:05:00 scikit-learn - Logistic Regression Model - Hands-on (Project Solutions) 00:15:00 Python for Machine Learning - scikit-learn - K Nearest Neighbors Theory: K Nearest Neighbors, Curse of dimensionality . 00:08:00 scikit-learn - K Nearest Neighbors - Hands-on 00:25:00 scikt-learn - K Nearest Neighbors (Project Overview) 00:04:00 scikit-learn - K Nearest Neighbors (Project Solutions) 00:14:00 Python for Machine Learning - scikit-learn - Decision Tree and Random Forests Theory: D-Tree & Random Forests, splitting, Entropy, IG, Bootstrap, Bagging. 00:18:00 scikit-learn - Decision Tree and Random Forests - Hands-on (Part 1) 00:19:00 scikit-learn - Decision Tree and Random Forests (Project Overview) 00:05:00 scikit-learn - Decision Tree and Random Forests (Project Solutions) 00:15:00 Python for Machine Learning - scikit-learn -Support Vector Machines (SVMs) Support Vector Machines (SVMs) - (Theory Lecture) 00:07:00 scikit-learn - Support Vector Machines - Hands-on (SVMs) 00:30:00 scikit-learn - Support Vector Machines (Project 1 Overview) 00:07:00 scikit-learn - Support Vector Machines (Project 1 Solutions) 00:20:00 scikit-learn - Support Vector Machines (Optional Project 2 - Overview) 00:02:00 Python for Machine Learning - scikit-learn - K Means Clustering Theory: K Means Clustering, Elbow method .. 00:11:00 scikit-learn - K Means Clustering - Hands-on 00:23:00 scikit-learn - K Means Clustering (Project Overview) 00:07:00 scikit-learn - K Means Clustering (Project Solutions) 00:22:00 Python for Machine Learning - scikit-learn - Principal Component Analysis (PCA) Theory: Principal Component Analysis (PCA) 00:09:00 scikit-learn - Principal Component Analysis (PCA) - Hands-on 00:22:00 scikit-learn - Principal Component Analysis (PCA) - (Project Overview) 00:02:00 scikit-learn - Principal Component Analysis (PCA) - (Project Solutions) 00:17:00 Recommender Systems with Python - (Additional Topic) Theory: Recommender Systems their Types and Importance 00:06:00 Python for Recommender Systems - Hands-on (Part 1) 00:18:00 Python for Recommender Systems - - Hands-on (Part 2) 00:19:00 Python for Natural Language Processing (NLP) - NLTK - (Additional Topic) Natural Language Processing (NLP) - (Theory Lecture) 00:13:00 NLTK - NLP-Challenges, Data Sources, Data Processing .. 00:13:00 NLTK - Feature Engineering and Text Preprocessing in Natural Language Processing 00:19:00 NLTK - NLP - Tokenization, Text Normalization, Vectorization, BoW. 00:19:00 NLTK - BoW, TF-IDF, Machine Learning, Training & Evaluation, Naive Bayes 00:13:00 NLTK - NLP - Pipeline feature to assemble several steps for cross-validation 00:09:00 Resources Resources - Data Science and Machine Learning using Python : A Bootcamp 00:00:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 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.

Dive deep into the world of spreadsheet mastery with our 'Data Analysis, Automating and Visualisation in Excel' course. This comprehensive programme takes you on a transformative journey from the rudiments of worksheet modifications to the advanced arts of data forecasting. Within each module, you'll unveil the secrets behind efficient list management, compelling visualisations, and the magic of PivotTables, among many other features. Moreover, automation isn't left behind; it's the heart and soul, making your workbook a living entity that breathes efficiency. By the end, you'll not only be fluent in Excel's vast toolkit but also possess the flair to present data in engaging, insightful ways. Learning Outcomes: Master the art of efficient worksheet modification and effective list management. Harness the power of data analysis tools to make informed decisions. Craft compelling visuals using charts, Sparklines, and data mapping techniques. Implement PivotTables and PivotCharts to dissect complex data sets effortlessly. Automate workbook functionalities for optimised and streamlined processes.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/03/Data-Analysis-Automating-and-Visualisation-in-Excel.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why buy this Data Analysis, Automating and Visualisation in Excel? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Data Analysis, Automating and Visualisation in Excel Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience Who is this Data Analysis, Automating and Visualisation in Excel course for? Individuals looking to enhance their data visualisation and analysis prowess. Managers wanting a streamlined approach to handling large datasets. Academic researchers aiming to present their data in a more compelling format. Finance professionals seeking efficient ways to dissect and forecast financial data. Marketing strategists aiming to leverage data for improved decision-making. Career path Data Analyst: £30,000 - £50,000 per annum Financial Analyst: £35,000 - £55,000 per annum Market Research Analyst: £28,000 - £45,000 per annum Business Intelligence Analyst: £32,000 - £56,000 per annum Operations Analyst: £30,000 - £52,000 per annum Research Scientist (Data-oriented): £35,000 - £60,000 per annum Prerequisites This Data Analysis, Automating and Visualisation in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis, Automating and Visualisation in Excel 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Assignment Assignment - Data Analysis, Automating and Visualisation in Excel 00:00:00

**Be prepared for the upcoming Hiring Season by enhancing your professional skillsets with Apex Learning! Get Hard Copy + PDF Certificate + Transcript + Student ID Card as a Gift - Enrol Now** Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Financial Advisor and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all in one Financial Advisor bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Financial Advisor course that will enhance your skills and prepare you for the competitive job market. Also, our Financial Advisor experts are available for answering your queries and help you along your learning journey. Advanced audiovisual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Financial Advisor, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Financial Advisor Bundle Consists of the following Premium courses: Course 01: Financial Advisor Course 02: Financial Management Course 03: Investment Course 04: Capital Budgeting & Investment Decision Rules Course 05: Budgeting and Forecasting Course 06: Level 3 Tax Accounting Course 07: Team Management Course 08: Intermediate Economics Level 3 Course 09: Internal Audit Training Diploma Course 10: Forex Trading Level 3 Course 11: Stock Market Investing for Beginners Course 12: Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 13: Commercial Law 2021 Course 14: Level 2 Microsoft Office Essentials Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 14 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum of Bundle Course 01: Financial Advisor Introduction to Finance Essential Skill Financial Planning Financial Risk Management and Assessment Investment Planning Divorce Planning Google Analytics and many more.... Course 02: Financial Management Introduction to Financial Management Fundamentals of Budgeting The Balance Sheet The Income Statement The Cash Flow Statement Statement of Stockholders' Equity Analysing and Interpreting Financial Statements International Aspects of Financial Management and many more.... Course 03: Investment Introduction to Investment Types and Techniques of Investment Key Concepts in Investment Understanding the Finance Investing in Bond Market Investing in Stock Market Risk and Portfolio Management and many more.... Course 04: Capital Budgeting & Investment Decision Rules Introduction NPV Method Payback Period Method Internal Rate of Return (IRR) Evaluating Projects in Different Lives Conclusion and many more.... Course 05: Budgeting and Forecasting Introduction Why Budget and Forecasts Is budget planning a paper exercise Operational and Financial Budget Detail Budget Requirement Components - Revenue Budgets Components - Cost Budget Qualitative Aspects Process of Making Budget Process of Budgeting - Logical Steps Example we used in Class to demonstrate a broad process in budget and planning Cost Budget Process - Other aspects and many more.... Course 06: Level 3 Tax Accounting Tax System and Administration in the UK Tax on Individuals National Insurance Fundamentals of Income Tax Payee, Payroll and Wages Value Added Tax Corporation Tax Double Entry Accounting Management Accounting and Financial Analysis Career as a Tax Accountant in the UK and many more.... Course 07: Presenting Financial Information Presenting Financial Information The Hierarchy of Performance Indicators The Principle of Effective Reports Methods of Presenting Performance Data The Pareto Chart: Highlighting Priorities Exercise: The Control Chart An Example Management Report Interpreting Performance Data Supporting Colleagues by Giving Feedback Data Visualisation Part 01, Part 02, Part 03, Part 04 and many more.... Course 08: Intermediate Economics Level 3 An Introduction to Economics The Market System and the Circular Flow Model Supply, Demand and Prices Prices Elasticity Market Failures Production and Costs Money, Banking and the Financial System Measuring GDP and Economic Growth Unemployment Inflation Income Distribution and Poverty International Finance Fiscal Policy and many more.... Course 09: Internal Audit Training Diploma Auditing as a Form of Assurance Internal Audit Procedures Technology-based Internal Audit Audit Interviews Reporting Audit Outcome UK Internal Audit Standards Career as an Auditor and many more.... Course 10: Forex Trading Level 3 Introduction to Forex Trading Kinds of Foreign Exchange Market Money Management Fundamental Analysis Technical Analysis Pitfalls and Risks Managing Risk and many more.... Course 11: Stock Market Investing for Beginners Module 01: Introduction to the Course Module 02: Introduction to Stocks Module 03: Money Required for Primary Investment Module 04: Opening an Investment Account Module 05: Brokerage Account Walkthrough Module 06: Finding Winning Stocks Module 07: Earning from Dividends Module 08: Diversifying Portfolio Module 09: Investment Plan Module 10: Rebalancing Portfolio Module 11: Understanding Order Types Module 12: Investment Tax Module 13: Investment Rules: Rule-1, 2, 3, 4, 5 Module 14: Stock Market Dictionary Module 15: Setting Up the Trading Platform Course 12: Fraud Management & Anti Money Laundering Awareness Complete Diploma Introduction to Money Laundering Proceeds of Crime Act 2002 Risk-based Approach Customer Due Diligence Record Keeping Suspicious Conduct and Transactions Awareness and Training and many more.... Course 13: Commercial Law 2021 Introduction of Commercial law Sales of Goods Law Consumer Law and Protection E-Commerce Law Competition Law and many more.... Course 14: Level 2 Microsoft Office Essentials Excel 2016 Getting Started with Microsoft Office Excel 2016 Performing Calculations Modifying a Worksheet Printing Workbooks Managing Workbooks Word 2016 Getting Started with Word Working More Efficiently Managing Lists Inserting Graphic Objects Controlling Page Appearance Preparing to Publish a Document Workbooks - Microsoft Word 2016 (Beginner) PowerPoint 2016 Presentation Basics Inserting Options Working with Objects Access 2016 Introduction to Access Access Forms Working with Reports and many more.... CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Financial Advisor bundle. Requirements Our Financial Advisor course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Financial Advisor expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Financial Advisor) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Financial Advisor) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Course Overview: According to a report by the World Economic Forum, data analysts and scientists are among the top emerging job roles. The "Data Analytics with Tableau" course is tailored to equip learners with the vital skills required to excel in this dynamic field. The course delves into the intricacies of data visualisation and analysis using Tableau, a leading software in the industry. It's not merely about understanding data but transforming it into actionable insights that drive business decisions. The course is structured to provide a comprehensive understanding of various aspects of data analytics, including sales, HR, and shipping analytics.Don't miss this opportunity to advance your career with cutting-edge skills in data analytics. Enrol in "Data Analytics with Tableau" now and embark on a journey of professional growth and endless possibilities! Key Features of the Course: CPD Certificate: Upon completion, you will receive a prestigious Continuing Professional Development (CPD) certificate, recognised globally for enhancing your career prospects. 24/7 Learning Assistance: Our dedicated support team ensures you receive prompt assistance, providing a seamless learning experience. Who is This Course For? This course is tailored for individuals who aspire to become data analysts, business intelligence professionals, marketing strategists, or decision-makers seeking to leverage data effectively. No experience with Tableau or coding is required, making it accessible and engaging for beginners. What You Will Learn: Data Analytics with Tableau, This course covers a wide range of topics, starting with connecting and preparing data, where you will learn how to import, clean, and transform data to make it analysis-ready within Tableau. Next, you will master the art of building insightful charts and visualisations using Tableau's rich set of tools, enabling you to communicate data trends and insights effectively. Additionally, you will explore the creation of captivating headline cards and interactive dashboards, gaining expertise in presenting key information and facilitating data exploration. Real-world projects, including Discount Mart, Green Destinations, Super Store, Northwind Trade, and Tesla, will provide you with outstanding experience in applying Tableau to solve practical data challenges. Lastly, you will develop a solid understanding of database concepts and learn to create compelling data stories using Tableau's storytelling features. By the end of this course, you will have the skills and confidence to make data-driven decisions and communicate insights effectively using Tableau. Why Enrol in This Course: Join the recently updated top-reviewed Data Analytics course with Tableau to keep you at the forefront of the field. Expand your analytical skills, unlock career opportunities, and stay current in the rapidly evolving world of data analytics by mastering Tableau, the industry-standard tool for visual analytics. Requirements: No prior experience with Tableau or coding is required. All you need is a computer with internet access, a curious mind, and a passion for exploring the world of data analytics. Career Path: By acquiring data analytics skills with Tableau, you open doors to exciting career paths, such as: Data Analyst (Average Salary: £35,000 - £45,000) Business Intelligence Analyst (Average Salary: £40,000 - £55,000) Marketing Analyst (Average Salary: £30,000 - £40,000) Financial Analyst (Average Salary: £35,000 - £50,000) Data Visualization Specialist (Average Salary: £40,000 - £60,000) Database Administrator (Average Salary: £40,000 - £55,000) Data Scientist (Average Salary: £45,000 - £70,000) Certification: Upon successful completion of the course, you will receive a CPD certificate, internationally recognised for its validation of your expertise in data analytics with Tableau. Enrol now and embark on a transformative journey to become a proficient data analyst and visualisation expert with Tableau! Course Curriculum 9 sections • 41 lectures • 06:47:00 total length •Introduction to the Course: 00:02:00 •What is Tableau? An Introduction to Tableau: 00:03:00 •How this course is Structured: 00:01:00 •Installing the Free Full Version of Tableau: 00:02:00 •Project Brief for Discount Mart: 00:03:00 •Connecting and Preparing Data for Discount Mart: 00:15:00 •Building Charts on Tableau for Discount Mart (Part 1): 00:33:00 •Building Charts on Tableau for Discount Mart (Part 2): 00:16:00 •Creating Headline Cards on Tableau for Discount Mart: 00:10:00 •Building and Publishing Dashboards on Tableau: 00:15:00 •Project Brief for Green Destinations: 00:02:00 •Connecting and Preparing Data for Green Destinations: 00:09:00 •Building Charts on Tableau (Part 1) for Green Destinations: 00:28:00 •Building Charts on Tableau (Part 2) for Green Destinations: 00:08:00 •Creating Headline Cards on Tableau: 00:15:00 •Building a Dashboard for Green Destinations: 00:12:00 •Publish your Dashboard to Tableau Public: 00:02:00 •Project Brief for Super Store: 00:02:00 •Connecting and Preparing Data for Super Store: 00:17:00 •Building Charts on Tableau (Part 1) for Super Store: 00:34:00 •Building Charts on Tableau (Part 2) for Super Store: 00:23:00 •Building a Dashboard: 00:18:00 •Publish your Dashboard to Tableau Public: 00:03:00 •Project Brief for Northwind Trade: 00:03:00 •Connecting and Preparing Data for Northwind Trade: 00:14:00 •Building Charts on Tableau for Northwind Trade: 00:37:00 •Building and Publishing Dashboards for Northwind Trade: 00:10:00 •Project Brief for Tesla: 00:02:00 •Creating a Data Source through Google Sheet Functions: 00:05:00 •Connect to the Data for Tesla: 00:04:00 •Building Charts on Tableau for Tesla: 00:22:00 •Building Headline Cards: 00:09:00 •Building a Tesla Dashboard: 00:08:00 •Publish your Dashboard to Tableau Public: 00:03:00 •Introduction to Database Concepts: 00:01:00 •Understanding Relational Databases: 00:04:00 •Relationships of Database Entities: 00:02:00 •Primary and Foreign Keys: 00:01:00 •Data types and Naming Conventions: 00:04:00 •Creating Stories on Tableau: 00:05:00 •Resources - Data Analytics with Tableau: 00:00:00

Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Earn Nicely, spend wisely, and you will live happily. Finance and investment bankers are the individuals who make 2+2=5 and get to keep the remaining 1 that's not really there. Our Finance & Investment Banking bundle will assist you in landing your dream job in Investment Banking. IPOs, Bonds, M&A, Trading, LBOs, Valuation: Everything is included in this 11-in-1 exclusive bundle. The demand for Finance and investment bankers is at an all-time high in the UK. Also, entry-level jobs in the banking and investment sector are among the best paid in the UK - you could be earning up to £50,000on starting. There may also be bonuses! So, enrol in our Finance & Investment Banking bundle to kickstart your career in this ever-growing sector and secure a better life! What Will You Learn from this Finance and Investment Banking Bundle: Acquire the ability to perform financial calculations and financial planning & management Get a detailed overview of investment and its key concepts, types & techniques Become fully aware of investment banking and its structure & valuation methods Learn capital budgeting, investment decision rules and budgeting & forecasting Gain knowledge of tax system & administration in the UK, tax return and the fundamentals of income tax Discover Forex trading, trading psychology and fundamental & technical analysis Gain an acute understanding of stock marketing, investing & trading, and investing in stocks to maximise returns Explore how to present financial information, principles of effective reports and data visualisation Fully understand fraud management, money laundering, AML, CDD and RBA Get comprehensive knowledge of various effective communication skills Along with this Finance & Investment Banking course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. What other courses are included with this Finance & Investment Banking? Course 1: Investment Course 2: Stock Market Investing for Beginners Course 3: Investment Banking Course 4: Capital Budgeting & Investment Decision Rules Course 5: Budgeting and Forecasting Course 6: Level 3 Tax Accounting Course 7: Forex Trading Level 3 Course8:Team Management Course 9: Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 10: Effective Communication Skills Diploma Enrol now in Finance & Investment Banking to advance your career, and use the premium study materials from Apex Learning. Benefits you'll get from choosing Apex Learning for this Finance & Investment Banking: Pay once and get lifetime access to 11 CPD courses in this Finance & Investment Banking Course Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the Finance & Investment Banking course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules of Finance & Investment Banking designed by expert instructors Learn at your ease - anytime, from anywhere Study the Finance & Investment Banking from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Curriculum of Finance & Investment Banking Bundle Course 1: Level 2 Financial Planning and Management Course Personal Finance Calculations Saving for Retirement Building Credit to Buy a Home Personal Finance Guides for Beginners Cashflow Management Budgets and Money Management Course 2: Investment Introduction to Investment Types and Techniques of Investment Key Concepts in Investment Understanding the Finance Investing in Bond Market Investing in Stock Market Risk and Portfolio Management Course 3: Stock Market Investing for Beginners Module 01: Introduction to the Course Module 02: Introduction to Stocks Module 03: Money Required for Primary Investment Module 04: Opening an Investment Account Module 05: Brokerage Account Walkthrough Module 06: Finding Winning Stocks Module 07: Earning from Dividends Module 08: Diversifying Portfolio Module 09: Investment Plan Module 10: Rebalancing Portfolio Module 11: Understanding Order Types Module 12: Investment Tax Module 13: Investment Rules: Rule-1 Module 14: Investment Rules: Rule-2 Module 15: Investment Rules: Rule-3 Module 16: Investment Rules: Rule-4 Module 17: Investment Rules: Rule-5 Module 18: Stock Market Dictionary Module 19: Setting Up the Trading Platform Course 4: Investment Banking Introduction to Investment Banking Structure and Side of Investment Banking Valuation Methods in Investment Banking Leveraged Buyout (LBO) Initial Public Offering (IPO) Merger and Acquisition Ethics in Investment Banking Course 5: Capital Budgeting & Investment Decision Rules Introduction NPV Method Payback Period Method Internal Rate of Return (IRR) Evaluating Projects in Different Lives Conclusion Course 6: Budgeting and Forecasting Introduction Detail Budget Requirement Process of Making Budget Course 7: Level 3 Tax Accounting Tax System and Administration in the UK Tax on Individuals National Insurance How to Submit a Self-Assessment Tax Return Fundamentals of Income Tax Payee, Payroll and Wages Value Added Tax Corporation Tax Double Entry Accounting Management Accounting and Financial Analysis Career as a Tax Accountant in the UK Course 8: Forex Trading Level 3 Introduction to Forex Trading Major Currencies and Market Structure Kinds of Foreign Exchange Market Money Management Fundamental Analysis Technical Analysis Pitfalls and Risks Managing Risk Trading Psychology Course 10: Fraud Management & Anti Money Laundering Awareness Complete Diploma Introduction to Money Laundering Proceeds of Crime Act 2002 Development of Anti-Money Laundering Regulation Responsibility of the Money Laundering Reporting Office Risk-based Approach Customer Due Diligence Record Keeping Suspicious Conduct and Transactions Awareness and Training Course 11: Effective Communication Skills Diploma Business Communication Verbal and Non-verbal Communication Written Communication Electronic Communication Communicating with Graphic Effectively Working for Your Boss How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Training Expertise and essential knowledge, which will assist you in reaching your goal. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Requirements Anyone from any background can enrol in this training Bundle. Career path Upon successful completion of this Finance and Investment Banking bundle and equipped with the necessary skillsets, you might explore opportunities such as: Investment Banker Business Analyst Financial Associate Executive Director Managing Director Join Analyst Financial Advisor And much more! Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Level 2 Financial Planning and Management Course) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Experience the future of geographical analysis with our Machine Learning for Predictive Maps in Python and Leaflet course. Master the unique blend of programming, machine learning, and geographic information systems, all while honing your ability to predict and visualise spatial data in a powerful and effective way. This course offers you an unparalleled understanding of modern map creation, combined with the magic of prediction using machine learning models. Starting from the ground up, you'll be introduced to all the necessary setups and installations. After that, you will be diving into the depth of Django server-side code and front-end application code writing. The heart of the course lies in learning how to automate the machine learning pipeline, leading you to easily create predictive models.  Improve your maps with Leaflet programming, making your predictions accurate and also visually striking. By the end of this course, you will be armed with experience furnished by our comprehensive project source code and assignments, empowering you to drive data-driven decisions and insightful spatial analysis. Join us and map your way to success! Sign up today. Learning Outcomes:Upon completion of the Machine Learning course, you will be able to: Understand how to set up and install relevant software and libraries.Master Django server-side and application front-end code writing.Gain proficiency in the concepts and implementation of Machine Learning.Learn to automate Machine Learning pipelines for efficient workflows.Acquire skills in Leaflet programming for enhanced map visuals.Handle project source code effectively for real-world projects.Apply knowledge practically via assignments and gain experience. Who is this course for?This Machine Learning course is ideal for: Aspiring Data Scientists keen on harnessing geographical data.GIS professionals aiming to integrate Machine Learning into their skill set.Software Developers interested in creating geographically-focused applications.Analysts keen on enhancing their data visualisation skills with mapping. CertificationAfter studying the course materials of the Machine Learning for Predictive Maps in Python and Leaflet 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 have a range of certification options to choose from. You can claim a CPD Accredited PDF Certificate for £4.99, a CPD Accredited Hardcopy Certificate at £8.00, or you may choose to receive a PDF Transcript for £4.99 or a Hardcopy Transcript for £9.99. Select according to your needs, and we assure timely delivery of your chosen certificate. RequirementsThis professionally designed Machine Learning for Predictive Maps in Python and Leaflet course does not require you to have any prior qualifications or experience. It is open to everyone. You will be able to access the course from anywhere at any time. Just enrol and start learning! Career Path:Our Machine Learning course will help you to pursue a range of career paths, such as: Junior Data Analyst: £25,000 - £35,000 annually.Data Scientist: £40,000 - £60,000 annually.GIS Analyst: £30,000 - £45,000 annually.Geospatial Software Developer: £35,000 - £55,000 annually.Machine Learning Engineer: £50,000 - £80,000 annually.Lead Data Scientist (GIS speciality): £70,000 - £100,000+ annually. Course Curriculum Section 01: Introduction Introduction 00:10:00 Section 02: Setup and Installations Python Installation 00:04:00 Creating a Python Virtual Environment 00:07:00 Installing Django 00:09:00 Installing Visual Studio Code IDE 00:06:00 Installing PostgreSQL Database Server Part 1 00:03:00 Installing PostgreSQL Database Server Part 2 00:09:00 Section 03: Writing the Django Server-Side Code Adding the settings.py Code 00:07:00 Creating a Django Model 00:10:00 Adding the admin.py Code 00:21:00 Section 04: Writing the Application Front-end Code Creating Template Files 00:10:00 Creating Django Views 00:10:00 Creating URL Patterns for the REST API 00:09:00 Adding the index.html code 00:04:00 Adding the layout.html code 00:19:00 Creating our First Map 00:10:00 Adding Markers 00:16:00 Section 05: Machine Learning Installing Jupyter Notebook 00:07:00 Data Pre-processing 00:31:00 Model Selection 00:20:00 Model Evaluation and Building a Prediction Dataset 00:11:00 Section 06: Automating the Machine Learning Pipeline Creating a Django Model 00:04:00 Embedding the Machine Learning Pipeline in the Application 00:42:00 Creating a URL Endpoint for our Prediction Dataset 00:06:00 Section 07: Leaflet Programming Creating Multiple Basemaps 00:09:00 Creating the Marker Layer Group 00:10:00 Creating the Point Layer Group 00:12:00 Creating the Predicted Point Layer Group 00:07:00 Creating the Predicted High Risk Point Layer Group 00:12:00 Creating the Legend 00:09:00 Creating the Prediction Score Legend 00:15:00 Section 08: Project Source Code Resource 00:00:00 Assignment Assignment - Machine Learning for Predictive Maps in Python and Leaflet 00:00:00

In the digital age, the ability to interpret and predict data trends is paramount. Introducing 'Data Analysis and Forecasting in Excel', a comprehensive course tailored to unveil the intricacies of Excel's powerful tools. Dive deep into the world of worksheets, discover the magic of PivotTables, and unravel the secrets of data visualisation. Whether you're a novice eager to delve into data or a seasoned analyst looking to refine your skills, this course promises a transformative journey into the realm of Excel analytics. The curriculum is designed with the utmost care to ensure a holistic understanding. From the basics of modifying worksheets to the advanced techniques of forecasting data, every module is a step towards mastering Excel. With a focus on real-world applications, learners will be equipped to harness the potential of Excel, making data-driven decisions with confidence and precision. Visualisation is at the heart of understanding data. This course not only teaches you how to analyse data but also how to represent it effectively using charts, PivotCharts, and the innovative Sparklines. By the end of this course, you'll be adept at mapping data, automating workbook functionalities, and employing lookup functions with finesse. Learning Outcomes: Master the techniques of modifying and organising worksheets for optimal data representation. Understand and implement effective list management strategies within Excel. Analyse complex datasets and derive meaningful insights. Design and create compelling visual representations using charts and other visual tools. Efficiently utilise PivotTables and PivotCharts for advanced data analysis. Integrate and manage data across multiple worksheets and workbooks. Implement lookup functions and audit formulas to ensure data accuracy and integrity. Why buy this Data Analysis and Forecasting in Excel course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Data Analysis and Forecasting in Excel Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience Who is this Data Analysis and Forecasting in Excel course for? Individuals keen on mastering Excel for data interpretation and visualisation. Business analysts aiming to enhance their data forecasting abilities. Students pursuing a career in data analytics or business intelligence. Managers and decision-makers seeking to make data-driven strategies. Researchers looking to streamline and enhance their data processing techniques. Career path Data Analyst: Average salary range £30,000 - £50,000 annually. Business Intelligence Analyst: Average salary range £35,000 - £55,000 annually. Market Research Analyst: Average salary range £27,000 - £45,000 annually. Financial Analyst: Average salary range £35,000 - £60,000 annually. Operations Research Analyst: Average salary range £40,000 - £65,000 annually. Management Analyst: Average salary range £45,000 - £70,000 annually. Prerequisites This Data Analysis and Forecasting in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis and Forecasting in Excel 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00

Are you embarking on the journey of mastering data analytics and visualisation in the UK? The 'Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7' is your beacon. Positioned to illuminate the intricate realm of Power BI, this course offers a comprehensive look into the foundational aspects and the advanced features that make Microsoft's tool a standout. With sections meticulously designed ranging from the fundamentals, like data transformation, to advanced concepts, such as integrating Power BI with Python and storytelling with data, this course ensures learners grasp the complete spectrum. With the rising emphasis on data analytics in today's business world, this course acquaints you with Power BI's prowess. It prepares you for the sought-after Microsoft Power BI certification in the UK. Learning Outcomes Comprehend the fundamental aspects of Power BI, from initiating a project to understanding the user interface. Develop proficiency in advanced data transformation techniques and data model creation. Integrate Python with Power BI and harness the benefits of both for enhanced data analytics. Master the art of 'Storytelling with Data' to deliver impactful presentations and reports. Understand and implement Row-Level Security and harness Power BI Cloud services efficiently. Why choose this Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 for? Individuals keen on obtaining the Microsoft power bi certification UK. Analysts and data professionals aspiring to enhance their data visualisation skills. Business professionals wanting to leverage Power BI for insightful business decision-making. Tech enthusiasts aiming to amalgamate programming (Python) with data analytics. Those seeking to stay updated with the latest trends in Power BI and its evolving capabilities. Career path Data Analyst: Average Salary £30,000 - £40,000 Annually Business Intelligence Developer: Average Salary £35,000 - £45,000 Annually Power BI Developer: Average Salary £40,000 - £50,000 Annually Data Visualisation Specialist: Average Salary £32,000 - £42,000 Annually Business Intelligence Manager: Average Salary £45,000 - £55,000 Annually Data Strategy Consultant: Average Salary £50,000 - £60,000 Annually Prerequisites This Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Section 01: Introduction Welcome! 00:01:00 What is Power BI? 00:03:00 Download & Installing Power BI Desktop 00:04:00 Getting to know the interface 00:03:00 Mini Project: Transform Data 00:07:00 Mini Project: Visualize Data 00:05:00 Mini Project: Creating a Data Model 00:07:00 Course Outline: What will you learn in this course? 00:05:00 How to learn best with this course? 00:03:00 Section 02: Preparing our Project Creating our initial project file 00:04:00 Working with the attached project files 00:04:00 Section 03: Data Transformation - The Query Editor Exploring the Query Editor 00:06:00 Connecting to our data source 00:07:00 Editing rows 00:08:00 Changing data types 00:08:00 Replacing values 00:03:00 Close & Apply 00:03:00 Connecting to a csv file 00:03:00 Connecting to a web page 00:05:00 Extracting characters 00:06:00 Splitting & merging columns 00:09:00 Creating conditional columns 00:06:00 Creating columns from examples 00:09:00 Merging Queries 00:17:00 Pivoting & Unpivoting 00:06:00 Appending Queries 00:08:00 Practice & Solution: Population table 00:15:00 The Fact-Dimension-Model 00:09:00 Practice: Load the dimension table 00:04:00 Organizing our queries in groups 00:03:00 Entering data manually 00:05:00 Creating an index column 00:03:00 Workflow & more transformations 00:05:00 Module summary 00:05:00 Exercise 1 - Instruction 00:02:00 Exercise Solution 00:11:00 Section 04: Data Transformation - Advanced Advanced Editor - Best practices 00:09:00 Performance: References vs. Duplicating 00:10:00 Performance: Enable / Disable Load & Report Refresh 00:05:00 Group by 00:05:00 Mathematical Operations 00:05:00 Run R Script 00:15:00 Using Parameters to dynamically transform data 00:06:00 M formula language: Basics 00:07:00 M formula language: Values, Lists & Tables 00:14:00 M formula language: Functions 00:13:00 M formula language: More functions & steps 00:05:00 Exercise 2 - Instructions 00:01:00 Exercise 2 - solution 00:05:00 Section 05: Creating a Data Model Understanding the relationship 00:05:00 Create & edit relationships 00:06:00 One-to-many & one-to-one relationship 00:06:00 Many-to-many (m:n) relationship 00:08:00 Cross filter direction 00:06:00 Activate & deactivate relationships 00:06:00 Model summary 00:03:00 Exercise 3 Create Model 00:03:00 Exercise 3 Solution 00:02:00 Section 06: Data Visualization Our first visual 00:08:00 The format tab 00:12:00 Understanding tables 00:10:00 Conditional formatting 00:09:00 The Pie Chart 00:06:00 All about the filter visual 00:13:00 The filter pane for developers 00:09:00 Cross filtering & edit interactions 00:04:00 Syncing slicers across pages 00:07:00 Creating drill downs 00:08:00 Creating drill throughs 00:07:00 The tree map visual 00:07:00 The decomposition tree 00:05:00 Understanding the matrix visual 00:05:00 Editing pages 00:07:00 Buttons & Actions 00:09:00 Bookmarks to customize your report 00:10:00 Analytics and Forecasts with line charts 00:10:00 Working with custom visuals 00:07:00 Get data using R Script & R Script visual 00:08:00 Asking questions - Q&A visual 00:04:00 Wrap up - data visualization 00:08:00 Section 07: Power BI & Python Python in Power BI - Plan of attack 00:03:00 Setting up Python for Power BI 00:03:00 Transforming data using Python 00:11:00 Creating visualizations using Python 00:08:00 Violin plots, pair plots & ridge plots using Python 00:15:00 Machine learning (BayesTextAnalyzer) using Python 00:00:00 Performance & Troubleshooting 00:03:00 Section 08: Storytelling with Data Introduction 00:01:00 Show Empathy & Identify the Requirement 00:03:00 Finding the Most Suitable KPI's 00:02:00 Choose an Effective Visualization 00:04:00 Make Use of Natural Reading Pattern 00:03:00 Tell a Story Using Visual Cues 00:05:00 Avoid Chaos & Group Information 00:02:00 Warp Up - Storytelling with Data 00:02:00 Section 09: DAX - The Essentials Introduction 00:03:00 The project data 00:04:00 Measures vs. Calculated Columns 00:15:00 Automatically creating a date table in DAX 00:08:00 CALENDAR 00:05:00 Creating a complete date table with features 00:04:00 Creating key measure table 00:03:00 Aggregation functions 00:06:00 The different versions of COUNT 00:14:00 SUMX - Row based calculations 00:09:00 Section 10: DAX - The CALCULATE function CALCULATE - The basics 00:11:00 Changing the context with FILTER 00:07:00 ALL 00:08:00 ALL SELECTED 00:03:00 ALL EXCEPT 00:07:00 Section 11: Power BI Service - Power BI Cloud How to go on now? 00:03:00 Power BI Pro vs Premium & Signing up 00:04:00 Exploring the interface 00:04:00 Discovering your workspace 00:03:00 Connecting Power BI Desktop & Cloud 00:04:00 Understanding datasets & reports 00:03:00 Working on reports 00:04:00 Updating reports from Power BI Desktop 00:04:00 Creating and working with workspaces 00:07:00 Installing & using a data gateway 00:13:00 Get Quick Insights 00:03:00 Creating dashboards 00:04:00 Sharing our results through Apps 00:10:00 Power BI Mobile App 00:05:00 Creating the layout for the Mobile App 00:04:00 Wrap up Power BI Cloud 00:07:00 Section 12: Row-Level Security Introduction 00:03:00 Creating a Row-Level Security 00:05:00 Row-Level Security in the Cloud 00:04:00 Row-Level Security & Data Model 00:05:00 Dynamic Row-Level Security 00:07:00 Dynamic Many-to-Many RLS 00:04:00 Hierarchical Row-Level Security 00:13:00 Section 13: More data sources JSON & REST API 00:10:00 Setting up a local MySQL database 00:14:00 Connecting to a MySQL database in Power BI 00:05:00 Connecting to a SQL database (PostgreSQL) 00:05:00 Section 14: Next steps to improve & stay up to date Congratulations & next steps 00:06:00 The End 00:01:00 Resources Resources - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 00:00:00 Assignment Assignment - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00