Category: Business Consulting, Business Skills, Data & Business Analysis, Technology

Description:

Accredited Activities:

Power BI Introduction

Get a solid introduction to Power BI, starting with how to connect to data sources and transform raw data into meaningful insights. This course covers data cleansing, shaping, and visualization, allowing participants to create impactful dashboards and reports. Learn the essential skills needed to turn raw data into interactive, shareable insights that drive better decision-making. By the end of this course, learners will be able to:

• Identify the different Power BI products, including Power BI Desktop, the Power BI Service, Power BI Mobile Apps, and understand the differences between free and Pro subscriptions.
• Connect to a wide range of data sources, such as text files, Excel workbooks, folders, and web data, and import these data sources into Power BI.
• Use the Query Editor to clean and transform data, performing tasks such as renaming queries, modifying columns, splitting and merging columns, and using functions like Trim and Clean.
• Organize and model data by creating relationships, defining primary and foreign keys, setting cross-filtering directions, and creating composite keys.
• Write basic DAX expressions to create calculated columns and measures, and utilize DAX functions such as SUMX, CALCULATE, and RELATED to enhance data analysis.
• Create and customize visualizations, including column and bar charts, gauges, treemaps, and maps, and format them using themes, branding, and visual-level filters.
• Publish and share reports and dashboards in the Power BI Service, create app workspaces, and manage access through app workspaces and publishing processes.
• Optimize content for mobile use by creating mobile-friendly versions of dashboards and reports.

Power BI Intermediate

Take your Power BI skills to the next level with advanced data modeling and visualization techniques. This course introduces row-level security, report page navigation, and custom visuals. Participants will learn to build more dynamic, interactive reports and gain the skills needed to produce professional-grade dashboards that engage and inform stakeholders. By the end of this one-day Power BI Intermediate DAX training course, participants will be able to:

• Create dynamic report titles that adjust based on user selections by leveraging DAX functions such as SELECTEDVALUE and CONCATENATEX
• Enhance user interactivity within reports by using DAX functions to display personalized information like user names and last refresh timestamps
• Apply dynamic formatting in measures to produce visual cues such as RAG (Red-Amber-Green) color indicators and custom images
• Use DAX ranking functions like RANKX and TOPN to perform advanced ranking, including ranking within specific groups
• Utilize DAX Time Intelligence functions to analyze trends over time, including year-to-date, quarter-to-date, and month-to-date calculations, while understanding the use of calendar tables
• Implement semi-additive measures to address non-standard aggregation needs, ensuring accurate data representation in specific visualizations

Power BI Advanced

Push the boundaries of what’s possible with Power BI. This advanced course covers in-depth DAX (Data Analysis Expressions), complex data modeling, and performance optimization techniques. Learn how to handle large datasets, design calculation-heavy dashboards, and master techniques for faster query performance. By the end of this course, you’ll be equipped to create enterprise-level reports and data models. The course will equip delegates with the following skills:

• Apply M language to create parameters and perform data transformations in Power Query.
• Use M language transformations like Table.PromoteHeaders and Table.NestedJoin to manage data from multiple sources.
• Build custom functions in Power Query to automate data processing tasks.
• Utilize Power BI Dataflows for centralized data preparation.
• Connect Power BI to SQL Server, optimizing data import and refresh settings.
• Create and manage relationships in data models for robust relational structures.
• Optimize data models with schema design techniques and by hiding unused columns.
• Use DAX to create calculated columns, measures, and advanced data manipulations.
• Apply advanced DAX functions like RANKX and CALCULATE for complex analyses.
• Build and use hierarchies to enable drill-downs and improve data exploration.
• Perform time-based calculations with DAX Time Intelligence functions.

Power BI DAX Introduction

Master the essential skills of DAX (Data Analysis Expressions), Power BI’s formula language for creating calculated columns, measures, and tables. This course is ideal for beginners looking to build a strong foundation in DAX logic. Learn how to create simple calculations, apply key functions, and leverage the power of calculated measures to drive dynamic, data-driven reporting. By the end of this one-day Introduction to Power BI DAX course, participants will be able to:

• Understand the basics of DAX syntax and how to use DAX objects and operators effectively.
• Create and apply calculated columns to add new fields based on existing data within the data model.
• Build calculated tables and understand when to use them, including creating date tables and using functions like DISTINCT and FILTER.
• Develop and use measures for dynamic calculations in visuals, gaining insight into the differences between implicit and explicit measures.
• Use iterator functions such as SUMX, AVERAGEX, and COUNTX to perform calculations across rows, and understand the distinction between implicit and explicit iteration.
• Comprehend calculation contexts in DAX, including row context, filter context, and context transition.
• Apply the basics of the CALCULATE function, using it with Boolean logic and filter functions to modify calculation contexts.

Power BI DAX Intermediate

Build on your DAX foundation by learning to create more complex calculations and logic. This course covers time intelligence functions, dynamic filtering, and ranking techniques. Participants will develop the ability to create flexible, dynamic dashboards with smarter calculations and gain insight into using advanced DAX functions to solve business challenges. By the end of this one-day Power BI DAX Intermediate course, participants will be able to:

• Create dynamic titles in Power BI visuals by using DAX functions like SELECTEDVALUE and CONCATENATEX for customized user interactivity.
• Apply dynamic formatting techniques, including conditional formatting rules and RAG (Red-Amber-Green) colors, to enhance data visualization.
• Leverage the USERNAME function to personalize content and set up row-level security for more secure, user-specific reports.
• Use ranking functions such as RANKX and TOPN to perform advanced ranking, including ranking within specific groups.
• Utilize DAX Time Intelligence functions for date-based analysis, such as TOTALYTD, TOTALQTD, TOTALMTD, and SAMEPERIODLASTYEAR.
• Implement semi-additive measures to manage complex aggregation needs, ensuring accurate representation in specific visualizations.
• Participants will leave with a solid understanding of intermediate DAX techniques, confident in their ability to build interactive, user-responsive reports with advanced analysis capabilities.

Power BI DAX Advanced





Advance to expert-level DAX skills with this hands-on course. Learn to use calculation groups, path functions, and context manipulation to develop powerful custom measures. This course is designed for experienced Power BI users who want to create next-level business logic and improve dashboard performance through advanced DAX strategies. By the end of this one-day Power BI DAX Advanced course, participants will be able to:

• Create What-if parameters using DAX functions like GENERATESERIES to empower users with control over DAX measures.
• Utilize advanced grouping functions such as SUMMARIZE, SUMMARIZECOLUMNS, and GROUPBY to dynamically aggregate data within reports.
• Combine tables with DAX using functions like UNION, CROSSJOIN, INTERSECT, and EXCEPT to extend analysis across multiple datasets.
• Manipulate and refine filters with advanced filter functions including ALL, ALLSELECTED, REMOVEFILTERS, and USERELATIONSHIP to achieve precise filtering and control over data visibility.
• Apply DAX Path functions (e.g., PATH, PATHCONTAINS, PATHLENGTH) to create hierarchies and navigate parent-child relationships in complex datasets.
• Build and manage Calculation Groups using Tabular Editor to streamline and enhance measure calculations, including the use of SELECTEDMEASURE for dynamic analysis.
• Define and apply dynamic format strings in Calculation Groups to control and customize measure formatting based on context.

Power Query M Language





Take control of your data preparation process by mastering Power Query’s M language. This course teaches you how to write custom M code to handle complex data transformations, automate workflows, and create reusable queries. Learn how to filter, merge, and manipulate datasets at scale while saving time on repetitive data prep tasks. By the end of this course, participants will be able to:

• Understand the M language structure, including the let ... in statement, variables, and comments, to write and debug custom scripts in Power Query.
• Identify and apply appropriate M data types, including special and complex types, and perform effective type conversions for accurate data transformations.
• Connect to and transform data from various sources, including text files and Excel, using advanced Power Query techniques like File.Contents, Csv.Document, and Excel.Workbook.
• Create and utilize custom functions in Power Query to automate repetitive tasks and enhance efficiency in data preparation workflows.
• Work with lists and iterative logic to perform complex data transformations, such as combining data from multiple files or maintaining dynamic file lists.
• Master table functions like Table.SelectColumns and Table.RemoveColumns to manipulate and reshape datasets effectively.
• Use text functions for string manipulation, including case standardization, whitespace handling, splitting, joining, and advanced string analysis.
• Leverage date and time functions to build custom date tables, calculate elapsed times, and dynamically extract year, month, and day information from date fields.
• Implement robust error handling and debugging techniques to manage structural errors, incomplete edits, and replace or catch errors during transformations.

Power BI Administration





Master the skills required to become a Power BI administrator. This course covers tenant settings, governance policies, and data security controls. Learn how to manage users, workspaces, and security roles to ensure your organization’s Power BI environment is safe, secure, and properly governed. By the end of this Power BI Administration course, participants will be able to:

• Understand and configure Power BI tenant settings, including workspace, sharing, export, and support settings, to meet organizational needs.
• Assign and manage administrative roles in Power BI, Microsoft 365 Admin Center, and Azure Active Directory.
• Design and structure Power BI workspaces effectively, including assigning roles and implementing deployment pipelines for better content management.
• Implement data governance best practices by managing dataflows, shared datasets, and data source parameters, and setting up the on-premises data gateway and refresh schedules.
• Apply content administration practices to manage reports, dashboards, and custom visuals, including controlling accessibility, subscriptions, and sensitivity labels.
• Set up and oversee sharing and embedding options in Power BI, including data classification for dashboards and monitoring embed codes for published content.

Power Automate Introduction





Learn to create time-saving workflows and process automation with Power Automate. This introductory course covers flow triggers, multi-step approvals, and integration with Microsoft 365 apps. By the end of this course, you’ll be able to create sophisticated, automated workflows that save time and boost efficiency, all while ensuring your business processes run smoothly. By the end of the training, delegates will be able to:

• Understand the key components of Power Automate and its ecosystem, including triggers, actions, and connectors.
• Navigate and customize templates for common workflows such as file management and communication automation.
• Use the Power Automate mobile app to manage, edit, and trigger flows on the go.
• Create and enhance button and approval workflows, adding conditional logic and branching to optimize processes.
• Set up recurring workflows and advanced control structures to automate repetitive or complex tasks.
• Integrate Power Automate with Power BI and Power Apps for dynamic, cross-platform automation.
• Securely connect to on-premises data and troubleshoot connectivity issues.
• Design adaptive cards and modular workflows to streamline communication and enhance scalability.
• Apply advanced expressions and error-handling strategies to build robust workflows.
• Develop reusable, scalable automation solutions to support business needs.

Power Apps Introduction





Unlock the ability to create custom business applications without writing a single line of code. This Power Apps Introduction course teaches you how to design and develop custom canvas apps that automate tasks, streamline workflows, and improve productivity. By the end of this comprehensive 2-day introduction, delegates will know how to:

• Set up and navigate the Power Apps development environment, including Power Apps Studio and the mobile app.
• Create and customize basic canvas apps, incorporating essential controls and design elements.
• Connect Power Apps to data sources like SharePoint, Excel, and OneDrive to build dynamic, data-driven applications.
• Understand and utilize core controls, such as dropdowns, sliders, and toggles, while managing user input validation and error handling.
• Apply basic Power Apps formulas like Text(), Concatenate(), and Navigate() to create interactive and responsive app functionality.
• Manage app screens effectively, including adding dynamic elements, showing or hiding controls based on user input, and building interactive buttons and menus.
• Work with exotic controls, such as media elements like cameras, microphones, and videos, and format data tables for advanced filtering.
• Gain confidence in integrating Power Automate to call APIs and external services, expanding app functionality.
• Build apps with dynamic layouts that adapt seamlessly across devices (desktop, mobile, and tablet) using dynamic properties.




Who Should Attend:

Our courses are ideal for data analysts, business intelligence professionals, decision-makers, and IT managers looking to expand their expertise in data visualization, automation, and AI. These programs benefit:

• Data analysts aiming to enhance skills in Power BI for creating interactive dashboards and actionable insights (Power BI training)
• Business intelligence professionals interested in advanced DAX calculations and data modelling for complex analytics (Power BI DAX Intensive Training)
• IT managers seeking to leverage the Power Platform for efficient data integration and process automation across teams
• Professionals exploring AI tools like Microsoft Copilot, ChatGPT, and Midjourney to streamline workflows and improve predictive analytics
• Decision-makers and team leaders who need to adopt AI-driven tools for automation and actionable insights in their organizations
• Attendees will gain practical skills to boost productivity, make data-driven decisions, and integrate AI and automation into everyday tasks.
  




Further Information:

https://gcomsolutions.co.uk/microsoft-power-bi-training-courses/