3Cloud

3Cloud is a “born in the cloud” Gold-certified Microsoft Azure technology consulting firm and Azure Expert Managed Services Provider that provides cloud strategy, design, implementation, and managed services to clients across multiple industries. Founded by former Microsoft technology leaders, 3Cloud combines a team of highly experienced cloud architects and technologists with a strong network of Microsoft sales and engineering relationships to deliver the ultimate Azure experience for clients. 3Cloud is headquartered in Chicago, Illinois with offices in Dallas, Texas and Pittsburgh, Pennsylvania and supports clients throughout North America and Europe. To learn more, visit www.3cloudsolutions.com.

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

3Cloud Earns Microsoft’s Azure Advanced Specializations in Modernization of Web Applications, Windows Virtual Desktop & Windows Server and SQL Server Migration

3Cloud is proud to announce it has earned Microsoft Azure Advanced Specializations in Modernization of Web Applications, Windows Virtual Desktop and Windows Server and SQL Server Migration to Azure. By earning these advanced specializations, we are able to further differentiate ourselves and validate our deep knowledge, extensive experience, and expertise within these areas of Microsoft Azure. We are thrilled to have earned advanced specializations in the following areas to best meet the needs of our customers:

Modernization of Web Applications: Only partners that meet stringent criteria around customer success and staff skilling, as well as pass a third-party audit of their web workload deployment and management practices, including their ability to implement Azure App Service, are able to earn the Modernization of Web Applications in Microsoft Azure advanced specialization.

Windows Virtual Desktop: This is Microsoft’s newest advanced specialization. Windows Virtual Desktop has increased in demand as organizations across the globe are working remotely and many are transitioning to desktop-as-a-service to enable their employees. Partners must demonstrate extensive knowledge and experience with deploying, optimizing, and securing virtual desktop infrastructure on Azure.

Windows Server and SQL Server Migration to Microsoft Azure: This advanced specialization validates a solution partner’s experience, knowledge, and expertise in migrating Windows Server and SQL Server-based workloads to Azure. Partners must meet strict criteria around staff skilling, customer success and pass a third-party audit of their migration practices.

As companies look to modernize and take full advantage of the benefits of the cloud, they are looking for a partner with advanced skills to migrate, optimize, and manage their environments. 3Cloud continually strives to be that partner in guiding clients on their Azure adoption journey.

Jim Hughes, VP, Solution Architecture at 3Cloud stated, “As we continue our mission in helping our customers achieve The Ultimate Azure Experience, we are excited to announce that 3Cloud has been awarded the Microsoft Windows Virtual Desktop Advanced Specialization. With this award, we became the first US Microsoft Partner to achieve this goal. In addition, 3Cloud has also earned Advanced Specializations in Modernization of Web Applications and Windows Server and SQL Server Migration. I’m excited and proud of these accomplishments and to be part of an incredible team that provides our clients with top-notch guidance in their journey to Azure.”

3Cloud guides clients on their journey to the cloud by providing the Ultimate Azure Experience. Our experience, reputation for excellence, and on-going support define us as a leader in the Azure ecosystem. Please reach out if you have questions about any of our solution offerings or would like to discuss how we help your business at every stage of your Azure journey at [email protected] or call (888) 88-AZURE. Learn more about Microsoft Azure Advanced Specializations in the link below.

https://aka.ms/aaspartners

 

3Cloud3Cloud Earns Microsoft’s Azure Advanced Specializations in Modernization of Web Applications, Windows Virtual Desktop & Windows Server and SQL Server Migration
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

Microsoft Announces the General Availability of Azure Synapse Analytics and the Preview of Azure Purview

There was some exciting news from Microsoft today! At a digital conference, Satya Nadella, CEO of Microsoft, announced the general availability of Azure Synapse Analytics and the preview of Azure Purview, Microsoft’s new unified data governance service.

Why are these announcements so important? Because to thrive, businesses need to harness the power of their data.

One of the best ways to harness the power of your data is to remove data silos. While not a new concept, achieving this has been a constant challenge in the history of data and analytics, as many ecosystems continue to be complex and heterogeneous. Organizations must break down all silos to the get the most out  of data and analytics, in a consolidated, secure, and compliant manner. Azure Synapse Analytics and Azure Purview remove silos by creating a unified data analytics and governance service.

Now that we’ve given you an overview of the announcements, let’s break down the details of each Azure service.

What is Azure Synapse Analytics? Azure Synapse Analytics is a limitless analytics service that brings together traditional data warehousing and big data analytics – into one offering! Azure Synapse brings these two worlds together with a centralized experience to ingest, prepare, manage, and serve data for immediate BI and machine learning applications.

Azure Synapse Analytics Highlights

  • New cloud native distributed SQL engine
  • Deep integration with Spark
  • Flexible service query options – Serverless + Dedicated
  • Power BI + ML integration
  • Azure Synapse Link – Enables real-time data analytics with link to your operational database
  • TPC-H benchmark at PB scale
  • Native Row Level Security – This is not possible with Amazon Redshift, Google BigQuery
  • Citizen Data Scientist capabilities with direct ML integration
  • Code Management – Automation, code sync to dev/master branch, and end to end deployment lifecycle
  • Power BI integration from inside the Synapse service
  • Ability to add Power BI reports into Teams for end users

What is Azure Purview? It is critical to enable these capabilities through a comprehensive data governance solution. An organization that does not know where its data is, does not know what its future will be.  Azure Purview is a unified data governance service that helps organizations achieve a complete understanding of their data. Azure Purview empowers users to discover all data across the business, track lineage of data and create a business glossary wherever it is stored: on-premise, across clouds, in SaaS applications, or in Power BI.

Azure Purview Highlights

  • Key important and rich features: Compliance, Catalog and Data Map
  • Sourcing from on-prem, SaaS, and multi-cloud services
  • Data Map: search/browse data by tech/non-tech domain
  • Business glossary
  • No manual building of data dictionary
  • Data scanning by clicking on a button
  • Automated data classification with custom options
  • Schedule for future scanning and classification
  • Easy cloud based data search
  • Data lineage and reporting
  • Free scanning: On-premise SQL Servers, Power BI Service, data sensitivity labeling for O365 E5 customers

The combination of Azure Synapse Analytics and Azure Purview enables organizations to develop the capabilities needed to empower their teams to leverage all data for analytics and data governance, silo-free.

3CloudMicrosoft Announces the General Availability of Azure Synapse Analytics and the Preview of Azure Purview
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

3Cloud Welcomes Mark Nelson as New VP of Managed Services

We’re excited to announce Mark Nelson as our VP of Managed Services at 3Cloud! In this role, Mark will lead our Managed Services practice and drive the growth of this key division of 3Cloud’s business.

“We’re thrilled to welcome Mark as VP of Managed Services. He has stepped into a pivotal role and we’re excited to see him bring his knowledge and experience to deliver excellent experiences for our clients, and to drive the growth of our Managed Services business,” said Matt Morse, COO of 3Cloud.

Mark comes to us with a deep background in consulting and managed services. He led the creation and growth of West Monroe Partners’ award-winning Managed Services practice—which ultimately grew to more than 125 people—and shepherded that team’s spinoff into Ascend Technologies. Prior to West Monroe Partners, Mark held technology leadership roles at Arthur Andersen and BearingPoint. He spent nine months serving as interim CIO for a client in the futures trading industry, and that experience was an eye-opener to the opportunity to deliver managed IT services that mid-market firms really need. He is a lifelong resident of Illinois and attended Indiana University.

“I was impressed with the culture and strategy of 3Cloud’s leadership and the capabilities of the 3Cloud team,” Mark states. “3Cloud has a strong Managed Services foundation to support our clients as they evolve on their journey with Azure.  I look forward to building on our current Managed Services offering and continuing to expand our capabilities to meet the changing needs of our clients and to be the premier Managed Services Provider for Microsoft Azure customers.”

As the cloud is forever changing, with new updates emerging daily, companies can quickly fall behind. 3Cloud’s Managed Services practice has the tools, processes, and IP to optimize our clients’ spend and performance and ensure they stay on the leading edge. Our Managed Services team monitors and manages client’s environment to proactively mitigate problems, contain costs and get the maximum performance and availability of their systems. 3Cloud is one of only 55 Azure Expert MSPs in the world.

3Cloud3Cloud Welcomes Mark Nelson as New VP of Managed Services
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

Azure SQL Database Elasticity – Queries, Jobs, and Transactions

Do you want to learn Azure SQL Database Elasticity? In this recent webinar, 3Cloud Director of Consulting, Steve Hughes, explores the flexibility of Azure SQL Database and how it makes an even better target for solutions that could only be supported on premises.

Steve dives deep into Azure SQL Database Elasticity, covering:

  • Elastic Queries (still in preview)
    • These are similar to Polybase functionality found in SQL Server 2019 and Azure Synapse but only for use with Azure SQL Database and Azure Synapse.
    • Elastic Queries strategies like vertical partitioning, horizontal partitioning or Sharding and data virtualization.
    • Touches upon cost information.
  • Elastic Jobs
    • Provides a mechanism to support T-SQL scripts to be run across one or more databases in parallel, on demand or on a schedule.
    • Elastic Jobs can be created in the portal, with PowerShell, with REST, or SQL.
    • Elastic Job target groups (i.e. databases, servers, pools, and Shard Maps).
    • Jobs and job steps.
  • Elastic Transactions
    • Allows you to create cross database transactions in Azure SQL Database.
    • What transactions it supports and its limitations.

All these elasticity topics will also be demoed in this webinar. So, if you’d like to learn more about Azure SQL Database elasticity and how to use this flexibility in your solutions, 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].

3CloudAzure SQL Database Elasticity – Queries, Jobs, and Transactions
Read More