Overview This comprehensive course on Business Intelligence and Data Mining Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Business Intelligence and Data Mining Masterclass comes with accredited certification, 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 Intelligence and Data Mining Masterclass. It is available to all students, of all academic backgrounds. Requirements Our Business Intelligence and Data Mining Masterclass 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 24 lectures • 04:56:00 total length •Module 01: What is Business Intelligence?: 00:05:00 •Module 02: Starting Case in understanding BI needs in diff phase of business: 00:07:00 •Module 03: Decision Making Process and Need of IT systems: 00:20:00 •Module 04: Problem Structure and Decision Support System: 00:11:00 •Module 05: Introduction to BI Applications: 00:18:00 •Module 06: Dashboard presentation systems: 00:07:00 •Module 07: Different Types of Charts used in 131 Dashboards: 00:30:00 •Module 08: Good Dashboard and BSC: 00:13:00 •Module 09: Examples of Bad Dashboards 1: 00:07:00 •Module 10: Examples of Bad Dashboards 2: 00:01:00 •Module 11: Process of KPI Development: 00:26:00 •Module 12: Overview of Data warehouse: 00:08:00 •Module 13: More explaining of data warehouse and steps in processing: 00:09:00 •Module 14: Data Warehouse Architecture -Tiers: 00:18:00 •Module 15: Data Warehouse - components: 00:15:00 •Module 16: Approach to develop data structure and Models of database: 00:16:00 •Module 17: Basics of Data Mining - Meaning: 00:35:00 •Module 18: Basics of Data Mining - Stages of DM: 00:25:00 •Module 19: Data Mining Technique - Classification: 00:07:00 •Module 20: Data mining - Clustering: 00:02:00 •Module 21: Data Mining - Association Rules: 00:05:00 •Module 22: Data Mining Applications - Banking: 00:03:00 •Module 23: Data Mining Applications - CRM: 00:04:00 •Module 24: Data Mining Applications - other industries: 00:04:00
Tired of searching and accumulating all the relevant courses for this specific field? It takes a substantial amount of your time and, more importantly, costs you a fortune! Well, we have just come up with the ultimate solution for you by giving this all-inclusive Finance Training for Financial Analysts mega bundle. This 33 courses mega bundle keeps you up-to-date in this field and takes you one step ahead of others. Keeping in mind the latest advancements in this ever-emerging sector, the Finance Training for Financial Analysts bundle covers all the state-of-the-art tools and techniques required to become a competent worker in this area. You will encounter specific courses relevant to the sector. We take you from the most introductory fundamentals to advance knowledge in a step-by-step manner. In addition, the Finance Training for Financial Analysts bundle also consists of courses related to some soft skills that you will need to succeed in any industry or job sector. This Finance Training for Financial Analysts Bundle consists of the following premium courses: Course 01: Financial Analysis Course 02: Understanding Financial Statements and Analysis Course 03: Finance Principles Course 04: Financial Management Course 05: Improve your Financial Intelligence Course 06: Develop Your Career in Finance: Blue Ocean Strategy Course 07: Dealing With Uncertainity: Make Budgets and Forecasts Course 08: Financial Statements Fraud Detection Training Course 09: Raising Money & Valuations Course 10: Cost Control Process and Management Course 11: Financial Modeling Using Excel Course 12: Tax Accounting Course 13: Introduction to VAT Course 14: Applied Accounting Course 15: Financial Wellness: Managing Personal Cash Flow Course 16: GDPR Course 17: Banking and Finance Accounting Statements Financial Analysis Course 18: Introduction to Corporate Finance Course 19: Corporate Finance: Working Capital Management Course 20: Financial Ratio Analysis for Business Decisions Course 21: Debt Management - Online Course Course 22: Anti Money Laundering & Countering of Terrorist Financing Course 23: Sage 50 Accounts Course 24: Commercial Law Course 25: Fundamentals of Zero Based Budgeting Course 26: Financial Analysis : Finance Reports Course 27: Presenting Financial Information Course 28: Document Control Course 29: Stakeholder Management Course 30: Excel Pivot Tables for Data Reporting Moreover, this bundles include 3 career-focused courses: Course 01: Career Development Plan Fundamentals Course 02: CV Writing and Job Searching Course 03: Interview Skills: Ace the Interview Our cutting-edge learning package offers top-notch digital aid and first-rate tutor support. You will acquire the crucial hard and soft skills needed for career advancement because this bundle has been thoroughly examined and is career-friendly. So don't overthink! Enrol today. Learning Outcomes This unique Finance Training for Financial Analysts mega bundle will help you to- Quench your thirst for knowledge Be up-to-date about the latest advancements Achieve your dream career goal in this sector Know the applicable rules and regulations needed for a professional in this area Acquire some valuable knowledge related to Finance Training for Financial Analysts to uplift your morale The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Certificate: PDF Certificate: Free for all 33 courses Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Finance Training for Financial Analysts bundle is designed to assist anyone with a curious mind, anyone looking to boost their CVs or individuals looking to upgrade their career to the next level can also benefit from the learning materials. Requirements The courses in this bundle has been designed to be fully compatible with tablets and smartphones. Career path This Finance Training for Financial Analysts bundle will give you an edge over other competitors and will open the doors for you to a plethora of career opportunities. 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 (Financial Analysis) 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.
In today’s competitive landscape, businesses heavily rely on skilled marketers to promote their brand, create innovative marketing strategies, and drive sales growth. To help you stand out in the job market, we present the Sales and Marketing – CPD Accredited course, designed to equip you with essential marketing skills. The success of any business is tied to the communication, management, planning, and leadership abilities of its marketing professionals. That’s why our experts have carefully curated this Sales and Marketing course to develop your marketing expertise, making you a proficient marketer ready for the global market. In this course, you will gain expertise in Sales and Marketing, Business Administration, Data Analysis in Excel, Business Management, Financial Management and Trading, Performance Management, and Sales: Psychology of Customers and Business Strategies. These skills will enhance your ability to succeed in today’s marketing environment. Enrol in this comprehensive package and make yourself job-ready with this career-focused Sales and Marketing training. Key Features of the Course: FREE Sales and Marketing CPD-accredited certificate Get a free student ID card with Sales and Marketing training (£10 applicable for international delivery) Lifetime access to the Sales and Marketing course materials The Sales and Marketing program comes with 24/7 tutor support Get instant access to this Sales and Marketing course Learn Sales and Marketing training from anywhere in the world The Sales and Marketing training is affordable and simple to understand The Sales and Marketing training is an entirely online Benefits you'll get from choosing Apex Learning for this Sales and Marketing: Pay once and get lifetime access to 11 CPD courses from this Sales and Marketing Bundle Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules of Sales and Marketing courses designed by expert instructors Learn at your ease - anytime, from anywhere Study from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge of Sales and Marketing without leaving your home In this part, we'll discuss the course modules in detail so that you get a clear view of what your learning journey would be. The Sales and Marketing Skills course modules are divided into small sections for a better learning experience. Description: The Sales and Marketing – CPD Accredited course equips you with essential skills to thrive in the fast-paced world of marketing and sales. In a competitive market, having strong marketing strategies is key to driving sales and enhancing brand visibility. This course covers vital topics like digital marketing, social media marketing, business marketing, and consumer psychology, helping you effectively promote products and services. You’ll also gain expertise in content marketing, performance management, business management, and data analysis, allowing you to understand market trends and make informed decisions. Whether you're aiming to enhance sales techniques or expand your marketing knowledge, this course prepares you for various roles, including marketing management and sales leadership. Get ahead in your career with this comprehensive marketing training package and become a proficient marketer ready to excel in the global market. ★★★ Course Curriculum of the Sales and Marketing - CPD Accredited Bundle ★★★ Course 1: Sales and Marketing Skills Level 3 Module 01: Getting Started Module 02: Understanding the Talk Module 03: Getting Prepared to Make the Call Module 04: Creative Openings Module 05: Making Your Pitch Module 06: Handling Objections Module 07: Sealing the Deal Module 08: Following Up Module 09: Setting Goals Module 10: Managing Your Data Module 11: Using a Prospect Board Module 12: Wrapping Up -------- Other Courses Are --------- Course 02: Business Analysis Level 3 Course 03: Digital Marketing and Advertising Level 3 Course 04: Purchasing & Procurement Course - Level 3 Course 05: Data Analysis in Excel Level 3 Course Course 06: Business Administration Level 3 Course 07: Forex Trading and Market Structure Course 08: Risk Management Course 09: Performance Management Course 10: Customer Relationship Management Course 11: Sales: Psychology of Customers How will I get my Certificate? After successfully completing the Sales and Marketing 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) PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Sales and Marketing bundle. Requirements This Sales and Marketing course has been designed to be fully compatible with tablets and smartphones. Career path Unlock diverse career opportunities with Sales and Marketing – CPD Accredited. Explore these lucrative paths: Sales and Marketing Manager: £30,000 - £55,000 Digital Marketing Specialist: £25,000 - £45,000 Business Development Manager: £28,000 - £50,000 Brand Manager: £35,000 - £60,000 Marketing Coordinator: £22,000 - £35,000 Market Research Analyst: £25,000 - £40,000 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 (Sales and Marketing Skills Level 3) 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.
Overview With the ever-increasing demand for Tableau in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Tableau may be. Learning about Tableau or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Tableau. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Tableau is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by Compete High in this Diploma in Data Analytics In Tableau course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Diploma in Data Analytics In Tableau course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Diploma in Data Analytics In Tableau course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Tableau, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Tableau, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Tableau, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Diploma in Data Analytics In Tableau course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 01_ Data Analytics Data Analytics 00:00 Module 02_ Why Use Tableau for Data Analytics Why Use Tableau for Data Analytics 00:00 Module 03_ Getting Started With Tableau Getting Started With Tableau 00:00 Module 04_ Tableau Data Source (TDS) Tableau Data Source (TDS) 00:00 Module 05_ Tableau Worksheets Tableau Worksheets 00:00 Module 06_ Tableau Calculations Tableau Calculations 00:00 Module 07_ Tableau Sort _ Filters Tableau Sort _ Filters 00:00 Module 08_ Tableau Charts Tableau Charts 00:00 Module 09_ Tableau Advanced Tableau Advanced 00:00
In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Financial Analysis Training course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Financial Analysis Training course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Financial Analysis Training and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Financial Analysis Training course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Financial Analysis Training course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path The Financial Analysis Training will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Module 01: Introduction to Financial Analysis Introduction to Financial Analysis 00:18:00 Module 02: The Balance Sheet The Balance Sheet 00:29:00 Module 03: The Income Statement The Income Statement 00:25:00 Module 04: The Cash Flow Statement The Cash Flow Statement 00:25:00 Module 05: Financial Reporting Financial Reporting 00:26:00 Module 06: Analysing Profitability Analysing Profitability 00:22:00 Module 07: The Applications and Limitations of EBITDA The Applications and Limitations of EBITDA 00:27:00 Module 08: Credit Analysis Credit Analysis 00:32:00 Module 09: Equity Analysis Equity Analysis 00:17:00 Module 10: Ratio Analysis Ratio Analysis 00:28:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
Process Improvement Course Overview: This course on Process Improvement provides a comprehensive foundation for learners to understand and apply key principles of process management and optimisation. Participants will explore various strategies, tools, and methodologies to streamline processes, enhance efficiency, and reduce waste. Emphasising real-world applicability, the course equips learners with the knowledge to analyse, design, and implement process improvements in a variety of professional settings. By the end, learners will be able to identify inefficiencies, propose targeted improvements, and contribute effectively to organisational performance enhancement. Course Description: In this course, learners will delve into the essentials of process improvement, covering fundamental concepts and frameworks used to optimise operations. Topics include the types of processes, the methodologies for process analysis, and the steps for implementing effective process improvements. Learners will gain a deep understanding of key process improvement techniques, such as Six Sigma and Lean, and develop the skills to assess and refine processes. The course also includes a LIVE demonstration, allowing learners to see the implementation of improvements in action, ensuring they are well-equipped to contribute to the efficiency of their organisations. Process Improvement Curriculum: Module 01: Introduction Module 02: The Fundamentals of Process Improvement Module 03: Types of Process in Process Improvement Module 04: The Process of Delivering Process Improvement Module 05: LIVE Demonstration of a Process Improvement Module 06: Close Out (See full curriculum) Who is this course for? Individuals seeking to enhance operational efficiency. Professionals aiming to advance their career in process management. Beginners with an interest in process improvement or management. Anyone looking to understand key strategies for process optimisation. Career Path: Process Improvement Specialist Business Process Analyst Operations Manager Lean Six Sigma Consultant Continuous Improvement Coordinator
Inventory Management Course Overview: This course on Inventory Management is designed to equip learners with essential knowledge and skills in managing inventory systems effectively. Covering key areas such as types of inventory, demand identification, and maintaining accuracy, it provides the foundation for anyone looking to optimise warehouse operations. Learners will gain an understanding of how to establish efficient inventory systems and the critical role that inventory management plays in ensuring business success. This course will help participants develop the expertise needed to contribute to more effective supply chain and warehouse management. Course Description: In this course, learners will explore the fundamentals of inventory management, from defining inventory to understanding different types of inventory and key industry players. Topics such as warehouse setup, identifying demand, and maintaining inventory accuracy are covered in depth. The course also delves into the outbound process and how to streamline operations to ensure that stock levels are effectively managed. By the end of the course, learners will have developed the necessary skills to improve inventory systems, contribute to better decision-making processes, and understand the broader implications of inventory management within a business context. Inventory Management Curriculum: Module 01: What Is Inventory? Module 02: Types Of Inventory Module 03: Key Players Module 04: Setting Up The Warehouse Module 05: Identifying Demand Module 06: Maintaining Inventory Accuracy Module 07: The Outbound Process (See full curriculum) Who is this course for? Individuals seeking to improve their knowledge of inventory systems. Professionals aiming to enhance their expertise in warehouse management. Beginners with an interest in logistics and supply chain management. Those interested in a career in inventory management or related fields. Career Path: Inventory Manager Supply Chain Coordinator Warehouse Supervisor Operations Analyst Logistics Specialist
Linux Security and Hardening Course Overview: This "Linux Security and Hardening" course provides a comprehensive introduction to the essential practices required to secure Linux systems. It covers fundamental aspects of security, including general, physical, account, and network security, as well as file system security measures. With a focus on Linux-specific tools and techniques, the course is designed to equip learners with the knowledge to protect their systems from common vulnerabilities. By completing this course, learners will understand the key concepts and be able to implement security measures effectively, ensuring the integrity and confidentiality of their Linux-based systems. Course Description: In this course, learners will explore various layers of Linux security and hardening techniques to protect against threats. Topics covered include general system security, physical security, account management, network protection, and securing file systems. The course also provides additional resources to enhance your understanding of Linux security. By engaging with these modules, learners will acquire the skills necessary to safeguard systems, mitigate risks, and create a secure environment. This course is suitable for those wishing to bolster their technical expertise and for professionals eager to advance their career in Linux system administration and security. Linux Security and Hardening Curriculum: Module 01: Course Overview and Downloads Module 02: General Security Module 03: Physical Security Module 04: Account Security Module 05: Network Security Module 06: File System Security Module 07: Additional Resources (See full curriculum) Who is this course for? Individuals seeking to enhance their knowledge of Linux security. Professionals aiming to advance their career in Linux system administration. Beginners with an interest in system security and IT infrastructure. Those looking to specialise in security and hardening for Linux-based environments. Career Path: Linux System Administrator IT Security Analyst Network Security Specialist System Security Engineer Cybersecurity Consultant
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
Course Overview The LEED V4 - Building Design and Construction course offers an in-depth exploration of sustainable building practices in line with the LEED (Leadership in Energy and Environmental Design) standards. Learners will gain a comprehensive understanding of the LEED V4 framework and its application to building design and construction. The course highlights key principles, including energy efficiency, environmental responsibility, and resource management, equipping participants with the knowledge to meet LEED certification requirements. Upon completion, learners will be prepared to integrate sustainable practices into their work, contributing to green building initiatives and reducing environmental impact in the construction industry. Course Description This course delves into the core components of the LEED V4 standards, covering a broad spectrum of topics such as integrative processes, sustainable site development, water efficiency, energy optimisation, and indoor environmental quality. Learners will explore how these elements impact building design and construction, learning how to create energy-efficient, eco-friendly structures. The course provides a thorough examination of each LEED category, equipping participants with the skills needed to navigate the certification process and apply sustainable design principles to real-world projects. By the end, learners will have the knowledge to assess projects for LEED compliance and incorporate green strategies into building practices, driving sustainability forward. Course Modules Module 01: Introduction Module 02: Integrative Process Module 03: Location & Transportation Module 04: Sustainable Sites Module 05: Water Efficiency Module 06: Energy & Atmosphere Module 07: Materials & Resources Module 08: Indoor Environment Quality Module 09: Innovation Module 10: Regional Priority Module 11: Completion (See full curriculum) Who is this course for? Individuals seeking to enhance their knowledge of sustainable building practices Professionals aiming to pursue LEED accreditation or certification Beginners with an interest in green building and environmental design Architects, engineers, and construction managers looking to stay current with industry standards Sustainability advocates looking to make a difference in the built environment Career Path Green Building Consultant LEED Accredited Professional Sustainability Coordinator Environmental Consultant Energy Manager Construction Project Manager Sustainability Analyst