- Power BI Dataset Tuning Tips
Join us on July 10th to learn how to develop effective models for large datasets. According to Power BI expert Armando Lacerda, it's better to get your models right from the start, and essential if you're working with large datasets. You'll learn: * Best practices for Power BI model design * How to measure the performance of your datasets * About how to avoid common model design errors Most Power BI reports use small datasets. And due to today’s lighting fast data engines, most data model mistakes are masked. But when datasets get larger, performance of reports with poorly designed data models start to lag. At some point, the models need to be fixed, and the reports updated accordingly. The Power BI data engine is not relational and therefore most data modeling techniques either don’t apply or don’t deliver. Armando will go over how to develop models and measure performance when larger Power BI datasets are involved.
- Bay Area Microsoft DataFest 2019: Advanced Analytics & Big Data Conference
Please join us for the Bay Area Microsoft DataFest 2019. This is a community event featuring Big Data, IOT and AI & ML Services on Azure. You'll learn about architecting and solidifying your Data Platform and AI strategy. This is an exciting opportunity to meet, align strategies, and plan outcomes with Senior Data Leads/Managers, Executives, Data Scientist, Data Engineers, Analysts, Developers, and Data Evangelists. Time: 9:30 am - 5:30 pm Happy Hour: 5:30 - 7:30 pm Cost $25 Register on Eventbrite here: https://www.eventbrite.com/e/bay-area-datafest-2019-advanced-analytics-big-data-conference-tickets-55909167826 You'll learn about: * The latest Microsoft Big Data/ML Latest Tools and Technologies * A Unified data platform using SQL Server 2019 (with Apache Spark and Hadoop Distributed File System (HDFS) for intelligence over all your data.) * Azure IOT, BOTS and Cognitive Services in action * Cutting Edge AL/ML research presented by the Microsoft Research Team * How to plan an End to End Data Strategy, Vision, and Architecture design
- Azure SQL Server Flavors, Which One Is Right For My Scenario?
Choosing the right Azure SQL Server offering can be daunting. With over 50 individual deployment options it is not uncommon to see DBAs migrating to Azure getting dizzy. In this session, BI expert and Microsoft Data Platform MVP Armando Lacerda will explain the basis of each offering and when to apply them. You'll see demos that show how and why. You'll learn • The SQL Server offerings available on Azure • What is different about each offering • What requirements will drive your selection • Pros and Cons of the different Azure SQL Server offerings Armando welcomes you to bring some scenarios and questions to the meeting. He'll give you advice based on his hands-on experience. Armando Lacerda is an Azure, Data Platform and BI Architect.
- DAX Overview with Jeffrey Wang
Jeffrey Wang, one of the creators of DAX, will go over important DAX concepts, programming patterns, debugging techniques, and common user mistakes. He works with the Power BI product group in Redmond. DAX has been repeatedly voted by users as one of the most powerful features of Power BI and at the same time one of the more difficult areas to learn and master. Jeffrey will present demos using Power BI Desktop to illustrate the various DAX patterns covered in the presentation. He is also available to answer any of your Power BI questions. You'll Learn: * The most important DAX and modeling concepts and how to apply them to solve your daily analytics and reporting challenges * Answers to the most common DAX puzzles that baffle users * How to avoid common mistakes made by other DAX users * The best DAX patterns to solve common business problems * A deeper understanding of the big picture of data modeling and DAX programming Jeffrey Wang leads the development effort of the DAX engine that drives Power BI’s data modeling, interactive queries, user programming, DirectQuery, and composite modeling.
- Azure SQL Data Warehouse for SQL DBAs
Armando Lacerda will present the overall Azure SQL DW architecture. He'll compare SQL Server resources and their counterparts in Azure SQL DW, showing how they operate in distinct ways, helping you avoid some very common mistakes in Azure SQL DW when applying your SQL Server skills. Although Azure SQL Data Warehouse seems to be SQL Server on steroids, there are many important differences. Some are major and some are very subtle. It becomes confusing when the same vendor (Microsoft) uses the same brand name (SQL) and the same core engine (SQL Server) to offer very distinct products (Azure SQL DB and Azure SQL DW). This will be a demo packed 60-minute presentation on the cloud-based relational data warehouse PaaS offering from Microsoft. You'll learn about: * Azure SQL DW storage system and differences between Gen1 and Gen2 * The types of tables available in Azure SQL DB DW * Performance options, distribution, partition and index strategies, including column store * Cost budgeting
- Holiday Party 2018
Let's get together and celebrate the holidays! This is a combined event for members of the following tech meetups in the San Francisco Bay Area. The party is hosted by Microsoft. You MUST sign up on Eventbrite to attend! https://www.eventbrite.com/register?orderid=b00c039bf7f011e8825b12d022dba9e4&client_token=ece543fc3a054ba48990647bd2c424dd&eid=52889080664 1. San Francisco Azure Meetup 2. Bay.NET meetups, including San Francisco, Berkeley, and Mtn View 3. Microsoft Data Platform 4. San Francisco Power BI 5. Bay Area Microsoft BI 6. PAC IT Pros 7. F# meetup 8. Silicon Valley C# meetup There's a lot of overlap in these groups! Let's get together with old friends and make some new friends, too! We'll have food, beer, and sodas and will have a handful of lightning talks -- 10 minutes at most -- about various topics. If you want to volunteer to GIVE a lightning, talk, e-mail Robin Shahan at [masked]
- DBA vNext – What Does it Take to be a Cloud-Enabled Database Professional?
What does it take to be a well-rounded Azure cloud DBA? Not long ago, being a Microsoft DBA meant specializing in Microsoft SQL Server, along with all the bells and whistles. That was the on-prem age. Now in the cloud computing age, cloud providers support multiple database engines in order to welcome all applications to their infrastructure. SQL Server is not always the way to go for an application. You'll learn why it's vital to know Azure, where the main PaaS database engines offerings are SQL DB, PostgreSQL, MySQL, Redis Cach, and Cosmos DB. On top of that are the big data offerings. You'll learn: • What it takes to be a well-rounded Azure cloud DBA • Best application scenarios • Price and budgeting • Tuning Armando Lacerda is a senior BI professional at DesignMind.
- Intro to Data Modeling in Power BI with Marco Russo
Speaker: Marco Russo: Microsoft MVP, Consultant, and Author Marco Russo is an internationally known Microsoft MVP, Consultant & Mentor. He'll introduce the basic principles of data modeling for analytics. You'll learn what makes a model “right” or “wrong” and why spending the time to design the right data model will pay off when you begin coding. You'll learn: * How to properly structure a data model to simplify DAX code and improve performance * Practical examples of good and bad design * Common terms used in data modeling * How to apply these concepts to your data models Marco Russo is a business intelligence consultant and mentor. He has written several books about Power BI, Analysis Service, and Power Pivot. He also regularly writes articles and white papers that are available at https://www.sqlbi.com While Marco is in San Francisco, he is teaching a three-day Mastering DAX Workshop. Learn more at https://www.sqlbi.com/p/mastering-dax-workshop-san-francisco-october-2018/. Contact Mark Ginnebaugh for a discount code to save $450 for this workshop.
- Kevin Kline - Data Science with the Microsoft Data Platform
Whether you're getting started with Data science or a seasoned veteran, please join us to discuss Data science on the Microsoft Platform. We're fortunate to welcome Kevin Kline, a veteran Microsoft Data Platform MVP, author, former PASS president, and popular international speaker. Kevin will take us on a tour of Microsoft’s Team Data Science Process (TDSP). The TDSP is Microsoft’s systematic approach to building applications which empower data scientists to collaborate over the full life cycle of activities needed to turn these applications into full-fledged products. You'll learn about: * The Microsoft Team Data Science Process * The Cortana Intelligence Suite * Machine Learning in R * Data Exploration Analytics and Reporting (IDEAR) for interactive data exploration * Automated Modeling and Reporting tool for Machine Learning (ML) model Kevin Kline serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, Google Author, and long-time blogger at sqlblog.com and at kevinekline.com. As a noted leader in the IT industry, Kevin's blog covers Microsoft SQL Server features and best practices, third-party software, trends in the IT industry, and professional development for IT professionals. @kekline