This course is designed for those already using Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Power Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations. The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with business examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI's analytical capabilities in more depth. 1 The Query Editor Grouping rows in a table Split row by delimiter Add days to determine deadlines The query editor 2 Fuzzy Matching Joins Matching inconsistencies by percentage Matching with transformation table 3 The Query Editor M Functions Adding custom columns Creating an IF function Nested AND logics in an IF function 4 DAX New Columns Functions Including TRUE with SWITCH Using multiple conditions The FIND DAX function The IF DAX function Logical functions IF, AND, OR 5 Editing DAX Measures Making DAX easier to read Add comments to a measure Using quick measures 6 The Anatomy of CALCULATE Understanding CALCULATE filters Add context to CALCULATE with FILTER Using CALCULATE with a threshold 7 The ALL Measure Anatomy of ALL Create an ALL measure Using ALL as a filter Use ALL for percentages 8 DAX Iterators Anatomy of iterators A closer look at SUMX Using RELATED with SUMX Create a RANKX RANKX with ALL 9 Date and Time Functions Overview of functions Create a DATEDIFF function 10 Time Intelligent Measures Compare historical monthly data Create a DATEADD measure Creating cumulative totals Creating cumulative measures Visualising cumulative totals 11 Visualisations In-Depth Utilising report themes Applying static filters Group data using lists Group numbers using bins Creating heatmaps Comparing proportions View trends with sparklines 12 Comparing Variables Visualising trendlines as KPI Forecasting with trendlines Creating a scatter plot Creating dynamic labels Customised visualisation tooltips Export reports to SharePoint
dvanced Course This MS Project Advanced course is an intensive, hands-on, one-day training course, concentrating on complex calendars, complex costs, multiple baselines, multiple projects and other advanced MS Project features. This is a one day course, one a one-to-one basis, attending to individual questions and issues. Group bookings could be requested
DATE: 16th October TIME: 4pm LOCATION: Studio A Facilitated by Alice Coyle, Student Counsellor. This is a practical workshop to help you understand more about how anxiety, perfectionism and procrastination can get in the way of getting stuff done. Whether you are a starter or into your final year after, It is timed to help you prepare for your first written assignment and set you up for the year ahead, without all the angst that can really hold you back from enjoying your college studies and life. You may feel that no one else struggles as much as you do over getting work submitted. By sharing ideas and tips together in small groups of 2 or 3, you may be surprised by how much you have in common with your fellow students and how much you can learn from each other.
DATE: 20th March TIME: 4pm LOCATION: Studio A Central Film School are delighted to invite Alexis Watkins to speak to our student body about the importance of mental wellbeing and the keys to mental safeguarding for both yourself and other students. Alexis has professional experience in the following roles: - Mental Health Practitioner & Data Analyst for BWW Mind - Chair of Central & North West London (CNWL) NHS Mental Health Ambassador Group - Vice Chair of the Board of Trustees for the WïSH Centre - National Lived Experience Partner for NHS England She has filmed with the CNWL and was recently part of a team nominated at the Health Service Journal awards for Reducing Healthcare Inequalities for Children and Young People award. She has also been a guest-speaker at The Listening Place, a charity focused on helping those with suicidal thoughts. She will be joining us to specifically discuss topics of isolation, substance abuse and suicidal ideation. Even if you are fortunate enough not to be struggling with your mental health currently, it is always worth being aware of the signs and knowing how to help others, so please consider coming along to this event if you feel comfortable doing so.
This MS Access Advanced Course mostly covers creating advanced MS Access reports, forms, and macros. Create and amend Advanced Forms and Advanced Reports. Macro buttons. This assists you to build user-friendly forms to facilitate effective navigation, effective data capture and effective viewing and querying data This course will help you to structure MS Access tables, import, and manage your data effectively.
Hello there, tiny tumblers and little leapers! Welcome to our delightful Acro Beginners Dance Class, meticulously designed for our budding acrobats aged between 5 and 9. Are you ready to jump into an exciting world of flips, spins, and maybe a cartwheel or two? If your answer is a resounding "Yes!", then you're in the right place. Acro dance is a unique style that combines the grace of dance with the thrill of acrobatics. Our Acro Beginners class is the perfect introduction to this fascinating dance form. From the moment your little one steps onto our specially designed acro mats, they'll be set for an exhilarating journey of discovery! Our class starts with basic acrobatic tricks that are as fun to learn as they are to perform. We'll be somersaulting, cartwheeling, and even handstanding our way into the world of acro dance. Our friendly and experienced instructors will ensure that each child learns at their own pace in a safe and supportive environment. But we'll be doing more than just acrobatics. We're also working on enhancing flexibility, balance, and stretching. Through a variety of engaging activities and exercises, your child will develop these skills, becoming not just a better acro dancer, but also a more confident mover! Yet, our Acro Beginners class is not just about learning acro dance. We believe that dance is an invaluable tool for teaching life skills. Through acro dance, your child will improve their self-esteem, learn to work as part of a team, and even develop resilience. Each cartwheel, leap, and roll is a lesson in determination and self-belief! And let's not forget the wonderful friends your child will make in our class. Acro dance is about collaboration and trust, and our class is a community of little acrobats supporting and cheering for each other. Your child will make friendships that go beyond the dance floor, creating beautiful memories along the way. So, lace up your dancing shoes, little acrobats! It's time to tumble, flip, and leap into the captivating world of acro dance. We can't wait to welcome you to our Acro Beginners Dance Class and start this exciting journey together. Remember, acro dance is about having fun, expressing yourself, and working together. So, let's embark on our acro adventure, where every flip and roll is a step towards joy and self-confidence! See you on the dance mat!
This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson
There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups
MS PowerPoint is really easy, but in this PowerPoint Training Courses, we cover most aspects in a fast-paced day, and attend the to more tricky aspects. This course is one-to-one to attend to specific aspects per delegate. Group training could be organised on request.