Lynn Langit
In this hands-on session, Lynn will share, show and teach how to get more value of your data by using her favorite free tools for analysts. Lynn will take you through data projects stages - from tools which help you to find free datasets on the web, to tools which perform common parsing (JSON data in Excel anyone?) and tools which help to visualize results.
Dean Abbott
Predictive Analytics (PA) has emerged as a “go to” approach to creating data-driven business decisions. The science of PA is not new, the algorithms are not new. What is new is how these techniques are applied to big and small data as organizations collect and integrate data that provide better information for predictive modeling. This session will provide a practitioners overview to Predictive Analytics and four of the most misunderstood topics: data preparation, sampling, the strengths and weaknesses of algorithms, and how to assess model accuracy.
Chandoo
Learn how to create interactive & advanced charts in Excel in this hands-on session. Grow your charting repertoire beyond simple bar & column charts. In this full day session, you'll learn:
- Interactive charts with form controls, slicers & VBA
- Mixing 2 or more chart types into one view (Case Study)
- Panel charts - communicating a lot of information in one view
- Charting best practices & principles
- How to speed up chart formatting & replication like a superman
By the end of the session, you'll be able to create charts like these: Example 1, Example 2, Example 3
Rob Collie & Avi Singh
Power BI is a multi-faceted technology “wave” that can be thought of as “Business Intelligence finally becoming accessible.” But it is also very useful to view it as “a revolution in Excel’s analysis and reporting capabilities.”
Either way, once armed with its industrial-strength depth, you will conquer an unlimited spectrum of analytical, reporting and modeling needs. We repeatedly see dramatically improved productivity, efficiency, and profitability within a matter of days.
In this full day session, Rob Collie and Avi Singh have filtered many years of “Modern Excel” and Power BI education, writing, and consulting experience down to the things anyone can learn and retain in a short period of time, while simultaneously building a confident foundation for future learning. Together you will take a 100% human and pragmatic approach.
Their recipe, geared toward absolute beginners, will give you analytical superpowers, broken into five easy-to-follow segments:
- Roadmap – get maps that demystify Microsoft’s rapidly-evolving offerings in this space.
- Fundamentals – short and simple fundamentals that fit onto a single 6-step flowchart (provided).
- Patterns – “recipes” you can easily follow and modify to solve business problems, without requiring PhD-level mastery.
- Priorities – focused on the capabilities that are most “bang for the buck.”
- Examples – no reference guide beats a working example that you can revisit when needed. Each student takes home dozens of working examples.
The only prerequisite is to enjoy data. Join us for the revolution.
To add a Pre-Conference session to your existing registration, please call Shannon Cunningham at 888.714.5544 or via
email.