Azure

A Look at Azure Synapse Studio (in Preview)

Azure Synapse, formerly SQL DW, is an analytics service that gives you the ability to query data on your terms and at scale. It brings together enterprise data warehousing and big data analytics. Azure Synapse brings together serverless on-demand or provisioned resources with a unified experience so you can ingest, prepare, manage, and serve data for immediate business intelligence and machine learning needs.

In this post I’ll show you a new Azure Synapse feature in preview called Azure Synapse Studio that I’m excited about. The Studio is a one-stop shop for working with data of any size, but particularly big data. You can ingest data, you can explore and analyze data that you already have in the workspace, as well as visualize data using Power BI.

In my video demo included in this post, I’ll walk you through the Azure Synapse Studio and show you what you can do with it. On the Home Page, you can click on the “New” button and see all you can do such as, create a new SQL script which can be executed against your SQL on-demand or another SQL Database that you have connected to your Studio’s workspace or create a Jupiter notebook which you can run in either a SQL or Spark context, along with creating dataflows, pipelines and Power BI reports.

In my demo I’ll dig into the Studio and show you how to:

  • create a notebook, ingest data, explore your data by either working in a notebook or a pipeline.
  • connect to external data like an Azure Cosmos DB or Azure Data Lake Storage Gen 2 instance.
  • create a new database with the Manage feature in which you can create a new SQL pool or an Apache Spark pool.
  • create Linked Services to connect to your Data Factory pipelines and instances to work within your databases

There are so many great things you can do with the Azure Synapse Studio and I think it will be very helpful to many people from data engineers to data scientists and business analysts, allowing them to work together in a single workspace without having to flip back and forth between various tools. I highly suggest you sign up for this preview feature and give it a try.

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

Brian CusterA Look at Azure Synapse Studio (in Preview)
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

How to Add Menus to Screens in Your Power App

Power Apps is the incredible tool by Microsoft in which citizen developers can quickly build their own custom business application. If you’re just starting out with Power Apps, I’d like to share some knowledge about adding Power Apps navigation menus in order to help you make the best use of available real estate on the screen when developing a Power App.

In my video included at the end of this post, I’ll demo using the on-demand navigation drop down menu, be sure to watch this for more a more detailed view.

  • I’ve created an app to showcase my child’s artwork and I want to separate the art by medium (clay, paint, pencil), so I’ll have multiple screens.
  • On each screen, I want to add a menu. There are 4 components on this screen that make up these menus:
    • The Hamburger Icon controls the visual properties of the other items.
    • Arrow icons act as links to the other screens.
    • Labels to indicate what the links are for.
    • The right dangle icon acts as a background and ties it all together.
  • You access these components in the Icons tab/dropdown menu at the top. I’ll begin by adding a Hamburger Icon by clicking on Hamburger Icon from the dropdown menu.
  • Once we add it and see it on our screen, we can change the properties of our Hamburger, like position and size, in the Icon menu on the right side of the screen. We can also change the color and the hover fill, so we get the highlight when we hover over the icon.
  • We can also add a rectangle icon which acts as our menu on the page and can be used to hold the links to the other pages. We may not always want this icon/menu to show and we can control that with a variable. Check out my demo for more detail on this.
  • To add the links to the other screens, we first want to click on the Label tab to add a label. The first label I want is a link to the main screen. Use the Label menu on the right side to set your properties such as text (I put main for my demo to tell this link will go back to the main page) and change the position and size. For the link for this label, I want enough room next to my text to show my arrow icon on the left. I do this with the Padding Property, I set this to the left of the text, which moves my text to the center and I now have room to add an arrow icon.
  • We need to have the text and the icon as the label will not change your mouse when you hover over it, but the icon does. The text only tells the user where they are going with the arrow.
  • We want the mouse not only to change into a pointing finger when we hover, but we want it to be highlighted, so when we’re going through our links on the menu each one will be highlighted. We do this with by using the hover fill for the arrow icon.
  • To make this link go to the main screen, we change the On Select for that arrow icon; we’ll need to change the code to navigate to the main screen. Also, when we leave that rectangle icon screen (or pencil menu), we want to tidy up by hiding that menu. We do this by updating the context of our pencil menu and changing our visible properties. (See code in my demo.)

I hope this post was helpful in learning how to add menus to multiple screens on our app, as well as how to hide and show them to maximize your real estate on your screen.

 

 

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

Jim BentonHow to Add Menus to Screens in Your Power App
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

Real-time Structured Streaming in Azure Databricks

Do you want to learn real-time Structured Streaming in Azure Databricks? In this recent webinar with Principal Consultant, Brian Steele, you’ll learn all about Structured Streaming, the main model for handling streaming datasets in Azure Databricks.

3CloudReal-time Structured Streaming in Azure Databricks
Read More

How to Connect Azure Databricks to an Azure Storage Account

In continuation with our Azure Every Day mini-series on Azure Databricks, I will be covering some key topics within Databricks such as Azure Key Vault, storage accounts, PowerPoint and DevOps. If you’re just starting out with Databricks, you may want to check out our previous posts on Databricks 101 and Getting Started with Azure Databricks. Today’s post is focused on accessing Azure Storage accounts.

Jon BloomHow to Connect Azure Databricks to an Azure Storage Account
Read More

Getting Started with Azure Databricks

As part of our ongoing series on Azure Databricks, I’ll walk you through getting started by creating your own Databricks Service and Databricks cluster. First off, it’s important to know that Databricks is not available with an Azure free subscription, you must have an Azure pay as you go account. However, there is a free 14-day premium trial available.

Leslie AndrewsGetting Started with Azure Databricks
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