Visualizing data with Power BI: Digital Story Telling
Power BI is a Microsoft business analytics tool that lets business users visualize their data and share insights across your organization. In this course, business users can learn the basic concepts of dimensional modeling, the main design techniques to create wonderful reports which can be applied in Power BI Desktop, Power BI Mobile or Power BI Report Builder.
Furthermore, the student will learn about the basic concepts of financial modeling applied in real situations.
Upcoming Dates
Course Delivery Options
In-class Sessions – 2-Day Course
The training will be in a classroom with no more than 15 students in order to maintain a good level of interaction.
Pre-requisites
Before attending this course, it is recommended that students have the following skills:
- Desire to learn about Power BI.
- Want to work analysing data.
After this Course
Upon completion of this course, the student will be able to:
- Understand the key capabilities and characteristics of modelling in Power BI
- See the different elements that can be created with Power BI
- Optimize Power BI models by using correct relationships and data types
- Design its own dashboards using the most common design tips
- Tell a dynamic story in Power BI
- Build reports for mobile devices
- Build report with Power BI Report Builder
- Learn the basic concepts of financial modelling
Instructors
Victor 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.
Pau Sempere Sánchez
Pau is a Mentor at SolidQ. He obtained his Computer Engineering (Master in Computer Science) degree at University of Alicante in 2011. Nowadays he is involved business analytics and advanced analytics projects, including technologies as SQL Server, SSIS, SSAS, Azure ML, ML Server, Power BI or SSRS. Pau has participated as speaker at diverse Microsoft TechNet webcasts events, such as “The 12 Hours of SQL Server” (sponsored by Microsoft Spain and PASS Spain). He speaks regularly at the SolidQ Summit Madrid and is member of SQL PASS Spain, having spoken at diverse SQL Saturday events.
He collaborates actively at “The Business Analytics Blog” blog along with his SolidQ colleagues and got the Microsoft Active Professional award (MAP) in 2012.
He is experienced at textile, online gaming, retail, health system, communications, insurance, broadcasting services and social media.
Patrick Dubois
Patrick is an experienced Data Specialist who has been guiding clients since 2001 in better understanding and working with their data. His project experiences have revolved around moving and integrating data into new environments, system/process redesigns, data and business rule validation, as well as full implementation of business intelligence solutions at both large and small clients. To that end, Patrick has worked with a variety of tools, but he specializes within the Microsoft BI Suite of Products (SQL Server, SSIS, SSAS, SSRS, Power BI).
Rushabh Mehta
Rushabh leads software development, application development, product management, and customer enablement. With an entrepreneurial spirit and passion for finding new ways to solve complex business challenges, he has deep empathy for customers and end users which guides his advocacy and influence over product direction. Rushabh strives to create an environment of high energy and creativity. He has been providing Business Intelligence, SQL Server and Information Services architecture solutions, training and mentoring services to enterprise customers since 1998.
Julio Granados
Julio works as Data Platform Engineer at SolidQ in the Business Intelligence area. He completed his Computer Engineering degree at University of Alicante in 2014 specializing in information systems and a Master in business intelligence on Microsoft technologies at SolidQ in 2016. He is currently involved in data integration projects, ETL processes, consolidation Data maintenance, datamart maintenance, report construction and dashboards.
He has experience in the textile, banking, food and collections industries.
Daniel Gil
Daniel is an engineer at SolidQ. He completed his studies of degree in Telecommunications, Sound and Image in the University of Alicante in 2008 awarded with the Extraordinary Graduation Award in his year. From 2009-2010, he worked as a Computer technician in San Vicente’s Town Council and collaborated with the team for seismic research of the University of Alicante, creating a software in Matlab. In 2014, he completed his studies in Computer Science in the Universidad de Alicante. He started at SolidQ through a University internship, developing the platform for SolidQ Analytics and continued in the company with a grant during his last year at University. After completing his degree, he started working for SolidQ in the BI sector.
Currently he is undertaking the Master in Microsoft business intelligence technologies. He also has been formed in an intern framework which make faster and reliable the ETL processes.
Module 0. Introduction and Setup.
- Introduction
- Course overview
- Course materials and Setup.
Module 1. Introduction to Power BI Desktop.
- How did we use to do BI?
- The evolution of BI
- How do we do BI?
- Why Power BI?
Module 2. Basic Dimensional Modeling.
- General concepts
- Dimensional modeling
- Elements of dimensional modeling
- Why modeling is important?
- Modeling in Power BI
Module 3. Visualizations
- Report view
- Visuals
- Chart suggestions
- Fields, format and analytics
Module 4. Interactions and Themes
- Interactions
- Themes
Module 5. Storytelling.
- What is Storytelling?
- Why Storytelling?
- How can we achieve Data Storytelling?
- Different Storytelling scenarios.
Module 6. Dashboard Design Tips.
- Report vs Dashboard
- Understand your audience
- Design your narrative
- The “5th Second Rule”
- Logical layout “The Inverted Pyramid” and the “F Pattern”
- Minimalism: less is more
- S.C.R.A.P. Methodology
- Color theory
Module 7. Behind the Power BI Scenes
- Actionable elements
- Bookmarks
- Tooltips
- Drillthrough
- Show data and see records
- Questions & Answers
- What If parameters
- Insights
Module 8. Power BI Mobile
- Mobile support
- Mobile features
- Power BI mobile view
- Design considerations
- Report view in your mobile device
Module 9. Power BI Report Builder
- What is Report Builder?
- Report view
- Connecting to a data source
- Building the datasets
- Visuals
- Building a report
- Previsualize the report
Module 10. Real practical cases. Financial models
- Definitions and concepts
- Data sources
- Power BI modeling
- Design of metrics and financial reports
Do you want more info about these courses?