Nr: 946
SQLSaturday #946 - South Florida - BI Edition 2020
| Start Time (24h) |
Speaker |
Track |
Title |
| 08:15:00 |
SQL Saturday South Florida |
Panel of Discussion |
Keynote - Women in Technology Panel |
| 09:30:00 |
Ed Watson |
Power BI |
The Psychology of Better Power BI Reporting |
| 09:30:00 |
Diana Betancourt |
LATAM ( BI topics in Spanish) |
Design your Power BI with inclusive intelligence |
| 09:30:00 |
Matt Cushing |
Networking |
Networking 101: Getting Ready for a SQL Event |
| 09:30:00 |
Warner Chaves |
BI Platform Architecture, Development Administration |
Architecting a Modern Business Intelligence Data Platform |
| 09:30:00 |
Priscilla Camp |
Power BI |
Are you a Power BI Newbie? |
| 09:30:00 |
SQL Saturday South Florida |
LATAM ( BI topics in Spanish) |
Session in Spanish Coming soon [reserved slot] |
| 10:35:00 |
Katie Schmidt |
Power BI |
DAX for Beginners - Learn the basics for Power BI |
| 10:35:00 |
Mariano Kovo |
LATAM ( BI topics in Spanish) |
Designing BI Architectures in the world of Azure |
| 10:35:00 |
Barkha Herman |
Artificial Intelligence |
An Intro to Databricks |
| 10:35:00 |
Armando Lacerda |
BI Platform Architecture, Development Administration |
Azure SQL DB Hyperscale, the game has changed. |
| 11:40:00 |
Julie Smith |
Power BI |
Using Python In Power BI |
| 11:40:00 |
Darius Liktorius |
BI Platform Architecture, Development Administration |
Azure Data Factory for Beginners |
| 11:40:00 |
oscar garcia |
LATAM ( BI topics in Spanish) |
Build a Modern Data Warehouse with Apache Spark and SQL Server |
| 11:40:00 |
Jessica Jolly |
Power BI |
What is the Power Query Editor? |
| 12:45:00 |
Herve Roggero |
BI Platform Architecture, Development Administration |
How to build a Virtual Data Warehouse with SQL Server |
| 14:00:00 |
Oscar Zamora |
BI Platform Architecture, Development Administration |
BI against Azure Synapse Analytics or Azure Analysis Services. What architecture to be considered? |
| 14:00:00 |
Kelly Tabler |
Power BI |
Data and DevOps: Joining the CI/CD Fun |
| 14:00:00 |
Tim Radney |
Networking |
Getting Involved and Getting Ahead |
| 14:00:00 |
Hilary Wilkie |
Power BI |
User Experience Brilliance in Power BI Dashboards |
| 14:00:00 |
Gilda Alvarez |
LATAM ( BI topics in Spanish) |
Surviving the digital transformation |
| 15:00:00 |
Hector Villafuerte |
Artificial Intelligence |
Automated Machine Learning (AutoML) in Power BI |
| 15:00:00 |
SQL Saturday South Florida |
Networking |
Networking Clinic |
| 15:00:00 |
Mahesh Caroicar |
LATAM ( BI topics in Spanish) |
Power BI creating reports with Visio diagrams and Cognitive Servi |
| 15:00:00 |
Cecilia Brusatori |
Power BI |
Level-up your Power BI Reports |
| 15:00:00 |
Aaron Cutshall |
BI Platform Architecture, Development Administration |
"There Be Whales Here!" -- Big Data in SQL Server |
| 16:00:00 |
Kevin Feasel |
BI Platform Architecture, Development Administration |
Data Virtualization with PolyBase |
| 16:00:00 |
Patricia Monica Ojeda |
Networking |
Dare to change, the path of a peak performance professional |
| 16:00:00 |
Candace Thompson |
BI Platform Architecture, Development Administration |
An introduction to utilizing SSIS for Business Intelligence |
| 16:00:00 |
Audrey Hammonds |
Artificial Intelligence |
Pattern Recognition: Unlock Data’s Potential using Azure Cognitiv |
| 16:00:00 |
Armando Lacerda |
Power BI |
Power BI Dataset Tuning |
SessionID: 102279
Keynote - Women in Technology Panel
Event Date: 22-02-2020 - Session time: 08:15:00 - Track: Panel of Discussion
Speaker: SQL Saturday South Florida
Title: Keynote - Women in Technology Panel
Abstract:
Come and join us for the keynote and Women in Technology Panel
"The art of creating Allies to grow your career"
Panelists:
Barkha Herman
Diana Betancourt
Gilda Alvarez
Dave Noderer
Moderator:
Cecilia Brusatori
SessionID: 100571
The Psychology of Better Power BI Reporting
Event Date: 22-02-2020 - Session time: 09:30:00 - Track: Power BI
Speaker: Ed Watson
Title: The Psychology of Better Power BI Reporting
Abstract:
In this course we identify some common mistakes that we see in the business world using Power BI. We will identify the psychology behind the reporting techniques needed to create powerful and effective reports. The attendee will leave the class ready to write better reports using Power BI in the real world.
SessionID: 100966
Design your Power BI with inclusive intelligence
Event Date: 22-02-2020 - Session time: 09:30:00 - Track: LATAM ( BI topics in Spanish)
Speaker: Diana Betancourt
Title: Design your Power BI with inclusive intelligence
Abstract:
Your Power BI looks awesome! but have you thought if it is accessible enough for people with disabilities? Or better yet for people with visual impairments?
Do you know what tools do you have available to make your app. ADA ready?
Let's work together on a hands-on journey to learn the statistics that affect our customers and to walk away with real tools to make our apps Intelligent ready for ALL!
SessionID: 100977
Networking 101: Getting Ready for a SQL Event
Event Date: 22-02-2020 - Session time: 09:30:00 - Track: Networking
Speaker: Matt Cushing
Title: Networking 101: Getting Ready for a SQL Event
Abstract:
Looking to get the most out of your SQL Saturday, PASS Summit, or local user group meeting? Plan ahead! Events aren't just about learning new things, they're about meeting new people, networking with peers, and learning different approaches to common issues.
In this session, we'll go over steps you can take before, during and after the event to maximize the amount of great stuff you'll take away at the end (besides cool vendor swag). Not just keeping up on new technologies, but meeting new people, getting leads on solutions/opportunities, and an appreciation for the community you're in and what it has to offer.
SessionID: 101255
Event Date: 22-02-2020 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Warner Chaves
Abstract:
The power of cloud storage and compute power has made data warehousing and big data possible for businesses of all sizes. What was once a large capital expenditure and multi-year implementation can now be deployed and ready to use within minutes and allow any organization to collect, query and discover insights from their structured and unstructured data sources.
With tightly integrated services and a user-centric approach, a cloud-native data platform can fit transparently into your business data strategy and leverage already existing and familiar development and management skills.
In this session we will look at the main components and reference architectures for building a modern business intelligence platform that includes data warehousing, big data and analytics with examples using Microsoft Azure. We will talk about ways to integrate with on-premises systems as well as lessons learned from building these Enterprise BI Data Platforms for multiple clients.
SessionID: 101277
Are you a Power BI Newbie?
Event Date: 22-02-2020 - Session time: 09:30:00 - Track: Power BI
Speaker: Priscilla Camp
Title: Are you a Power BI Newbie?
Abstract:
Want to learn Power BI, and not sure where to start? This session will teach you all the basics you need to know to get started. We will discuss some of the parts of Power BI Desktop such as Power Query, Data Model, and the Report Canvas. I will also teach you where to go to follow the latest updates, and give you a few recommended books and websites to get to the next level.
SessionID: 101673
Session in Spanish Coming soon [reserved slot]
Event Date: 22-02-2020 - Session time: 09:30:00 - Track: LATAM ( BI topics in Spanish)
Speaker: SQL Saturday South Florida
Title: Session in Spanish Coming soon [reserved slot]
Abstract:
Session in Spanish Coming soon [reserved slot]
SessionID: 100437
DAX for Beginners - Learn the basics for Power BI
Event Date: 22-02-2020 - Session time: 10:35:00 - Track: Power BI
Speaker: Katie Schmidt
Title: DAX for Beginners - Learn the basics for Power BI
Abstract:
If you want to use PowerBI, you'll want to learn the DAX language. We will go over what, when and how to use it along with where to get help! If you are an excel person, this might be an easy shift. If you are not, then you will definitely want to understand this language if you or your teams are using PowerBI.
SessionID: 100970
Designing BI Architectures in the world of Azure
Event Date: 22-02-2020 - Session time: 10:35:00 - Track: LATAM ( BI topics in Spanish)
Speaker: Mariano Kovo
Title: Designing BI Architectures in the world of Azure
Abstract:
So many options can be overwhelming and there is no single solution that can be applied to every requirement. In this session, we will cover the different options available in Azure to deploy Data Platform components, without leaving the performance, costs, and migration complexity aspects.
SessionID: 101120
An Intro to Databricks
Event Date: 22-02-2020 - Session time: 10:35:00 - Track: Artificial Intelligence
Speaker: Barkha Herman
Title: An Intro to Databricks
Abstract:
Unlock insights from all your data and build artificial intelligence (AI) solutions with Azure Databricks, set up your Apache Spark™ environment in minutes, autoscale, and collaborate on shared projects in an interactive workspace. Azure Databricks supports Python, Scala, R, Java, and SQL, as well as data science frameworks and libraries including TensorFlow, PyTorch, and scikit-learn.
SessionID: 99951
Azure SQL DB Hyperscale, the game has changed.
Event Date: 22-02-2020 - Session time: 10:35:00 - Track: BI Platform Architecture, Development Administration
Speaker: Armando Lacerda
Title: Azure SQL DB Hyperscale, the game has changed.
Abstract:
There is a new Azure SQL DB option: Hyperscale. It introduces a redesigned architecture under the hood not comparable to the other SQL DB PaaS options.
In this session you will learn and see how it works and the best scenarios where it fits in. And how it blends in a cloud based BI solution arctecture.
SessionID: 100710
Using Python In Power BI
Event Date: 22-02-2020 - Session time: 11:40:00 - Track: Power BI
Speaker: Julie Smith
Title: Using Python In Power BI
Abstract:
Python is a powerful general purpose programming language that has emerged as one of the main tools of data scientists. Python was added to Power BI in June of 2018. This session will demonstrate the three points of entry for python inside the Power BI desktop-- how to leverage python scripts inside the Power BI query editor and how to use python visuals in Power BI reports.
SessionID: 101205
Azure Data Factory for Beginners
Event Date: 22-02-2020 - Session time: 11:40:00 - Track: BI Platform Architecture, Development Administration
Speaker: Darius Liktorius
Title: Azure Data Factory for Beginners
Abstract:
Whether you have worked with SSIS or are new to data pipelines, come and learn about Azure Data Factory (ADF), what it is, how to deploy it, integrate with Git for source control, create and monitor data pipelines.
SessionID: 101507
Build a Modern Data Warehouse with Apache Spark and SQL Server
Event Date: 22-02-2020 - Session time: 11:40:00 - Track: LATAM ( BI topics in Spanish)
Speaker: oscar garcia
Title: Build a Modern Data Warehouse with Apache Spark and SQL Server
Abstract:
Learning Objectives:
Challenges when using disparate data sources (different models)
Define a common model to support the different model shapes (Star Schema)
Apache Spark Overview
Strategy for loading the different data-sets into the common model
Data analysis and visualization with Power BI
SessionID: 99912
What is the Power Query Editor?
Event Date: 22-02-2020 - Session time: 11:40:00 - Track: Power BI
Speaker: Jessica Jolly
Title: What is the Power Query Editor?
Abstract:
How often do you get data that is perfectly tailored and ready to use in a Power BI report?
Less often than you could hope. There is a rule of thumb that says 80% of the work required to
create a report (or a dashboard) involves cleaning and prepping the data. This is accentuated
when you consider that 90% of the time, if you are having a problem with a visual in a report,
it is because something is awry in the data model. In other words, it all starts with clean, well prepared data. This is why you need to become familiar with the Power Query Editor.
In this session, we will cover:
--What is the Power Query Editor?
--How do you access it?
--What does it do that nothing else does?
--When would you use it?
--How hard is it to use?
--A quick demo of PQE's capabilities
SessionID: 101667
How to build a Virtual Data Warehouse with SQL Server
Event Date: 22-02-2020 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Herve Roggero
Title: How to build a Virtual Data Warehouse with SQL Server
Abstract:
In this talk we will discuss the principles of a virtual data warehouse, how you can reduce or eliminate ETL jobs, and how to combine the power of SQL Server and Enzo to build a data warehouse that can deliver near-time and real-time SaaS data to PowerBI, data integration, AI integration, and more.
SessionID: 100085
BI against Azure Synapse Analytics or Azure Analysis Services. What architecture to be considered?
Event Date: 22-02-2020 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Oscar Zamora
Title: BI against Azure Synapse Analytics or Azure Analysis Services. What architecture to be considered?
Abstract:
Azure Analysis Services at times is collocated with Azure Synapse Analytics as Business Intelligence back-end layer. This session will help the audience determine what architecture should be chosen for a given enterprise requirement. Session will also provide features and advantages from each PaaS offering.
SessionID: 100900
Data and DevOps: Joining the CI/CD Fun
Event Date: 22-02-2020 - Session time: 14:00:00 - Track: Power BI
Speaker: Kelly Tabler
Title: Data and DevOps: Joining the CI/CD Fun
Abstract:
For too long, data developers have been left in the dark on the power of DevOps. From creating entire new environments with infrastructure and configuration as code to maintaining consistency on existing systems with source control and automated builds and deployments, DevOps tools are as accessible to data platforms as to application developers. In this session, we will focus on the benefits and concepts of continuous integration and continuous delivery with PowerBI. Using AzureDevOps, we will deal with maintaining reports in source control, triggering automated builds, and publishing to multiple environments.
SessionID: 101175
Getting Involved and Getting Ahead
Event Date: 22-02-2020 - Session time: 14:00:00 - Track: Networking
Speaker: Tim Radney
Title: Getting Involved and Getting Ahead
Abstract:
SessionID: 99806
User Experience Brilliance in Power BI Dashboards
Event Date: 22-02-2020 - Session time: 14:00:00 - Track: Power BI
Speaker: Hilary Wilkie
Title: User Experience Brilliance in Power BI Dashboards
Abstract:
User Experience (UX) and Design Thinking are common buzz words around the office. What do these words have to do with BI and Dashboards, anyway?
Sure, Power BI itself is intuitive and user friendly, but are YOU building dashboards that people will actually use. If you want to get the business off of their beloved excel and onto your dashboards, this is how you will do it.
In this session, we will explore how to start using UX and the psychology behind it to empower you with intel that will make YOUR dashboards Kick Booty! We will show examples and arm with the tools/strategies to make the best dashboards your business has ever used.
SessionID: 99924
Event Date: 22-02-2020 - Session time: 14:00:00 - Track: LATAM ( BI topics in Spanish)
Speaker: Gilda Alvarez
Abstract:
Technology is moving faster than we can grasp but we must continue to grow our careers and skills. Join me to unravel the emerging technologies and how we can bulletproof our careers and adapt to these changes.
SessionID: 100084
Automated Machine Learning (AutoML) in Power BI
Event Date: 22-02-2020 - Session time: 15:00:00 - Track: Artificial Intelligence
Speaker: Hector Villafuerte
Title: Automated Machine Learning (AutoML) in Power BI
Abstract:
AutoML was proposed as an artificial intelligence-based solution to the ever-growing challenge of applying machine learning. Business analysts can build Machine Learning models to solve business problems that once required data scientists. In this session, Hector will explain the principles of Machine Learning and AutoML (Automated machine learning) and he will demo AutoML PowerBI features end-to-end and show How to interpret and extract the optimum results based on specific business problems.
SessionID: 101276
Networking Clinic
Event Date: 22-02-2020 - Session time: 15:00:00 - Track: Networking
Speaker: SQL Saturday South Florida
Title: Networking Clinic
Abstract:
Networking is key for your professional career!
You would like to meet people but don't know how?
Are you an introvert?
You go to events and not sure how to break the ice?
If you answered yes to at least one of the questions above, don't worry, you're not alone!
Join the networking clinic, we will have activities and discussions to help
SessionID: 101354
Power BI creating reports with Visio diagrams and Cognitive Servi
Event Date: 22-02-2020 - Session time: 15:00:00 - Track: LATAM ( BI topics in Spanish)
Speaker: Mahesh Caroicar
Title: Power BI creating reports with Visio diagrams and Cognitive Servi
Abstract:
This presentation main goal is to show the connectivity of Power BI and Microsoft Visio to create reports that can generate valuable Insights for a company. Along with that I will show through Azure SQL Data and Azure Cognitive Services how to create a Sentiment Analysis Report
SessionID: 99906
Level-up your Power BI Reports
Event Date: 22-02-2020 - Session time: 15:00:00 - Track: Power BI
Speaker: Cecilia Brusatori
Title: Level-up your Power BI Reports
Abstract:
You've been working with Power BI, building fantastic reports and dashboards. Let's take a look at some of the cool features that will help you make your reports more appealing and add more functionalities.
This session is 100% demos: shortcuts, visuals interactions, drilling down/up/through data , custom tooltips, buttons bookmarks.
SessionID: 99926
"There Be Whales Here!" -- Big Data in SQL Server
Event Date: 22-02-2020 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Aaron Cutshall
Title: "There Be Whales Here!" -- Big Data in SQL Server
Abstract:
SessionID: 100649
Data Virtualization with PolyBase
Event Date: 22-02-2020 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Kevin Feasel
Title: Data Virtualization with PolyBase
Abstract:
PolyBase is Microsoft's data virtualization technology, allowing you to integrate SQL Server with external systems such as Hadoop and Azure Blob Storage. As of SQL Server 2019, PolyBase also allows you to connect to diverse systems such as Oracle, MongoDB, Cosmos DB, Teradata, Apache Spark, and even other SQL Server instances. In this talk, we will walk through the mechanics of PolyBase, showing how we can write T-SQL queries to access data from heterogeneous sources. We will investigate the Dynamic Management Views (DMVs) and other resources needed to tease out what the PolyBase engine is doing behind the scenes and where to go when things break down. Finally, we will look at several interesting use cases for PolyBase in the modern data environment.
SessionID: 101419
Event Date: 22-02-2020 - Session time: 16:00:00 - Track: Networking
Speaker: Patricia Monica Ojeda
Abstract:
For centuries the humans have been looking for the way to improve their bodies, mental capacity, and the ways to acquiring knowledge and techniques to improve their personal and professional lives.
In other words, a different outlook of the concept of wellbeing and perform better on whatever is the activity their doing.
During this session you will discover, thru the assessment of the peak performance, your status and preparedness to change and the tools available to make quick changes and tweaks, like techniques for speed reading, biohacking, how to be mindful instead of mindfull, how to achieve a flow state, and much more.
SessionID: 101420
An introduction to utilizing SSIS for Business Intelligence
Event Date: 22-02-2020 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Candace Thompson
Title: An introduction to utilizing SSIS for Business Intelligence
Abstract:
Want to learn how to create an SSIS package? With no prior experience we will dive into the world of ETL. How to create a package and build the intelligence based on your business needs.
Join me to this introductory class.
SessionID: 101438
Pattern Recognition: Unlock Data’s Potential using Azure Cognitiv
Event Date: 22-02-2020 - Session time: 16:00:00 - Track: Artificial Intelligence
Speaker: Audrey Hammonds
Title: Pattern Recognition: Unlock Data’s Potential using Azure Cognitiv
Abstract:
Every day, 2.5 quintillion bytes of data is produced, and 80% of it is unstructured. Go beyond reports and dashboards by leveraging new data sources, infusing AI into your applications, and harnessing cognitive capabilities to streamline every day tasks within your organization. In this demo-heavy session, we’ll walk through what Azure Cognitive Services are, use cases, and real-world scenarios. You do not have to be a data scientist to take advantage of AI!
SessionID: 99952
Power BI Dataset Tuning
Event Date: 22-02-2020 - Session time: 16:00:00 - Track: Power BI
Speaker: Armando Lacerda
Title: Power BI Dataset Tuning
Abstract: