Virtual Advanced Power BI Bootcamp
- Start: Sep 16, 2024 9:00 AM EDT
- End: Sep 20, 2024 5:00 PM EDT
- Cost: $2,995.00
- Instructor: Greg Trzeciak
- Event Categories:
- Avaliable Seats: Limited seats remaining!
- Missed your change to sign up, but still want to get in on the fun? Contact us!
Event description
Welcome to our Advanced Power BI 5-Day Intensive, tailored for data experts and analytics aficionados. In this immersive bootcamp, we dive deep into the heart of Power BI, focusing on advanced techniques designed to elevate your data analysis and visualization skills. From intricate data transformations and applying complex business logic, to crafting sophisticated data models with intricate relationships and calculations, this course is a deep dive into the art and science of Business Intelligence. Explore a spectrum of visualization tools, from intricate charts and graphs to spatial mapping and dynamic gauges, ensuring you can present even the most intricate datasets with finesse. Delve into the nuances of Power BI Service, understanding how to deploy intricate solutions effectively, and make your dashboards accessible across devices. This bootcamp isn't just about understanding Power BI; it's about mastering it. Join us for a transformative experience where you will refine your expertise, learn advanced strategies, and unlock the full potential of Power BI in the hands of experts. This bootcamp is also available to purchase by each individual day. You can find those listed on our our bootcamps page of our website.
Prerequisites
This class is targeted for advanced power users or end-users looking to enhance their skills in Power BI and empower better informed Business Intelligence solutions. Because this class is focused on self-service end-user solutions, previous SQL Server knowledge is not required. While it’s not mandatory, ideally students should have an intermediate understanding of database terminology such as tables, views, columns, rows, etc.
System Requirements
- Windows 10, Windows 7, Windows 8
- Microsoft Power BI Desktop requires Internet Explorer 10 or greater
- Microsoft Power BI Desktop is available for 32-bit (x86) and 64-bit (x64) platforms
- Power BI Desktop [https://aka.ms/pbiSingleInstaller](https://aka.ms/pbiSingleInstaller)
- Ability to download Python
Course Outline:
- Day One- Advanced Data Modeling
- Conceptual Modeling
- Fact and Dimensional Modeling on Raw-Form Data
- Navigating Direct-Query
- Building the Aggregate Table
- Understanding Relationships
- Day Two – Advanced Data Shaping
- Advanced Column Transformations
- Get Data with Python
- Advanced M Transformations
- Query Folding
- Data Profiling Tools and Techniques
- Error Handling
- Day Three – DAX Measures
- Building Aggregate Tables
- Optimizing DAX Performance
- Rolling Totals and Time Intelligence Functions
- Understanding CALCULATE
- Day Four – Advanced Data Visualizations
- Advanced Data Storytelling and Accessibility Tips
- Conditional Formatting
- Spatial Mapping
- Custom Visuals
- Anomaly Detection and Forecasting
- Using Python to build Power BI Visualizations
- Day Five – Power BI Administration
- Understanding the Power BI Administrator Role
- Establishing a Power BI Environment
- Usage Monitoring and Auditing
- Broadening the reach of Power BI
Add an event to your calendar
Instructor – Greg Trzeciak
Gregory Trzeciak has his master’s degree in Education from the University of Florida. He has 9 years of teaching experience in high school, college level, and summer programs where he was recognized as a top educator and leader in interactive education. As a trainer at Pragmatic Works, his primary goal is to help individuals gain confidence in using Power BI and the Power Platform. While not in the office, he enjoys fantasy football, walking his dog, and running half-marathons!