COURSE: Building Analytical Dashboards with Power BI

Power BI is an innovative solution helping businesses make better decisions

Make better solutions for your enterprise, integrating different resources to become one unique report. Your whole team will appreciate real and reliable numbers

UPCOMING DATES

June 27 – Vienna Enroll here
ONLINE July 9th-18th  Enroll here
 July 31 – Atlanta Enroll here
 August 14 – Miami Enroll here
 August 28 – NYC Enroll here
 September 11 – Philadelphia Enroll here
 October 2 – Tampa Enroll here
Oct 15 – Vienna Enroll here
 October 16 – Chicago Enroll here
 November 27 – Dallas Enroll here
 December 10 – Los Angeles Enroll here

The Power BI platform allows organizations to obtain data from many sources, integrate and convert information to be shared through excellent visualization and collaboration tools.

Take action on data insights!

COURSE DELIVERY OPTIONS

3-DAYS CLASSROOM

The course will take place in a classroom with no more than 20 students in order to maintain a good level of interactivity.

INSTRUCTOR-LED ONLINE

The training will be an instructor-led 100% online course, where you will be able to talk to the mentor and solve your problems in real time It wil lbe run in six 3-hour long sessions.

PRIVATE ONSITE

The course will take place in your companie’s facilities. We limit attendance to no more than 20 students in order to maintain a good level of interactivity.

Course Benefits

Does our organization need insights to make decisions at every level, in real time?
✔ With Power BI you can gather and analyze data from hundreds of data sources: on-premises data sources, big data, streaming data, cloud services…

Are you already using Power BI but you need to get the most out of it?
✔ In this course you will learn how to create and share powerful data visualizations with your team, using practical examples that you can implement from day 1.

Are you leveraging implementing Power BI in your organization?
✔ Microsoft Power BI is the best data visualization tool out there, and we will show you all the necessary ingredients for a successful implementation.

Expert Mentors

Our instructors have faced in previous real case projects, the same problems you are facing now. Learn from experience professionals.

t

Interaction and Q&A

In all of our trainings, you will have the chance to ask individual questions and be capable of solving certain issues.

Course Coverage

By the end of this course, you will have practiced how to Get Data from various sources, Model your data, Visualize your data, and Share your data with Power BI Desktop and the Power BI Service.

The training objective of the course is to provide students with the necessary knowledge for data integration and advanced analysis using Power BI.  Practical use cases are incorporated into the sessions allowing application into real-world situations.

Audience

This course is intended for experienced business and data analysts with prior experience data visualization tools like Tableau, QlikView and Excel with PowerPivot & Power View and desire to apply similar approaches to Power BI.    Exposure to Power BI Desktop and Power BI Service (powerbi.com) is recommended and prior work in Power BI is strongly encouraged.

Import data from heterogeneous sources.

 

Design, refine and optimize data models

 

Create analytical calculations using Data Analysis eXpressions (DAX)

 

Create interactive reports and dashboards

 

Share insights within the organization using content packs and app workspaces

 

Leverage content on various mobile platforms

 

Excellent teacher, he exceeded my expectations, his greatest strength is the ability to provide examples of the real world

Very knowledgeable and good energy. Kept the class moving and engaged

In many cases, the numerous companies I’ve spoken with let me know that they contacted me because of this Master Class and the course faculty

COURSE OUTLINE

MODULE 1. Introduction to the Power BI ecosystem

  • Power BI Service at PowerBI.com
  • Power BI DesktopPower BI Mobile
  • Power BI Embedded
  • Power BI Report Server

MODULE 2. Introduction to Power BI Desktop

  • Key features and navigation
  • Core activities with Get Data, Model and Visualize

MODULE 3. Modeling: Introduction-Fundamentals of Data Modeling

  • Data types
  • Model design
  • Modeling time
  • Practical cases

MODULE 4. Get Data: Gathering and Cleansing

  • Query Editor
  • Data Sources
  • Querying data
  • Other features
  • Practical cases

MODULE 5. Modeling: Improving the Data Model

  • Data model key components

MODULE 6. Modeling: Data Analysis eXpressions (DAX) and Quick Measures

  • What is DAX and why we need it
  • Calculated columns and measures
  • DAX functions introduction
  • Practical cases

MODULE 7. Visualize: Introduction to Visuals and Chart Interaction

  • Introduction to Power BI Reports
  • Visual elements
  • Creating reports
  • Practical cases

MODULE 8. Visualize: Conditional Formatting Options

  • Conditional formatting with the default visuals
  • Custom visuals tailor-made for conditional formatting

HANDS ON LABS

Lab 1: Obtaining and Refining Data
Lab 2: Refinements and Improvements on the Data Model
Lab 3: Incorporating Basic DAX Expressions
Lab 4: Create a Simple Report

MODULE 9. Share: Publishing to the Power BI Service

  • Publishing Reports
  • Building Dashboards
  • Sharing Dashboards

MODULE 10. Share: Creating and Managing Workspaces

  • Personal workspace
  • Group workspace

MODULE 11. Modeling: Connecting On-Premises Data to the Power BI Service

  • Power BI Gateway overvie
  • Gateway setup and configuration

MODULE 12. Get Data: Advanced Data Cleansing Features

  • Advanced Transformations
  • Using Parameters
  • M Language IntroductionI
  • ncorporating R datasets

MODULE 13. Modeling: Intermediate DAX Calculations

  • Overview of different types of functions
  • Aggregation and relationship functions
  • Implementing calculations, measures, and KPIs
  • Practical cases

MODULE 14. Get Data: Working with Data for Power BI Report Server

  • Extending on-premise capabilities
  • User Experiences
  • Moving assets to SSAS
  • Data Connectivity

MODULE 15. Share: Deploying Reports to Power BI Report Server

  • Deploying reports to Power BI Report Server
  • Editing and content linking
  • Security and Sharing
  • Developer resources

HANDS ON LABS
Lab 5: Building Better Visualizations

Lab 6: New Ways to Modify Reports
Lab 7: Intermediate DAX Calculations
Lab 8: Working with Power BI Report Server

 

MODULE 16. Visualize: Custom Visuals and Custom Data Sources
The default visuals that come with Power BI Desktop are very useful, but there are many custom visuals available to help fit specific situations.

MODULE 17. Visualize: Advanced Visualization Techniques

  • New analytical features

MODULE 18. Visualize: Advanced Visuals with R

  • Bringing Data Science into your Power BI reports

MODULE 19. Visualize: Designing for Mobility

  • Design considerations
  • Features & options

MODULE 20. Share: Power BI Service Administration

  • The need to share
  • The Power BI Service
  • Practical cases

HANDS ON LABS

Lab 9: Custom Visualizations
Lab 10: Power BI Service and Power BI Report Server better together

Meet our Instructors

 Paco González

Paco, a Microsoft Data Platform MVP and SolidQ North America Managing Director, is the PASS Big Data Virtual Chapter Leader, SQL Saturday Barcelona Organizer and assistant at the PASS Atlanta BI User Group. He is finishing his PhD thesis about: “Analyzing Social Data with Machine Learning.” He is an MCT and MCP on BizTalk Server and SQL Server. He is coauthor of Microsoft Training Kit 441.

Paco is a frequent speaker at large and small conferences. SQL Saturdays, TechEds, PASS BA, PASS Summit,  DevWeek London, and PAW Chicago and London.

 Pau Sempere

Pau is a Mentor at the Business Intelligence Area, participating in SQL Server, BI, Big Data and Data Science projects. He is a computer engineer graduated at The University of Alicante, being awarded as Microsoft Active Professional in 2012.

He is experienced in areas such as manufacturing, insurance, social media, health and e-commerce. In these he has been part of many projects including data integration, data modeling, data analysis and visualization, mainly based on the Microsoft Data Platform.

As speaker, he has participated in Microsoft Technet webcasts and events, and at the last 5 editions of The SolidQ Summit. In addition, he often works as a trainer in different sessions and training courses around the Microsoft data technologies.

 Walter Putz

Walter Putz, MCSA, MCSE Database Engine and MCT, is an SQL Server Architect with SolidQ. As Consultant and Trainer for T-SQL Programming, Administration and DWH/BI he works in the whole DACH region; amongst others for ONE, A1, Daimler or Raiffeisen. He delivers SQL Server trainings in Berlin, Munich, Frankfurt, Dresden, Leipzig i.e. for Stadtwerke München, Ferrero, Carl Zeiss, Casinos Austria, Magna et. al.

Víctor M. García Sánchez

BI architect and consultant focused in Microsoft technologies with a strong background in several areas such as banking, transportation and public administration. Among his skills can count system integration and data consolidation, data quality, data analysis, dashboards and scorecards development, corporate reporting. Always with the target of provide innovative solutions to customers.

Besides, trying to share knowledge to community through SolidQ and personal blog, collaborating with TechNet performing webcast and speaking in events.

 Dan Evans

Dan Evans is the North America Business Analytics Practice Director for SolidQ with over 25 years’ experience in applying innovative solutions to business needs. His key focus areas are Advanced Analytics, Business Intelligence, Enterprise Performance Management and Data Strategy on the Microsoft Data Platform. Dan works heavily in promoting technology across North America through involvement through user forums (.NET, PASS, Ignite) and industry-recognized organizations (TDWI, DAMA).

Specialties include business technology solutions, management consulting, business analytics, Big Data, Internet of Things, project management, technical strategic planning and new business development.

What can you achieve with Power BI?

This is an example of a real project implemented by SolidQ

Project goals

The Accounting and IT departments decided to go for a comprehensive BI solution based on Microsoft technology in order to carry out different analysis that helps them in decision making, both in the mother company and in the subsidiaries.

Outcome

✔ The new platform helped the consolidation and centralization of the company’s information in a corporate Data Warehouse.
✔ The Accounting Department now has an Excel-based solution that extracts information from the cube to perform analysis and in order to improve reports intended for the Board of Directors.
✔ Budget loading process, which was a manual  and difficult task to integrate, is now automated, and the information is built into the Data Warehouse.
✔ Every subsidiary Director has now access to analytical reports in Power BI for decision making.

Would you like to register for this course?

Fill out the form at the top of this page