Microsoft Power BI 2 Days Training in Dumfries

Certificate: Course Completion Certificate

Language: English

Duration: 2 Days

Credits: 16

Course Delivery: Classroom/ Virtual Live / Onsite

Offers: Groups of 5 - 10 people 10% Discount | Groups of 11 - 20 people 15% Discount

Course Overview:

Power BI is the newest Analytics & Business Intelligence tool developed by Microsoft. Power BI is one of the most robust business Intelligence platforms available for data modeling.

In this module we will learn the basics of this Power BI, and all the five components of the tool (Visualizations, Dashboards, Reports, Apps and Datasets).

There will be demos and introduction about Power BI desktop, Power BI website, Mobile Apps and Office 365 Power BI Subscription. You will also learn the easy methods of using Power BI in some scenarios.

Learning Objectives:

• Understand primary features of a self-service Power BI solution
• Utilize Power BI and its data sources
• Combine, analyze, model, shape, and visualize data
• Report data using rich dashboards

Agenda:

Module 1: Introduction to Power BI

Power BI is the analytics tool. This provides interactive visualizations and business intelligence capabilities with simple interface for users to create their own reports and dashboards. It is the data visualization and business intelligence tool that converts data from different sources to interactive dashboards.

Module 2: Getting Data

The first experience of working with Power BI is getting data. For some data sources you can have a live or direct connection and some connections work offline. Power BI takes information from data sources and turns them into custom visuals designed to help an organization not only read the info but get a clear idea of what to do. Here you can connect too many data sources on-premises or on cloud. In this module you will learn everything about getting data experience in Power BI.

Module 3: Power Query for Data Transformation

Power BI (including Power Query & Power Pivot) is the biggest Excel news item in the last 10 years. Power Query is the data transformation and data preparation engine of Power BI. Power Query is also part of Power BI Desktop. With Power Query you can import or connect external data. In this module you will learn about all different versions of Power Query, their similarities, and differences, as well as configuration and requirements of using them.

Module 4: Power Pivot for Data Modeling

Power Pivot is an in-memory data modeling component that enables highly-compressed data storage and extremely fast aggregation and calculation in Power BI. Modeling effectively is the key to a high performance BI solution. Here you will learn the basics of Power Pivot such as creating relationships, and calculated members, as well as advanced best practices and DAX expressions. You will learn the basics of data modeling using DAX and creating live dashboards for reporting in real world challenges.

Module 5: Data Visualization with Power View, Power BI Desktop and Power Map

Power BI is the data visualization tool. Data Visualization is the front end of any BI application; this is the user view point of your system. This tool allows you to embed your custom visualization into your website or app. In this module you will learn conceptual best practices of data visualizations which are valid through all data visualization tools. You will possess Power View and Power Map skills. Power View is the interactive data visualization technology that lets you to create interactive charts, graphs and maps. Power Map is a 3D geo-spatial data visualization tool. You will learn how to create effective dashboards and charts using these tools as well as best practices for working. Also two versions of Power View; Power View for Excel, and Power View for SharePoint which will be covered in this module as well.

Module 6: Designing the best solution with Power Q&A

How Power Q&A works? Power BI Q&A searches through all the reports, datasets, and visualizations on a selected workspace to come up with the best results. Thus, as you formulate your question, the answer will change as more and more details are typed. Power Q&A is a question and answering engine which works based on human natural language. Power Q&A automatically will be enabled on Power BI files deployed into Power BI website, or Office 365 subscription. There are some tips and tricks you need to know about how to design your model to get the best answers through Power Q&A and in this module you will learn best practices for modeling that effect on the response of Power Q&A.

Module 7: Power BI Desktop; combination of three tools

Power BI Desktop combines interactive visualizations. This is the new tool that enhances the combination of Power Query, Power Pivot, and Power View components. Power BI Desktop has great features that will be fully explored in this module. You will learn the differences between the original version and Power BI Desktop. You will also learn how to use Power BI desktop to mash up data, model it, and visualize it. Best practices of design will be all discussed with demos.

Module 8: Administration

Power BI components can be deployed into different environments such as Power BI website, Office 365 subscription. In module – 8, we will go through configurations, deployment options and requirements required for each environment. You will know how to deploy your Power BI files into the Power BI website. These three elements - Power BI Desktop, the service, and the mobile apps are designed to let you create, share, and consume business insights in the way that serves you and your role most effectively. You will gain the skills to work with these three elements.

Target Audience:

This Microsoft Power BI Course is for all the professionals who want to understand how to use the tools and create customized reports. Who are passionate about Business Intelligence are also welcomed. Some of Job roles include:

• Product Managers
• Data Engineers
• Business Analysts
• Data Analysts
• Business Intelligence Manager
• Data Scientists
• Project Managers
• Program Managers
• Professionals Working with Data

Examination:

No Exam

Technical Requirements:

For eBooks:

Internet for downloading the eBook

Laptop, tablet, Smartphone, eReader (No Kindle)

Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)

eBook download and activation instructions

Prerequisites:

There are no prerequisites for this course.

Course Materials:

Students will receive a course manual with presentation slides and reference materials.

Public Speaking Training: According to a 1973 survey by the Sunday Times of London, 41% of people list public speaking as their biggest fear. Forget small spaces, darkness, and spiders, standing up in front of a crowd and talking is far more terrifying for most people. Through this workshop your participants will become more confident and relaxed in front of an audience which will translate into a successful speaking event.

Leading Effective Teams Training: This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.

Train the Trainer Training: Whether you are preparing to be a professional trainer, or you are someone who does a bit of training as a part of their job, you always want to be prepared. Your participants will understand that training is a process where skills, knowledge, and attitudes are applied in a unique way.

Presentation Skills Training: In a survey carried out amongst experienced, middle and senior executives, designed to determine the things that they feared most, public speaking came out as number one. Death was eighth on the list! So, most of us would rather die than stand up and present!

Practical Sales Skills Training: These practical sales skills training has been developed for salespeople or people who are required to sell as part of their role. This course is applicable for both people relatively new to sales as well as those who have a lot of experience as the content is flexible enough to adapt to suit the audience.

Conflict Management Training: Disagreements, differences of opinion and conflicting perspectives on key issues inevitably arise in any context where people are working together.

Research has shown that workplace conflicts can become highly destructive. Negative emotions may be stirred up, poisoning team morale, creating stress and destroying relationships.

Power Query and Power Pivot for Excel Training: Power BI (including Power Query & Power Pivot) are the biggest Excel news items in the last 10 years. They give Excel users the power to draw information out of multiple sources, link it together then perform calculations on it that can then be sliced & diced any way you want.

Essential Management Skills Training: Every day, managers solve difficult problems, turn organisations around, and achieve astonishing performance. To be successful, every organisation needs good managers.

Manager Management Training: With this course, you will be able to provide the skills, guidance, and empowerment to your team of managers. They will then be better suited in leading and motivating their team and thus produce fantastic results. To be a successful manager means having a wide range of skills. Through this workshop, you will be able to disperse your knowledge and experience throughout your leadership team.

Sales Presentation Mastery Training: Sales are the absolute most essential component of any business, and selling skills are the most highly valued skills in today’s business landscape. The world's fastest growing and most successful businesses have one thing in common: they have effective sales people that drive their business forward.

Time Management Virtual Live Training: Personal time management skills are essential for professional success in any workplace. Those able to successfully implement time management strategies are able to control their workload rather than spend each day in a frenzy of activity reacting to crisis after crisis - stress declines and personal productivity soars! These highly effective individuals are able to focus on the tasks with the greatest impact to them and their organization.

Internet Marketing Fundamentals Virtual Live Training: Marketing has changed dramatically over the last decade. Marketing is all about communicating, and the Internet has completely changed the way people communicate. The Internet is a marketer's dream come true, especially with social media, as you have a low-cost marketing tool that can reach a large audience.