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.

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

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.

 

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

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.

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

3CloudData Mapping in Power BI
Read More

3Cloud Helps a School District in Georgia Improve Graduation Rate and Student Success with Power BI and Azure

3Cloud, formerly Pragmatic Works Consulting, was able to help a large school district in Georgia use Power BI to easily and effectively pinpoint struggling students in order to get the help they need to graduate, while saving the district over $300,000 in staff resources and time.

3Cloud3Cloud Helps a School District in Georgia Improve Graduation Rate and Student Success with Power BI and Azure
Read More