2007 Analytics courses

QLS Level 1 Course | 10 FREE CPD Courses & PDF Certificates | CPD Accredited | Installment Payment | Tutor Support

Boost Your Career By Enrolling In This Microsoft Excel & Data Analysis Bundle To Overcome Your Challenges! 4 in 1 Microsoft Excel & Data Analysis Bundle Improve your knowledge and enhance your skills to succeed with this Microsoft Excel & Data Analysis bundle. This Microsoft Excel & Data Analysis bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our bundle is ideal for those who aim to be the best in their fields and are always looking to grow. This Microsoft Excel & Data Analysis Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Microsoft Excel Complete Course Course 02: Basic Data Analysis Course 03: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 04: SQL for Data Science, Data Analytics and Data Visualization All the courses under this Microsoft Excel & Data Analysis bundle are split into a number of expertly created modules to provide you with an in-depth and comprehensive learning experience. Upon successful completion of the Microsoft Excel & Data Analysis bundle, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Stand out from the crowd and get trained for the job you want. With this comprehensive Microsoft Excel & Data Analysis bundle, you can achieve your dreams and train for your ideal career. This Microsoft Excel & Data Analysis bundle covers essential aspects in order to progress in your chosen career. Why Prefer Us for Microsoft Excel & Data Analysis? All-in-one package of 4 premium courses' Microsoft Excel & Data Analysis bundle Earn a certificate accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Globally Accepted Standard Lesson Planning Free Assessments with this Microsoft Excel & Data Analysis Bundle 24/7 Tutor Support available with this Microsoft Excel & Data Analysis Bundle Start your learning journey straightaway! This Microsoft Excel & Data Analysis's curriculum has been designed by Microsoft Excel & Data Analysis experts with years of Microsoft Excel & Data Analysis experience behind them. The Microsoft Excel & Data Analysis course is extremely dynamic and well-paced to help you understand Microsoft Excel & Data Analysis with ease. You'll discover how to master the Microsoft Excel & Data Analysis skill while exploring relevant and essential topics. Assessment Process Once you have completed all the courses in the Microsoft Excel & Data Analysis bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Microsoft Excel & Data Analysis bundle is suitable for everyone. Requirements You will not need any prior background or expertise. Career path This Microsoft Excel & Data Analysis bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Master the art of digital marketing with our Advanced Digital Marketing Course. From SEO strategies to social media tactics, this comprehensive course equips you with the skills needed to excel in today's competitive online landscape. Perfect for marketers, entrepreneurs, and students alike. Enroll now and elevate your digital marketing expertise!

Learn to utilize the marketing automation platform Hootsuite with the intensive course Hootsuite Social Media Management. Hootsuite is a social media management platform that allows you to manage multiple networks and profiles easily. It can support social network integrations for Twitter, Facebook, Instagram, LinkedIn, Google+ and YouTube. Using the platform, you can monitor what people are saying about your brand and help you respond instantly. You can use it free to build your social media following. The course teaches you how to use the social media management platform to boost your social media activities. The strategies of managing all social media activities from one dashboard and the ways of scheduling posts for every media post will be discussed in the course. The course also suggests you which social media to focus and which you should run. By the end of the course, you will be able to keep track of and manage your many social network channels easily with Hootsuite. What Will I Learn? You will know how to manage all your social medias in one dashboard You will know how to schedule posts for every social media platform You will know which social media platforms you should focus on - and which ones you should run from Requirements You should know how to use a computer at a beginner level Who is the target audience? Everyone looking to manage multiple social media platforms in less time Everyone looking to market to more people without doing more work Everyone looking to become more socially viral   Module: 01 Introduction FREE 00:02:00 Welcome to HootSuite 00:04:00 Connecting Social Media Accounts 00:04:00 Publishing & Scheduling in HootSuite 00:07:00 Managing Your HootSuite Dashboard 00:02:00 Module: 02 Technical Detail - How to Remove App Permissions 00:01:00 HootSuite Analytics Overview 00:02:00 Should You Be On Facebook 00:04:00 Optimizing Your Facebook Page & Profile 00:18:00 Facebook Advertising Overview 00:01:00 Should You Be On Twitter 00:05:00 Module: 03 Should You Be On Google+ 00:02:00 Should You Be On LinkedIn 00:03:00 The Attractive Character Overview 123 00:10:00 Should You Be On YouTube 00:04:00 YouTube Video Lighting Training 2 00:01:00 Course Certification

This course delves into the intricate dynamics of consumer behavior within the vibrant domain of tourism and hospitality. It explores the psychology behind consumer choices and equips learners with insights into contemporary trends and adaptive strategies in this industry. This course equips learners with insights into the intricate dynamics of consumer decision-making, theories guiding consumer behavior, and the evolving landscape of consumer trends within tourism and hospitality sectors. By examining adaptive strategies, students gain an understanding of agile business models tailored to meet consumer demands and market shifts. After completing this course, you will be able to: Critically Analyse Consumer Behaviour. Learn Theories of Consumer Behaviour such as: Theory of Reasoned Action. Theory of Planned Behaviour. Motivation-need Theory. Impulse Buying. Analyse Contemporary Trends in Consumer Behaviour in the Tourism and Hospitality Industry. Understand How Tourism and Hospitality Businesses Have Adapted to Changes in Consumer Behaviour. Explore Agile Business Strategies in Tourism and Hospitality. "Consumer Behavior Principles in Tourism and Hospitality" explores how customer choices and preferences impact the industry. It covers consumer psychology, decision-making processes, and market trends shaping service offerings and experiences in tourism and hospitality sectors. Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. The Principles of Consumer Behaviour in the Tourism and Hospitality Industry Self-paced pre-recorded learning content on this topic. Consumer Behavior Principles in the tourism and hospitality industry Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be an added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. · Hospitality Managers· Tourism Marketing Professionals· Tourism Industry Professionalism· Customer Experience Managers· Customer Experience Enhancement· Hospitality and Tourism Management Strategies· Market Researchers· Strategic Marketing Management Specialization· Marketing Analytics Specialization· International Marketing Specialization Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Social Media Strategist will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Social Media Strategist will help you keep ahead of the pack. The Social Media Strategist incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and essential knowledge, reaching out to the level of expertise required for your position. Further, this Social Media Strategist will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Social Media Strategist, you can equip yourself with the essentials to keep you afloat into the competition. Along with this 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. This Bundle Consists of the following Premium courses: Course 01: Social Media Strategist Training Course 02: Instagram Marketing Course 03: Youtube Marketing Diploma Course 04: Facebook Marketing Course 05: Pinterest Marketing Course 06: Content Management Course 07: Blogging Course 08: Basic Adobe Photoshop Course 09: Advanced Diploma in Copywriting Course 10: Professional Photography Diploma Course 11: Freelancing on UpWork As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the Social Media Strategist to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this Social Media Strategist: One payment, but lifetime access to 11 CPD courses Certificate, 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 (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. Curriculum of the Bundle Course 01: Social Media Strategist Training The Rise of Social Media Conducting Market Analysis Auditing Social Media Setting Goals and Selecting Platforms Creating the Social Media Policy Integrating Marketing Strategies Developing Effective Content Understanding the Popular Platforms Launching Successful Campaigns Managing the Community Providing Customer Service Measuring, Analyzing and Reporting The Social Media Strategist Career Course 02: Instagram Marketing Episode 0: Intro Episode 1: Profile Presence Episode 2: Content Episode 3: Stories Episode 4: Analytics Episode 5: Followers Episode 6: Influencer Marketing Episode 7: Giveaways Course 03: Youtube Marketing Diploma How To Get More YouTube Views - INTRO How To Go Viral On YouTube How To Increase YouTube Views & Watchtime YouTube Thumbnails Great Video Ranking Tips Secret To Getting YT Views Likes & Subscribers Guru Secret - CPA Profits SEO WHITE PAPERS FOR YOUTUBE RANKING & SUGGESTED VIDEOS SEO WHITE PAPERS FOR YOUTUBE RANKING & SUGGESTED VIDEOS (Alison) TubeBuddy Tutorial Finding Great Keywords For Maximum Success YouTube Ranking - Video Description SEO YouTube Ranking - Turning Keywords into the Description Getting in Suggested YouTube Videos YouTube Ranking - Syndwire SynLab YouTube Rankings - Live Event Blaster YouTube Ranking - Translations for morw Views and Sales BONUS - Get More YouTube Veiws - Sharree BONUS - PilotPoster Course 04: Facebook Marketing Module 01: My Experience with Facebook Marketing Module 02: Facebook Marketing Basics Explained From Profiles to Groups and Pages Module 03: 1 Facebook Marketing Strategy Forever Module 04: Best Free Facebook Marketing Strategy to Build Relationships without Having a Group or Page Module 05: Facebook Group Case Studies of Success and Failure Module 06: Managing Our Facebook Group Memberships and Considering the Need for a New Group Module 07: Facebook Group Creation, Url Setting, And Posting Permission Tutorial Module 08: Fast Facebook Group Cover Photo Creation At 1604 X 856 Pixels with Canva In 2019 Module 09: Creating rules for Facebook groups and managing moderation to limit self-promotion and conflict Module 10: Create Events in Facebook Groups for Weekly Voice Calls to Build Relationships Module 11: Editing the Facebook Group Description and Membership Requirements Course 05: Pinterest Marketing Introduction To The Course Getting started with Pinterest Basics of Pinning - What You Should Know Pinning With Your Cell Phone Creating Pinterest Badges & Widgets Viewing Analytics on Pinterest & Rich Pins Tools & Automation Hiring a Virtual Assistant to help you with Pinterest marketing Paid Advertising with your pins Getting Graphics Designed For Pinterest Course 06: Content Management Module 01: Introduction to Content Management Module 02: Content Management System (CMS) Module 03: Basics of Content Management Systems Module 04: Content Strategy Module 05: Content Marketing Module 06: Content Marketing Tools and Tactics Module 07: Content Marketing Strategy Course 07: Blogging Week 1 - Introduction To Building a Blog Week 2 - Organization & Mindset Week 3 - Building Out The Core Structure Of Your Blog Week 4 - Leveraging Interviews for Success Course 08: Basic Adobe Photoshop Section 01: Shortcuts & the Brush Section 02: Layers Section 03: Modify Your Portrait Section 04: Watermark & Figures Section 05: Modify Your Text Course 09: Advanced Diploma in Copywriting Module 1: Introduction to Copywriting Module 2: Basics of Copywriting Module 3: Eye-Catching Headlines Module 4: Attention-Grabbing Advertisements Module 5: Essential Copywriting Skills Module 6: Online Copywriting Module 7: Press Related Copywriting Module 8: Print Media Copywriting Module 9: Copywriting for Mainstream Media Module 10: Copywriting for Other Media Module 11: How to Write Better Copy Module 12: Final Tips Course 10: Professional Photography Diploma Introduction Exposure Digital Photography Masterclass Focus and Depth of Field Camera Anatomy White Balance and Color Lighting Mobile Photography Equipment - Cameras Equipment - Lenses Equipment - Accessories Photo Scenario - Portrait Photo Scenario - Long Exposure Photo Scenario - Landscape Photo Scenario - Product Photo Scenario - Low Light Photo Scenario - Sports & Action Photo Scenario - Macro Photo Scenario - Street & Architecture Photo Scenario - Events Photo Scenario - Aerial Photo Scenario - Night Intro to Photo Editing Photoshop CC Lightroom Classic CC Lightroom CC Mac Photos Google Photos Photoshop Express Snapseed Sharing Your Photos Starting a Photo Business Selling Stock Photos Printing Wildlife Conclusion Course 11: Freelancing on UpWork Introduction & Overview Setting Up Your UpWork Profile Submitting Proposals To Jobs Pricing, Upgrading & Closing Sales Conclusion CPD 125 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Social Media Strategist bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Social Media Strategist 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 expertise will increase the value in your CV and open you up to multiple job sectors. 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 (Social Media Strategist Training) 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.

The aim of this course is to provide a comprehensive understanding of e-commerce and its organizational structure. By the end of this course, students will be able to compare conventional design and e-organization, understand the concept and dynamics of e-retailing, and apply the concept of e-services. After the successful completion of the course, you will be able to learn about the following, Compare Conventional Design and E-Organization Understand E-commerce Enterprise's Organizational Structure Understand the concept and dynamics of E-Retailing Understand and utilize a Conversion Funnel Understand and apply the concept of E-services. The aim of this course is to provide learners with a comprehensive understanding of the key concepts, principles, and dynamics of e-commerce enterprise, and the impact of technology on organizational structure, design, and operations. The course will explore the differences between conventional design and e-organization, with a focus on e-retailing, conversion funnel, and e-services. By the end of the course, learners will have developed the knowledge and skills required to evaluate, analyze, and implement effective e-commerce strategies to drive organizational growth and success. The aim of this course is to provide a comprehensive understanding of e-commerce and its organizational structure. By the end of this course, students will be able to compare conventional design and e-organization, understand the concept and dynamics of e-retailing, and apply the concept of e-services. They will also be able to utilize a conversion funnel to analyze customer behavior and optimize the e-commerce experience. This course aims to equip students with the skills and knowledge necessary to succeed in the ever-evolving e-commerce industry. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Managing the E-Enterprise Self-paced pre-recorded learning content on this topic. Managing the E-Enterprise Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course.The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. E-commerce Manager Chief Digital Officer Digital Marketing Manager Online Business Manager Web Analytics Manager Social Media Manager Customer Relationship Manager Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Business Analysis Fundamentals: In-House Training This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals to pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP™). This course teaches participants the overall process of business analysis and where it fits in the bigger picture of the project life cycle and the business context. The course is interactive and combines discussion, active workshops, and demonstrations of techniques. The goal is bottom-line results that cut through the real-world problems facing people seeking to improve the way they operate to develop new and improved systems and products or otherwise deliver results through project performance. What you will Learn At the end of this program, you will be able to: Define the solution scope Work with the development team in the systems testing stage Ensure the solution is usable in the business environment Foundation Concepts Defining the business analyst (BA) function The role of the BA as change agent An introduction to the BABOK® Guide BA roles and relationships through the project life cycle (PLC) Business Analysis Planning and Monitoring Overview of business analysis planning and monitoring (BAP&M) Business analysis planning and monitoring - process and tools Business analysis planning and monitoring - roles and responsibilities Business analysis planning and monitoring - governance, information management, and performance improvement Elicitation and Collaboration Overview of elicitation and collaboration Elicitation and collaboration techniques Requirements Life Cycle Management Overview of requirements life cycle management Requirements life cycle management task details Strategy Analysis Overview of strategy analysis Analyze current state Define future state Assess risks Define change strategy Requirements Analysis and Design Definition Overview of requirements analysis and design definition (RA&DD) The anatomy of requirements RA&DD task descriptions RA&DD techniques Solution Evaluation Overview of solution evaluation Solution evaluation tasks Solution evaluation in development stages Underlying Competencies Overview of underlying competencies (UC) Underlying competencies

Business Analysis Fundamentals This course is part of IIL's Business Analysis Certificate Program (BACP), a program designed to help prepare individuals to pass the IIBA® Certification exam to become a Certified Business Analysis Professional (CBAP™). This course teaches participants the overall process of business analysis and where it fits in the bigger picture of the project life cycle and the business context. The course is interactive and combines discussion, active workshops, and demonstrations of techniques. The goal is bottom-line results that cut through the real-world problems facing people seeking to improve the way they operate to develop new and improved systems and products or otherwise deliver results through project performance. What you will Learn At the end of this program, you will be able to: Define the solution scope Work with the development team in the systems testing stage Ensure the solution is usable in the business environment Foundation Concepts Defining the business analyst (BA) function The role of the BA as change agent An introduction to the BABOK® Guide BA roles and relationships through the project life cycle (PLC) Business Analysis Planning and Monitoring Overview of business analysis planning and monitoring (BAP&M) Business analysis planning and monitoring - process and tools Business analysis planning and monitoring - roles and responsibilities Business analysis planning and monitoring - governance, information management, and performance improvement Elicitation and Collaboration Overview of elicitation and collaboration Elicitation and collaboration techniques Requirements Life Cycle Management Overview of requirements life cycle management Requirements life cycle management task details Strategy Analysis Overview of strategy analysis Analyze current state Define future state Assess risks Define change strategy Requirements Analysis and Design Definition Overview of requirements analysis and design definition (RA&DD) The anatomy of requirements RA&DD task descriptions RA&DD techniques Solution Evaluation Overview of solution evaluation Solution evaluation tasks Solution evaluation in development stages Underlying Competencies Overview of underlying competencies (UC) Underlying competencies

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