What we're about
Upcoming events (2)
MARK WALTER (Industrial Finishes and Systems) - A Power BI Spin on Accounting and Finance Reports During Mark's talk, he will demonstrate how Industrial Finishes and Systems, Inc. (IFS) has used data and Power BI to provide everything from Corporate analytics, to external customer dashboards that help highlight added value and areas of profit improvement. He will demo how he built a drillable P&L statement with visualizations that compare year over previous year. He will also show his methodologies for highlighting material changes that are used to communicate to field managers succinctly. Mark is an Accounting and Analytics Manager at IFS. Since 1958, Industrial Finishes and Systems, Inc. (IFS), a Nationwide distributor, has brought complete system solutions to Auto Body Shops, RV manufactures, Wood product producers, and Aerospace industries. He is originally from Honolulu Hawaii but lived much of his adult life in the Seattle area where he majored in Finance and Accounting. Mark is an long time Excel power user, and today focuses on DAX/M and promoting a data driven culture. Mark enjoys speaking locally with networking and professional groups, helping to promote and build awareness of Power BI in the workplace. REID HAVENS (Havens Consulting) - Designing an Impactful KPI Scorecard in Power BI Knowing the right visuals, DAX, and design to build out a professional scorecard report can be challenging. Leverage native and custom visuals, DAX calculations, and design practices to build out a quality Power BI scorecard template to use for your business. The scorecard talk will be broken down into three sections. Section one will cover the basics of the report design by leveraging a DAX calculated table inside a Matrix Table visual. Section two will cover DAX measures, KPIs, and conditional formatting. The final section three will cover custom visual sparklines, and design practices to clean up the report for delivery to the client. Reid is the Founder of Havens Consulting Inc. and Microsoft MVP. He has a formal background in technology and organizational management, having obtained separate Master's Degrees in Organizational Development & Business Analytics. Reid has experience working with many of the Fortune 50, 100, & 500 companies. Additionally he guest lectures at the University of Washington and other universities, teaching Business Intelligence, Reporting, & Data Visualization. Embedded Report Example: http://www.havensconsulting.net/files-and-templates
BRIAN GRANT (CSG Pro) - The DAX Component Method Demo DAX is a tricky language to learn; one thing that would help new DAX authors immensely if having a mental framework both of specifically what they are supposed to be doing, and a short list of the kinds of tools they will be using to do it. The Component Method of understanding DAX breaks its essential actions down into one of four components which interact with each other in consistent ways. In this session we will demo these components and show you how they work together to answer questions in DAX. By the end you will be clued into the patterns that repeat over and over again within the construction of measures. Brian Grant is a masterful Analytics Consultant at CSG Pro by day, and a Power BI legend by night. Brian's passion for Power BI has led him to holistically master the tool from all three perspectives: M, DAX, and the visualization layer. He also has a passion for teaching and is constantly uploading new material to YouTube, blogging, and leading Power BI training sessions for clients. MIKE MAROTTA (PowerON) - The Art of the Possible: Write-Back & Planning for Power BI PowerON, a Microsoft ISV partner, has developed the world's first fully integrated BI and Performance Management Solution for Power BI. This new, award winning technology enables Write-Back & Planning functionality directly within Power BI reports. Users of any level can now enter data, make comments, do real-time what-if scenario creation, and perform budgeting/forecasting tasks directly in their Power BI reports. These inputs update the underlying SQL & SSAS Tabular data models and refresh Power BI visuals instantly. In addition, users can leverage PowerON’s Visual Table Editor to write-back data to any OLEDB/ODBC compliant data source (Oracle, SAP, Hadoop, Teradata, Amazon Redshift, etc.). Mike Marotta is a sales executive with almost 10 years of experience in the BI, CPM, & Visual Analytics industry. Mike works with both Fortune 500 & mid-sized organizations to enhance and cement Power BI usage across their respective organizations.