Skip Main Navigation
Page Content
This event has ended

Save This Event

Event Saved

Actionable Data Visualization In Power BI: The Essentials with Julie Koesmarno

SoCal SQL Saturday

Friday, April 10, 2015 from 7:45 AM to 5:15 PM (PDT)

Actionable Data Visualization In Power BI: The...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Early Bird   more info Ended $99.00 $6.44

Share Actionable Data Visualization In Power BI: The Essentials with Julie Koesmarno

Event Details

SQL Saturday #389 - Full Day Preconference Session

Actionable Data Visualization In Power BI: The Essentials with Julie Koesmarno

Abstract

Historically, users have been constrained to consume data in fixed platforms, with one specific dimension for digital viewings and a couple of printed layouts. Nowadays, with the ubiquitous mobile devices available, Management expects to know key business indicators and day-to-day operation performance on the go. Using well-designed data models and visualization techniques, Power View can leverage timely and quick dashboards for analysis on the go. Meanwhile, Pivot Tables and Pivot Charts in Excel can also provide greater insights both in the desktop and online version. Power BI Q&A can visualize data based on a natural language question using advanced indexing technique of Power BI. Power Map can provide custom 3D as well as geographical analysis.

This session will discuss how to design the appropriate data models to enable self-service data exploration and insightful analysis in Power BI, and how to create pixel perfect visualization for mobile devices. You will also learn how the techniques differ from traditional platforms. We will discuss fundamental data visualization principles, business requirements gathering techniques and data modelling tips/tricks. Using live demo, we will walk through ways to channel users focus on actionable analytics on operational, strategy and analytical dashboard use cases.

Featuring a full day workshop packed with demos, our aim is to introduce patterns as well as tips and tricks to build data visualization solution using Power BI both for online and offline consumption.

Objectives

  • Attendees will learn fundamental data modelling principles required to build operational, analytical and strategic Power View, Pivot Table/Charts, Power BI Dashboard reports 
  • Attendees will learn characteristics that make Actionable Analytics in Dashboards and Reports
  • Attendees will understand when to choose Power Map or Power View for Geospatial Analysis
  • Attendees will learn how to use Power Query to acquire data from various sources
  • Attendees will learn how to configure Power Pivot model to enable Power BI Q&A
  • Attendees will learn how to publish and administer Excel workbooks, Power Query queries and Power BI Dashboard
Course Outline
  1. Introduction to Power BI
  2. Acquiring and Preparing Data for Power View and Excel
  3. Data Modelling Patterns 101 Using Power Pivot
  4. Power Query 101 (for Power BI Dashboard)
  5. Creating Interactive Visualization for Actionable Analytics
  6. Tips and Tricks on Charts and Data Models
  7. Publishing and Adminstrering Dashboards and Reports in Power BI for Organization
Julie Koesmarno

Julie Koesmarno, SQL Server MVP, MCSE Data Platform, and MCSE Business Intelligence, is a SQL Server and BI consultant, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her recent projects include delivering a SQL Server 2012 data warehouse and BI solutions for a number of high profile clients in US and Australia.

FAQs

What is the refund policy?

Once purchased, tickets are non-refundable.  Tickets are transferrable. 

What does the ticket include?

The ticket for the event includes the following:

  • Access to Session Material for the Pre-Conference Workshop
  • Continental Breakfast, Lunch and Snacks are included. If you have any dietary restrictions please let us know at sqlsaturday389@sqlsaturday.com


What should I bring to the event?

There will be a lot of information presented at the event so you will likely need something to take notes.  If you have a laptop with SQL Server installed you may be able to follow along with demos or try techniques on your own databases

Where on campus is the event located?

Detailed instructions on the exact location of the classroom for your event will be sent closer to the day of the event in addition to information on parking.

Does this register me for the SQL Saturday event the next day?

No.  If you are plannig on attending the main SQL Saturday event the next day, please be sure to register on the main SQL Saturday site: https://www.sqlsaturday.com/389/register.aspx.

What if I have Questions?

Please email us at sqlsaturday389@sqlsaturday.com. 

Have questions about Actionable Data Visualization In Power BI: The Essentials with Julie Koesmarno? Contact SoCal SQL Saturday

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.