Marc Beacom, Author at DawaBI - Page 3 of 10

marcbeacom

About Marc Beacom

Marc Beacom is President of DawaBI, a Data Warehouse and Business Intelligence Consultancy firm focusing on Making Data-Driven Decisions Possible. He has been working with SQL Server for over a decade delivering scalable solutions for organizations of all sizes. He has earned several industry certifications and degrees. Marc is an active member of the community and has served 5 years on the board of two Colorado SQL Server User Groups (Denver and Colorado Springs), 1 year as a Regional Mentor for PASS and is currently on the boards of two Colorado nonprofit organizations; Colorado GiveCamp and Camp To Belong Colorado.

PASS SQLSaturday Events: March 2014

Date Event March 1, 2014 SQLSaturday #278 – Budapest 2014 March 1, 2014 SQLSaturday #268 – Connecticut 2014 March 6, 2014 SQLSaturday #280 – Vienna 2014 March 15, 2014 SQLSaturday #276 – Silicon Valley 2014 March 22, 2014 SQLSaturday #269 – Exeter 2014 March 22, 2014 SQLSaturday #277 – Richmond 2014 March 29, 2014 SQLSaturday #275 – Copenhagen 2014 March 29, 2014 SQLSaturday #262 – Boston 2014 March 29, 2014 SQLSaturday #287 – Madison 2014 March 29, 2014 SQLSaturday #279 – Phoenix 2014
View future events on the SQLSaturday website.
By |February 18th, 2014|PASS, SQLSaturday|

February – Colorado SQL Events

Please register soon as seating is limited, and let friends and colleagues know about the event. Most events are free, however a nominal fee may be charged so that lunch may be provided (not pizza).

Date Group Info
Tuesday, February 4, 2014 Denver SQL Lunch
Tuesday, February 18, 2014 Boulder SQL Server Performance
Monday, February 17, 2014 Northern Colorado Performance Tuning

PASS SQLSaturday Events: February 2014

 

Date Event

February 8, 2014

SQLSaturday #241 – Cleveland 2014

February 22, 2014

SQLSaturday #273 – Tampa 2014

View future events on the SQLSaturday website.

By |January 15th, 2014|PASS, SQLSaturday|

Breaking Complex Data into Visualizations that Tell a Story

How much do you enjoy reading pages and pages of detailed report data? A large amount of information presented in a typical Excel spreadsheet can also be difficult to digest. Presenting complex data in a way that everyone can easily understand can be a challenge for companies. Data visualizations are a simple way to summarize data down into easy-to-understand terms. Various studies by companies like 3M, show that people respond better to data visualization rather than raw data.

Data Grid for visualizaiton

Data Grid for visualizaiton

When your company has complex or a large amount of information to present, instead of just putting a bunch of numbers into a report, data visualization allows you to tell a story that would otherwise be virtually impossible to tell due to the shear amount of data organizations have today. Busy executives can more easily see patterns at a glance.

Using charts, graphs and other visuals can help the company’s management:

  • Easily spot areas that need improved
  • See patterns in sales volume
  • Understand customer behavior and what impacts it
  • Better understand demographics of the customer base and how to anticipate future demand of products
  • Make decisions on where to reduce expenses
Bar Chart for Data Visualization

Bar Chart for Data Visualization

Choosing the Best Visuals to Support Your Data

One of the biggest challenges in breaking down data into visuals is deciding which type of graphic would work best to present that information. There are many factors to weigh, including how much data needs to be presented, the overall goal of the visual and which items should be included and which shouldn’t. Working with someone experienced in visualizing data will help you better understand what types of visual data work best for different purposes and for your individual company.

Keep in mind that more than one type of graphic may be necessary to fully explore the data as a whole. One example would be sales figures for the year. A bar chart with top sales months highlighted might help your company understand which months are the busiest for sales and which months need more attention, while a pie chart of top-selling items could help you see if there are products that need replaced or updated.

Figuring out the Data’s Key Point

Another thing to consider is what the key point of the data actually is. Keep in mind that the visualization is meant to help the lay person more easily understand a collection of statistics and figures. First, everything needs to be labeled clearly, so a quick glance tells the viewer what the graphic is about. What information is it getting across?

Let’s say the graphic is a module on a dashboard that shows how many customers are using the company’s website and how they are using it. What is the most important information from those statistics? For the CEO, the most important information may be items like:

  • What percentage of customers are visiting the website versus contacting the company over the telephone?
  • How are they using the website? For information? To order? To interact?
  • How does this compare to competitor websites?

Driving Action

The right visual drives action by presenting data, calling attention to key points and engaging the reader. Modern data visualizations also include interactive elements in some cases that allow you to drill down into the detailed data that the visual relies upon, but fancy visuals shouldn’t be added just for the sake of adding these items.

Like human DNA no two visualizations are exactly alike. Each company has a different story to tell and each set of data is another chapter in that story. Understanding which data visualization tells the story the best takes time and the ability to break down complex data.

How do you tell your data story?

By |January 9th, 2014|Visualizations|

PASS Virtual Chapter Events : December 2013

Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources including an archive of past presentations, and special training events.

Application Development – Virtual Chapters

Date: Friday, December 6, 2013

Time: 2:00 PM – 3:00 PM (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Isn’t That Spatial: Spatial Data for the App Dev

Register

Virtualization – Virtual Chapters

Date: Wednesday, December 11, 2013

Time: 12:00 pm – 1:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Virtualization Question & Answers with Brent Ozar

The Virtualization Virtual Chapter (aka SIG) is dedicated to better management of SQL Servers in virtual environments like Microsoft Hyper-V and VMware vSphere. We: Help the community by producing things like monthly training webcasts, a centralized list of helpful virtualization-savvy administrators, and a periodic report of what works well under virtualization and what isn’t quite working yet. Help virtualization vendors by getting training and configuration information out to the people who need it, and helping the vendors build a better product with our feedback. Help PASS management by building assets that PASS can leverage (like a library of training content) and showing that PASS solves real DBA problems.

Speaker Info:

Brent Ozar is a Microsoft Certified Master of SQL Server 2008 and a Microsoft SQL Server MVP. He has over a decade of experience with SQL Server, systems administration, SAN storage, virtualization, and project management. Today, he’s a consultant for Brent Ozar Unlimited. Previously, Brent was a SQL Server expert at Quest Software and a DBA at Southern Wine & Spirits, a Miami-based wine and spirits distributor. Brent blogs at http://www.BrentOzar.com like it’s going out of style.

Event Details >> Attend

Database Administration – Virtual Chapters

Date: Wednesday, December 11, 2013

Time: 2:00 pm – 3:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Load Testing with SQL Server Tools sponsored by Dell Software

It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, we can gain these key insights, perform modifications to existing configurations, and understand the impact on performance levels. Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.

Speaker Info:

Neil Hambly is a 14-year SQL Server veteran, with expertise in SQL Server from version 6.5 to the latest 2012 edition. He’s held database roles at major organizations, including the BBC, ABN AMRO, and Accenture, as well as at a number of market-leading companies. Currently CTO/Founder at SQLnextSteps, he’s worked as a DBA, developer, and architect. Leader of the PASS London Chapter, Neil can frequently be found speaking at UK and international events.

Attend

Big Data Virtual Chapter – Virtual Chapters

Date: Tuesday, December 17, 2013

Time: 4:00 pm – 5:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Building a Big Data Architecture

Big data solutions call for different architectural solutions than our traditional workloads. Here we examine several ideas related to the architecture”cloud versus on premises, picking toolsets and distribution, and how to plan for growth and change in the stack.

Speaker Info:

Joey D’Antoni is an Architect with over a decade of experience working in both Fortune 500 and smaller firms. He is currently solutions architect for SQL Server and Big Data for Anexinet in Blue Bell, PA. He holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University. He is a frequent speaker at events such as PASS Summit and TechEd.

Register

By |December 4th, 2013|Uncategorized|

PASS SQL Saturday Events : December 2013

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register (registration links are provided for each event). Please register soon as seating is limited, and let friends and colleagues know about the event. Most events are free, however a nominal fee may be charged so that lunch may be provided (not pizza). Note that all event times are relative to venue location.

Kharkov, Ukraine | #259

Date: Saturday, December 7th, 2013

Time: 9:00 am – 6:30 pm

Cost: Free

Event Details >> Register >> Schedule

Lima, Perú | #266

Date: Saturday, December 7th, 2013

Time: 9:00 am – 5:00 pm

Cost: Free

Venue:
Microsoft Perú
Av. Victor Andres Belaunde #147
Piso 3, San Isidro, Lima, Lima 27, Peru

Event Details >> Register >> Schedule

Washington DC | #233

Date: Saturday, December 7th, 2013

Time: 8:00 am – 5:00 pm

Cost: Free + $10 lunch

Venue:
Microsoft MTC
5404 Wisconsin Ave, Chevy Chase, MD, 20815

Event Details >> Register >> Schedule

Italy, ANCONA | #264

Date: Saturday, December 13th, 2013

Time: 9:00 am – 6:00 pm

Cost: Free

Venue:
Università Politecnica delle Marche
Via Pietro Valenti 65, Alt. entrance: Via Brecce Bianche 1,
Ancona, 60020, Italy

Event Details >> Register >> Schedule

Slovenia | #274

Date: Saturday, December 21st, 2013

Time: 9:00 am – 4:30 pm

Cost: Free

Venue:
Pixi Labs
Poslovna cona A 2, Sencur – Ljubljana
SI-4208, Slovenia

Event Details >> Register >> Schedule

By |December 4th, 2013|Uncategorized|

Colorado SQL Events : December 2013

Colorado Springs SQL

Date: Wednesday, December 18th

Time: 5:30 – ?

Main Presentation: Holiday Party – Family Welcome!

Meeting Location
Old Chicago (Austin Bluffs and Academy)
4110 North Academy Boulevard
Colorado Springs, CO

View Larger Map

BoulderSQL

Date: Tuesday, December 10th

Main Presentation: Holiday Networking & Social

Time: 5:30 pm – 8:00 pm

Appetizers and the first round of drinks will be provided! This will be a great opportunity to hob nob with other SQL savvy professionals from the area. Hope you can make it!

Meeting Location
Dave & Buster’s
10667 Westminster Blvd
Westminster, CO 80020
http://www.daveandbusters.com
phone: 303-438-1500

View Larger Map

By |December 4th, 2013|Uncategorized|

Colorado SQL Events : November 2013

All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend so bring a co-worker¦or two. These events provide for great learning opportunities, as well as networking with other local SQL Server professionals.

Northern Colorado SQL Server User Group Meeting

Date: Monday, November 18th

Time: 5:30 – 8:30 pm

Main Presentation: TBA

Presenter: TBA

Meeting Location
UNC Loveland Center at Centerra
2915 Rocky Mountain Ave.
Loveland, CO 80538
Breckenridge Conference Room 2nd Floor

View Larger Map

Colorado Springs SQL

Date: Wednesday, November 20th

Time: 5:30 – 8:00 pm

Main Presentation: TBA

Presenter: TBA

Meeting Location
Hyatt Place – Colorado Springs
503 Garden of the Gods Rd W,
Colorado Springs, CO

View Larger Map

BoulderSQL

Date: Tuesday, November 19th

Main Presentation: Ready, Set, Build a Cube:

Are you ready to do something different? Are you stuck in a rut? Let’s get out of that rut and find out what else we can do with the data we have in from of us. Let’s take the data and help others make better decisions. We have all had to learn something new. Let see what it takes to get data from an OLTP database to a cube..

Presenter: Tom Norman

In 1998, Tom changed his career focus to begin working with Sql Server. He has worked in all aspects of Sql Server including Administration, Database Development, BI and Reporting Services. He has worked in the Finance and Car Dealership industry. His experience has included International deployments. Tom is the co-leader of the PASS Virtualization chapter and the past President of the Denver Sql Server User Group.

Meeting Agenda
5:30 6:00 Food / Socializing
6:00 6:15 User Group Business
6:15 6:45 First Presentation
6:45 8:00 Main presentation
8:00 8:30 Questions/Answers, general SQL discussions

Meeting Location
Confio Software in Boulder
4772 Walnut Street
Suite 100
Boulder, CO 80301

View Larger Map

DenverSQL
The Denver SQL Server User Group is organized to bring professionals of all career levels that work with Microsoft’s SQL Server, together to learn and network with others. There is no charge to attend, and you are encouraged to bring guests. Food and refreshments are provided by event sponsors.

Date: Thursday, November 21st

Time: 5:30 – 8:00 pm

Main Presentation: Write Once, Build Many – Metadata Driven SSIS with Biml

Biml is gaining traction as a viable method for programming SSIS. In this demo rich presentation you will be introduced to Biml and see the basics of using Biml to develop SSIS packages. We will also dive into examples of how you can leverage the power of Biml to create many packages from a single Biml script using a Metadata approach to your development.
Presenter: Write Once, Build Many – Metadata Driven SSIS with Biml

Andy Vold, a SQL Server MCTS and MCITP, is an Architect with RevGen Partners working primarily in business intelligence, SSIS/ETL, and database development. He enjoys helping clients by building database and business intelligence solutions to solve their complex business needs. Andy is a past board member of the Denver SQL Server Users Group.

Meeting Location
Microsoft
7595 Technology Way, Suite 400
Denver, CO 80237

View Larger Map

By |November 18th, 2013|Uncategorized|

PASS SQL Saturday Events : November 2013

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register (registration links are provided for each event). Please register soon as seating is limited, and let friends and colleagues know about the event. Most events are free, however a nominal fee may be charged so that lunch may be provided (not pizza). Note that all event times are relative to venue location.

Verona, Italy | #257

Date: Saturday, November 9th, 2013

Time: 9:00 am – 6:00 pm

Cost: Free

Venue:
Strada le Grazie 15
Verona, 37134
Italy

Event Details >> Register >> Schedule

Manila | #263

Date: Saturday, November 9th, 2013

Time: 8:30 am – 5:00 pm

Cost: Free

Venue:
Microsoft Philippines
8th Floor 6750 Ayala Tower
Makati City, 1200, Philippines

Event Details >> Register >> Schedule

Tampa BI | #248

Date: Saturday, November 9th, 2013

Time: 7:00 am – 5:30 pm

Cost: Free

Venue:
University of South Florida (USF),
College of Business Bldg.
4202 E Fowler Ave.
Tampa, FL, 33620

Event Details >> Register >> Schedule

Oregon | #265

Date: Saturday, November 16th, 2013

Time: 8:30 am – 6:30 pm (Local Time)

Cost: Free

Venue:
Mittleman Community Center
6651 SW Capitol Highway
Portland, OR, 97219

Event Details >> Register >> Schedule

Moscow | #261

Date: Saturday, November 30th, 2013

Time: 9:00 am – 6:30 pm

Cost: Free

Venue:
Krylatskaya st. 17, building 1
Moscow, Russian Federation

Event Details >> Register >> Schedule

By |November 2nd, 2013|Uncategorized|

PASS Virtual Chapter Events : November 2013

Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources including an archive of past presentations, and special training events.

DBA Fundamentals – Virtual Chapters

Date: Tuesday, November 5, 2013

Time: 10:00 am – 11:00 am (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Statistics Starters

Have you been updating statistics as part of your maintenance plan, even though you’re not really sure what they are? Have you been asking yourself where statistics exist, how to find them, and what people mean when they say check statistics? Do you look at the database options for statistics and wonder if they really matter? It’s time to end the guessing and start understanding the basics about statistics. In this session I’ll answer these questions using straight-forward demos and real-world examples. And if you haven’t been updating statistics as part of your maintenance plan don’t worry, I’ll get you started.

Speaker Info:

Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 12 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

There will be a drawing for a $100 Amazon gift card at the end of the meeting. A winner will be randomly chosen from all those in attendance for the whole webcast who provide their email address.

Register

Big Data Virtual Chapter – Virtual Chapters

Date: Tuesday, November 5, 2013

Time: 12:00 pm – 1:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Table Partitioning: Secret Weapon for Big Data Pro

Big Data starting to slow you down? Data growth putting your maintenance tasks in danger of not meeting your SLAs? Wish you could archive old data with minimal impact to your tables during the archive process or that you could eliminate most of the data in your tables when you query them? If so, it’s time you consider implementing table partitioning to help with general performance and reduce your window for completing maintenance tasks. Come learn how table partitioning works and when it should be implemented. You’ll see how to initially configure partition functions and partition schemes to have a rock-solid partitioned table. And you’ll learn how to implement an automated sliding window to maintain your partitioned tables and ensure optimal performance.

Speaker Info:

John Sterrett is a database administration senior advisor for Dell, directly responsible for several mission-critical databases. Previously, he was a senior DBA focused primarily on performance tuning at a Remote DBA service company with over 200 SQL Server clients. He has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturday, and local PASS Chapter and Virtual Chapter meetings. He is a PASS Regional Mentor for the South Central US region, co-founded the West Virginia SQL Server User Group, and hosted the first and second SQLSaturday in West Virginia. He is a syndicated blogger at SQLServerPedia and SQLServerCentral.com and a writer for MSSQLTips.com.

Event Details >> Attend

Business Analytics – Virtual Chapters

Date: Thursday, November 7, 2013

Time: 10:00 am – 11:30 am (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Power BI Info Management and Data Stewardship

Business intelligence tools continue to improve, letting users shorten their time to insight and take that insight to more devices in more places. But this evolution of BI doesn’t change one fundamental fact of information management: You can’t gain insight from data you can’t access. In this session, Matthew Roche and Ofer Ashkenazi will introduce the role of the data steward and the self-service information management capabilities included in Power Query and Power BI for Office 365, focusing on how Power BI empowers business users to add value to the organization.

Speaker Info:

Matthew Roche is a Senior Program Manager on the SQL Server product team, working on Self-Service Information Management (SSIM) in Power BI, and who has worked on the SQL Server Enterprise Information Management (EIM) platform including SQL Server Integration Services (SSIS), Master Data Services (MDS) and Data Quality Services (DQS). Before joining Microsoft in 2008, Matthew was a business intelligence consultant and trainer and a Microsoft SQL Server MVP. In addition to implementing small- and large-scale BI solutions with SQL Server, Matthew has presented on SQL topics at major technical conferences, code camps, and user groups across the US and in Europe. Ofer Ashkenazi is a Senior Product Planner with the Data Platform Group (Information Services). His focus is on Power BI, in particular Power Query, the Data Catalogue, and the Data Stewardship Experience in Power BI. Before this role, Ofer was the planner for SQL Azure and other cloud data services, including the Azure Data Marketplace. He was also the product planner and senior technical product manager with the Enterprise Application Platform Marketing team at Microsoft. Ofer’s roles include planning for new services releases, briefing market analysts, and presenting at conferences. Before joining Microsoft, Ofer served as a Microsoft Regional Director, BizTalk Server. At the same time, he managed a BizTalk Server consulting, training, and professional services business for a Microsoft partner.

Attend

Business Intelligence – Virtual Chapters

Date: Thursday, November 7, 2013

Time: 2:00 pm – 3:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: The Accidental Business Intelligence Project Manager

You’ve watched the Apprentice with Donald Trump and Lord Alan Sugar. You know that the Project Manager is usually the one gets fired. You’ve heard that Business Intelligence projects are prone to failure. You know that a quick Bing search for why do Business Intelligence projects fail?’ produces a search result of 25 million hits! Despite all this¦ you’re now Business Intelligence Project Manager now what do you do? In this session, Jen will provide a sparks from the anvil’ series of steps and working practices in Business Intelligence Project Management. What about waterfall vs agile? What is a Gantt chart anyway? Jen will give you some ideas and insights that will help you set your BI project right: assess priorities, avoid conflict, empower the BI team and deliver the Business Intelligence project successfully!

Speaker Info:

Jen Stirrup, a SQL Server MVP and PASS Director-At-Large (Elect), is best-known for her work in business intelligence & data visualization. She runs Copper Blue Consulting, delivering business-critical solutions that add enterprise value. Jen has presented at TechEd North America, TechEd Europe, PASS Summit, and SQLBIts, as well as at SQLSaturday events in Europe. She won PASS’s prestigious Passion Award, presented at Summit 2012, for her work in supporting the SQL Server community in Europe.

Register

Virtualization – Virtual Chapters

Date: Wednesday, November 13, 2013

Time: 10:00 am – 11:00 am (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Testing and Benchmarking SQL Server Consolidation

Whether you are consolidating SQL Server on a hypervisor or bare-metal, proper testing and benchmarking of SQL workloads is critical. This session will introduce you to testing methodologies for the most commonly consolidated SQL Server workloads. CPU and memory configurations will be discussed as well.

Speaker Info:

Andrew: Frank Cicalese is a Technical Solutions Architect with Cisco Systems, Inc., assisting customers with their design of SQL Server solutions on Cisco Unified Compute System. Before joining Cisco, Frank worked at Microsoft Corporation for 10 years, excelling in several positions, including as Database TSP. Frank has in-depth technical knowledge and proficiency with database design, optimization, replication, and clustering and has extensive virtualization, identity and access management and application development skills. He has established himself as an architect who can tie core infrastructure, collaboration, and application development platform solutions together in a way that drives understanding and business value for the companies he services.

Event Details

Book Readers – Virtual Chapters

Date: Wednesday, November 20, 2013

Time: 1:00 pm – 2:00 pm (Mountain Time)

Cost: Free

Language: English

Featured Presentation: Delivering Business Intelligence 5th Meeting

Speaker Info:

Ike Ellis SQL, Business Intelligence, and Data Consultant. He’s been a SQL Server MVP since 2010. He has 17 years of experience writing software and working with SQL Server. He’s the principal SQL course author and instructor for DevelopMentor. His twitter handle is@ike_ellis. Find more information at www.ikeellis.com

Brad Cunningham C# MVP since 2008. He’s always on the cutting edge of software development, writing for the new web, mobile, and enterprise solutions. His code has been featured all over the Internet, on numerous pod casts and user groups. You can find him on twitter as @foovanadil.

Rob Sullivan Bona fide Alpha Nerd, SQL Server DBA by day and code slinger by night. He is the SQL Dude for Tekpub, open source contributor to .NET Micro ORMS, speaker and can occasionally be found on This Developers Life. In his free time, he frequents various user groups in Oklahoma City or pretty much anywhere that has pizza.

Scott Reed An Azure MVP since 2011. Scott’s career in software began in 1993 at IBM. Along the way, he has developed enterprise solutions for both Microsoft and Cardinal Health. Scott is a generalist, his interests ranging from data access technologies and multithreading to communications and UI technologies. Scott holds a BS in Computer Science and math from Virginia Tech.

Event Details

By |November 1st, 2013|Uncategorized|