Free Training

Tabular Modeling & Calculation Techniques Beyond the Basics in Power BI

Do you want to learn how to address real-world issues with Power BI and DAX? In a recent webinar, Principal Consultant, Paul Turley, teaches you what you need to know. Paul covers many-to-many relationships, using disconnected tables and takes a look at using composite models.

This presentation takes a deep dive into Tabular modeling and calculation and includes demos. Paul’s agenda covers:

  • Dimensional modeling basics (just a quick run through as this is a more advanced presentation)
  • Filter propagation in Tabular models
  • Effects of single and bi-directional relationships as you are creating relationships in your data model
  • A look at scenarios where data model relationships can or cannot be used to achieve requirements or may or may not solve business problems
  • Dynamic measures built on a dimensional data model
  • A demo on DirectQuery in a Gen 1 composite model with Import mode
  • A first look at new Gen 2 DirectQuery using Power BI datasets which is the next generation of composite model capabilities which is now in public preview

All these topics and demos are based on a business requirement or business problem context, so the presenter will set up a business problem and work through how it can be solved with dimensional modeling.

So, if you’re looking to learn about using Power BI and DAX to address real-world business issues, then this webinar is for you. You can watch the complete webinar below.

Be sure to join us each week for our free webinars that happen every Tuesday at 11 AM ET. Our webinars cover a wide range of Azure topics and are presented by industry experts. Check out what webinars are coming up on our events calendar.

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

3CloudTabular Modeling & Calculation Techniques Beyond the Basics in Power BI
Read More

Introduction to Azure Automation

Do you want to learn how to automate administrative tasks in your Azure environment? In a recent webinar, we discussed how to automate various processes in Azure using PowerShell, Runbooks, and Automation Modules. When you know these techniques, you’ll be able to do things such as automate the starting and stopping of services, even processing Analysis Services Models!

This demo-heavy presentation will explain and help you understand Azure Automation and Runbooks. It will show you how to create a PowerShell Runbook and discuss options to setup a Runbook. The demo will take you through the steps, including testing and publishing a sample Runbook code and how to run a Runbook job.

So, grab 40 minutes and watch this demo if you want to learn about how to integrate automation within your Azure environment, so you can save time on those routine, administrative tasks and focus on more important things. You can watch the complete webinar below.

Our free webinars happen every Tuesday at 11 am EST and cover a variety of Azure topics that are presented by industry experts and consultants. Be sure to check out our monthly calendar for upcoming webinars.

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

3CloudIntroduction to Azure Automation
Read More

Azure Trends: Looking Ahead to 2021

2020 has been many things. We’ve seen massive change and resiliency in our interactions with clients and each other. Working remotely for most organizations has changed the way we think about running our business and what we need to do for the future.
In a recent webinar, our delivery leaders discussed the lessons learned from 2020 and looked forward to 2021 to share what they’re looking for in the new year. From DevOps to modernizing applications to data, all the key areas of technology are discussed. Check out this webinar for an engaging, round robin-style conversation on the technical challenges and opportunities you and your team can expect as we say farewell to 2020.
You can watch the complete webinar below.


3Cloud is committed to bringing you the most up-to-date topics covering all areas of Azure, data, and the cloud in our free weekly webinars. We are filling our calendar with hot topics delivered by industry experts in 2021. Follow us on social media to stay up to date and keep checking our event calendar on our website.

Our free webinars happen every Tuesday at 11 a.m. ET. We look forward to you joining us each week in 2021!

3CloudAzure Trends: Looking Ahead to 2021
Read More

Getting Started with Custom Power BI Report Themes

Do you want to learn how to create visual consistency across your reports and eliminate the monotonous task of setting common visual properties? Power BI report themes are more than just a color palette for your reports. With report themes, you can apply design changes to your entire report. All the visuals in your report will use the colors and formatting of the theme you’ve selected as a default. You can make design changes like using corporate colors, changing icon sets or applying new default visual formatting.

In a recent webinar, 3Cloud Senior Consultant, Jeremy Black, takes you on a deep dive into Power BI report themes. Jeremy covers the two types of report themes: built-in and custom. With custom themes you can customize via Power BI Desktop and/or by manually manipulating the JSON theme file used by Power BI Desktop. He’ll also cover the benefits of creating custom report themes, as well as their limitations.

Lastly, the presentation will delve into the Power BI report theme building blocks including data and structural colors, text, and visual styles. Most of this webinar is spent on demos of examples of how to begin customizing your report themes.

You can watch the complete webinar below.


So, if you’re looking to create visual consistency in your reports without spending tons of time setting common visual properties for your reports, this webinar is for you. Join us for our free weekly webinars covering a variety of Azure topics every Tuesday at 11 a.m. ET. Check out our events calendar for upcoming topics.

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

3CloudGetting Started with Custom Power BI Report Themes
Read More

Introduction to Azure Synapse Analytics

Do you want to learn how to bring together enterprise data warehousing and big data analytics? In a recent webinar, 3Cloud consultant Mike Donnelly, explores the components included with an Azure Synapse Workspace. This presentation goes through all the various pieces of Synapse, what it is and what it can do, as well as why people will be using this more and more as people build modern data warehouse.
When you search Azure Synapse Analytics, you’ll see there is Azure Synapse Analytics (formerly known as Azure SQL DW) which has been around for a bit as a data warehouse solution. But you will also find Azure Synapse Analytics Workspaces Preview. This preview resource is the focus today and many of the pieces it includes will be covered (and demoed), including:
• SQL Pools (formerly known as SQL Data Warehouse)
• Built-in SQL Pool (aka SQL On-Demand/Serverless)
• Azure Data Lake Storage (Gen2)
• Spark Compute Pools (not Azure Databricks)
• Integrate (Azure Data Factory)
If you’re interested in learning more about Azure Synapse Analytics and why it will become the tool of choice for building modern data warehouse, this webinar is for you. Watch the complete webinar below.

Be sure to watch for our free weekly webinars that happen every Tuesday at 11 AM EST. Check out our events calendar on our website https://www.3cloudsolutions.com/resources/events-calendar/

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

3CloudIntroduction to Azure Synapse Analytics
Read More

Understanding Pandemic Related Trends with COVID-19 Statistics and Power BI

Do you want to learn how to pandemic proof your business not only for the rest of the pandemic but for future disasters? If so, check out this recent webinar presented by Senior Consultant, Robin Abramson.

In this presentation, she’ll connect Power BI to COVID-19 statistics from Johns Hopkins and tie it into a generated dataset. She will also review how the two datasets can be combined to better see how the trends affect – or don’t affect – each other.

In this demo-heavy presentation, you’ll learn how to get the COVID data and the files, plus get links to access the data used in the presentation. Robin also shares how she, and fellow consultant, Paul Turley created their COVID-19 Power BI report after a client asked them to create reports to help them understand the impact of COVID to their business in the early days of the pandemic. Best practices for security and performance will be discussed.

The demo provides information and files to use as a starting point and are meant to display the techniques of how to use this report to pandemic proof your business. The goal here is to use this starting point to discuss the questions your business is looking to answer with your corporate business analysts and managers.

If you’d like to learn about using this Power BI report and up to date COVID-19 data to discover ways to pandemic proof your business now and for future disasters, this webinar is for you. You can watch the complete webinar below.

Be sure to join us each week for our free webinars that happen every Tuesday at 11 AM ET. Our webinars cover a wide range of Azure topics and are presented by industry experts. Check out what webinars are coming up on our events calendar.

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

 

3CloudUnderstanding Pandemic Related Trends with COVID-19 Statistics and Power BI
Read More

Spatial Data Mapping in Power BI

Do you want to learn Spatial Data Mapping in Power BI? In a recent webinar, Sr. BI Consultant, Chris Silvernail, looks at the traditional Map, Shape Map and Filled Map Visuals. The second half of the presentation focuses on the new Azure Maps visual including a demonstration leveraging a Custom Tile Layer.

Chris covers the 4 main map types that are built into Power BI; Bing Maps (both Maps and Filled Maps), the Shape Map and the newly introduced Azure Map which are both still in preview. All the maps shown are available in the free version of Power BI.

This demo-heavy webinar will show you how to use each of these maps, as well as what each is best for. Here’s a quick run-down:

  • Bing Map – visuals displayed using Bubble and Heat Maps. Use case: Displaying exact location on a map or displaying two separate measures simultaneously using size and color gradient of bubble.
  • Bing Map (Filled Map) – using color/gradient to display aggregate values within regional boundaries and predefined boundaries. Use case: showing how values differs in proportion to other geographies or regions. Birthrate, Crime Rate, Population, etc.
  • Shape Map – Similar to Filled Map, except there are no Bing Layers (satellite, road, etc.). You can provide your own topoJSON maps, as well as custom region/geographies. Also support no geo maps (venue seating, parking lot, etc.). Use case: Use instead of the Filled Map when you need to specify your own geography regions or non-geo map (venue seating, etc.).
  • Azure Maps – This new release is a collection of geospatial services and SDKs that use fresh mapping data to provide geographic context to web and mobile applications. The Power BI Map Visual leverages Azure Maps. These maps have 5 Layers: bubble layer, 3D bar chart layer, 2 measures (color and height), reference layer, custom tile layer and real-time traffic layer.

So, if you’re interested in learning more about Spatial Data Mapping in Power BI, this webinar is for you! You can watch the complete webinar below.

Be sure to join us each week for our free webinars that happen every Tuesday at 11 AM ET. Our webinars cover a wide range of Azure topics and are presented by industry experts. Check out what webinars are coming up on our events calendar.

Need further help with Power BI or any Azure in general? Our expert team and solution offerings can help your business with Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

3CloudSpatial Data Mapping in Power BI
Read More