Skill Up Card - Course Bundles

Save up to £4,000 per delegate.

skill up card image - Nexus Human

Quick Start to Power BI for Anlaysts & Users / Introduction to Power BI (TTDPB01)

4.6 out of 5 rating

Jump to dates

Duration

2 Days

12 CPD hours

About this course

This hands-on course is geared new users and analysts or individuals who might be responsible for accessing the organization's data, transforming that data and generating reports.

Overview

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, students will learn how to: -Perform Power BI desktop data transformation. -Describe Power BI desktop modelling. -Create a Power BI desktop visualization. -Implement the Power BI service. -Describe how to connect to Excel data. -Shape and Combine Data -Describe how to collaborate with Power BI data. -Connect directly to data stores. -Time Permitting: Explore the Power BI developer API. -Time Permitting: Describe the Power BI mobile app

Description

QuickStart to Power BI for Analysts and Users is a two-day introductory-level course that provides attendees with a hands-on exploration of the essential features and benefits of Power BI, as well as a targeted hands-on jump start to performing data analysis with Power BI. This course will provide you with the job-ready skills required to make you productive in your role with basic Power BI features and functionality, right after the training ends.

Prerequisites

Before attending this course, students should have: -A general knowledge of database concepts (fields, records, relationships). -An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable. -Familiarity with Excel.

Module 1: Introduction to Self-Service BI Solutions Introduces business intelligence (BI) and how to self-serve with BI. Topics Introduction to business intelligence Introduction to data analysis Introduction to data visualization Overview of self-service BI Considerations for self-service BI Microsoft tools for self-service BI Hands-on: Exploring an Enterprise BI solution Viewing reports Creating a Power BI report Creating a Power BI dashboard Module 2: Introducing Power BI This module introduces Power BI desktop, and explores the features that enable the rapid creation and publication of sophisticated data visualizations. Topics Power BI The Power BI service Hands-on: Creating a Power BI dashboard Connecting to Power BI data Create a Power BI dashboard Module 3: Power BI Essentials At the end of this module students will be able to explain the rationale and advantages of using Power BI. Topics Using Excel as a data source for Power BI The Power BI data model Using databases as a data source for Power BI The Power BI service Hands-on: Importing data into Power BI Importing Excel files into Power BI Viewing reports from Excel files Module 4: Shaping and Combining Data With Power BI desktop you can shape and combine data with powerful, built-in tools. This module introduces the tools that are available for preparing your data and transforming it into a form ready for reporting. Topics Power BI desktop queries Shaping data Combining data Hands-on: Shaping and combining data Shape power BI data Combine Power BI data Module 5: Modelling data This module describes how to shape and enhance data. Topics Relationships DAX queries Calculations and measures What is DAX (Overview) What is DAX (Tabular) Creating Calculated Columns (Basics) Conditional and Logical Functions Creating Calculated Measures Time Intelligence (Overview) Time Intelligence (Time Intelligence Functions) Using X-Functions and A-Functions DAX as a Query Language Hands-on: Let's Model Data Module 6: Interactive Data Visualizations This module describes how to create and manage interactive data visualizations. Topics Creating Power BI Reports Page Layout and Formatting Working with Multiple Visualizations Creating Charts Histograms Managing a Power BI Solution Power BI Service Settings Power BI Desktop Settings Module 7: Direct Connectivity Cloud Data Connecting to Big Data Connecting to Analysis Services Direct Connectivity to Analysis Services Using the On-Premises Gateway SSAS Multidimensional Models Bonus Topics / Time Permitting This content will be included with your course materials, and will be addressed in class if time permits. Module 8: The Developer API The Developer API The Interactive API Console Custom Visuals Using Custom Visuals Using the Developer API Module 9: PowerBI Mobile Power BI Mobile Apps Creating Dashboards for Mobile Devices Power BI for iOS and Android Power BI for Windows 10 Using the Power BI Mobile App Annotating Dashboards Power BI Embedded Adding Visualizations to an App Power BI Community
Additional course details:

Nexus Humans Quick Start to Power BI for Anlaysts & Users / Introduction to Power BI (TTDPB01) 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 ITS Data Analytics 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.

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable. To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.

What people say about us


Global Schedule

GTR = Guarenteed to Run

03 Jun 24 Enquire Book
15:00 - 23:00Live Online1
09 Dec 24 Enquire Book
15:00 - 23:00Live Online1

12 Aug 24 Enquire Book
15:00 - 23:00Live Online1
15 Apr 24 Enquire Book
15:00 - 23:00Live Online1
23 Sep 24 Enquire Book
15:00 - 23:00Live Online1
28 Oct 24 Enquire Book
14:00 - 22:00Live Online1

Find out more about this course

Interested in alternative dates? Would like to book a private session of this course for your company? Or for any other queries please simply fill out the form below.