| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 20-04-2015 08:30 | Lynn Langit | Pre-Conference Session (full day) | Unlocking Big Data | 3 Tools an Hour - 24 FREE Tools every business analyst needs |
| 20-04-2015 08:30 | Rob Collie, Avi Singh | Pre-Conference Session (full day) | Discover & Integrate | Join the Power BI & Excel Revolution |
| 20-04-2015 08:30 | Chandoo (Purna Duggirala) | Pre-Conference Session (full day) | Analyze & Interpret | Building Awesome, Interactive & Advanced Charts with Excel |
| 20-04-2015 08:30 | Dean Abbott | Pre-Conference Session (full day) | Analyze & Interpret | An Overview of Predictive Analytics for Practitioners |
| 21-04-2015 09:45 | Jen Underwood | Breakout Session (60 minutes) | Visualize & Inform | Best Practice Mobile Dashboard Design |
| 21-04-2015 09:45 | Oz du Soleil | Breakout Session (60 minutes) | Discover & Integrate | The Pain and Glory of Data Preparation |
| 21-04-2015 09:45 | Scott Shaw | Lab (120 minutes) | Unlocking Big Data | Big Data and the Data Lake from the Analyst Perspective |
| 21-04-2015 09:45 | Avi Singh | Breakout Session (60 minutes) | Visualize & Inform | The Art of Power BI Visualization: Create Reports That Help You Run Your Business |
| 21-04-2015 09:45 | Rob Collie | Breakout Session (120 minutes) | Analyze & Interpret | Increased Margins, Period: Modern Excel and the Bottom Line |
| 21-04-2015 11:00 | Rick Grantham | Breakout Session (60 minutes) | Communicate & Lead | Making Informed Decisions: Guidelines for Creating an Effective Dashboard |
| 21-04-2015 11:00 | Dean Abbott | Breakout Session (60 minutes) | Analyze & Interpret | What Skills Do Predictive Modelers Need? |
| 21-04-2015 11:00 | Othniel Denis | Breakout Session (60 minutes) | Communicate & Lead | The ROI of Business Analytics: Calculating Financial Return |
| 21-04-2015 11:00 | Hyoun Park | Breakout Session (60 minutes) | Analyze & Interpret | The Data Supply Chain: Maximizing Value Throughout the Cycle |
| 21-04-2015 13:00 | James Kobielus | Breakout Session (60 minutes) | Unlocking Big Data | Unlocking Big Data: The Power of Cognitive Computing |
| 21-04-2015 13:00 | Jordan Goldmeier | Breakout Session (60 minutes) | Discover & Integrate | Creating Outstanding Spreadsheet Models |
| 21-04-2015 13:00 | Dipak Bhudia, Minnie Park | Breakout Session (60 minutes) | Discover & Integrate | Self Service Business Intelligence: Helping Businesses Help Themselves |
| 21-04-2015 13:00 | Brandon Purcell | Breakout Session (120 minutes) | Analyze & Interpret | Open for Business: Leveraging Open Data to Gain Advantage on the Competition |
| 21-04-2015 13:00 | Richard Lee | Breakout Session (60 minutes) | Communicate & Lead | Embracing The Data Leadership Nexus to Achieve Strategic Success |
| 21-04-2015 13:00 | Chandoo (Purna Duggirala) | Lab (120 minutes) | Visualize & Inform | Creating Awesome Charts in Excel: Process and Examples |
| 21-04-2015 14:30 | Marco Russo | Breakout Session (60 minutes) | Analyze & Interpret | Budgeting with Power Pivot |
| 21-04-2015 14:30 | Ike Ellis | Breakout Session (60 minutes) | Visualize & Inform | 60 Reporting Tips in 60 Minutes |
| 21-04-2015 14:30 | Paco Gonzalez | Breakout Session (60 minutes) | Discover & Integrate | Social Listening, Data Extraction & Discovery |
| 21-04-2015 14:30 | Michelle Ufford | Breakout Session (60 minutes) | Unlocking Big Data | Resistance is Futile: What You Need to Know about Big Data |
| 21-04-2015 15:45 | Satheesh Iyer | Breakout Session (60 minutes) | Unlocking Big Data | Is There Really Such a Thing as Turnkey Data Analytics Solution? |
| 21-04-2015 15:45 | Daniel Fylstra | Lab (120 minutes) | Analyze & Interpret | Beyond What-If: How to Build Analytic and Decision Models in Spreadsheets |
| 21-04-2015 15:45 | Mahesh Kumar, Santhosh Krishnan | Breakout Session (60 minutes) | Analyze & Interpret | Predictive Analytics in Social Media and Online Display Advertising |
| 21-04-2015 15:45 | Bill Jelen | Breakout Session (120 minutes) | Analyze & Interpret | MrExcel's Most Productive Analysis Techniques |
| 21-04-2015 15:45 | David Smith | Breakout Session (60 minutes) | Unlocking Big Data | Real-Time Big Data Analytics with R |
| 21-04-2015 15:45 | Sanjay Soni, Miguel Martinez | Breakout Session (60 minutes) | Visualize & Inform | Pour Some Data on Me: Discover, Manage, Analyze, and Visualize Your Data with Power BI |
| 21-04-2015 17:00 | Miguel Llopis | Breakout Session (60 minutes) | Discover & Integrate | Data Hunters & Gatherers: Discover, Acquire, and Transform Your Data with Power Query |
| 21-04-2015 17:00 | David Schaefer, Gregorio Martinez | Breakout Session (60 minutes) | Analyze & Interpret | Enabling Customer-Driven Insight: How Intel is Delivering Self-Service BI |
| 21-04-2015 17:00 | Marc Reguera, Jeff Lumpkin | Breakout Session (60 minutes) | Communicate & Lead | The Valued Analyst: From Data to Insight in 60 Minutes |
| 22-04-2015 09:45 | Igor Peev | Breakout Session (60 minutes) | Visualize & Inform | Visualizing and Analyzing Data in 3D |
| 22-04-2015 09:45 | Jessica Ellis | Breakout Session (60 minutes) | Unlocking Big Data | Internet of Things Farm: Introducing Kids to Data Science |
| 22-04-2015 09:45 | Dean Abbott | Lab (120 minutes) | Analyze & Interpret | Starting Your First Predictive Analytics Project |
| 22-04-2015 09:45 | James Taylor | Breakout Session (60 minutes) | Analyze & Interpret | A New Approach to Defining BI Requirements |
| 22-04-2015 09:45 | Chris Webb | Breakout Session (60 minutes) | Discover & Integrate | Best Practices for Collecting and Analyzing Data with Power Query and Excel |
| 22-04-2015 09:45 | Ken Raetz | Breakout Session (60 minutes) | Communicate & Lead | The Art of Prototyping Analytics |
| 22-04-2015 11:00 | Kasper de Jonge | Breakout Session (60 minutes) | Analyze & Interpret | Advanced Modelling and Calculation Using the Power BI Designer |
| 22-04-2015 11:00 | Chandoo (Purna Duggirala) | Breakout Session (60 minutes) | Analyze & Interpret | Top 10 Excel Formulas for Analysts |
| 22-04-2015 11:00 | James Haight | Breakout Session (60 minutes) | Visualize & Inform | Data Visualization, Storytelling, and the Brain |
| 22-04-2015 11:00 | Lynn Langit | Breakout Session (60 minutes) | Discover & Integrate | Using Premium Data for Analysts |
| 22-04-2015 11:00 | Theresa Palmer-Boroski | Breakout Session (60 minutes) | Discover & Integrate | Instant Dashboards for Your Critical Business Applications: Dynamics, Salesforce, Marketo and more! |
| 22-04-2015 13:00 | Matt Allington | Breakout Session (60 minutes) | Visualize & Inform | Becoming Team Awesome: How to Create Value and Present Data to Business Executives in SharePoint |
| 22-04-2015 13:00 | Jack Mardack | Breakout Session (60 minutes) | Visualize & Inform | The Analytics of Growth Hacking |
| 22-04-2015 13:00 | Bob Phillips | Breakout Session (60 minutes) | Visualize & Inform | Dynamic Presentation Using Excel CUBE Formulas |
| 22-04-2015 13:00 | Marco Russo | Breakout Session (60 minutes) | Analyze & Interpret | Inventory Valuation Techniques with DAX and Tabular Models |
| 22-04-2015 13:00 | Ken Puls | Lab (120 minutes) | Analyze & Interpret | Optimizing your Power Pivot models using Power Query (and other performance tips) |
| 22-04-2015 13:00 | Andrew J. Brust | Breakout Session (120 minutes) | Unlocking Big Data | Using Hadoop with Excel and Power BI, Plus Data Discovery 101 |
| 22-04-2015 14:30 | Zack Barresse | Breakout Session (60 minutes) | Visualize & Inform | Advanced Excel Add-Ins |
| 22-04-2015 14:30 | Sandy Rivas | Breakout Session (60 minutes) | Visualize & Inform | Big Ways Small Businesses are Leveraging Analytics to Gain Insights |
| 22-04-2015 14:30 | Mark Wilcock | Breakout Session (60 minutes) | Analyze & Interpret | 'What If’ Scenarios for Uncertainty in Business – Analytics as Your Crystal Ball |
| 22-04-2015 14:30 | Jordan Goldmeier | Breakout Session (60 minutes) | Communicate & Lead | Making Better Decisions with Data |
| 22-04-2015 15:45 | Jen Stirrup | Breakout Session (60 minutes) | Visualize & Inform | Pulling Back the Green Curtain: Data Forensics, Power BI, and Dataviz |
| 22-04-2015 15:45 | Paco Gonzalez | Breakout Session (60 minutes) | Analyze & Interpret | Social Listening for Richer Data, Unstructured Analytics |
| 22-04-2015 15:45 | Rick Grantham | Breakout Session (60 minutes) | Communicate & Lead | Creating an Effective Reporting Strategy: Tools, Metrics, Analytics |
Event Date: 20-04-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Unlocking Big Data
She will take you through the common data projects stages (survey, clean, locate, process, store, query and analyze) and will show you tools which can help you be more effective at each of these stages.
Tools shown will include those which help you to find and fix mistakes in your source data, to tools which visualize your data in a useful way and many more.
Event Date: 20-04-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Discover & Integrate
Either way though, 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 their 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 – we will literally give you maps that demystify Microsoft’s rapidly-evolving offerings in this space.
Fundamentals – short and simple, these fit onto a single 6-step flowchart (provided).
Patterns – “recipes” that 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.” Avoids topics that are too complex or too “niche.”
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.
Event Date: 20-04-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Analyze & Interpret
• Interactive charts with form controls, slicers & VBA • Mixing 2 or more chart types in to 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 superhero
Example charts you will create by end of this session:
<a href="http://cache.chandoo.org/images/c/analytical-charts-demo.gif" target="_blank">http://cache.chandoo.org/images/c/analytical-charts-demo.gif</a> <a href="http://img.chandoo.org/c/then-vs-now-chart-with-details-demo.gif" target="_blank">http://img.chandoo.org/c/then-vs-now-chart-with-details-demo.gif</a> <a href="http://img.chandoo.org/vp/interactive-sales-chart-demo-2.gif" target="_blank">http://img.chandoo.org/vp/interactive-sales-chart-demo-2.gif</a>
Event Date: 20-04-2015 08:30 - Category: Pre-Conference Session (full day) - Track: Analyze & Interpret
This sessions 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.
Event Date: 21-04-2015 09:45 - Category: Breakout Session (60 minutes) - Track: Visualize & Inform
Event Date: 21-04-2015 09:45 - Category: Breakout Session (60 minutes) - Track: Discover & Integrate
This dirty part of analytics isn’t formally taught. There are no standard tricks for cleaning data. Strategy and experience are the data warrior's weapons.
People who can clean and shape data are true heroes: They can remove duplicates, get data into the right fields, merge data, and so on. Sometimes it’s elegant. Other times, it’s ugly. The result is that any, analysis, and suggestions are rooted in trustworthy data quality.
In this session, you’ll learn strategies for assessing data quality, tips for cleaning and shaping data and determining how clean is “clean enough”, ideas for creating policies and processes that can guide you when working with unclean data, and which Excel features are most useful during prep work.
Event Date: 21-04-2015 09:45 - Category: Lab (120 minutes) - Track: Unlocking Big Data
The concept of a data lake is emerging as a popular way to organize and build the next generation of data systems to master new big data challenges. Organizations are seeking to create data lakes because they manage and use data with increased volume, variety, and unprecedented velocity. However, how can data professionals and analysts access the data lake for the expected insights at the velocity required by the business?
In this session, we will take every day relevant business scenarios to learn how to spring business value from data held in the data lake, in order to answer key questions:
• How do we import structured, semi-structured and unstructured data into our data lake?
• How can we access unstructured and semi-structured data to derive value for the enterprise?
• How do we do analytics and reporting over the data lake in Hadoop?
• What are the similarities and differences between accessing data held in a data lake in terms of architecture and syntax?
In terms of the technology, we will springboard from SQL to learn how to do familiar activities such as import, access and visualise data in our data lake. To do this, we will use technology such as Hive, Hue, and the Hadoop Distributed Files System (HDFS) as a data source.
Come and join us for this practical two hour session which will build on your existing SQL skills to demystify Big Data and the Data Lake for analysts. This session is aimed at people who want to keep pace with the latest Big Data technology by adopting the latest techniques to explore the data lake, building on their existing analytical knowledge.
Event Date: 21-04-2015 09:45 - Category: Breakout Session (60 minutes) - Track: Visualize & Inform
Learn how you can effectively use Power BI Visualizations to create reports your users would love and actually use every day. Avi Singh, will share all the best practices he gleaned while building a Power BI reporting platform for a BI audience of 600+ users within Microsoft.
You will see Power BI Visualizations in action within Excel, online on SharePoint and in its new avatar at Power BI preview. You will learn about the ‘winning’ report layout, crafting reports around user stories, how best to use basic and advanced Power BI Visualization features, and more.
If you apply what you learn in this session, you will help unlock the insights that are buried in your data and help drive your business to new levels.
Event Date: 21-04-2015 09:45 - Category: Breakout Session (120 minutes) - Track: Analyze & Interpret
But it often seems like the reporting and analytics world didn't get the message. Why, for instance, is “Sales Dollars” the most commonly-reported metric when only MARGINS truly matter?
In this session, Rob Collie will show you how Modern Excel, with its suite of Power BI tools, helps us dramatically kick those bad habits. He will provide you with a step-by-step methodology for “working backwards” from the impact you need, coming full circle to delivering that impact in less than a day. Using a live case study as a backdrop, you will see everything - from sketches and data prep to formulas and dashboards.
Your job is then to take this approach, which has saved individual clients millions of dollars per year, back to your own business. And to your own bottom line.
Event Date: 21-04-2015 11:00 - Category: Breakout Session (60 minutes) - Track: Communicate & Lead
• Determine the best ways to scope your dashboard project, including tips for gathering requirements and eliciting feedback
• See what’s required to build an effective dashboard, from documenting query mockups to creating dashboard prototypes.
Rick will go through every step of the requirements gathering process and provide the audience with LIVE demonstrations at every step, including sample mockups and real-life examples of how to best scope your dashboard.
After this session, you will know when you should (and when you should not) start your KPIs with your company’s annual report. You will be armed with the most efficient process to create the most effective dashboards.
Event Date: 21-04-2015 11:00 - Category: Breakout Session (60 minutes) - Track: Analyze & Interpret
Event Date: 21-04-2015 11:00 - Category: Breakout Session (60 minutes) - Track: Communicate & Lead
Event Date: 21-04-2015 11:00 - Category: Breakout Session (60 minutes) - Track: Analyze & Interpret
By fully considering the full “supply chain” of data from source to consumption, data analysts can insure that their data extraction, quality, and integration are fully appreciated by the end user whether it be an employee, partner, customer, or other interested party.
Event Date: 21-04-2015 13:00 - Category: Breakout Session (60 minutes) - Track: Unlocking Big Data
Event Date: 21-04-2015 13:00 - Category: Breakout Session (60 minutes) - Track: Discover & Integrate
Event Date: 21-04-2015 13:00 - Category: Breakout Session (60 minutes) - Track: Discover & Integrate
This session will cover a real-world use-case of how one of the worlds largest banks implemented self-service and agile BI methodologies to give their risk officers the tools necessary to deliver datapoints required by a rapidly growing number of regulatory bodies during the aftermath of the financial crisis.
See how some IT departments are evolving from report delivery to data delivery, letting businesses handle the dynamic query and representation whilst IT can observe and monitor how businesses use the data. This ‘BI-on-BI’ helps focus scarce IT resources to delivering even higher quality data where it matters most.
Event Date: 21-04-2015 13:00 - Category: Breakout Session (120 minutes) - Track: Analyze & Interpret
• Mining the Consumer Financial Protection Bureau database to prevent customer complaints
• Leveraging the Home Mortgage Disclosure Act database for competitive analysis
• Integrating open data with internal data sources and social media. Relevant technologies: R, Excel
Event Date: 21-04-2015 13:00 - Category: Breakout Session (60 minutes) - Track: Communicate & Lead
The Data Leadership Nexus is the intersection of; Top-Down Executive Leadership, a fully-aligned Organizational Culture and the use of Data (Big or Small), Information & Analytics as Core Competencies. It is the path to Strategic Success in becoming a Predictive Enterprise and it the linchpin of every Organization’s Strategic Plan for building & sustaining “a Culture of Evidence-based Decisioning”.
In my presentation I will dive deeper into all aspects of the Data Leadership Nexus and lay the groundwork for you to use in leveraging it as your Strategic Framework.
Event Date: 21-04-2015 13:00 - Category: Lab (120 minutes) - Track: Visualize & Inform
Learn how to create awesome charts using Microsoft Excel. Understand the principles behind chart selection, creation & formatting to impress & communicate. In this hands-on session we will be creating many Excel charts for common business analysis needs, understand why they work, how to improve them and what mistakes to avoid. • 6 types of analytical needs • 8 recommended chart types • Data to ink ratio & maximizing it • How to choose colors & fonts • Formatting guidelines • Charts for Budget vs. Actual analysis • Charts for trends & forecasts • Charts for comparing and highlighting best (worst) performers Who can attend: Anyone familiar with Excel and already creating charts (doing analysis). Recommended for CXOs, Managers or Analysts or people who need to communicate often.
Event Date: 21-04-2015 14:30 - Category: Breakout Session (60 minutes) - Track: Analyze & Interpret
When it comes to budgeting, each company is a unique scenario. In this session, Marco will show you some common techniques to use when building a budget model with Power Pivot and Power Query, including previous year allocation, multiple-step budgeting with linked back tables, handling of budget on products which do not yet exist.
Event Date: 21-04-2015 14:30 - Category: Breakout Session (60 minutes) - Track: Visualize & Inform
Event Date: 21-04-2015 14:30 - Category: Breakout Session (60 minutes) - Track: Discover & Integrate
Event Date: 21-04-2015 14:30 - Category: Breakout Session (60 minutes) - Track: Unlocking Big Data
In this session, Michelle Ufford will introduce Big Data using concrete, real-world examples and will explain why she believes this topic is applicable to everyone. She’ll provide a brief introduction to Hadoop, including the technologies and languages most relevant to analysts. She’ll explore some common use cases and access patterns for analysts using Hadoop, including ad hoc querying and data visualization. Finally, she’ll conclude with Q&A and resources for learning more.
If you’re still trying to understand Big Data and decide if it’s relevant to you, then this is a session you won’t want to miss!
Event Date: 21-04-2015 15:45 - Category: Breakout Session (60 minutes) - Track: Unlocking Big Data
Event Date: 21-04-2015 15:45 - Category: Lab (120 minutes) - Track: Analyze & Interpret
Countless ads and articles from software vendors claim that you need to “outgrow the spreadsheet” and learn a whole new platform and language (theirs) in order to build analytic models and solve decision problems. Yet virtually all these tools feature “Excel import/export” buttons, and meanwhile tons of users have built analytic and decision models directly in Excel, often getting big payoffs. So, can you do it? Sure you can, but it requires a somewhat different way of thinking about your spreadsheet model, and more than simple calculation. In this hands-on session, you will do it! We’ll walk you through creation of Solver models for optimization, Monte Carlo simulation models for risk analysis, decision analysis models and more in Excel 2013, running on supplied PCs at your lab room seat. Analytic decision models are very often based on the summarized data we get from business intelligence tools – so we’ll use Power Pivot and Power Query to retrieve, summarize and deliver the data we need for our Excel-based analytic models.
Event Date: 21-04-2015 15:45 - Category: Breakout Session (60 minutes) - Track: Analyze & Interpret
However, the marketers, online advertising platforms, and other stakeholders need to be equipped with suitable analytical tools and methodologies to maximize the potential of online and digital media. The traditional analytical tools are often insufficient due to the rapidly growing volumes of data as well as increasing importance of dealing with textual and unstructured data in this space. In this talk you will learn how to:
• Optimize campaign for an impression given user and webpage characteristics • Calculate optimal bid price for a campaign • Increase CTR (Click-through rate) by more than 50% • Decrease CPC (Cost per click) by 25%
Event Date: 21-04-2015 15:45 - Category: Breakout Session (120 minutes) - Track: Analyze & Interpret
Attendees will learn how to use pivot tables to quickly create year-over-year analyses and how to apply an AutoFilter to a pivot table in order to filter on a single column or to generate a true top 10 report. Learn how to roll up daily dates in a pivot table by week, or into 13-monthly periods. Learn how to consolidate data of different shapes using the Consolidate command. Learn how to produce a high-to-low report of sales by customer using the Subtotal command. Learn when to take your flat data through Power Pivot to create asynchronous reports. Learn how to leverage GetPivotData to create beautifully formatted reports instead of hating Excel’s insistence on using it.
Event Date: 21-04-2015 15:45 - Category: Breakout Session (60 minutes) - Track: Unlocking Big Data
Event Date: 21-04-2015 15:45 - Category: Breakout Session (60 minutes) - Track: Visualize & Inform
Event Date: 21-04-2015 17:00 - Category: Breakout Session (60 minutes) - Track: Discover & Integrate
Event Date: 21-04-2015 17:00 - Category: Breakout Session (60 minutes) - Track: Analyze & Interpret
Event Date: 21-04-2015 17:00 - Category: Breakout Session (60 minutes) - Track: Communicate & Lead
Join us on the journey from data to insight to impact. We will breakdown the different key components such as understanding key success drivers & KPI’s, assessing data availability, and then using new Power BI tools to design views that are aligned with your business goals. You will leave with practical learnings you can apply immediately.
Event Date: 22-04-2015 09:45 - Category: Breakout Session (60 minutes) - Track: Visualize & Inform
Event Date: 22-04-2015 09:45 - Category: Breakout Session (60 minutes) - Track: Unlocking Big Data
Event Date: 22-04-2015 09:45 - Category: Lab (120 minutes) - Track: Analyze & Interpret
Predictive analytics has become a critical component of a big data strategy. However, many organizations struggle with taking the first steps. This session defines predictive analytics, describes how it differs from related approaches such as Business Intelligence and statistics, outlines how key considerations that can cause these projects to fail.
Event Date: 22-04-2015 09:45 - Category: Breakout Session (60 minutes) - Track: Analyze & Interpret
Event Date: 22-04-2015 09:45 - Category: Breakout Session (60 minutes) - Track: Discover & Integrate
• Creating and using a parameter table • Combining data from multiple Excel workbooks into a single data set • Handling errors and unavailable data sources • Calling web services, handling authentication and working with XML • Performing sentiment analysis in Excel with Power Query and Azure Machine Learning
Event Date: 22-04-2015 09:45 - Category: Breakout Session (60 minutes) - Track: Communicate & Lead
Do you find yourself stuck attempting to grow the use of analytics within your organization? Is your company culture still stuck in doing it the “long and hard way”? Does IT still hold the keys to implementing deep analytics?
With the introduction of Power BI and a growing set of cloud-based analytics capabilities, Microsoft has opened the door to agile analytics and enterprise reporting capabilities. Like never before, leaders are able to develop and deliver the value of analytics “early and often”, and use this as a springboard to change the culture of analytics throughout the organization. Power BI can be a critical component of a corporate analytics strategy, and by empowering business users to do what they do best (analyze the business), IT and business leaders can finally begin to change the culture of analytics.
In this session, you will learn: • To identify the barriers to changing your organization’s data culture • To find ways to create a bridge between IT and business leaders to gain access to critical resources and people • The importance of ROI on your analytics projects • To use Excel and Power BI as an effective tool to develop prototypes and production-ready analytic solutions. • How to empower key business leaders and analysts to further the data culture change throughout the organization.
Event Date: 22-04-2015 11:00 - Category: Breakout Session (60 minutes) - Track: Analyze & Interpret
Event Date: 22-04-2015 11:00 - Category: Breakout Session (60 minutes) - Track: Analyze & Interpret
Who can attend: Anyone familiar with basic Excel formulas and already using them to analyze data. Recommended for analysts or people who create reports.
Event Date: 22-04-2015 11:00 - Category: Breakout Session (60 minutes) - Track: Visualize & Inform
Event Date: 22-04-2015 11:00 - Category: Breakout Session (60 minutes) - Track: Discover & Integrate
Event Date: 22-04-2015 11:00 - Category: Breakout Session (60 minutes) - Track: Discover & Integrate
Event Date: 22-04-2015 13:00 - Category: Breakout Session (60 minutes) - Track: Visualize & Inform
After an Analyst creates value-added reports, the next step is to multiply the value and business benefits by sharing their tools across the organization.
In this practical “how to” session, you’ll learn how to quickly deploy PowerPivot Workbooks across the organization using SharePoint, extending the value from the reports while reducing the effort to refresh reports. You’ll learn patterns that can be replicated to help you get started without having to be a SharePoint expert or the need for IT support.
From this session, you’ll head back to work understanding the optimal way to present data for business executives to consume via a “positive web browsing experience.” You’ll also have the practical advice on how to explain the value to your organization’s decision makers.
Event Date: 22-04-2015 13:00 - Category: Breakout Session (60 minutes) - Track: Visualize & Inform
Analytics Model Overview We'll take a look at how growth hacking perspective drives the strategy and implementation of analytics. Jack will give a high-level architectural overview, and talk about some of the components used in each part: logging, log processing (ETL), dashboards, ad-hoc querying. He will touch on how the parts fit together, and talk about the typical data model: people, objects, events, metadata.
Jack will offer some examples from Prezi and Chartcube. He will talk about how the Prezi growth team built additional analytics on the existing Hadoop stack, adding hundreds of individual daily metrics to serve their needs, how they enriched user metadata and created new data architectures that were used by the whole company. He will look at how they used perspective and data to attack the user activation problem, and how they discovered the agency of content in the user life cycle through exploratory analysis. Jack will talk about how the situational differences between companies that have some users, versus zero users, impact the analytics strategy, and discuss how analytics serves user discovery in early-stage companies, and how they use data to consider the problem of product/market fit.
You should come away with a good understanding of how software companies leverage analytics for growth. Many of the analytical strategies and principles should transfer and have relevance for people working outside of software.
Event Date: 22-04-2015 13:00 - Category: Breakout Session (60 minutes) - Track: Visualize & Inform
Dashboards with good charts and graphics go some ways to delivering information for such users, but often a good table of results will give the correct amount of detail to gain the necessary insights, and is easy to read. With the aptly named CUBE formulas, Excel has the capability to read data directly from a data cube in the spreadsheet. This is a great way to build structured output in Excel, in the form of a simple table. The problem with this approach is in managing the data changes, changes in the underlying data can mean more or fewer rows of data to show in your table.
This session is not intending to explain how to use those CUBE formulae, although using them in the presentation will show their usage, as it is assumed that the audience at least knows of them and what they each do. Instead, the emphasis is on showing how to use other Excel formulas to manage the output, building a truly dynamic display that caters for changes in the size of the underlying data, whilst also handling those ugly #REF errors that can occur when users insert or delete rows above the output table.
Given time, we will add a little MDX to the formulas to show further dynamic capability.
Event Date: 22-04-2015 13:00 - Category: Breakout Session (60 minutes) - Track: Analyze & Interpret
Event Date: 22-04-2015 13:00 - Category: Lab (120 minutes) - Track: Analyze & Interpret
You know the scene; you've built a beautiful Power Pivot model that has solved all of your organization’s problems. You open it up, click Refresh and wait patiently for all the data to stream in. That’s okay, there’s a lot of data and you expect that. Then you click a slicer and… wait…
Time during the initial data load is one thing, but consumer’s patience during use is another. Their tolerance for latency is much less. In this session we’ll explore the things you can do to increase your Power Pivot model performance. We’ll look at the key factors that affect performance, as well as the things you can do to deal with them. In addition, we’ll look at how sourcing your data with Power Query can give you ultimate control over your data’s size and shape, and tricks to optimize it for Power Pivot consumption.
Event Date: 22-04-2015 13:00 - Category: Breakout Session (120 minutes) - Track: Unlocking Big Data
We’ll start by looking at Apache Hadoop, including its architecture, capabilities, and how to work with it directly. Then we’ll move up a couple of layers of abstraction and see how we can query Hadoop data using Excel, Power Query, Power View and Power BI. This will be a guided tour of Big Data technology and practical, approachable ways to work with that data using Microsoft’s BI tools.
From that focused look at Power BI, we’ll transition into an investigation of other self-service data discovery tools. We’ll look at tools from several vendors, including Tableau, Qlik and Jaspersoft. We’ll see how these tools compare to Microsoft’s, how they connect to Hadoop and we’ll learn about the commonalities between the products.
Event Date: 22-04-2015 14:30 - Category: Breakout Session (60 minutes) - Track: Visualize & Inform
In many cases your business may have a resident Excel expert on-hand, or that might even be you. Going for outside help or consultancy can be an extremely expensive endeavor (not to mention how many bad developers there are). This means any add-in need which comes up could be handled by the resident guru. Is that you?
Ranging from logical coding scenarios to shared add-ins over a network, this session will have pearls for your guru. Add-Ins can give your tools a beautiful and elegant UI and save you and your users countless hours of work by automating tasks.
Event Date: 22-04-2015 14:30 - Category: Breakout Session (60 minutes) - Track: Visualize & Inform
Event Date: 22-04-2015 14:30 - Category: Breakout Session (60 minutes) - Track: Analyze & Interpret
Event Date: 22-04-2015 14:30 - Category: Breakout Session (60 minutes) - Track: Communicate & Lead
Event Date: 22-04-2015 15:45 - Category: Breakout Session (60 minutes) - Track: Visualize & Inform
Event Date: 22-04-2015 15:45 - Category: Breakout Session (60 minutes) - Track: Analyze & Interpret
Event Date: 22-04-2015 15:45 - Category: Breakout Session (60 minutes) - Track: Communicate & Lead
• Determine the most appropriate BI tools to use given your organization’s BI maturity and what key performance indicators (KPIs) you should be using ?
• Identify the most effective way to tie KPIs to your organization’s strategic direction ?
• Determine the appropriate analytic direction to take once a KPI measurement is missed (stop light turns red) ?
This presentation will show the audience how to develop a reporting strategy that optimizes user adoption.
