• Power BI and R script - a powerful combination

    Online event

    https://tinyurl.com/t7cons3 Please use this link to join the call! This meeting has been changed to be hosted online. Please do not arrive in person. Invite links to a Microsoft Teams call will be sent out to the RSVP list via Meetup around 30 mins before the scheduled time on Thursday March 26th at 5:30 PM. Please keep an eye out for the message containing your invite link during this time. On the 26th, we'll be taking a tour of the capabilities of PowerBI and R script together. We'll walk through some applications of R script for custom visuals, as a data source with powerful data prep capabilities, and some creative applications. If you have any examples of R applications you'd like to present or share, reach out to the organizers. User groups thrive when we all participate and contribute our experience with examples, ideas, and learnings. That said, if you've never used R in PowerBI, come and see what you're missing! Agenda: 5:30p - 7:30p : Presentation -News and Updates -R script and PowerBI -Member participation - Q&A and user stories or challenges If you haven't already, please take a look at the group poll to help us choose future topics and speakers that are relevant and valuable to you. If you are interested in speaking or have some other way you'd like to support our group, please reach out and let your organizers know. I hope to see you all in a few weeks. Be sure to put it on your calendar and we'll see you there!

    7
  • Mile Hi Power BI Monthly Meeting

    Brown Caldwell

    • Food/Networking - 5:30-6:00 • Intros/Recap Power BI News - 6:00-6:30 • James Leffingwell - Power BI Report Server - 6:45-7:45 Power BI report server is an on-premises solution that utilizes the SQL Server Reporting Services (SSRS) server platform to host SSRS reports and Power BI objects. With the Power BI report server (PBIRS) users can access their SSRS reports and Power BI reports using existing Windows and SQL Server licenses (SQL Enterprise Edition + Software Assurance). James will discuss a possible approach to system architecture and other ideas on how to make PBIRS work for you. Help spread the word about the group, send all of you colleagues and friends that want to know more about Power BI to MileHiPowerBI.com (http://milehipowerbi.com) and get them to sign up. Also, join the online Power BI community, by signing up for a login on http://community.powerbi.com . Once you have done that you can participate in the forums for the international Power BI community.

    2
  • Mile Hi Power BI Annual Holiday Networking Event

    Great Northern

    No speakers, just networking! We will continue the annual tradition of joining up with the Denver SQL Server UG and DAMA for a networking event with food and drink @ the Great Northern Tavern in the DTC. Please RSVP at the Eventbrite page for this event: https://holiday-party-2019.eventbrite.com/ Help spread the word about the group, send all of you colleagues and friends that want to know more about Power BI to MileHiPowerBI.com (http://milehipowerbi.com) and get them to sign up. Also, join the online Power BI community, by signing up for a login on http://community.powerbi.com . Once you have done that you can participate in the forums for the international Power BI community.

  • Mile Hi Power BI Monthly Meeting with Marco Russo

    Microsoft Denver HQ

    NOTE: Date and Location change for this meeting! • Food/Networking - 5:30-6:00 Sponsored by: LBMC Data Insights (http://lbmc.com/datainsights) • Intros/Recap Power BI News - 6:00-6:30 • DAX Filter Context in 1 hour by Marco Russo - 6:45-7:45 Understanding evaluation contexts is the key to understand DAX and to start thinking in DAX. In this session we will start from the basics of evaluation context and explain in depth the role of filter context and row context in DAX expressions, providing several examples of formulas where following the flow of contexts in the correct way is mandatory to make a sense out of the numbers computed. At the end of the session you will have a clearer idea of the importance of evaluation context and you will probably look at your DAX code in a different way. Marco Russo Marco is a business intelligence consultant and mentor. He first started working on Analysis Services in 1998, back when Analysis Services was known as OLAP Services. A veteran of end-to-end projects, Marco wrote several books with Alberto Ferrari about Power BI, Analysis Service, and Power Pivot. They also regularly write articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and Sqlbits. He also enjoys delivering evening sessions at local user groups during his trips. Help spread the word about the group, send all of you colleagues and friends that want to know more about Power BI to MileHiPowerBI.com (http://milehipowerbi.com) and get them to sign up. Also, join the online Power BI community, by signing up for a login on http://community.powerbi.com . Once you have done that you can participate in the forums for the international Power BI community.

    2
  • Mile Hi Power BI Monthly Meeting

    Brown Caldwell

    • Food/Networking - 5:30-6:00 • Intros/Recap Power BI News - 6:00-6:30 • Overview of new Power BI service UI and Wave[masked] updates- 6:45-7:45 Help spread the word about the group, send all of you colleagues and friends that want to know more about Power BI to MileHiPowerBI.com (http://milehipowerbi.com) and get them to sign up. Also, join the online Power BI community, by signing up for a login on http://community.powerbi.com . Once you have done that you can participate in the forums for the international Power BI community.

    1
  • Mile Hi Power BI Monthly Meeting

    Brown Caldwell

    • Food/Networking - 5:30-6:00 • Intros/Recap Power BI News - 6:00-6:30 • Lessons Learned from a Successful Enterprise Power BI Deployment by Steve Wake - 6:45-7:45 Power BI is an amazing tool for end-user analytics and reporting, but if you don’t architect for it correctly it may not work right as an enterprise reporting solution. Come to this session to get actual implementation details from a real deployment that was completed for a mid-sized company (1,500+ employees) and is being used daily by more than half of the employees after only a few months of being live in production. Using demos and actual documentation you will see what you need to think of for a project like this. We will be covering architecture, implementation, governance, change control, and support to get a Power BI enterprise deployment working successfully from someone that has done it! Azure Analysis Services, Power BI Pro, and Power BI Premium will be discussed and how each is being used in this solution as well. Help spread the word about the group, send all of you colleagues and friends that want to know more about Power BI to MileHiPowerBI.com (http://milehipowerbi.com) and get them to sign up. Also, join the online Power BI community, by signing up for a login on http://community.powerbi.com . Once you have done that you can participate in the forums for the international Power BI community.

    2
  • Mile Hi Power BI Monthly Meeting

    Brown Caldwell

    • Food/Networking - 5:30-6:00 • Intros/Recap Power BI News - 6:00-6:30 • Microsoft Business Applications Summit Recap - 6:45-7:45 Help spread the word about the group, send all of you colleagues and friends that want to know more about Power BI to MileHiPowerBI.com (http://milehipowerbi.com) and get them to sign up. Also, join the online Power BI community, by signing up for a login on http://community.powerbi.com . Once you have done that you can participate in the forums for the international Power BI community.

    1
  • Mile Hi Power BI Monthly Meeting

    Brown Caldwell

    • Food/Networking - 5:30-6:00 • Intros/Recap Power BI News - 6:00-6:45 • Power BI Report Design for the Non-Artist by Meagan Longoria - 6:45-7:45 You don't have to be super artistic to make professional looking Power BI reports. In this session, you'll learn a healthier way to approach data visualization and report design. We'll discuss the basics of what is important in your report design, identify which design attributes are measurable or observable to appeal to our data-driven side, and run through an example of improving a report with a few small changes. You'll learn practical steps to enhance your reports that you can do today, even if you don't consider yourself artistic. Meagan Longoria is a business intelligence consultant with Denny Cherry & Associates who lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings as well as through her blog (http://DataSavvy.me ). Help spread the word about the group, send all of you colleagues and friends that want to know more about Power BI to MileHiPowerBI.com (http://milehipowerbi.com) and get them to sign up. Also, join the online Power BI community, by signing up for a login on http://community.powerbi.com . Once you have done that you can participate in the forums for the international Power BI community.

    1
  • Mile Hi Power BI Monthly Meeting

    Brown Caldwell

    • Food/Networking - 5:30-6:00 • Intros/Recap Power BI News - 6:00-6:30 • Translating your Excel Skills to Power BI by Marc Beacom - 6:45-7:45 The corporate world has depended on Excel to massage and built reports for years. With the accelerated growth of Power BI, professionals are now looking to expand upon their knowledge of Microsoft Excel and enable themselves to start building interactive visuals. Power BI is a business intelligence tool developed by Microsoft designed for business users who are already familiar with Excel. It’s specifically designed to create interactive dashboards and reports using data from a variety of sources to be published and shared across organizations. Benefits of Power BI over Excel: Easily share visualizations with your department or organization team members Mobile friendly visualizations Improved visualizations Accelerated development cycle with monthly updates Combine and work with data in multiple sources or workbooks Presenter: Marc Beacom Bio: Marc Beacom, Managing Partner at Datalere, leverages over two decades of experience to better the data landscape for clients, along with nearly a decade of building and managing productive teams. Marc has led architecture and developed data integration strategies for dozens of Colorado-based companies and organizations. Marc maintains an active presence in the Colorado community by volunteering and serving on nonprofit boards, speaking and running user groups. Help spread the word about the group, send all of you colleagues and friends that want to know more about Power BI to MileHiPowerBI.com (http://milehipowerbi.com) and get them to sign up. Also, join the online Power BI community, by signing up for a login on http://community.powerbi.com . Once you have done that you can participate in the forums for the international Power BI community.

    1