Course Type
Learn online in your own time, and at your own pace via our eLearning platform.
Duration
12 hours worth of video learning broken down into bite-sized lessons.
Certification
Certificate of Completion & Virtual eLearning Badge
Course Type
Led by a live instructor, learn virtually (via Microsoft Teams) alongside a small group of other students.
Please Note
This Course Type is not currently offered in this region. Please register your interest for this Type of course.
If you’re looking for something more bespoke; if you need to educate a group of people; or if you’d like to schedule in some face-to-face, on-site training, please do contact us.
Microsoft eLearning Subscription
£12.75 GBP* per month
What's included:
- Licence for 1 user
- Access to this course
- Access to all other Microsoft eLearning courses
- No lock-in contracts
- Cancel your subscription at any time – see Terms & Conditions for details.
- Please note that once payment has been made you will receive an email to access the platform on the next working day.
*excludes VAT
Course Overview
This course consists of four main parts with multiple lessons in each.
Extract, Transform and Load Data
- Creating a project with Power BI desktop
- Connecting to data sources
- Managing data connections
- Refine data with the query editor
- Choose columns
- Rename columns
- Format column values
- Reorder columns
- Replace column values
- Expanding related columns
- Merge columns
- Split columns
- Creating custom and conditional columns
Creating a Data Model
- Understanding relationships
- Formatting columns
- Introducing DAX
- Creating calculated columns
- Creating measures
- Structuring data with dimensional hierarchies
- Roles and row-level security
Designing Reports
- Adding pages and navigation
- Using shapes, images and text
- Adding visualisations
- Using filters and slicers
- Drill-throughs
- Adding custom visualisations
- Themes
Using Workspaces and Dashboards
- My workspace vs app workspaces
- Premium capacity workspaces
- Publishing a report
- Reconnecting with data sources
- Scheduling data refreshment
- Assigning security roles
- Creating and populating dashboards
- Customising dashboard tiles
- Creating tiles using Q&A
- Sharing reports and dashboards
- Publishing apps in a workspace
- Publishing content to websites
Benefits
Learning how to use Microsoft Power BI offers a multitude of benefits for individuals and organizations alike:
- Data Visualization Mastery: Power BI enables users to create visually stunning and interactive reports and dashboards, allowing them to present complex data in a clear and intuitive manner. Learning Power BI equips individuals with the skills to effectively communicate insights to stakeholders, driving better decision-making.
- Improved Data Analysis: With Power BI, users can easily connect to a wide range of data sources, transform raw data into meaningful information, and perform advanced analytics with built-in AI capabilities. This empowers individuals to extract actionable insights from large and disparate datasets, leading to better understanding and optimization of business processes.
- Increased Productivity: Power BI streamlines the process of data preparation, analysis, and visualization, enabling users to work more efficiently. By automating repetitive tasks and providing intuitive tools for data exploration, Power BI helps individuals save time and focus on deriving insights that matter.
- Seamless Integration: As part of the Microsoft ecosystem, Power BI seamlessly integrates with other Microsoft products such as Excel, SharePoint, and Azure, as well as with third-party applications and services. This interoperability allows users to leverage existing tools and investments, enhancing collaboration and maximizing productivity.
- Democratization of Data: Power BI empowers individuals across an organization to access and analyze data independently, without relying on IT or data experts. By democratizing data access and fostering a data-driven culture, Power BI enables organizations to harness the collective intelligence of their workforce and drive innovation.
- Cost-effectiveness: Compared to traditional BI solutions, Power BI offers a cost-effective and scalable platform for data analysis and visualization. With flexible licensing options and cloud-based deployment, organizations can minimize upfront investment and scale resources according to their needs, making Power BI accessible to businesses of all sizes.
- Competitive Advantage: In today's competitive landscape, the ability to leverage data effectively is a key differentiator for businesses. By investing in Power BI training, individuals can gain a competitive edge in their careers by acquiring in-demand skills that are highly valued by employers across industries
Overall, learning how to use Microsoft Power BI opens up a world of opportunities for individuals and organizations, enabling them to unlock the full potential of their data and drive success in an increasingly data-driven world.
Who should attend?
No matter your level of experience or job role, anyone can attend this course.
Payment Options
This course can be purchased via our Microsoft eLearning subscription.
Need training for a group of people?
If you’re looking to train a small group, a whole team, or an entire company of employees, please get in touch as we’re able to offer discounts on multiples.
