- Monitoring Power BI
Monitoring Power BI means having knowledge of all the content currently hosted in your Power BI tenant. What datasets and reports have been published? What users have access to these resources? How often are they looking at these reports? How have data refreshes been performing? By monitoring, you will truly understand what makes you an Administrator of Power BI. You'll see the different screens it takes to monitor everything in your tenant. Plus, you'll discover if there's a better way to monitor your tenant through collecting API data and analyzing it to derive some actionable insights for improved data governance in your companies. BI expert Angel Abundez will demo the Power BI administrative screens you use today to monitor your tenant. Then he'll do some PowerShell development in VS Code to collect API data and see if it's possible to use that data in Power BI for added insights. You'll learn: * Power BI Administration screens * Minimum permissions needed to administer Power BI * Useful PowerShell modules to collect API data * Different use cases of discovery and cleanup Angel Abundez is VP, Solutions Architecture at DesignMind
- 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 followed by Happy Hour from 5:30 -7:30 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
- Using Power BI to Analyze SharePoint Forms and Workflow Data
Learn how to build an end-to-end Power BI solution that unlocks the value of your SharePoint forms and workflow data. Afterward, you'll gain unique business insights by drilling down into collected forms/workflow data; filter by workflow, types, users, roles, departments, etc., and get answers to your most important business questions. Most data collection and BI implementations require deep technical knowledge, coding, and coordination with IT. Veteran BI expert Alex Viera will demonstrate how to bypass the technical hurdles. Alex will demonstrate and then build a complete BI solution; starting with provisioning a SharePoint form and workflow for data collection. He will then show how to use Power BI (or any BI tool) to identify which forms/workflows yield the best business results, target those workflows that need improvement, and gain key business insight using PowerBI. You'll learn how to: * Build an end-to-end no-code BI solution with minimal IT involvement. * Provision your SharePoint forms and workflows for data collection * Log the time duration of a SharePoint Task, or specific stages in a workflow for reporting * Log workflow specific data (list item data, user context info, custom) at any step in a workflow. * Transform the logged data into insightful reports in Power BI, or any other OData capable reporting tool. Alex Viera is a Nintex Solutions Architect at PacificBPA.com
- Free OPEN Passes to DeveloperWeek 2019 - Feb 20-24
- Automating Power BI Creations
Since Power BI was released four years ago, Power BI, Office 365, and Azure have added significant automation capabilities. To stay informed, you need to learn about the most recent capabilities and what they mean to you. Angel Abundez will present a wide-ranging overview of the data refresh setups common to Power BI data sources, going from DIY to more advanced scenarios that need IT support. Whether you’re automating reports for your department or for the enterprise, there’s something here for you. You'll learn how to: * Set up your datasets in Excel and Power BI to be automated * Refresh data from files hosted on SharePoint, One Drive, and REST APIs (CSV, Excel, JSON, etc) * Pull data from on-premises and cloud data sources using the latest capabilities of Power Apps, the Power BI Service, and Azure * Automate your Power BI analysis in PowerBI.com, One Drive, or even your O365 mailbox * Work with cloud databases such as Amazon Redshift, Azure SQL DB, and Snowflake (now hosted in Azure or AWS) Speaker: Angel Abundez is VP Solutions Architecture at DesignMind
- Divide and Conquer - Relational Division with SQL
SQL expert Ami Levin will share more SQL Server insights. Your journey into advanced SQL continues... This time you'll explore relational division challenges, and the various SQL techniques in our arsenal that will conquer them. Ami will explore the theoretical aspects of relational division, but the rest of the session will be hardcore, code-only demos. Brace yourself for another wild ride down the rabbit hole of SQL! Join us if you want to understand: * Relational Division challenges * How to systemically approach solving tough challenges in SQL * The pros and cons of the various relational division solutions And be able to: * Solve relational division and similar challenges using SQL * Approach other challenging SQL tasks with a proven, easy methodology * Improve performance, readability, and scalability of your SQL queries Ami Levin is a seasoned instructor, data tier architect, data modeler, database designer, and SQL developer.
- Power BI Tricks and Tips with Live Demo
BI expert Bill Singh will show you tricks and tips you can use to build Power BI reports and dashboards efficiently. He'll discuss and show live demos exploring version control, data importing rules, report building blocks, when to use measures vs calculated columns, date tables, measure tables, etc. All the code and slides will be provided, including templates. These tips will save you a lot of time creating and managing reports, and build confidence in your users. There will be a live demo. All the materials are at this download link: https://drive.google.com/drive/folders/1O_Oi98LxJuKOj06uj1BsuXXPyiFuuTIw?usp=sharing You'll learn… * How to spend less time spent in creating and maintaining reports * Where to find readily available information for Users and Developers * How to create reports that users will use and trust * How to show users how to use the reports. * How to ensure that support time decreases * How to make reports better for your organization Speaker Bill Singh is a Principal Business System Analyst with GlobalFoundries. He is a multi-certified technology professional, including MCSE, MCITP, MCSE, MCTS, ITIL V3, and AWS Certified Architect.
- Kevin Kline - Data Science with the Microsoft Data Platform
Speaker: Kevin Kline of SQLSentry If you’re a user or administrator of Microsoft data products like SQL Server, this session will introduce you to the data science path at Microsoft. Kevin Kline, a veteran Microsoft Data Platform MVP and popular international speaker, will take you 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
- Intermediate Security Topics in SQL Server
How many times have you been told by your application developers: 1. "Just grant db_owner/sysadmin to my application and it will work"? 2. "I need to be able to issue raw DML against these tables" 3. "my login doesn't work the way it should!" 4. "this query that is accessing objects in multiple databases isn't working" In this session with Ben Thul of SurveyMonkey, you'll learn about ways to service requests without having to give away the world. We’ll start with authentication and authorization, for context. He will then go into different methods to augment the "normal" means of obtaining permissions that will allow you to help your customers while at the same time not needing to be overly permissive. In the course of this presentation, you'll learn about: * Application roles * Module signing * Permission chaining * Impersonation and more! Ben Thul is originally from Minnesota. He moved to the Bay Area in 2015 to work for SurveyMonkey. He's worked as a data professional in various industries including airline IT, mortgage servicing, finance, and marketing. In his spare time, he practices martial arts.
- Office365 MyAnalytics and Workplace Analytics - June 19, 2018
Steven DeLoye of Microsoft will demo Office365 MyAnalytics personal dashboards, Workplace Analytics, and associated Power BI reports that provide an overview of a company’s organizational health, causes of stress, and leadership impact. Office 365 boasts two analytics applications: MyAnalytics and Workplace Analytics. MyAnalytics is a personal dashboard to help users understand how they spend their working life. Workplace Analytics is a tool for organizations to understand how they function. Both MyAnalytics and Workplace Analytics draw from the same well of email and calendar data held inside Exchange Online mailboxes and recorded in the Microsoft Graph. These tools provide the time and relationship insights leaders, managers, and workers need to focus on what matters most. You will learn: * How data can inform culture transformation through variety of use cases * What type data is available today from Office 365 analytics services * How insights can help organizations drive change Steven DeLoye is a Microsoft Product Specialist for Workplace Analytics. He joined in 2016 Microsoft to help launch Power BI. Previously he worked in analytics and data warehousing at Teradata, HP, and Datallegro (now Microsoft).