Advanced Pivot Tables for Deeper Analysis
SEPTEMBER 19, 2024
12:00 pm to 1:00 pm ET
Length
1 hour
Venue
Online
Cost
FREE
Christine Irons
- Change Pivot Table Layout
- Group Pivot Table Information
- Create Calculated Fields and Items
- Understand Pivot Table Sets
- Generate Multiple Reports with One Click
- Adjust Field List Settings
- Drill Down for Details
Ready to elevate your data analysis skills to the next level? This webinar will take your Pivot Table mastery to new heights by unlocking the full potential of Excel’s powerful toolset. Perfect for Excel enthusiasts and data analysts seeking to deepen their understanding, this one-hour webinar dives into the more complex side of Pivot Table functionalities. Uncover advanced techniques for data manipulation, visualization, and analysis, empowering you to extract deeper insights and optimize your decision-making process. Gain invaluable knowledge, streamline your workflow, and become a Pivot Table virtuoso!
Decoding Copilot: Your Job’s Secret Weapon
OCTOBER 16, 2024
12:00 pm to 1:00 pm ET
Length
1 hour
Venue
Online
Cost
FREE
Joy Neuhold
Greg Lutes
- Explore Copilot’s features and get a sneak peek into what we can expect next from Microsoft. Dive into Copilot’s interface, settings, and functionalities, including tools for writing and creating content.
- Watch a live demonstration of how to use Copilot in Microsoft Office applications.
- Learn how to customize Copilot with our top tips to improve your productivity (and avoid common pitfalls)!
Power BI: Mastering the Art of Data Intelligence
NOVEMBER 14, 2024
12:00 pm to 1:00 pm ET
Length
1 hour
Venue
Online
Cost
FREE
Greg Lutes
Joy Neuhold
- The Fundamentals: Quick refresher on Power BI fundamentals
- Complex Data Modeling: Delve into advanced table relationships, dynamic row-level security, and sophisticated DAX calculations
- Mastering Visualizations: Learn to create custom visuals with Power BI SDK, integrate R and Python for advanced analytics, and use storytelling features
- DAX Mastery: Explore complex DAX patterns, optimize query performance, and conduct advanced time-series and predictive analysis
- Power BI Ecosystem and Automation: Discover how to automate dataflows, leverage AI insights, and share your insights broadly with advanced sharing options.
We covered the basics earlier this year, but you told us you wanted to go even deeper! This comprehensive webinar is designed to take your data analytic skills to the next level. Once we quickly recap the basics, we’ll move on to:
- Intricate data modeling techniques
- Exploring advanced table relationships
- Implementing sophisticated DAX formulas
- Visual storytelling and crafting custom visuals
- Integrating powerful R and Python scripts
Our deep dive into DAX will reveal patterns and practices for performance tuning and predictive analysis, giving you the edge in complex data scenarios. Finally, we’ll look at connecting Power BI to other Microsoft tools, teaching you to automate dataflows and share insights with other stakeholders. If you are ready to harness data’s full potential and drive impactful decisions, this webinar is for you. Don’t miss this chance to elevate your expertise and become a sought-after professional in the analytics community.