• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

262 MySQL courses in Leicester delivered On Demand

An Introduction to CSS - A Complete Beginner to Expert Course

By Packt

Learn how to style HTML components with CSS3 to build websites and web pages that are visually appealing from beginning to end. Those who want to learn CSS should take this course.

An Introduction to CSS - A Complete Beginner to Expert Course
Delivered Online On Demand4 hours 7 minutes
£67.99

Certified Computer Programming Skills Training

By iStudy UK

Learning Computer Programming has never been so easy! Do you want ot learn codes and create your own software? Get this course to learn about coding and become a Programmer. Learn the different coding languages and have a career in one of the most demanding jobs at this moment in time. A computer programmer creates the code for software applications and operating systems. After a software developer designs a computer program, the programmer writes code that converts that design into a set of instructions a computer can follow. He or she tests the program to look for errors and then rewrites it until it is error-free. The programmer continues to evaluate programs that are in use, making updates and adjustments as needed. This course teaches you all the roles and responsibilities you will take as a computer programmer and how to deal with each one of them. It will also teach you about coding which essential for any prospective computer programmer. Course Highlights Certified Computer Programming Skills Training is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Computer Programming Skills Training into 33 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 1 day, 4 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Computer Programming Skills Training Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Computer Programming Skills Training is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certified Computer Programming Skills Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Computer Programming at a Glance COMPUTER PROGRAMMING AT A GLANCE 01:00:00 UNDERSTANDING THE LANGUAGE OF THE COMPUTER 00:30:00 Choosing a Language 00:30:00 Basic Programming Language BASIC Programming Language 01:00:00 Getting Started with BASIC Programming Language 01:00:00 BASIC Overview of BASIC Components 01:00:00 BASIC Special Variables 01:00:00 BASIC Probability Functions 01:00:00 Filtering the Data Set or Splitting the Data Set 01:00:00 DATA Blocks 01:00:00 DELETE Statement 01:00:00 FOR...NEXT Statement 01:00:00 IF. . . THEN Statement 01:00:00 PHP Programming Welcome to the world of programming! FREE 00:30:00 Getting Started FREE 01:00:00 Let's Start Coding! 01:00:00 PHP Strings 01:00:00 PHP Variables 01:00:00 Useful Variables 00:30:00 PHP Includes & Problem Solving 01:00:00 Tip When Creating Inc Pages 00:30:00 Redirecting Using PHP 00:30:00 Multiple Conditions 01:00:00 PHP Arrays 01:00:00 PHP Loops 01:00:00 Note on PHP Math Functions: 00:30:00 Functions 01:00:00 PHP Sessions 00:30:00 Cookies 01:00:00 Introduction to MySQL 01:00:00 Making The Connection 01:00:00 Inserting Data 01:00:00 Deleting / Removing Data 00:15:00

Certified Computer Programming Skills Training
Delivered Online On Demand28 hours
£25

Learn Linux in 5 Days and Level Up Your Career

4.8(9)

By Skill Up

Fast-track your career with our comprehensive 5-day Linux course. Master Linux in just a few days, boosting your expertise and job prospects.

Learn Linux in 5 Days and Level Up Your Career
Delivered Online On Demand5 hours 57 minutes
£25

Python Certification - IT Job Ready Program with Money Back Guarantee

5.0(2)

By Academy for Health and Fitness

Become an IT professional with our Python Certification - IT Job Ready Program! Gain comprehensive skills in Python programming, data analysis, and automation. We offer a money-back guarantee if you don't secure a job within six months of completion. Enroll now and jumpstart your tech career! Ready to land your dream job in tech? Our Python Certification - IT Job Ready Program equips you with essential Python programming, data analysis, and automation skills. Plus, we offer a money-back guarantee if you don't get hired within six months of completing the course. Don't miss out – enroll today and take the first step towards a successful IT career! 💻📊 #PythonCertification #TechTraining #CareerReady #MoneyBackGuarantee

Python Certification - IT Job Ready Program with Money Back Guarantee
Delivered Online On Demand3 hours
£649

Automation with Ansible Playbooks

By Packt

Using Ansible to automate local and cloud configuration management tasks with Playbooks

Automation with Ansible Playbooks
Delivered Online On Demand17 hours 35 minutes
£13.99

YAML Fundamentals for DevOps, Cloud and IaC Engineers

By Packt

The "YAML Fundamentals" course helps beginners with the required skills to develop YAML documents. It will also help you gain skills to develop a properly structured YAML document in both block style and flow style. The "flow style" is also known as JSON style or compact style. If you are looking forward to adding YAML to your skillset, then this course is what you need. In today's market, every IT professional is expected to know YAML.

YAML Fundamentals for DevOps, Cloud and IaC Engineers
Delivered Online On Demand2 hours 27 minutes
£37.99

Creational Design Patterns in Modern C++

By Packt

This course will help you become familiar with the implementation of creational design patterns. Featuring real-world examples written in modern C++, each pattern is explained in detail to help you to understand how the pattern can be implemented efficiently using language features.

Creational Design Patterns in Modern C++
Delivered Online On Demand7 hours 42 minutes
£14.99

Microsoft Power BI Masterclass 2021

4.5(3)

By Studyhub UK

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Microsoft Power BI Masterclass 2021 Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Microsoft Power BI Masterclass 2021 Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Microsoft Power BI Masterclass 2021 Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Microsoft Power BI Masterclass 2021 Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Microsoft Power BI Masterclass 2021? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Microsoft Power BI Masterclass 2021 there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Microsoft Power BI Masterclass 2021 course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill.   Prerequisites This Microsoft Power BI Masterclass 2021 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Power BI Masterclass 2021 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Microsoft Power BI Masterclass 2021 is a great way for you to gain multiple skills from the comfort of your home. 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:02: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 - Microsoft Power BI Masterclass 2021 00:00:00 Assignment Assignment - Microsoft Power BI 00:00:00

Microsoft Power BI Masterclass 2021
Delivered Online On Demand14 hours 25 minutes
£10.99

Web Design and Web Development With Complete Career Guide Course

5.0(2)

By Training Express

In today's digital age, web design and development are at the heart of creating engaging online experiences. The Web Design and Web Development course offers you the perfect opportunity to gain valuable knowledge and skills to build and maintain websites. Whether you are interested in creating sleek, user-friendly designs or coding dynamic websites, this course is designed to help you grasp the essential tools and techniques needed for success. As websites evolve, so does the demand for innovative and functional designs, and this course helps you stay ahead of the curve by offering a solid understanding of both design principles and coding practices. The world of web design and development continues to grow as businesses increasingly turn to online platforms to connect with customers. By learning the foundations of web design, HTML, CSS, JavaScript, and more, you'll be able to develop a range of websites, from basic landing pages to sophisticated online stores. You'll also be introduced to web development frameworks that can streamline your workflow and increase efficiency. This course provides everything you need to develop an online presence that meets the demands of modern users, ensuring that you're well-equipped for an exciting career in the tech industry. Key Features: CPD Certified 10 Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by qualified professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Web Design and WordPress Training Module 01: Web Design Module 02: Requirements to take this course Module 03: Organizing your Web Design Project Module 04: Gathering project information from client Module 05: Sketching, Wireframing, Atomic Design & 8point Grid system Module 06: Style Guides, colors and typographics scales Module 07: Designing for Desktop/Large View (Wstudio Web Design Project) Module 08: Planning Responsive Web Design Module 09: Designing for Tablet/Medium View (Wstudio Web Design Project) Module 10: Designing for Mobile/Small View (Wstudio Web Design Project) Module 11: Designing for Developers Module 12: Prototyping with Invision app Module 13: SVGs and Icon Fonts in Web Design Module 14: WordPress Training Module 15: Introduction & installing WordPress Module 16: WordPress page builder Familiarization Module 17: WordPress home page Design & development Module 18: WordPress About Us page Design & development Module 19: WordPress Contact Us & blog page design & development Module 20: WordPress Responsive website & publishing website Module 21: Free Plugins to mimic the Elementor Pro Module 22: Exporting & importing our Elementor pages Module 23: Creating Our WordPress ecommerce store Module 24: WordPress website customization Module 25: WordPress Website Backup, official email & more Advanced Diploma in PHP Web Development Module 01: Introduction Module 02: Environment Configuration Module 03: PHP Basics and Syntax Module 04: PHP Forms and MySQL and User Authentication ________________________________________________________________________ Complete Career Guide for Web Design and Web Development (A to Z) This isn't just a course; it's your ticket to thriving in the sector and your roadmap to the Web Design. In addition to mastering the essentials of Web Design, you'll also gain valuable skills in CV writing, job searching, communication, leadership, and project management. These 9 complementary courses are designed to empower you at every stage of your journey. Stand out in your career, from crafting a winning CV to excelling in interviews. Develop the leadership skills to inspire your team and efficiently manage projects. This holistic approach ensures you're not just job-ready but career-ready. Enrol today, and let's build your success story together in Web Design. Your dream career starts here! List of career guide courses included in Web Design and Web Development With Complete Career Guide: Course 01: Professional CV Writing and Job Searching Course 02: Communication Skills Training Course 03: Career Development Training Course 04: Time Management Course 05: Returning to Work Training Course 06: Level 3 Diploma in Project Management Course 07: Leadership Skills Course 08: Body Language Course 09: Interview and Recruitment ________________________________________________________________________ Learning Outcomes: Gain proficiency in web design principles and techniques. Develop effective project organization and client communication skills. Master the use of sketching, wireframing, and the 8-point grid system. Make typographic scales, style guides, and integrated graphic elements. Demonstrate expertise in responsive web design for various devices. Acquire practical knowledge in WordPress installation, customization, and e-commerce. ________________________________________________________________________ Accreditation All of our courses, including thiscourse, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Course, you will immediately be sent your digital certificates. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we recommend renewing them every 12 months. Assessment At the end of the courses, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to become skilled web designers and developers. Those seeking comprehensive WordPress training for website creation. Creative professionals aiming to enhance their design and development skills. Beginners in web design and development looking for a structured course. entrepreneurs who want to take charge of the material and layout of their website. Career path Web Designer - £25K to 35K/year. Front-end Developer - £30K to 40K/year. WordPress Developer - £28K to 38K/year. UI/UX Designer - £32K to 42K/year. E-commerce Developer - £35K to 45K/year. Certificates 10 CPD Accredited e-Certificates Digital certificate - Included 10 CPD Accredited Hard Copy Certificates Hard copy certificate - Included

Web Design and Web Development With Complete Career Guide Course
Delivered Online On Demand1 hour
£65

Microsoft Power BI Masterclass

By IOMH - Institute of Mental Health

Join our Microsoft Power BI Masterclass course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Power BI Masterclass course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Power BI Masterclass course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Power BI Masterclass. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Power BI Masterclass course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Power BI Masterclass is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Power BI Masterclass course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Power BI Masterclass Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. 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:02: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 - Microsoft Power BI Masterclass 00:00:00

Microsoft Power BI Masterclass
Delivered Online On Demand14 hours 25 minutes
£11.99