Virtual Advanced Power BI Bootcamp
- Start: Nov 18, 2024 9:00 AM EST
- End: Nov 22, 2024 5:00 PM EST
- Cost: $2,995.00
- Instructor: Allison Gonzalez
- Event Categories:
- Available Seats: Limited seats remaining!
- Missed your change to sign up, but still want to get in on the fun? Contact us!
- Need help convincing your boss? We can help.
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.
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 – Allison Gonzalez
Allison graduated from Flagler College in 2011. She has worked in management and training for tech companies for the past decade. As a Microsoft Certified Trainer, her primary focus is helping our customers learn the ins and outs of Power BI, along with Excel and Teams.