307 Microsoft Power Apps courses

Learn the Latest Skills | Acknowledged by CPD | MCQ Based Exam & Tutor Support | Interactive Video Training  If you are interested in gaining a position as a highly paid Office Administrator, Secretary, or Personal Assistant, then this lesson from Janets is the perfect opportunity. The course focuses on building practical knowledge so that upon successful completion you are fully prepared for work. Whether you are a complete beginner or have some experience, this course covers everything in a concise manner. Gain the confidence to excel in any office or commercial environment by gaining the necessary knowledge of administration, computer, and management techniques. This cutting-edge online course is taught by industry experts with continuing expert involvement, and it teaches you immediately applicable skills. Our Diploma can provide you with the insight, skills and knowledge you need to succeed in this busy career. What Will You Learn? Understand succession planning. Learn the basic computer software you need to know to perform at your best on a daily basis. How to work to a schedule to achieve the best results.. How to present documents and proofread. Organise effective meetings. How to categorise, sub-categorise and manage your filing system effectively. What classes are included in this package? Earn a digital certificate upon successful completion acknowledged by UK and internationally acknowledged lesson There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you’ll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? This course is designed for those seeking senior secretarial or administrative jobs in an organization, as well as newcomers seeking their first job in an office setting. Although a good command of the English language is assumed, no prior experience or knowledge is required. Career Path Training offered by the Office Admin, Secretarial and PA could potentially benefit a range of roles, but would particularly enhance careers in: Office Administration Personal Assistant Receptionist Secretary Other administration roles Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessments Assignment Certificate of Achievement after the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment On successful completion of the Office Admin, Secretarial and PA Diploma, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically and the results will be given to you immediately. Retake fee If you do not pass the exam first time, you can purchase the Retake Exam for £1.99 and try again. Course Contents Office Admin, Secretarial and PA Diploma Microsoft Word Microsoft PowerPoint Microsoft Excel Recommended Reading Mock Exam Final Exam Recommended Materials Assignment

This Access 2016 Intermediate is specially designed for you if you are thinking to take your Microsoft Access skills to the next level. Through the course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.  From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications, including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Finally, you'll build a navigation form to make it easy for your users to find their way around your database.  What Will I Learn? Design Tables for Better Data Entry Share Data with Other Applications Work with Action Queries Advanced Query Techniques Automate Processes with Macros Advanced Forms Advanced Report Techniques Requirements Access 2016 Introduction or equivalent experience. Who is the target audience? Students who want to take Access to the next level and improve their database design skills. Introduction Introduction FREE 00:01:00 Designing Tables for Better Data Entry Reviewing Table Design Principles 00:04:00 Setting Field Size, Formats and Captions 00:06:00 Setting Default Value and Required Fields 00:03:00 Restricting Data Entry Using Data Validation 00:02:00 Restricting Data Entry Using Input Masks 00:06:00 Sharing Data with Other Applications Exporting Tables and Queries to Excel 00:03:00 Importing Data from a TXT File 00:03:00 Importing Data from Excel 00:02:00 Exporting Data to a TXT File 00:02:00 Linking External Data Sources 00:03:00 Using Word Merge 00:02:00 Working with Action Queries What are Action Queries 00:02:00 Creating an Update Query 00:02:00 Creating an Append Query 00:03:00 Creating a Delete Query 00:02:00 Creating a Make Table Query 00:02:00 Changing the Start Number of an Auto Number Field 00:03:00 Advanced Query Techniques Creating Query Joins 00:05:00 Creating Find Unmatached and Find Duplicate Queries 00:03:00 Creating Parameter Queries 00:04:00 Using -Like- Keyword in Parameter Queries 00:02:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:03:00 Summarizing Query Data with Totals 00:03:00 Inserting Where Statements in Summary Queries 00:01:00 Creating a Crosstab Query 00:03:00 Automating Processes with Macros Understanding Macro Basics 00:06:00 Creating Macros to Open Forms by Record 00:04:00 Validating Data Entry with Macros 00:04:00 Creating a Macro to Automate Data Entry 00:03:00 Advanced Data Entry Using Macros and DLOOKUP Function 00:06:00 Advanced Form Using Conditional Formatting 00:02:00 Organizing Form Fields with Tab Controls 00:03:00 Creating a Combo Box Control 00:02:00 Creating an Option Group Control 00:03:00 Using a Subform to Show Data from a Related Table 00:03:00 Advanced Report Techniques Inserting a Chart on a Report 00:03:00 Showing Data in Columns 00:02:00 Inserting a Subreport 00:02:00 Configuring Reports with Parameter Queries 00:04:00 Sending Reports 00:02:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Intermediate 00:00:00 Course Certification

Microsoft Office 365 is an innovative computer program and highly suggested for individuals who are regularly on the go. This Office 365 Core Apps course introduces you to the Microsoft Word, Excel, and PowerPoint Online apps which are an integral part of the Office 365 suite. By enrolling in this course, you'll acquire essential skills for producing professional work with the Microsoft Office suite and access many of the Office tools and features online from any device with an Internet connection. This course includes both basic and advanced features of MS Office and explains the difference in the online versions of Word, Excel, and PowerPoint, and how to edit the online documents. You'll also learn to open and save online documents in desktop versions of Office products. What Will I Learn? Open and save online files in Office Edit documents in Office Online Learn what is different in Microsoft Word, Excel, and PowerPoint Online View and add comments to documents Print and share documents Use co-authoring for collaboration Requirements Familiarity with the desktop versions of Microsoft Word, Excel, and PowerPoint Introduction Introduction FREE 00:02:00 Working with Word, Excel, and PowerPoint Online Opening Files in Office 00:06:00 Saving Files 00:04:00 Editing Documents in Office Online 00:04:00 What is Different in Word? 00:05:00 What is Different in Excel? 00:05:00 What is Different in PowerPoint? 00:06:00 Viewing and Adding Comments 00:07:00 Printing and Sharing Documents 00:06:00 Using Co-Authoring for Collaboration 00:04:00 Course Recap 00:01:00 Course Certification

The Microsoft Office 2016 Excel PowerPivot is designed for new PowerPivot users to get up to speed on how it works and its feature set. The course covers different features of the interface, techniques for manipulating PowerPivot data, how to create PowerPivot reports, the structure of DAX functions, and ways to distribute PowerPivot data. You will learn how to enable and navigate Power Pivot, how to manage data relationships, how to visualize Power Pivot data, how to create a Power Pivot report, and more. You will also learn some commonly used DAX functions. Prerequisite Course: Excel Level 3 or equivalent. Course Highlights Microsoft Office 2016 Excel PowerPivot is an award-winning and the best selling course that has been given the CPD Qualification Standards & 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 Microsoft Office 2016 Excel PowerPivot into 19 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 12 hours, 30 minutes 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 Microsoft Office 2016 Excel PowerPivot Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards 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? Microsoft Office 2016 Excel PowerPivot is CPD Qualification Standards 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 Microsoft Office 2016 Excel PowerPivot 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 Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Office 2016 Excel PowerPivot Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Office 2016 Excel PowerPivot 00:00:00

Description MS office introduces different types of app to make human work faster and easier. MS Office Core Apps is one of them that is usually considered as an introduction to Excel, PowerPoint, and Microsoft Word. It deals with different tools and various function of it which you can learn from the MS Office 365 Core Apps course in details. The course is designed in such a way that assists the learners to know how to access different office tools and features with the help of any internet connected device. It shows how to create and save data of Office products in desktop version along with the assistance of collaborative work. The course helps to distinguish the difference between offline and online version MS Word, Excel, and PowerPoint to show how to edit online using effective tools besides the collaboration with sharing, comments, and comments, sharing and co-authoring. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS Office 365 Core Apps is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our MS Office 365 Core Apps 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:02:00 Working with Word, Excel, and PowerPoint Online Opening Files in Office 00:06:00 Saving Files 00:04:00 Editing Documents in Office Online 00:04:00 What is Different in Word? 00:05:00 What is Different in Excel? 00:05:00 What is Different in PowerPoint? 00:06:00 Viewing and Adding Comments 00:07:00 Printing and Sharing Documents 00:06:00 Using Co-Authoring for Collaboration 00:04:00 Course Recap 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The innovative Award in Power BI Formulas has been compiled with the assistance and expertise of industry professionals. It has been carefully crafted to meet the business requirements needed for an outstanding contribution to this role and the career path beyond it. By enrolling in this tutorial, a significant advantage can be gained by the student for securing their dream job and building an excellent reputation in this sector.  This popular Award in Power BI Formulas has been designed to help dedicated individuals train to become the absolute best in this business field. Many other entrepreneurs and talented students have already completed this course, and others like it, empowering them to move onto satisfying and rewarding careers. This unique Award in Power BI Formulas course is perfectly suited for those dedicated and ambitious individuals who are committed to genuinely becoming the best in the business.  The Award in Power BI Formulas is recognised and accredited by CPD standards, so all contents are guaranteed to be accurate and reputable, adding valuable competencies and qualifications to a CV, making anyone stand out from other potential candidates or business rivals. For added convenience, the Award in Power BI Formulas consists of a range of educational modules that allow study sessions to be organised at any time and any place. When the final assessment of the Award in Power BI Formulas has been completed, a certificate of completion is supplied to evidence newly acquired skills and knowledge. This will provide a significant boost for job-seeking or entry into a new and exciting career path. The valuable qualification from the Award in Power BI Formulas course can help to make all the difference in a dynamic employment sector and can also be validated on our website. We are aware that a student's lifestyles and work ethics may not allow much time for a dedicated study session, so the Award in Power BI Formulas has been specifically designed to be taken at a personally selected pace, and the hours that are suited to each individual. Full access is immediately available after registration, and this can be achieved via any online device, and at any global location you are sighted at. Our fully-trained tutors are committed to helping you throughout the course, and will instantly respond to any queries that are sent to them via email.

PowerPoint for Business in 60 Minutes   Course Description   Copyright Ross Maynard 2021   Course Description Welcome to PowerPoint for Business in 60 Minutes.   Microsoft PowerPoint has been around for nearly 35 years, and I am sure you are familiar with it, and have experienced many PowerPoint presentations – some good; many extremely tedious! Creating a business presentation in PowerPoint presents a number of challenges and there is a danger of “death by PowerPoint”. I recently attended a meeting which was supposed to be a planning discussion but which the person leading the meeting insisted on introducing with a PowerPoint presentation of 60 slides – mostly bullet points! We were hardly in the mood for action planning after that assault on our senses.  PowerPoint is good for presenting business results or for a training course, but you need to plan your slideshow carefully to avoid bullet-point boredom and to keep your audience engaged and interested. And that is the purpose of this course – to teach you PowerPoint techniques which you may not be familiar with, and which will help you improve the impact of your business presentations.   Less is more in a slide show so it is important to use techniques and effects which will help engage your audience and draw their attention to the points that matter.  In “PowerPoint for Business in 60 Minutes”, I cover six key topics that will help you produce more impactful business presentations: The best slide transitions and animations for business presentations The morph transition to make the narration of an agenda, or similar list, or a team photograph extremely slick and professional The Zoom effect to create a summary slide with hyperlinks to zoom into the section that you or your audience choose How to animate charts to highlight the key points you want to bring out How to embed Excel tables with slicers into PowerPoint, and why PowerPoint is not developed enough to make this useful for a business presentation How to turn your PowerPoint presentation into a video. This is the technique I am most often asked how to do.   This is not a full “PowerPoint from scratch” course: it assumes familiarity of Microsoft’s ubiquitous programme. Instead, the course takes only 1 hour of your time to focus on key techniques that can help you improve the impact of the presentations you create.   I hope you enjoy the course.     Key Learning Points  On completion of the course, delegates will be able to: Identify the most useful slide transitions and animations for business presentations Use the morph transition to draw the audience’s attention Create a “zoom” summary slide to jump to user-selected sections of slides Animate charts to highlight key points Embed a Microsoft Excel table in a PowerPoint slide Create a video with commentary of their PowerPoint presentation     Curriculum Lesson 1: Transitions and Animations Lesson 2: The Morph Transition Lesson 3: Zoom Lesson 4: Animating Charts Lesson 5: Excel Tables and Slicers in PowerPoint (or Not!) Lesson 6: Making a PowerPoint Video     Pre-Course Requirements There are no pre-course requirements     Additional Resources None     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What slide effect allows you to give the illusion of moving around a larger “page”? The Wipe transition. The Dissolve transition. The Push transition. The Fly-In animation   What does “Zoom” in PowerPoint allow you to do? Zoom creates the illusion of “zooming in” on a particular part of a slide Zoom creates a summary slide with hyperlinks to the individual slides or sections contained in the summary Zoom creates a smooth object animation from one slide to another to animate, for example, an agenda or timeline Zoom is used to highlight areas of a chart or graphic to draw the audience’s attention   What is the main problem with embedding a Microsoft Excel table with slicers into PowerPoint? The slicers do not work, and the table cannot be manipulated, in presentation mode in PowerPoint The table cannot be opened or manipulated in PowerPoint slide view Microsoft Excel and PowerPoint are incompatible with each other The file size created is too large for most business PCs to handle   When seeking to create an MP4 video file from a PowerPoint presentation, why is it advisable to record the commentary separately? PowerPoint’s built-in recording facility is unreliable and frequently crashes It’s much quicker to record the audio separately and then insert it into PowerPoint and save as a video file Separate video editing software needs to be used to improve the video’s look and sound where the audio is recorded directly in PowerPoint It removes the stress of commentating “live” on the presentation while recording it, and allows any mistakes and errors to be cut out  

Duration 1 Days 6 CPD hours This course is intended for This course is designed for students who wish to gain a foundational understanding of PowerPoint that is necessary to create and develop engaging multimedia presentations. Overview In this course, you will create and deliver an engaging PowerPoint presentation. You will: Identify the basic features and functions of PowerPoint. Develop a PowerPoint presentation. Perform text formatting. Add and arrange graphical elements. Modify graphical elements. Prepare to deliver your presentation. How do you grab and maintain an audience's focus when you're asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft© PowerPoint© can help you do.Today's audiences are tech savvy, accustomed to high-impact multimedia content, and stretched for time. By learning how to use the vast array of features and functionality contained within PowerPoint, you will gain the ability to organize your content, enhance it with high-impact visuals, and deliver it with a punch. In this course, you will use PowerPoint to begin creating engaging, dynamic multimedia presentations.Note: Most Office users perform the majority of their daily tasks using the desktop version of the Office software, so that is the focus of this training. The course material will also enable you to access and effectively utilize many web-based resources provided with your Microsoft 365 subscription. This includes brief coverage of key skills for using PowerPoint for the Web and OneDrive. Helpful notes throughout the material alert you to cases where the online version of the application may function differently from the primary, desktop version.This course may be a useful component in your preparation for the Microsoft PowerPoint (Microsoft 365 Apps and Office 2019): Exam MO-300 certification exam. Lesson 1: Getting Started with PowerPoint Topic A: Navigate the PowerPoint Environment Topic B: View and Navigate a Presentation Topic C: Create and Save a Basic Presentation Topic D: Navigate in PowerPoint for the Web Topic E: Use PowerPoint Help Lesson 2: Developing a PowerPoint Presentation Topic A: Create Presentations Topic B: Edit Text Topic C: Work with Slides Topic D: Design a Presentation Lesson 3: Formatting Text Topic A: Format Characters Topic B: Format Paragraphs Lesson 4: Adding and Arranging Graphical Elements Topic A: Insert Images Topic B: Insert Shapes Topic C: Create SmartArt Topic D: Insert Stock Media, Icons, and 3D Models Topic E: Size, Group, and Arrange Objects Lesson 5: Modifying Graphical Elements Topic A: Format Images Topic B: Format Shapes Topic C: Customize SmartArt Topic D: Format Icons Topic E: Format 3D Models Topic F: Animate Objects Lesson 6: Preparing to Deliver Your Presentation Topic A: Review Your Presentation Topic B: Apply Transitions Topic C: Print or Export a Presentation Topic D: Deliver Your Presentation Additional course details: Nexus Humans Microsoft PowerPoint for Office 365 (Desktop or Online) - Part 1 ( v1.1) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft PowerPoint for Office 365 (Desktop or Online) - Part 1 ( v1.1) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients. This course is also designed for professionals who want to pursue the Microsoft Power BI Data Analyst (Exam PL-300) certification. Overview In this course, you will analyze data with Microsoft Power BI. You will: Analyze data with self-service BI. Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Enhance data analysis by adding and customizing visual elements. Model data with calculations. Create interactive visualizations. Use advanced analysis techniques. Enhance reports and dashboards. Publish and share reports and dashboards. Extend Power BI beyond the desktop. As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of 'big data' is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Microsoft© Power BI© software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. Analyzing Data with Self-Service BI Topic A: Data Analysis and Visualization for Business Intelligence Topic B: Self-Service BI with Microsoft Power BI Connecting to Data Sources Topic A: Create Data Connections Topic B: Configure and Manage Data Relationships Topic C: Save Files in Power BI Performing Data Cleaning, Profiling, and Shaping Topic A: Clean, Transform, and Load Data with the Query Editor Topic B: Profile Data with the Query Editor Topic C: Shape Data with the Query Editor Topic D: Combine and Manage Data Rows Visualizing Data with Power BI Topic A: Create Visualizations in Power BI Topic B: Chart Data in Power BI Enhancing Data Analysis Topic A: Customize Visuals and Pages Topic B: Incorporate Tooltips Modeling Data with Calculations Topic A: Create Calculations with Data Analysis Expressions (DAX) Topic B: Create Calculated Measures and Conditional Columns Creating Interactive Visualizations Topic A: Create and Manage Data Hierarchies Topic B: Filter and Slice Reports Topic C: Create Dashboards Using Advanced Analysis Techniques Topic A: Create Calculated Tables, Variables, and Parameters Topic B: Enhance Visuals with Statistical Analysis Topic C: Perform Advanced Analysis Enhancing Reports and Dashboards Topic A: Enhance Reports Topic B: Enhance Dashboards Publishing and Sharing Reports and Dashboards Topic A: Publish Reports Topic B: Create and Manage Workspaces Topic C: Share Reports and Dashboards Extending Power BI Beyond the Desktop Topic A: Use Power BI Mobile Topic B: Extend Access with the Power BI API Additional course details: Nexus Humans Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft Power BI: Data Analysis Professional (Second Edition) (v1.3) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients. Overview In this course, you will analyze data with Microsoft Power BI. You will: Analyze data with self-service BI. Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Enhance data analysis by adding and customizing visual elements. Model data with calculations. Create interactive visualizations. As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of 'big data' is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Microsoft© Power BI© software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. Analyzing Data with Self-Service BI Topic A: Data Analysis and Visualization for Business Intelligence Topic B: Self-Service BI with Microsoft Power BI Connecting to Data Sources Topic A: Create Data Connections Topic B: Configure and Manage Data Relationships Topic C: Save Files in Power BI Performing Data Cleaning, Profiling, and Shaping Topic A: Clean, Transform, and Load Data with the Query Editor Topic B: Profile Data with the Query Editor Topic C: Shape Data with the Query Editor Topic D: Combine and Manage Data Rows Visualizing Data with Power BI Topic A: Create Visualizations in Power BI Topic B: Chart Data in Power BI Enhancing Data Analysis Topic A: Customize Visuals and Pages Topic B: Incorporate Tooltips Modeling Data with Calculations Topic A: Create Calculations with Data Analysis Expressions (DAX) Topic B: Create Calculated Measures and Conditional Columns Creating Interactive Visualizations Topic A: Create and Manage Data Hierarchies Topic B: Filter and Slice Reports Topic C: Create Dashboards Additional course details: Nexus Humans Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.3) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Microsoft Power BI: Data Analysis Practitioner (Second Edition) (v1.3) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.