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

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

Azure Synapse 101

 

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].

3CloudAzure Synapse 101
Read More

How to Propel Your Business Forward with Data

Do you want to learn how to propel your business forward with data-driven strategies? This recent webinar, presented by Sr. Director of Consulting at 3Cloud, Jeff Burns, explores some data-driven strategies to challenge your personal and organizational ideas to help excel your business.

Data-driven innovation brings together the art and science of what we do. The main goal of this webinar is for you to walk away with some concrete strategies and ideas of how to add innovation into your organization and even in your life.

If you’ve had great ideas in the past but it seems there are always barricades with feedback like – we’ve already tried that or that won’t work – this presentation talks through some strategies to get around those barricades. The steps that are covered through stories and shared processes that work are:

  • Defining the challenge – How to become a data-driven community and culture.
  • Innovation’s barricades – What are the barricades to innovation?
  • Exploring the process – The basics of the process and how data plays a role in it.
  • Evaluating the process – How can you tell if all this innovation is worth it?
  • A case study – A powerful success story.

Through these steps you’ll learn how you can take data and apply it to the different phases to move towards being a data-driven organization.

So, if you’re looking to learn strategies and processes to move your business (and your life) forward with data-driven strategies, this webinar is for you. Watch the complete webinar below.

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].

3CloudHow to Propel Your Business Forward with Data
Read More

Consulting, Communicating and COVID-19

Has your company been impacted by the COVID-19 pandemic? In a recent webinar, hosted by Pragmatic Works’ Lead Consultant Kathy Vick, you’ll learn some tips and tricks for making your remote workforce successful.

3CloudConsulting, Communicating and COVID-19
Read More

Creating Your First Notebook in Azure Databricks

Do you want to learn how to create a notebook in Azure Databricks? In this recent webinar with Steve Hughes, Director of Consulting, you will learn how to create your first notebook using Azure Databricks.

If you’re unaware, Databricks is a fast, easy, and collaborative analytics platform which is based on Apache Spark. This webinar will give you a beginner level overview of Databricks in Azure, which can be key in accelerating innovation by unifying data science, engineering, and business.

The primary focus of this presentation is on creating a simple notebook, moving data, and doing some data manipulation and visualization. This is a key part of the ecosystem of Azure Databricks. At Pragmatic Works, we’ve used Databricks in many projects for ETL transformations and machine learning scenarios, as well as streaming. This is a huge tool of choice for us because of the flexibility and capability Databricks gives us with scalability and management of data requests and requirements.

This demo-heavy webinar will cover:

  • Adding Azure Databricks to your subscription
  • Review the workspace
  • Set up the cluster
  • Manipulating data
  • Create visualizations

So, if you’re just starting out or interested in Azure Databricks and want to learn how to create your first notebook, this webinar is for you. You can watch the complete webinar below.

 

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].

 

3CloudCreating Your First Notebook in Azure Databricks
Read More